uap系统的参数模板设置主要存储在两张表内,分别是:
参数设置 (pub_sysinit) 和 参数模板设置 (pub_sysinittemp)
利用plsql导出它们的脚本即可,导出的脚本大致如下:
参数模板配置:
REM INSERTING into PUB_SYSINITTEMP
SET DEFINE OFF;
Insert into PUB_SYSINITTEMP (AFTERCLASS,CHECKCLASS,DATACLASS,DATAORIGINFLAG,DEFAULTVALUE,DOMAINFLAG,DR,EDITCOMPONENTCTRLCLASS,GROUPCODE,GROUPNAME,INITCODE,INITNAME,MAINFLAG,MUTEXFLAG,ORGTYPECONVERTMODE,PARATYPE,PK_ORGTYPE,PK_REFINFO,PK_SYSINITTEMP,REMARK,SHOWFLAG,STATEFLAG,SYSFLAG,SYSINDEX,TS,VALUELIST,VALUETYPE) values (null,null,null,0,null,'2011',null,null,'~',null,'ER15','报销单查看角色参照','N',0,'GLOBLE00000000000000','business','GLOBLE00000000000000','0001Z01000000003FR99','1001ZZ100000005E358A',null,'Y',5,'N',0,'2015-05-14 15:15:22',null,2);
Insert into PUB_SYSINITTEMP (AFTERCLASS,CHECKCLASS,DATACLASS,DATAORIGINFLAG,DEFAULTVALUE,DOMAINFLAG,DR,EDITCOMPONENTCTRLCLASS,GROUPCODE,GROUPNAME,INITCODE,INITNAME,MAINFLAG,MUTEXFLAG,ORGTYPECONVERTMODE,PARATYPE,PK_ORGTYPE,PK_REFINFO,PK_SYSINITTEMP,REMARK,SHOWFLAG,STATEFLAG,SYSFLAG,SYSINDEX,TS,VALUELIST,VALUETYPE) values (null,null,null,0,'N','2011',null,null,'~',null,'ER16','报销单全局查看权限','N',0,'GLOBLE00000000000000','business','GLOBLE00000000000000','~','1001ZZ100000005E358D',null,'Y',2,'N',0,'2015-05-14 15:33:10','Y/N',1);
业务参数设置-全局:
REM INSERTING into PUB_SYSINIT
SET DEFINE OFF;
Insert into PUB_SYSINIT (CONTROLFLAG,DATAORIGINFLAG,DR,EDITFLAG,INITCODE,INITNAME,MODIFIEDTIME,MODIFIER,PK_ORG,PK_SYSINIT,SYSINIT,TS,VALUE) values ('N',0,0,'Y','ER15','报销单查看角色参照','2015-05-15 16:51:17','1001H21000000001JV9N','GLOBLE00000000000000','1001H2100000005E3RA0','1001ZZ100000005E358A','2015-05-15 16:51:17','1001H2100000005E3RBD');
Insert into PUB_SYSINIT (CONTROLFLAG,DATAORIGINFLAG,DR,EDITFLAG,INITCODE,INITNAME,MODIFIEDTIME,MODIFIER,PK_ORG,PK_SYSINIT,SYSINIT,TS,VALUE) values ('N',0,0,'Y','ER16','报销单全局查看权限','2015-05-15 16:48:22','1001H21000000001JV9N','GLOBLE00000000000000','1001H2100000005E3RA1','1001ZZ100000005E358D','2015-05-15 16:48:22','Y');