复制代码 代码如下:
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 += " <a href='#'>" + curPage + "</a>";
}
else {
strPage += " <a href=https://www.jb51.net/article/\"#\" onclick=https://www.jb51.net/article/\"" + _FunName + "(" + curPage + ");\">" + curPage + "</a>";
}
if (curPage == maxSize && _MaxPageSize - _CurrentPageSize - 1 > size) {
strPage += "... ";
}
strResult += strPage;
}
}
strResult += "";
if (_IsUpDown) {
if (_CurrentPageSize == 1)
strResult = "<a href='#' >上一页</a>" + strResult;
else
strResult = " <a href=https://www.jb51.net/article/\"#\" onclick=https://www.jb51.net/article/\"" + _FunName + "(" + (_CurrentPageSize - 1) + ");\">上一页</a>" + strResult;
if (_CurrentPageSize == _MaxPageSize) {
strResult = strResult + " <a>下一页</a></ul>";
}
else {
strResult = strResult + " <a href=https://www.jb51.net/article/\"#\" onclick=https://www.jb51.net/article/\"" + _FunName + "(" + (_CurrentPageSize + 1) + ");\">下一页</a>";
}
}
document.getElementById(objDiv).innerHTML =strResult;
}
HTML Code:
复制代码 代码如下:
<script src="https://www.jb51.net/js/PageViewJS.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
function GetCurPage(curPage) {
//取当前页信息
document.forms[0].action = "ChrisBlessingList.aspx?Page=" + curPage;
document.forms[0].submit();
}
</script>
</head>
<body>
<form runat="server">
<div>
<div><img src="https://www.jb51.net/images/sdzt_07.jpg" usemap="#Map" /></div>
<div>
<div>
<ul>
<asp:DataList runat="server">
<ItemTemplate>
<li>
<table cellspacing="0" cellpadding="0">
<tr>
<td rowspan="2">
<img src="https://www.jb51.net/images/sdzt_02/img.jpg" />
</td>
<td valign="middle">
<%#Eval("User_Name")%>
对 【
<%#Eval("To_UserName")%>】说：
</td>
</tr>
<tr>
<td valign="top">
<%#Eval("To_Context")%>
</td>
</tr>
</table>
</li>
</ItemTemplate>
</asp:DataList>
</ul>
</div>
<div>
<div>
</div>
</div>
</div>
<div>
</div>
</div>
</div>
<asp:Literal runat="server"></asp:Literal>
</form>
</body>
</html>
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 = "<script language=https://www.jb51.net/article/\"javascript\" type=https://www.jb51.net/article/\"text/javascript\">InitPage(\"GetCurPage\", " + page + ", " + _MaxPageSize + ", 8, true); ShowPage(\"divPage\");</script>";
}
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
您可能感兴趣的文章: