110,571
社区成员
发帖
与我相关
我的任务
分享
private void Submit()
{
// 声明定义事务
using (TransactionScope ts = new TransactionScope())
{
try
{
// 事务方法体
Sub1();
Sub2();
// 提交事务并回滚
ts.Complete();
}
catch
{ }
}
this.GvBind();
}
private static void Sub2()
{
DbHelperSQL.ExecuteSql("INSERT INTO Items(Item) VALUES(''aa'')");
}
private static void Sub1()
{
DbHelperSQL.ExecuteSql("INSERT INTO Items(Item) VALUES(101)");
}
/// <summary>
/// 执行查询
/// </summary>
/// <param name="Querys">T-SQL语句的List泛型集合 T是string </param>
/// <returns>返回影响行数</returns>
public static int ExecuteNonQuery(List<string> Querys)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
con.Open();
SqlTransaction sqlTran = con.BeginTransaction();
try
{
com.Transaction = sqlTran;
int row = 0; ;
foreach (string str in Querys)
{
if (str.Length > 1)
{
com.CommandText = str;
row += com.ExecuteNonQuery();
}
}
sqlTran.Commit();
con.Close();
com.Clone();
con.Dispose();
com.Dispose();
return row;
}
catch (SqlException e)
{
sqlTran.Rollback();
throw new Exception(e.Message);
}
}
}
}