WebAPI/Controllers/人事管理/离职申请/HR_EmpDimissionBillController.cs
@@ -805,10 +805,12 @@
                            b.HItemID HDeptID, b.HNumber HDeptNumber, b.HName HDeptName
                            , c.HItemID HPostID, c.HNumber HPostNumber, c.HName HPostName
                            , d.HItemID HWorkTypeID, d.HNumber HWorkTypeNumber, d.HName HWorkTypeName, d.HPayMoney 
                            , e.HItemID HGroupID, e.HNumber HGroupNumber, e.HName HGroupName
                            from Gy_Employee AS a 
                            LEFT OUTER JOIN Gy_Department AS b on a.HDeptID = b.HItemID
                            LEFT OUTER JOIN Gy_Post AS c on a.HPostID = c.HItemID
                            LEFT OUTER JOIN Gy_WorkType AS d on a.HWorkTypeID = d.HItemID
                            LEFT OUTER JOIN Gy_Group AS e on a.HGroupID = e.HItemID
                            where a.HItemID = " + HEmpID;
                ds = oCN.RunProcReturn(sql, "Gy_EmployeeInfo");