/// <summary>
 /// 啟用事務(wù)提交多條帶參數(shù)的SQL語(yǔ)句
 /// </summary>
 /// <param name="mainSql">主表SQL</param>
 /// <param name="mainParam">主表對(duì)應(yīng)的參數(shù)</param>
 /// <param name="detailSql">明細(xì)表SQL語(yǔ)句</param>
 /// <param name="detailParam">明細(xì)表對(duì)應(yīng)的參數(shù)</param>
 /// <returns>返回事務(wù)是否成功</returns>
 public static bool UpdateByTran(string mainSql, SqlParameter[] mainParam, string detailSql, List<SqlParameter[]> detailParam)
 {
  SqlConnection conn = new SqlConnection(connString);
  SqlCommand cmd = new SqlCommand();
  cmd.Connection = conn;
  try
  {
   conn.Open();
   cmd.Transaction = conn.BeginTransaction();//開(kāi)啟事務(wù)
   if (mainSql != null && mainSql.Length != 0)
   {
    cmd.CommandText = mainSql;
    cmd.Parameters.AddRange(mainParam);
    cmd.ExecuteNonQuery();
   }
   foreach (SqlParameter[] param in detailParam)
   {
    cmd.CommandText = detailSql;
    cmd.Parameters.Clear();
    cmd.Parameters.AddRange(param);
    cmd.ExecuteNonQuery();
   }
   cmd.Transaction.Commit();//提交事務(wù)
   return true;
  }
  catch (Exception ex)
  {
   if (cmd.Transaction != null)
   {
    cmd.Transaction.Rollback();//回滾事務(wù)
   }
   //將異常信息寫(xiě)入日志
   string errorInfo = "調(diào)用UpdateByTran(string mainSql, SqlParameter[] mainParam,string detailSql ,List <SqlParameter []>detailParam)方法時(shí)<br data-filtered="filtered">發(fā)生錯(cuò)誤，具體信息：" + ex.Message;
   WriteLog(errorInfo);
   throw ex;
  }
  finally
  {
   if (cmd.Transaction != null)
   {
    cmd.Transaction = null;//清空事務(wù)
   }
   conn.Close();
  }
 }