asp.net MVC使用EF框架进行分页
-
数据库以Roles表为例
-
控制器代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Com.page.Models;
namespace Com.page.Controllers
{
public class UserinfoController : Controller
{
RbacDBEntities db = new RbacDBEntities();
// GET: Userinfo
public ActionResult Index(int pageIndex=1,int pageSize=10,string Name="")
{
var counts = db.UserInfos.Where(p => p.Name.Contains(Name)).Count();
var totalpage = Math.Ceiling(counts * 1.00 / pageSize);
var row = db.UserInfos.Where(p => p.Name.Contains(Name))
.OrderBy(p => p.ID)
.Skip(pageSize * (pageIndex - 1))
.Take(pageSize).ToList();
ViewBag.pageIndex = pageIndex;
ViewBag.totalpage = totalpage;
ViewBag.pageSize = pageSize;
ViewBag.Name = Name;
return View(row);
}
}
} -
视图代码