public IEnumerable <TownMrsSinrUl> GetMergeMrsStats(DateTime statTime, FrequencyBandType bandType)
{
var end = statTime.AddDays(1);
var stats = _mrsSinrUlRepository.GetAllList(x => x.StatDate >= statTime && x.StatDate < end);
var townStats = stats.GetTownFrequencyStats <MrsSinrUlStat, TownMrsSinrUlDto, TownMrsSinrUl>(bandType,
_cellRepository, _eNodebRepository);
var mergeStats = from stat in townStats
group stat by stat.TownId
into g
select new TownMrsSinrUl
{
TownId = g.Key,
StatDate = statTime,
SinrUlBelowM9 = g.Sum(x => x.SinrUlBelowM9),
SinrUlM9ToM6 = g.Sum(x => x.SinrUlM9ToM6),
SinrUlM6ToM3 = g.Sum(x => x.SinrUlM6ToM3),
SinrUlM3To0 = g.Sum(x => x.SinrUlM3To0),
SinrUl0To3 = g.Sum(x => x.SinrUl0To3),
SinrUl3To6 = g.Sum(x => x.SinrUl3To6),
SinrUl6To9 = g.Sum(x => x.SinrUl6To9),
SinrUl9To12 = g.Sum(x => x.SinrUl9To12),
SinrUl12To15 = g.Sum(x => x.SinrUl12To15),
SinrUl15To18 = g.Sum(x => x.SinrUl15To18),
SinrUl18To21 = g.Sum(x => x.SinrUl18To21),
SinrUl21To24 = g.Sum(x => x.SinrUl21To24),
SinrUlAbove24 = g.Sum(x => x.SinrUlAbove24),
FrequencyBandType = bandType
};
return(mergeStats);
}
public IEnumerable <MrsSinrUlStat> QueryDateSpanMrsSinrUlStats(DateTime begin, DateTime end)
{
return(_sinrUlRepository.GetAllList(x => x.StatDate >= begin && x.StatDate < end));
}
