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