Ejemplo n.º 1
0
        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\">&raquo;</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>&raquo;</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");
        }
Ejemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Power("supplier_message", "站内信"))
            {
                WindowNoPower();
            }
            int id = RequestTool.RequestInt("id", 0);

            model = B_Lebi_Message.GetModel("id = " + id + " and Supplier_id = " + CurrentSupplier.id + "");
            if (model == null)
            {
                model = new Lebi_Message();
            }
            if (model.User_id_From == 0)
            {
                model.IsRead = 1;
                B_Lebi_Message.Update(model);
            }
            models = B_Lebi_Message.GetList("Parentid = " + id, "id desc", PageSize, page);
        }
Ejemplo n.º 3
0
        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);
        }