public List <ENodeb> GetDistrictENodebs(string city, string district) { var towns = _townRepository.GetAllList(x => x.CityName == city && x.DistrictName == district); var eNodebs = _eNodebRepository.GetAllList(); return((from t in towns join e in eNodebs on t.Id equals e.TownId select e).ToList()); }
public List <DistrictBandClassStat> QueryDistrictBandStats(string city) { var eNodebTownIds = _eNodebRepository.GetAllList().Select(x => new { x.TownId, x.ENodebId }); var allCells = _cellRepository.GetAllInUseList(); return((from district in GetDistricts(city) let townList = _repository.GetAllList().Where(x => x.CityName == city && x.DistrictName == district) let cells = (from t in townList join e in eNodebTownIds on t.Id equals e.TownId join c in allCells on e.ENodebId equals c.ENodebId select c) select new DistrictBandClassStat { District = district, Band1Cells = cells.Count(x => x.BandClass == 1), Band3Cells = cells.Count(x => x.BandClass == 3), Band5Cells = cells.Count(x => x.BandClass == 5 && x.Frequency != 2506), NbIotCells = cells.Count(x => x.BandClass == 5 && x.Frequency == 2506), Band41Cells = cells.Count(x => x.BandClass == 41) }).ToList()); }
public IEnumerable <ENodeb> GetENodebsByDistrict(string city, string district) { var towns = _townRepository.GetAllList(city, district); return(from town in towns join eNodeb in _eNodebRepository.GetAllList() on town.Id equals eNodeb.TownId select eNodeb); }
public ViewResult TopDrop2G(TopDrop2GViewModel postedModel) { TopDrop2GViewModel viewModel = topDrop2GRepository.Stats.GenerateView <TopDrop2GViewModel, TopDrop2GCell, TopDrop2GCellView>( postedModel.StatDate, regionNamesService.Query().ToList(), btsRepository.GetAllList(), eNodebRepository.GetAllList()); return(View(viewModel)); }
public static IEnumerable <TTownStat> GetTownFrequencyItems <TStat, TTownStat>(this List <TStat> stats, FrequencyBandType bandType, ICellRepository cellRepository, IENodebRepository eNodebRepository) where TStat : ILteCellQuery where TTownStat : ITownId { var cells = cellRepository.GetAllList(bandType); var query = from stat in stats join cell in cells on new { stat.ENodebId, stat.SectorId } equals new { cell.ENodebId, cell.SectorId } join eNodeb in eNodebRepository.GetAllList() on cell.ENodebId equals eNodeb.ENodebId select new { Stat = stat, eNodeb.TownId }; var townStats = query.Select(x => { var townStat = Mapper.Map <TStat, TTownStat>(x.Stat); townStat.TownId = x.TownId; return(townStat); }); return(townStats); }
public JsonResult CoverageAdjust(CoverageStatChart chart) { List <ENodeb> eNodebList = eNodebRepository.GetAllList(); IEnumerable <CoverageAdjustment> adjustments = chart.StatList.GenerateAdjustmentList(cellRepository, eNodebList); var result = from a in adjustments join e in eNodebList on a.ENodebId equals e.ENodebId select new { N = e.Name + "-" + a.SectorId, F = a.Frequency, F165m = (int)(100 * a.Factor165m) / (double)(100), F135m = (int)(100 * a.Factor135m) / (double)(100), F105m = (int)(100 * a.Factor105m) / (double)(100), F75m = (int)(100 * a.Factor75m) / (double)(100), F45m = (int)(100 * a.Factor45m) / (double)(100), F15m = (int)(100 * a.Factor15m) / (double)(100), F15 = (int)(100 * a.Factor15) / (double)(100), F45 = (int)(100 * a.Factor45) / (double)(100), F75 = (int)(100 * a.Factor75) / (double)(100), F105 = (int)(100 * a.Factor105) / (double)(100), F135 = (int)(100 * a.Factor135) / (double)(100), F165 = (int)(100 * a.Factor165) / (double)(100) }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public void ImportTownENodebStats(ITownRepository townRepository, IENodebRepository eNodebRepository, IRegionRepository regionRepository) { IEnumerable <ENodeb> eNodebs = eNodebRepository.GetAllList(); TownENodebStats = townRepository.GetAllList().Select( x => new TownENodebStat(x, eNodebs, regionRepository)).ToList(); }
public IEnumerable <TopCoverageStatView> GetAllTopViews(DateTime begin, DateTime end, int topCount, OrderMrsRsrpPolicy policy) { return(GetTopViews(begin, end, topCount, policy, _eNodebRepository.GetAllList(), (beginDate, endDate) => _repository.GetAllList(x => x.StatDate >= beginDate && x.StatDate < endDate && x.TelecomAbove110 < x.TelecomMrs * 0.6 && x.TelecomMrs > 20000))); }
private IEnumerable <TownPreciseCoverage4GStat> GetTownStats(List <PreciseCoverage4G> stats) { var query = from stat in stats join eNodeb in _eNodebRepository.GetAllList() on stat.CellId equals eNodeb.ENodebId select new { Stat = stat, eNodeb.TownId }; var townStats = query.Select(x => { var townStat = Mapper.Map <PreciseCoverage4G, TownPreciseCoverage4GStat>(x.Stat); townStat.TownId = x.TownId; return(townStat); }); return(townStats); }
public IEnumerable <ENodebFlowView> GetENodebFlowViews(DateTime begin, DateTime end, FrequencyBandType frequency = FrequencyBandType.All) { var eNodebStatList = new List <ENodebFlowView>(); var zteFlows = _zteRepository.QueryZteFlows <FlowZte, IFlowZteRepository>(frequency, begin, end); var huaweiFlows = QueryHuaweiFlows(begin, end, frequency); var eNodebs = _eNodebRepository.GetAllList(); return(GenerateENodebFlowViews(eNodebStatList, huaweiFlows, eNodebs, zteFlows)); }
public IEnumerable <ENodebView> GetByTownNames(string city, string district, string town) { var townItem = _townRepository.GetAllList() .FirstOrDefault(x => x.CityName == city && x.DistrictName == district && x.TownName == town); if (townItem == null) { return(new List <ENodebView>()); } var list = _eNodebRepository.GetAllList(x => x.TownId == townItem.Id).MapTo <List <ENodebView> >(); list.ForEach(x => { x.CityName = city; x.DistrictName = district; x.TownName = town; }); return(list); }
private void OpenMro_OnClick(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(DirectoryPath.Content.ToString())) { return; } DirectoryInfo dir = new DirectoryInfo(DirectoryPath.Content.ToString()); List <ENodeb> eNodebs = _eNodebRepository.GetAllList(); ImportMrFilesAsync(dir, eNodebs); }
public static List <ENodeb> QueryENodebs(this ITownRepository townRepository, IENodebRepository eNodebRepository, string city, string district) { var towns = townRepository.GetAllList(x => x.CityName == city && x.DistrictName == district); if (!towns.Any()) { return(new List <ENodeb>()); } return((from eNodeb in eNodebRepository.GetAllList() join town in towns on eNodeb.TownId equals town.Id select eNodeb).ToList()); }
public ENodebBaseRepository(IENodebRepository inputRepository) { eNodebBaseList.Clear(); foreach (ENodeb eNodeb in inputRepository.GetAllList()) { eNodebBaseList.Add(new ENodebBase { ENodebId = eNodeb.ENodebId, Name = eNodeb.Name, TownId = eNodeb.TownId }); } }
public IEnumerable <ENodebAlarmWorkItemGroup> QueryENodebAlarmGroups(DateTime begin, DateTime end, int count) { var alarms = _repository.GetAllList( x => x.HappenTime >= begin && x.HappenTime < end && x.NetworkType == NetworkType.With4G); var groups = alarms.Where(x => x.SectorId == 255).ToList().GroupBy(x => x.ENodebId); var eNodebs = _eNodebRepository.GetAllList(); var results = groups.Select(g => new ENodebAlarmWorkItemGroup { ENodebId = g.Key, AlarmCounts = g.Count(), ItemList = g.Select(x => x.MapTo <AlarmWorkItemView>()).ToList() }).OrderByDescending(x => x.AlarmCounts).Take(count).ToList(); results.ForEach(result => { var eNodeb = eNodebs.FirstOrDefault(x => x.ENodebId == result.ENodebId); if (eNodeb != null) { eNodeb.MapTo(result); } }); return(results); }
public IEnumerable <AgpsCoverageTown> QueryAgpsCoverageTowns(List <AgpsMongo> stats, string type, DateTime statDate) { return((from town in _townRepository.GetAllList() let eNodebs = _eNodebRepository.GetAllList(x => x.TownId == town.Id) let townStats = (from s in stats join e in eNodebs on s.ENodebId equals e.ENodebId select s).ToList() select new AgpsCoverageTown { District = town.DistrictName, Town = town.TownName, Operator = type, StatDate = statDate, Count = townStats.Sum(x => x.Count), GoodCount = townStats.Sum(x => x.GoodCount), GoodCount105 = townStats.Sum(x => x.GoodCount105), GoodCount100 = townStats.Sum(x => x.GoodCount100) }).ToList()); }
public ActionResult Import(int page = 1) { IEnumerable <ENodebBase> eNodebBases = _eNodebRepository.GetAllList().Select(x => new ENodebBase { ENodebId = x.ENodebId, Name = x.Name }); MrInterferenceViewModel model = new MrInterferenceViewModel { StartDate = DateTime.Today.AddDays(-7), EndDate = DateTime.Today }; model.InitializeTownList(_townRepository, model); model.UpdateStats(RutraceStatContainer.MrsStats, eNodebBases, PageSize, page); return(View(model)); }
public static IEnumerable <TView> QueryAllFlowViews <TView, TZte, THuawei>(this ICellRepository huaweiCellRepository, List <TZte> zteStats, List <THuawei> huaweiStats, IENodebRepository eNodebRepository) where TZte : ILteCellQuery where THuawei : ILocalCellQuery where TView : class, IENodebName, ILteCellQuery, new() { var eNodebs = eNodebRepository.GetAllList(); if (!eNodebs.Any()) { return(new List <TView>()); } var zteViews = eNodebs.QueryZteViews <TView, TZte>(zteStats); var huaweiViews = eNodebs.QueryHuaweiViews <TView, THuawei>(huaweiStats, huaweiCellRepository); return(zteViews.Concat(huaweiViews).ToList()); }
public static IEnumerable <TopCellContainer <TTopCell> > QueryContainers <TTopCell>(this List <TTopCell> topCells, IBtsRepository btsRepository, IENodebRepository eNodebRepository) where TTopCell : IBtsIdQuery { return(from stat in topCells join bts in btsRepository.GetAllList() on stat.BtsId equals bts.BtsId into btsQuery from bq in btsQuery.DefaultIfEmpty() join eNodeb in eNodebRepository.GetAllList() on bq?.ENodebId ?? -1 equals eNodeb.ENodebId into query from q in query.DefaultIfEmpty() select new TopCellContainer <TTopCell> { TopCell = stat, LteName = q == null ? "无匹配LTE基站" : q.Name, CdmaName = bq == null ? "无匹配CDMA基站" : bq.Name }); }
public static IEnumerable <TTownStat> GetTownStats <TStat, TTownStat>(this IEnumerable <TStat> stats, IENodebRepository eNodebRepository) where TStat : IENodebId where TTownStat : ITownId { var query = from stat in stats join eNodeb in eNodebRepository.GetAllList() on stat.ENodebId equals eNodeb.ENodebId select new { Stat = stat, eNodeb.TownId }; var townStats = query.Select(x => { var townStat = Mapper.Map <TStat, TTownStat>(x.Stat); townStat.TownId = x.TownId; return(townStat); }); return(townStats); }
public IEnumerable <CellIdPair> QueryUnmatchedHuaweis(int townId, DateTime date) { var eNodebs = _eNodebRepository.GetAllList(x => x.TownId == townId); var cells = from cell in _cellRepository.GetAllList() join eNodeb in eNodebs on cell.ENodebId equals eNodeb.ENodebId select cell; var stats = _huaweiRepository.GetAllList(x => x.StatTime >= date); var townStats = from stat in stats join eNodeb in eNodebs on stat.ENodebId equals eNodeb.ENodebId select stat; return(from stat in townStats join cell in cells on new { stat.ENodebId, stat.LocalCellId } equals new { cell.ENodebId, LocalCellId = cell.LocalSectorId } into match from m in match.DefaultIfEmpty() where m == null select new CellIdPair { CellId = stat.ENodebId, SectorId = stat.LocalCellId }); }
public static IEnumerable <TENodebStat> GetENodebStats <TStat, TENodebStat>(this IEnumerable <TStat> stats, IENodebRepository eNodebRepository) where TStat : IENodebId where TENodebStat : IENodebId, IGeoPoint <double> { var query = from stat in stats join eNodeb in eNodebRepository.GetAllList() on stat.ENodebId equals eNodeb.ENodebId select new { Stat = stat, eNodeb.Longtitute, eNodeb.Lattitute }; var eNodebStats = query.Select(x => { var eNodebStat = Mapper.Map <TStat, TENodebStat>(x.Stat); eNodebStat.Longtitute = x.Longtitute; eNodebStat.Lattitute = x.Lattitute; return(eNodebStat); }); return(eNodebStats); }
public JsonResult Query(DateTime begin, DateTime end, string city, int topCounts = 20) { DateTime endDate = end.AddDays(1); IEnumerable <TopConnection3GCell> stats = statRepository.Stats.QueryTimeStats(begin, endDate, city).ToList(); if (stats.Any()) { CdmaLteNamesService <TopConnection3GCell> service = new CdmaLteNamesService <TopConnection3GCell>( stats, btsRepository.GetAllList(), eNodebRepository.GetAllList()); IEnumerable <TopConnection3GCellView> cellViews = service.Clone <TopConnection3GCellView>(); var statCounts = from v in cellViews group v by new { v.CdmaName, v.SectorId } into g select new { CarrierName = g.Key.CdmaName + "-" + g.Key.SectorId, TopDates = g.Count(), SumOfTimes = g.Sum(v => v.ConnectionFails) }; return(Json(statCounts.OrderByDescending(x => x.SumOfTimes).Take(topCounts), JsonRequestBehavior.AllowGet)); } return(Json(new List <int>(), JsonRequestBehavior.AllowGet)); }
public static IEnumerable <TTownStat> GetTownDateStats <TStat, TTownStat>(this IEnumerable <TStat> stats, IENodebRepository eNodebRepository, Action <TStat, TTownStat> patchAction) where TStat : IENodebId, IStatTime where TTownStat : ITownId, IStatDate { var query = from stat in stats join eNodeb in eNodebRepository.GetAllList() on stat.ENodebId equals eNodeb.ENodebId select new { Stat = stat, eNodeb.TownId }; var townStats = query.Select(x => { var townStat = Mapper.Map <TStat, TTownStat>(x.Stat); townStat.TownId = x.TownId; townStat.StatDate = x.Stat.StatTime.Date; patchAction(x.Stat, townStat); return(townStat); }); return(townStats); }
public void ImportTownENodebStats(ITownRepository townRepository, IENodebRepository eNodebRepository, IRegionRepository regionRepository) { IEnumerable<ENodeb> eNodebs = eNodebRepository.GetAllList(); TownENodebStats = townRepository.GetAllList().Select( x => new TownENodebStat(x, eNodebs, regionRepository)).ToList(); }
public IEnumerable <ENodeb> Get() { return(_repository.GetAllList()); }
public static IEnumerable <TopStatCount> QueryTopCounts <TCell, TView>(this IEnumerable <TCell> stats, IBtsRepository btsRepository, IENodebRepository eNodebRepository, int topCounts) where TCell : class, ICdmaCell, new() where TView : class, IGetTopCellView, new() { CdmaLteNamesService <TCell> service = new CdmaLteNamesService <TCell>(stats, btsRepository.GetAllList(), eNodebRepository.GetAllList()); IEnumerable <TView> cellViews = service.Clone <TView>(); IEnumerable <TopStatCount> statCounts = from v in cellViews group v by new { v.CdmaName, v.SectorId, v.Frequency } into g select new TopStatCount { CarrierName = g.Key.CdmaName + "-" + g.Key.SectorId + "-" + g.Key.Frequency, TopDates = g.Count(), SumOfTimes = g.Sum(v => v.Drops) }; return(statCounts.OrderByDescending(x => x.SumOfTimes).Take(topCounts)); }
public void Save(IEnumerable <BtsExcel> btsInfoList, bool updateBts) { IEnumerable <Town> townList = _townRepository.GetAllList(); List <ENodeb> eNodebList = (_lteRepository == null) ? null : _lteRepository.GetAllList(); TownIdAssignedSaveOneBtsService service = new TownIdAssignedSaveOneBtsService( _repository, _baseRepository, 0, eNodebList); foreach (BtsExcel btsExcel in btsInfoList.Distinct(new BtsExcelComparer())) { var town = townList.FirstOrDefault(x => x.DistrictName == btsExcel.DistrictName && x.TownName == btsExcel.TownName); var townId = (town == null) ? -1 : town.Id; service.TownId = townId; if (service.SaveOneBts(btsExcel, updateBts)) { _infrastructure.CdmaBtsUpdated++; } } }
public void ResetENodebList() { eNodebList = eNodebRepository.GetAllList(); }