PagedList分页操作
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
PagedList表格分页操作
Controller部分
添加引用头文件
using PagedList;
using PagedList.Mvc;
//使用PageList将数据分页
public ActionResult page(int?page) {
var t = from teacher in db.Teachers select teacher;
//第几页
int pagenumber = page ?? 1;
//每一页显示的记录数
int pageSize = 15;
//根据教师ID进行排序(先按教师的编号升序,再按教师的名称降序排)
t = t.OrderBy(x =>x.TeacherID).ThenByDescending(y=>y.TeacherName); //通过ToPagedLsit扩展方法进行分页
IPagedList<Teacher>pagedlist = t.ToPagedList(pagenumber,pageSize);
return View(pagedlist);
}
在项目下的所有的web.config中的命名空间内添加<add namespace="PagedList"/>
<add namespace="PagedList.Mvc"/>
Html页面部分
@using PagedList;
@model PagedList.IPagedList<WebApp.Models.Teacher> @{
Layout = "~/Views/Shared/_Layout.cshtml";
<link href="~/Content/PagedList.css"rel="stylesheet"/> <link href="~/Content/bootstrap.css"rel="stylesheet"/> <script src="~/Content/jquery-2.1.1.js"></script>
<script src="~/Content/bootstrap.js"></script>
}
<div class="pageNav">
<span><i class="icofont-arrow-right"></i>首页</span> </div>
<div class="content-body">
<div class="box corner-all hidden">
<!--box header-->
<div class="box-header grd-white color-silver-dark corner-top">
<div class="header-control">
<a data-box="collapse"><i class="icofont-caret-up"></i></a>
</div>
<span>查询</span>
</div><!--/box header-->
<!--box body-->
<div class="box-body corner-bottom">
<div class="control-group">
<div class="controls">
<div class="input-append">
</div>
</div>
</div>
</div>
</div>
<div class="container"data-autosize="true">
<table cellpadding="3"cellspacing="0"border="1"class="inputform table-hover table-striped table-wrapper"align="center">
<thead>
<tr>
<td class="td-label td-label-center color-black"><strong>教师编号</strong></td>
<td class="td-label td-label-center color-black"><strong>教师名称</strong></td>
<td></td>
</tr>
</thead>
@foreach (var item in Model)
{
<tbody>
<tr>
<td class="td-label-center color-orange">@Html.DisplayFor(modelitem
=>item.TeacherID)</td>
<td class="td-label-center color-green">@Html.DisplayFor(modelitem
=>item.TeacherName)</td>
<td class="td-label-center color-red"style="width:100px;">@Html.ActionLink("课程",
"/Operations", new { id = item.TeacherID.Trim() })</td>
</tr>
</tbody>
}
<tfoot>
<tr>
<td align="center"colspan="3">
每页@Model.PageSize条记录,共@Model.PageCount页,当前第@Model.PageNumber页@Html.PagedListPager(Model, Page =>Url.Action("page", new { Page }))
</td>
</tr>
</tfoot>
</table>
</div>
</div>
显示的效果。