1.动态排序

public static IQueryable<T> Sort<T>(this IQueryable<T> source, string sort) { string sortStr = ""; string sortDirection = ""; string sortDir = string.Empty; if(!string.IsNullOrEmpty(sort)) { sortStr = sort.Split('-')[0];//排序字段 sortDirection = sort.Split('-')[1];//方向 } if (sortDirection.Trim().ToUpper() == "ASC") { sortDir = "OrderBy"; } else { sortDir = "OrderByDescending"; } ParameterExpression param = Expression.Parameter(typeof(T), sortStr); PropertyInfo pi = typeof(T).GetProperty(sortStr); Type[] types = new Type[2]; types[0] = typeof(T); types[1] = pi.PropertyType; Expression expr = Expression.Call(typeof(Queryable), sortDir, types, source.Expression, Expression.Lambda(Expression.Property(param, sortStr), param)); IQueryable<T> query = source.AsQueryable().Provider.CreateQuery<T>(expr); return query; }

2.分页

2.1扩展基础类

[Serializable] public class PagedList<T> : List<T> { /// <summary> /// /// </summary> /// <param name="source">数据源</param> /// <param name="pageIndex">页码，从0开始</param> /// <param name="pageSize">每页显示数量</param> public PagedList(IQueryable<T> source, int pageIndex, int pageSize) { int total = source.Count(); TotalCount = total; TotalPages = total / PageSize; if (total % pageSize > 0) { TotalPages++; } PageSize = pageSize; this.PageIndex = pageIndex; AddRange(source.Skip(pageIndex * pageSize).Take(pageSize).ToList()); } public PagedList(IEnumerable<T> source, int pageIndex, int pageSize) { int total = source.Count(); TotalCount = total; TotalPages = total / PageSize; if (total % pageSize > 0) { TotalPages++; } PageSize = pageSize; this.PageIndex = pageIndex; AddRange(source); } public PagedList(IList<T> source, int pageIndex, int pageSize) { int total = source.Count; TotalCount = total; TotalPages = total / PageSize; if (total % pageSize > 0) { TotalPages++; } PageSize = pageSize; this.PageIndex = pageIndex; AddRange(source); } /// <summary> /// 页码索引 /// </summary> public int PageIndex { get; private set; } /// <summary> /// 每页显示记录数 /// </summary> public int PageSize { get; private set; } /// <summary> /// 总记录 /// </summary> public int TotalCount { get; private set; } /// <summary> /// 总页数 /// </summary> public int TotalPages { get; private set; } /// <summary> /// 上一页？ /// </summary> public bool HasPrePage { get { return (PageIndex > 0); } } /// <summary> /// 下一页 /// </summary> public bool HasNextPage { get { return (PageIndex + 1 < TotalPages); } } }

2.2扩展方法

public static PagedList<T> ToPagedList<T>(this IQueryable<T> soruce, int pageIndex, int pageSize) { return new PagedList<T>(soruce,pageIndex,pageSize); }