public IEnumerable <CdmaBtsView> GetByGeneralName(string name)
{
var items =
_btsRepository.GetAllList().Where(x => x.Name.IndexOf(name.Trim(), StringComparison.Ordinal) >= 0).ToArray();
if (items.Any())
{
return(items.MapTo <IEnumerable <CdmaBtsView> >());
}
var btsId = name.Trim().ConvertToInt(0);
if (btsId > 0)
{
items = _btsRepository.GetAll().Where(x => x.BtsId == btsId).ToArray();
if (items.Any())
{
return(items.MapTo <IEnumerable <CdmaBtsView> >());
}
}
items =
_btsRepository.GetAllList()
.Where(
x =>
x.Address.IndexOf(name.Trim(), StringComparison.Ordinal) >= 0)
.ToArray();
return(items.Any() ? items.MapTo <IEnumerable <CdmaBtsView> >() : null);
}
public IEnumerable <CdmaBtsView> GetByTownArea(string city, string district, string town)
{
var list = new List <CdmaBtsView>();
var townItem = _townRepository.GetAllList()
.FirstOrDefault(x => x.CityName == city && x.DistrictName == district && x.TownName == town);
if (townItem == null)
{
return(list);
}
var boudary = _boundaryRepository.FirstOrDefault(x => x.TownId == townItem.Id);
if (boudary == null)
{
return(list);
}
foreach (var townEntity in _townRepository.GetAllList(x => x.CityName == city && x.DistrictName == district && x.TownName != town))
{
var views =
_btsRepository.GetAllList(x => x.TownId == townEntity.Id)
.Where(x => boudary.IsInTownRange(x))
.MapTo <List <CdmaBtsView> >();
views.ForEach(x =>
{
x.DistrictName = district;
x.TownName = townEntity.TownName;
x.TownId = townItem.Id;
});
list.AddRange(views);
}
return(list);
}
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 IEnumerable <CdmaBtsView> GetByTownNames(string city, string district, string town)
{
var townItem = _townRepository.GetAllList()
.FirstOrDefault(x => x.CityName == city && x.DistrictName == district && x.TownName == town);
var viewList = _btsRepository.GetAllList(x => x.TownId == townItem.Id).MapTo <List <CdmaBtsView> >();
viewList.ForEach(x =>
{
x.CityName = city;
x.DistrictName = district;
x.TownName = town;
});
return(townItem == null
? new List <CdmaBtsView>()
: viewList);
}
public IEnumerable <BtsExcel> GetNewBtsExcels()
{
if (!BtsExcels.Any())
{
return(new List <BtsExcel>());
}
return(from info in BtsExcels
join bts in _btsRepository.GetAllList()
on info.BtsId equals bts.BtsId into btsQuery
from bq in btsQuery.DefaultIfEmpty()
where bq == null
select info);
}
public ENodebBaseRepository(IBtsRepository inputRepository)
{
eNodebBaseList.Clear();
foreach (CdmaBts bts in inputRepository.GetAllList())
{
eNodebBaseList.Add(new ENodebBase
{
ENodebId = bts.BtsId,
Name = bts.Name,
TownId = bts.TownId
});
}
}
public ENodebBaseRepository(IBtsRepository inputRepository)
{
eNodebBaseList.Clear();
foreach (CdmaBts bts in inputRepository.GetAllList())
{
eNodebBaseList.Add(new ENodebBase
{
ENodebId = bts.BtsId,
Name = bts.Name,
TownId = bts.TownId
});
}
}
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 <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 UpdateCdmaLteIdService(IBtsRepository repository,
ICdmaCellRepository cellRepository, IEnumerable <CdmaLteIds> lteIds)
: this(repository)
{
var cdmaLteInfos =
(from a in repository.GetAllList()
join b in cellRepository.GetAllList()
on a.BtsId equals b.BtsId
where a.ENodebId == -1
select new { a.BtsId, b.CellId }).Distinct();
_eNodebIds =
from a in cdmaLteInfos
join c in lteIds
on a.CellId equals c.CdmaCellId
select new BtsENodebIds
{
ENodebId = c.ENodebId,
BtsId = a.BtsId
};
}
public UpdateCdmaLteIdService(IBtsRepository repository,
ICdmaCellRepository cellRepository, IEnumerable<CdmaLteIds> lteIds)
: this(repository)
{
var cdmaLteInfos =
(from a in repository.GetAllList()
join b in cellRepository.GetAllList()
on a.BtsId equals b.BtsId
where a.ENodebId == -1
select new {a.BtsId, b.CellId}).Distinct();
_eNodebIds =
from a in cdmaLteInfos
join c in lteIds
on a.CellId equals c.CdmaCellId
select new BtsENodebIds
{
ENodebId = c.ENodebId,
BtsId = a.BtsId
};
}
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 IEnumerable <CdmaBts> Get()
{
return(_repository.GetAllList());
}
