.Net通用分页类(存储过程分页版,完全自定义显示样式,包括中英显示)

最新推荐文章于 2024-07-30 19:26:47 发布

weixin_34292924

最新推荐文章于 2024-07-30 19:26:47 发布

阅读量87

点赞数

文章标签：数据库 javascript ViewUI

原文链接：http://www.cnblogs.com/84ww/archive/2008/08/02/1258744.html

版权

using System;

using System.Collections.Generic;

using System.Text;

/**/ /// <summary>

/// .Net通用分页类(存储过程分页版,完全自定义显示样式,包括中英显示)

/// 作者:启程 www.letwego.cn

/// 可用于任意用途,请保留作者信息，谢谢！

/// </summary>

namespace Ask.Common

{

/**//// <summary>

/// 分页（只处理分页，与数据无关）

/// </summary>

public class PageStyle

{

初始构造#region 初始构造

public PageStyle(string Language)

{

if (Language == "EN")//英文默认

{

PageString = "Page [PageIndex]/[TotalPage]  Info [PageSize]/[TotalRecord]  [FirstStr] [PrevStr] [PageNumber] [NextStr] [LastStr]  [TurnControl]";

TurnUrlStr = "";

PageSize = 20;

PageIndex = 1;

TotalRecord = 0;

FirstStr = "<<";

PrevStr = "<";

NextStr = ">";

LastStr = ">>";

NoRecord = "Total 0";

ButtonStr = " GO ";

TotalPage = 0;

TurnControl = "";

PageNumber = "";

ShowPageStr = "";

}

else//中文默认

{

PageString = "第[PageIndex]页/共[TotalPage]页  第每[PageSize]条/共[TotalRecord]条  [FirstStr] [PrevStr] [PageNumber] [NextStr] [LastStr]  [TurnControl]";

TurnUrlStr = "";

PageSize = 20;

PageIndex = 1;

TotalRecord = 0;

FirstStr = "首页";

PrevStr = "上一页";

NextStr = "下一页";

LastStr = "尾页";

NoRecord = "共有 0 条信息";

ButtonStr = "跳转";

TotalPage = 0;

TurnControl = "";

PageNumber = "";

ShowPageStr = "";

}

#endregion

字段公共#region 字段公共

/**//// <summary>

/// 具体样式（需要显示哪些内容）

/// </summary>

public string PageString;

/**//// <summary>

/// 跳转的url链接

/// </summary>

public string TurnUrlStr;

/**//// <summary>

/// 跳转的url链接的参数前面不要加问号和与号

/// </summary>

public string Parameters;

/**//// <summary>

/// 每页记录数

/// </summary>

public int PageSize;

/**//// <summary>

/// 需要获取第几页的数据，从 1 开始

/// </summary>

public int PageIndex;

/**//// <summary>

/// 总记录数

/// </summary>

public int TotalRecord;

/**//// <summary>

/// 首页显示样式

/// </summary>

public string FirstStr;

/**//// <summary>

/// 上一页显示样式

/// </summary>

public string PrevStr;

/**//// <summary>

/// 下一页显示样式

/// </summary>

public string NextStr;

/**//// <summary>

/// 尾页显示样式

/// </summary>

public string LastStr;

/**//// <summary>

/// 没有记录时显示的信息

/// </summary>

public string NoRecord;

/**//// <summary>

/// 跳转按钮文字

/// </summary>

public string ButtonStr;

#endregion

字段私有#region 字段私有

/**//// <summary>

/// 总页数

/// </summary>

private int TotalPage;

/**//// <summary>

/// 跳转控件

/// </summary>

private string TurnControl;

/**//// <summary>

/// 存储中间的内容（如 1 2 3 页码）

/// </summary>

private string PageNumber;

/**//// <summary>

/// 显示页码的总字符

/// </summary>

private string ShowPageStr;

#endregion

获取最终页码显示#region 获取最终页码显示

/**//// <summary>

/// 获取最终页码显示

/// </summary>

/// <param name="Style">样式（1 是上下页，2 是显示一批页码）</param>

/// <param name="PlaceIn">固定当前页在第几个位置（样式2用）</param>

/// <param name="ShowNum">一页显示几个页码（样式2用）</param>

/// <returns>最终页码显示</returns>

public string GetShowPageStr(string Style, int PlaceIn, int ShowNum)

{

TotalPage = (TotalRecord + PageSize - 1) / PageSize;

//超出最小页码

if (PageIndex < 1)

{

PageIndex = 1;

}

//超出最大页码

if (PageIndex > TotalPage)

{

PageIndex = TotalPage;

}

//跳转

TurnControl = "<input value='" + PageIndex.ToString() + "' id='txtPageGo' name='txtPageGo' type='text' style='width:35px;' οnkeydοwn=\"if(event.keyCode==13)window.location.href='" + TurnUrlStr + "?Page=' + document.getElementById('txtPageGo').value + '" + "&" + Parameters + "'\"><input name='btnGo' type='button' id='btnGo' value='" + ButtonStr + "' οnclick=\"javascript:window.location.href='" + TurnUrlStr + "?Page=' + document.getElementById('txtPageGo').value + '" + "&" + Parameters + "'\">";

//没有记录

if (TotalRecord <= 0)

{

ShowPageStr = NoRecord;

}

//有记录

else

{

//只有一页

if (TotalPage <= 1)

{

ShowPageStr = "共有 " + TotalRecord.ToString() + " 条信息";

}

//不止一页

else

{

//第一页

if (PageIndex == 1)

{

}

else

{

FirstStr = "<a href=\"" + TurnUrlStr + "?Page=1" + "&" + Parameters + "\">" + FirstStr + "</a>";

PrevStr = "<a href=\"" + TurnUrlStr + "?Page=" + Convert.ToString(PageIndex - 1) + "&" + Parameters + "\">" + PrevStr + "</a>";

}

//最后一页

if (PageIndex == TotalPage)

{

}

else

{

NextStr = "<a href=\"" + TurnUrlStr + "?Page=" + Convert.ToString(PageIndex + 1) + "&" + Parameters + "\">" + NextStr + "</a>";

LastStr = "<a href=\"" + TurnUrlStr + "?Page=" + TotalPage + "&" + Parameters + "\">" + LastStr + "</a>";

}

样式一: 共X条信息第N页/共M页首页上一页下一页尾页跳转#region 样式一: 共X条信息第N页/共M页首页上一页下一页尾页跳转

if (Style == "1")

{

PageNumber = "";

}

#endregion

样式三: 共X条信息第N页/共M页首页 1 2 3 尾页跳转当前页码定位在第 PlaceIn 位#region 样式三: 共X条信息第N页/共M页首页 1 2 3 尾页跳转当前页码定位在第 PlaceIn 位

if (Style == "2")

{

int PageTemp = 0;

if (PlaceIn < 1 || PlaceIn > ShowNum)

{

PlaceIn = 2;//前面保持有两个,则当前页码定位在第3位

}

else

{

PlaceIn = PlaceIn - 1;//前面保持有 PlaceIn - 1 个

}

string strPageNum = "";

string strTempNow = "";

//当页码总数 <= 一页要显示的页码数

if (TotalPage <= ShowNum)

{

for (int i = 1; i <= TotalPage; i++)

{

strTempNow = Convert.ToString(PageTemp + i);

//当前页不显示超链接

if (PageIndex == PageTemp + i)

{

strPageNum = strPageNum + "<b>" + strTempNow + "</b>  ";

}

else

{

strPageNum = strPageNum + "<a href=\"" + TurnUrlStr + "?Page=" + strTempNow + "&" + Parameters + "\">[" + strTempNow + "]</a>  ";

}

else

{

//当前页码 <= 固定位置 PlaceIn

if (PageIndex <= PlaceIn)

{

for (int i = 1; i <= ShowNum; i++)

{

strTempNow = Convert.ToString(i);

//当前页不显示超链接

if (PageIndex == i)

{

strPageNum = strPageNum + "<b>" + strTempNow + "</b>  ";

}

else

{

strPageNum = strPageNum + "<a href=\"" + TurnUrlStr + "?Page=" + strTempNow + "&" + Parameters + "\">[" + strTempNow + "]</a>  ";

}

//当前页码 >=最后一批该显示

else if (PageIndex >= TotalPage - ShowNum + PlaceIn + 1)

{

//第一个显示的数字

PageTemp = TotalPage - ShowNum + 1;

for (int i = PageTemp; i <= TotalPage; i++)

{

if (i > TotalPage) break;

strTempNow = Convert.ToString(i);

//当前页不显示超链接

if (PageIndex == i)

{

strPageNum = strPageNum + "<b>" + strTempNow + "</b>  ";

}

else

{

strPageNum = strPageNum + "<a href=\"" + TurnUrlStr + "?Page=" + strTempNow + "&" + Parameters + "\">[" + strTempNow + "]</a>  ";

}

else

{

for (int i = PageIndex - PlaceIn; i < PageIndex - PlaceIn + ShowNum; i++)

{

strTempNow = Convert.ToString(i);

//当前页不显示超链接

if (i == PageIndex)

{

strPageNum = strPageNum + "<b>" + strTempNow + "</b>  ";

}

else

{

strPageNum = strPageNum + "<a href=\"" + TurnUrlStr + "?Page=" + strTempNow + "&" + Parameters + "\">[" + strTempNow + "]</a>  ";

}

PageNumber = strPageNum;

}

#endregion

}

ShowPageStr = PageString;

ShowPageStr = ShowPageStr.Replace("[PageIndex]", PageIndex.ToString());//

ShowPageStr = ShowPageStr.Replace("[TotalPage]", TotalPage.ToString());//

ShowPageStr = ShowPageStr.Replace("[PageSize]", PageSize.ToString());//

ShowPageStr = ShowPageStr.Replace("[TotalRecord]", TotalRecord.ToString());//

ShowPageStr = ShowPageStr.Replace("[FirstStr]", FirstStr);//

ShowPageStr = ShowPageStr.Replace("[PrevStr]", PrevStr);//

ShowPageStr = ShowPageStr.Replace("[NextStr]", NextStr);//

ShowPageStr = ShowPageStr.Replace("[LastStr]", LastStr);//

ShowPageStr = ShowPageStr.Replace("[TurnControl]", TurnControl);//

ShowPageStr = ShowPageStr.Replace("[PageNumber]", PageNumber);//

return ShowPageStr;

}

#endregion

}

调用实例#region 调用实例

/**//*

protected void BindData()

{

PageStyle MyPage = new PageStyle("EN");//创建类

MyPage.PageSize = MyPageSize;//页码大小

MyPage.TotalRecord = Counts;//总记录数

MyPage.TurnUrlStr = "AskSearchList.aspx";//要跳转的页面(当前页)

MyPage.Parameters = MyParameters;//页面所带参数

MyPage.PageIndex = PageIndex;//当前要显示的页码

//具体样式

MyPage.PageString = "第[PageIndex]页/共[TotalPage]页  第每[PageSize]条/共[TotalRecord]条  [FirstStr] [PrevStr] [PageNumber] [NextStr] [LastStr]  [TurnControl]";

string strPage = MyPage.GetShowPageStr("2", 3, 10);

labShowPage.Text = strPage;

}

#endregion

简要说明#region 简要说明

/**//*

.Net通用分页类(存储过程分页版,可以完全自定义显示样式,包括中英显示).

大概思路是:主要是利用存储过程在数据库进行分页,

所以在这个类里面不涉及到数据的处理,只进行页码的显示格式处理,

配合SQL2005 的 ROW_NUMBER () 功能,能够达到更好的效果.

显示样式可以完全自定义,,用图片也可以,只是要把字符串拼成图片的Html

效果图:https://images.cnblogs.com/cnblogs_com/84ww/128905/r_PageStore.gif

#endregion

附存储过程例子#region 附存储过程例子

/**//*

CREATE PROCEDURE dbo.sp_userinfoList

@strOptions varchar(200) = NULL,

@PageSize int = 20,

@PageIndex int = 1,

@Counts int = 0 OUTPUT

SET NOCOUNT ON

SET ANSI_WARNINGS OFF

DECLARE @PageUp int

DECLARE @PageDown int

--处理页大小

IF @PageSize = -1 SET @PageSize = 20

--获得总记录数

SELECT @Counts = COUNT(1) FROM userinfo

--当前页的第一条记录RowID

SET @PageDown = @PageSize * @PageIndex + 1

--当前页的最后一条记录RowID

SET @PageUp = @PageSize * (@PageIndex + 1)

-- 信息列表

IF @strOptions='LIST' BEGIN

SELECT

id,

user,

password,

datetime,

content

FROM

(

SELECT * ,

PageTableRowID = ROW_NUMBER () OVER (ORDER BY id DESC)

FROM userinfo

) AS PageTableList

WHERE PageTableRowID BETWEEN @PageDown AND @PageUp

END

#endregion

}

转载于:https://www.cnblogs.com/84ww/archive/2008/08/02/1258744.html

weixin_34292924

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
.Net通用分页类(存储过程分页版,完全自定义显示样式,包括中英显示)

usingSystem;usingSystem.Collections.Generic;usingSystem.Text;/**////<summary>///.Net通用分页类(存储过程分页版,完全自定义显示样式,包括中英显示)///作者:启程www.letwego.cn///可用于任意用途,请保留作者信息，谢谢！///</su...
复制链接

扫一扫