单个部门删除逻辑

找不到

结束

根据ps_c_if_dept_tbl.DING_DEPTID去dept/dept_jb表查找对应的生效的部门。对应的sql见右边的注释

找到

从ps_c_if_dept_tbl获取有效的部门有效部门查询条件:EFF_STATUS='A' and C_CRUD_FLAG !='D'

查找sql:心怡: select * from dept d where d.`ineffect_time`='9999-12-31' and d.`dept_type` = 0 and d.`dept_id` = 'ps_c_if_dept_tbl.DING_DEPTID去掉前缀' and dept_id not like 'GW_%'; 桔瓣:    select * from dept_jb d where d.`ineffect_time`='9999-12-31' and d.`dept_id` = 'ps_c_if_dept_tbl.DING_DEPTID无需去前缀' ;

将ps_c_if_dept_tb.EFF_STATUS更新为'I'。ps_c_if_dept_tb.EFFDT更新为当前日期