public List <TopPrecise4GContainer> GetTopCountStats(DateTime begin, DateTime end, int topCount,
                                                             OrderPreciseStatService.OrderPreciseStatPolicy policy)
        {
            var query =
                _repository.GetAll()
                .Where(x => x.StatTime >= begin && x.StatTime <end && x.TotalMrs> TotalMrsThreshold);
            var result =
                from q in query.AsEnumerable()
                group q by new
            {
                q.CellId,
                q.SectorId
            }
            into g
                select new TopPrecise4GContainer
            {
                PreciseCoverage4G = new PreciseCoverage4G
                {
                    CellId          = g.Key.CellId,
                    SectorId        = g.Key.SectorId,
                    FirstNeighbors  = g.Sum(q => q.FirstNeighbors),
                    SecondNeighbors = g.Sum(q => q.SecondNeighbors),
                    ThirdNeighbors  = g.Sum(q => q.ThirdNeighbors),
                    TotalMrs        = g.Sum(q => q.TotalMrs)
                },
                TopDates = g.Count()
            };

            var orderResult = result.Order(policy, topCount);

            return(orderResult);
        }
Пример #2
0
 public void UpdateKpi(IPreciseCoverage4GRepository repository, DateTime begin, DateTime end)
 {
     var query = repository.GetAll().Where(x => x.StatTime >= begin && x.StatTime < end
                                                && x.CellId == ENodebId && x.SectorId == SectorId).ToList();
     if (query.Count > 0)
     {
         var sum = query.Sum(x => x.TotalMrs);
         PreciseRate = sum == 0 ? 100 : 100 - (double)query.Sum(x => x.SecondNeighbors) / sum * 100;
     }
 }
        public void UpdateKpi(IPreciseCoverage4GRepository repository, DateTime begin, DateTime end)
        {
            var query = repository.GetAll().Where(x => x.StatTime >= begin && x.StatTime < end &&
                                                  x.CellId == ENodebId && x.SectorId == SectorId).ToList();

            if (query.Count > 0)
            {
                var sum = query.Sum(x => x.TotalMrs);
                PreciseRate = sum == 0 ? 100 : 100 - (double)query.Sum(x => x.SecondNeighbors) / sum * 100;
            }
        }