通过级联加载部门树,用SQL来验证部门子集是否存在。
select ID,DEPT as name,
(case when (select count(*) from SM_DEPT b where b.PID=a.ID)>0 then 'Y' else 'N' end) as PATH
from SM_DEPT a where PID='${PID}' ORDER BY SNO
根据PATH字段来确定是否还有子集,然后根据数据进行数据处理
通过级联加载部门树,用SQL来验证部门子集是否存在。
select ID,DEPT as name,
(case when (select count(*) from SM_DEPT b where b.PID=a.ID)>0 then 'Y' else 'N' end) as PATH
from SM_DEPT a where PID='${PID}' ORDER BY SNO
根据PATH字段来确定是否还有子集,然后根据数据进行数据处理