MVC分页之MvcPager使用

小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

最近刚刚接触MVC不久，因项目中要用到分页，网上找了下资料，最后采用了MvcPager(http://www.webdiyer.com/),支持同步和Ajax异步分页。废话不多说了直接上代码。

一.MvcPager异步

ViewModel:

public class Article
{
[Display(Name = "信息编号")]
public int ID { get; set; } [Display(Name = "信息标题")]
public string Title { get; set; } [Display(Name = "信息内容")]
public string Content { get; set; }
}

public class AjaxPager
{
public PagedList<Article> Articles { get; set; }
}

Control:

/// <summary>
/// 异步分页测试
/// </summary>
/// <param name="id">pageIndex</param>
/// <param name="key">关键字</param>
/// <returns></returns>
public ActionResult AjaxPaging(int? id = , string key = null)
{
int totalCount = ;
int pageIndex = id ?? ;
int pageSize = ;
List<Article> infoList = new SoleFuDAL.MyTest().GetArticleList(key, pageSize, (pageIndex - ) * , out totalCount);
PagedList<Article> InfoPager = infoList.AsQueryable().OrderByDescending(o => o.ID).ToPagedList(pageIndex, pageSize);
InfoPager.TotalItemCount = totalCount;
InfoPager.CurrentPageIndex = (int)(id ?? ); Models.MyTest.AjaxPager model = new Models.MyTest.AjaxPager();
model.Articles = InfoPager;
if (Request.IsAjaxRequest())
{
return PartialView("_ArticleList", model);
}
return View(model);
}

View:

@model soulefu_manage.Models.MyTest.AjaxPager
@using Webdiyer.WebControls.Mvc;<!DOCTYPE html><html>
<head>
<meta name="viewport" content="width=device-width" />
<title>MVCPager-AjaxPaging</title>
<link href="~/Content/pagerstyles.css" rel="stylesheet" />
<link href="~/Content/bootstrap.css" rel="stylesheet" />
</head>
<body>
<div style="padding: 15px;">
@using (Html.BeginForm("AjaxPaging", "MyTest", new RouteValueDictionary { { "id", "" } }, FormMethod.Get))
{
@Html.Label("关键字：") <input name="key" value="@Request.QueryString["key"]" /><input type="submit" value="查询" />
} @*分页Table*@
@{ Html.RenderPartial("_ArticleTable"); } <div class="text-center">
@Ajax.Pager(Model.Articles, new PagerOptions
{
PageIndexParameterName = "id",
FirstPageText = "首页",
PrevPageText = "上一页",
NextPageText = "下一页",
LastPageText = "末页",
NumericPagerItemCount = ,
ContainerTagName = "ul",
CssClass = "pagination",
CurrentPagerItemTemplate = "<li class=\"active\"><a href=\"#\">{0}</a></li>",
DisabledPagerItemTemplate = "<li class=\"disabled\"><a>{0}</a></li>",
PagerItemTemplate = "<li>{0}</li>"
}).AjaxOptions(a => a.SetUpdateTargetId("articles"))
</div>
</div>
</body>
</html>

@model soulefu_manage.Models.MyTest.AjaxPager<table class="table table-bordered table-striped">
<tr>
<th class="nowrap">序号</th>
<th>
标题
</th>
<th>
内容
</th>
</tr>
@foreach (var item in Model.Articles)
{
<tr>
<td>@Html.DisplayFor(model => item.ID)</td>
<td>
@Html.DisplayFor(modelItem => item.Title)
</td>
<td>
@Html.DisplayFor(modelItem => item.Content)
</td>
</tr>
}
</table>

二.MvcPager同步

ViewModel（此处可不增加，直接和异步的共用同一个）:

public class MVCPager
{
//信息列表
public PagedList<Article> Articles { get; set; }
}

Control:

/// <summary>
/// 同步分页测试
/// </summary>
/// <param name="id">pageIndex</param>
/// <param name="key">关键字</param>
/// <returns></returns>
public ActionResult MVCPager(int? id = , string key = null)
{
int totalCount = ;
int pageIndex = id ?? ;
int pageSize = ;
List<Article> infoList = new SoleFuDAL.MyTest().GetArticleList(key, pageSize, (pageIndex - ) * , out totalCount);
PagedList<Article> InfoPager = infoList.AsQueryable().OrderByDescending(o => o.ID).ToPagedList(pageIndex, pageSize);
InfoPager.TotalItemCount = totalCount;
InfoPager.CurrentPageIndex = (int)(id ?? ); //数据组装到viewModel
Models.MyTest.MVCPager model = new Models.MyTest.MVCPager();
model.Articles = InfoPager;
return View(model);
}

View:

@model soulefu_manage.Models.MyTest.MVCPager
@using Webdiyer.WebControls.Mvc;<!DOCTYPE html><html>
<head>
<meta name="viewport" content="width=device-width" />
<title>MVCPager</title>
<link href="~/Content/pagerstyles.css" rel="stylesheet" />
<link href="~/Content/bootstrap.css" rel="stylesheet" />
</head>
<body>
<div style="padding:15px;">
@using (Html.BeginForm("MVCPager", "MyTest", new RouteValueDictionary { { "id", "" } }, FormMethod.Get))
{
@Html.Label("关键字：")<input name="key" value="@Request.QueryString["key"]" /><input type="submit" value="查询" />
} <table class="table table-bordered table-striped">
<tr>
<th>编号</th>
<th>标题</th>
<th>内容</th>
</tr>
@foreach (var info in Model.Articles)
{
<tr>
<td>@Html.DisplayFor(model => info.ID)</td>
<td>@Html.DisplayFor(model => info.Title)</td>
<td>@Html.DisplayFor(model => info.Content)</td>
</tr>
}
</table> <div class="text-center">
<nav>
@Html.Pager(Model.Articles, new PagerOptions
{
PageIndexParameterName = "id",
FirstPageText = "首页",
PrevPageText = "上一页",
NextPageText = "下一页",
LastPageText = "末页",
ContainerTagName = "ul",
CssClass = "pagination",
CurrentPagerItemTemplate = "<li class=\"active\"><a href=\"#\">{0}</a></li>",
DisabledPagerItemTemplate = "<li class=\"disabled\"><a>{0}</a></li>",
PagerItemTemplate = "<li>{0}</li>",
Id = "bootstrappager"
})
</nav>
</div>
</div>
</body>
</html>

获取测试数据方法（共用）：

public class MyTest
{
/// <summary>
/// 获取测试数据
/// </summary>
/// <param name="key"></param>
/// <param name="PageSize"></param>
/// <param name="CurrentCount"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public List<Article> GetArticleList(string key, int PageSize, int CurrentCount, out int TotalCount)
{
string tabName = string.Format("Article");
string strWhere = " 1=1";
if (!string.IsNullOrEmpty(key))
{
//SQL关键字过滤包含关键字则不拼接SQL
if (!SqlInjection.GetString(key))
{
strWhere += string.Format(" AND (Title LIKE '%{0}%' OR Content LIKE '%{0}%')", key);
}
}
string Order = string.Format("ID ASC");
DataSet ds = SqlHelper.GetList(SqlHelper.connStr, Order, PageSize, CurrentCount, tabName, strWhere, out TotalCount);
List<Article> list = new List<Article>();
if (ds != null && ds.Tables.Count > )
{
foreach (DataRow dr in ds.Tables[].Rows)
{
Article model = new Article();
model.ID = Convert.ToInt32(dr["ID"]);
model.Title = dr["Title"].ToString();
model.Content = dr["Content"].ToString();
list.Add(model);
}
}
return list;
}
}