/// <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)); }