/// <summary>
/// 返回每月汇总增长数据
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public List <dynamic> GetMonthlyData(DateTime dt)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(
"declare @acc int;" +
"select @acc=count(Id) from i200.dbo.T_Account where DATEDIFF(month,@month,regTime)=0 and state=1;" +
"select @acc as Account,ISNULL(SUM(saleNum),0) as Sale,ISNULL(SUM(userNum),0) as Usr,ISNULL(SUM(addGoodsNum),0) as Goods,ISNULL(SUM(smsNum),0) as Sms,ISNULL(SUM(orderNum),0) as Ord,ISNULL(sum(orderMoney),0) as ordMon " +
"from SysRpt_WebDayInfo where DATEDIFF(year,@year,S_Date)=0 and DATEDIFF(month,@month,S_Date)=0");
List <dynamic> list =
DapperHelper.Query <dynamic>(strSql.ToString(), new { year = dt, month = dt }).ToList();
if (DateTime.Now.Month == dt.Month)
{
PanelShowModel.SomedayDataCount tData = GetNowData();
//list[0].Account += tData.regNum;
list[0].Sale += tData.saleNum;
list[0].Usr += tData.userNum;
list[0].Goods += tData.goodsNum;
list[0].Sms += tData.smsNum;
list[0].ordMon += tData.orderMoney;
}
return(list);
}
/// <summary>
/// 返回KPI数据和区分用户活跃类型后的数据
/// </summary>
/// <param name="nowDay"></param>
/// <returns></returns>
public static string GetStatusType(DateTime nowDay)
{
List <DashBoardModel> modelList = DashBoardAnalyzeBLL.GetStatusType(nowDay);
PanelShowModel.SomedayDataCount todayModel = SysRpt_WebDayInfoBLL.GetNowDataCount();
foreach (DashBoardModel model in modelList)
{
switch (model.Name)
{
case "销售笔数":
model.Total = todayModel.saleNum;
break;
case "会员数量":
model.Total = todayModel.userNum;
break;
case "商品数量":
model.Total = todayModel.goodsNum;
break;
case "短信数量":
model.Total = todayModel.smsNum;
break;
}
}
return(CommonLib.Helper.JsonSerializeObject(modelList));
}
/// <summary>
/// 返回今日昨日此时数据对比
/// </summary>
/// <returns></returns>
public static string GetYesterdayNowData()
{
PanelShowModel.SomedayDataCount todayModel = SysRpt_WebDayInfoBLL.GetNowDataCount();
PanelShowModel.SomedayDataCount yestaredayModel = SysRpt_WebDayInfoBLL.GetYesterdayPeerData();
Dictionary <string, object> list = new Dictionary <string, object>();
list["today"] = todayModel;
list["yestareday"] = yestaredayModel;
return(CommonLib.Helper.JsonSerializeObject(list));
}
/// <summary>
/// 今天昨天对比更多
/// </summary>
/// <returns></returns>
public static Dictionary <string, object> GetTodayYesterdayContrastMore()
{
//得到昨天此时数据
PanelShowModel.SomedayDataCount yestaredayModel = SysRpt_WebDayInfoBLL.GetYesterdayPeerData();
PanelShowModel.SomedayDataCount activ = SysRpt_WebDayInfoBLL.GetAverageData(DateTime.Now.AddDays(-30), DateTime.Now);
yestaredayModel.nowTimeString = "昨日此时";
activ.nowTimeString = "近30日平均";
Dictionary <string, object> list = new Dictionary <string, object>();
list["yestareday"] = yestaredayModel;
list["average"] = activ;
return(list);
}
public static string GetAllData()
{
PanelShowModel.SomedayDataCount allData = new PanelShowModel.SomedayDataCount();
dynamic all = SysRpt_WebDayInfoBLL.GetAllData();
allData.nowTime = DateTime.Now;
allData.regNum = Convert.ToInt32(all.Account);
allData.saleNum = Convert.ToInt32(all.Sale);
allData.userNum = Convert.ToInt32(all.Usr);
allData.goodsNum = Convert.ToInt32(all.Goods);
allData.smsNum = Convert.ToInt32(all.Sms);
allData.orderNum = Convert.ToInt32(all.Ord);
allData.orderMoney = Convert.ToDecimal(all.ordMon);
return(CommonLib.Helper.JsonSerializeObject(allData));
}
/// <summary>
/// 今天昨天数据对比
/// </summary>
/// <returns></returns>
public static Dictionary <string, object> GetTodayYesterdayContrast()
{
//得到今日数据
PanelShowModel.SomedayDataCount todayModel = SysRpt_WebDayInfoBLL.GetNowDataCount();
//得到昨天数据
PanelShowModel.SomedayDataCount yestaredayModel = SysRpt_WebDayInfoBLL.GetModelByDate(DateTime.Now.AddDays(-1));
if (yestaredayModel == null)
{
yestaredayModel = new PanelShowModel.SomedayDataCount(DateTime.Now.AddDays(-1));
}
if (todayModel == null)
{
todayModel = new PanelShowModel.SomedayDataCount(DateTime.Now);
}
todayModel.nowTimeString = "今天";
yestaredayModel.nowTimeString = "昨天";
Dictionary <string, object> list = new Dictionary <string, object>();
list["today"] = todayModel;
list["yestareday"] = yestaredayModel;
return(list);
}
/// <summary>
/// 得到当前数据的汇总
/// </summary>
/// <param name="type"></param>
/// <param name="nowDay"></param>
/// <returns></returns>
public static PanelShowModel.SomedayDataCount GetNowDataCount()
{
DateTime insertDate = DateTime.Now;
PanelShowModel.SomedayDataCount todayModel = new PanelShowModel.SomedayDataCount();
todayModel.nowTime = DateTime.Now.Date;
//新注册
todayModel.regNum = 0;
List <dynamic> shopList = SysRpt_WebDayInfoBLL.GetIndexNowData("shop", insertDate);
foreach (dynamic item in shopList)
{
todayModel.regNum += Convert.ToInt32(item.shop);
}
//销售笔
todayModel.saleNum = 0;
todayModel.saleMoney = 0;
List <dynamic> saleList = SysRpt_WebDayInfoBLL.GetIndexNowData("Sell", insertDate);
foreach (dynamic item in saleList)
{
todayModel.saleNum += Convert.ToInt32(item.Sell);
todayModel.saleMoney += Convert.ToDecimal(item.SellNum);
}
//新增会员
todayModel.userNum = 0;
List <dynamic> userList = SysRpt_WebDayInfoBLL.GetIndexNowData("Reg", insertDate);
foreach (dynamic item in userList)
{
todayModel.userNum += Convert.ToInt32(item.Reg);
}
//新增加商品
todayModel.goodsNum = 0;
List <dynamic> goodsList = SysRpt_WebDayInfoBLL.GetIndexNowData("goods", insertDate);
foreach (dynamic item in goodsList)
{
todayModel.goodsNum += Convert.ToInt32(item.goods);
}
//短信数
todayModel.smsNum = 0;
List <dynamic> smsList = SysRpt_WebDayInfoBLL.GetIndexNowData("Sms", insertDate);
foreach (dynamic item in smsList)
{
todayModel.smsNum += Convert.ToInt32(item.Sms);
}
//订单数
todayModel.orderNum = 0;
todayModel.orderMoney = 0;
List <dynamic> orderList = SysRpt_WebDayInfoBLL.GetIndexNowData("Order", insertDate);
foreach (dynamic item in orderList)
{
todayModel.orderNum += Convert.ToInt32(item.Order);
todayModel.orderMoney += Convert.ToDecimal(item.OrderNum);
}
return(todayModel);
}
