protected override List <PrbHuawei> QueryList(DateTime begin, DateTime end, byte localCellId)
{
return
(HuaweiRepository.GetAllList(
x =>
x.StatTime >= begin && x.StatTime < end && x.ENodebId == ENodebId &&
x.LocalCellId == localCellId));
}
public IEnumerable <FlowView> QueryAllTopRank2Views(DateTime begin, DateTime end,
int topCount)
{
var results = HuaweiCellRepository.QueryAllFlowViews <FlowView, FlowZte, FlowHuawei>(
ZteRepository.GetAllList(x => x.StatTime >= begin && x.StatTime < end &&
x.SchedulingTm3 - x.SchedulingTm3Rank2 > 10000000),
HuaweiRepository.GetAllList(
x => x.StatTime >= begin && x.StatTime < end && x.SchedulingRank1 > 1000000));
return(results.OrderBy(x => x.Rank2Rate).Take(topCount));
}
public List <FlowView> QueryTopDownSwitchViews(DateTime begin, DateTime end, int topCount, OrderDownSwitchPolicy policy)
{
var zteViews =
ZteRepository.GetAllList(
x => x.StatTime >= begin && x.StatTime < end && x.RedirectA2 + x.RedirectB2 > 2000)
.MapTo <IEnumerable <FlowView> >();
var huaweiViews =
HuaweiRepository.GetAllList(x => x.StatTime >= begin && x.StatTime < end && x.RedirectCdma2000 > 2000)
.MapTo <IEnumerable <FlowView> >();
var joinViews = zteViews.Concat(huaweiViews);
return(QueryTopViewsByPolicy(joinViews, topCount, policy));
}
public IEnumerable <FlowView> QueryAllTownViews(string city, string district, string town,
DateTime begin, DateTime end, FrequencyBandType frequency)
{
var zteStats =
ZteRepository.QueryZteFlows <FlowZte, IFlowZteRepository>(frequency, begin, end);
var huaweiStats =
HuaweiRepository.GetAllList(x => x.StatTime >= begin && x.StatTime < end);
var results = HuaweiCellRepository.QueryTownFlowViews <FlowView, FlowZte, FlowHuawei>(city, district,
town, zteStats, huaweiStats, frequency,
TownRepository, ENodebRepository);
return(results);
}
private IEnumerable <FlowView> QueryDistrictViews(string city, string district, DateTime begin, DateTime end)
{
var zteStats =
ZteRepository.GetAllList(
x => x.StatTime >= begin && x.StatTime < end && x.RedirectA2 + x.RedirectB2 > 2000);
var huaweiStats =
HuaweiRepository.GetAllList(x => x.StatTime >= begin && x.StatTime < end && x.RedirectCdma2000 > 2000);
var results = HuaweiCellRepository.QueryDistrictFlowViews <FlowView, FlowZte, FlowHuawei>(city, district,
zteStats,
huaweiStats,
TownRepository, ENodebRepository);
return(results);
}
public List <QciView> QueryTopCqiViews(DateTime begin, DateTime end, int topCount, OrderCqiPolicy policy)
{
var zteViews =
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 > 200000)
.MapTo <IEnumerable <QciView> >();
var huaweiViews =
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 > 200000)
.MapTo <IEnumerable <QciView> >();
var joinViews = zteViews.Concat(huaweiViews);
return(QueryTopViewsByPolicy(joinViews, topCount, policy));
}
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);
}
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));
}
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));
}
protected override List <FlowHuawei> QueryList(DateTime begin, DateTime end, byte localCellId)
{
return(HuaweiRepository.GetAllList(begin, end, ENodebId, localCellId));
}
