DIV CSS 佈局教程網

用 jQuery 打造 C# 網站的通用分頁列
編輯:JQuery特效代碼     

分頁是每個列表頁都躲不掉的東西,與其每頁重寫一次,不如做成前端函數 + 後端算總數的組合。這裡記錄一套以 jQuery(其實純 JavaScript 即可)搭配 ASP.NET 的實作。

JavaScript:算出該顯示哪些頁碼

思路是以當前頁為中心,向前後各取一半,頭尾頁永遠顯示,中間缺口用省略號帶過。

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>

C#:算出總頁數並觸發前端繪製

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;
    }
}

SQL:用 ROW_NUMBER 做索引分頁

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 呼叫即可,其餘邏輯不必更動。

XML學習教程| jQuery入門知識| AJAX入門| Dreamweaver教程| Fireworks入門知識| SEO技巧| SEO優化集錦|
Copyright © DIV+CSS佈局教程網 All Rights Reserved