NC Cloud 升级到2005版需要删除的监听和无效项目

--一、云原生要进行删除

--停用利润中心存货

delete from sm_createcorp where FUNCCODE = '3824';

--停用利润中心交易

delete from sm_createcorp where FUNCCODE = '3822';

-- 停用进出口模块

delete from sm_createcorp a where a.funccode like '41%';

-- 删除进出口插件

delete from pub_pluginitem where vextendmodule in ('et','it');

delete from pub_eventlistener where owner like '41%';

--停用运输管理模块

delete from pub_eventlistener where owner='4014';

delete from sm_createcorp where FUNCCODE = '4014';

---生产制造

delete from sm_createcorp  where FUNCCODE like '50%';

delete from pub_eventlistener where owner in('5099','5011','5010','5009','5014','5003','5002','5004','5006','5007','5008','5001','5012','5016','5018','5019 ');

--二、云原生和经典盘都要进行删除 

---停用营改增

delete from sm_createcorp where FUNCCODE in( 'C101','C110','C120'，'C140');

--停用电子销售

delete from sm_createcorp where FUNCCODE like 'EC%';

--删除电子销售扩展类

delete from pub_pluginitem where vruleclass like '%.opcnc.%';

--删除项目管理监听

delete from pub_eventlistener where owner in('3840','4815','4850','4801','4810','4820','4802','4804','4806','4817','4830','4840','4853','4855','4860','4870 ');

DELETE FROM PUB_EVENTLISTENER WHERE OWNER IN ('4S10','4S20','EC20','EC23');

/*电采插件删除（供应商无插件）*/ 

DELETE FROM SM_PARAMREGISTER WHERE PARAMNAME LIKE '%PluginBeanConfigFilePath%' AND PARAMVALUE LIKE 'nc/ui/ebpur%'  AND PARENTID LIKE '%Z8%' AND PK_PARAM LIKE '%ZF%';

/*电采供应商菜单项删除*/ 

DELETE FROM SM_MENUITEMREG WHERE MENUITEMCODE IN ('4S','EC');

/*电采供应商功能注册项删除*/ 

DELETE FROM DAP_DAPSYSTEM WHERE MODULEID IN ('4S','EC') OR PARENTCODE IN ('4S','EC');

--资金删除监听

--删除付款排程功能节点

DELETE FROM SM_FUNCREGISTER sf WHERE sf.OWN_MODULE ='3612';

--删除付款排程监听

DELETE  FROM PUB_EVENTLISTENER pe WHERE pe.OWNER ='3612';

--删除付款排程查询拓展功能

DELETE  FROM PUB_QUERY_SYSFUNC pqs WHERE pqs.PK_SYSFUNC ='1001Z6_PS_PERIOD0002';

--删除内部贷款管理功能节点

DELETE  FROM SM_FUNCREGISTER sf WHERE sf.OWN_MODULE ='3635';

--删除内部贷款管理监听

DELETE  FROM PUB_EVENTLISTENER pe WHERE pe.OWNER ='3635';