E9/8:部门浏览框取任意层级部门id

༄天M宇ༀ

已于 2023-12-11 10:31:30 修改

阅读量287

点赞数

分类专栏：泛微OA：E9 文章标签： sql mysql 数据库

于 2023-06-12 15:33:37 首次发布

本文链接：https://blog.csdn.net/qq_34975043/article/details/131169937

版权

泛微OA：E9 专栏收录该内容

34 篇文章 12 订阅

订阅专栏


--单部门：WHERE  Id = $main.ddbm$) 多部门 ：WHERE  Id in ($main.ddbm$)
--层级：supdepid = 0 （一级部门）其他层级修改supdepid_对应值
----sqlservice/oracle数据库
doFieldSQL("WITH TEMP
     AS (SELECT Id,
                departmentName,
                supdepid
         FROM   hrmdepartment
         WHERE  Id in ($main.ddbm$)
         UNION ALL
         SELECT B.Id,
                B.departmentName,
                B.supdepid
         FROM   TEMP A
                INNER JOIN hrmdepartment B
                        ON B.Id = A.supdepid)
SELECT Id
FROM   TEMP  where supdepid = 0  ")


--mysql数据库
SELECT Id
FROM (
    SELECT Id, departmentName, supdepid
    FROM hrmdepartment
    WHERE Id IN ($main.ddbm$)
    UNION ALL
    SELECT B.Id, B.departmentName, B.supdepid
    FROM hrmdepartment B
    INNER JOIN (
        SELECT Id, departmentName, supdepid
        FROM hrmdepartment
        WHERE Id IN ($main.ddbm$)
    ) A ON B.Id = A.supdepid
) TEMP
WHERE supdepid = 0;