复制代码 代码如下:

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

}

}