예제 #1
0
        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));
        }
예제 #2
0
        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));
        }