public JsonResult GetSaleRankingChart(string day = "", int year = 0, int month = 0, int weekIndex = 0, int dimension = 1) { Model.LineChartDataModel <int> model = new Model.LineChartDataModel <int>(); DateTime start; if (!string.IsNullOrWhiteSpace(day)) { if (!DateTime.TryParse(day, out start)) { start = DateTime.Now; } model = _iStatisticsService.GetSaleRankingChart(start, (SaleDimension)dimension); } else { if (year == 0) { year = DateTime.Now.Year; } if (month == 0) { month = DateTime.Now.Month; } if (weekIndex == 0) { model = _iStatisticsService.GetSaleRankingChart(year, month, (SaleDimension)dimension); } else { model = _iStatisticsService.GetSaleRankingChart(year, month, weekIndex, (SaleDimension)dimension); } } return(Json(new { successful = true, chart = model }, JsonRequestBehavior.AllowGet)); }
public JsonResult ProductVisitRankingChart(string day = "", int year = 0, int month = 0, int weekIndex = 0) { Model.LineChartDataModel <int> model = new Model.LineChartDataModel <int>(); DateTime start; if (!string.IsNullOrWhiteSpace(day)) { if (!DateTime.TryParse(day, out start)) { start = DateTime.Now; } model = _iStatisticsService.GetProductVisitRankingChart(CurrentSellerManager.ShopId, start); } else { if (year == 0) { year = DateTime.Now.Year; } if (month == 0) { month = DateTime.Now.Month; } if (weekIndex == 0) { model = _iStatisticsService.GetProductVisitRankingChart(CurrentSellerManager.ShopId, year, month); } else { model = _iStatisticsService.GetProductVisitRankingChart(CurrentSellerManager.ShopId, year, month, weekIndex, 15); } } return(Json(new { successful = true, chart = model }, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportSaleRanking(string day = "", int year = 0, int month = 0, int weekIndex = 0) { #region 获取查询结果 List <SalesExportModel> result = new List <SalesExportModel>(); Model.LineChartDataModel <int> SaleCountmodel = new Model.LineChartDataModel <int>(); Model.LineChartDataModel <int> Salesmodel = new Model.LineChartDataModel <int>(); string Title = ""; DateTime start; if (!string.IsNullOrWhiteSpace(day)) { if (!DateTime.TryParse(day, out start)) { start = DateTime.Now; } SaleCountmodel = _iStatisticsService.GetSaleRankingChart(start, SaleDimension.SaleCount); Salesmodel = _iStatisticsService.GetSaleRankingChart(start, SaleDimension.Sales); Title = "按天统计:" + day; } else { if (year == 0) { year = DateTime.Now.Year; } if (month == 0) { month = DateTime.Now.Month; } if (weekIndex == 0) { SaleCountmodel = _iStatisticsService.GetSaleRankingChart(year, month, SaleDimension.SaleCount); Salesmodel = _iStatisticsService.GetSaleRankingChart(year, month, SaleDimension.Sales); Title = "按月统计:" + year + "年" + month + "月"; } else { SaleCountmodel = _iStatisticsService.GetSaleRankingChart(year, month, weekIndex, SaleDimension.SaleCount); Salesmodel = _iStatisticsService.GetSaleRankingChart(year, month, weekIndex, SaleDimension.Sales); Title = "按周统计:" + year + "年" + month + "月 第" + weekIndex + "周"; } } for (int i = 0; i < SaleCountmodel.ExpandProp.Length; i++) { SalesExportModel model = new SalesExportModel(); if (!string.IsNullOrEmpty(SaleCountmodel.ExpandProp[i])) { model.ProductName = SaleCountmodel.ExpandProp[i]; model.SaleCount = SaleCountmodel.SeriesData[0].Data[i]; model.SaleAmount = Salesmodel.SeriesData[0].Data[i]; result.Add(model); } } #endregion #region 构建EXCEL ViewData.Model = result; //ViewBag.Title = Title; ViewData.Add("Title", Title); string viewHtml = RenderPartialViewToString(this, "ExportSaleRanking"); return(File(System.Text.UTF8Encoding.Default.GetBytes(viewHtml), "application/ms-excel", string.Format("销量分析_{0}.xls", DateTime.Now.ToString("yyyy-MM-dd")))); #endregion }