关键字查询并分页

来源：互联网发布：编程工具下载编辑：程序博客网时间：2024/04/24 09:23

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;    }

0 0