/// <summary> /// 分页查询 /// </summary> /// <param name="pageSize">单页的记录数</param> /// <param name="pageIndex">页码</param> /// <param name="isAsc">是否正序排序</param> /// <param name="orderField">排序字段 为空时默认为 CREATION_DATE </param> /// <param name="sWhere">查询条件;多条件是目前只支持 and;表达式 System.Linq.Dynamic的形式</param> /// <returns>符合查询条件的List结果</returns> public List <SysUser> GetSysUserByPage(int pageSize, int pageIndex, bool isAsc, string orderField, string sWhere) { string orderStr = ""; if (string.IsNullOrEmpty(orderField)) { orderStr = "CREATION_DATE"; } else { orderStr = orderField; } Expression <Func <SysUser, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <SysUser>(sWhere); using (ISysUserBLL SysUserBLL = BLLContainer.Resolve <ISysUserBLL>()) { List <SysUser> models = SysUserBLL.GetModelsByPage(pageSize, pageIndex, isAsc, orderStr, whereLamda); return(models); } }