public ActionResult List(int p = 1) { PermissionEntities perEntities = new PermissionEntities(); int pagesize = 10; int count = GetCount(); string pagerInfo = Pager.CreatePageNums(count, pagesize, p); ViewBag.pager = pagerInfo; //第二页数据 //var pagerList = perEntities.User.OrderBy(x => x.ID).Skip((p - 1) * pagesize).Take(10).ToList(); var query = perEntities.User.Join(perEntities.RoleTable, rp => rp.RoleID, r => r.ID, (rp, r) => new ViewModels.RoleUser { ID = rp.ID, RoleName = r.Name, UserName = rp.Name, UserPwd = rp.Pwd, UserSex = rp.Sex, UserDepartment = rp.Department, UserPhone = rp.Phone }).OrderBy(x => x.ID).Skip((p - 1) * pagesize).Take(10).ToList(); return(View(query)); }
public ActionResult List(int p = 1) { PermissionEntities perEntities = new PermissionEntities(); int pagesize = 10; int count = GetCount(); string pagerInfo = Pager.CreatePageNums(count, pagesize, p); ViewBag.pager = pagerInfo; //第二页数据 var pagerList = perEntities.Permission.OrderBy(x => x.ID).Skip((p - 1) * pagesize).Take(10).ToList(); return(View(pagerList)); }