效果界面
控制器代码
public ActionResult Index(int roleID=0,string name="",int pageIndex=1,int pageSize=5)
{
var roles = db.Roles.ToList();
ViewBag.roles = roles;
//总记录数
var pageCounts = db.UserInfos.Count();
var rowCounts = Math.Ceiling(1.00*pageCounts/pageSize);
//根据页码每页的条数名称查询
var userInfos = db.UserInfos.Where(p=>p.Name==""||(p.Name.Contains(name)))
.OrderBy(p=>p.ID) //排序
.Skip((pageIndex - 1) * pageSize) //跳过
.Take(pageSize) //取
.ToList(); //转化集合
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
ViewBag.Name = name;
ViewBag.pageCounts = pageCounts;
ViewBag.rowCounts = rowCounts;
return View(userInfos);
}