IQueryable简单分页的扩展方法
IQueryable简单分页的扩展方法 ,废话不多说,直接上干货!
/// <summary> /// 分页列表 /// </summary> public class Page<T> { public Page() { } public Page(List<T> items, int pageIndex, int pageSize, int totalCount) { PageIndex = pageIndex; PageSize = pageSize; Total = totalCount; PageTotal = (int)Math.Ceiling(totalCount / (double)pageSize); Items = items; } /// <summary> /// 当前页码 /// </summary> public int PageIndex { get; set; } /// <summary> /// 每页记录数 /// </summary> public int PageSize { get; set; } /// <summary> /// 总记录数 /// </summary> public int Total { get; set; } /// <summary> /// 总页数 /// </summary> public int PageTotal { get; set; } /// <summary> /// 分页数据 /// </summary> public List<T> Items { get; set; } }
public static class PagedListExtensions { /// <summary> /// PagedList /// </summary> /// <param name="query"></param> /// <param name="pageIndex">1为起始页</param> /// <param name="pageSize"></param> /// <param name="cancellationToken"></param> public static async Task<Page<T>> ToPagedListAsync<T>( this IQueryable<T> query, int pageIndex, int pageSize, CancellationToken cancellationToken = default) { if (pageIndex < 1) throw new ArgumentOutOfRangeException(nameof(pageIndex)); int realIndex = pageIndex - 1; int count = await query.CountAsync(cancellationToken).ConfigureAwait(false); var items = await query.Skip(realIndex * pageSize) .Take(pageSize) .ToListAsync(cancellationToken) .ConfigureAwait(false); return new Page<T>(items, pageIndex, pageSize, count); } public static Page<T> ToPagedList<T>( this IQueryable<T> query, int pageIndex, int pageSize) { if (pageIndex < 1) throw new ArgumentOutOfRangeException(nameof(pageIndex)); int realIndex = pageIndex - 1; int count = query.Count(); var items = query.Skip(realIndex * pageSize) .Take(pageSize) .ToList(); return new Page<T>(items, pageIndex, pageSize, count); } }
作者:阿笨
【官方QQ一群:跟着阿笨一起玩NET(已满)】:422315558
【官方QQ二群:跟着阿笨一起玩C#(已满)】:574187616
【官方QQ三群:跟着阿笨一起玩ASP.NET(已满)】:967920586
【官方QQ四群:Asp.Net Core跨平台技术开发(可加入)】:829227829
【官方QQ五群:.NET Core跨平台开发技术(可加入)】:647639415
【网易云课堂】:https://study.163.com/provider/2544628/index.htm?share=2&shareId=2544628
【腾讯课堂】:https://abennet.ke.qq.com
【51CTO学院】:https://edu.51cto.com/sd/66c64
【微信公众号】:微信搜索:跟着阿笨一起玩NET