分頁是每個列表頁都躲不掉的東西,與其每頁重寫一次,不如做成前端函數 + 後端算總數的組合。這裡記錄一套以 jQuery(其實純 JavaScript 即可)搭配 ASP.NET 的實作。
思路是以當前頁為中心,向前後各取一半,頭尾頁永遠顯示,中間缺口用省略號帶過。
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;
}
}
if (_IsUpDown) {
if (_CurrentPageSize == 1) strResult = "<a href='#'>上一頁</a>" + strResult;
else strResult = " <a href=\"#\" onclick=\"" + _FunName + "(" + (_CurrentPageSize - 1) + ");\">上一頁</a>" + strResult;
if (_CurrentPageSize == _MaxPageSize) strResult += " <a>下一頁</a>";
else strResult += " <a href=\"#\" onclick=\"" + _FunName + "(" + (_CurrentPageSize + 1) + ");\">下一頁</a>";
}
document.getElementById(objDiv).innerHTML = strResult;
}
<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>
列表本體用 asp:DataList 綁定,下方預留一個空 DIV 給分頁列:
<div class="fy">
<div id="divPage"></div>
</div>
<asp:Literal ID="ltScript" runat="server"></asp:Literal>
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();
int total = Convert.ToInt32(tChrisTable.Tables[1].Rows[0][0].ToString());
_MaxPageSize = total % pageSize == 0 ? total / pageSize : total / pageSize + 1;
}
}
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;
這套做法的關鍵在於「一次查詢回傳兩個結果集」:第一個是當前頁的資料,第二個是總筆數。前端只負責畫面,後端只負責資料與總數,雙方透過 InitPage 的三個數字(當前頁、總頁數、每頁顯示頁碼數)溝通。若要改成純 AJAX 版本,把 GetCurPage 換成 $.getJSON 呼叫即可,其餘邏輯不必更動。