1.Controller中的代码
public ActionResult Index()
{
int pageIndex = Request["pageIndex"] == null ? 1 : int.Parse(Request["pageIndex"]);
ViewBag.CurrentPage = pageIndex;
int pageSize = Request["pageSize"] == null ? 5 : int.Parse(Request["pageSize"]);
ViewBag.PageSize = pageSize;
ViewBag.Total = db.Base_Employee.Where(u => u.Name.StartsWith("杨")).Count();
List<Base_Employee> UserList = db.Base_Employee.Where(u=>u.Name.StartsWith("杨")).OrderByDescending(u=>u.ID).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList();
return View(UserList);
}
2.分页帮助类
namespace MVC.Utility
{
public static class HtmlPaginationBar
{
public static HtmlString ShowPageNavigate(this HtmlHelper htmlHelper, int currentPage, int pageSize, int totalCount)
{
var redirectTo = htmlHelper.ViewContext.RequestContext.HttpContext.Request.Url.AbsolutePath;
pageSize = pageSize == 0 ? 3 : pageSize;
var totalPages = Math.Max((totalCount + pageSize - 1) / pageSize, 1);//总页数
var output = new StringBuilder();
if (totalPages > 1)
{
//if (currentPage!=1)
{//处理首页连接
output.AppendFormat("<a class='pageLink' href='{0}?pageIndex=1&pageSize={1}'>首页</a>", redirectTo, pageSize);
}
if (currentPage > 1)
{//处理上一页的连接
output.AppendFormat("<a class='pageLink' href='{0}?pageIndex=1&pageSize={1}&pageSize={2}'>上一页</a>", redirectTo, currentPage - 1, pageSize);
}
else
{
//output.Append("<span class='pageLink'>上一页</span>");
}
output.Append(" ");
int currint = 5;
for (int i = 0; i < 10; i++)
{//一共最多系那是10个页码,前面5个后面5个
if ((currentPage + i - currint) >= 1 && (currentPage + i - currint) <= totalPages)
{
if (currint == i)
{//当前页处理
output.AppendFormat("<a class='cpb' href='{0}?pageIndex={1} & pageSize={2}'>{3}</a>", redirectTo, currentPage, pageSize, currentPage);
}
else
{//一般页处理
output.AppendFormat("<a class='cpb' href='{0}?pageIndex={1} & pageSize={2}'>{3}</a>", redirectTo, currentPage + i - currint, pageSize, currentPage + i - currint);
}
}
output.Append(" ");
}
if (currentPage < totalPages)
{//处理下一页的连接
output.AppendFormat("<a class='pageLink' href='{0}?pageIndex={1} & pageSize={2}'>下一页</a>", redirectTo, currentPage + 1, pageSize);
}
else
{
}
output.Append(" ");
if (currentPage != totalPages)
{
output.AppendFormat("<a class='pageLink' href='{0}?pageIndex={1} & pageSize={2}'>末页</a>", redirectTo, totalPages, pageSize);
}
output.Append(" ");
}
output.AppendFormat("第{0}页 / 共{1}页", currentPage, totalPages);//这个统计加不加都行
return new HtmlString(output.ToString());
}
}
}
3.View页面展示
@using MVC.Utility;
样式:
<style type="text/css">
.paginator {
font: 12px Arial,Helvetica,sans-serif;
padding: 10px 20px 10px 0;
margin: 0px;
}
.paginator a {
border: solid 1px #ccc;
color: #0063dc;
cursor: pointer;
text-decoration: none;
}
.paginator a:visited {
padding: 1px 6px;
border: solid 1px #ddd;
background: #fff;
text-decoration: none;
}
.paginator .cpb {
border: 1px solid #F50;
font-weight: 700;
color: #F50;
background-color: #ffeee5;
}
.paginator a:hover {
border: solid 1px #F50;
color: #f60;
text-decoration: none;
}
.paginator a, .paginator a:visited, .paginator .cpb, .paginator a:hover {
float: left;
height: 16px;
line-height: 16px;
min-width: 10px;
_width: 10px;
margin-right: 5px;
text-align: center;
white-space: nowrap;
font-size: 12px;
font-family: Arialm,SimSun;
padding: 0 3px;
}
</style>
<div class="paginator">
@Html.ShowPageNavigate((int)ViewBag.CurrentPage, (int)ViewBag.PageSize, (int)ViewBag.Total)
<div>