仿百度的sql分页样式分享

分页基本是每个程序都会遇到的问题.前面已经发不过sql存储过程的通用分页.这里小弟再发一个前台页面的分页显示.有点仿百度的样子.希望高手们有好的写法给予指导

 

代码如下	复制代码
protected DataTable dtNews ;  const int PAGE_SIZE = 7;  protected string pagestr;  protected string pagestring;  protected void Page_Load(object sender, EventArgs e)  {      string urlParam = Request["p"] ?? string.Empty;      int pageIndex;     int.TryParse(urlParam.Trim(), out pageIndex);     if (pageIndex     {          pageIndex = 1;      }

//这里就是调用sql通用存储过程的方法,我把SelectPager()方法贴出来

 

代码如下	复制代码
View Code //QARequestionBLL就是存放Pager的类  this.dtNews = QARequestionBLL.SelectPager(pcategory, this._CurPageIndex, _pageSize, "QDatetime", "desc", out doCount);   pagestring = GetPageStr(doCount, PAGE_SIZE, pageIndex);    }

 //声明一下.这里面的URLTO,是我用了重定向的方法.把他提取出来一个类了,所以href里面的连接其实就是地址后面加

代码如下

复制代码

pageindex.(要下班了,所以就不正了,回家有事.嘿嘿....)      //总共多少也,每页多少条,第几页         public string GetPageStr(int total, int per, int page)         {             int allpage = 0;             int next = 0;             int pre = 0;             int startcount = 0;             int endcount = 0;               if (page             if (per != 0)             {                 allpage = (total / per);                 allpage = ((total % per) != 0 ? allpage + 1 : allpage);                 allpage = (allpage == 0 ? 1 : allpage);             }             next = page + 1;             pre = page - 1;             if (startcount             {                 startcount = 1;             }             if (allpage             {                 endcount = allpage;             }             if (page > allpage)             {                 page = allpage;             }             if (allpage>1)             {                 pagestr = " ";                 pagestr += page > 1 ? " " : "上一页";                 pagestr += " ";                 if (allpage > 10)                 {                     startcount = (page + 4) > allpage ? allpage - 10 : page - 4;                     if (page                     {                           for (int i = 1; i                         {                             pagestr += page == i ? "" + i + "" : "" + i + "";                         }                         //pagestr += "...  " + Convert.ToString(allpage - 1) + "";                         pagestr += "..." + allpage + "";                     }                     else                         if (page                         {                             pagestr += "  1...";                             //pagestr += "  2...";                             for (int i = startcount; i                             {                                 pagestr += page == i ? "  " + i + "" : "  " + i + "";                             }                             //pagestr += "...  " + Convert.ToString(allpage - 1) + "";                             pagestr += "..." + allpage + "";                         }                         else                         {                             pagestr += "  1...";                             //pagestr += "  2...";                             for (int i = allpage - 8; i                             {                                 pagestr += page == i ? "  " + i + "" : "  " + i + "";                             }                         }                   }                 else                 {                     for (int i = 1; i                     {                         pagestr += page == i ? "  " + i + "" : "  " + i + "";                     }                 }                 pagestr += " ";                 pagestr += page != allpage ? "  " : " 下一页";             }             return pagestr;         }