/// <summary>
/// 条件查询
/// </summary>
/// <param name="parmList"></param>
/// <returns></returns>
public List <StudentDTO> GetConditionStu(int page, int pagesize, string sortName, List <Expression <Func <StudentDTO, bool> > > parmList, ref int count)
{
var query = (from c in ObjEntity.Student
join d in ObjEntity.Grade on c.s_GradeID equals d.GradeID
select new StudentDTO()
{
s_id = c.s_id,
s_name = c.s_name,
s_address = c.s_address,
s_sex = c.s_sex,
s_age = c.s_age,
s_createDate = c.s_createDate,
s_loginName = c.s_loginName,
s_passWord = c.s_passWord,
s_phone = c.s_phone,
s_remark = c.s_remark,
s_status = c.s_status,
SexName = c.s_sex == 0 ? "男" : "女",
StatusName = c.s_status == 1 ? "启用" : "禁用",
GradeName = d.GradeName
});
if (parmList != null)
{
foreach (var parm in parmList)
{
query = query.Where(parm);
}
}
//返回总条数
count = query.FutureCount();
query = SortTools.SortingAndPaging <StudentDTO>(query, sortName, page, pagesize);
return(query.ToList());
}
/// <summary>
/// 分页获取数据
/// </summary>
/// <param name="page">页码</param>
/// <param name="pageSize">煤业显示条数</param>
/// <param name="order">排序字段</param>
/// <param name="sort">排序方式 1.正序 2.倒序</param>
/// <returns></returns>
public List <TEntity> GetDataByPage(int page, int pageSize, List <Expression <Func <TEntity, bool> > > parmList, string Sort, ref int count)
{
IQueryable <TEntity> query = dbSet;
if (parmList != null)
{
foreach (var parm in parmList)
{
query = query.Where(parm);
}
}
count = query.FutureCount();
query = SortTools.SortingAndPaging <TEntity>(query, Sort, page, pageSize, true);
List <TEntity> queryList = query.ToList();
return(queryList);
}