public IEnumerable <TownMrsTadv> GetMergeMrsStats(DateTime statTime, FrequencyBandType bandType)
{
var end = statTime.AddDays(1);
var stats = _mrsTadvRepository.GetAllList(x => x.StatDate >= statTime && x.StatDate < end);
var townStats =
stats.GetTownFrequencyStats <MrsTadvStat, TownMrsTadvDto, TownMrsTadv>(bandType, _cellRepository,
_eNodebRepository);
var mergeStats = from stat in townStats
group stat by stat.TownId
into g
select new TownMrsTadv
{
TownId = g.Key,
StatDate = statTime,
TadvBelow1 = g.Sum(x => x.TadvBelow1),
Tadv1To2 = g.Sum(x => x.Tadv1To2),
Tadv2To3 = g.Sum(x => x.Tadv2To3),
Tadv3To4 = g.Sum(x => x.Tadv3To4),
Tadv4To6 = g.Sum(x => x.Tadv4To6),
Tadv6To8 = g.Sum(x => x.Tadv6To8),
Tadv8To10 = g.Sum(x => x.Tadv8To10),
Tadv10To12 = g.Sum(x => x.Tadv10To12),
Tadv12To14 = g.Sum(x => x.Tadv12To14),
Tadv14To16 = g.Sum(x => x.Tadv14To16),
Tadv16To18 = g.Sum(x => x.Tadv16To18),
Tadv18To20 = g.Sum(x => x.Tadv18To20),
Tadv20To24 = g.Sum(x => x.Tadv20To24),
Tadv24To28 = g.Sum(x => x.Tadv24To28),
Tadv28To32 = g.Sum(x => x.Tadv28To32),
Tadv32To36 = g.Sum(x => x.Tadv32To36),
Tadv36To42 = g.Sum(x => x.Tadv36To42),
Tadv42To48 = g.Sum(x => x.Tadv42To48),
Tadv48To54 = g.Sum(x => x.Tadv48To54),
Tadv54To60 = g.Sum(x => x.Tadv54To60),
Tadv60To80 = g.Sum(x => x.Tadv60To80),
Tadv80To112 = g.Sum(x => x.Tadv80To112),
Tadv112To192 = g.Sum(x => x.Tadv112To192),
TadvAbove192 = g.Sum(x => x.TadvAbove192),
FrequencyBandType = bandType,
Id = 0
};
return(mergeStats);
}
public IEnumerable <MrsTadvStat> QueryDateSpanMrsTadvStats(DateTime begin, DateTime end)
{
return(_tadvRepository.GetAllList(x => x.StatDate >= begin && x.StatDate < end));
}
