Pages() 附加条件分页

来源：互联网发布：淘宝导航条怎么去掉编辑：程序博客网时间：2024/06/18 00:09
    public List<Dqt.Reporter.Model.article> Pages()    {        string strWhere = "1=1";        string fudai = string.Empty;        if (!string.IsNullOrEmpty(Request.QueryString["sport"]))        {            if (MFunction.IsSaveStr(Request.QueryString["sport"]))            {                int essence = 0;                if (int.TryParse(Request.QueryString["sport"], out essence))                {                    strWhere += " and ArticlCalssName="+Common.active;                    classname = "精彩活动";                    fudai += "&sport=1";                    header1.Styletype = "sport";                }                else                {                    return null;                }            }        }        if (!string.IsNullOrEmpty(Request.QueryString["new"]))        {            if (MFunction.IsSaveStr(Request.QueryString["new"]))            {                int essence = 0;                if (int.TryParse(Request.QueryString["new"], out essence))                {                    strWhere += " and ArticlCalssName=" + Common.newdynamic;                    classname = "通知公告";                    fudai += "&new=1";                    header1.Styletype = "new";                }                else                {                    return null;                }            }        }        if (!string.IsNullOrEmpty(Request.QueryString["key"]))        {            if (MFunction.IsSaveStr(Request.QueryString["key"]))            {                strWhere += " and ArticlTitle like '%" + Request.QueryString["key"] + "%'";            }        }        int pageSize = 10;//每页10条        int pageindex = 1;        if (!string.IsNullOrEmpty(Request.QueryString["page"]))            pageindex = int.Parse(Request.QueryString["page"]);        pageindex = pageindex < 1 ? 1 : pageindex;        int totle = ArticleBLL.GetRecordCount(strWhere);        pager1.RecordCount = totle;        if (totle > pageSize)            pager1.Visible = true;        pager1.PageUrl = "/gaojian/gaojian_all.aspx";        pager1.PageSize = pageSize;        pager1.DestPage = pageindex;        pager1.UrlParm = "cid=" + Request.QueryString["cid"]+fudai;        List<Dqt.Reporter.Model.article> alist=ArticleBLL.GetModelList(strWhere, pageindex, pageSize, " ArticlTime desc");        records=alist.Count();        return alist;    }
0 0