/// <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> /// <param name="dt"></param> /// <returns></returns> public static string GetMonthlyData(DateTime dt) { List <dynamic> list = SysRpt_WebDayInfoBLL.GetMonthlyData(dt); List <MonthlyKPI> listPreset = Sys_PresetKPIBLL.GetList(1, true, dt); List <KPICompareModel> modelList = new List <KPICompareModel>(); if (list != null && list.Count > 0 && listPreset != null && listPreset.Count > 0) { modelList.Add(new KPICompareModel("注册量", Convert.ToInt32(list[0].Account), listPreset[0].RegNum, (Convert.ToInt32(list[0].Account) * 100 / listPreset[0].RegNum).ToString("#0.00"))); modelList.Add(new KPICompareModel("销售笔数", Convert.ToInt32(list[0].Sale), listPreset[0].SellCount, (Convert.ToInt32(list[0].Sale) * 100 / listPreset[0].SellCount).ToString("#0.00"))); modelList.Add(new KPICompareModel("新增会员", Convert.ToInt32(list[0].Usr), listPreset[0].UsrAdd, (Convert.ToInt32(list[0].Usr) * 100 / listPreset[0].UsrAdd).ToString("#0.00"))); modelList.Add(new KPICompareModel("新增商品", Convert.ToInt32(list[0].Goods), listPreset[0].Sku, (Convert.ToInt32(list[0].Goods) * 100 / listPreset[0].Sku).ToString("#0.00"))); modelList.Add(new KPICompareModel("短信量", Convert.ToInt32(list[0].Sms), listPreset[0].Sms, (Convert.ToInt32(list[0].Sms) * 100 / listPreset[0].Sms).ToString("#0.00"))); //modelList.Add(new KPICompareModel("订单笔数", Convert.ToInt32(list[0].Ord), listPreset[0].OrderCount, //(Convert.ToInt32(list[0].Ord) * 100 / listPreset[0].OrderCount).ToString("#0.00"))); modelList.Add(new KPICompareModel("订单金额", Convert.ToInt32(list[0].ordMon), listPreset[0].OrderCount, (Convert.ToInt32(list[0].ordMon) * 100 / listPreset[0].OrderCount).ToString("#0.00"))); } return(CommonLib.Helper.JsonSerializeObject(modelList)); }
/// <summary> /// 获取每日和前日的对比数据 /// </summary> /// <param name="type"></param> /// <param name="day"></param> /// <returns></returns> public static string getTableData(string type, DateTime day, string source) { chartDataModel model = SysRpt_WebDayInfoBLL.GetDailyGraph(type, day, source); string jsData = CommonLib.Helper.JsonSerializeObject(model); return(jsData); }
/// <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); }