EAS-查看非末级部门对应的部门负责人是否为空，不为空将需要设置为空

1.查询数据库

select * from t_org_admin  org where 1=1
and org.FIsSealUp=0  
and org.FIsOUSealUp =0  
and org.FIsLeaf=0 
and org.FResponPositionID is not null;

2.备份

此备份在EAS查询分析器执行；

select * into dml_t_org_admin_180119 from t_org_admin  org where 1=1

and org.FIsSealUp=0  

and org.FIsOUSealUp =0  
and org.FIsLeaf=0 
and org.FResponPositionID is not null;

3.将不为空的部门负责人设置为空；

可以手工处理，将FResponPositionID此字段值的单元格的内值删掉即可；

脚本处理：

update t_org_admin set FResponPositionID='' where fid in (select fid from t_org_admin  org where 1=1and org.FIsSealUp=0  

and org.FIsOUSealUp =0  
and org.FIsLeaf=0 
and org.FResponPositionID is not null)

即可；