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);
}
