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 + ""; }
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("全部会员"); } }