public static List <dynamic> GetMonthlyData(DateTime dt)
{
SysRpt_WebDayInfoDAL dal = new SysRpt_WebDayInfoDAL();
return(dal.GetMonthlyData(dt));
}
public static dynamic GetAllData()
{
SysRpt_WebDayInfoDAL dal = new SysRpt_WebDayInfoDAL();
return(dal.GetAllData());
}
/// <summary>
/// 得到某段时间内的平均数据
/// </summary>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public static PanelShowModel.SomedayDataCount GetAverageData(DateTime startTime, DateTime endTime)
{
SysRpt_WebDayInfoDAL dal = new SysRpt_WebDayInfoDAL();
return(dal.GetAverageData(startTime, endTime));
}
public static chartDataModel GetDailyGraph(string type, DateTime date, string source = "all")
{
SysRpt_WebDayInfoDAL dayInfo = new SysRpt_WebDayInfoDAL();
chartDataModel chartData = new chartDataModel();
Dictionary <string, charDataList> charItemList = new Dictionary <string, charDataList>();
List <dynamic> list = dayInfo.GetIndexNowData(type, date);
List <dynamic> listYesterday = dayInfo.GetIndexNowData(type, date.AddDays(-1));
//Dictionary<string, charDataItemList> charDataItem =
//new Dictionary<string, charDataItemList>();
if (list != null && list.Count > 0)
{
DateTime hourTime = DateTime.Now;
switch (type)
{
//新增店铺
case "shop":
List <string> paramListShop = new List <string>();
if (source == "all")
{
paramListShop.Add("newShop");
paramListShop.Add("yesterShop");
}
else if (source == "android")
{
paramListShop.Add("android");
paramListShop.Add("yesterAndroid");
}
else if (source == "ios")
{
paramListShop.Add("ios");
paramListShop.Add("yesterIOS");
}
Dictionary <string, charDataList> charDataItemShop = InitChartData(paramListShop);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
if (source == "all")
{
charDataItemShop[XLable].ItemList["newShop"].Values = itemDataList.shop;
}
else if (source == "android")
{
charDataItemShop[XLable].ItemList["android"].Values = itemDataList.android;
}
else if (source == "ios")
{
charDataItemShop[XLable].ItemList["ios"].Values = itemDataList.ios;
}
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
if (source == "all")
{
charDataItemShop[XLable].ItemList["yesterShop"].Values = itemDataList.shop;
}
else if (source == "android")
{
charDataItemShop[XLable].ItemList["yesterAndroid"].Values = itemDataList.android;
}
else if (source == "ios")
{
charDataItemShop[XLable].ItemList["yesterIOS"].Values = itemDataList.ios;
}
}
chartData.DataList = charDataItemShop;
break;
//新增会员
case "Reg":
List <string> paramListReg = new List <string>()
{
"newUser", "yesterUser"
};
Dictionary <string, charDataList> charDataItemReg = InitChartData(paramListReg);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
charDataItemReg[XLable].ItemList["newUser"].Values = itemDataList.Reg;
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
charDataItemReg[XLable].ItemList["yesterUser"].Values = itemDataList.Reg;
}
chartData.DataList = charDataItemReg;
break;
//新增商品
case "goods":
List <string> paramListGoods = new List <string>()
{
"newGoods", "yesterGoods"
};
Dictionary <string, charDataList> charDataItemGoods = InitChartData(paramListGoods);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
charDataItemGoods[XLable].ItemList["newGoods"].Values = itemDataList.goods;
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
charDataItemGoods[XLable].ItemList["yesterGoods"].Values = itemDataList.goods;
}
chartData.DataList = charDataItemGoods;
break;
//销售笔数和销售金额
case "Sell":
List <string> paramListSell = new List <string>()
{
"sell", "yesterSell", "sellNum", "yesterSellNum"
};
Dictionary <string, charDataList> charDataItemSell = InitChartData(paramListSell);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
charDataItemSell[XLable].ItemList["sell"].Values = itemDataList.Sell;
charDataItemSell[XLable].ItemList["sellNum"].Values = itemDataList.SellNum;
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
charDataItemSell[XLable].ItemList["yesterSell"].Values = itemDataList.Sell;
charDataItemSell[XLable].ItemList["yesterSellNum"].Values = itemDataList.SellNum;
}
chartData.DataList = charDataItemSell;
break;
//销售商品数
case "saleGoods":
List <string> paramListSaleGoods = new List <string>()
{
"saleGoods", "yesterSaleGoods"
};
Dictionary <string, charDataList> charDataItemSaleGoods = InitChartData(paramListSaleGoods);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
charDataItemSaleGoods[XLable].ItemList["saleGoods"].Values = itemDataList.saleGoods;
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
charDataItemSaleGoods[XLable].ItemList["yesterSaleGoods"].Values = itemDataList.saleGoods;
}
chartData.DataList = charDataItemSaleGoods;
break;
//当日支出
case "Pay":
List <string> paramListPay = new List <string>()
{
"pay", "yesterPay", "payNum", "yesterPayNum"
};
Dictionary <string, charDataList> charDataItemPay = InitChartData(paramListPay);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
charDataItemPay[XLable].ItemList["pay"].Values = itemDataList.Pay;
charDataItemPay[XLable].ItemList["payNum"].Values = itemDataList.PayNum;
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
charDataItemPay[XLable].ItemList["yesterPay"].Values = itemDataList.Pay;
charDataItemPay[XLable].ItemList["yesterPayNum"].Values = itemDataList.PayNum;
}
chartData.DataList = charDataItemPay;
break;
//当日短信
case "Sms":
List <string> paramListSms = new List <string>()
{
"sms", "yesterSms"
};
Dictionary <string, charDataList> charDataItemSms = InitChartData(paramListSms);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
charDataItemSms[XLable].ItemList["sms"].Values = itemDataList.Sms;
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
charDataItemSms[XLable].ItemList["yesterSms"].Values = itemDataList.Sms;
}
chartData.DataList = charDataItemSms;
break;
//当日订单
case "Order":
List <string> paramListOrder = new List <string>()
{
"order", "yesterOrder", "orderNum", "yesterOrderNum"
};
Dictionary <string, charDataList> charDataItemOrder = InitChartData(paramListOrder);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
charDataItemOrder[XLable].ItemList["order"].Values = itemDataList.Order;
charDataItemOrder[XLable].ItemList["orderNum"].Values = itemDataList.OrderNum;
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
charDataItemOrder[XLable].ItemList["yesterOrder"].Values = itemDataList.Order;
charDataItemOrder[XLable].ItemList["yesterOrderNum"].Values = itemDataList.OrderNum;
}
chartData.DataList = charDataItemOrder;
break;
//客户端登录
case "kehuduan":
List <string> paramListClient = new List <string>()
{
"client", "yesterClient"
};
Dictionary <string, charDataList> charDataItemClient = InitChartData(paramListClient);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
charDataItemClient[XLable].ItemList["client"].Values = itemDataList.kehuduan;
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
charDataItemClient[XLable].ItemList["yesterClient"].Values = itemDataList.kehuduan;
}
chartData.DataList = charDataItemClient;
break;
//登录
case "loginNum":
List <string> paramListLogNum = new List <string>()
{
"logNum", "yesterLogNum"
};
Dictionary <string, charDataList> charDataItemLogNum = InitChartData(paramListLogNum);
foreach (dynamic itemDataList in list)
{
var XLable = itemDataList.Period.ToString();
charDataItemLogNum[XLable].ItemList["logNum"].Values = itemDataList.loginNum;
}
foreach (dynamic itemDataList in listYesterday)
{
var XLable = itemDataList.Period.ToString();
charDataItemLogNum[XLable].ItemList["yesterLogNum"].Values = itemDataList.loginNum;
}
chartData.DataList = charDataItemLogNum;
break;
}
}
return(chartData);
}
/// <summary>
/// 返回昨日此时数据
/// </summary>
/// <returns></returns>
public static PanelShowModel.SomedayDataCount GetYesterdayPeerData()
{
SysRpt_WebDayInfoDAL dal = new SysRpt_WebDayInfoDAL();
return(dal.GetYesterdayPeerData());
}
/// <summary>
/// 得到某日此时的数据
/// </summary>
/// <param name="webDate"></param>
/// <returns></returns>
public static PanelShowModel.SomedayDataCount GetThisMomentData(DateTime webDate)
{
SysRpt_WebDayInfoDAL dal = new SysRpt_WebDayInfoDAL();
return(dal.GetThisMomentData(webDate));
}
/// <summary>
/// 得到当前系统今天的统计信息
/// </summary>
/// <param name="type">{新增店铺 "shop",新增会员 "Reg",新增商品 "goods",销售笔数和销售金额 "Sell",销售商品数 "saleGoods",当日支出 "Pay",当日短信 "Sms",当日订单 "Order",客户端登录 "kehuduan",登录 "loginNum"}</param>
/// <returns></returns>
public static List <dynamic> GetIndexNowData(string type, DateTime nowDay)
{
SysRpt_WebDayInfoDAL dal = new SysRpt_WebDayInfoDAL();
return(dal.GetIndexNowData(type, nowDay));
}
