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);
}
