c#执行事务函数代码

///<summary>
///执行多条sql语句，实现事务
///</summary>
///<paramname="arraySql">多条sql语句</param>
publicintExecutrSqlTran(System.Collections.ArrayListarraySql)
{
intitemnum;
DbOpen();
SqlCommandcm=newSqlCommand();
cm.Connection=scn;
SqlTransactiontx=scn.BeginTransaction();
cm.Transaction=tx;
try
{
for(inti=0;i<arraySql.Count;i++)
{
stringstrSql=arraySql[i].ToString();
if(strSql.Trim().Length>1)
{
cm.CommandText=strSql;
cm.ExecuteNonQuery();
}
}
tx.Commit();
itemnum=1;
}
catch(SqlExceptionE)
{
tx.Rollback();
itemnum=0;
thrownewException(E.Message);
}
DbClose();
returnitemnum;
}
}