/// <summary>
/// 执行SQL语句并返回数据表
/// </summary>
/// <param name="Sqlstr">SQL语句</param>
/// <returns></returns>
public static DataTable ExecuteDt(String Sqlstr)
{
String ConnStr = SQLDbHelper.GetSqlConnection();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
SqlDataAdapter da = new SqlDataAdapter(Sqlstr, conn);
DataTable dt = new DataTable();
conn.Open();
da.Fill(dt);
conn.Close();
return(dt);
}
}
/// <summary>
/// 根据SQL语句,取得SqlDataReader结果
/// </summary>
/// <param name="Sqlstr">SQL语句</param>
/// <returns>SqlDataReader</returns>
public static SqlDataReader ExecuteDr(string Sqlstr)
{
String ConnStr = SQLDbHelper.GetSqlConnection();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
SqlCommand cmd = new SqlCommand(Sqlstr, conn);
//cmd.CommandText = Sqlstr;
//cmd.Connection = conn;
conn.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
conn.Close();
return(dataReader);
}
}
/// <summary>
/// 执行SQL语句并返回数据集
/// </summary>
/// <param name="Sqlstr">SQL语句</param>
/// <returns>DataSet</returns>
public static DataSet ExecuteDs(String Sqlstr)
{
String ConnStr = SQLDbHelper.GetSqlConnection();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(Sqlstr, conn);
//cmd.CommandText = Sqlstr;
//cmd.Connection = conn;
da.SelectCommand = cmd;
conn.Open();
da.Fill(ds);
conn.Close();
return(ds);
}
}
/// <summary>
/// 执行SQL语句并返回数据表
/// </summary>
/// <param name="Sqlstr">SQL语句</param>
/// <param name="param">参数对象列表</param>
/// <returns></returns>
public static DataTable ExecuteDt(String Sqlstr, SqlParameter[] param)
{
String ConnStr = SQLDbHelper.GetSqlConnection();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(Sqlstr, conn);
//cmd.CommandText = Sqlstr;
//cmd.Connection = conn;
cmd.Parameters.AddRange(param);
da.SelectCommand = cmd;
conn.Open();
da.Fill(dt);
conn.Close();
return(dt);
}
}
/// <summary>
/// 批量执行SQL语句
/// </summary>
/// <param name="Sqlstr">SQL语句数组</param>
/// <param name="param">SQL参数对象数组</param>
/// <returns></returns>
public static Boolean ExecuteSqls(String[] Sqlstr, List <SqlParameter[]> param)
{
String ConnStr = SQLDbHelper.GetSqlConnection();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
SqlCommand cmd = new SqlCommand();
SqlTransaction tran = null;
cmd.Transaction = tran;
try
{
conn.Open();
tran = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = tran;
Int32 count = Sqlstr.Length;
for (Int32 i = 0; i < count; i++)
{
cmd.CommandText = Sqlstr[i];
cmd.Parameters.AddRange(param[i]);
cmd.ExecuteNonQuery();
}
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
finally
{
cmd.Dispose();
conn.Close();
}
}
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="Sqlstr">SQL语句</param>
/// <param name="param">参数对象数组</param>
/// <returns></returns>
public static Boolean ExecuteSql(String Sqlstr, SqlParameter[] param)
{
String ConnStr = SQLDbHelper.GetSqlConnection();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = Sqlstr;
cmd.Parameters.AddRange(param);
conn.Open();
int AffectRows = cmd.ExecuteNonQuery(); //对于 UPDATE、INSERT 和 DELETE 语句，返回值为该命令所影响的行数。
conn.Close(); //对于所有其他类型的语句，返回值为 -1。如果发生回滚，返回值也为 -1。
if (AffectRows > 0 || AffectRows == -1)
{
return(true);
}
else
{
return(false);
}
}
}