//確認退款單 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 HttpResponseBase GetPackageStore() { string json = string.Empty; try { //List<OrderReturnStatusQuery> store = new List<OrderReturnStatusQuery>(); _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString); DataTable _dt = _orderReturnStatus.GetPackageStore(); json = "{success:true,data:" + JsonConvert.SerializeObject(_dt, 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:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
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 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 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 void ExportReport() { List<OrderMasterQuery> stores = new List<OrderMasterQuery>(); OrderMasterQuery query = new OrderMasterQuery(); DateTime dtime; string payment = string.Empty; string order_status = string.Empty; string detail_status = string.Empty; string product_mode = string.Empty; string total_amount = string.Empty; string invoice_number = string.Empty; string invoice_date = string.Empty; try { _orderMasterMgr = new OrderMasterMgr(mySqlConnectionString); _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString); #region 查詢條件 string dateOne = Request.Params["dateOne"]; string dateTwo = Request.Params["dateTwo"]; if (DateTime.TryParse(Request.Params["dateOne"].ToString(), out dtime))//開始時間 { query.datestart = dtime; } if (DateTime.TryParse(Request.Params["dateTwo"].ToString(), out dtime)) { query.dateend = dtime; } #endregion DataTable dtHZ = new DataTable(); dtHZ.Columns.Add("會員姓名", typeof(String)); dtHZ.Columns.Add("購買時間", typeof(String)); dtHZ.Columns.Add("付款單號", typeof(String)); dtHZ.Columns.Add("付款方式", typeof(String)); dtHZ.Columns.Add("購買金額", typeof(String)); dtHZ.Columns.Add("付款狀態", typeof(String)); dtHZ.Columns.Add("發票號碼", typeof(String)); dtHZ.Columns.Add("發票金額", typeof(String)); dtHZ.Columns.Add("發票開立日期", typeof(String)); dtHZ.Columns.Add("商品細項編號", typeof(String)); dtHZ.Columns.Add("訂單狀態", typeof(String)); dtHZ.Columns.Add("供應商", typeof(String)); dtHZ.Columns.Add("供應商編碼", typeof(String)); dtHZ.Columns.Add("品名", typeof(String)); dtHZ.Columns.Add("數量", typeof(String)); dtHZ.Columns.Add("購買單價", typeof(String)); dtHZ.Columns.Add("折抵購物金", typeof(String)); dtHZ.Columns.Add("抵用卷", typeof(String)); dtHZ.Columns.Add("總價", typeof(String)); dtHZ.Columns.Add("成本單價", typeof(String)); dtHZ.Columns.Add("寄倉費", typeof(String)); dtHZ.Columns.Add("成本總額", typeof(String)); dtHZ.Columns.Add("出貨單歸檔期", typeof(String)); dtHZ.Columns.Add("負責PM", typeof(String)); dtHZ.Columns.Add("來源ID", typeof(String)); dtHZ.Columns.Add("來源名稱", typeof(String)); dtHZ.Columns.Add("出貨方式", typeof(String)); DataTable _dt = _orderMasterMgr.OrderSerchExport(query); for (int i = 0; i < _dt.Rows.Count; i++) { if (i != 0) { if (_dt.Rows[i]["order_id"].ToString() == _dt.Rows[i - 1]["order_id"].ToString()) { dtHZ.Rows.Add(_orderReturnStatus.GetOrdinaryData(dtHZ, _dt, i)); } else { if (i == _dt.Rows.Count - 1) { #region 如果此order_id是最後一條數據 dtHZ.Rows.Add(_orderReturnStatus.GetOrdinaryData(dtHZ, _dt, i)); DataTable _dtFreight = _orderMasterMgr.GetOrderFreight(Convert.ToUInt32(_dt.Rows[i]["order_id"])); if (_dtFreight != null && _dtFreight.Rows.Count > 0) { #region 常溫運費 if (Convert.ToInt32(_dtFreight.Rows[0][0]) != 0)//常溫運費 { dtHZ.Rows.Add(_orderReturnStatus.GetFreightData(dtHZ, _dt, _dtFreight, i,1)); } #endregion #region 低溫運費 if (Convert.ToInt32(_dtFreight.Rows[0][1]) != 0)//低溫運費 { dtHZ.Rows.Add(_orderReturnStatus.GetFreightData(dtHZ, _dt, _dtFreight, i, 2)); } #endregion } #endregion } else { #region 查上一個order_id是否有運費 DataTable _dtFreight02 = _orderMasterMgr.GetOrderFreight(Convert.ToUInt32(_dt.Rows[i - 1]["order_id"])); if (_dtFreight02 != null && _dtFreight02.Rows.Count > 0) { #region 常溫運費 if (Convert.ToInt32(_dtFreight02.Rows[0][0]) != 0)//常溫運費 { dtHZ.Rows.Add(_orderReturnStatus.GetFreightData(dtHZ, _dt, _dtFreight02, i - 1,1)); } #endregion #region 低溫運費 if (Convert.ToInt32(_dtFreight02.Rows[0][1]) != 0)//低溫運費 { dtHZ.Rows.Add(_orderReturnStatus.GetFreightData(dtHZ, _dt, _dtFreight02, i - 1,2)); } #endregion } #endregion #region 查當前order_id dtHZ.Rows.Add(_orderReturnStatus.GetOrdinaryData(dtHZ, _dt, i)); #endregion } } } else { dtHZ.Rows.Add(_orderReturnStatus.GetOrdinaryData(dtHZ, _dt, i)); } } string fileName = "會計總表" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, ""); Response.AddHeader("Content-Disposition", "attach-ment;filename=" + fileName); Response.BinaryWrite(ms.ToArray()); } 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); } }
public HttpResponseBase GetUserInfo() { string json = "{success:false}"; try { int type = 0; int related_id = 0; string urlType = string.Empty; int totalCount = 0; int info_id = 0; string info_type = string.Empty; if (!string.IsNullOrEmpty(Request.Params["relatedID"])) { related_id = Convert.ToInt32(Request.Params["relatedID"].ToString());//表主鍵欄位 } if (!string.IsNullOrEmpty(Request.Params["type"])) { type = Convert.ToInt32(Request.Params["type"].ToString());//secret_type,表某一模塊 } if (!string.IsNullOrEmpty(Request.Params["urlType"]))//url地址 { urlType = Request.Params["urlType"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["info_id"])) { info_id = Convert.ToInt32(Request.Params["info_id"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["info_type"])) { info_type = Request.Params["info_type"].ToString(); } switch (info_type)//1.會員查詢頁面2.訂單內容3.簡訊查詢4.聯絡客服列表 { case "users": UsersMgr _usermgr = new UsersMgr(mySqlConnectionString); Users u = new Users(); Users uModel = _usermgr.GetUser(new Users { user_id = Convert.ToUInt32(info_id) }).FirstOrDefault(); if (uModel != null) { if (!string.IsNullOrEmpty(uModel.user_mobile)) { if (!CommonFunction.isMobile(uModel.user_mobile)) { if (uModel.user_mobile.ToString().Length == 48) { uModel.user_mobile = EncryptComputer.EncryptDecryptTextByApi(uModel.user_mobile, false); if (!CommonFunction.isMobile(uModel.user_mobile)) { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},編號:{1},行動電話:{2},Message:{3}", "users", uModel.user_id, uModel.user_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}", "users", uModel.user_id, uModel.user_mobile, "行動電話錯誤"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } } } json = "{success:true,\"user_id\":\"" + uModel.user_id + "\",\"user_name\":\"" + uModel.user_name + "\",\"user_email\":\"" + uModel.user_email + "\",\"user_mobile\":\"" + uModel.user_mobile + "\",\"user_adress\":\"" + uModel.user_address + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; case "trial_share": TrialRecordMgr _recordMgr = new TrialRecordMgr(mySqlConnectionString); TrialShare tModel = _recordMgr.GetTrialShare(new TrialShare { share_id = related_id, user_id = info_id }); json = "{success:true,\"user_id\":\"" + tModel.user_id + "\",\"user_name\":\"" + tModel.user_name + "\"}"; break; case "manager_user": ManageUserMgr _muMgr = new ManageUserMgr(mySqlConnectionString); ManageUser muModel = _muMgr.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(info_id) }).FirstOrDefault(); json = "{success:true,\"user_id\":\"" + muModel.user_id + "\",\"user_name\":\"" + muModel.user_username + "\",\"user_email\":\"" + muModel.user_email + "\"}"; break; case "vip_user": VipUserMgr vipusersMgr = new VipUserMgr(mySqlConnectionString); VipUser model = vipusersMgr.GetSingleByID(related_id); json = "{success:true,\"v_id\":\"" + model.v_id + "\",\"user_id\":\"" + model.user_id + "\",\"user_email\":\"" + model.user_email + "\"}"; break; case "edm_group_email": EdmGroupEmailMgr edmgroupmailMgr = new EdmGroupEmailMgr(mySqlConnectionString); EdmGroupEmailQuery egemodel = edmgroupmailMgr.GetModel(new EdmGroupEmail { email_id = Convert.ToUInt32(related_id), group_id = Convert.ToUInt32(info_id) }).FirstOrDefault(); json = "{success:true,\"user_id\":\"" + egemodel.email_id + "\",\"user_name\":\"" + egemodel.email_name + "\",\"user_email\":\"" + egemodel.email_address + "\"}"; break; case "edm_test": EdmTestMgr edmtestMgr = new EdmTestMgr(mySqlConnectionString); EdmTestQuery etmodel = edmtestMgr.GetModel(new EdmTestQuery { email_id = Convert.ToUInt32(related_id) }).FirstOrDefault(); json = "{success:true,\"user_id\":\"" + etmodel.email_id + "\",\"user_name\":\"" + etmodel.test_username + "\",\"user_email\":\"" + etmodel.email_address + "\"}"; break; case "order_master": OrderMasterMgr omMgr = new OrderMasterMgr(mySqlConnectionString); zMgr = new ZipMgr(mySqlConnectionString); DataTable dt = omMgr.GetOrderidAndName(related_id); json = "{success:true,\"order_id\":\"" + dt.Rows[0][0] + "\",\"order_name\":\"" + dt.Rows[0][1] + "\",\"order_phone\":\"" + dt.Rows[0][2] + "\",\"order_mobile\":\"" + dt.Rows[0][3] + "\",\"order_address\":\"" + zMgr.Getaddress(int.Parse(dt.Rows[0][9].ToString())) + dt.Rows[0][4] + "\",\"delivery_name\":\"" + dt.Rows[0][5] + "\",\"delivery_phone\":\"" + dt.Rows[0][6] + "\",\"delivery_mobile\":\"" + dt.Rows[0][7] + "\",\"delivery_address\":\"" + zMgr.Getaddress(int.Parse(dt.Rows[0][10].ToString())) + dt.Rows[0][8] + "\"}"; break; case "order_master1": OrderMasterMgr omMgr1 = new OrderMasterMgr(mySqlConnectionString); DataTable dt1 = omMgr1.GetOrderidAndName(related_id); json = "{success:true,\"order_id\":\"" + dt1.Rows[0][0] + "\",\"order_name\":\"" + dt1.Rows[0][1] + "\"}"; break; case "order_payment_hitrust": TabShowMgr OphMgr = new TabShowMgr(mySqlConnectionString); DataTable store = new DataTable(); store = OphMgr.GetOderHitrustDT(related_id); json = "{success:true,\"id\":\"" + store.Rows[0]["id"] + "\",\"pan\":\"" + store.Rows[0]["pan"] + "\",\"bankname\":\"" + store.Rows[0]["bankname"] + "\"}"; break; case "order_payment_nccc": TabShowMgr OpnMgr = new TabShowMgr(mySqlConnectionString); DataTable Opn = new DataTable(); store = OpnMgr.GetNCCC(related_id); json = "{success:true,\"nccc_id\":\"" + Opn.Rows[0]["nccc_id"] + "\",\"nccc_pan\":\"" + Opn.Rows[0]["pan"] + "\",\"nccc_bankname\":\"" + Opn.Rows[0]["bankname"] + "\"}"; break; //case "send_mail": // SendMailMgr sendmailMgr = new SendMailMgr(mySqlConnectionString); // SendMail sendModel = sendmailMgr.GetModel(new SendMail { id = related_id }); // json = "{success:true,\"sender_address\":\"" + sendModel.sender_address + "\",\"sender_name\":\"" + sendModel.sender_name + "\",\"send_type\":\"" + sendModel.send_type // + "\",\"recipient\":\"" + sendModel.recipient + "\",\"recipient_name\":\"" + sendModel.recipient_name // + "\"}"; // break; } switch (type)//1.會員查詢頁面2.訂單內容3.簡訊查詢4.聯絡客服列表 { case 1: if (urlType == "/Member/RecommendMember")//推薦會員中推薦者的信息 { UserRecommendMgr _userrecommendMgr = new UserRecommendMgr(mySqlConnectionString); DataTable _urdtno = _userrecommendMgr.getUserInfo(related_id); if (_urdtno.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"ur_name\":\"" + _urdtno.Rows[0]["name"] + "\",\"ur_mail\":\"" + _urdtno.Rows[0]["mail"] + "\",\"no_ur_name\":\"" + _urdtno.Rows[0]["user_name"] + "\"}"; } } else if (urlType == "/Member/UserLoginLog")//會員登入記錄 { UserLoginLogMgr _userloginlog = new UserLoginLogMgr(mySqlConnectionString); DataTable _dtull = _userloginlog.GetUserInfo(related_id); if (_dtull.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dtull.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtull.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtull.Rows[0]["user_email"] + "\",\"user_adress\":\"" + _dtull.Rows[0]["user_address"] + "\"}"; } } else { UsersListMgr _userMgr = new UsersListMgr(mySqlConnectionString); BLL.gigade.Model.Custom.Users _user = _userMgr.getModel(related_id); if (_user != null) { json = "{success:true,\"user_id\":\"" + _user.user_id + "\",\"user_name\":\"" + _user.user_name + "\",\"user_email\":\"" + _user.user_email + "\",\"user_adress\":\"" + _user.user_address + "\"}"; } } break; case 2: OrderQuestionMgr _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString); DataTable _dtques = _IOrderQuesMgr.GetUserInfo(related_id); if (_dtques.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dtques.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtques.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtques.Rows[0]["user_email"] + "\",\"user_adress\":\"" + "" + "\",\"order_id\":\"" + _dtques.Rows[0]["order_id"] + "\"}"; } break; case 3: SmsMgr _ISmsMgr = new SmsMgr(mySqlConnectionString); SmsQuery SmsStore = _ISmsMgr.GetSmsList(new SmsQuery { id = related_id }, out totalCount).FirstOrDefault(); if (SmsStore != null) { json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + "" + "\",\"user_mobile\":\"" + SmsStore.mobile + "\",\"user_adress\":\"" + "" + "\"}"; } break; case 4: ContactUsQuestionMgr _ctactMgr = new ContactUsQuestionMgr(mySqlConnectionString); DataTable _dt = _ctactMgr.GetUserInfo(related_id); if (_dt.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dt.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dt.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dt.Rows[0]["user_email"] + "\",\"user_adress\":\"" + "" + "\"}"; } break; case 7://供應商詳情 VendorQuery _dtven = null; if (urlType == "/Vendor/VendorBrandList") { VendorBrandSetMgr _IvendorBrandSet = new VendorBrandSetMgr(mySqlConnectionString); VendorBrandSetQuery query = _IvendorBrandSet.GetModelById(related_id); VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString); _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = query.vendor_id, IsPage = false }, ref totalCount).FirstOrDefault(); if (_dtven != null) { json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + "" + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}"; } } else if (urlType == "/Vendor/VendorLoginList") { VendorLoginListMgr _Ivendorloginlist = new VendorLoginListMgr(mySqlConnectionString); VendorLoginQuery query = _Ivendorloginlist.Query(new VendorLoginQuery { login_id = Convert.ToUInt32(related_id), IsPage = false }, out totalCount).FirstOrDefault(); VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString); _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = query.vendor_id, IsPage = false }, ref totalCount).FirstOrDefault(); if (_dtven != null) { json = "{success:true,\"user_id\":\"" + _dtven.vendor_code + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + "" + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}"; } } else { VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString); _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = Convert.ToUInt32(related_id), IsPage = false }, ref totalCount).FirstOrDefault(); if (_dtven != null) { json = "{success:true,\"user_id\":\"" + _dtven.vendor_code + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + _dtven.vendor_email + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + _dtven.vendor_company_address + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}"; } } break; case 9: MailUserMgr _IMailUserMgr = new MailUserMgr(mySqlConnectionString); DataTable _dtmu = _IMailUserMgr.GetUserInfo(related_id); if (_dtmu.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dtmu.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtmu.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtmu.Rows[0]["user_email"] + "\",\"user_adress\":\"" + _dtmu.Rows[0]["user_address"] + "\"}"; } break; case 10: PaperAnswerMgr _paperAnswerMgr = new PaperAnswerMgr(mySqlConnectionString); PaperAnswer store = _paperAnswerMgr.GetPaperAnswerList(new PaperAnswer { answerID = related_id, IsPage = false }, out totalCount).FirstOrDefault(); if (store != null) { json = "{success:true,\"user_id\":\"" + store.userid + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + store.userMail + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\"}"; } break; case 14://會員等級歷程 UserLevelLogMgr _userLevelLog = new UserLevelLogMgr(mySqlConnectionString); // UserLevelLogQuery store UserLevelLogQuery levelStore = _userLevelLog.GetUserLevelLogList(new UserLevelLogQuery { user_id = Convert.ToUInt32(related_id), IsPage = false, isSecret = false }, out totalCount).FirstOrDefault(); if (levelStore != null) { json = "{success:true,\"user_id\":\"" + levelStore.user_id + "\",\"user_name\":\"" + levelStore.user_name + "\",\"user_email\":\"" + levelStore.user_email + "\"}"; } break; case 18://企業會員管理 _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString); VipUserGroupQuery vipStore = _vipUserGroup.GetVipUserGList(new VipUserGroupQuery { group_id = Convert.ToUInt32(related_id), IsPage = false, isSecret = false }, out totalCount).FirstOrDefault(); if (vipStore != null) { json = "{success:true,\"group_committe_chairman\":\"" + vipStore.group_committe_chairman + "\",\"group_committe_phone\":\"" + vipStore.group_committe_phone + "\",\"group_committe_mail\":\"" + vipStore.group_committe_mail + "\"}"; } break; case 19://商品點擊查詢 _IBrowseDataMgr = new BrowseDataMgr(mySqlConnectionString); DataTable _dtBrowse = _IBrowseDataMgr.GetBrowseDataList(new BrowseDataQuery { id = related_id, IsPage = false, isSecret = false }, out totalCount); string user_name = (_dtBrowse.Rows[0]["user_name"].ToString()); string user_id = (_dtBrowse.Rows[0]["user_id"].ToString()); json = "{success:true,\"user_name\":\"" + user_name + "\",\"user_id\":\"" + user_id + "\"}"; break; case 22://聯合信用卡銀行卡號 _tabshow = new TabShowMgr(mySqlConnectionString); // OrderPaymentNcccQuery OPNQuery = new OrderPaymentNcccQuery(); OrderPaymentNcccQuery OPNQuery = _tabshow.GetNCCC(new OrderPaymentNcccQuery { nccc_id = (uint)related_id, IsPage = false, isSecret = false }, out totalCount).FirstOrDefault(); json = "{success:true,\"nccc_id\":\"" + OPNQuery.nccc_id + "\",\"nccc_pan\":\"" + OPNQuery.pan + "\",\"nccc_bankname\":\"" + OPNQuery.bankname + "\"}"; break; case 23://退貨 _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString); OrderMaster om = _orderReturnStatus.GetOrderInfo(Convert.ToUInt32(related_id)); json = "{success:true,\"orc_name\":\"" + om.Delivery_Name + "\",\"orc_mobile\":\"" + om.Delivery_Mobile + "\",\"orc_address\":\"" + om.Delivery_Address + "\"}"; break; } } 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; }