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