/// <summary>
/// Creates the asynchronous.
/// </summary>
/// <param name="source">The source.</param>
/// <param name="pageNumber">The page number.</param>
/// <param name="pageSize">Size of the page.</param>
/// <returns></returns>
public static async Task <PagedList <T> > CreateAsync(ISelect <T> source, int pageNumber, int pageSize)
{
var count = await source.CountAsync();
var items = await source.Page(pageNumber, pageSize).ToListAsync();
return(new PagedList <T>(items, count, pageNumber, pageSize));
}
/// <summary>
/// Creates the asynchronous.
/// </summary>
/// <typeparam name="TInput">The type of the input.</typeparam>
/// <param name="source">The source.</param>
/// <param name="pageNumber">The page number.</param>
/// <param name="pageSize">Size of the page.</param>
/// <param name="mapper">The mapper.</param>
/// <returns></returns>
public static async Task <PagedList <T> > CreateAsync <TInput>(ISelect <TInput> source, int pageNumber, int pageSize, IMapper mapper) where TInput : class
{
var count = await source.CountAsync();
var items = await source.Page(pageNumber, pageSize).ToListAsync();
return(new PagedList <T>(mapper.Map <List <T> >(items), count, pageNumber, pageSize));
}
public async Task <long> GetCount(string code, DateTime sTime, DateTime endTime)
{
if (FreeHanlder.SqliteHandler == null)
{
throw new NullReferenceException("未初始化SqliteHandler数据库访问程序;");
}
//List<TightenModel> tds =
ISelect <TightenModel> query = FreeHanlder.SqliteHandler.Select <TightenModel>()
.Where(t => t.EngineCode.Contains(code));
if (sTime != null)
{
query = query.Where(t => t.CreateTime > sTime);
}
if (endTime != null)
{
query = query.Where(t => t.CreateTime < endTime);
}
return(await query.CountAsync());
}
public static Task <long> CountAsync <T>(ISelect <T> select) where T : class => select.CountAsync();
