/// <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();