public IList <TrafficSourceScope> GetPageviewSource(TrafficQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
StringBuilder stringBuilder2 = new StringBuilder(" PageType=" + 4);
if (query.Type.ToLower() == "pv")
{
stringBuilder.Append("select SourceId,sum(pv) as scope from [Hishop_DailyAccessStatistics] where ");
}
else if (query.Type.ToLower() == "uv")
{
stringBuilder.Append("select SourceId,sum(uv) as scope from [Hishop_DailyAccessStatistics] where ");
}
stringBuilder2.AppendFormat(" AND StatisticalDate between '{0}' and '{1}'", query.CustomConsumeStartTime, query.CustomConsumeEndTime);
stringBuilder.Append(stringBuilder2);
stringBuilder.Append(" group by SourceId");
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
IList <TrafficSourceScope> result = new List <TrafficSourceScope>();
using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand))
{
result = (DataHelper.ReaderToList <TrafficSourceScope>(objReader) as List <TrafficSourceScope>);
}
return(result);
}
public static IList <TrafficSourceScope> GetPageviewSource(TrafficQuery query)
{
DateTime dateTime;
if (query.LastConsumeTime == EnumConsumeTime.custom)
{
if (query.CustomConsumeStartTime > query.CustomConsumeEndTime)
{
return(null);
}
}
else if (query.LastConsumeTime == EnumConsumeTime.inOneMonth)
{
dateTime = DateTime.Now;
dateTime = dateTime.Date;
query.CustomConsumeEndTime = dateTime.AddDays(-1.0);
dateTime = query.CustomConsumeEndTime;
query.CustomConsumeStartTime = dateTime.AddDays(-29.0);
}
else if (query.LastConsumeTime == EnumConsumeTime.inOneWeek)
{
dateTime = DateTime.Now;
dateTime = dateTime.Date;
query.CustomConsumeEndTime = dateTime.AddDays(-1.0);
dateTime = query.CustomConsumeEndTime;
query.CustomConsumeStartTime = dateTime.AddDays(-6.0);
}
else if (query.LastConsumeTime == EnumConsumeTime.preThreeMonth)
{
dateTime = DateTime.Now;
dateTime = dateTime.Date;
query.CustomConsumeEndTime = dateTime.AddDays(-1.0);
dateTime = query.CustomConsumeEndTime;
query.CustomConsumeStartTime = dateTime.AddDays(-89.0);
}
else
{
dateTime = DateTime.Now;
dateTime = dateTime.Date;
query.CustomConsumeEndTime = dateTime.AddDays(-1.0);
query.CustomConsumeStartTime = query.CustomConsumeEndTime;
}
return(new TrafficDao().GetPageviewSource(query));
}
public IList <Traffics> GetPageview(TrafficQuery query)
{
StringBuilder stringBuilder = new StringBuilder(" select sum(PV) PV,sum(UV) UV, StatisticalDate from [dbo].[Hishop_DailyAccessStatistics] where ");
stringBuilder.AppendFormat(" StatisticalDate between '{0}' and '{1}'", query.CustomConsumeStartTime, query.CustomConsumeEndTime);
if (query.PageType >= 0)
{
stringBuilder.Append("AND PageType=" + query.PageType);
}
if (query.PageType == 1)
{
stringBuilder.Append(" AND StoreId = 0");
}
stringBuilder.Append(" group by StatisticalDate");
IList <Traffics> result = new List <Traffics>();
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand))
{
result = (DataHelper.ReaderToList <Traffics>(objReader) as List <Traffics>);
}
return(result);
}
public static IList <Traffics> GetPageview(TrafficQuery query)
{
DateTime dateTime;
if (query.LastConsumeTime == EnumConsumeTime.custom)
{
if (query.CustomConsumeStartTime > query.CustomConsumeEndTime)
{
return(null);
}
}
else if (query.LastConsumeTime == EnumConsumeTime.inOneMonth)
{
dateTime = DateTime.Now;
dateTime = dateTime.Date;
query.CustomConsumeEndTime = dateTime.AddDays(-1.0);
dateTime = query.CustomConsumeEndTime;
query.CustomConsumeStartTime = dateTime.AddDays(-29.0);
}
else if (query.LastConsumeTime == EnumConsumeTime.inOneWeek)
{
dateTime = DateTime.Now;
dateTime = dateTime.Date;
query.CustomConsumeEndTime = dateTime.AddDays(-1.0);
dateTime = query.CustomConsumeEndTime;
query.CustomConsumeStartTime = dateTime.AddDays(-6.0);
}
else if (query.LastConsumeTime == EnumConsumeTime.preThreeMonth)
{
dateTime = DateTime.Now;
dateTime = dateTime.Date;
query.CustomConsumeEndTime = dateTime.AddDays(-1.0);
dateTime = query.CustomConsumeEndTime;
query.CustomConsumeStartTime = dateTime.AddDays(-89.0);
}
else
{
dateTime = DateTime.Now;
dateTime = dateTime.Date;
query.CustomConsumeEndTime = dateTime.AddDays(-1.0);
query.CustomConsumeStartTime = query.CustomConsumeEndTime;
}
IList <Traffics> list = new TrafficDao().GetPageview(query);
if (query.CustomConsumeStartTime < query.CustomConsumeEndTime)
{
DateTime dtDay = query.CustomConsumeStartTime;
while (dtDay <= query.CustomConsumeEndTime)
{
if (list.FirstOrDefault((Traffics c) => c.StatisticalDate == dtDay) == null)
{
Traffics traffics = new Traffics();
traffics.StatisticalDate = dtDay;
list.Add(traffics);
}
dtDay = dtDay.AddDays(1.0);
}
list = (from c in list
orderby c.StatisticalDate
select c).ToList();
}
return(list);
}
