杨涛主页
Fork me on GitHub

UrlPager 示例 - Url逆向分页

本示例演示如何使用UrlPager分页控件进行逆向分页，逆向分页即Url中显示的页索引与实际页索引逆转。
Order IDOrder DateCompany NameCustomer IDEmployee Name
11007 1998/4/8 Princesa Isabel Vinhos PRINI Laura Callahan
11006 1998/4/7 Great Lakes Food Market GREAL Janet Leverling
11005 1998/4/7 Wilman Kala WILMK Andrew Fuller
11004 1998/4/7 Maison Dewey MAISD Janet Leverling
11003 1998/4/6 The Cracker Box THECR Janet Leverling
11002 1998/4/6 Save-a-lot Markets SAVEA Margaret Peacock
11001 1998/4/6 Folk och fä HB FOLKO Andrew Fuller
11000 1998/4/6 Rattlesnake Canyon Grocery RATTC Andrew Fuller
10999 1998/4/3 Ottilies Käseladen OTTIK Michael Suyama
10998 1998/4/3 Wolski Zajazd WOLZA Laura Callahan
 First Prev ... 3 4 5 6 7 8 9 10 11 12 ... Next Last

路由定义：

routes.MapPageRoute("UrlPager_ReversePageIndex",
                "urlpager/demos/{controller}/{action}/{pageIndex}",
                "~/UrlPager/Demos/ReversePageIndex.aspx", false, new RouteValueDictionary { { "controller", "ReversePageIndex" }, { "action", "List" }, { "pageIndex", null } }, new RouteValueDictionary { { "controller", "ReversePageIndex" }, { "action", "List" } });

ReversePageIndex.aspx:

    
 <%@Register Namespace="Webdiyer.WebControls" Assembly="Webdiyer.UrlPager" TagPrefix="webdiyer"%>
    <asp:Repeater ID="Repeater1" runat="server">
    <headertemplate>
    <table class="table table-bordered table-hover">
    <tr><th>Order ID</th><th>Order Date</th><th>Company Name</th><th>Customer ID</th><th>Employee Name</th></tr>
        </headertemplate>
    <itemtemplate>
    <tr>
    <td><%#DataBinder.Eval(Container.DataItem,"orderid")%></td>
    <td><%#DataBinder.Eval(Container.DataItem,"orderdate","{0:d}")%></td>
    <td><%#DataBinder.Eval(Container.DataItem, "companyname")%></td>
    <td><%#DataBinder.Eval(Container.DataItem,"customerid")%></td>
    <td><%#DataBinder.Eval(Container.DataItem,"employeename")%></td>
        </tr>
        </itemtemplate>
    <footertemplate>
        </table>
        </footertemplate>
        </asp:Repeater>
    <webdiyer:UrlPager runat="server" id="pager1" RouteName="UrlPager_ReversePageIndex" PagerItemTemplate="&nbsp;{0}"
                       ReversePageIndex="true" OnPageChanged="PageChanged"></webdiyer:UrlPager>

ReversePageIndex.aspx.cs:

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace Webdiyer.UrlPagerDemo
{
    public partial class ReversePageIndex : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
                pager1.TotalItemCount = (int)SqlHelper.ExecuteScalar(CommandType.StoredProcedure, "P_GetOrderNumber");
        }
        protected void PageChanged(object sender, EventArgs e)
        {
            Repeater1.DataSource = SqlHelper.ExecuteReader(CommandType.StoredProcedure, ConfigurationManager.AppSettings["pagedSPName"],
                new SqlParameter("@startIndex", pager1.StartItemIndex),
                new SqlParameter("@endIndex", pager1.EndItemIndex));
            Repeater1.DataBind();
        }
    }
}