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