public ActionResult Index() { var model = new GetT_ItemInput { FilterText = Request.QueryString["filterText"] }; return(View(model)); }
/// <summary> /// 根据查询条件获取培训项目设置分页列表 /// </summary> public async Task <PagedResultDto <T_ItemListDto> > GetPagedT_ItemsAsync(GetT_ItemInput input) { var query = _t_ItemRepository.GetAll().WhereIf(!string.IsNullOrWhiteSpace(input.FilterText), o => o.ProjectName.Contains(input.FilterText));; //TODO:根据传入的参数添加过滤条件 var query1 = from i in _t_ItemRepository.GetAll().WhereIf(!string.IsNullOrWhiteSpace(input.FilterText), o => o.ProjectName.Contains(input.FilterText)) join r in _t_RequireRepository.GetAll() on i.Id equals r.Fk_Item_Require_Id into ji from j2 in ji.DefaultIfEmpty() group j2 by new { i.CreateTime, i.Id, i.ProjectName } into grouped select new T_ItemListDto { ProjectName = grouped.Key.ProjectName, CreateTime = grouped.Key.CreateTime, Id = grouped.Key.Id, Count = grouped.Count(_ => _.UserName != null) }; dynamic rst = query1.ToList(); var t_ItemCount = await query1.CountAsync();//await query.CountAsync(); //var t_Items = await query // .AsNoTracking() //.OrderBy(input.Sorting) //.PageBy(input) //.ToListAsync(); var t_Items = await query1 .AsNoTracking() .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var t_ItemListDtos = t_Items;// t_Items.MapTo<List<T_ItemListDto>>(); return(new PagedResultDto <T_ItemListDto>( t_ItemCount, t_ItemListDtos )); //return new JtableResult<List<T_ItemListDto>>(t_ItemCount, t_ItemListDtos); }