/// <summary> /// 記錄付款單狀態方法參考自(includes/order/order.php第391行方法) /// </summary> /// <param name="Order_Id"></param> /// <param name="Modify_Master_Order_Status"></param> /// <param name="description"></param> /// <returns></returns> public string order_master_status_record(string Order_Id, string Order_Status, string description = "") { StringBuilder sb = new StringBuilder(); StringBuilder sbt = new StringBuilder(); try { SerialDao serial = new SerialDao(connStr); Serial se = new Serial(); se = serial.GetSerialById(29);// 訂單主檔狀態流水號 //se.Serial_Value += 1; sb.AppendFormat(serial.Update(29)); // serial.Update(se); sb.Append(@"insert into order_master_status(serial_id,order_id,order_status,status_description,status_ipfrom,status_createdate)"); sb.AppendFormat(" value((select serial_value from serial where serial_id=29),'{0}','{1}' ,", Order_Id, Order_Status); sb.AppendFormat(" '{0}','{1}','{2}'); ", Description, IPAddress, uint.Parse(CommonFunction.GetPHPTime(DateTime.Now.ToString()).ToString())); return sb.ToString(); } catch (Exception ex) { throw new Exception("OrderDao.order_slave_status_record -->" + ex.Message + sb.ToString(), ex); } }
public int AnnounceSave(AnnounceQuery store) { MySqlCommand mySqlCmd = new MySqlCommand(); MySqlConnection mySqlConn = new MySqlConnection(connStr); StringBuilder sql = new StringBuilder(); int re = 0; store.Replace4MySQL(); try { if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed) { mySqlConn.Open(); } mySqlCmd.Connection = mySqlConn; mySqlCmd.Transaction = mySqlConn.BeginTransaction(); mySqlCmd.CommandType = System.Data.CommandType.Text; SerialDao _serialDao = new SerialDao(connStr); #region 新增 if (store.announce_id == 0)//新增 { Serial sQuery = new Serial(); store.announce_id = Convert.ToUInt32(_serialDao.GetSerialById(65).Serial_Value + 1); // GetSerialValue(20); mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(new Serial { Serial_id = 65, Serial_Value = store.announce_id }); mySqlCmd.CommandText += InsertAnnounce(store); re = mySqlCmd.ExecuteNonQuery(); } else//編輯 { mySqlCmd.CommandText = UpdateAnnounce(store); re = mySqlCmd.ExecuteNonQuery(); } #endregion mySqlCmd.Transaction.Commit(); } catch (Exception ex) { mySqlCmd.Transaction.Rollback(); throw new Exception("AnnounceDao-->AnnounceSave-->" + mySqlCmd.ToString() + ex.Message, ex); } finally { if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open) { mySqlConn.Close(); } } return re; }
public int SaveUserPhone(Model.Query.UserQuery uQuery) { _userhistoryDao = new UserHistoryDao(connStr); _smsdao = new SmsDao(connStr); _serialDao = new SerialDao(connStr); Serial serial = new Serial(); uQuery.Replace4MySQL(); int i = 0; MySqlCommand mySqlCmd = new MySqlCommand(); MySqlConnection mySqlConn = new MySqlConnection(connStr); try { if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed) { mySqlConn.Open(); } mySqlCmd.Connection = mySqlConn; mySqlCmd.Transaction = mySqlConn.BeginTransaction(); mySqlCmd.CommandType = System.Data.CommandType.Text; #region 處理serial表數據 mySqlCmd.CommandText = _serialDao.Update(22);//22電話會員 serial = _serialDao.GetSerialById(22); uQuery.user_id = Convert.ToUInt32(serial.Serial_Value) + 1; #endregion #region 處理user 和user_history數據 mySqlCmd.CommandText = Save(uQuery); mySqlCmd.CommandText += _userhistoryDao.Save(uQuery); #endregion #region 處理sms表 Sms smsModel = new Sms(); smsModel.type = 9; smsModel.mobile = uQuery.user_mobile; smsModel.subject = "電話會員"; smsModel.content = "感謝您選擇成為吉甲地市集電話會員,未來我們將透過簡訊提供商品優惠。日後若有電話訂購服務之需求,可撥打專線(02)2783-4995,謝謝。"; smsModel.send = uQuery.send_sms_ad == true ? 1 : 0; smsModel.created = uQuery.created; smsModel.modified = uQuery.created; smsModel.estimated_send_time = uQuery.created; mySqlCmd.CommandText += _smsdao.SaveSms(smsModel); #endregion i += mySqlCmd.ExecuteNonQuery(); //全部执行成功以后,对serial表的serial_value的值進行變更 if (i == 3) { serial.Serial_Value = serial.Serial_Value + 1; int j = _serialDao.Update(serial); } mySqlCmd.Transaction.Commit(); } catch (Exception ex) { mySqlCmd.Transaction.Rollback(); throw new Exception("UsersDao-->Save-->" + ex.Message + mySqlCmd.CommandText.ToString(), ex); } finally { if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open) { mySqlConn.Close(); } } return i; }