Exemplo n.º 1
0
        /// <summary>
        /// 获取Demo分页
        /// </summary>
        /// <param name="PageIndex"></param>
        /// <param name="PageSize"></param>
        /// <returns></returns>
        public async Task <PageResult <Demo> > GetDemoPageListAsync(int PageIndex, int PageSize)
        {
            var    result   = new PageResult <Demo>();
            string sql      = @"SELECT Id, Name, Sex, Age, Remark FROM Demo";
            string sqlCount = @"SELECT count(*) FROM Demo";

            result.list = await _demoRepository.GetListAsync(sql, PageIndex, PageSize);

            result.TotalCount = await _demoRepository.CountAsync(sqlCount);

            result.PageIndex = PageIndex;
            result.PageSize  = PageSize;
            return(result);
        }
 public async Task <IEnumerable <User> > UserList()
 {
     return(await _demoRepository.GetListAsync());
 }