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_UserMessage'"); type = Rint_Para("0"); 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>"; if (type == 0) { path += "<a href=\"" + URL("P_UserMessage", "0") + "\"><span>" + Tag("收件箱") + "</span></a>"; } else { path += "<a href=\"" + URL("P_UserMessage", "1") + "\"><span>" + Tag("发件箱") + "</span></a>"; } CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserMessage'"); key = Rstring("key"); type_id = Rstring("type_id"); dateFrom = Rstring("dateFrom"); dateTo = Rstring("dateTo"); DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); pageindex = RequestTool.RequestInt("page", 1); if (type == 0) { where = "User_id_To=" + CurrentUser.id + ""; } if (type == 1) { where = "User_id_From=" + CurrentUser.id + ""; } if (key != "") { where += " and (Title like lbsql{'%" + key + "%'})"; } if (type_id != "") { where += " and Message_Type_id = " + type_id; } if (dateFrom != "" && dateTo != "") { where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)"; } messages = B_Lebi_Message.GetList(where, "id desc", PageSize, pageindex); int recordCount = B_Lebi_Message.Counts(where); PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&type=" + type + "&type_id=" + type_id + "&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage); NextPage = "?page=" + (pageindex + 1) + "&type=" + type + "&type_id=" + type_id + "&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + ""; message_types = B_Lebi_Message_Type.GetList("Type_id_MessageTypeClass = 350", "id desc"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("message_list", "站内信列表")) { PageReturnMsg = PageNoPowerMsg(); } lang = RequestTool.RequestString("lang"); key = RequestTool.RequestString("key"); type = RequestTool.RequestString("type"); type_id = RequestTool.RequestString("type_id"); dateFrom = RequestTool.RequestString("dateFrom"); dateTo = RequestTool.RequestString("dateTo"); user_id = RequestTool.RequestInt("user_id", 0); if (user_id > 0) { modeluser = B_Lebi_User.GetModel(user_id); if (modeluser == null) { UserName = ""; } else { UserName = modeluser.UserName; } } DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); string where = "Supplier_id = 0"; if (key != "") { where += " and (Title like lbsql{'%" + key + "%'} or User_Name_To like lbsql{'%" + key + "%'} or User_Name_From like lbsql{'%" + key + "%'})"; } if (user_id > 0) { where += " and (User_id_To = " + user_id + " or User_id_From = " + user_id + ")"; } if (lang != "") { where += " and Language = lbsql{'" + lang + "'}"; } if (type == "0") { where += " and User_id_To =0"; } if (type == "1") { where += " and User_id_From =0"; } if (type_id != "") { where += " and Message_Type_id = " + type_id; } if (dateFrom != "" && dateTo != "") { where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)"; } models = B_Lebi_Message.GetList(where, "Time_Add desc", PageSize, page); int recordCount = B_Lebi_Message.Counts(where); PageString = Pager.GetPaginationString("?page={0}&user_id=" + user_id + "&type=" + type + "&lang=" + lang + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&type_id=" + type_id + "&key=" + key, page, PageSize, recordCount); }