/// <summary> /// 预约进度表 /// </summary> /// <param name="page"></param> /// <param name="dwbh"></param> /// <param name="pqstart"></param> /// <param name="pqend"></param> /// <returns></returns> public ActionResult YyJdb(int page = 1, string dwbh = "", string pqstart = "", string pqend = "") { ReportQyService rs = new ReportQyService(); ViewBag.jsyrs = rs.GetHomejryrs(GLYadmin.YYID, 1); //首页今日预约人数 List <string> jsList = rs.GetHometjzryyjd(GLYadmin.YYID); //今日预约总进度 ViewBag.jsyyzjd = jsList[0]; ViewBag.jsyyzjdsz = jsList[1]; //今日到检总进度 List <string> jsDjList = rs.GetHometjdjzjd(GLYadmin.YYID); ViewBag.jsDjzjd = jsDjList[0]; ViewBag.jsDjzjdsz = jsDjList[1]; QyyyService qs = new QyyyService(); int count = 0; List <QyyyModel> list = qs.GetQyygjbxxList(GLYadmin.YYID, dwbh, pqstart, pqend, page, PageSize, ref count); int recordCount = count; //总记录数 ViewBag.Pager = PagingNewHelper.ShowFPageForBootstrapAdmin(page, PageSize, count); //生成分页条 if (Request.IsAjaxRequest()) { return(PartialView("YyJdbPart", list)); } else { List <KeyValueModel> liQy = new QyjbxxService().GetqyList(GLYadmin.YYID); ViewBag.QyList = liQy; } return(View(list)); }
public ActionResult QyJs(int page = 1, string dwbh = "", string pqstart = "", string pqend = "") { QyyyService qs = new QyyyService(); int count = 0; List <QyyyModel> list = qs.GetQyygjbxxList(GLYadmin.YYID, dwbh, pqstart, pqend, page, PageSize, ref count); int recordCount = count; //总记录数 ViewBag.Pager = PagingNewHelper.ShowFPageForBootstrapAdmin(page, PageSize, count); //生成分页条 if (Request.IsAjaxRequest()) { return(PartialView("QyJsPart", list)); } else { List <KeyValueModel> liQy = new QyjbxxService().GetqyList(GLYadmin.YYID); ViewBag.QyList = liQy; } return(View(list)); }
/// <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)); }