/// <summary> /// 获取欠薪金额趋势数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <DebtMoneyModel> GetPayMoneyByDate(DebtChartByYearModel model) { if (null == model) { return(null); } return(DBSession.IWGJG02DAL.GetPayMoneyByDate(model)); }
/// <summary> /// 获取欠薪人数趋势 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <DebtPersonsModel> GetPayCountPerson(DebtChartByYearModel model) { if (null == model) { return(null); } return(DBSession.IWGJG02DAL.GetPayCountPerson(model)); }
/// <summary> /// 获取欠薪人数趋势 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <DebtPersonsModel> GetPayCountPerson(DebtChartByYearModel model) { sb?.Clear(); sb.Append(string.Format(@"SELECT TT.month,TT.number FROM (SELECT T.month,COUNT(T.month) AS number FROM (SELECT CAST(MONTH(WGJG0202) AS INT) AS month FROM dbo.WGJG02 WHERE ISNULL(WGJG0211,'2')='2' AND ISNULL(dbo.WGJG02.WGJG0202,'')<>'' AND YEAR(WGJG0202)=@year)T GROUP BY T.month)TT WHERE TT.number>0;")); _param?.Clear(); _param.Add("@year", model.year); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <DebtPersonsModel>(dt)); }
/// <summary> /// 获取欠薪金额趋势数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <DebtMoneyModel> GetPayMoneyByDate(DebtChartByYearModel model) { sb?.Clear(); sb.Append(string.Format(@"SELECT T.month,T.money FROM (SELECT wg.month,CONVERT(DECIMAL(18,2),(SUM(ISNULL(WGJG0207,0))-SUM(ISNULL(WGJG0208,0)))/10000) AS money FROM (SELECT CAST(MONTH(WGJG0202) AS INT) AS month,ISNULL(WGJG0207,0) AS WGJG0207, WGJG0208=(CASE WHEN ISNULL(WGJG0211,'2')='2' THEN 0 ELSE ISNULL(WGJG0208,0) END) FROM dbo.WGJG02 WHERE ISNULL(WGJG0211,'2') IN('1','2') AND YEAR(WGJG0202)=@year)wg GROUP BY wg.month)T WHERE T.money>0 ORDER BY T.month ASC;" )); _param?.Clear(); _param.Add("@year", model.year); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <DebtMoneyModel>(dt)); }
public object GetDebtPersons(DebtChartByYearModel model) { if (!ModelState.IsValid) { return(operateContext.RedirectWebApi(WebResultCode.Exception, GlobalConstant.参数异常.ToString(), false)); } List <DebtPersonsModel> uModel = operateContext.bllSession.WGJG02.GetPayCountPerson(model); if (null == uModel || uModel.Count <= 0) { return(operateContext.RedirectWebApi(WebResultCode.Ok, GlobalConstant.数据为空.ToString(), null)); } return(operateContext.RedirectWebApi(WebResultCode.Ok, GlobalConstant.操作成功.ToString(), uModel)); }