public JsonResult GetAreaMapBySearch(int dimension, int year = 0, int month = 0)
{
if (year == 0)
{
year = DateTime.Now.Year;
}
if (month == 0)
{
month = DateTime.Now.Month;
}
var data = StatisticApplication.GetAreaOrderChart((OrderDimension)dimension, year, month);
return(Json(new { successful = true, chart = data }, JsonRequestBehavior.AllowGet));
}
public ActionResult ExportAreaMap(int year = 0, int month = 0, DateTime?begin = null, DateTime?end = null)
{
MapChartDataModel <decimal> orderCounts = new MapChartDataModel <decimal>();
MapChartDataModel <decimal> orderAmounts = new MapChartDataModel <decimal>();
var title = string.Empty;
if (begin.HasValue && end.HasValue)
{
orderCounts = StatisticApplication.GetAreaOrderChart(SaleDimension.Count, begin.Value, end.Value);
orderAmounts = StatisticApplication.GetAreaOrderChart(SaleDimension.Amount, begin.Value, end.Value);
title = string.Format("区域统计_{0}至{1}", begin.Value.ToString("yyyy-MM-dd"), end.Value.ToString("yyyy-MM-dd"));
}
else
{
if (year == 0)
{
year = DateTime.Now.Year;
}
if (month == 0)
{
month = DateTime.Now.Month;
}
orderCounts = StatisticApplication.GetAreaOrderChart(SaleDimension.Count, year, month);
orderAmounts = StatisticApplication.GetAreaOrderChart(SaleDimension.Amount, year, month);
title = string.Format("区域统计_{0}年{1}月", year, month);
}
var list = new List <AreaMapExportSubModel>();
for (int i = 0; i < orderCounts.Data.Count; i++)
{
list.Add(new AreaMapExportSubModel
{
RegionName = orderCounts.Data[i].Name,
OrderCount = (int)orderCounts.Data[i].Value,
OrderAmount = orderAmounts.Data[i].Value
});
}
ViewData.Model = list;
ViewData.Add("Title", title);
string viewHtml = RenderPartialViewToString(this, "ExportAreaMap");
return(File(System.Text.Encoding.UTF8.GetBytes(viewHtml), "application/ms-excel", title + ".xls"));
}
public JsonResult GetAreaMapBySearch(SaleDimension dimension, int year = 0, int month = 0, DateTime?begin = null, DateTime?end = null)
{
if (begin.HasValue && end.HasValue)
{
end = end.Value.AddDays(1);
var data = StatisticApplication.GetAreaOrderChart(dimension, begin.Value, end.Value);
return(Json(new { success = true, chart = data }, true));
}
else
{
if (year == 0)
{
year = DateTime.Now.Year;
}
if (month == 0)
{
month = DateTime.Now.Month;
}
var data = StatisticApplication.GetAreaOrderChart(dimension, year, month);
return(Json(new { success = true, chart = data }, true));
}
}