EntityFramework41实现动态多条件查询分页和排序.docVIP

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 /// summary /// 根据条件分页获得记录 /// /summary /// param name=where条件/param /// param name=orderBy排序/param /// param name=ascending是否升序/param /// param name=pageIndex当前页码/param /// param name=pageSize每页大小/param /// param name=totalRecord总记录数/param /// returns记录列表/returns public virtual ListT GetMany(ExpressionFuncT, bool where, string orderBy, bool ascending, int pageIndex, int pageSize, out int totalRecord) { ????totalRecord = 0; ????where = where.And(u = u.Flag != (int)Flags.Delete); ????var list = dbset.Where(where); ?? ????totalRecord = list.Count(); ????if (totalRecord = 0) return new ListT(); ?? ????list = list.OrderBy(orderBy, ascending).Skip((pageIndex - 1) * pageSize).Take(pageSize); ?? ????return list.ToList(); } ? 动态排序扩展: + View Code? public static IQueryableT OrderByT(this IQueryableT source, string propertyName, bool ascending) where T : class { ????Type type = typeof(T); ?? ????PropertyInfo property = type.GetProperty(propertyName); ????if (property == null) ????????throw new ArgumentException(propertyName, Not Exist); ?? ????ParameterExpression param = Expression.Parameter(type, p); ????Expression propertyAccessExpression = Expression.MakeMemberAccess(param, property); ????LambdaExpression orderByExpression = Expression.Lambda(propertyAccessExpression, param); ?? ????string methodName = ascending ? OrderBy : OrderByDescending; ?? ????MethodCallExpression resultExp = Expression.Call(typeof(Queryable), methodName, new Type[] { type, property.PropertyType }, source.Expression, Expression.Quote(orderByExpression)); ?? ????return source.Provider.CreateQueryT(resultExp); } ? 如果要通过Expression获取字段，可以使用以下代码: + View Code? /// summary /// 获取对应的字段名 /// /summary /// typeparam name=TSource/typeparam /// param name=keySelector/param /// returns/returns public static string GetMemberNameTSource, TKey(ExpressionFuncTSource, TKey keySelector) { ????string fieldName = null; ????va