MVC+Bootstrap+Drapper使用PagedList.Mvc支持多查询条件分页_实用技巧_

 public class OrderQueryParamModel { /// 
 /// 订单编号 /// 
 public string OrderNo { get; set; } /// 
 /// 客户名称 /// 
 public string CustomerName { get; set; } }

 public StaticPagedList(IEnumerable subset, IPagedList metaData) : this(subset, metaData.PageNumber, metaData.PageSize, metaData.TotalItemCount) { }

 public class OrderViewModel { public OrderQueryParamModel QueryModel { get; set; } public PagedList.StaticPagedList OrderList { get; set; } }

 public ActionResult List(OrderViewModel orderViewModel, int page = 1) { var pagesize = 10; var count = 0; var orders = _orderService.GetOrders(page, pagesize, model.QueryModel, ref count); orderViewModel.OrderList = new StaticPagedList(orders, page, pagesize, count); return View(orderViewModel); }

 public List GetOrders(int pageindex, int pagesize, OrderQueryParamModel query, ref int count) { var orders = new List(); var whereStr = string.Empty; if (query != null) { if (!string.IsNullOrEmpty(query.CustomerName)) { whereStr += string.Format(" and CustomerName like '%{0}%' ", query.CustomerName); } } var cmd = string.Format(@"SELECT COUNT(*) FROM [Orders] WHERE 1=1 {0}; SELECT * FROM ( SELECT *, row_number() OVER (ORDER BY orderId DESC ) AS [row] FROM [Orders] WHERE 1=1 {0} )t WHERE t.row >@indexMin AND t.row<=@indexMax", whereStr); using (IDbConnection conn = BaseDBHelper.GetConn()) { using (var multi = conn.QueryMultiple(cmd, new { indexMin = (pageindex - 1) * pagesize, indexMax = pageindex * pagesize })) { count = multi.Read().SingleOrDefault(); orders = multi.Read().ToList(); } } return orders; }

 @using PagedList.Mvc; @using PagedList; @model Models.OrderViewModel

 @using (Html.BeginForm("List", "Order", FormMethod.Post, new { id = "OrderForm", @class = "form-horizontal" })) { @Html.Raw("客户名称：") @Html.TextBoxFor(m => m.QueryModel.CustomerName) @Html.Raw("订单编号：") @Html.TextBoxFor(m => m.QueryModel.OrderNo) 查询 //咿，这个干吗用的？后面会解释  } 

 @foreach (var item in Model.OrderList) {  } 
订单编号
客户名称
手机号码
商品数量
订单金额
下单时间
@item.orderNo
@item.customerName
@item.customerMobile
@item.productQuantity
@item.orderAmount
@item.orderCreateTime

 @if (Model.OrderList != null&&Model.OrderList.Any()) { 
 @Html.PagedListPager(Model.OrderList, page => Url.Action("List", new { page }), PagedListRenderOptions.Classic) 
 } 

 $(function () { $(".pagination > li > a").click(function () { event.preventDefault(); var index = $(this).html(); if (index == '»') { index = parseInt($(".pagination > li[class=active] > a").html()) + 1; } if (index == '«') { index = parseInt($(".pagination > li[class=active] > a").html()) - 1; } if (index < 1) return; $("input[name=page]").val(index); $("#OrderForm").submit(); }); });