NC节点导出脚本

NC节点导出脚本：

以节点 1234567890 为例：

--功能注册
select * from sm_funcregister where funcode = '1234567890';
--功能注册表体
select * from sm_paramregister where parentid in (select cfunid from sm_funcregister where funcode = '1234567890');
--菜单
select * from sm_menuitemreg where funcode = '1234567890';
--单据模版
select * from pub_billtemplet where pk_billtypecode = '1234567890';
--单据模版表体
select * from pub_billtemplet_b where pk_billtemplet in (select pk_billtemplet from pub_billtemplet where pk_billtypecode = '1234567890');
--单据模版页签表
select * from pub_billtemplet_t where pk_billtemplet in (select pk_billtemplet from pub_billtemplet where pk_billtypecode = '1234567890');
--查询模版表头
select * from pub_query_templet where model_code = '1234567890';
--查询模版表体
select * from pub_query_condition where pk_templet in (select id from pub_query_templet where model_code = '1234567890');
--打印模版
select * from pub_print_template where vtemplatecode = '1234567890';
--打印模版表体
select * from pub_print_cell where ctemplateid in (select ctemplateid from pub_print_template where vtemplatecode = '1234567890');
--单据类型
select * from bd_billtype where nodecode = '1234567890';
--单据类型动作
select * from pub_billaction where pk_billtypeid in(select pk_billtypeid from bd_billtype where nodecode = '1234567890');
--单据动作插件注册
select * from pub_busiclass where pk_billtypeid in(select pk_billtypeid from bd_billtype where nodecode = '1234567890');

--模版信息
select * from aam_appasset where dataid in (select pk_billtemplet from pub_billtemplet where pk_billtypecode = '1234567890');
select * from aam_appasset where dataid in (select id from pub_query_templet where model_code = '1234567890');
select * from aam_appasset where dataid in (select ctemplateid from pub_print_template where vtemplatecode = '1234567890');

--模板分配基准表
select * from pub_systemplate_base where templateid in (select pk_billtemplet from pub_billtemplet where pk_billtypecode = '1234567890');
select * from pub_systemplate_base where templateid in (select id from pub_query_templet where model_code = '1234567890');
select * from pub_systemplate_base where templateid in (select ctemplateid from pub_print_template where vtemplatecode = '1234567890');

--单据动作插件注册
select * from pub_bcr_nbcr where code in (select pk_billtypecode from bd_billtype where nodecode = '1234567890');
--编码对象
select * from pub_bcr_RuleBase where rulecode in (select pk_billtypecode from bd_billtype where nodecode = '1234567890');
--编码规则元素
select * from pub_bcr_elem where pk_billcodebase in (select pk_billcodebase from pub_bcr_RuleBase where rulecode in (select pk_billtypecode from bd_billtype where nodecode = '1234567890'));

原文链接：https://blog.csdn.net/qq_33639332/article/details/83863893