复制代码 代码如下:

/// <summary>

/// 批量执行SQL语句

/// </summary>

/// <param name="Sqlstr">SQL语句数组</param>

/// <param name="param">SQL参数对象数组</param>

/// <returns></returns>

public static Int32 ExecuteSqls(String[] Sqlstr, List<SqlParameter[]> param)

{

String ConnStr = GetSqlConnection();

using (SqlConnection conn = new SqlConnection(ConnStr))

{

SqlCommand cmd = new SqlCommand();

SqlTransaction tran = null;

cmd.Transaction = tran;

try

{

conn.Open();

tran = conn.BeginTransaction();

cmd.Connection = conn;

cmd.Transaction = tran;

Int32 count = Sqlstr.Length;

for (Int32 i = 0; i < count; i++)

{

cmd.CommandText = Sqlstr[i];

cmd.Parameters.AddRange(param[i]);

cmd.ExecuteNonQuery();

}

tran.Commit();

return 1;

}

catch

{

tran.Rollback();

return 0;

}

finally

{

cmd.Dispose();

conn.Close();

}

}

}