public int GetAccessStatisticsModelList(EnumConsumeTime TimeType, DateTime StartDate, DateTime EndDate)
{
string format = "SELECT IsNull(SUM(UV),null) AS UV FROM dbo.Hishop_DailyAccessStatistics";
format = string.Format(format, 4);
string text = $" where StoreId = 0 AND PageType = {4} and ";
int num;
switch (TimeType)
{
case EnumConsumeTime.custom:
text = text + "StatisticalDate >= '" + StartDate + "' and StatisticalDate <= '" + EndDate + "'";
break;
default:
num = ((TimeType == EnumConsumeTime.inOneWeek) ? 1 : 0);
goto IL_0079;
case EnumConsumeTime.inOneMonth:
{
num = 1;
goto IL_0079;
}
IL_0079:
text = ((num == 0) ? ((TimeType != EnumConsumeTime.yesterday) ? (text + "StatisticalDate = '" + DateTime.Now.Date + "'") : (text + "StatisticalDate = '" + StartDate.Date + "'")) : (text + "StatisticalDate >= '" + StartDate + "' and StatisticalDate < '" + EndDate + "'"));
break;
}
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(format + text);
return(base.database.ExecuteScalar(sqlStringCommand).ToInt(0));
}
public IList <OrderStatisticModel> GetOrderDailyStatisticsList(EnumConsumeTime TimeType, DateTime StartDate, DateTime EndDate)
{
string format = "SELECT a.StatisticalDate, IsNull(b.PV,0) AS PV,IsNull(b.UV,0) AS UV,[OrderUserNum] ,[OrderNum],[OrderProductQuantity],[OrderAmount],[PaymentUserNum] ,[PaymentOrderNum]\r\n ,[PaymentProductNum],[PaymentAmount],[RefundAmount] FROM Hishop_OrderDailyStatistics AS a\r\n LEFT JOIN (SELECT SUM(PV) AS PV ,SUM(UV) AS UV,StatisticalDate,PageType FROM dbo.Hishop_DailyAccessStatistics WHERE StoreId = 0\r\n GROUP BY StatisticalDate,PageType HAVING PageType = {0}) AS b\r\n ON b.StatisticalDate = a.StatisticalDate";
format = string.Format(format, 4);
string text = " where ";
int num;
switch (TimeType)
{
case EnumConsumeTime.custom:
text = text + "a.StatisticalDate >= '" + StartDate + "' and a.StatisticalDate <= '" + EndDate + "'";
break;
default:
num = ((TimeType == EnumConsumeTime.inOneWeek) ? 1 : 0);
goto IL_0070;
case EnumConsumeTime.inOneMonth:
{
num = 1;
goto IL_0070;
}
IL_0070:
text = ((num == 0) ? ((TimeType != EnumConsumeTime.yesterday) ? (text + "a.StatisticalDate = '" + DateTime.Now.Date + "'") : (text + "a.StatisticalDate = '" + StartDate.Date + "'")) : (text + "a.StatisticalDate >= '" + StartDate + "' and a.StatisticalDate < '" + EndDate + "'"));
break;
}
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(format + text);
using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand))
{
return(DataHelper.ReaderToList <OrderStatisticModel>(objReader));
}
}
public static int GetAccessStatisticsModelList(EnumConsumeTime TimeType, DateTime StartDate, DateTime EndDate)
{
return(new TransactionAnalysisDao().GetAccessStatisticsModelList(TimeType, StartDate, EndDate));
}
public static IList <OrderStatisticModel> GetOrderDailyStatisticsList(EnumConsumeTime TimeType, DateTime StartDate, DateTime EndDate)
{
return(new TransactionAnalysisDao().GetOrderDailyStatisticsList(TimeType, StartDate, EndDate));
}
