/// <summary> /// 确认收货 /// </summary> public void Received() { int id = RequestTool.RequestInt("id", 0); int tid = RequestTool.RequestInt("tid", 0); Lebi_Transport_Order torder = B_Lebi_Transport_Order.GetModel("User_id=" + CurrentUser.id + " and id = " + tid); if (torder == null) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } if (torder.Type_id_TransportOrderStatus != 220) { Response.Write("{\"msg\":\"" + Tag("当前状态不可收货") + "\"}"); return; } if (torder.User_id != CurrentUser.id) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } torder.Type_id_TransportOrderStatus = 223; torder.Time_Received = System.DateTime.Now; B_Lebi_Transport_Order.Update(torder); EX_Area.UpdateShouHuoCount(torder); //发送短信 SMS.SendSMS_orderrecive(CurrentUser, torder); Response.Write("{\"msg\":\"OK\"}"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("order_shipping", "订单发货")) { WindowNoPower(); } int id = RequestTool.RequestInt("id", 0); string where = "id = " + id + ""; if (!string.IsNullOrEmpty(EX_Admin.Project().Site_ids)) { where += " and (Site_id in (" + EX_Admin.Project().Site_ids + "))"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Supplier_ids)) { where += " and (Supplier_id in (" + EX_Admin.Project().Supplier_ids + "))"; } model = B_Lebi_Order.GetModel(where); if (model == null) { model = new Lebi_Order(); } pros = B_Lebi_Order_Product.GetList("Order_id=" + model.id + "", ""); transport_order = B_Lebi_Transport_Order.GetModel("Order_id = " + id); if (transport_order == null) { transport_order = new Lebi_Transport_Order(); } }
protected void Page_Load(object sender, EventArgs e) { int id = RequestTool.RequestInt("id", 0); torder = B_Lebi_Transport_Order.GetModel(id); if (torder == null) { Response.Write(Tag("参数错误")); Response.End(); return; } string where = "id = " + torder.Order_id + ""; if (!string.IsNullOrEmpty(EX_Admin.Project().Site_ids)) { where += " and (Site_id in (" + EX_Admin.Project().Site_ids + "))"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Supplier_ids)) { where += " and (Supplier_id in (" + EX_Admin.Project().Supplier_ids + "))"; } order = B_Lebi_Order.GetModel(where); if (order == null) { Response.Write(Tag("参数错误")); Response.End(); return; } pros = B_Lebi_Order_Product.GetList("Order_id=" + order.id + "", ""); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("order_shipping", "订单发货")) { WindowNoPower(); } int id = RequestTool.RequestInt("id", 0); torder = B_Lebi_Transport_Order.GetModel(id); if (torder == null) { Response.Write(Tag("参数错误")); Response.End(); return; } model = B_Lebi_Order.GetModel(torder.Order_id); tps = new List <TransportProduct>(); JavaScriptSerializer jss = new JavaScriptSerializer(); try { tps = jss.Deserialize <List <TransportProduct> >(torder.Product); } catch (Exception) { tps = new List <TransportProduct>(); } }
/// <summary> /// 订单发货 /// </summary> /// <param name="user"></param> /// <param name="order"></param> /// <param name="torder"></param> public static void Push_ordershipping(Lebi_User user, Lebi_Order order, Lebi_Transport_Order torder) { BaseConfig conf = ShopCache.GetBaseConfig(); if (conf.APPPush_sendmode.Contains("ordershipping")) { if (user.Language == "") { user.Language = Language.Languages().FirstOrDefault().Code; } string list = ""; List <TransportProduct> tps = new List <TransportProduct>(); JavaScriptSerializer jss = new JavaScriptSerializer(); try { tps = jss.Deserialize <List <TransportProduct> >(torder.Product); } catch (Exception) { tps = new List <TransportProduct>(); } foreach (TransportProduct pro in tps) { list += "" + Language.Tag("商品编号", user.Language) + ":" + pro.Product_Number + ";" + Language.Tag("商品", user.Language) + ":" + Language.Content(pro.Product_Name, user.Language) + ";" + Language.Tag("发货数量", user.Language) + ":" + pro.Count + ";"; } string content = Language.Content(conf.SMSTPL_ordershipping, user.Language); content = ReplaceSMSTag(content, user, conf); content = content.Replace("{$OrderNO}", order.Code); content = content.Replace("{$ExpressCompany}", torder.Transport_Name); content = content.Replace("{$ExpressNumber}", torder.Code); content = content.Replace("{$Order}", list); Push(user.Device_system, user.Device_id, content); } }
/// <summary> /// 收货确认后,更新订单产品的收货数量 /// </summary> /// <param name="torder"></param> public static void UpdateShouHuoCount(Lebi_Transport_Order torder) { if (torder.Type_id_TransportOrderStatus != 223) { return; } Lebi_Order order = B_Lebi_Order.GetModel(torder.Order_id); if (order == null) { return; } List <Lebi_Order_Product> ops = B_Lebi_Order_Product.GetList("Order_id=" + torder.Order_id + "", ""); List <Lebi_Transport_Order> torders = B_Lebi_Transport_Order.GetList("Order_id=" + torder.Order_id + " and Type_id_TransportOrderStatus=223", ""); //bool shouhuoall = true; foreach (Lebi_Order_Product op in ops) { //op.Count_Received = 0; foreach (Lebi_Transport_Order to in torders) { foreach (TransportProduct p in GetTransportProduct(to)) { if (p.Product_id == op.Product_id) { op.Count_Received = op.Count_Received + p.Count; if (op.Count_Shipped < op.Count_Received) { op.Count_Received = op.Count_Shipped; } break; } } } //if (op.Count_Received < op.Count_Shipped) // shouhuoall = false; B_Lebi_Order_Product.Update(op);//更新收货数量 } order.IsReceived = 1; order.IsReceived_All = 1; ops = B_Lebi_Order_Product.GetList("Order_id=" + torder.Order_id + "", ""); foreach (Lebi_Order_Product op in ops) { if (op.Count_Received < op.Count_Shipped) { order.IsReceived_All = 0; } } order.Time_Received = System.DateTime.Now; B_Lebi_Order.Update(order); if (order.IsReceived_All == 1)//全部收货完成 { Order.Received(order); } }
protected void Page_Load(object sender, EventArgs e) { int id = RequestTool.RequestInt("id", 0); torder = B_Lebi_Transport_Order.GetModel(id); if (torder == null) { Response.Write(Tag("参数错误")); Response.End(); return; } order = B_Lebi_Order.GetModel(torder.Order_id); pros = B_Lebi_Order_Product.GetList("Order_id=" + order.id + "", ""); }
/// <summary> /// 返回货运单中的商品数据 /// </summary> /// <param name="torder"></param> /// <returns></returns> public static List <TransportProduct> GetTransportProduct(Lebi_Transport_Order torder) { List <TransportProduct> tps = new List <TransportProduct>(); JavaScriptSerializer jss = new JavaScriptSerializer(); try { tps = jss.Deserialize <List <TransportProduct> >(torder.Product); } catch (Exception) { tps = new List <TransportProduct>(); } return(tps); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("order_shipping", "订单发货")) { WindowNoPower(); } int id = RequestTool.RequestInt("id", 0); torder = B_Lebi_Transport_Order.GetModel(id); if (torder == null) { Response.Write(Tag("参数错误")); Response.End(); return; } log = EX_Area.GetKuaiDi100(torder); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("order_shipping", "订单发货")) { WindowNoPower(); } int id = RequestTool.RequestInt("id", 0); torder = B_Lebi_Transport_Order.GetModel(id); if (torder == null) { Response.Write(Tag("参数错误")); Response.End(); return; } string where = "Order_id = " + torder.Order_id + ""; if (!string.IsNullOrEmpty(EX_Admin.Project().Site_ids)) { where += " and (Site_id in (" + EX_Admin.Project().Site_ids + "))"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Supplier_ids)) { where += " and (Supplier_id in (" + EX_Admin.Project().Supplier_ids + "))"; } model = B_Lebi_Order.GetModel(where); if (model == null) { Response.Write(Tag("参数错误")); Response.End(); return; } tps = new List <TransportProduct>(); JavaScriptSerializer jss = new JavaScriptSerializer(); try { tps = jss.Deserialize <List <TransportProduct> >(torder.Product); } catch (Exception) { tps = new List <TransportProduct>(); } }
/// <summary> /// 订单收货 /// </summary> /// <param name="user"></param> /// <param name="torder"></param> public static void SendSMS_orderrecive(Lebi_User user, Lebi_Transport_Order torder) { BaseConfig conf = ShopCache.GetBaseConfig(); int IsAdminSms = 0; int IsSupplierSms = 0; if (conf.SMS_sendmode.Contains("SMSTPL_Admin_orderrecive")) { IsAdminSms = 1; } Lebi_Order order = B_Lebi_Order.GetModel("id=" + torder.Order_id + ""); if (order.Supplier_id > 0) { if (ShopCache.GetBaseConfig_Supplier(order.Supplier_id).SMS_sendmode.Contains("SMSTPL_Admin_orderrecive")) { IsSupplierSms = 1; } } if (IsAdminSms == 0 && IsSupplierSms == 0) { return; } if (user.Language == "") { user.Language = Language.Languages().FirstOrDefault().Code; } string Admin_content = Language.Content(conf.SMSTPL_Admin_orderrecive, user.Language); Admin_content = ReplaceSMSTag(Admin_content, user, conf); Admin_content = Admin_content.Replace("{$OrderNO}", order.Code); if (IsAdminSms == 1) { Send(conf.SMS_reciveno, Admin_content); } if (IsSupplierSms == 1) { BaseConfig_Supplier config_supplier = ShopCache.GetBaseConfig_Supplier(order.Supplier_id); Send(config_supplier.SMS_reciveno, Admin_content); } }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("order_shipping", "订单发货")) { WindowNoPower(); } int id = RequestTool.RequestInt("id", 0); model = B_Lebi_Order.GetModel(id); if (model == null) { model = new Lebi_Order(); } pros = B_Lebi_Order_Product.GetList("Order_id=" + model.id + "", ""); transport_order = B_Lebi_Transport_Order.GetModel("Order_id = " + id); if (transport_order == null) { transport_order = new Lebi_Transport_Order(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Power("supplier_order_edit", "编辑订单")) { WindowNoPower(); } int id = RequestTool.RequestInt("id", 0); torder = B_Lebi_Transport_Order.GetModel(id); if (torder == null) { Response.Write(Tag("参数错误")); Response.End(); return; } order = B_Lebi_Order.GetModel(torder.Order_id); if (order.Supplier_id != CurrentSupplier.id) { Response.Write(Tag("参数错误")); Response.End(); return; } pros = B_Lebi_Order_Product.GetList("Order_id=" + order.id + "", ""); }
/// <summary> /// 订单发货通知-不更新库存 /// </summary> public void mSndGoods() { //OrderID 订单编号 //OrderNO 原始订单编号 //CustomerID 客户网名 //SndStyle 发货方式 //BillID 货运单号 //SndDate 发货时间 string OrderID = RequestTool.RequestString("OrderID"); string OrderNO = RequestTool.RequestString("OrderNO"); string CustomerID = RequestTool.RequestString("CustomerID"); string SndStyle = RequestTool.RequestString("SndStyle"); string BillID = RequestTool.RequestString("BillID"); string SndDate = RequestTool.RequestString("SndDate"); Lebi_Order model = B_Lebi_Order.GetModel("Code=lbsql{'" + OrderNO + "'}"); Lebi_Language_Code lang = Language.DefaultLanguage(); string res = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n"; if (model == null) { res += "<rsp><result>0</result><cause>无此单号</cause></rsp>"; Response.Write(res); return; } Lebi_Transport tran = B_Lebi_Transport.GetModel("[Name]=lbsql{'" + SndStyle + "'}"); if (tran == null) { tran = new Lebi_Transport(); } Lebi_Transport_Order torder = new Lebi_Transport_Order(); torder.Code = BillID; torder.Order_id = model.id; torder.T_Address = model.T_Address; torder.T_Email = model.T_Email; torder.T_MobilePhone = model.T_MobilePhone; torder.T_Name = model.T_Name; torder.T_Phone = model.T_Phone; torder.Transport_Code = tran == null ? model.Transport_Code : tran.Code; torder.Transport_id = tran == null ? model.Transport_id : tran.id; torder.Transport_Name = tran == null ? model.Transport_Name : tran.Name; torder.User_id = model.User_id; List <TransportProduct> tps = new List <TransportProduct>(); TransportProduct tp; List <Lebi_Order_Product> pros = B_Lebi_Order_Product.GetList("Order_id=" + model.id + "", ""); bool isfahuo_all = true; foreach (Lebi_Order_Product pro in pros) { tp = new TransportProduct(); tp.Count = pro.Count; tp.ImageBig = pro.ImageBig; tp.ImageMedium = pro.ImageMedium; tp.ImageOriginal = pro.ImageOriginal; tp.ImageSmall = pro.ImageSmall; tp.Product_Number = pro.Product_Number; tp.Product_id = pro.Product_id; tp.Product_Name = pro.Product_Name; tps.Add(tp); pro.Count_Shipped = pro.Count; B_Lebi_Order_Product.Update(pro); //更新库存 Lebi_Product product = B_Lebi_Product.GetModel(pro.Product_id); EX_Product.ProductStock_Change(product, (0 - pro.Count), 302, model); } JavaScriptSerializer jss = new JavaScriptSerializer(); torder.Product = jss.Serialize(tps); torder.Type_id_TransportOrderStatus = 220;//默认状态:在途 B_Lebi_Transport_Order.Add(torder); model.IsShipped = 1; model.IsShipped_All = isfahuo_all ? 1 : 0; model.Time_Shipped = System.DateTime.Now;; B_Lebi_Order.Update(model); Log.Add("订单发货-网站管家", "Order", model.id.ToString()); //发送邮件 if (ShopCache.GetBaseConfig().MailSign.ToLower().Contains("dingdanfahuo")) { Lebi_User user = B_Lebi_User.GetModel(model.User_id); Email.SendEmail_ordershipping(user, model, torder); } res += "<rsp><result>1</result></rsp>"; Response.Write(res); Log.Add("订单编号:" + OrderNO + "--" + res, "网店管家同步发货", ""); }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Lebi_Transport_Order model) { return(D_Lebi_Transport_Order.Instance.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public static void Update(Lebi_Transport_Order model) { D_Lebi_Transport_Order.Instance.Update(model); }
/// <summary> /// 退货单发货 /// </summary> public void torder_shipping() { int order_id = RequestTool.RequestInt("order_id", 0); Lebi_Order model = B_Lebi_Order.GetModel("User_id=" + CurrentUser.id + " and id = " + order_id); if (model == null) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } if (model.IsVerified != 1) { Response.Write("{\"msg\":\"" + Tag("请等待客服人员确认") + "\"}"); return; } Lebi_Transport_Order torder = B_Lebi_Transport_Order.GetModel("Order_id=" + model.id + ""); if (torder != null) { torder.Code = RequestTool.RequestSafeString("Code"); torder.Transport_Name = RequestTool.RequestSafeString("Transport_Name"); B_Lebi_Transport_Order.Update(torder); } else { Lebi_Supplier supplier = B_Lebi_Supplier.GetModel(model.Supplier_id); if (supplier == null) { supplier = new Lebi_Supplier(); } torder = new Lebi_Transport_Order(); torder.Code = RequestTool.RequestSafeString("Code"); torder.Order_id = model.id; torder.T_Address = model.T_Address; torder.T_Email = model.T_Email; torder.T_MobilePhone = model.T_MobilePhone; torder.T_Name = model.T_Name; torder.T_Phone = model.T_Phone; //torder.Transport_Code = model.Transport_Code; //torder.Transport_id = model.Transport_id; torder.Transport_Name = RequestTool.RequestSafeString("Transport_Name"); torder.User_id = model.User_id; torder.Supplier_id = supplier.id; torder.Supplier_SubName = supplier.SubName; List <TransportProduct> tps = new List <TransportProduct>(); TransportProduct tp; List <Lebi_Order_Product> pros = B_Lebi_Order_Product.GetList("Order_id=" + model.id + "", ""); foreach (Lebi_Order_Product pro in pros) { tp = new TransportProduct(); tp.Count = pro.Count; tp.ImageBig = pro.ImageBig; tp.ImageMedium = pro.ImageMedium; tp.ImageOriginal = pro.ImageOriginal; tp.ImageSmall = pro.ImageSmall; tp.Product_Number = pro.Product_Number; tp.Product_id = pro.Product_id; tp.Product_Name = pro.Product_Name; tps.Add(tp); pro.Count_Shipped = pro.Count; B_Lebi_Order_Product.Update(pro); } JavaScriptSerializer jss = new JavaScriptSerializer(); torder.Product = jss.Serialize(tps); torder.Type_id_TransportOrderStatus = 220;//默认状态:在途 B_Lebi_Transport_Order.Add(torder); model.IsShipped = 1; model.IsShipped_All = 1; B_Lebi_Order.Update(model); } Response.Write("{\"msg\":\"OK\"}"); }
/// <summary> /// 返回快递100物流数据 /// </summary> /// <param name="to"></param> /// <returns></returns> public static KuaiDi100 GetKuaiDi100(Lebi_Transport_Order torder) { string json; KuaiDi100 log = new KuaiDi100(); BaseConfig conf = ShopCache.GetBaseConfig(); JavaScriptSerializer jss = new JavaScriptSerializer(); if (torder.Type_id_TransportOrderStatus == 223) { json = torder.Log; log = jss.Deserialize <KuaiDi100>(json); } else { try { string url = "http://www.kuaidi100.com/api?id=" + conf.KuaiDi100 + "&com=" + torder.Transport_Code + "&nu=" + torder.Code + "&show=0&muti=1"; json = HtmlEngine.CetHtml(url); log = jss.Deserialize <KuaiDi100>(json); switch (log.state) { case "1": torder.Type_id_TransportOrderStatus = 221; break; case "2": torder.Type_id_TransportOrderStatus = 222; break; case "3": torder.Type_id_TransportOrderStatus = 223; try { torder.Time_Received = Convert.ToDateTime(log.data.FirstOrDefault().time); } catch { torder.Time_Received = System.DateTime.Now; } break; case "4": torder.Type_id_TransportOrderStatus = 224; break; //default: // //torder.Type_id_TransportOrderStatus = 220; // break; } if (log.message != "ok") { //没有成功获取到json数据 url = "http://www.kuaidi100.com/applyurl?key=" + conf.KuaiDi100 + "&com=" + torder.Transport_Code + "&nu=" + torder.Code; string html = HtmlEngine.CetHtml(url); //html = HtmlEngine.CetHtml(html); torder.HtmlLog = html; } torder.Log = json; B_Lebi_Transport_Order.Update(torder); UpdateShouHuoCount(torder); } catch (Exception) { log = new KuaiDi100(); } } if (log == null) { log = new KuaiDi100(); } if (log.data == null) { log.data = new List <KuaiDi100.KuaiDi100data>(); } return(log); }
/// <summary> /// 安全方式绑定表单数据 /// </summary> public static Lebi_Transport_Order SafeBindForm(Lebi_Transport_Order model) { return(D_Lebi_Transport_Order.Instance.SafeBindForm(model)); }