示例#1
0
 /// <summary>
 /// 重置分页对象
 /// </summary>
 /// <param name="query">查询对象</param>
 public static void ResetPageQuery <T>(this NGPPageQueryRequest <T> query) where T : INGPRequest
 {
     //充值当前页码
     if (query.PageNumber == 0)
     {
         query.PageNumber = 1;
     }
     //分页大小默认为10
     if (query.PageSize == 0)
     {
         query.PageSize = 10;
     }
 }
示例#2
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <typeparam name="TRequest"></typeparam>
        /// <typeparam name="TReponse"></typeparam>
        /// <param name="source"></param>
        /// <param name="query"></param>
        /// <returns></returns>
        public static NGPPageQueryResponse <TReponse> ParsePageQuery <TRequest, TReponse>(this IQueryable <TReponse> source,
                                                                                          NGPPageQueryRequest <TRequest> query)
            where TRequest : INGPRequest
        {
            var result = new NGPPageQueryResponse <TReponse>();

            if (query == null)
            {
                return(result);
            }

            query.ResetPageQuery();
            //起始页
            var startIndex = (query.PageNumber - 1) * query.PageSize;

            // 执行分页
            var pageSource = source
                             .Skip(startIndex)
                             .Take(query.PageSize);

            // 总条数
            result.TotalCount = source.Select(s => 1).Count();

            // 行数据
            result.Data = pageSource.ToList();

            return(result);
        }
示例#3
0
 /// <summary>
 /// 分页查询
 /// </summary>
 /// <typeparam name="TRequest"></typeparam>
 /// <typeparam name="TReponse"></typeparam>
 /// <param name="source"></param>
 /// <param name="query"></param>
 /// <returns></returns>
 public static (int totalCount, List <TReponse> data) ParsePageQuery <TRequest, TReponse>(this IQueryable <TReponse> source,
                                                                                          NGPPageQueryRequest <TRequest> query)