最近剛剛接觸MVC不久，因項目中要用到分頁，網(wǎng)上找了下資料，最后采用了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 = "信息內(nèi)容")]
public string Content { get; set; }
}
public class AjaxPager
{
public PagedListArticle> Articles { get; set; }
}
Control:
/// summary>
/// 異步分頁測試
/// /summary>
/// param name="id">pageIndex/param>
/// param name="key">關(guān)鍵字/param>
/// returns>/returns>
public ActionResult AjaxPaging(int? id = 1, string key = null)
{
int totalCount = 0;
int pageIndex = id ?? 1;
int pageSize = 2;
ListArticle> infoList = new SoleFuDAL.MyTest().GetArticleList(key, pageSize, (pageIndex - 1) * 2, out totalCount);
PagedListArticle> 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:
@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("關(guān)鍵字：") 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>
@model soulefu_manage.Models.MyTest.AjaxPager
table class="table table-bordered table-striped">
tr>
th class="nowrap">序號/th>
th>
標題
/th>
th>
內(nèi)容
/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 PagedListArticle> Articles { get; set; }
}
Control:
/// summary>
/// 同步分頁測試
/// /summary>
/// param name="id">pageIndex/param>
/// param name="key">關(guān)鍵字/param>
/// returns>/returns>
public ActionResult MVCPager(int? id = 1, string key = null)
{
int totalCount = 0;
int pageIndex = id ?? 1;
int pageSize = 2;
ListArticle> infoList = new SoleFuDAL.MyTest().GetArticleList(key, pageSize, (pageIndex - 1) * 2, out totalCount);
PagedListArticle> InfoPager = infoList.AsQueryable().OrderByDescending(o => o.ID).ToPagedList(pageIndex, pageSize);
InfoPager.TotalItemCount = totalCount;
InfoPager.CurrentPageIndex = (int)(id ?? 1);
//數(shù)據(jù)組裝到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("關(guān)鍵字：")input name="key" value="@Request.QueryString["key"]" />input type="submit" value="查詢" />
}
table class="table table-bordered table-striped">
tr>
th>編號/th>
th>標題/th>
th>內(nèi)容/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>
獲取測試數(shù)據(jù)方法（共用）：
public class MyTest
{
/// summary>
/// 獲取測試數(shù)據(jù)
/// /summary>
/// param name="key">/param>
/// param name="PageSize">/param>
/// param name="CurrentCount">/param>
/// param name="TotalCount">/param>
/// returns>/returns>
public ListArticle> GetArticleList(string key, int PageSize, int CurrentCount, out int TotalCount)
{
string tabName = string.Format("Article");
string strWhere = " 1=1";
if (!string.IsNullOrEmpty(key))
{
//SQL關(guān)鍵字過濾 包含關(guān)鍵字則不拼接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);
ListArticle> list = new ListArticle>();
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）
以上就是本文的全部內(nèi)容，希望對大家的學(xué)習(xí)有所幫助，也希望大家多多支持腳本之家。
您可能感興趣的文章:- Java簡單實現(xiàn)SpringMVC+MyBatis分頁插件
- ASP.NET MVC 5使用X.PagedList.Mvc進行分頁教程(PagedList.Mvc)
- MVC+jQuery.Ajax異步實現(xiàn)增刪改查和分頁
- SpringMvc+Mybatis+Pagehelper分頁詳解
- 超好用輕量級MVC分頁控件JPager.Net
- springmvc 分頁查詢的簡單實現(xiàn)示例代碼
- 基于SpringMVC+Bootstrap+DataTables實現(xiàn)表格服務(wù)端分頁、模糊查詢
- ASP.NET MVC4 HtmlHelper擴展類，實現(xiàn)分頁功能
- ASP.NET MVC分頁和排序功能實現(xiàn)
- MVC生成頁碼選擇器返回HTML代碼詳解
