#region 引用
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
#endregion
public static void ExecuteSqlNonQuery(string SQL)
{
SqlConnection sqlCnn = new SqlConnection(strCnn);
sqlCnn.Open();
try
{
StringBuilder build = new StringBuilder();
build.AppendFormat(SQL.ToString());
SqlCommand sqlCmm = new SqlCommand(build.ToString(), sqlCnn);
sqlCmm.ExecuteNonQuery();
}
catch (Exception ex)
{
// LoggerHelper.WriteLog("", "", DateTime.Now.ToString() + "数据库操作异常" + ex.Message);
}
finally
{
sqlCnn.Close();
}
}
///
///
///
///
///
public static DataTable ExecuteSqlForDT(string SQL)
{
DataSet ds = new DataSet();
using (SqlConnection sqlCnn = new SqlConnection(strCnn))
{
sqlCnn.Open();
try
{
SqlCommand sqlCmm = new SqlCommand(SQL.ToString(), sqlCnn);
sqlCmm.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(sqlCmm);
da.Fill(ds);
}
catch (Exception ex)
{
// LoggerHelper.WriteLog("", "", DateTime.Now.ToString() + "数据库操作异常"+ ex.Message);
}
finally
{
sqlCnn.Close();
}
}
return ds.Tables[0];
}
