public static Model.Huang.PageList PageListDemo(int pageindex, int pagesize) { CangChuEntities1 entities = new CangChuEntities1(); Model.Huang.PageList list = new Model.Huang.PageList(); var obj = from p in entities.Admin where p.IsDelete == 0 orderby p.Id select new { Id = p.Id, UserName = p.UserName, RealName = p.RealName, RoleId = p.RoleId, DeptId = p.DeptId, Rname = p.Role.RoleName, Dname = p.Dept.DeptName, Email = p.Email, phone = p.phone, CreateTime = p.CreateTime, IsDelete = p.IsDelete, DeleteTime = p.DeleteTime, Remake = p.Remake }; list.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize); int rows = entities.Role.Count(); list.PageCount = rows % pagesize == 0 ? rows / pagesize : rows / pagesize + 1; return(list); }
public static Model.Huang.PageList PageListDemo(int pageindex, int pagesize) { CangChuEntities1 entities = new CangChuEntities1(); Model.Huang.PageList list = new Model.Huang.PageList(); var obj = from p in entities.Role orderby p.RoleId select new { RoleId = p.RoleId, RoleName = p.RoleName, CreateTime = p.CreateTime, IsDelete = p.IsDelete, Remake = p.Remake }; list.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize); int rows = entities.Role.Count(); list.PageCount = rows % pagesize == 0 ? rows / pagesize : rows / pagesize + 1; return(list); }