public async Task <CityAreaChartDto> GetCityDDChartDataAsync()
{
CityAreaChartDto result = new CityAreaChartDto();
result.list = new List <AreaChartDto>();
AreaChartDto actual = new AreaChartDto();
actual.GroupName = "落实面积";
actual.AreaName = "广元市";
actual.Area = await _growerRepository.GetAll().SumAsync(v => v.ActualArea ?? 0);
AreaChartDto expected = new AreaChartDto();
expected.GroupName = "约定面积";
expected.AreaName = "广元市";
expected.Area = await _growerRepository.GetAll().SumAsync(v => v.PlantingArea ?? 0);
result.list.Add(expected);
result.list.Add(actual);
result.Expected = expected.Area;
result.Actual = actual.Area;
return(result);
}
public async Task <DistrictAreaChartDto> GetDistrictDDChartDataAsync()
{
//var actual = await (_growerRepository.GetAll().GroupBy(v => v.AreaCode)
// .Select(v => new AreaChartDto()
// {
// GroupName = "落实面积",
// Area = v.Sum(a => a.ActualArea ?? 0),
// AreaName = v.Key.ToString()
// })).AsNoTracking().ToListAsync();
//var expected = await (_growerRepository.GetAll().GroupBy(v => v.AreaCode)
// .Select(v => new AreaChartDto()
// {
// GroupName = "约定面积",
// Area = v.Sum(a => a.PlantingArea??0),
// AreaName = v.Key.ToString()
// })).AsNoTracking().ToListAsync();
//List<AreaChartDto> list = new List<AreaChartDto>();
//list.AddRange(expected);
//list.AddRange(actual);
//return list;
DistrictAreaChartDto result = new DistrictAreaChartDto();
result.list = new List <AreaChartDto>();
//昭化
AreaChartDto zhExpected = new AreaChartDto();
zhExpected.GroupName = "约定面积";
zhExpected.AreaName = "昭化区";
zhExpected.Area = await _growerRepository.GetAll().Where(v => v.AreaCode == GYEnums.AreaCodeEnum.昭化区).SumAsync(v => v.PlantingArea ?? 0);
AreaChartDto zhActual = new AreaChartDto();
zhActual.GroupName = "落实面积";
zhActual.AreaName = "昭化区";
zhActual.Area = await _growerRepository.GetAll().Where(v => v.AreaCode == GYEnums.AreaCodeEnum.昭化区).SumAsync(v => v.ActualArea ?? 0);
//剑阁
AreaChartDto jgExpected = new AreaChartDto();
jgExpected.GroupName = "约定面积";
jgExpected.AreaName = "剑阁县";
jgExpected.Area = await _growerRepository.GetAll().Where(v => v.AreaCode == GYEnums.AreaCodeEnum.剑阁县).SumAsync(v => v.PlantingArea ?? 0);
AreaChartDto jgActual = new AreaChartDto();
jgActual.GroupName = "落实面积";
jgActual.AreaName = "剑阁县";
jgActual.Area = await _growerRepository.GetAll().Where(v => v.AreaCode == GYEnums.AreaCodeEnum.剑阁县).SumAsync(v => v.ActualArea ?? 0);
//旺苍
AreaChartDto wcExpected = new AreaChartDto();
wcExpected.GroupName = "约定面积";
wcExpected.AreaName = "旺苍县";
wcExpected.Area = await _growerRepository.GetAll().Where(v => v.AreaCode == GYEnums.AreaCodeEnum.旺苍县).SumAsync(v => v.PlantingArea ?? 0);
AreaChartDto wcActual = new AreaChartDto();
wcActual.GroupName = "落实面积";
wcActual.AreaName = "旺苍县";
wcActual.Area = await _growerRepository.GetAll().Where(v => v.AreaCode == GYEnums.AreaCodeEnum.旺苍县).SumAsync(v => v.ActualArea ?? 0);
result.list.Add(zhExpected);
result.list.Add(zhActual);
result.list.Add(jgExpected);
result.list.Add(jgActual);
result.list.Add(wcExpected);
result.list.Add(wcActual);
result.ZhExpected = zhExpected.Area;
result.ZhActual = zhActual.Area;
result.JgExpected = jgExpected.Area;
result.JgActual = jgActual.Area;
result.WcExpected = wcExpected.Area;
result.WcActual = wcActual.Area;
return(result);
}
