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