English
MvcPager分页控件
MvcPager分页示例—使用分页存储过程
本示例演示如何使用分页存储过程获取当前页数据，通过构造函数创建PagedList<T>对象并实现分页。
| 订单编号 | 订单日期 | 顾客编号 | 收货地址 |
|---|---|---|---|
| 10960 | 1998/3/19 0:00:00 | HILAA | Carrera 22 con Ave. Carlos Soublette #8-35 |
| 10961 | 1998/3/19 0:00:00 | QUEEN | Alameda dos Canàrios, 891 |
| 10962 | 1998/3/19 0:00:00 | QUICK | Taucherstraße 10 |
| 10963 | 1998/3/19 0:00:00 | FURIB | Jardim das rosas n. 32 |
| 10964 | 1998/3/20 0:00:00 | SPECD | 25, rue Lauriston |
| 10965 | 1998/3/20 0:00:00 | OLDWO | 2743 Bering St. |
| 10966 | 1998/3/20 0:00:00 | CHOPS | Hauptstr. 31 |
| 10967 | 1998/3/23 0:00:00 | TOMSP | Luisenstr. 48 |
| 10968 | 1998/3/23 0:00:00 | ERNSH | Kirchgasse 6 |
| 10969 | 1998/3/23 0:00:00 | COMMI | Av. dos Lusíadas, 23 |
| 10970 | 1998/3/24 0:00:00 | BOLID | C/ Araquil, 67 |
| 10971 | 1998/3/24 0:00:00 | FRANR | 54, rue Royale |
| 10972 | 1998/3/24 0:00:00 | LACOR | 67, avenue de l'Europe |
| 10973 | 1998/3/24 0:00:00 | LACOR | 67, avenue de l'Europe |
| 10974 | 1998/3/25 0:00:00 | SPLIR | P.O. Box 555 |
| 10975 | 1998/3/25 0:00:00 | BOTTM | 23 Tsawassen Blvd. |
| 10976 | 1998/3/25 0:00:00 | HILAA | Carrera 22 con Ave. Carlos Soublette #8-35 |
| 10977 | 1998/3/26 0:00:00 | FOLKO | Åkergatan 24 |
| 10978 | 1998/3/26 0:00:00 | MAISD | Rue Joseph-Bens 532 |
| 10979 | 1998/3/26 0:00:00 | ERNSH | Kirchgasse 6 |
<%@ 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);
}
}