工具类
public class TransactionHelper
{
private SqlConnection connection;
private SqlTransaction myTrans;
SqlCommand myCommand;
public string connString = "服务器名;Initial Catalog = 数据库名;User ID = 用户名;Pwd = 密码(没有密码可以省略)";
public TransactionHelper()
{
connection = new SqlConnection(connString);
connection.Open();
myTrans = connection.BeginTransaction();
myCommand = new SqlCommand();
myCommand.Connection = connection;
myCommand.Transaction = myTrans;
Console.WriteLine("Transaction Init");
}
public int Update(string sql)
{
try
{
myCommand.CommandText = sql;
int a = myCommand.ExecuteNonQuery();
Console.WriteLine("Transaction Update:" + sql);
return a;
}
catch (Exception ex)
{
myTrans.Rollback();
connection.Close();
Console.WriteLine(ex.ToString());
return -1;
}
}
public Boolean Commit()
{
try
{
myTrans.Commit();
Console.WriteLine("Transaction Commit");
return true;
}
catch (Exception ex)
{
myTrans.Rollback();
Console.WriteLine(ex.ToString());
return false;
}
finally
{
connection.Close();
}
}
public void Rollback()
{
if (connection.State != System.Data.ConnectionState.Closed)
{
myTrans.Rollback();
Console.WriteLine("Transaction Rollback");
connection.Close();
}
}
}
测试类
public class Class1
{
TransactionHelper transactionHelper=new TransactionHelper();
public bool test()
{
if (transactionHelper.Update("sql1") <= 0)
{
transactionHelper.Rollback();
return false;
}
if (transactionHelper.Update("sql2") <= 0)
{
transactionHelper.Rollback();
return false;
}
if (otherfunction())
{
transactionHelper.Rollback();
return false;
}
transactionHelper.Commit();
return true;
}
}