/// <summary>
/// 饼图
/// </summary>
/// <returns></returns>
public string GetSalesTrendsPieData()
{
var qdlist = new QyjbxxService().GetqyqdList(GLYadmin.YYID);
var list = new DdJbxxService().GetSalesScale(GLYadmin.YYID);
var seriesData = new List <object>();
var totalNum = Math.Round(list.Sum(x => x.money), 2);
foreach (var item in qdlist)
{
var qdData = list.Count > 0 ? (list.Where(x => x.qdid == item.key).Count() > 0? list.First(x => x.qdid == item.key) : null) : null;
var name = item.values;
var value = qdData == null ? 0 : qdData.money;
var per = totalNum == 0 ? "100%" : (value / totalNum).ToString("0.##%");
seriesData.Add(new { name = name, value = value, per = per });
}
var legendData = qdlist.Select(x => x.key);
var color = "red";
return(JsonConvert.SerializeObject(new { legendData = legendData, seriesData = seriesData, color = color }));
}
public string GetSalesTrendsBarData()
{
var qdlist = new QyjbxxService().GetqyqdList(GLYadmin.YYID);
var list = new DdJbxxService().GetSalesTrends(GLYadmin.YYID);
var monthList = new List <int>();
var now = DateTime.Now;
for (int i = -11; i <= 0; i++)
{
monthList.Add(now.AddMonths(i).Month);
}
var months = monthList.Select(x => x.ToString() + "月");
var series = new List <object>();
foreach (var item in qdlist)
{
var name = item.values;
var type = "bar";
var color = "#58afff";
var stack = "abc";
var data = new List <decimal>();
var qdData = list.Where(x => x.qdid == item.key);
foreach (var month in monthList)
{
var monthData = qdData.FirstOrDefault(x => x.month == month);
data.Add(monthData == null ? 0 : Convert.ToDecimal(monthData.money.ToString("0.#")));
}
series.Add(new { name = name, type = type, color = color, stack = stack, data = data });
}
var value = new { xAxisData = months, series = series };
return(JsonConvert.SerializeObject(value));
}
