ASP.NET MVC分頁的實(shí)現(xiàn)方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using PagedList;
 
namespace MvcApplication1.Models
{
 public class ViewBook
 {

 public IPagedList<Book> Books { get; set; }
 public string Search { get; set; } 

 public string Category { get; set; }
 public string SortBy { get; set; } 
 }
}

public ActionResult SearchIndex(string Category, string searchString, string sortBy,int? page)
 
 {

 var cateLst = new List<string>();

 var cateQry = from d in db.Books
 orderby d.Category
 select d.Category;
 cateLst.AddRange(cateQry.Distinct());
 ViewBag.category = new SelectList(cateLst); 

 //排序選項(xiàng)
 var orderbyLst = new Dictionary<string, string>
 {
 { "價格從低到高", "price_lowest" },
 { "價格從高到低", "price_highest" }
 };

 ViewBag.sortBy = new SelectList(orderbyLst, "Value", "Key");
 // [2017-2-14 end]
 var books = from m in db.Books
 select m; 

 if (!String.IsNullOrEmpty(searchString))
 {
 books = books.Where(s => s.Name.Contains(searchString));
 }

 // sort the results
 switch (sortBy)
 {

 case "price_lowest":
 books = books.OrderBy(p => p.Price);
 break;
 case "price_highest":
 books = books.OrderByDescending(p => p.Price);
 break;
 default:
 books = books.OrderBy(p => p.Name);
 break;
 } 

 //分頁
 const int pageItems = 5;
 int currentPage = (page ?? 1);
 IPagedList<Book> pageBooks = books.ToPagedList(currentPage, pageItems);
 // [2017-2-14]
 ViewBook vbook = new ViewBook();
 vbook.Books = pageBooks;
 vbook.Category = Category;
 vbook.SortBy = sortBy;
 vbook.Search = searchString;
 if (string.IsNullOrEmpty(Category))
 vbook.Books =pageBooks;
 else
 {
 vbook.Books =pageBooks.Where(x => x.Category == Category).ToPagedList(currentPage, pageItems);
 }
 return View(vbook);
 }

@model MvcApplication1.Models.ViewBook
 @using PagedList.Mvc

@{

 ViewBag.Title = "書籍查詢";
}
 <link href="/Content/PagedList.css" rel="external nofollow" rel="external nofollow" rel="stylesheet" type="text/css" />
<h2>書籍查詢</h2>
 @using (Html.BeginForm("SearchIndex","book",FormMethod.Get)){ 
 <p>書籍種類： @Html.DropDownList("category", "All") 
 書籍名稱： @Html.TextBox("SearchString") 
 排序: @Html.DropDownList("sortBy", "不排序")
 <input type="submit" value="查詢" /> </p>
 }

<table>
 <tr>
 <th>
 @Html.DisplayNameFor(model => model.Books.First().Category)
 </th>
 <th>
 @Html.DisplayNameFor(model => model.Books.First().Name)

 </th>
 <th>
 @Html.DisplayNameFor(model => model.Books.First().Numberofcopies)

 </th>
 <th>
 @Html.DisplayNameFor(model => model.Books.First().AuthorID)

 </th>
 <th>
 @Html.DisplayNameFor(model => model.Books.First().Price)

 </th>
 <th>
 @Html.DisplayNameFor(model => model.Books.First().PublishDate)

 </th>
 <th></th>

 </tr>
@foreach (var item in Model.Books) {

 <tr>
 <td>
 @Html.DisplayFor(modelItem => item.Category)

 </td>
 <td>
 @Html.DisplayFor(modelItem => item.Name)

 </td>
 <td>
 @Html.DisplayFor(modelItem => item.Numberofcopies)

 </td>
 <td>
 @Html.DisplayFor(modelItem => item.AuthorID)

 </td>
 <td>
 @Html.DisplayFor(modelItem => item.Price)

 </td>
 <td>
 @Html.DisplayFor(modelItem => item.PublishDate)

 </td>
 <td>
 @Html.ActionLink("Edit", "Edit", new { id=item.BookID }) |

 @Html.ActionLink("Details", "Details", new { id=item.BookID }) |

 @Html.ActionLink("Delete", "Delete", new { id=item.BookID })

 </td>
 </tr>
}
</table>

<div>
 Page @(Model.Books.PageCount < Model.Books.PageNumber ? 0 : Model.Books.PageNumber) of @Model.Books.PageCount

 @Html.PagedListPager(Model.Books, page => Url.Action("SearchIndex", new { category = Model.Category, 
search = Model.Search, sortBy = Model.SortBy, page }))
 </div>