智云MES后端API代码
parent: 05a948b4 | 补丁 | 提交 | show whitespace
duhe
2023-12-08 7ef0e8ac0b8ecbb32393e16707ee28bca35de821 
根据用户获取职员、部门、主管报错处理
1个文件已修改
6 ■■■■■ 已修改文件
WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs


@@ -1856,11 +1856,11 @@


            try


            {


                string sql = @"select 


                            c.HEmpID


                            ISNULL(c.HEmpID,0) HEmpID


                            ,e.HName HEmpName


                            ,c.HDeptID


                            ,ISNULL(c.HDeptID,0) HDeptID


                            ,d.HName HDeptName


                            ,d.HEmpID HManagerID


                            ,ISNULL(d.HEmpID,0) HManagerID


                            ,e1.HName HManagerName


                            from Gy_Czygl as c


                            left join Gy_Employee as e on c.HEmpID = e.HItemID