Asp.Net MVC 分页、检索、排序整体实现代码(2)

public static int UserPageItemCount { get { if (_userPageItemCount == 0) { _userPageItemCount = WebConfigurationManager.AppSettings["UserPageItemCount"] != null ? Convert.ToInt16(WebConfigurationManager.AppSettings["UserPageItemCount"]) : 5; } return _userPageItemCount; } set { _userPageItemCount = value; } }

再进行绑定：

_kernel.Bind<IUsersRepository>().To<UsersRepository>();

三、控制器部分

我们需要两个页面，一个主页面Index，一个负责局部刷新的部分视图 UserTable

下面是主要的方法，主要逻辑都在在仓库中处理了。

[Authorize] public class UserManagerController : Controller { /// <summary> /// The _repository /// </summary> private readonly IUsersRepository _repository; /// <summary> /// Initializes a new instance of the <see cref="UserManagerController"/> class. /// </summary> /// <param>The i repository.</param> public UserManagerController(IUsersRepository iRepository) { _repository = iRepository; } /// <summary> /// Indexes the specified page index. /// </summary> /// <param>Index of the page.</param> /// <returns>ActionResult.</returns> public ActionResult Index(int pageIndex=1) { ViewBag.DisplayPage = _repository.DisplayPage; pageIndex = HandlePageindex(pageIndex); //支持地址栏直接分页 ViewBag.CurrentPage = pageIndex; return View(); } /// <summary> /// Users table. 分页模块 /// </summary> /// <param>Index of the page.</param> /// <param>The order.</param> /// <param>The filter str.</param> /// <returns>ActionResult.</returns> public ActionResult UserTable(int pageIndex = 1, int order = 0, string filter = "") { pageIndex = HandlePageindex(pageIndex); var skip = (pageIndex - 1) * _repository.PageItemCount; var users = _repository.Find(order,filter, skip, _repository.PageItemCount); //总用户数 ViewBag.TotalUser = _repository.TotalItem; //总页数 ViewBag.TotalPageCount = _repository.TotoalPage; ; return PartialView(users); } /// <summary> /// 处理页数 防止过大或过小 /// </summary> /// <param></param> /// <returns></returns> private int HandlePageindex(int index) { var totoalpage = _repository.TotoalPage; if (index == 0) return 1; return index > totoalpage ? totoalpage : index; } }

四、视图部分Html jquery

1.Index.cshtml

<script src="https://www.jb51.net/~/Scripts/form.js"></script> <div> <h4>管理用户</h4> <p> <button data-target="#adduser" data-toggle="modal">新增用户</button> <button>删除</button> <span></span> <input type="search" placeholder="搜索"/> </p> <div> @Html.Action("UserTable",new{pageIndex=ViewBag.CurrentPage}) </div> <div></div> <input type="hidden" value="@ViewBag.DisplayPage"/> <input type="hidden" value="@ViewBag.CurrentPage"/> <input type="hidden" value="@ViewBag.CurrentPage"/> </div> <divid="adduser" tabindex="1" role="dialog" aria-hidden="true"> <div> <div> <button type="button" data-dismiss="modal" aria-hidden="true" >&times;</button> <h4>Add new User</h4> </div> <div> @{ Html.RenderAction("Create","UserManager"); } </div> </div> </div> @section Scripts { @Scripts.Render("~/bundles/jqueryval") }

2.UserTable.cshtml,角色部分还未处理，这个表格更新之后，也会更新满足条件的用户数和新的总页数，触发Jpaginate重新分页一次。