public List <QciView> QueryTopCqiViews(string city, string district, DateTime begin, DateTime end,
int topCount, OrderCqiPolicy policy)
{
var joinViews = QueryDistrictViews(city, district, begin, end);
return(QueryTopViewsByPolicy(joinViews, topCount, policy));
}
public List <HourCqiView> QueryTopCqiViews(string city, string district, DateTime begin, DateTime end,
int topCount, OrderCqiPolicy policy)
{
var joinViews = QueryDistrictViews(city, district, begin, end).ToList();
var days = (joinViews.Max(x => x.StatTime) - joinViews.Min(x => x.StatTime)).Days + 1;
return(QueryTopViewsByPolicy(joinViews, topCount * days, policy));
}
private List <HourCqiView> QueryTopViewsByPolicy(IEnumerable <HourCqiView> source, int topCount,
OrderCqiPolicy policy)
{
switch (policy)
{
case OrderCqiPolicy.OrderByCqiRate:
return(source.OrderBy(x => x.CqiRate).Take(topCount).ToList());
case OrderCqiPolicy.OrderByPoorCqiDescending:
return(source.OrderByDescending(x => x.CqiCounts.Item1 - x.CqiCounts.Item2).Take(topCount).ToList());
}
return(new List <HourCqiView>());
}
public List <HourCqiView> QueryTopCqiViews(DateTime begin, DateTime end, int topCount, OrderCqiPolicy policy)
{
var stats = Repository.FilterTopList(begin, end);
var joinViews = stats.MapTo <List <HourCqiView> >();
var days = (joinViews.Max(x => x.StatTime) - joinViews.Min(x => x.StatTime)).Days + 1;
return(QueryTopViewsByPolicy(joinViews, topCount * days, policy));
}
public List <QciView> QueryTopCqiViews(DateTime begin, DateTime end, int topCount, OrderCqiPolicy policy)
{
var zteStats = ZteRepository.FilterTopList(begin, end);
var huaweiStats = HuaweiRepository.FilterTopList(begin, end);
var joinViews = HuaweiCellRepository.QueryAllFlowViews <QciView, QciZte, QciHuawei>(zteStats, huaweiStats).ToList();
var days = (joinViews.Max(x => x.StatTime) - joinViews.Min(x => x.StatTime)).Days + 1;
return(QueryTopViewsByPolicy(joinViews, topCount * days, policy));
}
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));
}
public List <CqiView> QueryTopDistrictViews(DateTime begin, DateTime end, int topCount, OrderCqiPolicy policy)
{
var zteStats = ZteRepository.FilterTopList(begin, end);
var huaweiStats = HuaweiRepository.FilterTopList(begin, end);
var joinViews = zteStats.MapTo <IEnumerable <CqiView> >().Concat(huaweiStats.MapTo <IEnumerable <CqiView> >()).ToList();
var days = (joinViews.Max(x => x.StatTime) - joinViews.Min(x => x.StatTime)).Days + 1;
return(QueryTopViewsByPolicy(joinViews, topCount * days, policy));
}
