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