复制代码 代码如下: /// summary /// 执行多条sql语句，实现事务 /// /summary /// param多条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; } } ，。