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