// Admin.NET 项目的版æƒã€å•†æ ‡ã€ä¸“利和其他相关æƒåˆ©å‡å—ç›¸åº”æ³•å¾‹æ³•è§„çš„ä¿æŠ¤ã€‚ä½¿ç”¨æœ¬é¡¹ç›®åº”éµå®ˆç›¸å…³æ³•律法规和许å¯è¯çš„è¦æ±‚。 // // 本项目主è¦éµå¾ª MIT 许å¯è¯å’Œ Apache 许å¯è¯ï¼ˆç‰ˆæœ¬ 2.0)进行分å‘和使用。许å¯è¯ä½äºŽæºä»£ç æ ‘æ ¹ç›®å½•ä¸çš„ LICENSE-MIT å’Œ LICENSE-APACHE 文件。 // // ä¸å¾—利用本项目从事å±å®³å›½å®¶å®‰å…¨ã€æ‰°ä¹±ç¤¾ä¼šç§©åºã€ä¾µçŠ¯ä»–äººåˆæ³•æƒç›Šç‰æ³•å¾‹æ³•è§„ç¦æ¢çš„æ´»åЍï¼ä»»ä½•基于本项目二次开å‘è€Œäº§ç”Ÿçš„ä¸€åˆ‡æ³•å¾‹çº çº·å’Œè´£ä»»ï¼Œæˆ‘ä»¬ä¸æ‰¿æ‹…ä»»ä½•è´£ä»»ï¼ namespace Admin.NET.Core; /// <summary> /// åˆ†é¡µæ³›åž‹é›†åˆ /// </summary> /// <typeparam name="TEntity"></typeparam> public class SqlSugarPagedList<TEntity> { /// <summary> /// 页ç /// </summary> public int Page { get; set; } /// <summary> /// é¡µå®¹é‡ /// </summary> public int PageSize { get; set; } /// <summary> /// æ€»æ¡æ•° /// </summary> public int Total { get; set; } /// <summary> /// 总页数 /// </summary> public int TotalPages { get; set; } /// <summary> /// 当å‰é¡µé›†åˆ /// </summary> public IEnumerable<TEntity> Items { get; set; } /// <summary> /// æ˜¯å¦æœ‰ä¸Šä¸€é¡µ /// </summary> public bool HasPrevPage { get; set; } /// <summary> /// æ˜¯å¦æœ‰ä¸‹ä¸€é¡µ /// </summary> public bool HasNextPage { get; set; } } /// <summary> /// 分页拓展类 /// </summary> public static class SqlSugarPagedExtensions { /// <summary> /// 分页拓展 /// </summary> /// <param name="query"><see cref="ISugarQueryable{TEntity}"/>对象</param> /// <param name="pageIndex">当å‰é¡µç ,从1开始</param> /// <param name="pageSize">页ç 容é‡</param> /// <param name="expression">查询结果 Select 表达å¼</param> /// <returns></returns> public static SqlSugarPagedList<TResult> ToPagedList<TEntity, TResult>(this ISugarQueryable<TEntity> query, int pageIndex, int pageSize, Expression<Func<TEntity, TResult>> expression) { var total = 0; var items = query.ToPageList(pageIndex, pageSize, ref total, expression); return CreateSqlSugarPagedList(items, total, pageIndex, pageSize); } /// <summary> /// 分页拓展 /// </summary> /// <param name="query"><see cref="ISugarQueryable{TEntity}"/>对象</param> /// <param name="pageIndex">当å‰é¡µç ,从1开始</param> /// <param name="pageSize">页ç 容é‡</param> /// <returns></returns> public static SqlSugarPagedList<TEntity> ToPagedList<TEntity>(this ISugarQueryable<TEntity> query, int pageIndex, int pageSize) { var total = 0; var items = query.ToPageList(pageIndex, pageSize, ref total); return CreateSqlSugarPagedList(items, total, pageIndex, pageSize); } /// <summary> /// 分页拓展 /// </summary> /// <param name="query"><see cref="ISugarQueryable{TEntity}"/>对象</param> /// <param name="pageIndex">当å‰é¡µç ,从1开始</param> /// <param name="pageSize">页ç 容é‡</param> /// <param name="expression">查询结果 Select 表达å¼</param> /// <returns></returns> public static async Task<SqlSugarPagedList<TResult>> ToPagedListAsync<TEntity, TResult>(this ISugarQueryable<TEntity> query, int pageIndex, int pageSize, Expression<Func<TEntity, TResult>> expression) { RefAsync<int> total = 0; var items = await query.ToPageListAsync(pageIndex, pageSize, total, expression); return CreateSqlSugarPagedList(items, total, pageIndex, pageSize); } /// <summary> /// 分页拓展 /// </summary> /// <param name="query"><see cref="ISugarQueryable{TEntity}"/>对象</param> /// <param name="pageIndex">当å‰é¡µç ,从1开始</param> /// <param name="pageSize">页ç 容é‡</param> /// <returns></returns> public static async Task<SqlSugarPagedList<TEntity>> ToPagedListAsync<TEntity>(this ISugarQueryable<TEntity> query, int pageIndex, int pageSize) { RefAsync<int> total = 0; var items = await query.ToPageListAsync(pageIndex, pageSize, total); return CreateSqlSugarPagedList(items, total, pageIndex, pageSize); } /// <summary> /// 分页拓展 /// </summary> /// <param name="list">集åˆå¯¹è±¡</param> /// <param name="pageIndex">当å‰é¡µç ,从1开始</param> /// <param name="pageSize">页ç 容é‡</param> /// <returns></returns> public static SqlSugarPagedList<TEntity> ToPagedList<TEntity>(this IEnumerable<TEntity> list, int pageIndex, int pageSize) { var total = list.Count(); var items = list.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); return CreateSqlSugarPagedList(items, total, pageIndex, pageSize); } /// <summary> /// 创建 <see cref="SqlSugarPagedList{TEntity}"/> 对象 /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="items">分页内容的对象集åˆ</param> /// <param name="total">æ€»æ¡æ•°</param> /// <param name="pageIndex">当å‰é¡µç ,从1开始</param> /// <param name="pageSize">页ç 容é‡</param> /// <returns></returns> private static SqlSugarPagedList<TEntity> CreateSqlSugarPagedList<TEntity>(IEnumerable<TEntity> items, int total, int pageIndex, int pageSize) { var totalPages = pageSize > 0 ? (int)Math.Ceiling(total / (double)pageSize) : 0; return new SqlSugarPagedList<TEntity> { Page = pageIndex, PageSize = pageSize, Items = items, Total = total, TotalPages = totalPages, HasNextPage = pageIndex < totalPages, HasPrevPage = pageIndex - 1 > 0 }; } }