MVC分页之MvcPager使用详解

时间:2021-11-18 22:54:55

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

一.MvcPager异步
 ViewModel: 

?
1
2
3
4
5
6
7
8
9
10
11
public class Article
{
[Display(Name = "信息编号")]
public int ID { get; set; }
 
[Display(Name = "信息标题")]
public string Title { get; set; }
 
[Display(Name = "信息内容")]
public string Content { get; set; }
}
?
1
2
3
4
public class AjaxPager
{
public PagedList<Article> Articles { get; set; }
}

Control:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
/// <summary>
 /// 异步分页测试
 /// </summary>
 /// <param name="id">pageIndex</param>
 /// <param name="key">关键字</param>
 /// <returns></returns>
 public ActionResult AjaxPaging(int? id = 1, string key = null)
 {
  int totalCount = 0;
  int pageIndex = id ?? 1;
  int pageSize = 2;
  List<Article> infoList = new SoleFuDAL.MyTest().GetArticleList(key, pageSize, (pageIndex - 1) * 2, out totalCount);
  PagedList<Article> InfoPager = infoList.AsQueryable().OrderByDescending(o => o.ID).ToPagedList(pageIndex, pageSize);
  InfoPager.TotalItemCount = totalCount;
  InfoPager.CurrentPageIndex = (int)(id ?? 1);
 
  Models.MyTest.AjaxPager model = new Models.MyTest.AjaxPager();
  model.Articles = InfoPager;
  if (Request.IsAjaxRequest())
  {
  return PartialView("_ArticleList", model);
  }
  return View(model);
 }

View: 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
@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 = 5,
  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>
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
@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(此处可不增加,直接和异步的共用同一个): 

?
1
2
3
4
5
public class MVCPager
{
//信息列表
public PagedList<Article> Articles { get; set; }
}

Control: 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
/// <summary>
/// 同步分页测试
/// </summary>
/// <param name="id">pageIndex</param>
/// <param name="key">关键字</param>
/// <returns></returns>
public ActionResult MVCPager(int? id = 1, string key = null)
{
 int totalCount = 0;
 int pageIndex = id ?? 1;
 int pageSize = 2;
 List<Article> infoList = new SoleFuDAL.MyTest().GetArticleList(key, pageSize, (pageIndex - 1) * 2, out totalCount);
 PagedList<Article> InfoPager = infoList.AsQueryable().OrderByDescending(o => o.ID).ToPagedList(pageIndex, pageSize);
 InfoPager.TotalItemCount = totalCount;
 InfoPager.CurrentPageIndex = (int)(id ?? 1);
 
 //数据组装到viewModel
 Models.MyTest.MVCPager model = new Models.MyTest.MVCPager();
 model.Articles = InfoPager;
 return View(model);
}

View: 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
@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>

获取测试数据方法(共用):

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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 > 0)
 {
 foreach (DataRow dr in ds.Tables[0].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;
}
}

效果图:(需要引用CSS)

MVC分页之MvcPager使用详解

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。

原文链接:http://www.cnblogs.com/xiaoxiaocainia/p/5563633.html