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 += " <a href='#' style='font-size:14px;color:red'>" + curPage + "</a>";
}
else {
strPage += " <a href=\"#\" style='font-size:14px' onclick=\"" + _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=\"#\" onclick=\"" + _FunName + "(" + (_CurrentPageSize - 1) + ");\">上一頁</a>" + strResult;
if (_CurrentPageSize == _MaxPageSize) {
strResult = strResult + " <a>下一頁</a></ul>";
}
else {
strResult = strResult + " <a href=\"#\" onclick=\"" + _FunName + "(" + (_CurrentPageSize + 1) + ");\">下一頁</a>";
}
}
document.getElementById(objDiv).innerHTML =strResult;
}
HTML Code:
代碼如下:
<script src="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 id="form1" runat="server">
<div style="width: 1002px; margin: 0 auto;">
<div id="hdgz"><img src="images/sdzt_07.jpg" border="0" usemap="#Map" /></div>
<div id="liebiao">
<div class="a_01" id="Container">
<ul class="lb">
<asp:DataList ID="ddlBlessingList" runat="server" Width="100%">
<ItemTemplate>
<li class="bg01">
<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100" height="90" rowspan="2">
<img src="images/sdzt_02/img.jpg" class="lb_img" />
</td>
<td width="600" align="left" valign="middle" class="font_07">
<%#Eval("User_Name")%>
對 【
<%#Eval("To_UserName")%>】說：
</td>
</tr>
<tr>
<td align="left" valign="top" class="font_07" style="word-break: break-all; width: 600px;
overflow: auto;">
<%#Eval("To_Context")%>
</td>
</tr>
</table>
</li>
</ItemTemplate>
</asp:DataList>
</ul>
</div>
<div class="fy">
<div id="divPage">
</div>
</div>
</div>
<div id="back_zhufu">
</div>
</div>
</div>
<asp:Literal ID="ltScript" 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=\"javascript\" type=\"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