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