public ListResultDto <PlanWithBudgetOutlayListDto> GetCorrelatedOutlays(PlanWithBudgetOutlayQueryDto request)
{
if (!request.Pid.HasValue)
{
throw new UserFriendlyException("采购计划不能为空");
}
var query = this.planWithBudgetOutlayRepository.GetAll()
.Where(r => r.ProcurementPlanId == request.Pid).OrderByDescending(r => r.CreationTime);
var count = query.Count();
var list = query.AsQueryable().PageBy(request).ToList();
var dtos = list.MapTo <List <PlanWithBudgetOutlayListDto> >();
return(new PagedResultDto <PlanWithBudgetOutlayListDto>(count, dtos));
}
public ListResultDto <PlanWithBudgetOutlayListDto> GetUnCorrelatedOutlays(PlanWithBudgetOutlayQueryDto request)
{
if (!request.Year.HasValue)
{
request.Year = DateTime.Now.Year;
}
var correlatedIds = this.planWithBudgetOutlayRepository.GetAll()
.Where(r => r.ProcurementPlan.Date.Year == request.Year.Value).Select(r => r.BudgetOutlayId);
var query = this.budgetOutlayRepository.GetAll()
.Where(r => correlatedIds.All(m => m != r.Id) && r.BudgetReceiptId.HasValue && r.Type == request.Type)
.WhereIf(!string.IsNullOrEmpty(request.Name), r => r.Name.Contains(request.Name))
.OrderByDescending(r => r.CreationTime);
var count = query.Count();
var list = query.AsQueryable().PageBy(request).ToList();
var dtos = list.MapTo <List <PlanWithBudgetOutlayListDto> >();
return(new PagedResultDto <PlanWithBudgetOutlayListDto>(count, dtos));
}
