public DataTable CheckOrderId(OrderReturnStatusQuery query) { try { return _orderReturnStatus.CheckOrderId(query); } catch (Exception ex) { throw new Exception("OrderReturnStatusMgr-->CheckOrderId-->" + ex.Message, ex); } }
public DataTable CheckTransport(OrderReturnStatusQuery query) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); sql.AppendFormat("select orc.orc_deliver_code from order_return_content orc where orc.orc_order_id='{0}' and return_id='{1}' ; ", query.orc_order_id,query.return_id); DataTable _dt = _access.getDataTable(sql.ToString()); return _dt; } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->CheckTransport-->" + ex.Message + sql.ToString(), ex); } }
public DataTable CheckOrderId(OrderReturnStatusQuery query) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); sql.AppendFormat("select ors.ors_status from order_return_status ors where ors.ors_order_id='{0}' and return_id='{1}' order by ors_status desc; ", query.ors_order_id, query.return_id); DataTable _dt = _access.getDataTable(sql.ToString()); return _dt; } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->CheckOrderId-->" + ex.Message + sql.ToString(), ex); } }
//確認退款單---執行之前的歸檔邏輯但是除去更新庫存的操作 public bool CouldReturnMoney(OrderReturnStatusQuery query) { StringBuilder sql = new StringBuilder(); ArrayList arrList = new ArrayList(); try { arrList.Add(CouldReturn(query)); arrList.Add(UpOrderReturnMaster(query)); HgBatchAccumulateRefund hgBatch = new HgBatchAccumulateRefund(); HGLogin hgLogin = GetHGLoginData((uint)query.ors_order_id); OrderMaster om = _ordermasterdao.GetOrderMasterByOrderId4Change(Convert.ToInt32(query.ors_order_id)); DataTable _returnDt = GetReturnId(query); DataTable odli = _orderDetailDao.OrderDetailTable(Convert.ToUInt32(query.return_id),0); OrderReturnMasterQuery omQuery = new OrderReturnMasterQuery(); SerialDao serialDao = new SerialDao(connStr); MySqlCommand mySqlCmd = new MySqlCommand(); MySqlConnection mySqlConn = new MySqlConnection(connStr); if (odli != null) { #region hg個字段賦值 if (hgLogin != null) { #region hg_batch_accumulate_refund hgBatch.order_id = (uint)query.ors_order_id; hgBatch.head = "B"; hgBatch.card_no = ""; hgBatch.card_checksum = ""; hgBatch.category_id = "N0699999"; hgBatch.wallet = "991991"; hgBatch.enc_idno = hgLogin.enc_idno; hgBatch.checksum = hgLogin.chk_sum; hgBatch.transaction_time = hgLogin.transaction_time; hgBatch.merchant_pos = hgLogin.merchant_pos; hgBatch.terminal_pos = hgLogin.terminal_pos; hgBatch.refund_point = om.Deduct_Happygo; //hgBatch.order_note = "吉甲地台灣好市集訂單編號" + hgBatch.order_id + "返還" + hgBatch.refund_point + "點"; //吉甲地台灣好市集訂單編號131210039累點取消4點 hgBatch.batch_status = 0; hgBatch.billing_checked = 0; // hgBatch.batch_import_time = Convert.ToInt32(CommonFunction.GetPHPTime()); #endregion } #endregion int paymoney = 0; int returnmoney = 0; int deductbonus = 0; int deductcash = 0; int accumulated_bonus = 0; int accumulated_happygo = 0; int deduct_happygo = 0; int deduct_happygo_money = 0; #region 退款金額 = 商品購買金額 - 購物金 foreach (DataRow od in odli.Rows) { // 退款金額 = 商品購買金額 - 購物金 paymoney += (Convert.ToInt32(od["single_money"]) * Convert.ToInt32(od["buy_num"])); deductbonus += Convert.ToInt32(od["deduct_bonus"]); deductcash += Convert.ToInt32(od["deduct_welfare"]); accumulated_bonus += Convert.ToInt32(od["accumulated_bonus"]); accumulated_happygo += Convert.ToInt32(od["accumulated_happygo"]); deduct_happygo += Convert.ToInt32(od["deduct_happygo"]); deduct_happygo_money += Convert.ToInt32(od["deduct_happygo_money"]); } returnmoney += paymoney - (deductbonus + deductcash + deduct_happygo_money);//計算應退還的money #endregion #region 判斷是否有付款 if (om.Money_Collect_Date > 0 && om.Order_Amount > 0 && returnmoney > 0) { #region 新增退款單 string serial_sql = serialDao.Update(46);//46 退款單流水號 DataTable _moneyDt = GetMoneyIDBySerial(serial_sql); uint moneyId = Convert.ToUInt32(_moneyDt.Rows[0][0]); OrderMoneyReturn omr = new OrderMoneyReturn(); omQuery.order_id = Convert.ToUInt32(query.ors_order_id); omr.money_type = om.Order_Payment; omr.money_total = Convert.ToUInt32(returnmoney); omr.money_status = 0; omr.money_source = "return_id:" + query.return_id; omr.money_id = moneyId; omQuery.return_ipfrom = ""; omQuery.bank_name = query.bank_name; omr.bank_branch = query.bank_branch; omr.bank_account = query.bank_account; omr.account_name = query.account_name; omr.bank_note = query.bank_note; string insertSql = _orderMoneyReturnDao.InsertSql(omQuery, omr); arrList.Add(insertSql); #endregion //取回給予的購物金與happygo點數 if (accumulated_bonus > 0) { Deduct_User_Bonus(accumulated_bonus, om); } //扣除給予會員的hg點數 if (accumulated_happygo > 0) { //插入hg_batch_accumulate_refund arrList.Add(hg_batch_accumulate_refund(hgBatch)); } } #endregion #region 黑貓例外處理 //黑貓例外處理 if (om.Money_Collect_Date == 0 && om.Order_Payment == 8) { //扣除給予會員的購物金 if (accumulated_bonus > 0) { Deduct_User_Bonus(accumulated_bonus, om); } //扣除給予會員的hg點數 if (accumulated_happygo > 0) { //插入hg_batch_accumulate_refund arrList.Add(hg_batch_accumulate_refund(hgBatch)); } } #endregion //寫入付款單退款金額 arrList.Add(_ordermasterdao.UpdateMoneyReturn(returnmoney, om.Order_Id)); //退回購買扣抵的hp點數 #region 判斷退回購買扣抵的hp點數 判斷是否要退回購物金 if (deduct_happygo > 0) { //插入hg_deduct_refund arrList.Add(hg_batch_deduct_refund(hgBatch)); } if (deductbonus > 0) { Deduct_Refund(om, deductbonus, 0, 0, omQuery); } if (deductcash > 0) { Deduct_Refund(om, 0, deductcash, 0, omQuery); } #endregion DataTable _dt = GetTotalCount(om.Order_Id, 1); if (Convert.ToInt32(_dt.Rows[0][0]) == 0) { if (om.Priority == 1) { arrList.Add(UpdatePriority(om.Order_Id)); arrList.Add(UpdateFirstTime(om.user_id)); } } DataTable _dt2 = GetTotalCount(om.Order_Id, 2); #region 更改推薦 if (Convert.ToInt32(_dt2.Rows[0][0]) == 0) { List<UserRecommend> usRecommandLi = _userRecommendDao.QueryByOrderId(om.Order_Id); string idStr = string.Empty; if (usRecommandLi.Count != 0) { foreach (var record in usRecommandLi) { idStr += "," + record.id; } idStr= idStr.TrimStart(','); arrList.Add(_userRecommendDao.UpdateIsCommend(idStr)); } } #endregion if (_mySqlDao.ExcuteSqlsThrowException(arrList)) { return true; } else { return false; } } } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->CouldReturnMoney-->" + ex.Message, ex); } return true; }
//更新庫存的操作 public bool PlaceOnFile(OrderReturnStatusQuery query) { //選中要退的商品進行入庫,未選中的則不入庫,將未選中的記錄到order_return_status里 try { bool b = true; ArrayList arrList = new ArrayList(); if (query.ors_status == 3) { List<OrderReturnStatusQuery> ORStore = new List<OrderReturnStatusQuery>(); if (query.data != "") { string[] dataSplit = query.data.Split(';'); for (int i = 0; i < dataSplit.Length; i++) { if (dataSplit[i] != "") { string[] newData = dataSplit[i].Split('*'); query.item_id = Convert.ToUInt32(newData[0]); query.itemStr += query.item_id + ","; query.buy_num = Convert.ToUInt32(newData[1]); DataTable odli = _orderDetailDao.OrderDetailTable(Convert.ToUInt32(query.return_id), query.item_id); if (Convert.ToInt32(odli.Rows[0]["item_mode"]) == 1)//组合商品 { List<OrderDetail> childDetail = Get_Combined_Product(Convert.ToUInt32(query.ors_order_id), Convert.ToUInt32(odli.Rows[0]["Parent_Id"]), Convert.ToUInt32(odli.Rows[0]["pack_id"])); foreach (var child in childDetail) { arrList.Add(_itemDao.UpdateItemStock(child.Item_Id, child.Buy_Num * child.parent_num));//更新庫存 } } else { arrList.Add(_itemDao.UpdateItemStock(query.item_id, query.buy_num));//更新庫存 } } } } int totalCount = 0; query.IsPage = false; query.itemStr = query.itemStr.TrimEnd(','); // query.nonSelected = true; ORStore = CouldGridList(query, out totalCount); query.itemStr = string.Empty; foreach (var item in ORStore) { query.itemStr += item.item_id + ","; } if (query.itemStr != "") { query.ors_remark = "未入庫的商品細項編號為:" + query.itemStr.TrimEnd(','); } arrList.Add(CouldReturn(query)); } if (_mySqlDao.ExcuteSqlsThrowException(arrList)) { b = true; } else { b = false; } return b; } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->PlaceOnFile-->" + ex.Message, ex); } }
public List<OrderReturnStatusQuery> CouldGridList(OrderReturnStatusQuery query, out int totalCount) { StringBuilder sql = new StringBuilder(); StringBuilder sqlFrom = new StringBuilder(); StringBuilder sqlWhere = new StringBuilder(); StringBuilder sqlCount = new StringBuilder(); try { totalCount = 0; sql.Append("select orm.order_id,od.item_id,od.product_name,para.parameterName as 'product_mode',od.product_spec_name,od.buy_num,od.single_money ,om.order_payment,orm.bank_name,orm.bank_branch,orm.bank_account,orm.account_name,orm.bank_note "); sqlFrom.Append(" from order_return_master orm LEFT JOIN order_return_detail ord on orm.return_id=ord.return_id "); sqlFrom.Append("LEFT JOIN order_detail od on ord.detail_id=od.detail_id "); sqlFrom.Append(" LEFT JOIN (select parameterCode,parameterName,remark from t_parametersrc where parametertype='product_mode') para on od.product_mode=para.parameterCode "); sqlFrom.Append(" LEFT JOIN order_master om on om.order_id = orm.order_id "); sqlWhere.AppendFormat(" where orm.return_id='{0}' ", query.return_id); if (query.itemStr!="") { sqlWhere.AppendFormat(" and od.item_id not in({0}) ",query.itemStr); } if (query.IsPage) { DataTable _dt = _access.getDataTable("select count(orm.order_id) as 'totalCount' " + sqlFrom.ToString() + sqlWhere.ToString()); if (_dt != null) { totalCount = Convert.ToInt32(_dt.Rows[0][0]); } } sqlWhere.AppendFormat(" limit {0},{1}; ", query.Start, query.Limit); sql.Append(sqlFrom.ToString() + sqlWhere.ToString()); return _access.getDataTableForObj<OrderReturnStatusQuery>(sql.ToString()); } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->CouldGridList-->" + sql.ToString() + ex.Message, ex); } }
public string CouldReturn(OrderReturnStatusQuery query) { string json = string.Empty; // List<OrderReturnStatusQuery> store = new List<OrderReturnStatusQuery>(); ArrayList arrList = new ArrayList(); try { //int totalCount = 0; //query.IsPage = false; //store= _orderReturnStatus.CouldGridList(query, out totalCount); // int modeCount = 0; //foreach (var item in store) //{ // if (item.product_mode =="自出") // { // modeCount++; // } //} //if (modeCount ==store.Count) //{ // //全是自出 // query.ors_status = 4; // arrList.Add(_orderReturnStatus.CouldReturn(query)); //} //不全是自出 arrList.Add(_orderReturnStatus.UpdateORM(query)); arrList.Add(_orderReturnStatus.CouldReturn(query)); if (_mysql.ExcuteSqlsThrowException(arrList)) { json = "{success:true}"; } else { json = "{success:false}"; } return json; } catch (Exception ex) { throw new Exception("OrderReturnStatusMgr-->CouldReturn-->" + ex.Message, ex); } }
public HttpResponseBase CouldGridList() { string json = string.Empty; try { _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString); OrderReturnStatusQuery query = new OrderReturnStatusQuery(); List<OrderReturnStatusQuery> store = new List<OrderReturnStatusQuery>(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); if (!string.IsNullOrEmpty(Request.Params["return_id"])) { query.return_id = Convert.ToUInt32(Request.Params["return_id"]); query.ors_order_id = _orderReturnStatus.GetOrderIdByReturnId(query.return_id); } int totalCount = 0; store = _orderReturnStatus.CouldGridList(query, out totalCount); json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented) + "}";//返回json數據 } 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:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase CheckOrderId() { string json = string.Empty; OrderReturnStatusQuery query = new OrderReturnStatusQuery(); DataTable _dt = new DataTable(); DataTable _tranDt = new DataTable(); List<OrderReturnStatusQuery> store = new List<OrderReturnStatusQuery>(); try { if (!string.IsNullOrEmpty(Request.Params["return_id"])) { query.return_id = Convert.ToUInt32(Request.Params["return_id"]); //如果ors_order_id為0則證明return_id不存在 _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString); query.ors_order_id = _orderReturnStatus.GetOrderIdByReturnId(query.return_id); query.orc_order_id = query.ors_order_id; //add 歸檔取消退貨的商品 直接告知不再繼續往下 if (query.ors_order_id == 0) { json = "{success:true,status:'-1'}"; } else { _dt = _orderReturnStatus.CheckOrderId(query); _tranDt = _orderReturnStatus.CheckTransport(query); int totalCount = 0; query.IsPage = false; store = _orderReturnStatus.CouldGridList(query, out totalCount); if (_dt != null && _dt.Rows.Count > 0) { if (Convert.ToInt32(_dt.Rows[0][0]) == 2 || Convert.ToInt32(_dt.Rows[0][0]) == 3 || Convert.ToInt32(_dt.Rows[0][0]) == 4) { json = "{success:true,status:'" + Convert.ToInt32(_dt.Rows[0]["ors_status"]) + "',order_payment:'" + store[0].order_payment + "',bank_name:'" + store[0].bank_name + "',bank_branch:'" + store[0].bank_branch + "',bank_account:'" + store[0].bank_account + "',account_name:'" + store[0].account_name + "',bank_note:'" + store[0].bank_note + "' }"; } else if (_tranDt == null || _tranDt.Rows[0][0].ToString() == "") { json = "{success:true,status:'0.5'}"; } else { if (Convert.ToInt32(_dt.Rows[0]["ors_status"]) == 2)//此時需要點擊確認入庫 { json = "{success:true,status:'" + Convert.ToInt32(_dt.Rows[0]["ors_status"]) + "'}"; } else { json = "{success:true,status:'" + Convert.ToInt32(_dt.Rows[0]["ors_status"]) + "'}"; } } } else { OrderMaster om = _orderReturnStatus.GetOrderInfo(Convert.ToUInt32(query.return_id)); string delivery_name = "***"; string delivery_mobile = "***"; string delivery_address = "***"; if (!string.IsNullOrEmpty(om.Delivery_Name)) { delivery_name = om.Delivery_Name.Substring(0, 1) + "**"; } if (!string.IsNullOrEmpty(om.Delivery_Mobile)) { if (!CommonFunction.isMobile(om.Delivery_Mobile)) { if (om.Delivery_Mobile.ToString().Length == 48) { om.Delivery_Mobile = EncryptComputer.EncryptDecryptTextByApi(om.Delivery_Mobile, false); if (!CommonFunction.isMobile(om.Delivery_Mobile)) { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", query.orc_order_id, om.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", query.orc_order_id, om.Delivery_Mobile, "訂購人行動電話錯誤"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } if (om.Delivery_Mobile.ToString().Length > 3) { om.Delivery_Mobile = om.Delivery_Mobile.Substring(0, 3) + "***"; } else { om.Delivery_Mobile = om.Delivery_Mobile + "***"; } } if (!string.IsNullOrEmpty(om.Delivery_Address)) { if (om.Delivery_Address.Length > 3) { delivery_address = om.Delivery_Address.Substring(0, 3) + "**"; } else { delivery_address = om.Delivery_Address + "***"; } } json = "{success:true,name:'" + delivery_name + "',mobile:'" + delivery_mobile + "',address:'" + delivery_address + "',zipcode:'" + om.Delivery_Zip + "',status:'0',bank_note:'" + store[0].bank_note + "'}"; } } } } 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 InsertOrderReturnContent(OrderReturnStatusQuery query) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("insert into order_return_content(orc_order_id,orc_deliver_code,orc_deliver_date,orc_deliver_time,orc_name,orc_mobile,orc_zipcode,orc_address,orc_remark,orc_type,orc_service_remark,return_id,orc_send) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}');", query.orc_order_id, query.orc_deliver_code, CommonFunction.DateTimeToString(query.orc_deliver_date), query.orc_deliver_time, query.orc_name, query.orc_mobile, query.orc_zipcode, query.orc_address, query.orc_remark, query.orc_type, query.orc_service_remark, query.return_id, query.orc_send); return sql.ToString(); } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->InsertOrderReturnContent-->" + ex.Message + sql.ToString(), ex); } }
public string InsertTransport(OrderReturnStatusQuery query) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("set sql_safe_updates = 0;update order_return_content set orc_deliver_date='{0}' ,orc_deliver_time='{1}',orc_deliver_code='{2}' where orc_order_id='{3}' and return_id='{4}' ;set sql_safe_updates=1;", CommonFunction.DateTimeToString(query.orc_deliver_date), query.orc_deliver_time, query.orc_deliver_code, query.orc_order_id,query.return_id); return sql.ToString(); } catch (Exception ex) { throw new Exception("OrderReturnStatusDao.InsertTransport-->" + ex.Message + sql.ToString(), ex); } }
public string SaveOrderReturn(OrderReturnStatusQuery query) { string json = string.Empty; try { ArrayList arrList = new ArrayList(); bool zichu = false; query.ors_createdate = DateTime.Now; if (query.orc_name.IndexOf("*")>0) { OrderMaster om = _orderReturnStatus.GetOrderInfo(Convert.ToUInt32(query.orc_order_id)); query.orc_name = om.Delivery_Name; query.orc_mobile = om.Delivery_Mobile; query.orc_address = om.Delivery_Address; } arrList.Add(_orderReturnStatus.InsertOrderReturnContent(query)); arrList.Add(_orderReturnStatus.InsertOrderReturnStatus(query)); arrList.Add(_orderReturnStatus.UpdateORM(query)); //產看要退的商品是不是都是自出 List<OrderReturnStatusQuery> store = new List<OrderReturnStatusQuery>(); int totalCount = 0; query.IsPage = false; store = _orderReturnStatus.CouldGridList(query, out totalCount); int modeCount = 0; foreach (var item in store) { if (item.product_mode == "自出") { modeCount++; } } if (modeCount == store.Count) { //全是自出 zichu = true; query.ors_status = 3; arrList.Add(_orderReturnStatus.CouldReturn(query)); } else { if (query.orc_send == 0)//未發貨,寄倉/調度則在客戶信息填完之後,就確認入庫 { query.ors_status = 2; arrList.Add(_orderReturnStatus.CouldReturn(query)); } } if (_orderReturnStatus.ExecSqls(arrList)) { if (zichu) { json = "{success:true,isZIChu:'1',}"; } else { json = "{success:true}"; } } else { json = "{success:false}"; } return json; } catch (Exception ex) { throw new Exception("OrderReturnStatusMgr-->SaveOrderReturn-->" + ex.Message, ex); } }
//確認入庫,更新庫存 public string PlaceOnFile(OrderReturnStatusQuery query) { string json = string.Empty; try { if (_orderReturnStatus.PlaceOnFile(query)) { json = "{success:true}"; } else { json = "{success:false}"; } return json; } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->PlaceOnFile-->" + ex.Message, ex); } }
public string CouldReturnMoney(OrderReturnStatusQuery query) { string json = string.Empty; try { if (_orderReturnStatus.CouldReturnMoney(query)) { json = "{success:true}"; } else { json = "{success:false}"; } return json; } catch (Exception ex) { throw new Exception("OrderReturnStatusMgr-->CouldReturnMoney-->" + ex.Message, ex); } }
public string InsertTransport(OrderReturnStatusQuery query) { string json = string.Empty; try { ArrayList arrList = new ArrayList(); arrList.Add(_orderReturnStatus.InsertTransport(query)); arrList.Add(_orderReturnStatus.UpdateORS(query));//由於邏輯變更,此處為想order_return_status表裏插入數據 if (_mysql.ExcuteSqlsThrowException(arrList)) { json = "{success:'true',msg:'1'}"; } else { json = "{success:'false'}"; } return json; } catch (Exception ex) { throw new Exception("OrderReturnStatusMgr-->InsertTransport-->" + ex.Message, ex); } }
public DataTable GetReturnId(OrderReturnStatusQuery query) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("select return_id from order_return_master where order_id='{0}';", query.ors_order_id); return _access.getDataTable(sql.ToString()); } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->GetReturnId-->" + ex.Message + sql.ToString(), ex); } }
public string UpdateORM(OrderReturnStatusQuery query) { StringBuilder sql = new StringBuilder(); StringBuilder sql1 = new StringBuilder(); try { sql.AppendFormat("update order_return_master set "); if (query.invoice_deal == 0 && query.ormpackage != 0) { sql1.AppendFormat(" package='{0}' ", query.ormpackage); } else if (query.invoice_deal != 0 && query.ormpackage == 0) { sql1.AppendFormat(" invoice_deal='{0}' ", query.invoice_deal); } if (query.bank_note != "") { if (sql1.Length > 1) { sql1.Append(","); } sql1.AppendFormat(" bank_note='{0}' ", query.bank_note); } sql1.AppendFormat(" where return_id='{0}'; ", query.return_id); sql.Append(sql1.ToString()); return sql.ToString(); } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->UpdateORM-->" + sql.ToString() + ex.Message, ex); } }
public string CouldReturn(OrderReturnStatusQuery query) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("insert into order_return_status(ors_order_id,ors_status,ors_remark,ors_createdate,ors_createuser,return_id) values('{0}','{1}','{2}','{3}','{4}','{5}');", query.ors_order_id, query.ors_status, query.ors_remark, CommonFunction.DateTimeToString(DateTime.Now), query.ors_createuser, query.return_id); return sql.ToString(); } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->CouldReturn-->" + sql.ToString() + ex.Message, ex); } }
public HttpResponseBase SaveOrderStatus() { OrderReturnStatusQuery query = new OrderReturnStatusQuery(); string json = string.Empty; try { _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["orc_name"])) { query.orc_name = (Request.Params["orc_name"]); } if (!string.IsNullOrEmpty(Request.Params["return_id"])) { query.return_id = Convert.ToUInt32(Request.Params["return_id"]); query.orc_order_id = _orderReturnStatus.GetOrderIdByReturnId(query.return_id); query.ors_order_id = query.orc_order_id; } if (!string.IsNullOrEmpty(Request.Params["orc_mobile"])) { query.orc_mobile = Request.Params["orc_mobile"]; //變更電話需加密 後期解除注視 //if (!CommonFunction.isMobile(Request.Params["orc_mobile"])) //{ // //異常記錄 // Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); // logMessage.Content = string.Format("表名:{0},退貨編號:{1},行動電話:{2},Message:{3}", "order_return_content", query.return_id, Request.Params["orc_mobile"], "退貨狀態查詢行動電話不滿足正則表達式"); // logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; // log.Error(logMessage); //} //else { // //加密電話 // query.orc_mobile = EncryptComputer.EncryptDecryptTextByApi(Request.Params["orc_mobile"]); //} } if (!string.IsNullOrEmpty(Request.Params["orc_zipcode"])) { query.orc_zipcode = (Request.Params["orc_zipcode"]); } if (!string.IsNullOrEmpty(Request.Params["orc_address"])) { query.orc_address = (Request.Params["orc_address"]); } if (!string.IsNullOrEmpty(Request.Params["orc_type"])) { query.orc_type =Convert.ToInt32(Request.Params["orc_type"]); } if (!string.IsNullOrEmpty(Request.Params["orc_service_remark"])) { query.orc_service_remark = (Request.Params["orc_service_remark"]); } if (!string.IsNullOrEmpty(Request.Params["orc_remark"])) { query.orc_remark = (Request.Params["orc_remark"]); query.ors_remark = (Request.Params["orc_remark"]); } if (!string.IsNullOrEmpty(Request.Params["invoice_deal"])) { query.invoice_deal =Convert.ToInt32(Request.Params["invoice_deal"]); } if (!string.IsNullOrEmpty(Request.Params["orc_send"])) { query.orc_send = Convert.ToInt32(Request.Params["orc_send"]); } if (!string.IsNullOrEmpty(Request.Params["bank_note"])) {//退款諮詢添加到此 query.bank_note = Request.Params["bank_note"]; } query.ors_createuser = (Session["caller"] as Caller).user_id; json = _orderReturnStatus.SaveOrderReturn(query); } 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 UpOrderReturnMaster(OrderReturnStatusQuery query) { StringBuilder sql = new StringBuilder(); StringBuilder sql1 = new StringBuilder(); try { sql.AppendFormat("set sql_safe_updates = 0;update order_return_master set return_status=1,bank_name='{0}', bank_branch='{1}',bank_account='{2}',account_name='{3}' ", query.bank_name, query.bank_branch, query.bank_account, query.account_name); if (!String.IsNullOrEmpty(query.bank_note)) {//add 如果退款備註不為空則更新 sql1.AppendFormat(",bank_note='{0}' ", query.bank_note); } sql.Append(sql1.ToString()); sql.AppendFormat(" where return_id='{0}';set sql_safe_updates = 1;", query.return_id); return sql.ToString(); } catch (Exception ex) { throw new Exception("OrderReturnStatusDao-->UpOrderReturnMaster-->"+sql.ToString()+ex.Message,ex); } }
//確認退款單 public HttpResponseBase CouldReturnMoney() { string json = string.Empty; try { _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString); OrderReturnStatusQuery query = new OrderReturnStatusQuery(); if (!string.IsNullOrEmpty(Request.Params["return_id"])) { query.return_id = Convert.ToUInt32(Request.Params["return_id"]); query.ors_order_id = _orderReturnStatus.GetOrderIdByReturnId(query.return_id); } if (!string.IsNullOrEmpty(Request.Params["bank_name"])) { query.bank_name =(Request.Params["bank_name"]); } if (!string.IsNullOrEmpty(Request.Params["bank_branch"])) { query.bank_branch = (Request.Params["bank_branch"]); } if (!string.IsNullOrEmpty(Request.Params["bank_account"])) { query.bank_account = (Request.Params["bank_account"]); } if (!string.IsNullOrEmpty(Request.Params["account_name"])) { query.account_name = (Request.Params["account_name"]); } if (!string.IsNullOrEmpty(Request.Params["bank_note"])) { query.bank_note = (Request.Params["bank_note"]); } query.ors_status = 4; query.ors_createuser = (Session["caller"] as Caller).user_id; json = _orderReturnStatus.CouldReturnMoney(query); } 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 List<OrderReturnStatusQuery> CouldGridList(OrderReturnStatusQuery query, out int totalCount) { try { return _orderReturnStatus.CouldGridList(query, out totalCount); } catch (Exception ex) { throw new Exception("OrderReturnStatusMgr-->CouldGridList-->" + ex.Message, ex); } }