/// <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; } }