--****************************************************************************
--第1步:
----删除用户和组织关系表
----用administrator登陆---系统管理---系统管理---用户管理---查询用户---点击涉及的用户--修改--删除该用户涉及的组织
select * from T_SEC_USERORG
select * from T_SEC_USERROLEMAP
--****************************************************************************
--第2步:
--删除不需要的组织
--组织机构相关查询
--组织机构--索引
select * from T_ORG_Organizations
--组织机构--名称
select * from T_ORG_ORGANIZATIONS_L
--组织机构--关联关系
select T1.FORGID as 组织内码
, ( convert(varchar(50),T1.FNUMBER) + '||' + convert(varchar(200),T2_1.FNAME) ) as 组织代码和名称
, T1.FNUMBER as 组织代码1,T2_1.FNAME as 组织名称1, T1.FNUMBER as 组织代码2,T2_1.FNAME as 组织名称2 , T1.FNUMBER as 上级组织代码,T2_1.FNAME as 上级组织名称
from T_ORG_Organizations as T1
left outer join ( select * from T_ORG_ORGANIZATIONS_L where FLOCALEID =2052 ) as T2_1 on T1.FORGID =T2_1.FORGID
left outer join ( select * from T_ORG_ORGANIZATIONS_L where FLOCALEID =2052 ) as T2_2 on T1.FPARENTID =T2_2.FORGID
-- where ( convert(varchar,T1.FNUMBER) + '||' + convert(varchar,T2_1.FNAME) ) = 'zz001.2011||zz001.2011_组织名称'
order by T1.FNUMBER
---------------------------------
-- --zz001_2001 --zz001_2009 or --zz001_2011 --zz001_2021
delete from T_ORG_ORGANIZATIONS_L where (FORGID >=100001 and FORGID <=100018) or (FORGID >=100020 and FORGID <=100021)
-- --zz001_2001 --zz001_2009 or --zz001_2011 --zz001_2021
delete from T_ORG_Organizations where (FORGID >=100001 and FORGID <=100018) or (FORGID >=100020 and FORGID <=100021)
--****************************************************************************
