/// <summary> /// 获取欠薪时间数据 /// </summary> /// <returns></returns> public EchartsVo GetDebtTimeData(string unitCode, int keyChild) { List <P_QianXin_ShiJian_Result> list = base.DBSession.IView_QXTJDAL.GetViewTimeData(unitCode, keyChild); if (list.Count <= 0) { return(null); } EchartsVo dTime = new EchartsVo(); List <Series> seriesList = new List <Series>(); List <decimal?> detTime = new List <decimal?>();//欠薪人数 foreach (P_QianXin_ShiJian_Result vq in list) { detTime.Add(vq.renshu); } seriesList.Add( new Series() { name = "欠薪人数", type = "bar", data = detTime }); dTime.seriesList = seriesList; return(dTime); }
public EchartsVo GetChartData(WGJG01ChartModel model) { List <WGJG01Model> list = DBSession.IWGJG01DAL.GetWageListDataByUnit(model); if (list.Count <= 0) { return(null); } EchartsVo dChart = new EchartsVo(); List <Series> seriesList = new List <Series>(); List <decimal?> aMoney = new List <decimal?>(); decimal monry = Math.Round(list.Sum(s => s.allMoney) / 10000, 2); aMoney.Add(monry); //应该总金额 monry = Math.Round(list.Sum(s => s.sureMoney) / 10000, 2); aMoney.Add(monry); //已发总金额 monry = Math.Round(list.Sum(s => s.payMoney) / 10000, 2); aMoney.Add(monry); //欠薪总金额 seriesList.Add( new Series() { name = "金额", type = "bar", data = aMoney }); dChart.seriesList = seriesList; return(dChart); }
public EchartsVo GetMonthChartData(HCQ2_Model.SelectModel.A02Model model) { if (model == null || string.IsNullOrEmpty(model.unitID)) { return(null); } List <A02Model> list = DBSession.IA02DAL.SelectA02CheckByMonthData(model); if (list == null || list.Count <= 0) { return(null); } EchartsVo dChart = new EchartsVo(); List <Series> seriesList = new List <Series>(); //数据集合 List <string> xAxis = new List <string>(); //x轴数据 List <decimal?> aPersons = new List <decimal?>(); foreach (A02Model item in list) { xAxis.Add(item.cardDate); aPersons.Add(item.countPersons); } seriesList.Add( new Series() { name = "打卡人数", type = "bar", data = aPersons }); dChart.xAxis = xAxis; dChart.seriesList = seriesList; return(dChart); }
/// <summary> /// 获取欠薪金额数据 首页统计前7条记录 /// </summary> /// <returns></returns> public ActionResult GetMoneyDataBySelUnit() { string json = RequestHelper.GetStrByName("selUnit"); EchartsVo dm = operateContext.bllSession.View_QXTJ.GetDebtMoneyData(json); return(operateContext.RedirectAjax(0, "", dm, null)); }
public ActionResult GetDebtTimeData() { //string unitID = "011002"; string unitID = Helper.ToString(Request["unitID"]); int keyChild = Helper.ToInt(Request["keyChild"]); EchartsVo dm = base.operateContext.bllSession.View_QXTJ.GetDebtTimeData(unitID, keyChild); return(operateContext.RedirectAjax(0, "", dm, null)); }
public ActionResult GetChartDataByUnit(FormCollection form) { string unitID = Helper.ToString(form["unitID"]); string dateStart = Helper.ToString(form["dateStart"]); string dateEnd = Helper.ToString(form["dateEnd"]); EchartsVo Ev = operateContext.bllSession.A02.GetMonthChartData(new HCQ2_Model.SelectModel.A02Model() { unitID = unitID, dateStart = dateStart, dateEnd = dateEnd }); return(operateContext.RedirectAjax(0, "", Ev, null)); }
public ActionResult GetCountGrantData(FormCollection form) { string rowID = Helper.ToString(form["rowID"]); string unitID = Helper.ToString(form["unitID"]); string dateStart = Helper.ToString(form["dateStart"]); string dateEnd = Helper.ToString(form["dateEnd"]); EchartsVo vo = operateContext.bllSession.WGJG01.GetChartData(new HCQ2_Model.SelectModel.WGJG01ChartModel() { rowID = rowID, unitID = unitID, dateStart = dateStart, dateEnd = dateEnd, isAll = true }); return(operateContext.RedirectAjax(0, "", vo, null)); }
/// <summary> /// 获取欠薪人数 /// </summary> /// <returns></returns> public EchartsVo GetDebtPerson() { List <View_QXTJ> list = GetDebtPersonByPermissTopSeren(); if (list.Count <= 0) { return(null); } EchartsVo dPerson = new EchartsVo(); dPerson.legend = new List <string>("总人数,欠薪人数".Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries)); //X轴 List <string> xAxis = new List <string>(); List <Series> seriesList = new List <Series>(); List <decimal?> detAllCount = new List <decimal?>(); //总人数 List <decimal?> detPerson = new List <decimal?>(); //欠薪人数 foreach (View_QXTJ vq in list) { xAxis.Add(vq.B0001Name); detAllCount.Add(vq.People2); detPerson.Add(vq.People); } seriesList.Add( new Series() { name = "总人数", type = "bar", data = detAllCount }); seriesList.Add( new Series() { name = "欠薪人数", type = "bar", data = detPerson }); dPerson.xAxis = xAxis; dPerson.seriesList = seriesList; return(dPerson); }
private EchartsVo GetEchartsData(List <View_QXTJ> list) { EchartsVo dMoney = new EchartsVo(); dMoney.legend = new List <string>("保障金额,欠薪金额".Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries)); //X轴 List <string> xAxis = new List <string>(); List <Series> seriesList = new List <Series>(); List <decimal?> detMoney = new List <decimal?>(); //欠薪金额 List <decimal?> bzMoney = new List <decimal?>(); //保证金额 foreach (View_QXTJ vq in list) { xAxis.Add(vq.B0001Name); detMoney.Add(vq.QXTJ01); bzMoney.Add(vq.B0116); } seriesList.Add( new Series() { name = "保证金额", type = "bar", data = bzMoney }); seriesList.Add( new Series() { name = "欠薪金额", type = "bar", data = detMoney }); dMoney.xAxis = xAxis; dMoney.seriesList = seriesList; return(dMoney); }
/// <summary> /// 获取欠薪金额数据 首页统计前7条记录 /// </summary> /// <returns></returns> public ActionResult GetMoneyData() { EchartsVo dm = base.operateContext.bllSession.View_QXTJ.GetDebtData(); return(operateContext.RedirectAjax(0, "", dm, null)); }