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_UserOftenBuy", "") + "\"><span>" + Tag("常购清单") + "</span></a>"; key = Rstring("key"); dateFrom = Rstring("dateFrom"); dateTo = Rstring("dateTo"); DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); pageindex = RequestTool.RequestInt("page", 1); where = "User_id=" + CurrentUser.id + " and Type_id_UserProductType=144"; if (key != "") { where += " and Product_id in (select id from Lebi_Product where Name like lbsql{'%" + key + "%'})"; } if (dateFrom != "" && dateTo != "") { where += " and Time_Add>='" + FormatDate(lbsql_dateFrom) + "' and Time_Add<='" + FormatDate(lbsql_dateTo) + " 23:59:59'"; } user_products = B_Lebi_User_Product.GetList(where, "id desc", PageSize, pageindex); int recordCount = B_Lebi_User_Product.Counts(where); PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage); NextPage = "?page=" + (pageindex + 1) + "&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + ""; }
/// <summary> /// 侧边栏-收藏夹 /// </summary> public void sidebar_userlike() { StringBuilder sb = new StringBuilder(); sb.Append("<div class=\\\"ibar_plugin_content\\\">"); //sb.Append(" <div class=\\\"ibar-history-head\\\">共3件产品<a href=\\\"#\\\">清空</a></div>"); sb.Append(" <div class=\\\"ibar-moudle-product\\\">"); List <Lebi_User_Product> pros = B_Lebi_User_Product.GetList("User_id=" + CurrentUser.id + " and Type_id_UserProductType=141", "id desc", 10, 1); foreach (Shop.Model.Lebi_User_Product pro in pros) { Shop.Model.Lebi_Product productmodel = GetProduct(pro.Product_id); if (productmodel.id == 0) { continue; } sb.Append(" <div class=\\\"imp_item\\\">"); sb.Append(" <a href=\\\"" + URL("P_Proudct", pro.Product_id) + "\\\" class=\\\"pic\\\"><img src=\\\"" + Image(productmodel.ImageOriginal) + "\\\" width=\\\"100\\\" height=\\\"100\\\" /></a>"); sb.Append(" <p class=\\\"tit\\\"><a href=\\\"" + URL("P_Proudct", pro.Product_id) + "\\\">" + Lang(productmodel.Name) + "</a></p>"); sb.Append(" <p class=\\\"price\\\">" + FormatMoney(ProductPrice(productmodel)) + "</p>"); sb.Append(" <a href=\\\"javascript:void(0);\\\" onclick=\\\"UserProduct_Edit(" + productmodel.id + ",142,1,'','');\\\" class=\\\"imp-addCart\\\">" + Tag("加入购物车") + "</a>"); sb.Append(" </div>"); } sb.Append(" </div>"); sb.Append("</div>"); Response.Write("{\"title\":\"" + Tag("我的收藏") + "\",\"content\":\"" + sb.ToString() + "\"}"); }
/// <summary> /// 删除会员 /// </summary> public void User_Del() { if (!EX_Admin.Power("user_del", "删除会员")) { AjaxNoPower(); return; } string id = RequestTool.RequestString("ids"); if (id == "") { Response.Write("{\"msg\":\"" + Tag("请选择要删除的信息") + "\"}"); return; } if (RequestTool.GetConfigKey("IsDelFalse").ToLower() == "true") { List <Lebi_User> users = B_Lebi_User.GetList("id in (lbsql{" + id + "})", ""); foreach (var u in users) { u.IsDel = 1; B_Lebi_User.Update(u); } } else { List <Lebi_Order> modellist = B_Lebi_Order.GetList("User_id in (lbsql{" + id + "})", ""); foreach (Lebi_Order model in modellist) { B_Lebi_Order.Delete("id = " + model.id + ""); B_Lebi_Order_Log.Delete("Order_id = " + model.id + ""); B_Lebi_Order_Product.Delete("Order_id = " + model.id + ""); } B_Lebi_User.Delete("id in (lbsql{" + id + "})"); B_Lebi_Message.Delete("User_id_To in (lbsql{" + id + "})"); B_Lebi_User_Answer.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_User_Answer.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_User_BuyMoney.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_User_Card.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_User_Money.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_User_Point.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_User_Product.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_User_Address.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_Supplier.Delete("User_id in (lbsql{" + id + "})"); //B_Lebi_Supplier_ProductType.Delete("Supplier_id in (lbsql{" + id + "})"); //B_Lebi_Supplier_Verified_Log.Delete("Supplier_id in (lbsql{" + id + "})"); B_Lebi_Agent_Area.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_Agent_Money.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_Agent_Product.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_Agent_Product_request.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_Agent_Product_User.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_Bill.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_Cash.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_Comment.Delete("User_id in (lbsql{" + id + "})"); B_Lebi_weixin_qrcode.Delete("User_id in (lbsql{" + id + "})"); } Log.Add("删除会员", "User", id.ToString(), CurrentAdmin, id.ToString()); Response.Write("{\"msg\":\"OK\"}"); }
/// <summary> /// 更新常购商品 /// </summary> public void UserOftenBuy_Update() { string id = RequestTool.RequestSafeString("Uid"); List <Lebi_User_Product> models = B_Lebi_User_Product.GetList("User_id=" + CurrentUser.id + " and id in (lbsql{" + id + "})", ""); foreach (Lebi_User_Product model in models) { model.count = RequestTool.RequestInt("Count" + model.id + "", 0); model.WarnDays = RequestTool.RequestInt("WarnDays" + model.id + "", 0); model.Time_addemail = System.DateTime.Now.Date.AddDays(model.WarnDays); B_Lebi_User_Product.Update(model); } Response.Write("{\"msg\":\"OK\"}"); }
/// <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) { if (!EX_Admin.Power("oftenbuy_list", "常购清单列表")) { PageReturnMsg = PageNoPowerMsg(); } PageSize = RequestTool.getpageSize(25); int user_id = RequestTool.RequestInt("user_id", 0); key = RequestTool.RequestString("key"); dateFrom = RequestTool.RequestString("dateFrom"); dateTo = RequestTool.RequestString("dateTo"); type = RequestTool.RequestInt("type", 0); if (type == 0) { type = 144; } DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); string where = "1=1"; if (user_id > 0) { where += " and User_id=" + user_id; } if (type > 0) { where += " and Type_id_UserProductType=" + type + ""; } if (key != "") { where += " and Product_id in (select id from Lebi_Product where Name like lbsql{'%" + key + "%'})"; } if (dateFrom != "" && dateTo != "") { where += " and Time_Add>='" + FormatDate(lbsql_dateFrom) + "' and Time_Add<='" + FormatDate(lbsql_dateTo) + " 23:59:59'"; } models = B_Lebi_User_Product.GetList(where, "id desc", PageSize, page); int recordCount = B_Lebi_User_Product.Counts(where); PageString = Pager.GetPaginationString("?page={0}&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&type = " + type, page, PageSize, recordCount); user = B_Lebi_User.GetModel(user_id); if (user == null) { user = new Lebi_User(); user.UserName = Tag("全部会员"); } }
/// <summary> /// 删除常购商品 /// </summary> public void UserOftenBuy_Del() { string ids = RequestTool.RequestSafeString("id"); if (ids == "") { Response.Write("{\"msg\":\"OK\"}"); return; } List <Lebi_User_Product> models = B_Lebi_User_Product.GetList("User_id=" + CurrentUser.id + " and id in (lbsql{" + ids + "})", ""); foreach (Lebi_User_Product model in models) { B_Lebi_User_Product.Delete(model.id); } Response.Write("{\"msg\":\"OK\"}"); }
/// <summary> /// 修改购物车产品 /// </summary> public void UserBasket_Edit() { int t = 142; //int num = RequestTool.RequestInt("num", 1);//默认数量1 string property = RequestTool.RequestSafeString("property"); string CookieName = "UserProduct" + t; List <Lebi_User_Product> pros = Basket.UserProduct(CurrentUser, t); foreach (Lebi_User_Product pro in pros) { pro.count = RequestTool.RequestInt("BasketCount" + pro.Product_id, 1);//默认数量1 pro.count = pro.count < 1 ? 1 : pro.count; } if (CurrentUser.id > 0 && CurrentUser.IsAnonymous == 0)//已经登录 { foreach (Lebi_User_Product pro in pros) { B_Lebi_User_Product.Update(pro); } } else//未登录 { NameValueCollection nv = CookieTool.GetCookie(CookieName); string key, userproduct; foreach (Lebi_User_Product pro in pros) { key = "p" + pro.Product_id.ToString(); userproduct = nv.Get(key); if (string.IsNullOrEmpty(userproduct)) { //nv.Add(key, pro.count.ToString()); nv.Add(key, pro.count.ToString() + "|" + property); } else { nv.Set(key, pro.count.ToString() + "|" + property); } } CookieTool.WriteCookie(CookieName, nv, 365); } Response.Write("{\"msg\":\"OK\"}"); }
/// <summary> /// 购物车或收藏夹中删除一个商品 /// 141购物车 /// 142收藏 /// 143浏览记录 /// </summary> public void UserProduct_Del() { int t = RequestTool.RequestInt("type", 141);//默认收藏 if (t != 141 && t != 142 && t != 143) { Response.Write("OK"); return; } string productid = RequestTool.RequestSafeString("pid"); if (productid == "all") { //清空购物车/收藏夹 Basket.Clear(CurrentUser, t); } else { int pid = RequestTool.RequestInt("pid", 0); if (EX_User.LoginStatus(CurrentUser))//已经登录 { B_Lebi_User_Product.Delete("user_id=" + CurrentUser.id + " and product_id=" + pid + " and type_id_UserProductType=" + t + ""); } else//未登录 { string CookieName = "UserProduct" + t; NameValueCollection nv = CookieTool.GetCookie(CookieName); string key = "p" + pid.ToString(); string userproduct = nv.Get(key); if (!string.IsNullOrEmpty(userproduct)) { nv.Remove(key); } CookieTool.WriteCookie(CookieName, nv, 365); } } Response.Write("{\"msg\":\"OK\",\"mes\":\"" + Tag("操作成功") + "\"}"); }