using FreeSql;
using DeYi.NuGet.Other;
using DeYi.NuGet.PagedData;
namespace OCR.WebAPI.System.FreeSql
{
    /// 

    /// FreeSql分页扩展类
    /// 
    public static class FreeSqlPageList
    {
        /// 

        /// ToListAsync分页封装
        /// 
        /// 
        /// 
        /// 
        public static async Task> ToPageListAsync(this ISelect query, PagingAndSortingParam PagingAndSortingParam)
        {
            if (PagingAndSortingParam != null && !PagingAndSortingParam.SortString.IsNullOrEmpty())
                query.OrderBy(PagingAndSortingParam.SortString);
            PagedData PageData = PagingAndSortingParam.ToPagedData();
            //PageData.DataList = await query.Page(PagingAndSortingParam.Page, PagingAndSortingParam.PageSize).Count(out var total).ToListAsync();
            PageData.DataList = await query.Page(PagingAndSortingParam.Page, PagingAndSortingParam.PageSize).ToListAsync();//上句Count输出不支持异步
            PageData.TotalCount = (int)await query.CountAsync();
            return PageData;
        }
    }
    /// 

    /// FreeSql分页扩展类
    /// 
    public class FreeSqlPageList
    {
        /// 

        /// ToDtoListAsync分页封装
        /// 
        /// 
        /// 
        /// 
        /// 
        public static async Task> ToDtoPageListAsync(ISelect query, PagingAndSortingParam PagingAndSortingParam)
        {
            if (PagingAndSortingParam != null && !PagingAndSortingParam.SortString.IsNullOrEmpty())
                query.OrderBy(PagingAndSortingParam.SortString);
            PagedData PageData = PagingAndSortingParam.ToPagedData();
            //PageData.DataList = await query.Page(PagingAndSortingParam.Page, PagingAndSortingParam.PageSize).Count(out var total).ToListAsync();
            PageData.DataList = await query.Page(PagingAndSortingParam.Page, PagingAndSortingParam.PageSize).ToListAsync();//上句Count输出不支持异步
            PageData.TotalCount = (int)await query.CountAsync();
            return PageData;
        }
    }
}