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