MvcPager分页控件

MvcPager分页示例—使用分页存储过程

本示例演示如何使用分页存储过程获取当前页数据，通过构造函数创建PagedList<T>对象并实现分页。

示例
View代码
存储过程
Controller代码

订单编号	订单日期	顾客编号	收货地址
10780	1997/12/16 0:00:00	LILAS	Carrera 52 con Ave. Bolívar #65-98 Llano Largo
10781	1997/12/17 0:00:00	WARTH	Torikatu 38
10782	1997/12/17 0:00:00	CACTU	Cerrito 333
10783	1997/12/18 0:00:00	HANAR	Rua do Paço, 67
10784	1997/12/18 0:00:00	MAGAA	Via Ludovico il Moro 22
10785	1997/12/18 0:00:00	GROSR	5ª Ave. Los Palos Grandes
10786	1997/12/19 0:00:00	QUEEN	Alameda dos Canàrios, 891
10787	1997/12/19 0:00:00	LAMAI	1 rue Alsace-Lorraine
10788	1997/12/22 0:00:00	QUICK	Taucherstraße 10
10789	1997/12/22 0:00:00	FOLIG	184, chaussée de Tournai
10790	1997/12/22 0:00:00	GOURL	Av. Brasil, 442
10791	1997/12/23 0:00:00	FRANK	Berliner Platz 43
10792	1997/12/23 0:00:00	WOLZA	ul. Filtrowa 68
10793	1997/12/24 0:00:00	AROUT	Brook Farm Stratford St. Mary
10794	1997/12/24 0:00:00	QUEDE	Rua da Panificadora, 12
10795	1997/12/24 0:00:00	ERNSH	Kirchgasse 6
10796	1997/12/25 0:00:00	HILAA	Carrera 22 con Ave. Carlos Soublette #8-35
10797	1997/12/25 0:00:00	DRACD	Walserweg 21
10798	1997/12/26 0:00:00	ISLAT	Garden House Crowther Way
10799	1997/12/26 0:00:00	KOENE	Maubelstr. 90

首页上一页 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 ... 下一页尾页

<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" 
Inherits="System.Web.Mvc.ViewPage<PagedList<MvcPagerSample.Models.Order>>" %>
<%@ Import Namespace="MvcPagerSample.Models" %>
<%@ Import Namespace="Webdiyer.WebControls.Mvc" %>

<asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">
	MvcPager分页示例—使用分页存储过程
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <h2>MvcPager分页示例—使用分页存储过程</h2>
    <div>本示例演示如何使用分页存储过程获取当前页数据，
    通过构造函数创建PagedList<T>对象并实现分页。</div><br />

<table width="98%">
<tr><th>订单编号</th><th>订单日期</th><th>顾客编号</th><th>收货地址</th></tr>
<%foreach(Order od in Model)
 {
     %>
     <tr><td><%=od.OrderID %></td><td><%=od.OrderDate.ToString() %></td>
     <td><%=od.CustomerID %></td><td><%=od.ShipAddress %></td></tr>
     <%
 } %>
</table>
 <%=Html.Pager(Model, new PagerOptions { PageIndexParameterName = "id",
 NumericPagerItemCount=15})%>
</asp:Content>

Create PROCEDURE P_GetPagedOrders2005
(@startIndex INT, 
 @endindex INT
 )
AS
begin
WITH orderList AS ( 
SELECT ROW_NUMBER() OVER (ORDER BY O.orderid DESC)AS Row, O.*
from orders O)

SELECT * FROM orderlist
WHERE Row between @startIndex and @endIndex

end

/// <summary>
/// 使用存储过程获取分页数据示例
/// </summary>
/// <param name="id">当前页索引</param>
/// <returns></returns>
public ActionResult StoredProcedure(int? id)
{
    using (var db = new MvcPagerSampleDataContext())
    {
	//起始记录索引
	int startIndex = id.HasValue&&id.Value>1 ? (id.Value-1)*20+1:0;
	//通过分页存储过程获取当前页的数据
	List<Order> orders = db.GetPagedOrders(startIndex,startIndex+20).ToList();
	//要分页的数据总数
	int totalOrders = db.Orders.Count();
	//用构造函数创建PagedList<T>对象
	PagedList<Order> pagedOrders = new PagedList<Order>(orders, id ?? 1, 20, totalOrders);
	return View(pagedOrders);
    }
}