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 List <WGJG01Model> GetWageListDataByUnit(WGJG01ChartModel model)
{
if (string.IsNullOrEmpty(model.unitID))
{
return(null);
}
return(DBSession.IWGJG01DAL.GetWageListDataByUnit(model));
}
public int CountGrantPersons(WGJG01ChartModel model)
{
if (!string.IsNullOrEmpty(model.rowID))
{
if (!string.IsNullOrEmpty(model.keyword))
{
return(SelectCount(s => s.WGJG01RowID == model.rowID && s.A0101.Contains(model.keyword)));
}
return(SelectCount(s => s.WGJG01RowID == model.rowID));
}
StringBuilder sb = new StringBuilder();
sb.Append(string.Format("SELECT COUNT(*) FROM dbo.WGJG02 WHERE PersonID IN (SELECT PersonID FROM dbo.A01) AND WGJG01RowID IN(SELECT RowID FROM dbo.WGJG01 WHERE UnitID LIKE '{0}%' ", model.unitID));
if (!string.IsNullOrEmpty(model.dateStart) && !string.IsNullOrEmpty(model.dateEnd))
{
sb.Append(string.Format(" AND WGJG0102 BETWEEN '{0}' AND '{1}' ", model.dateStart, model.dateEnd));
}
else if (!string.IsNullOrEmpty(model.dateStart))
{
sb.Append(string.Format(" AND WGJG0102>='{0}' ", model.dateStart));
}
else if (!string.IsNullOrEmpty(model.dateEnd))
{
sb.Append(string.Format(" AND WGJG0102<='{0}' ", model.dateEnd));
}
if (!string.IsNullOrEmpty(model.keyword))
{
sb.Append(string.Format(" AND A0101 LIKE '%{0}%' ", model.keyword));
}
if (!string.IsNullOrEmpty(model.isGive) && model.isGive.Equals("1"))
{
sb.Append(" AND WGJG0211='1' ");
}
else if (!string.IsNullOrEmpty(model.isGive))
{
sb.Append(" AND ISNULL(WGJG0211,'')<>'1' ");
}
sb.Append(")");
return(Helper.ToInt(SqlHelper.ExecuteScalar(sb.ToString(), CommandType.Text)));
}
public int CountGrantPersons(WGJG01ChartModel model)
{
return(DBSession.IWGJG02DAL.CountGrantPersons(model));
}
