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