sqlhelper中执行事务一例
- /// <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();
- }
- }
- }