基于jquery的分页控件(C#)_jquery



JS代码：
Code：
代码如下:
var _MaxPageSize = 0;
var _PageSize = 5;
var _IsUpDown = false;
function InitPage(funName, currentPageSize, maxPageSize, pageSize, isUpDown) {
_FunName = funName;
_CurrentPageSize = currentPageSize;
_MaxPageSize = maxPageSize;
_PageSize = pageSize;
_IsUpDown = isUpDown;
}
function ShowPage(objDiv) {
var strResult = "";
var size = Math.floor(_PageSize / 2);
var maxSize = _CurrentPageSize + size > _MaxPageSize ? _MaxPageSize : _CurrentPageSize + size;
var minSize = _CurrentPageSize - size < 1 ? 1 : _CurrentPageSize - size;
if (maxSize == _MaxPageSize)
minSize = maxSize - _PageSize + 1;
if (minSize == 1)
maxSize = minSize + _PageSize - 1;
var str = "";
for (var i = 0; i < _MaxPageSize; i++) {
var curPage = i + 1;
if (curPage == 1 || (curPage >= minSize && curPage <= maxSize) || curPage == _MaxPageSize) {
var strPage = "";
if (curPage == minSize && (_CurrentPageSize > _PageSize || minSize > 2))
strPage += "... ";
if (_CurrentPageSize == curPage) {
strPage += " " + curPage + "";
}
else {
strPage += " " + curPage + "";
}
if (curPage == maxSize && _MaxPageSize - _CurrentPageSize - 1 > size) {
strPage += "... ";
}
strResult += strPage;
}
}
strResult += "";
if (_IsUpDown) {
if (_CurrentPageSize == 1)
strResult = "上一页" + strResult;
else
strResult = " 上一页" + strResult;
if (_CurrentPageSize == _MaxPageSize) {
strResult = strResult + " 下一页";
}
else {
strResult = strResult + " 下一页";
}
}
document.getElementById(objDiv).innerHTML =strResult;
}

HTML Code:
代码如下:


function GetCurPage(curPage) {
//取当前页信息
document.forms[0].action = "ChrisBlessingList.aspx?Page=" + curPage;
document.forms[0].submit();
}







C# Code：
代码如下:
private int _MaxPageSize = 1;
protected void Page_Load(object sender, EventArgs e)
{
int page = 1;
if (Request.QueryString["Page"] != null && Request.QueryString["Page"].ToString() != "")
{
page = Convert.ToInt32(Request.QueryString["Page"]);
}
int _PageSize = 5;
BindChristData(page, _PageSize);
ltScript.Text = "InitPage(\"GetCurPage\", " + page + ", " + _MaxPageSize + ", 8, true); ShowPage(\"divPage\");";
}
private void BindChristData(int pageIndex, int pageSize)
{
int intStartIndex = (pageIndex - 1) * pageSize + 1;
int intEndIndex = pageIndex * pageSize;
DataSet tChrisTable = TChristmaxWishBLL.GetTChristmaxWish(intStartIndex, intEndIndex);
if (tChrisTable != null && tChrisTable.Tables[0].Rows.Count > 0)
{
ddlBlessingList.DataSource = tChrisTable;
ddlBlessingList.DataBind();
_MaxPageSize = Convert.ToInt32(tChrisTable.Tables[1].Rows[0][0].ToString()) % pageSize == 0 ? Convert.ToInt32(tChrisTable.Tables[1].Rows[0][0].ToString()) / pageSize : Convert.ToInt32(tChrisTable.Tables[1].Rows[0][0].ToString()) / pageSize + 1;
}
}
Sql语句：
select row_num,User_Name,User_Email,User_Phone,To_UserName,To_Context from(SELECT ROW_NUMBER() OVER ( ORDER BY To_Date desc)as row_num,User_Name,User_Email,User_Phone,To_UserName,To_Context from TChristmaxWish where Is_Del=0 )as newTable where row_num between @intStrIndex and @intEndIndex;
select count(id) from TChristmaxWish where Is_Del=0