public IQueryable <TEntity> GetPaged(int pageIndex, int pageSize, Expression <Func <TEntity, object> > sortBy, bool isDesc = false) { return(_dbSet.GetPageList(p => true, new PageModel() { PageIndex = pageIndex, PageSize = pageSize }, sortBy, isDesc ? OrderByType.Desc : OrderByType.Asc).AsQueryable()); }
/// <summary> /// Query Pagination data by condition /// </summary> /// <param name="whereExpression"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public List <T> GetListByPage(Expression <Func <T, bool> > whereExpression, int pageIndex, int pageSize) { return(currentDb.GetPageList(whereExpression, new PageModel() { PageIndex = pageIndex, PageSize = pageSize })); }
public BizListResult <T> GetPageList(int start, int pageSize, Expression <Func <T, object> > orderByExpression = null, int ordertype = 0, Expression <Func <T, bool> > whereExpression = null) { OrderByType orderByType = OrderByType.Asc; if (ordertype == 1) { orderByType = OrderByType.Desc; } if (whereExpression == null) { whereExpression = it => 1 == 1; } double page = start / pageSize; int pageIndex = Math.Ceiling(page).ObjToInt() + 1;//Sql Sugar 页从1开始! PageModel p = new PageModel() { PageIndex = pageIndex, PageSize = pageSize }; List <T> data = sdb.GetPageList(whereExpression, p, orderByExpression, orderByType); var t = new BizListResult <T> { Code = 0, total = p.PageCount, Rows = data, Msg = "成功" }; return(t); }
public TableModel<Role> getPageList(int pageIndex, int pageSize) { PageModel page = new PageModel { PageSize = pageSize, PageIndex = pageIndex }; Expression<Func<Role, bool>> ex = (it => 1 == 1); List<Role> roles = roleClient.GetPageList(ex, page); TableModel<Role> r = new TableModel<Role>(); r.Code = 0; r.Count = page.PageCount; r.Data = roles; r.Msg = "成功"; return r; }
public TableModel <Menu> getPageList(int pageIndex, int pageSize) { PageModel page = new PageModel { PageSize = pageSize, PageIndex = pageIndex }; Expression <Func <Menu, bool> > ex = (it => 1 == 1); List <Menu> menus = Client.GetPageList(ex, page); TableModel <Menu> r = new TableModel <Menu>(); r.Code = 0; r.Count = page.PageCount; r.Data = menus; r.Msg = "成功"; return(r); }
/// <summary> /// /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public TableModel <Organization> getPageList(int pageIndex, int pageSize) { PageModel page = new PageModel { PageSize = pageSize, PageIndex = pageIndex }; Expression <Func <Organization, bool> > ex = (it => 1 == 1); List <Organization> Organizations = Client.GetPageList(ex, page); TableModel <Organization> r = new TableModel <Organization>(); r.Code = 0; r.Count = page.PageCount; r.Data = Organizations; r.Msg = "成功"; return(r); }
/// <summary> /// 获取用户分页 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public TableModel <User> getPageList(int pageIndex, int pageSize) { PageModel page = new PageModel { PageSize = pageSize, PageIndex = pageIndex }; Expression <Func <User, bool> > ex = (it => 1 == 1); List <User> users = userClent.GetPageList(ex, page); TableModel <User> u = new TableModel <User>(); u.Code = 0; u.Count = page.PageCount; u.Data = users; u.Msg = "成功"; return(u); }
TableModel <Star> IStar.GetPageList(int pageIndex, int pageSize) { PageModel p = new PageModel() { PageIndex = pageIndex, PageSize = pageSize }; Expression <Func <Star, bool> > ex = (it => 1 == 1); List <Star> data = sdb.GetPageList(ex, p); TableModel <Star> t = new TableModel <Star>(); t.Code = 0; t.Count = p.PageCount; t.Data = data; t.Msg = "成功"; return(t); }
public TableModel <Student> GetPageList(int pageIndex, int pageSize) { PageModel page = new PageModel() { PageIndex = pageIndex, PageSize = pageSize }; Expression <Func <Student, bool> > ex = (it => 1 == 1); List <Student> data = sdb.GetPageList(ex, page); TableModel <Student> t = new TableModel <Student>(); t.Code = 0; t.Count = page.PageCount; t.Data = data; t.Msg = "成功"; return(t); }
public TableModel <T> GetPageList(int pageIndex, int pageSize) { PageModel p = new PageModel() { PageIndex = pageIndex, PageSize = pageSize }; Expression <Func <T, bool> > ex = (it => 1 == 1); List <T> data = sdb.GetPageList(ex, p); var t = new TableModel <T> { Code = 0, Count = p.PageCount, Data = data, Msg = "成功" }; return(t); }
public new TableModel <pt_info> GetPageList(int pageIndex, int pageSize) { PageModel p = new PageModel() { PageIndex = pageIndex, PageSize = pageSize }; Expression <Func <pt_info, bool> > ex = (it => 1 == 1); List <pt_info> data = pdb.GetPageList(ex, p); TableModel <pt_info> t = new TableModel <pt_info> { Code = 0, Count = p.PageCount, Data = data, Msg = "成功" }; return(t); }
public TableModel <UserInfo> GetPageList(int pageindex, int pageSize) { PageModel pageModel = new PageModel() { PageIndex = pageindex, PageSize = pageSize }; Expression <Func <UserInfo, bool> > ex = (n => true); List <UserInfo> data = sdb.GetPageList(ex, pageModel); TableModel <UserInfo> table = new TableModel <UserInfo> { Code = 200, Count = pageModel.PageCount, Data = data, Msg = "Successful" }; return(table); }