/// <summary>
/// 工资下发
/// </summary>
/// <param name="person"></param>
/// <returns></returns>
public List <WageDetialResult> GetWageDetialByPerson(WageGrantParamModel person)
{
if (null == person)
{
return(null);
}
return(DBSession.IWGJG02DAL.GetWageDetialByPerson(person));
}
public object GetWageDetail(WageGrantParamModel person)
{
if (!ModelState.IsValid)
{
return(operateContext.RedirectWebApi(WebResultCode.Exception, GlobalConstant.参数异常.ToString(), null));
}
List <WageDetialResult> list = operateContext.bllSession.WGJG02.GetWageDetialByPerson(person);
if (null == list || list.Count <= 0)
{
return(operateContext.RedirectWebApi(WebResultCode.Error, GlobalConstant.数据获取失败.ToString(), ""));
}
return(operateContext.RedirectWebApi(WebResultCode.Ok, GlobalConstant.数据获取成功.ToString(), list));
}
/// <summary>
/// 工资下发
/// </summary>
/// <param name="person"></param>
/// <returns></returns>
public List <WageDetialResult> GetWageDetialByPerson(WageGrantParamModel person)
{
if (null == person)
{
return(null);
}
sb?.Clear();
sb.Append(string.Format(@"SELECT c1.WGJG0203,ISNULL(w1.WGJG0204,0) AS WGJG0204,w1.WGJG0501,w1.WGJG0502,ISNULL(w1.WGJG0207,0) AS WGJG0207,ISNULL(w1.WGJG0208,0) AS WGJG0208,w1.WGJG0202 FROM
(SELECT TOP 1 WGJG0203,WGJG0204,WGJG0501=0.00,WGJG0502=0.00,WGJG0207,WGJG0208,CONVERT(varchar(100), WGJG0202, 23) AS WGJG0202 FROM dbo.WGJG02 WHERE PersonID IN (SELECT PersonID FROM dbo.A01) AND UnitID=@UnitID AND A0177=@A0177 ORDER BY WGJG0202 DESC) w1 LEFT JOIN
(SELECT CodeItemID,CodeItemName AS WGJG0203 FROM dbo.SM_CodeItems WHERE CodeID='GZFFFS') c1 ON w1.WGJG0203 = c1.CodeItemID;"));
_param?.Clear();
_param.Add("@UnitID", person.orgid);
_param.Add("@A0177", person.A0177);
DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param));
return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <WageDetialResult>(dt));
}
