/// <summary> /// 分页获取数据 /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedListResult <PushTextListOutput> > GetPushTextPagedList(PushTextSearchInput input) { var tmplist = _pushTextRepository.Table .Where(c => c.IsWriteDb == input.IsWriteDb) //只查询未审核的数据 .WhereIf(!string.IsNullOrEmpty(input.Remark), c => c.Remark.Contains(input.Remark)) .WhereIf(input.DataTypeId != null, c => c.TextTypeId == input.DataTypeId.Value) .AsNoTracking(); try { var list = await tmplist .Select(c => new PushTextListOutput() { Id = c.Id, Text = c.Text, PushDateTime = c.PushDateTime.Value.ToString("yyyy-MM-dd HH:mm"), TextType = c.TextType, Remark = c.Remark, IsWriteDb = c.IsWriteDb }) .PageBy(input.PageIndex, input.PageSize) .ToListAsync(); //总数 int count = list.Count(); return(new PagedListResult <PushTextListOutput>() { Data = list, Count = count, Code = 0 }); } catch (Exception e) { throw; } }
/// <summary> /// 获取推送信息列表 /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <IActionResult> GetPagedPushTexts(PushTextSearchInput input) { return(Json(await _chromeService.GetPushTextPagedList(input))); }