private IEnumerable <QciView> QueryDistrictViews(string city, string district, DateTime begin, DateTime end)
{
var zteStats =
ZteRepository.GetAllList(
x => x.StatTime >= begin && x.StatTime < end &&
x.Cqi0Times + x.Cqi1Times + x.Cqi2Times + x.Cqi3Times + x.Cqi4Times
+ x.Cqi5Times + x.Cqi6Times + x.Cqi7Times + x.Cqi8Times + x.Cqi9Times
+ x.Cqi10Times + x.Cqi11Times + x.Cqi12Times + x.Cqi13Times + x.Cqi14Times + x.Cqi15Times > 2000);
var huaweiStats =
HuaweiRepository.GetAllList(x => x.StatTime >= begin && x.StatTime < end &&
x.Cqi0Times + x.Cqi1Times + x.Cqi2Times + x.Cqi3Times + x.Cqi4Times
+ x.Cqi5Times + x.Cqi6Times + x.Cqi7Times + x.Cqi8Times + x.Cqi9Times
+ x.Cqi10Times + x.Cqi11Times + x.Cqi12Times + x.Cqi13Times + x.Cqi14Times + x.Cqi15Times > 2000);
var results = HuaweiCellRepository.QueryDistrictFlowViews <QciView, QciZte, QciHuawei>(city, district,
zteStats,
huaweiStats,
TownRepository, ENodebRepository);
return(results);
}
protected override List <RssiZte> QueryList(DateTime begin, DateTime end)
{
return
(ZteRepository.GetAllList(
x => x.StatTime >= begin && x.StatTime < end && x.ENodebId == ENodebId && x.SectorId == SectorId));
}
public IEnumerable <RrcView> QueryTopRrcFailViews(string city, string district, DateTime begin, DateTime end,
int topCount)
{
var results = HuaweiCellRepository.QueryDistrictFlowViews <RrcView, RrcZte, RrcHuawei>(city, district,
ZteRepository.GetAllList(
x =>
x.StatTime >= begin && x.StatTime < end &&
x.MoDataRrcRequest + x.MoSignallingRrcRequest + x.MtAccessRrcRequest > 20000),
HuaweiRepository.GetAllList(
x =>
x.StatTime >= begin && x.StatTime < end &&
x.MoDataRrcRequest + x.MoSignallingRrcRequest + x.MtAccessRrcRequest > 20000),
TownRepository, ENodebRepository);
return(results.OrderByDescending(x => x.TotalRrcFail).Take(topCount));
}
public IEnumerable <FlowView> QueryTopRank2Views(string city, string district, DateTime begin, DateTime end,
int topCount)
{
var results = HuaweiCellRepository.QueryDistrictFlowViews <FlowView, FlowZte, FlowHuawei>(city, district,
ZteRepository.GetAllList(x => x.StatTime >= begin && x.StatTime < end && x.SchedulingTm3 > 10000000),
HuaweiRepository.GetAllList(
x => x.StatTime >= begin && x.StatTime < end && x.SchedulingRank1 + x.SchedulingRank2 > 20000000),
TownRepository, ENodebRepository);
return(results.OrderBy(x => x.Rank2Rate).Take(topCount));
}
protected override List <FlowZte> QueryList(DateTime begin, DateTime end)
{
return(ZteRepository.GetAllList(begin, end, ENodebId, SectorId));
}