protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { if (CurrentUser.id == 0) { Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + "")); } LoadTheme(themecode, siteid, languagecode, pcode); CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserOrderDetails'"); id = Rint("id"); order = B_Lebi_Order.GetModel("User_id = " + CurrentUser.id + " and id = " + id + ""); if (order == null) { PageError(); } if (order.User_id != CurrentUser.id) { PageError(); } if (order.Type_id_OrderType == 212) { Response.Redirect(URL("P_UserReturnDetails", id)); } path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserOrders", "") + "\"><span>" + Tag("我的订单") + "</span></a><em>»</em><a href=\"" + URL("P_UserOrderDetails", id) + "\"><span>" + Tag("订单") + ":" + order.Code + "</span></a>"; CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserOrderDetails'"); id = Rint_Para("0"); comments = B_Lebi_Comment.GetList("TableName='Order' and Keyid=" + order.id, "id desc"); transport_orders = B_Lebi_Transport_Order.GetList("Order_id=" + order.id, "id desc"); bills = B_Lebi_Bill.GetList("Order_id=" + order.id, "id desc"); order_products = B_Lebi_Order_Product.GetList("Order_id=" + order.id, "id desc"); pay = B_Lebi_Pay.GetModel(order.Pay_id); if (pay == null) { pay = new Lebi_Pay(); } }
/// <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 override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { if (CurrentUser.id == 0) { Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + "")); } LoadTheme(themecode, siteid, languagecode, pcode); if (SYS.IsClosetuihuo == "1") { PageError(); } CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserReturnApply'"); path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturn", "" + id + "") + "\"><span>" + Tag("退货订单") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturnApply", "") + "\"><span>" + Tag("退货申请") + "</span></a>"; CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserReturnApply'"); id = Rint_Para("0"); order = B_Lebi_Order.GetModel("User_id = " + CurrentUser.id + " and id = " + id + ""); if (order == null) { PageError(); } if (order.User_id != CurrentUser.id) { PageError(); } where = "Order_id=" + order.id + ""; order_products = B_Lebi_Order_Product.GetList(where, "id desc"); if (order.Supplier_id > 0) { Lebi_Supplier supplier = B_Lebi_Supplier.GetModel(order.Supplier_id); if (supplier != null) { shouhuoren = supplier.RealName; shouhuodizhi = supplier.Address; shouhuodianhua = supplier.Phone; shouhuoyoubian = supplier.Postalcode; } } else { Lebi_Express_Shipper shipper = B_Lebi_Express_Shipper.GetList("", "Sort desc", 1, 1).FirstOrDefault(); if (shipper != null) { shouhuoren = shipper.UserName; shouhuodizhi = shipper.Address; shouhuodianhua = shipper.Tel; shouhuoyoubian = shipper.ZipCode; } } }
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { LoadTheme(themecode, siteid, languagecode, pcode); path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_Pay", "") + "\"><span>" + Tag("在线付款") + "</span></a>"; order_id = Rint("order_id"); order = B_Lebi_Order.GetModel(order_id); if (order == null) { PageError(); } if (order.User_id != CurrentUser.id || order.IsInvalid == 1 || order.IsPaid == 1) { PageError(); } else { if (order.Type_id_OrderType == 215) { List <Lebi_Order> ors = B_Lebi_Order.GetList("Order_id=" + order.id + "", ""); decimal moeny = 0; foreach (Lebi_Order or in ors) { moeny += or.Money_Pay; } order.Money_Pay = moeny; B_Lebi_Order.Update(order); } } string onpaywhere = "IsUsed=1 and parentid=0"; if (CurrentSite.IsMobile == 1) { onpaywhere += " and (showtype='' or showtype like '%wap%')"; } else { onpaywhere += " and (showtype='' or showtype like '%web%')"; } onlinepays = B_Lebi_OnlinePay.GetList(onpaywhere, "Sort desc"); order_products = B_Lebi_Order_Product.GetList("Order_id = " + order.id, "id desc"); }
/// <summary> /// 返回成本 /// </summary> /// <param name="where"></param> /// <returns></returns> public static decimal Money_CostCount(string where) { List <Lebi_Order_Product> models = B_Lebi_Order_Product.GetList("Order_id in (select id from Lebi_Order where " + where + ") and Price_Cost = 0", ""); if (models.Count > 0) { foreach (Lebi_Order_Product m in models) { m.Price_Cost = Shop.Bussiness.EX_Product.GetProduct(m.Product_id).Price_Cost; B_Lebi_Order_Product.Update(m); } } string sum = B_Lebi_Order_Product.GetValue("sum(Price_Cost * Count)", "Order_id in (select id from Lebi_Order where " + where + ")"); if (String.IsNullOrEmpty(sum)) { sum = 0.ToString(); } return(Convert.ToDecimal(sum)); }
/// <summary> /// 单品代理佣金 /// </summary> private void AgentProductMoney() { List <Lebi_Order_Product> Products = B_Lebi_Order_Product.GetList("Order_id=" + Order.id + "", ""); if (Products == null) { return; } int pid = 0; decimal money = 0; Lebi_Agent_Product_User auser; foreach (Lebi_Order_Product model in Products) { Lebi_Product pro = B_Lebi_Product.GetModel(model.Product_id); pid = pro.Product_id == 0 ? pro.id : pro.Product_id; Lebi_Agent_Product apro = B_Lebi_Agent_Product.GetModel("Product_id=" + pid + ""); if (apro == null) { continue; } auser = B_Lebi_Agent_Product_User.GetModel("User_id=" + apro.User_id + " and IsFailure=0"); if (auser == null) { continue; } if (auser.Time_end.Date < System.DateTime.Now.Date) { continue; } Lebi_User user = B_Lebi_User.GetModel(apro.User_id); if (user == null) { continue; } money = model.Price * model.Count * auser.Commission / 100; AddMoney(money, user, 392, 0, model.Product_id, pid, pro.Number); } }
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { if (CurrentUser.id == 0) { Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + "")); } LoadTheme(themecode, siteid, languagecode, pcode); CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserReturnShip'"); id = Rint("id"); tid = Rint("id"); order = B_Lebi_Order.GetModel("User_id = " + CurrentUser.id + " and id = " + id + ""); if (order == null) { PageError(); } if (order.User_id != CurrentUser.id) { PageError(); } path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturn", "" + id + "") + "\"><span>" + Tag("退货订单") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturnDetails", "" + id + "") + "\"><span>" + Tag("订单") + ":" + order.Code + "</span></a><em>»</em><a href=\"" + URL("P_UserReturnShip", "") + "\"><span>" + Tag("发货") + "</span></a>"; where = "Order_id=" + order.id + ""; order_products = B_Lebi_Order_Product.GetList(where, "id desc"); }
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { if (CurrentUser.id == 0) { Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + "")); } LoadTheme(themecode, siteid, languagecode, pcode); path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserComment", "") + "\"><span>" + Tag("商品评价") + "</span></a>"; //key={0}&type={1}&status={2}&dateFrom={3}&dateTo={4} key = Rstring("key"); type = Rint("type"); status = Rint("status"); dateFrom = Rstring("dateFrom"); dateTo = Rstring("dateTo"); DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); pageindex = RequestTool.RequestInt("page", 1); types = B_Lebi_Type.GetList("Class='CommentStatus'", "sort desc"); if (type == 0) { where = "Parentid = 0 and TableName = 'Product' and User_id=" + CurrentUser.id + ""; if (key != "") { where += " and (Content like lbsql{'%" + key + "%'})"; } if (dateFrom != "" && dateTo != "") { where += " and (datediff(d,Time_Add,'" + lbsql_dateFrom + "')<=0 and datediff(d,Time_Add,'" + lbsql_dateTo + "')>=0)"; } if (status > 0) { where += " and (Status = " + status + ")"; } comments = B_Lebi_Comment.GetList(where, "id desc", PageSize, pageindex); foreach (Shop.Model.Lebi_Comment c in comments) { c.IsRead = 1; B_Lebi_Comment.Update(c); } int recordCount = B_Lebi_Comment.Counts(where); //string url = URL("P_UserComment", key + "," + type + "," + status + "," + dateFrom + "," + dateTo + ",{0}"); //PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, page, PageSize, recordCount, CurrentLanguage); PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&key=" + key + "&type=" + type + "&status=" + status + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage); } else { //待评价商品 where = "IsCommented = 0 and User_id=" + CurrentUser.id + ""; if (key != "") { where += " and (Product_Name like lbsql{'%" + key + "%'})"; } if (dateFrom != "" && dateTo != "") { where += " and (datediff(d,Time_Add,'" + lbsql_dateFrom + "')<=0 and datediff(d,Time_Add,'" + lbsql_dateTo + "')>=0)"; } order_products = B_Lebi_Order_Product.GetList(where, "id desc", PageSize, pageindex); int recordCount = B_Lebi_Order_Product.Counts(where); string url = URL("P_UserComment", key + "," + type + "," + status + "," + dateFrom + "," + dateTo + ",{0}"); PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&key=" + key + "&type=" + type + "&status=" + status + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage); } }
/// <summary> /// 订单提交 /// </summary> /// <param name="user"></param> /// <param name="order"></param> public static void SendSMS_ordersubmit(Lebi_User user, Lebi_Order order) { BaseConfig conf = ShopCache.GetBaseConfig(); int IsUserSms = 0; int IsUserSms2 = 0; int IsAdminSms = 0; int IsSupplierSms = 0; if (conf.SMS_sendmode.Contains("SMSTPL_ordersubmit")) { IsUserSms = 1; } if (conf.SMS_sendmode.Contains("SMSTPL_Admin_ordersubmit")) { IsAdminSms = 1; } if (conf.SMS_sendmode.Contains("SMSTPL_orderpickup")) { IsUserSms2 = 1; } if (order.Supplier_id > 0) { if (ShopCache.GetBaseConfig_Supplier(order.Supplier_id).SMS_sendmode.Contains("SMSTPL_Admin_ordersubmit")) { IsSupplierSms = 1; } } if (IsUserSms == 0 && IsUserSms2 == 0 && IsAdminSms == 0 && IsSupplierSms == 0) { return; } if (user.Language == "") { user.Language = Language.Languages().FirstOrDefault().Code; } string list = ""; List <Lebi_Order_Product> pros = B_Lebi_Order_Product.GetList("Order_id=" + order.id + "", ""); foreach (Lebi_Order_Product pro in pros) { 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 + ";"; } if (IsUserSms == 1) { string content = Language.Content(conf.SMSTPL_ordersubmit, user.Language); content = ReplaceSMSTag(content, user, conf); content = content.Replace("{$OrderNO}", order.Code); content = content.Replace("{$Money}", Language.FormatMoney(order.Money_Order, order.Currency_Code)); content = content.Replace("{$Order}", list); Send(order.T_MobilePhone, content); } if (IsAdminSms == 1 || IsSupplierSms == 1) { string Admin_content = Language.Content(conf.SMSTPL_Admin_ordersubmit, user.Language); Admin_content = ReplaceSMSTag(Admin_content, user, conf); Admin_content = Admin_content.Replace("{$OrderNO}", order.Code); Admin_content = Admin_content.Replace("{$Money}", Language.FormatMoney(order.Money_Order, order.Currency_Code)); Admin_content = Admin_content.Replace("{$Order}", list); string transport = "order.Transport_Name"; if (order.PickUp_Name != "") { transport += "|" + order.PickUp_Name + "|" + order.PickUp_Date.ToString("yyyy-MM-dd"); } Admin_content = Admin_content.Replace("{$Transport}", transport); 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); } } if (IsUserSms2 == 1) { string content = Language.Content(conf.SMSTPL_orderpickup, user.Language); content = ReplaceSMSTag(content, user, conf); content = content.Replace("{$OrderNO}", order.Code); content = content.Replace("{$Money}", Language.FormatMoney(order.Money_Order, order.Currency_Code)); content = content.Replace("{$Order}", list); content = content.Replace("{$PickUpStation}", order.PickUp_Name); content = content.Replace("{$PickUpTime}", order.PickUp_Date.ToString("yyyy-MM-dd")); Send(order.T_MobilePhone, content); } }