public HttpResponseBase SaveNoteAdmin()
{
string json = string.Empty;
OrderShowMasterQuery query = new OrderShowMasterQuery();
try
{
if (!string.IsNullOrEmpty(Request.Params["order_id"]))
{
query.order_id = Convert.ToUInt32(Request.Params["order_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["note_admin"]))
{
query.note_admin = Request.Params["note_admin"];
}
_orderMasterMgr = new OrderMasterMgr(mySqlConnectionString);
_orderMasterMgr.SaveNoteAdmin(query);
json = "{success:true}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase SaveNoteOrder()
{
string json = string.Empty;
OrderShowMasterQuery query = new OrderShowMasterQuery();
try
{
if (!string.IsNullOrEmpty(Request.Params["order_id"]))
{
query.order_id = Convert.ToUInt32(Request.Params["order_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["note_order"]))
{
query.note_order = Request.Params["note_order"];
}
query.user_id = query.user_id = uint.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
query.NoteOrderModifyTime = DateTime.Now;
_orderMasterMgr = new OrderMasterMgr(mySqlConnectionString);
_orderMasterMgr.SaveNoteOrder(query);
json = "{success:true}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase SaveStatus()
{
string json = string.Empty;
OrderShowMasterQuery query = new OrderShowMasterQuery();
try
{
if (!string.IsNullOrEmpty(Request.Params["order_id"]))
{
query.order_id = Convert.ToUInt32(Request.Params["order_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["order_status"]))
{
query.order_status = Convert.ToUInt32(Request.Params["order_status"]);
}
if (!string.IsNullOrEmpty(Request.Params["user_username"]))
{
query.manager_name = Request.Params["user_username"];
}
if (!string.IsNullOrEmpty(Request.Params["status_description"]))
{//query.manager_name
query.status_description = (Session["caller"] as Caller).user_username+ ":" + Request.Params["status_description"];
}
System.Net.IPAddress[] addlist = Dns.GetHostByName(Dns.GetHostName()).AddressList;
if (addlist.Length > 0)
{
query.status_ipfrom = addlist[0].ToString();
}
query.StatusCreateDate = DateTime.Now;
_orderMasterMgr = new OrderMasterMgr(mySqlConnectionString);
_orderMasterMgr.SaveStatus(query);
json = "{success:true}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public string InsertOrderMasterStatus(OrderShowMasterQuery store)
{
StringBuilder sql = new StringBuilder();
try
{
sql.Append("insert into order_master_status (serial_id,order_id,order_status,");
sql.Append("status_description,status_ipfrom,status_createdate) ");
sql.AppendFormat("values({0},{1},{2},", store.serial_id, store.order_id, store.order_status);
sql.AppendFormat("'{0}','{1}',{2});", store.status_description, store.status_ipfrom, CommonFunction.GetPHPTime(store.StatusCreateDate.ToString()));
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("OrderMasterDao-->InsertOrderMasterStatus-->" + sql.ToString() + ex.Message, ex);
}
}
public HttpResponseBase GetData()
{
uint orderId =0;
if(uint.TryParse(Request.Params["order_id"],out orderId))
{
orderId = orderId;
}
OrderMasterQuery omQuery=new OrderMasterQuery ();
OrderShowMasterQuery query = new OrderShowMasterQuery();
string json = string.Empty;
OrderShowMasterQuery store = new OrderShowMasterQuery();
_orderMasterMgr = new OrderMasterMgr(mySqlConnectionString);
zMgr = new ZipMgr(mySqlConnectionString);
try
{
store = _orderMasterMgr.GetData(orderId);
uint user_id =(uint)(Session["caller"] as Caller).user_id;
if (_orderMasterMgr.VerifySession(user_id) > 0)
{
store.is_manage_user = true;
}
else
{
store.is_manage_user = false;
}
if (!string.IsNullOrEmpty(Request.Params["isSecret"]))
{
if (Request.Params["isSecret"] == "false")
{
store.isSecret = false;
}
else
{
store.isSecret = true;
}
}
omQuery.Order_Id=orderId;
store.is_send_product = _orderMasterMgr.IsSendProduct(omQuery);//true可以變更 false不可變更。
store.is_vendor_deliver = _orderMasterMgr.IsVendorDeliver(orderId);
store.OrderDatePay = CommonFunction.GetNetTime(store.order_date_pay);
if (!string.IsNullOrEmpty(store.money_collect_date.ToString()) && store.money_collect_date != 0)
{
store.MoneyCollectDate = CommonFunction.GetNetTime(store.money_collect_date);
}
store.NoteOrderModifyTime = CommonFunction.GetNetTime(store.note_order_modify_time);
store.OrderCreateDate = CommonFunction.GetNetTime(store.order_createdate);
store.OrderDateClose = CommonFunction.GetNetTime(store.order_date_close);
double value = Convert.ToDouble(store.deduct_happygo * store.deduct_happygo_convert);
store.Hg_Nt = Math.Round(value).ToString();
//地址直接讀取
store.order_address = zMgr.Getaddress(int.Parse(store.order_zip.ToString())) + store.order_address;
store.delivery_address = zMgr.Getaddress(int.Parse(store.delivery_zip.ToString())) + store.delivery_address;
if (store.isSecret)
{
#region 添加資安的字段
if (store.order_name.Length > 1)
{
store.order_name = store.order_name.ToString().Substring(0, 1) + "**";
}
else
{
store.order_name = store.order_name.ToString() + "**";
}
//if (store.order_mobile.Length > 1)
//{
// store.order_mobile = store.order_mobile.ToString().Substring(0, 1) + "****";
//}
//else
//{
// store.order_mobile = store.order_mobile.ToString() + "**";
//}
if (!string.IsNullOrEmpty(store.order_mobile))
{
if (!CommonFunction.isMobile(store.order_mobile))
{
if (store.order_mobile.ToString().Length == 48)
{
store.order_mobile = EncryptComputer.EncryptDecryptTextByApi(store.order_mobile, false);
if (!CommonFunction.isMobile(store.order_mobile))
{
//異常記錄
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.order_mobile, "訂購人行動電話解密后不滿足正則表達式");
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
}
else
{
//異常記錄
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.order_mobile, "訂購人行動電話錯誤");
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
}
if (store.order_mobile.ToString().Length > 3)
{
store.order_mobile = store.order_mobile.Substring(0, 3) + "***";
}
else
{
store.order_mobile = store.order_mobile + "***";
}
}
if (store.order_address.Length > 3)
{
store.order_address = store.order_address.ToString().Substring(0, 3) + "****";
}
else
{
store.order_address = store.order_address.ToString() + "**";
}
if (store.delivery_name.Length > 1)
{
store.delivery_name = store.delivery_name.ToString().Substring(0, 1) + "**";
}
else
{
store.delivery_name = store.delivery_name.ToString() + "**";
}
//if (store.delivery_mobile.Length > 1)
//{
// store.delivery_mobile = store.delivery_mobile.ToString().Substring(0, 1) + "****";
//}
//else
//{
// store.delivery_mobile = store.delivery_mobile.ToString() + "**";
//}
if (!string.IsNullOrEmpty(store.delivery_mobile))
{
if (!CommonFunction.isMobile(store.delivery_mobile))
{
if (store.delivery_mobile.ToString().Length == 48)
{
store.delivery_mobile = EncryptComputer.EncryptDecryptTextByApi(store.delivery_mobile, false);
if (!CommonFunction.isMobile(store.delivery_mobile))
{
//異常記錄
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.delivery_mobile, "收貨人行動電話解密后不滿足正則表達式");
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
}
else
{
//異常記錄
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.delivery_mobile, "收貨人行動電話錯誤");
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
}
if (store.delivery_mobile.ToString().Length > 3)
{
store.delivery_mobile = store.delivery_mobile.Substring(0, 3) + "***";
}
else
{
store.delivery_mobile = store.delivery_mobile + "***";
}
}
if (store.delivery_address.Length > 3)
{
store.delivery_address = store.delivery_address.ToString().Substring(0, 3) + "****";
}
else
{
store.delivery_address = store.delivery_address.ToString() + "**";
}
#endregion
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public int SaveNoteAdmin(OrderShowMasterQuery store)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("update order_master set note_admin='{0}' where order_id={1};", store.note_admin, store.order_id);
return _dbAccess.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("OrderMasterDao-->SaveNoteAdmin-->" + sql.ToString() + ex.Message, ex);
}
}
public int SaveStatus(OrderShowMasterQuery store)
{
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
int re = 0;
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
store.serial_id = GetSerialValue(29); //得到serial_value,是order_master_status的id
mySqlConn.Open();
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
mySqlCmd.CommandText = UpdateSerialVal(store.serial_id, 29);
mySqlCmd.CommandText += InsertOrderMasterStatus(store);
re = mySqlCmd.ExecuteNonQuery();
mySqlCmd.Transaction.Commit();
}
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("OrderShowBaseInfoDao-->SaveStatus-->" + mySqlCmd.ToString() + ex.Message, ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return re;
}
public string UpdateOrderMaster(OrderMasterQuery query, OrderShowMasterQuery osmQuery)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("update order_master set delivery_store='{0}' ", query.Delivery_Store);
if (query.payment == "T_CAT")
{
sql.AppendFormat(" ,order_freight_normal='{0}',order_freight_low='{1}',order_payment='{2}',order_date_pay='{3}' ", query.Order_Freight_Normal, query.Order_Freight_Low, query.Order_Payment, CommonFunction.GetPHPTime());
if (query.t_cat_amount != 0)
{
sql.AppendFormat(",order_amount='{0}' ", query.Order_Amount);
}
}
else if (osmQuery.order_status == 0)
{
sql.AppendFormat(" ,order_freight_normal='{0}',order_freight_low='{1}',order_amount='{2}',order_payment='{3}',order_date_pay='{4}' ", query.Order_Freight_Normal, query.Order_Freight_Low, query.Order_Amount, query.Order_Payment, CommonFunction.GetPHPTime());
}
sql.AppendFormat(" where order_id='{0}';", query.Order_Id);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("OrderMasterDao-->UpDeliveryStore-->" + sql.ToString() + ex.Message, ex);
}
}
public int SaveNoteOrder(OrderShowMasterQuery store)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("update order_master set note_order='{0}',note_order_modifier={1},note_order_modify_time={2} where order_id={3}", store.note_order, store.user_id, CommonFunction.GetPHPTime(store.NoteOrderModifyTime.ToString()), store.order_id);
return _dbAccess.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("OrderMasterDao-->SaveNoteOrder-->" + sql.ToString() + ex.Message, ex);
}
}
public string ModifyDeliveryData(OrderMasterQuery om)
{
string json = string.Empty;
ArrayList arrList = new ArrayList();
OrderShowMasterQuery oms = new OrderShowMasterQuery();
OrderShowMasterQuery newOms = new OrderShowMasterQuery();
try
{
if (IsSendProduct(om))//true可以變更 false不可變更。
{
json= ChangeDeliverData(oms, newOms, om);
}
else
{
json = "{success:true,msg:'1'}";
}
return json;
}
catch (Exception ex)
{
throw new Exception("OrderMasterMgr-->ModifyDeliveryData-->" + ex.Message, ex);
}
}
public string ChangePayMent(OrderMasterQuery query)
{
string json = string.Empty;
ArrayList arrList = new ArrayList();
OrderMasterStatusQuery omsQuery = new OrderMasterStatusQuery();
OrderShowMasterQuery osmQuery = new OrderShowMasterQuery();
osmQuery = _orderMasterDao.GetData(query.Order_Id);
try
{
if (query.payment == "T_CAT")
{
query.Order_Payment = 8;
query.Order_Date_Pay = (uint)CommonFunction.GetPHPTime();
query.status_description = query.username + "轉黑貓貨到付款";
query.Delivery_Store = (uint)query.delivery;
#region modify_order_status
arrList.Add(_orderMasterDao.ModifyOrderStatus(query));
omsQuery.serial_id = Convert.ToUInt64(_orderMasterDao.GetNextSerial(new Serial { Serial_id = 29 }).Rows[0][0]);
omsQuery.order_id = query.Order_Id;
omsQuery.status_description = query.status_description;
omsQuery.order_status = 2;
omsQuery.status_ipfrom = query.Order_Ipfrom;
query.user_id = osmQuery.user_id;
arrList.Add(_orderMasterDao.OMSRecord(omsQuery));
DataTable _dt = _orderMasterDao.IsFirstTime(query);
if (_dt != null && _dt.Rows.Count > 0)
{
arrList.Add(_orderMasterDao.UpFirstTime(query));
}
#endregion
//加30運費
if (osmQuery.order_freight_normal != 0)
{
query.Order_Freight_Normal = osmQuery.order_freight_normal += 30;
query.t_cat_amount += 30;
}
if (osmQuery.order_freight_low != 0)
{
query.Order_Freight_Low = osmQuery.order_freight_low += 30;
query.t_cat_amount += 30;
}
if (query.t_cat_amount != 0)
{
query.Order_Amount = osmQuery.order_amount += query.t_cat_amount;
}
}
if (query.delivery == 12)
{
if (osmQuery.order_status == 0)
{
query.Order_Amount = osmQuery.order_amount - (osmQuery.order_freight_normal + osmQuery.order_freight_low);
query.Order_Freight_Normal = 0;
query.Order_Freight_Low = 0;
query.Order_Payment = 9;
query.Order_Date_Pay = (uint)CommonFunction.GetPHPTime();
query.status_description = query.username + "轉自取，現金";
#region modify_order_status
arrList.Add(_orderMasterDao.ModifyOrderStatus(query));
omsQuery.serial_id = Convert.ToUInt64(_orderMasterDao.GetNextSerial(new Serial { Serial_id = 29 }).Rows[0][0]);
omsQuery.order_id = query.Order_Id;
omsQuery.status_description = query.status_description;
omsQuery.order_status = 2;
omsQuery.status_ipfrom = query.Order_Ipfrom;
arrList.Add(_orderMasterDao.OMSRecord(omsQuery));
query.user_id = osmQuery.user_id;
DataTable _dt = _orderMasterDao.IsFirstTime(query);
if (_dt != null && _dt.Rows.Count > 0)
{
arrList.Add(_orderMasterDao.UpFirstTime(query));
}
#endregion
int master_total = osmQuery.accumulated_bonus;
if (master_total > 0)
{
BonusMaster bm = new BonusMaster();
bm.master_start = (uint)CommonFunction.GetPHPTime();
bm.master_end = bm.master_start + (86400 * 90);
bm.master_note = query.Order_Id.ToString();
bm.master_writer = "Writer : 轉自取發放購物金";
bm.type_id = 30;
bm.master_total = (uint)master_total;
bm.master_balance = master_total;
bm.user_id = osmQuery.user_id;
bm.master_createdate = (uint)CommonFunction.GetPHPTime();
bm.master_updatedate = bm.master_createdate;
bm.master_ipfrom = query.Order_Ipfrom;
_orsDao.Bonus_Master_Add(bm);
}
}
else
{
DataTable _serDt = _orderMasterDao.GetNextSerial(new Serial { Serial_id = 29 });
omsQuery.serial_id = Convert.ToUInt64(_serDt.Rows[0][0]);
omsQuery.order_id = query.Order_Id;
omsQuery.status_description = query.username + "轉自取";
omsQuery.order_status = osmQuery.order_status;
omsQuery.status_ipfrom = query.Order_Ipfrom;
arrList.Add(_orderMasterDao.OMSRecord(omsQuery));
}
arrList.Add(_orderMasterDao.UpDeliveryMaster(query.Order_Id, query.Delivery_Store));
}
//更新order_master
arrList.Add(_orderMasterDao.UpdateOrderMaster(query, osmQuery));
if (_mysqlDao.ExcuteSqlsThrowException(arrList))
{
json = "{success:true}";
}
else
{
json = "{success:false}";
}
}
catch (Exception ex)
{
throw new Exception("OrderMasterMgr-->ChangePayMent-->" + ex.Message, ex);
}
return json;
}
public int SaveStatus(OrderShowMasterQuery store)
{
try
{
return _orderMasterDao.SaveStatus(store);
}
catch (Exception ex)
{
throw new Exception("OrderMasterMgr-->SaveStatus-->" + ex.Message, ex);
}
}
public int SaveNoteOrder(OrderShowMasterQuery store)
{
try
{
return _orderMasterDao.SaveNoteOrder(store);
}
catch (Exception ex)
{
throw new Exception("OrderMasterMgr-->VerifyData-->" + ex.Message, ex);
}
}
public string ChangeDeliverData(OrderShowMasterQuery oms, OrderShowMasterQuery newOms, OrderMasterQuery om)
{
string json = string.Empty;
ArrayList arrList = new ArrayList();
Serial serial = new Serial();
oms.status_description = "Writer:" + "(" + om.user_id + ")" + om.user_name + "," + "\r\n" + "異動收貨資訊";
oms.status_ipfrom = om.Order_Ipfrom;
oms.StatusCreateDate = DateTime.Now;
oms.order_id = om.Order_Id;
om.mdd = true;
newOms = _orderMasterDao.GetData(om.Order_Id);
string note_order = newOms.note_order;
if (note_order == "")
{
om.note_order = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "更改收件人資訊";
}
else
{
om.note_order = note_order + '/' + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "更改收件人資訊";
}
oms.order_status = newOms.order_status;
arrList.Add(_orderMasterDao.UpOrderMaster(om));//更新order_master
arrList.Add(_orderMasterDao.UpdateDM(om));//更新deliver_master
serial = _serialDao.GetSerialById(29);
oms.serial_id = Convert.ToInt32(serial.Serial_Value) + 1;
serial.Serial_Value = Convert.ToUInt64(oms.serial_id);
arrList.Add(_serialDao.UpdateAutoIncreament(serial));//更新serial表
arrList.Add(_orderMasterDao.InsertOrderMasterStatus(oms));//插入order_master_status表
if (_mysqlDao.ExcuteSqlsThrowException(arrList))
{
json = "{success:true}";
#region 發送郵件
MailHelper mail = new MailHelper();
string body = "付款單號 : " + om.Order_Id + " 已更改收貨人資訊，請重新檢視出貨單<br/>更改時間：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "<br/><br/>以上為系統通知信請勿直接回覆，謝謝！ ";
mail.SendMailAction("*****@*****.**", "收貨人資訊變更", body);
#endregion
}
else
{
json = "{success:false}";
}
return json;
}
