public ActionResult ExportSaleRanking(string day = "", int year = 0, int month = 0, int weekIndex = 0)
{
#region 获取查询结果
var result = new List <SalesExportModel>();
var SaleCountmodel = new LineChartDataModel <int>();
var Salesmodel = new LineChartDataModel <int>();
var Title = string.Empty;
if (!string.IsNullOrWhiteSpace(day))
{
DateTime date = DateTime.Parse(day);
SaleCountmodel = StatisticApplication.GetProductSaleRankingChart(0, date, date, SaleDimension.Count, 15);
Salesmodel = StatisticApplication.GetProductSaleRankingChart(0, date, date, SaleDimension.Amount, 15);
Title = "按天统计：" + day;
}
else
{
if (year == 0)
{
year = DateTime.Now.Year;
}
if (month == 0)
{
month = DateTime.Now.Month;
}
if (weekIndex == 0)
{
Title = "按月统计：" + year + "年" + month + "月";
}
else
{
Title = "按周统计：" + year + "年" + month + "月 第" + weekIndex + "周";
}
SaleCountmodel = StatisticApplication.GetProductSaleRankingChart(0, year, month, weekIndex, SaleDimension.Count, 15);
Salesmodel = StatisticApplication.GetProductSaleRankingChart(0, year, month, weekIndex, SaleDimension.Amount, 15);
}
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;
ViewData.Add("Title", Title);
string viewHtml = RenderPartialViewToString(this, "ExportSaleRanking");
return(File(System.Text.Encoding.UTF8.GetBytes(viewHtml), "application/ms-excel", string.Format("销量分析_{0}.xls", DateTime.Now.ToString("yyyy-MM-dd"))));
#endregion
}
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
}
