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