c# 执行事务函数代码，， 执行多条sql语句，实现事务

/// <summary> 
/// 执行多条sql语句，实现事务 
/// </summary> 
/// <param name="arraySql">多条sql语句</param> 
public int ExecutrSqlTran(System.Collections.ArrayList arraySql) 
{ 
int itemnum; 
DbOpen(); 
SqlCommand cm = new SqlCommand(); 
cm.Connection = scn; 
SqlTransaction tx = scn.BeginTransaction(); 
cm.Transaction = tx; 
try 
{ 
for (int i = 0; i < arraySql.Count; i++) 
{ 
string strSql = arraySql[i].ToString(); 
if (strSql.Trim().Length > 1) 
{ 
cm.CommandText = strSql; 
cm.ExecuteNonQuery(); 
} 
} 
tx.Commit(); 
itemnum = 1; 
} 
catch (SqlException E) 
{ 
tx.Rollback(); 
itemnum = 0; 
throw new Exception(E.Message); 
} 
DbClose(); 
return itemnum; 
} 
}