protected void Page_Load(object sender, EventArgs e) { Random Random = new Random(); randnum = RequestTool.RequestInt("randnum", 0); id = RequestTool.RequestInt("id", 0); if (id == 0 || (id > 0 && randnum > 0)) { if (!EX_Admin.Power("product_add", "添加商品")) { PageNoPower(); } } else { if (!EX_Admin.Power("product_edit", "编辑商品")) { PageNoPower(); } } action = RequestTool.RequestInt("action", 1); model = B_Lebi_Product.GetModel(id); if (model == null) { model = new Lebi_Product(); model.Type_id_ProductType = 320; } wap = Ishavewap(); StepPrices = EX_Product.StepPrice(model.StepPrice); if (StepPrices == null) { StepPrices = new List <ProductStepPrice>(); } UserLevelPrices = EX_Product.UserLevelPrice(model.UserLevelPrice); if (UserLevelPrices == null) { UserLevelPrices = new List <ProductUserLevelPrice>(); } UserLevelCounts = EX_Product.UserLevelCount(model.UserLevelCount); if (UserLevelCounts == null) { UserLevelCounts = new List <ProductUserLevelCount>(); } userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); if (model.IsCombo == 1) { comboProducts = B_Lebi_Product_Combo.GetList("Product_id=" + model.id + "", ""); } else { comboProducts = new List <Lebi_Product_Combo>(); } }
/// <summary> /// 晒单评论 /// </summary> public void Comment_reply() { int id = RequestTool.RequestInt("id", 0); int Product_id = 0; Lebi_Product product = B_Lebi_Product.GetModel(id); if (product != null) { Product_id = product.Product_id; } Lebi_Comment pmodel = B_Lebi_Comment.GetModel(id); if (pmodel == null) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } string Content = RequestTool.RequestSafeString("comment"); if (Content == "") { Response.Write("{\"msg\":\"" + Tag("内容不能为空") + "\"}"); return; } Lebi_Comment model = new Lebi_Comment(); model.TableName = "Product"; model.Keyid = id; //model.Admin_UserName = CurrentUser.NickName; model.Admin_id = 0; model.User_id = CurrentUser.id; model.User_UserName = CurrentUser.NickName; model.Content = Content; model.Parentid = id; model.Status = 280; model.Time_Add = System.DateTime.Now; model.Language_Code = CurrentLanguage.Code; model.Product_id = Product_id; model.IsRead = 0; model.Supplier_id = product.Supplier_id; if (!Comment.CheckSafeWord(model.Content)) { Response.Write("{\"msg\":\"" + Tag("内容中包含敏感词") + "\"}"); return; } B_Lebi_Comment.Add(model); //发送邮件 if (ShopCache.GetBaseConfig().AdminMailSign.ToLower().Contains("comment")) { Lebi_User user = B_Lebi_User.GetModel(CurrentUser.id); Email.SendEmail_comment(user, model); } Response.Write("{\"msg\":\"OK\"}"); }
protected void Page_Load(object sender, EventArgs e) { userlevelid = RequestTool.RequestInt("userlevelid"); key = RequestTool.RequestString("key"); productid = RequestTool.RequestInt("productid"); product = B_Lebi_Product.GetModel(productid); if (product == null) { product = new Lebi_Product(); } }
/// <summary> /// 收藏夹批量添加购物车 /// </summary> public void LikeToBasket() { string ids = RequestTool.RequestSafeString("id"); string mes = ""; if (ids == "") { Response.Write("{\"msg\":\"" + Tag("请先选择商品") + "\"}"); return; } else { List <Lebi_User_Product> models = B_Lebi_User_Product.GetList("(Type_id_UserProductType=141 or Type_id_UserProductType=144) and User_id=" + CurrentUser.id + " and id in (lbsql{" + ids + "})", ""); foreach (Lebi_User_Product model in models) { //<-{ 判断收藏夹商品是否为上架状态 by lebi.kingdge 2015-02-10 Lebi_Product Product = B_Lebi_Product.GetModel("id = " + model.Product_id + " and Type_id_ProductStatus = 101"); if (Product == null) { Response.Write("{\"msg\":\"" + Lang(Product.Name) + " " + Tag("该商品已经下架") + "\"}"); return; } //}-> int num = model.count; int levelcount = ProductLevelCount(Product); if (num < levelcount) { num = levelcount; } Lebi_User_Product updatemodel = B_Lebi_User_Product.GetModel("User_id=" + CurrentUser.id + " and product_id=" + model.Product_id + " and type_id_UserProductType=142"); if (updatemodel != null) { if (updatemodel.count < num) { updatemodel.count = model.count; B_Lebi_User_Product.Update(updatemodel); } } else { model.Type_id_UserProductType = 142; model.count = num; B_Lebi_User_Product.Add(model); } } mes = Tag("商品已加入购物车") + "<div>" + Tag("数量") + " <span>" + Basket_Product_Count() + "</span> " + Tag("件") + " <span>" + FormatMoney(Basket_Product_Price()) + "</span></div><div><a href='" + URL("P_Basket", "") + "' class='btn btn-7'><s></s>" + Tag("查看购物车") + "</a> <a href='javascript:void(0)' onclick='cloesedialog();' class='btn btn-11'><s></s>" + Tag("关闭") + "</a></div>"; } Response.Write("{\"msg\":\"OK\",\"count\":\"" + Basket_Product_Count() + "\",\"amount\":\"" + FormatMoney(Basket_Product_Price()) + "\",\"mes\":\"" + mes + "\",\"url\":\"" + URL("P_AddToBasket", "") + "\"}"); }
protected void Page_Load(object sender, EventArgs e) { pid = RequestTool.RequestInt("pid", 0); tid = RequestTool.RequestInt("tid", 0); randnum = RequestTool.RequestInt("randnum", 0); mutiadd_property = RequestTool.RequestInt("mutiadd_property", 0); //1批量添加规格 0否 if (pid == 0 || (pid > 0 && randnum > 0)) { if (!EX_Admin.Power("product_add", "添加商品")) { WindowNoPower(); } } else { if (!EX_Admin.Power("product_edit", "编辑商品")) { WindowNoPower(); } } if (pid > 0 && randnum > 0) { modelp = B_Lebi_Product.GetModel(randnum); } else { modelp = B_Lebi_Product.GetModel(pid); } if (modelp == null) { modelp = new Lebi_Product(); modelp.ProPertyMain = RequestTool.RequestInt("ProPertyMain", 0); modelp.ProPerty131 = RequestTool.RequestString("ProPerty131"); } modelLan = Language.DefaultLanguage(); string where = ""; if (pid == 0 || (pid > 0 && randnum > 0)) { where = "Product_id=" + randnum + " and Product_id!=0"; } else { where = "Product_id=" + pid + " and Product_id!=0"; } models = B_Lebi_Product.GetList(where, ""); }
protected void Page_Load(object sender, EventArgs e) { pid = RequestTool.RequestInt("pid", 0); tid = RequestTool.RequestInt("tid", 0); randnum = RequestTool.RequestInt("randnum", 0); if (pid == 0 || (pid > 0 && randnum > 0)) { if (!Power("supplier_product_add", "添加商品")) { WindowNoPower(); } } else { if (!Power("supplier_product_edit", "编辑商品")) { WindowNoPower(); } } if (pid > 0 && randnum > 0) { modelp = B_Lebi_Product.GetModel("(IsDel!=1 or IsDel is null) and Supplier_id = " + CurrentSupplier.id + " and id = " + randnum); } else { modelp = B_Lebi_Product.GetModel("(IsDel!=1 or IsDel is null) and Supplier_id = " + CurrentSupplier.id + " and id = " + pid); } if (modelp == null) { modelp = new Lebi_Product(); modelp.ProPertyMain = RequestTool.RequestInt("ProPertyMain", 0); modelp.ProPerty131 = RequestTool.RequestString("ProPerty131"); } modelLan = Language.DefaultLanguage(); string where = "(IsDel!=1 or IsDel is null)"; if (pid == 0 || (pid > 0 && randnum > 0)) { where += " and Supplier_id = " + CurrentSupplier.id + " and Product_id=" + randnum + " and Product_id!=0"; } else { where += " and Product_id=" + pid + " and Product_id!=0"; } models = B_Lebi_Product.GetList(where, ""); }
protected void Page_Load(object sender, EventArgs e) { Random Random = new Random(); randnum = RequestTool.RequestInt("randnum", 0); id = RequestTool.RequestInt("id", 0); if (id == 0 || (id > 0 && randnum > 0)) { if (!Power("supplier_product_add", "添加商品")) { PageNoPower(); } } else { if (!Power("supplier_product_edit", "编辑商品")) { PageNoPower(); } } action = RequestTool.RequestInt("action", 1); model = B_Lebi_Product.GetModel("Supplier_id = " + CurrentSupplier.id + " and (IsDel!=1 or IsDel is null) and id = " + id); if (model == null) { model = new Lebi_Product(); model.Type_id_ProductType = 320; } wap = Ishavewap(); StepPrices = EX_Product.StepPrice(model.StepPrice); if (StepPrices == null) { StepPrices = new List <ProductStepPrice>(); } UserLevelPrices = EX_Product.UserLevelPrice(model.UserLevelPrice); if (UserLevelPrices == null) { UserLevelPrices = new List <ProductUserLevelPrice>(); } UserLevelCounts = EX_Product.UserLevelCount(model.UserLevelCount); if (UserLevelCounts == null) { UserLevelCounts = new List <ProductUserLevelCount>(); } userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); }
public void LoadPage() { LoadTheme(); PageSize = RequestTool.RequestInt("Count", 20); id = RequestTool.RequestInt("id", 0); tag = RequestTool.RequestString("tag"); tag = tag.Replace(",", ","); if (tag == "" || tag == null) { tag = "NO TAGS"; } string where = ""; if (tag.IndexOf(",") > -1) { string[] tagsArr; tagsArr = tag.Split(new char[1] { ',' }); foreach (string tags in tagsArr) { if (where == "") { where = "Name like lbsql{'%" + tags + "%'}"; } else { where += " or Name like lbsql{'%" + tags + "%'}"; } } } else { where = "Name like lbsql{'%" + tag + "%'}"; } where = " (" + where + ") and " + ProductWhere; //Response.Write(where); //Response.End(); //return; LB.DataAccess.SQLPara sp = new LB.DataAccess.SQLPara(where, " Sort desc,id desc", "*"); products = B_Lebi_Product.GetList(sp, PageSize, pageindex); }
/// <summary> /// 发表商品咨询 /// </summary> public void Ask_Write() { int id = RequestTool.RequestInt("id", 0); int Product_id = 0; Lebi_Product product = B_Lebi_Product.GetModel(id); if (product != null) { Product_id = product.Product_id; } Lebi_Comment model = new Lebi_Comment(); model.TableName = "Product_Ask"; model.Keyid = id; model.Admin_UserName = "******"; model.Admin_id = 0; model.User_id = CurrentUser.id; model.User_UserName = CurrentUser.UserName; model.Content = RequestTool.RequestSafeString("Content"); model.Star = 0; model.Parentid = 0; model.Status = 282; //283已回复 model.Time_Add = System.DateTime.Now; model.Language_Code = CurrentLanguage.Code; model.Product_id = Product_id; model.IsRead = 1; model.Supplier_id = product.Supplier_id; if (!Comment.CheckSafeWord(model.Content)) { Response.Write("{\"msg\":\"" + Tag("内容中包含敏感词") + "\"}"); return; } B_Lebi_Comment.Add(model); //发送邮件 Lebi_User user = B_Lebi_User.GetModel(CurrentUser.id); Email.SendEmail_ask(user, model); //发送短信 SMS.SendSMS_ask(user, model); Response.Write("{\"msg\":\"OK\"}"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("product_user_price", "商品会员价格")) { WindowNoPower(); } userlevelid = RequestTool.RequestInt("userlevelid"); userid = RequestTool.RequestInt("userid"); productid = RequestTool.RequestInt("productid"); key = RequestTool.RequestString("key"); userlevel = B_Lebi_UserLevel.GetModel(userlevelid); product = B_Lebi_Product.GetModel(productid); if (product == null) { product = new Lebi_Product(); } if (userlevel == null) { userlevel = new Lebi_UserLevel(); } string where = "IsAnonymous<>1"; if (key != "") { where += " and (UserName like '%" + key + "%' or RealName like '%" + key + "%' or NickName like '%" + key + "%')"; } if (userlevelid > 0) { where += " and UserLevel_id =" + userlevelid + ""; } PageSize = RequestTool.getpageSize(10); int recordCount = B_Lebi_User.Counts(where); PageString = Pager.GetPaginationStringForJS("reloadproducts({0},'" + key + "'," + userlevel.id + ");", page, PageSize, recordCount); users = B_Lebi_User.GetList(where, "", PageSize, page); userlevellimit = B_Lebi_Product_Price.GetModel("Product_id=" + product.id + ""); if (userlevellimit == null) { userlevellimit = new Lebi_Product_Price(); } }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("product_edit", "编辑商品")) { WindowNoPower(); } Number = RequestTool.RequestString("Number"); string sql = ""; Lebi_Product pro = B_Lebi_Product.GetModel("Number = lbsql{'" + Number + "'}"); int SonCount = B_Lebi_Product.Counts("Product_id = " + pro.id + ""); if (SonCount == 0) { sql = "Product_Number = lbsql{'" + Number + "'}"; } else { sql = "Product_Number in (select Lebi_Product.Number from Lebi_Product where Lebi_Product.Product_id = " + pro.id + ")"; } pros = B_Lebi_Order_Product.GetList("" + sql + " and Order_id in(select Lebi_Order.id from Lebi_Order where Lebi_Order_Product.Order_id = Lebi_Order.id and Lebi_Order.Type_id_OrderType=211 and Lebi_Order.IsCompleted = 1)", ""); }
private void Reset_Count_Freeze() { string ProductStockFreezeTime = ShopCache.GetBaseConfig().ProductStockFreezeTime; List <Lebi_Product> parents = B_Lebi_Product.GetList("Product_id = 0", ""); foreach (Lebi_Product parent in parents) { List <Lebi_Product> pros = B_Lebi_Product.GetList("Product_id = " + parent.id + "", ""); if (pros.Count > 0) { foreach (Lebi_Product pro in pros) { EX_Product.Reset_Count_Freeze(pro); } } else { EX_Product.Reset_Count_Freeze(parent); } } }
public static int TypeProductCount(int supplier_id, int id) { string where = "Product_id=0 and Supplier_id = " + supplier_id + ""; if (id > 0) { if (DataBase.DBType == "sqlserver") { where += " and Charindex('," + id + ",',','+Supplier_ProductType_ids+',')>0"; } if (DataBase.DBType == "access") { where += " and Instr(','+Supplier_ProductType_ids+',','," + id + ",')>0"; } } else { where += " and Supplier_ProductType_ids = ''"; } return(B_Lebi_Product.Counts(where)); //return TypeIds(id); }
protected void Page_Load(object sender, EventArgs e) { int orderid = RequestTool.RequestInt("orderid", 0); int id = RequestTool.RequestInt("id", 0); string pnumber = RequestTool.RequestString("pnumber").Trim(); order = B_Lebi_Order.GetModel(orderid); orderproduct = B_Lebi_Order_Product.GetModel(id); if (orderproduct == null) { product = B_Lebi_Product.GetModel("Number=lbsql{'" + pnumber + "'} order by id desc"); orderproduct = new Lebi_Order_Product(); } else { product = B_Lebi_Product.GetModel(orderproduct.Product_id); } if (order == null || product == null) { Response.Write(Tag("参数错误")); Response.End(); return; } //int pid = product.Product_id == 0 ? product.id : product.Product_id; if (product.Product_id > 0) { models = B_Lebi_Product.GetList("Product_id=" + product.Product_id + "", ""); } else { models = B_Lebi_Product.GetList("Product_id=" + product.id + "", ""); if (models.Count == 0) { models = new List <Lebi_Product>(); models.Add(product); } } }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("product_user_limit", "商品会员权限")) { WindowNoPower(); } userlevelid = RequestTool.RequestInt("userlevelid"); userid = RequestTool.RequestInt("userid"); typeid = RequestTool.RequestInt("typeid"); showall = RequestTool.RequestInt("showall"); key = RequestTool.RequestString("key"); user = B_Lebi_User.GetModel(userid); userlevel = B_Lebi_UserLevel.GetModel(userlevelid); if (user == null) { user = new Lebi_User(); } if (userlevel == null) { userlevel = new Lebi_UserLevel(); } string where = "Product_id=0 and (IsDel!=1 or IsDel is null)"; if (key != "") { where += " and (Name like '%" + key + "%' or Number like '%" + key + "%' or Code like '%" + key + "%')"; } if (typeid > 0) { string tids = EX_Product.TypeIds(typeid); where += " and Pro_Type_id in (" + tids + ")"; } PageSize = RequestTool.getpageSize(10); int recordCount = B_Lebi_Product.Counts(where); PageString = Pager.GetPaginationStringForJS("reloadproducts({0}," + typeid + ",'" + key + "'," + user.id + "," + userlevel.id + ");", page, PageSize, recordCount); products = B_Lebi_Product.GetList(where, "", PageSize, page); }
/// <summary> /// 同步库存 /// </summary> public void mUpdateStock() { //mType 请求类别,同步库存时,该值为“mUpdateStock”。 //GoodsNO 货品编号 //BarCode 货品条码(主条码) //Stock 库存量 string GoodsNO = RequestTool.RequestString("GoodsNO"); int Stock = RequestTool.RequestInt("Stock"); string res = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n"; Lebi_Product product = B_Lebi_Product.GetModel("Number=lbsql{'" + GoodsNO + "'}"); if (product == null) { res += "<rsp><result>0</result><cause>无此商品</cause></rsp>"; Response.Write(res); } product.Count_Stock = Stock; B_Lebi_Product.Update(product); if (product.Product_id > 0) { //子商品库存变更,修改父商品库存 Lebi_Product model = B_Lebi_Product.GetModel(product.Product_id); if (model != null) { List <Lebi_Product> pros = B_Lebi_Product.GetList("Product_id=" + model.id + "", ""); int count = 0; foreach (Lebi_Product pro in pros) { count = count + pro.Count_Stock; } model.Count_Stock = count; B_Lebi_Product.Update(model); } } res += "<rsp><result>1</result></rsp>"; Log.Add("商品编码:" + GoodsNO + "数量:" + Stock + "--" + res, "网店管家同步库存", ""); Response.Write(res); }
protected void Page_Load(object sender, EventArgs e) { int tid = RequestTool.RequestInt("tid", 0); int pid = RequestTool.RequestInt("pid", 0); model = B_Lebi_Product.GetModel(pid); if (model == null) { model = new Lebi_Product(); } //Lebi_ProPerty_Type ptype = B_Lebi_ProPerty_Type.GetModel(tid); string property = EX_Product.ProductType_ProPertystr(tid, CurrentSupplier.id); if (property != "") { pros = B_Lebi_ProPerty.GetList("Type_id_ProPertyType in (132,133) and id in (" + property + ")", "Sort desc"); } if (pros == null) { pros = new List <Lebi_ProPerty>(); } ProPerty133 = Common.KeyValueToList(model.ProPerty133); }
/// <summary> /// 条形码 /// </summary> public void ProductCode() { string lang = RequestTool.RequestSafeString("lang", "CN"); string Code = RequestTool.RequestSafeString("Code"); JavaScriptSerializer jss = new JavaScriptSerializer(); LBAPI api = new LBAPI(); Lebi_Product pro = B_Lebi_Product.GetModel("Code=lbsql{'" + Code + "'}"); if (pro != null) { api.data = Shop.Bussiness.ThemeUrl.GetURL("P_Product", pro.id.ToString(), "", lang); api.msg = "OK"; //Response.Write("{\"msg\":\"OK\",\"url\":\"" + Shop.Bussiness.ThemeUrl.GetURL("P_Product", pro.id.ToString(), "", lang) + "\"}"); } else { api.msg = Tag("未找到商品"); //Response.Write("{\"msg\":\"" + Tag("未找到商品") + "\"}"); } string json = jss.Serialize(api); SystemLog.Add(json); Response.Write(json); }
protected void Page_Load(object sender, EventArgs e) { id = RequestTool.RequestInt("id", 0); modelp = B_Lebi_Product.GetModel("Supplier_id = " + CurrentSupplier.id + " and id = " + id); if (modelp == null) { modelp = new Lebi_Product(); modelp.ProPertyMain = RequestTool.RequestInt("ProPertyMain", 0); modelp.ProPerty131 = RequestTool.RequestString("ProPerty131"); } if (!Power("supplier_product_edit", "编辑商品")) { WindowNoPower(); } string property = EX_Product.ProductType_ProPertystr(modelp.Pro_Type_id); if (property != "") { try { ggs = B_Lebi_ProPerty.GetList("Type_id_ProPertyType=131 and id in (lbsql{" + property + "})", "Sort desc"); } catch (System.Data.SqlClient.SqlException) { ggs = new List <Lebi_ProPerty>(); } } if (ggs == null) { ggs = new List <Lebi_ProPerty>(); } modelLan = Language.DefaultLanguage(); string where = ""; where = "Product_id=" + id + " and Product_id!=0 and (IsDel!=1 or IsDel is null)"; models = B_Lebi_Product.GetList(where, ""); }
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { LoadTheme(themecode, siteid, languagecode, pcode); CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_Exchange'"); list = Rstring_Para("0"); sort = Rstring_Para("1"); pageindex = RequestTool.RequestInt("page", 1); path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a class=\"text\"><span>" + Tag("积分兑换") + "</span></a>"; where = ProductWhere + " and Type_id_ProductType = 323 and (Time_Start < '" + FormatTime(System.DateTime.Now) + "' and Time_Expired > '" + FormatTime(System.DateTime.Now) + "')"; if (sort == "1") { order = " Count_Sales desc"; ordertmp = "a"; } else if (sort == "1a") { order = " Count_Sales asc"; ordertmp = ""; } else if (sort == "2") { order = " Price desc"; ordertmp = "a"; } else if (sort == "2a") { order = " Price asc"; ordertmp = ""; } else if (sort == "3") { order = " Count_Comment desc"; ordertmp = "a"; } else if (sort == "3a") { order = " Count_Comment asc"; ordertmp = ""; } else if (sort == "4") { order = " Time_Add desc"; ordertmp = "a"; } else if (sort == "4a") { order = " Time_Add asc"; ordertmp = ""; } else if (sort == "5") { order = " Count_Views_Show desc"; ordertmp = "a"; } else if (sort == "5a") { order = " Count_Views_Show asc"; ordertmp = ""; } else if (sort == "6") { order = " Count_Stock desc"; ordertmp = "a"; } else if (sort == "6a") { order = " Count_Stock asc"; ordertmp = ""; } else { order = " Count_Sales desc"; ordertmp = "a"; } products = B_Lebi_Product.GetList(where, order, PageSize, pageindex); recordCount = B_Lebi_Product.Counts(where); HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple("?page={0}&sort=" + sort + "&list=" + list + "", pageindex, PageSize, recordCount, CurrentLanguage); FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&sort=" + sort + "&list=" + list + "", pageindex, PageSize, recordCount, CurrentLanguage); NextPage = "?page=" + (pageindex + 1) + "&sort=" + sort + "&list=" + list + ""; }
/// <summary> /// 生成新订单 /// </summary> public void order_save() { if (CurrentUserLevel.BuyRight != 1) { Response.Write("{\"msg\":\"" + Tag("您所在的分组不允许下单") + "\"}"); return; } int pay_id = RequestTool.RequestInt("pay_id", 0); int sid = RequestTool.RequestInt("sid", 0);//结算供应商ID int onlinepay_id = RequestTool.RequestInt("onlinepay_id", 0); decimal Money_UserCut = RequestTool.RequestDecimal("Money_UserCut", 0); int usermoneytype = RequestTool.RequestInt("usermoneytype", 0); string Pay_Password = RequestTool.RequestSafeString("Pay_Password"); Lebi_PickUp pick = null; DateTime pickdate = System.DateTime.Now; if (usermoneytype == 3) { if (Pay_Password == "") { Response.Write("{\"msg\":\"" + Tag("请输入支付密码") + "\"}"); return; } else { if (EX_User.MD5(Pay_Password) != CurrentUser.Pay_Password) { Response.Write("{\"msg\":\"" + Tag("支付密码不正确") + "\"}"); return; } } if (Money_UserCut > 0 && Money_UserCut > CurrentUser.Money) { Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}"); return; } } Lebi_Pay pay = B_Lebi_Pay.GetModel(pay_id); if (pay == null) { Response.Write("{\"msg\":\"" + Tag("请设置付款方式") + "\"}"); return; } Basket basket = new Basket(sid); int CustomOfflineMoney = RequestTool.RequestInt("CustomOfflineMoney" + pay.id, 0); decimal OfflineMoney = RequestTool.RequestDecimal("OfflineMoney" + pay.id, 0); if (CustomOfflineMoney == 1) { if (pay.Code != "OfflinePay" && pay.Code != "OnlinePay") { //订单如果选择了线下支付,并且非货到付款 if (OfflineMoney < basket.Money_Product) { Response.Write("{\"msg\":\"" + Tag("打款金额不能少于订单金额") + "\"}"); return; } } } if (pay.Code == "OnlinePay") { Lebi_OnlinePay onpay = B_Lebi_OnlinePay.GetModel(onlinepay_id); if (onpay == null) { Response.Write("{\"msg\":\"" + Tag("请设置付款方式") + "\"}"); return; } } if (basket.Products.Count == 0) { Response.Write("{\"msg\":\"" + Tag("购物车为空") + "\"}"); return; } foreach (Lebi_User_Product up in basket.Products) { if (up.count < 1) { Response.Write("{\"msg\":\"" + Tag("购物车异常") + "\"}"); return; } } if (basket.Point_Buy > 0 && (basket.Point_Buy > CurrentUser.Point)) { Response.Write("{\"msg\":\"" + Tag("积分不足") + "\"}"); return; } int ProductCount = 0; foreach (Lebi_User_Product up in basket.Products) { Lebi_Product pro = B_Lebi_Product.GetModel(up.Product_id); if (pro.Type_id_ProductType != 323) { ProductCount += up.count; } //<-{ 判断是否上架状态 by lebi.kingdge 2015-02-10 if (pro.Type_id_ProductStatus != 101) { Response.Write("{\"msg\":\"" + Lang(pro.Name) + " " + Tag("该商品已经下架") + "\"}"); return; } //}-> if (pro.Type_id_ProductType != 324) { int levelcount = ProductLevelCount(pro); if (up.count < levelcount) { Response.Write("{\"msg\":\"" + Lang(pro.Name) + " " + Tag("起订量") + " " + levelcount + "\"}"); return; } } if (pro.Type_id_ProductType != 320 && pro.Time_Expired > System.DateTime.Now) { if (pro.Count_Limit < up.count && pro.Count_Limit > 0) { Response.Write("{\"msg\":\"" + Tag("购买数量大于限购数量") + "\"}"); return; } } if (SYS.IsNullStockSale != "1") { if (pro.Count_Stock - pro.Count_Freeze < up.count && pro.Type_id_ProductType != 324) { Response.Write("{\"msg\":\"" + Lang(pro.Name) + "" + Tag("库存不足") + "\"}"); return; } } } //验证当前分组允许的最低订单提交金额 if (CurrentUserLevel.OrderSubmit > 0) { if (basket.Money_Product < CurrentUserLevel.OrderSubmit) { Response.Write("{\"msg\":\"" + Tag("单笔订单最低金额为:") + FormatMoney(CurrentUserLevel.OrderSubmit) + "\"}"); return; } } //验证当前分组允许的最低订单提交数量 if (CurrentUserLevel.OrderSubmitCount > 0 && ProductCount > 0) { if (ProductCount < CurrentUserLevel.OrderSubmitCount) { Response.Write("{\"msg\":\"" + Tag("单笔订单最低数量为:") + CurrentUserLevel.OrderSubmitCount + "\"}"); return; } } Lebi_User_Address shouhuo = B_Lebi_User_Address.GetModel(CurrentUser.User_Address_id); if (shouhuo == null) { Response.Write("{\"msg\":\"" + Tag("未设置收获地址") + "\"}"); return; } if (CurrentUser.Transport_Price_id == "") { Response.Write("{\"msg\":\"" + Tag("运费设置错误") + "\"}"); return; } foreach (BasketShop shop in basket.Shops) { Lebi_Transport_Price tprice = B_Lebi_Transport_Price.GetModel("id in (lbsql{" + CurrentUser.Transport_Price_id + "}) and Supplier_id=" + shop.Shop.id + ""); if (tprice == null) { Response.Write("{\"msg\":\"" + Tag("运费设置错误") + "\"}"); return; } Lebi_Transport transport = B_Lebi_Transport.GetModel(tprice.Transport_id); if (tprice == null) { Response.Write("{\"msg\":\"" + Tag("运费设置错误") + "\"}"); return; } //检查运费设置是否正确 if (!EX_Area.CheckAreaPrice(tprice, shouhuo.Area_id)) { Response.Write("{\"msg\":\"" + Tag("运费设置错误") + "\"}"); return; } if (transport.Type_id_TransportType == 332)//自提检查 { int pickup_id = RequestTool.RequestInt("pickup_id" + shop.Shop.id); string pickdate_ = RequestTool.RequestString("pickupdate_" + pickup_id); try { pickdate = Convert.ToDateTime(pickdate_); } catch { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } pick = B_Lebi_PickUp.GetModel(pickup_id); if (pick == null) { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } if (pick.IsCanWeekend == 0 && (pickdate.DayOfWeek == DayOfWeek.Saturday || pickdate.DayOfWeek == DayOfWeek.Sunday)) { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } if (System.DateTime.Now.Date.AddDays(pick.BeginDays) > pickdate) { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } string NoServiceDays = pick.NoServiceDays.TrimStart('0').Replace(".0", "."); string nowday = pickdate.ToString("M.d"); if (("," + NoServiceDays + ",").Contains("," + nowday + ",")) { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } } } //检查代金券 string pay312 = RequestTool.RequestSafeString("pay312"); if (pay312 != "") { List <Lebi_Card> cs = B_Lebi_Card.GetList("User_id=" + CurrentUser.id + " and id in (lbsql{" + pay312 + "})", "id asc"); int flag = cs.FirstOrDefault().IsCanOtherUse; if (flag == 0 && cs.Count > 1) { Response.Write("{\"msg\":\"" + Tag("代金券异常") + "\"}"); return; } foreach (Lebi_Card c in cs) { if (flag != c.IsCanOtherUse) { Response.Write("{\"msg\":\"" + Tag("代金券异常") + "\"}"); return; } if (!Basket.CheckCard(basket, c)) { Response.Write("{\"msg\":\"" + Tag("代金券异常") + "\"}"); return; } } } //检查代金券结束 //检查发票信息 int billtype_id = RequestTool.RequestInt("billtype_id", 0); Lebi_BillType billtype = B_Lebi_BillType.GetModel(billtype_id); if (ShopCache.GetBaseConfig().BillFlag == "1") { if (billtype == null) { Response.Write("{\"msg\":\"" + Tag("请设置发票内容") + "\"}"); return; } } CurrentUser.Pay_id = pay.id; CurrentUser.OnlinePay_id = onlinepay_id; Lebi_Order ordergroup; List <Lebi_Order> orders = Shop.Bussiness.Order.CreateOrder(CurrentUser, basket, shouhuo, billtype, CurrentCurrency, CurrentSite, CurrentLanguage, out ordergroup); CurrentUser.Count_Order = CurrentUser.Count_Order + orders.Count; B_Lebi_User.Update(CurrentUser); List <Lebi_Order> ordermodel = B_Lebi_Order.GetList("User_id=" + CurrentUser.id + "", "id desc"); ordergroup = ordermodel.FirstOrDefault(); if (OfflineMoney == 0) { OfflineMoney = ordergroup.Money_Order; } string remark = RequestTool.RequestSafeString("remark"); ordergroup.Remark_User = remark; bool needupdate = false; if (remark != "") { Lebi_Comment model = new Lebi_Comment(); model.Content = remark; model.Keyid = ordergroup.id; model.TableName = "Order"; model.User_id = CurrentUser.id; model.User_UserName = CurrentUser.UserName; B_Lebi_Comment.Add(model); needupdate = true; } if (pick != null) { ordergroup.PickUp_Date = pickdate; ordergroup.PickUp_id = pick.id; ordergroup.PickUp_Name = pick.Name; needupdate = true; } if (needupdate) { B_Lebi_Order.Update(ordergroup); } if (pay.Code != "OfflinePay" && pay.Code != "OnlinePay") { //订单如果选择了线下支付,并且非货到付款 //生成一笔充值单 //OfflineMoney Lebi_Currency DefaultCurrency = B_Lebi_Currency.GetModel("IsDefault=1"); if (DefaultCurrency == null) { DefaultCurrency = B_Lebi_Currency.GetList("", "Sort desc").FirstOrDefault(); } Lebi_Order order = new Lebi_Order(); order.Code = "M" + Shop.Bussiness.Order.CreateOrderCode(); order.Money_Order = OfflineMoney; order.Money_Pay = OfflineMoney; order.User_id = CurrentUser.id; order.User_UserName = CurrentUser.UserName; order.IsPaid = 0; order.Currency_Code = ordergroup.Currency_Code; order.Currency_ExchangeRate = ordergroup.Currency_ExchangeRate; order.Currency_id = ordergroup.Currency_id; order.Currency_Msige = ordergroup.Currency_Msige; order.Type_id_OrderType = 214; order.Pay_id = pay.id; order.Pay = pay.Name; order.Site_id = CurrentSite.id; order.Language_id = CurrentLanguage.id; order.Remark_Admin = ""; order.Order_id = ordergroup.id; B_Lebi_Order.Add(order); } //if (orders.Count == 1) // ordergroup = orders.FirstOrDefault(); //Shop.Bussiness.Order.SupplierOrder(order);//根据商品供应商分单 Response.Write("{\"msg\":\"OK\",\"id\":\"" + ordergroup.id + "\"}"); return; }
protected void Page_Load(object sender, EventArgs e) { Random Random = new Random(); t = RequestTool.RequestString("t"); id = RequestTool.RequestInt("id", 0); model = B_Lebi_Product.GetModel(id); int Type_id_ProductType = RequestTool.RequestInt("Type_id_ProductType", 320); if (id == 0 || (id > 0 && t == "copy")) { if (!EX_Admin.Power("product_add", "添加商品")) { PageReturnMsg = PageNoPowerMsg(); } ////如果添加商品时随机数小于9位数 重定向生成随机数 防止破坏已有数据 //if (randnum.ToString().Length < 9) //{ // Response.Redirect(site.AdminPath + "/product/product_edit.aspx?id=" + id + "&t=" + t + "&randnum=" + Random.Next(100000000, 999999999)); // Response.End(); // return; //} } else { if (!EX_Admin.Power("product_edit", "编辑商品")) { PageReturnMsg = PageNoPowerMsg(); } if (site.SiteCount > 1 && CurrentAdmin.Site_ids != "" && model.Site_ids != "") { string[] psids = model.Site_ids.Split(','); bool flag = false; foreach (string pdis in psids) { if (("," + CurrentAdmin.Site_ids + ",").Contains("," + pdis + ",")) { flag = true; } } if (!flag) { PageReturnMsg = PageErrorMsg(); } } } action = RequestTool.RequestInt("action", 1); if (model == null) { model = new Lebi_Product(); model.Site_ids = site.Sitesid(); model.Type_id_ProductType = Type_id_ProductType; Lebi_Product modellast = B_Lebi_Product.GetModel("Type_id_ProductType = " + Type_id_ProductType + " and Supplier_id = 0 order by Time_Edit desc,id desc"); if (modellast != null) { model.Pro_Type_id = modellast.Pro_Type_id; } } else { if (t == "copy") { model.id = 0; } } if (model.Images != "") { if (model.Images.Substring(model.Images.Length - 1, 1) == "@") { model.Images = model.Images.Substring(0, model.Images.Length - 1); } if (model.Images.Substring(0, 1) != "@") { model.Images = "@" + model.Images; } } StepPrices = EX_Product.StepPrice(model.StepPrice); if (StepPrices == null) { StepPrices = new List <ProductStepPrice>(); } UserLevelPrices = EX_Product.UserLevelPrice(model.UserLevelPrice); if (UserLevelPrices == null) { UserLevelPrices = new List <ProductUserLevelPrice>(); } UserLevelCounts = EX_Product.UserLevelCount(model.UserLevelCount); if (UserLevelCounts == null) { UserLevelCounts = new List <ProductUserLevelCount>(); } userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); wap = Ishavewap(); if (model.IsCombo == 1) { comboProducts = B_Lebi_Product_Combo.GetList("Product_id=" + model.id + "", ""); } else { comboProducts = new List <Lebi_Product_Combo>(); } }
public int CountSon(int pid) { return(B_Lebi_Product.Counts("Product_id=" + pid + " and Product_id<>0")); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("product_batch_edit", "批量编辑")) { PageReturnMsg = PageNoPowerMsg(); } PageSize = RequestTool.getpageSize(25); key = RequestTool.RequestString("key"); Pro_Type_id = RequestTool.RequestString("Pro_Type_id"); status = RequestTool.RequestInt("status", 0); brand = RequestTool.RequestInt("brand", 0); tag = RequestTool.RequestInt("tag", 0); dateFrom = RequestTool.RequestString("dateFrom"); dateTo = RequestTool.RequestString("dateTo"); OrderBy = RequestTool.RequestString("OrderBy"); lang = RequestTool.RequestString("lang"); DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); Type_id_ProductType = RequestTool.RequestInt("Type_id_ProductType", 320); if (lang == "") { lang = "CN"; } string where = "Product_id=0 and (IsDel!=1 or IsDel is null)"; if (Pro_Type_id != "") { where += " and Pro_Type_id in (" + Shop.Bussiness.EX_Product.Categoryid(Pro_Type_id) + ")"; } if (status > 0) { where += " and Type_id_ProductStatus=" + status + ""; } if (Type_id_ProductType > 0) { where += " and Type_id_ProductType=" + Type_id_ProductType + ""; } if (tag > 0) { if (LB.DataAccess.DB.BaseUtilsInstance.DBType == "sqlserver") { where += " and Charindex('" + tag + "',Pro_Tag_id)>0"; } else if (LB.DataAccess.DB.BaseUtilsInstance.DBType == "access") { where += " and Instr(Pro_Tag_id,'" + tag + "')>0"; } else if (LB.DataAccess.DB.BaseUtilsInstance.DBType == "mysql") { where += " and Instr(Pro_Tag_id,'" + tag + "')>0"; } } if (brand > 0) { where += " and Brand_id=" + brand + ""; } if (key != "") { where += " and (Name like lbsql{'%" + key + "%'} or Number like lbsql{'%" + key + "%'})"; } if (dateFrom != "" && dateTo != "") { where += " and Time_Add>='" + FormatDate(lbsql_dateFrom) + "' and Time_Add<='" + FormatDate(lbsql_dateTo) + " 23:59:59'"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Site_ids)) { string[] arr = EX_Admin.Project().Site_ids.Split(','); string sonwhere = ""; foreach (string sid in arr) { if (sonwhere == "") { sonwhere = "','+Site_ids+',' like '%," + sid + ",%'"; } else { sonwhere += " or ','+Site_ids+',' like '%," + sid + ",%'"; } } where += " and (" + sonwhere + " or Site_ids='')"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Pro_Type_ids)) { string[] ids = EX_Admin.Project().Pro_Type_ids.Split(','); string sonwhere = ""; foreach (string id in ids) { sonwhere += " or Path like '%," + id + ",%'"; } sonwhere = "select id from Lebi_Pro_Type where id in (" + EX_Admin.Project().Pro_Type_ids + ")" + sonwhere; where += " and (Pro_Type_id in (" + sonwhere + ") or Pro_Type_id=0)"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Supplier_ids)) { where += " and (Supplier_id in (" + EX_Admin.Project().Supplier_ids + "))"; } //if (!string.IsNullOrEmpty(OrderBy)) //{ // if (OrderBy.Contains("Desc")) // { // orderstr = " " + OrderBy.Substring(0, OrderBy.Length - 4) + " desc"; // } // else // { // orderstr = " " + OrderBy.Substring(0, OrderBy.Length - 3) + " asc"; // } //} //else //{ // orderstr = " id desc"; //} if (OrderBy == "StatusDesc") { orderstr = " Type_id_ProductStatus desc"; } else if (OrderBy == "StatusAsc") { orderstr = " Type_id_ProductStatus asc"; } else if (OrderBy == "ViewsDesc") { orderstr = " Count_Views desc"; } else if (OrderBy == "ViewsAsc") { orderstr = " Count_Views asc"; } else if (OrderBy == "SalesDesc") { orderstr = " Count_Sales desc"; } else if (OrderBy == "SalesAsc") { orderstr = " Count_Sales asc"; } else if (OrderBy == "CountDesc") { orderstr = " Count_Stock desc"; } else if (OrderBy == "CountAsc") { orderstr = " Count_Stock asc"; } else if (OrderBy == "Price_MarketDesc") { orderstr = " Price_Market desc"; } else if (OrderBy == "Price_MarketAsc") { orderstr = " Price_Market asc"; } else if (OrderBy == "Price_CostDesc") { orderstr = " Price_Cost desc"; } else if (OrderBy == "Price_CostAsc") { orderstr = " Price_Cost asc"; } else if (OrderBy == "PriceDesc") { orderstr = " Price desc"; } else if (OrderBy == "PriceAsc") { orderstr = " Price asc"; } else if (OrderBy == "FreezeDesc") { orderstr = " Count_Freeze desc"; } else if (OrderBy == "FreezeAsc") { orderstr = " Count_Freeze asc"; } else if (OrderBy == "SortDesc") { orderstr = " Sort desc"; } else if (OrderBy == "SortAsc") { orderstr = " Sort asc"; } else { orderstr = " id desc"; } LB.DataAccess.SQLPara sp = new LB.DataAccess.SQLPara(where, orderstr, "*"); models = B_Lebi_Product.GetList(sp, PageSize, page); int recordCount = B_Lebi_Product.Counts(sp); PageString = Pager.GetPaginationString("?page={0}&brand=" + brand + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&key=" + key + "&lang=" + lang + "&OrderBy=" + OrderBy + "&Pro_Type_id=" + Pro_Type_id + "&status=" + status + "&Type_id_ProductType=" + Type_id_ProductType + "&tag=" + tag, page, PageSize, recordCount); userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); }
/// <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 void mGetOrder() { string OrderNO = RequestTool.RequestString("OrderNO"); Lebi_Order model = B_Lebi_Order.GetModel("Code=lbsql{'" + OrderNO + "'}"); Lebi_Language_Code lang = Language.DefaultLanguage(); if (model == null) { Response.Write("无此单号"); return; } List <Lebi_Order_Product> pros = B_Lebi_Order_Product.GetList("Order_id=" + model.id + "", ""); StringBuilder sb = new System.Text.StringBuilder(); sb.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n"); sb.Append("<Order>\r\n"); sb.Append("<Ver>2.0</Ver>\r\n"); //OrderNO 订单号 sb.Append("<OrderNO>" + model.Code + "</OrderNO>\r\n"); //DateTime 成交日期 sb.Append("<DateTime>" + model.Time_Add.ToString("yyyy-MM-dd HH:mm:ss") + "</DateTime>\r\n"); //BuyerID 买家用户名 sb.Append("<BuyerID>" + FormatXMLStr(model.User_UserName) + "</BuyerID>\r\n"); //BuyerName 买家姓名 sb.Append("<BuyerName>" + FormatXMLStr(model.T_Name) + "</BuyerName>\r\n"); //Country 国家 sb.Append("<Country>" + FormatXMLStr(EX_Area.GetAreaNameNoPath(model.T_Area_id, 4)) + "</Country>\r\n"); //Province 省/州 sb.Append("<Province>" + FormatXMLStr(EX_Area.GetAreaNameNoPath(model.T_Area_id, 3)) + "</Province>\r\n"); //City 市/县 sb.Append("<City>" + FormatXMLStr(EX_Area.GetAreaNameNoPath(model.T_Area_id, 2)) + "</City>\r\n"); //Town 区/镇 sb.Append("<Town>" + FormatXMLStr(EX_Area.GetAreaNameNoPath(model.T_Area_id, 1)) + "</Town>\r\n"); //Adr 地址 sb.Append("<Adr>" + FormatXMLStr(model.T_Address) + "</Adr>\r\n"); //Zip 邮编 sb.Append("<Zip>" + FormatXMLStr(model.T_Postalcode) + "</Zip>\r\n"); //Email Email sb.Append("<Email>" + FormatXMLStr(model.T_Email) + "</Email>\r\n"); //Phone 联系电话 sb.Append("<Phone>" + FormatXMLStr(model.T_MobilePhone) + "</Phone>\r\n"); //Total 货款总额 sb.Append("<Total>" + model.Money_Product + "</Total>\r\n"); //Postage 货运费用 sb.Append("<Postage>" + model.Money_Transport + "</Postage>\r\n"); //PayAccount 支付方式 sb.Append("<PayAccount>" + FormatXMLStr(Language.Content(model.Pay, lang.Code)) + "</PayAccount>\r\n"); //PayID 支付编号 sb.Append("<PayID></PayID>\r\n"); //LogisticsName 发货方式 sb.Append("<LogisticsName>" + FormatXMLStr(model.Transport_Name) + "</LogisticsName>\r\n"); //Chargetype 结算方式 sb.Append("<Chargetype>" + FormatXMLStr(Language.Content(model.OnlinePay, lang.Code)) + "</Chargetype>\r\n"); //CustomerRemark 客户备注 //发票信息 sb.Append("<CustomerRemark>" + FormatXMLStr(model.Remark_User) + "</CustomerRemark>\r\n"); //Remark 客服备注 sb.Append("<Remark>" + FormatXMLStr(model.Remark_Admin) + "</Remark>\r\n"); foreach (Lebi_Order_Product pro in pros) { Lebi_Product p = B_Lebi_Product.GetModel(pro.Product_id); if (p == null) { continue; } sb.Append(" <Item>\r\n"); //GoodsID 库存编码 sb.Append(" <GoodsID>" + FormatXMLStr(pro.Product_Number) + "</GoodsID>\r\n"); //GoodsName 货品名称 sb.Append(" <GoodsName>" + FormatXMLStr(Language.Content(pro.Product_Name, lang.Code)) + "</GoodsName>\r\n"); //GoodsSpec 货品规格 //sb.Append(" <GoodsSpec>" + FormatXMLStr(EX_Product.ProPertyNameStr(p.ProPerty131, lang)) + "</GoodsSpec>\r\n"); sb.Append(" <GoodsSpec></GoodsSpec>\r\n");//书生定制 //Count 数量 sb.Append(" <Count>" + pro.Count + "</Count>\r\n"); //Price 单价 sb.Append(" <Price>" + pro.Price + "</Price>\r\n"); sb.Append(" </Item>\r\n"); } sb.Append("</Order>\r\n"); Log.Add(sb.ToString(), "网店管家下载订单", ""); Response.Write(sb.ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("product_list", "商品列表")) { PageReturnMsg = PageNoPowerMsg(); } sp = new SearchProduct(CurrentAdmin, CurrentLanguage.Code); PageSize = RequestTool.getpageSize(25); key = RequestTool.RequestString("key"); Type_id_ProductType = RequestTool.RequestInt("Type_id_ProductType", 320); //Pro_Type_id = RequestTool.RequestString("Pro_Type_id"); //status = RequestTool.RequestInt("status", 0); //brand = RequestTool.RequestInt("brand", 0); //tag = RequestTool.RequestInt("tag", 0); //dateFrom = RequestTool.RequestString("dateFrom"); //dateTo = RequestTool.RequestString("dateTo"); OrderBy = RequestTool.RequestString("OrderBy"); //lang = RequestTool.RequestString("lang"); //if (lang == "") // lang = "CN"; string where = "Product_id=0 and (IsDel!=1 or IsDel is null)"; //if (Pro_Type_id != "") // where += " and Pro_Type_id in (" + Shop.Bussiness.EX_Product.Categoryid(Pro_Type_id) + ")"; //if (status > 0) // where += " and Type_id_ProductStatus=" + status + ""; //if (tag > 0) // where += " and Pro_Tag_id=" + tag + ""; //if (brand > 0) // where += " and Brand_id=" + brand + ""; if (key != "") { where += " and (Name like lbsql{'%" + key + "%'} or Number like lbsql{'%" + key + "%'} or Code like lbsql{'%" + key + "%'} or id like lbsql{'%" + key + "%'})"; } //if (dateFrom != "" && dateTo != "") // where += " and (datediff(d,Time_Add,'" + dateFrom + "')<=0 and datediff(d,Time_Add,'" + dateTo + "')>=0)"; where += sp.SQL; if (domain3admin && CurrentAdmin.Site_ids != "") { string[] arr = CurrentAdmin.Site_ids.Split(','); string sonwhere = ""; foreach (string sid in arr) { if (sonwhere == "") { sonwhere = "','+Site_ids+',' like '%," + sid + ",%'"; } else { sonwhere += " or ','+Site_ids+',' like '%," + sid + ",%'"; } } where += " and (" + sonwhere + " or Site_ids='')"; } if (CurrentAdmin.Pro_Type_ids != "") { string[] ids = CurrentAdmin.Pro_Type_ids.Split(','); string sonwhere = ""; foreach (string id in ids) { sonwhere += " or Path like '%," + id + ",%'"; } sonwhere = "select id from Lebi_Pro_Type where id in (" + CurrentAdmin.Pro_Type_ids + ")" + sonwhere; where += " and (Pro_Type_id in (" + sonwhere + ") or Pro_Type_id=0)"; } if (OrderBy == "StatusDesc") { orderstr = " Type_id_ProductStatus desc"; } else if (OrderBy == "StatusAsc") { orderstr = " Type_id_ProductStatus asc"; } else if (OrderBy == "ViewsDesc") { orderstr = " Count_Views desc"; } else if (OrderBy == "ViewsAsc") { orderstr = " Count_Views asc"; } else if (OrderBy == "SalesDesc") { orderstr = " Count_Sales desc"; } else if (OrderBy == "SalesAsc") { orderstr = " Count_Sales asc"; } else if (OrderBy == "CountDesc") { orderstr = " Count_Stock desc"; } else if (OrderBy == "CountAsc") { orderstr = " Count_Stock asc"; } else if (OrderBy == "Price_CostDesc") { orderstr = " Price_Cost desc"; } else if (OrderBy == "Price_CostAsc") { orderstr = " Price_Cost asc"; } else if (OrderBy == "PriceDesc") { orderstr = " Price desc"; } else if (OrderBy == "PriceAsc") { orderstr = " Price asc"; } else if (OrderBy == "FreezeDesc") { orderstr = " Count_Freeze desc"; } else if (OrderBy == "FreezeAsc") { orderstr = " Count_Freeze asc"; } else if (OrderBy == "SortDesc") { orderstr = " Sort desc"; } else if (OrderBy == "SortAsc") { orderstr = " Sort asc"; } else { orderstr = " id desc"; } models = B_Lebi_Product.GetList(where, orderstr, PageSize, page); int recordCount = B_Lebi_Product.Counts(where); PageString = Pager.GetPaginationString("?page={0}&OrderBy=" + OrderBy + "&key=" + key + "&" + sp.URL, page, PageSize, recordCount); //Response.Write(where); }
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { pcode = "P_ShopIndex"; LoadTheme(themecode, siteid, languagecode, pcode); id = RequestTool.RequestInt("id", 0); //商家ID cid = RequestTool.RequestInt("cid", 0); //商品分类 list = RequestTool.RequestString("list"); //列表或网格 sort = RequestTool.RequestString("sort"); //排序 key = RequestTool.RequestSafeString("keyword"); //关键词 pageindex = RequestTool.RequestInt("page", 1); parentcid = 0; supplier = B_Lebi_Supplier.GetModel("id = " + id); if (supplier == null) { Response.Redirect(URL("P_404", "")); Response.End(); } int Supplier_id = supplier.User_id; if (cid != 0) { producttype = B_Lebi_Supplier_ProductType.GetModel(cid); if (producttype.parentid > 0) { parentcid = producttype.parentid; } else { parentcid = cid; } } path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_ShopIndex", id) + "\"><span>" + Lang(supplier.Name) + "</span></a>"; where = ProductWhere + " and Supplier_id = " + id + ""; if (cid > 0) { if (DataBase.DBType == "sqlserver") { where += " and Charindex('," + cid + ",',','+Supplier_ProductType_ids+',')>0"; } if (DataBase.DBType == "access") { where += " and Instr(','+Supplier_ProductType_ids+',','," + cid + ",')>0"; } } if (key != "") { where += " and Name like '%" + key + "%'"; } if (sort == "") { sort = "1"; } if (sort == "1") { order = " Count_Sales_Show desc"; ordertmp = "a"; } else if (sort == "1a") { order = " Count_Sales_Show asc"; ordertmp = ""; } else if (sort == "2") { order = " Price desc"; ordertmp = "a"; } else if (sort == "2a") { order = " Price asc"; ordertmp = ""; } else if (sort == "3") { order = " Count_Comment desc"; ordertmp = "a"; } else if (sort == "3a") { order = " Count_Comment asc"; ordertmp = ""; } else if (sort == "4") { order = " Time_Add desc"; ordertmp = "a"; } else if (sort == "4a") { order = " Time_Add asc"; ordertmp = ""; } else if (sort == "5") { order = " Count_Views_Show desc"; ordertmp = "a"; } else if (sort == "5a") { order = " Count_Views_Show asc"; ordertmp = ""; } else { order = " Count_Sales_Show desc"; ordertmp = "a"; } products = B_Lebi_Product.GetList(where, order, PageSize, pageindex); recordCount = B_Lebi_Product.Counts(where); //id={0}&pid={1}&cid={2}&list={3}&sort={4}&tid={5}&page={6} string url = URL("P_ShopIndex", id + "," + cid + "," + list + "," + sort + ",{0}," + key + ""); HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple(url, pageindex, PageSize, recordCount, CurrentLanguage); FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, pageindex, PageSize, recordCount, CurrentLanguage); NextPage = URL("P_ShopIndex", id + "," + cid + "," + list + "," + sort + "," + (pageindex + 1) + "," + key + ""); string supplierservicepannelcon = supplier.ServicePanel; supplierservicepannel = B_ServicePanel.GetModel(supplierservicepannelcon); headcontent = supplier.head; longbar = supplier.longbar; shortbar = supplier.shortbar; if (CurrentSite.IsMobile == 0) //只针对PC站点 lebi.kingdge 2015-12-30 { //跳转至设置的皮肤页面 Lebi_Supplier_Skin skin = B_Lebi_Supplier_Skin.GetModel(supplier.Supplier_Skin_id); if (skin != null) { string filename = HttpContext.Current.Request.Url.AbsolutePath.ToString().ToLower(); if (!filename.Contains("default" + skin.id + ".aspx")) { string tourl = Shop.Bussiness.Site.Instance.WebPath + "/" + CurrentLanguage.Path + "/shop/default" + skin.id + ".aspx?id=" + supplier.id + "&cid=" + cid + "&list=" + list + "&sort=" + sort + "&page=" + pageindex; tourl = ThemeUrl.CheckPath(tourl); Response.Redirect(tourl); //Response.Write(tourl); } } } }
/// <summary> /// 发表商品评价 /// </summary> public void Comment_Write() { int id = RequestTool.RequestInt("id", 0); //int Product_id = 0; if (!Comment.CheckSafeWord(RequestTool.RequestSafeString("Content"))) { Response.Write("{\"msg\":\"" + Tag("内容中包含敏感词") + "\"}"); return; } Lebi_Order_Product Order_Product = B_Lebi_Order_Product.GetModel("User_id=" + CurrentUser.id + " and id = " + id); if (Order_Product == null) { Response.Write("{\"msg\":\"" + Tag("该商品已经下架") + "\"}"); return; } else { Lebi_Order order = B_Lebi_Order.GetModel(Order_Product.Order_id); if (order == null) { Response.Write("{\"msg\":\"" + Tag("无效订单") + "\"}"); return; } else { if (order.IsReceived == 0) { Response.Write("{\"msg\":\"" + Tag("已购买商品在已收货之后才可以发表评价") + "\"}"); return; } } Order_Product.IsCommented = 1; B_Lebi_Order_Product.Update(Order_Product); } Lebi_Product checkproduct = B_Lebi_Product.GetModel(Order_Product.Product_id); if (checkproduct == null) { Response.Write("{\"msg\":\"" + Tag("该商品已经下架") + "\"}"); return; } Lebi_Comment model = new Lebi_Comment(); model.TableName = "Product"; model.Keyid = Order_Product.Product_id; model.Admin_UserName = "******"; model.Admin_id = 0; model.User_id = CurrentUser.id; model.User_UserName = CurrentUser.NickName; model.Content = RequestTool.RequestSafeString("Content"); model.Star = RequestTool.RequestInt("Star", 5); model.Parentid = 0; model.Status = 280; model.Time_Add = System.DateTime.Now; model.Language_Code = CurrentLanguage.Code; model.Images = RequestTool.RequestSafeString("Images"); model.ImagesSmall = RequestTool.RequestSafeString("ImagesSmall"); model.Product_id = Order_Product.Product_id; model.IsRead = 1; model.Supplier_id = checkproduct.Supplier_id; B_Lebi_Comment.Add(model); //List<Lebi_Order_Product> modelproducts = B_Lebi_Order_Product.GetList("User_id=" + CurrentUser.id + " and id = " + id + "", ""); //foreach (Lebi_Order_Product modelproduct in modelproducts) //{ // modelproduct.IsCommented = 1; // B_Lebi_Order_Product.Update(modelproduct); //} Lebi_Product product = B_Lebi_Product.GetModel(Order_Product.Product_id); if (product != null) { EX_Product.UpdateStar(product); } model.id = B_Lebi_Comment.GetMaxId(); //处理图片 ImageHelper.LebiImagesUsed(model.Images, "comment", model.id); //发送邮件 Lebi_User user = B_Lebi_User.GetModel(CurrentUser.id); Email.SendEmail_comment(user, model); //发送短信 SMS.SendSMS_comment(user, model); Response.Write("{\"msg\":\"OK\"}"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("product_list", "商品列表")) { PageReturnMsg = PageNoPowerMsg(); } sp = new SearchProduct(CurrentAdmin, CurrentLanguage.Code); PageSize = RequestTool.getpageSize(25); key = RequestTool.RequestSafeString("key"); OrderBy = RequestTool.RequestString("OrderBy"); mode = RequestTool.RequestString("mode"); string where = "Product_id=0 and (IsDel!=1 or IsDel is null)"; if (mode == "recycle") { where = "IsDel=1"; } if (key != "") { where += " and ("; where += " Name like lbsql{'%" + key + "%'} or Number like lbsql{'%" + key + "%'} or Code like lbsql{'%" + key + "%'} or id like lbsql{'%" + key + "%'}"; List <Lebi_Product> parents = B_Lebi_Product.GetList("Number like lbsql{'%" + key + "%'} or Code like lbsql{'%" + key + "%'} or id like lbsql{'%" + key + "%'}", ""); if (parents.Count > 0) { foreach (Lebi_Product parent in parents) { where += " or id =" + parent.Product_id + ""; } } where += " )"; } where += sp.SQL; if (mode != "recycle") { if (!string.IsNullOrEmpty(EX_Admin.Project().Site_ids)) { string[] arr = EX_Admin.Project().Site_ids.Split(','); string sonwhere = ""; foreach (string sid in arr) { if (sonwhere == "") { sonwhere = "','+Site_ids+',' like '%," + sid + ",%'"; } else { sonwhere += " or ','+Site_ids+',' like '%," + sid + ",%'"; } } where += " and (" + sonwhere + " or Site_ids='')"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Pro_Type_ids)) { string[] ids = EX_Admin.Project().Pro_Type_ids.Split(','); string sonwhere = ""; foreach (string id in ids) { sonwhere += " or Path like '%," + id + ",%'"; } sonwhere = "select id from Lebi_Pro_Type where id in (" + EX_Admin.Project().Pro_Type_ids + ")" + sonwhere; where += " and (Pro_Type_id in (" + sonwhere + "))"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Supplier_ids)) { where += " and (Supplier_id in (" + EX_Admin.Project().Supplier_ids + "))"; } } if (OrderBy == "StatusDesc") { orderstr = " Type_id_ProductStatus desc"; } else if (OrderBy == "StatusAsc") { orderstr = " Type_id_ProductStatus asc"; } else if (OrderBy == "ViewsDesc") { orderstr = " Count_Views desc"; } else if (OrderBy == "ViewsAsc") { orderstr = " Count_Views asc"; } else if (OrderBy == "SalesDesc") { orderstr = " Count_Sales desc"; } else if (OrderBy == "SalesAsc") { orderstr = " Count_Sales asc"; } else if (OrderBy == "CountDesc") { orderstr = " (Count_Stock+Count_Freeze) desc"; } else if (OrderBy == "CountAsc") { orderstr = " (Count_Stock+Count_Freeze) asc"; } else if (OrderBy == "Price_CostDesc") { orderstr = " Price_Cost desc"; } else if (OrderBy == "Price_CostAsc") { orderstr = " Price_Cost asc"; } else if (OrderBy == "PriceDesc") { orderstr = " Price desc"; } else if (OrderBy == "PriceAsc") { orderstr = " Price asc"; } else if (OrderBy == "FreezeDesc") { orderstr = " Count_Freeze desc"; } else if (OrderBy == "FreezeAsc") { orderstr = " Count_Freeze asc"; } else if (OrderBy == "SortDesc") { orderstr = " Sort desc"; } else if (OrderBy == "SortAsc") { orderstr = " Sort asc"; } else { orderstr = " id desc"; } models = B_Lebi_Product.GetList(where, orderstr, PageSize, page); int recordCount = B_Lebi_Product.Counts(where); PageString = Pager.GetPaginationString("?page={0}&OrderBy=" + OrderBy + "&key=" + key + "&mode=" + mode + "&" + sp.URL, page, PageSize, recordCount); //Response.Write(where); }