关键字查询并分页

最新推荐文章于 2022-05-02 23:54:58 发布

原创最新推荐文章于 2022-05-02 23:54:58 发布 · 974 阅读

0 ·

CC 4.0 BY-SA版权

.NET 专栏收录该内容

166 篇文章

订阅专栏

public List<Dqt.Reporter.Model.article> Pages()
    {
        string strWhere = "1=1";
        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;
    }