最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
仿百度的sql分页样式分享
时间：2011-11-01 编辑：简简单单 来源：一聚教程网
| 代码如下 | 复制代码 |
|
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 < 1) { pageIndex = 1; } |
|
//这里就是调用sql分页通用存储过程的方法,我把SelectPager()方法贴出来
| 代码如下 | 复制代码 |
|
View Code 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 < 1) { page = 1; } 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 < 1) { startcount = 1; } if (allpage < endcount) { 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 < 10) {
for (int i = 1; i <=10; i++) { pagestr += page == i ? "" + i + "" : "" + i + ""; } //pagestr += "... " + Convert.ToString(allpage - 1) + ""; pagestr += " } else if (page <= allpage - 8) { pagestr += " 1..."; //pagestr += " 2..."; for (int i = startcount; i <= startcount + 8; i++) { pagestr += page == i ? " " + i + "" : " " + i + ""; } //pagestr += "... " + Convert.ToString(allpage - 1) + ""; pagestr += " } else { pagestr += " 1 //pagestr += " 2..."; for (int i = allpage - 8; i <= allpage; i++) { pagestr += page == i ? " " + i + "" : " " + i + ""; } }
} else { for (int i = 1; i <= allpage; i++) { pagestr += page == i ? " " + i + "" : " " + i + ""; } } pagestr += " ";
" : " 下一页";
pagestr += page != allpage ? " } return pagestr; } |
|
相关文章
- MySQL登录、访问及退出操作解析 10-18
- sql语句 update字段null不能用is null问题解析 09-28
- SQL Server ISNULL 不生效原因及解决分析 09-28
- 关于if exists的用法及说明分析 09-28
- Access数据库日常维护方法 09-28
- Oracle 删除大量表记录操作介绍 09-27