Nccloud自定义参照实现

Z时代
2024-01-10
分类：综合

--普通用户
update sm_user sm set sm.user_password=  
"U_U++--V"||LOWER( RAWTOHEX( UTL_RAW.CAST_TO_RAW( sys.dbms_obfuscation_toolkit.md5(input_string =>  sm.cuserid||"1234abcd"/**要设置的密码*/) ) ) ) 
where sm.tslike"2020-03-22%";
--超管
update sm_super_user set password="U_U++--V93f182df06984208361b9689a94416ec"where admcode ="root";--重置为空密码
update sm_super_user set islocked="N"where admcode ="root";--如果用户锁定，运行该命令进行解锁

Nccloud创建自定义参照

select * from BD_REFINFO where name like"借款单"or name like"供应商付款单"

select * from MD_CLASS where defaulttablename in ( "er_jkzb","ap_paybill")

select * FROM MD_CLASS where refmodelname = "借款单"

--MD_CLASS原语句

insertinto MD_CLASS (ACCESSORCLASSNAME, BIZITFIMPCLASSNAME, CLASSTYPE, COMPONENTID, CREATETIME, CREATOR, DEFAULTTABLENAME, DESCRIPTION, DISPLAYNAME, DR, FIXEDLENGTH, FULLCLASSNAME, HELP, ID, INDUSTRY, ISACTIVE, ISAUTHEN, ISCREATESQL, ISEXTENDBEAN, ISPRIMARY, KEYATTRIBUTE, MODIFIER, MODIFYTIME, MODINFOCLASSNAME, NAME, PARENTCLASSID, PRECISE, REFMODELNAME, RESID, RETURNTYPE, STEREOTYPE, TS, USERDEFCLASSNAME, VERSIONTYPE)

values ("nc.md.model.access.javamap.AggVOStyle", "", 201, "97fb6843-4991-4840-a555-847ebec18424", "2009-06-24 12:35:15", "", "ap_paybill", "", "供应商付款单", null, "", "nc.vo.arap.pay.PayBillVO", "smart,BUSILOG", "6ec38eda-3752-462a-bb29-2add1625f011", "0", "", "Y", "Y", "", "Y", "1f27882e-5048-484b-b19d-a1e6bb2bf56f", "yonyouBQ", "2019-01-08 10:13:26", "", "paybill", "", null, "", "2paybill-000037", "", "", "2019-07-03 16:52:31", "", 0);

values ("nc.md.model.access.javamap.AggVOStyle", "", 201, "72539296-21dc-4b99-91a2-f350cbaff5ae", "2010-01-20 19:47:27", "", "er_jkzb", "", "借款单", null, "", "nc.vo.ep.bx.JKHeaderVO", "BUSILOG", "e0499b58-c604-48a6-825b-9a7e4d6dacca", "0", "", "Y", "Y", "", "Y", "0aee8d74-47a0-458b-a459-fdf804ab1040", "developer", "2018-10-17 15:21:22", "", "jkzb", "", null, "", "22011LMG-000086", "", "", "2019-07-03 16:54:25", "", 0);

values ("nc.md.model.access.javamap.AggVOStyle", "", 201, "a5e3685e-4fac-4ffa-94aa-c69371decd06", "2010-03-18 19:14:49", "", "ct_pu", "", "采购合同", null, "", "nc.vo.ct.purdaily.entity.CtPuVO", "BUSILOG", "5a300bf9-2157-4fc6-8255-d7538356fd90", "0", "", "Y", "Y", "", "Y", "5911dedb-7ff1-45c2-906c-6b9c87a8620a", "YONYOU NC", "2015-11-18 10:02:05", "", "ct_pu", "", null, "采购合同", "2402000303-0076", "", "", "2019-07-03 17:02:24", "", 0);

-- BD_REFINFO 原语句

insertinto BD_REFINFO (CODE, DR, ISTREELAZYLOAD, ISNEEDPARA, ISSPECIALREF, LAYER, METADATANAMESPACE, METADATATYPENAME, MODULENAME, NAME, PARA1, PARA2, PARA3, PK_COUNTRY, PK_INDUSTRY, PK_REFINFO, REFCLASS, REFPATH, REFSYSTEM, REFTYPE, RESERV1, RESERV2, RESERV3, RESID, RESIDPATH, TS, WHEREPART)

values ("40203001", 0, "Y", "", "", null, "ct", "ct_pu", "ct", "采购合同", "", "", "", "", "", "4020Z830100000000004", "nc.ui.ct.purdaily.ref.CtPuRefModel", "justbon/refer/purdaily/CtpuGridRef/index", "", 1, "", "", "", "ref_40203001", "refinfo", "2019-07-03 17:13:06", "");

--查询语句

SELECT * FROM BD_REFINFO where name like"%采购合同%"or pk_refinfo like"5%"

select * from MD_CLASS where defaulttablename in ("ap_paybill","er_jkzb","ct_pu")

--参照注册

INSERTINTO BD_REFINFO ("CODE", "DR", "ISTREELAZYLOAD", "ISNEEDPARA", "ISSPECIALREF", "LAYER", "METADATANAMESPACE", "METADATATYPENAME", "MODULENAME", "NAME", "PARA1", "PARA2", "PARA3", "PK_COUNTRY", "PK_INDUSTRY", "PK_REFINFO", "REFCLASS", "REFPATH", "REFSYSTEM", "REFTYPE", "RESERV1", "RESERV2", "RESERV3", "RESID", "RESIDPATH", "TS", "WHEREPART")

values ("50205001", 0, "Y", "", "", null, "arap", "paybill", "arap", "供应商付款单", "", "", "", "", "", "5020Z830100000000005", "", "justbon/refer/loanbill/transrefer/index", "", 1, "", "", "", "ref_40203001", "refinfo", "2020-01-01 17:13:06", "");

values ("50204001", 0, "Y", "", "", null, "erm", "jkzb", "erm", "借款单", "", "", "", "", "", "5020Z830100000000004", "", "justbon/refer/paybill/paybill/index", "", 1, "", "", "", "ref_40203001", "refinfo", "2020-01-01 17:13:06", "");

--修改翻译模板

UPDATE MD_CLASS set refmodelname = "供应商付款单"where defaulttablename = "ap_paybill"

UPDATE MD_CLASS set refmodelname = "借款单"where defaulttablename = "er_jkzb"

--王沫补丁 20200105

--元数据补丁

--SELECT * FROM MD_CLASS where defaulttablename in ("er_jkzb","ap_paybill","ct_pu");

INSERTINTO"MD_CLASS"("ACCESSORCLASSNAME", "BIZITFIMPCLASSNAME", "CLASSTYPE", "COMPONENTID", "CREATETIME", "CREATOR", "DEFAULTTABLENAME", "DESCRIPTION", "DISPLAYNAME", "DR", "FIXEDLENGTH", "FULLCLASSNAME", "HELP", "ID", "INDUSTRY", "ISACTIVE", "ISAUTHEN", "ISCREATESQL", "ISEXTENDBEAN", "ISPRIMARY", "KEYATTRIBUTE", "MODIFIER", "MODIFYTIME", "MODINFOCLASSNAME", "NAME", "PARENTCLASSID", "PRECISE", "REFMODELNAME", "RESID", "RETURNTYPE", "STEREOTYPE", "TS", "USERDEFCLASSNAME", "VERSIONTYPE") VALUES ("nc.md.model.access.javamap.AggVOStyle", NULL, "201", "a5e3685e-4fac-4ffa-94aa-c69371decd06", "2010-03-18 19:14:49", NULL, "ct_pu", NULL, "采购合同", NULL, NULL, "nc.vo.ct.purdaily.entity.CtPuVO", "BUSILOG", "5a300bf9-2157-4fc6-8255-d7538356fd90", "0", NULL, "Y", "Y", NULL, "Y", "5911dedb-7ff1-45c2-906c-6b9c87a8620a", "YONYOU NC", "2015-11-18 10:02:05", NULL, "ct_pu", NULL, NULL, "采购合同", "2402000303-0076", NULL, NULL, "2019-07-03 17:02:24", NULL, "0");

INSERTINTO"MD_CLASS"("ACCESSORCLASSNAME", "BIZITFIMPCLASSNAME", "CLASSTYPE", "COMPONENTID", "CREATETIME", "CREATOR", "DEFAULTTABLENAME", "DESCRIPTION", "DISPLAYNAME", "DR", "FIXEDLENGTH", "FULLCLASSNAME", "HELP", "ID", "INDUSTRY", "ISACTIVE", "ISAUTHEN", "ISCREATESQL", "ISEXTENDBEAN", "ISPRIMARY", "KEYATTRIBUTE", "MODIFIER", "MODIFYTIME", "MODINFOCLASSNAME", "NAME", "PARENTCLASSID", "PRECISE", "REFMODELNAME", "RESID", "RETURNTYPE", "STEREOTYPE", "TS", "USERDEFCLASSNAME", "VERSIONTYPE") VALUES ("nc.md.model.access.javamap.AggVOStyle", NULL, "201", "97fb6843-4991-4840-a555-847ebec18424", "2009-06-24 12:35:15", NULL, "ap_paybill", NULL, "供应商付款单", NULL, NULL, "nc.vo.arap.pay.PayBillVO", "smart,BUSILOG", "6ec38eda-3752-462a-bb29-2add1625f011", "0", NULL, "Y", "Y", NULL, "Y", "1f27882e-5048-484b-b19d-a1e6bb2bf56f", "yonyouBQ", "2019-01-08 10:13:26", NULL, "paybill", NULL, NULL, "供应商付款单", "2paybill-000037", NULL, NULL, "2019-07-03 16:52:31", NULL, "0");

INSERTINTO"MD_CLASS"("ACCESSORCLASSNAME", "BIZITFIMPCLASSNAME", "CLASSTYPE", "COMPONENTID", "CREATETIME", "CREATOR", "DEFAULTTABLENAME", "DESCRIPTION", "DISPLAYNAME", "DR", "FIXEDLENGTH", "FULLCLASSNAME", "HELP", "ID", "INDUSTRY", "ISACTIVE", "ISAUTHEN", "ISCREATESQL", "ISEXTENDBEAN", "ISPRIMARY", "KEYATTRIBUTE", "MODIFIER", "MODIFYTIME", "MODINFOCLASSNAME", "NAME", "PARENTCLASSID", "PRECISE", "REFMODELNAME", "RESID", "RETURNTYPE", "STEREOTYPE", "TS", "USERDEFCLASSNAME", "VERSIONTYPE") VALUES ("nc.md.model.access.javamap.AggVOStyle", NULL, "201", "72539296-21dc-4b99-91a2-f350cbaff5ae", "2010-01-20 19:47:27", NULL, "er_jkzb", NULL, "借款单", NULL, NULL, "nc.vo.ep.bx.JKHeaderVO", "BUSILOG", "e0499b58-c604-48a6-825b-9a7e4d6dacca", "0", NULL, "Y", "Y", NULL, "Y", "0aee8d74-47a0-458b-a459-fdf804ab1040", "developer", "2018-10-17 15:21:22", NULL, "jkzb", NULL, NULL, "借款单", "22011LMG-000086", NULL, NULL, "2019-07-03 16:54:25", NULL, "0");

--SELECT * FROM BD_REFINFO WHERE name in ("借款单","供应商付款单","采购合同")

--参照补丁

--20200105

INSERTINTO"BD_REFINFO"("CODE", "DR", "ISTREELAZYLOAD", "ISNEEDPARA", "ISSPECIALREF", "LAYER", "METADATANAMESPACE", "METADATATYPENAME", "MODULENAME", "NAME", "PARA1", "PARA2", "PARA3", "PK_COUNTRY", "PK_INDUSTRY", "PK_REFINFO", "REFCLASS", "REFPATH", "REFSYSTEM", "REFTYPE", "RESERV1", "RESERV2", "RESERV3", "RESID", "RESIDPATH", "TS", "WHEREPART") VALUES ("40203001", "0", "Y", NULL, NULL, NULL, "ct", "ct_pu", "ct", "采购合同", NULL, NULL, NULL, NULL, NULL, "4020Z830100000000004", "nc.ui.ct.purdaily.ref.CtPuRefModel", "justbon/refer/purdaily/CtpuGridRef/index", NULL, "1", NULL, NULL, NULL, "ref_40203001", "refinfo", "2019-07-03 17:13:06", NULL);

INSERTINTO"BD_REFINFO"("CODE", "DR", "ISTREELAZYLOAD", "ISNEEDPARA", "ISSPECIALREF", "LAYER", "METADATANAMESPACE", "METADATATYPENAME", "MODULENAME", "NAME", "PARA1", "PARA2", "PARA3", "PK_COUNTRY", "PK_INDUSTRY", "PK_REFINFO", "REFCLASS", "REFPATH", "REFSYSTEM", "REFTYPE", "RESERV1", "RESERV2", "RESERV3", "RESID", "RESIDPATH", "TS", "WHEREPART") VALUES ("50204002", "0", "Y", NULL, NULL, NULL, "erm", "jkzb", "erm", "借款单", NULL, NULL, NULL, NULL, NULL, "5020Z830100000000004", NULL, "justbon/refer/loanbill/transrefer/index", NULL, "1", NULL, NULL, NULL, "ref_40203001", "refinfo", "2020-01-01 17:13:06", NULL);

INSERTINTO"BD_REFINFO"("CODE", "DR", "ISTREELAZYLOAD", "ISNEEDPARA", "ISSPECIALREF", "LAYER", "METADATANAMESPACE", "METADATATYPENAME", "MODULENAME", "NAME", "PARA1", "PARA2", "PARA3", "PK_COUNTRY", "PK_INDUSTRY", "PK_REFINFO", "REFCLASS", "REFPATH", "REFSYSTEM", "REFTYPE", "RESERV1", "RESERV2", "RESERV3", "RESID", "RESIDPATH", "TS", "WHEREPART") VALUES ("50205001", "0", "Y", NULL, NULL, NULL, "arap", "paybill", "arap", "供应商付款单", NULL, NULL, NULL, NULL, NULL, "5020Z830100000000005", NULL, "justbon/refer/paybill/paybill/index", NULL, "1", NULL, NULL, NULL, "ref_40203001", "refinfo", "2020-01-01 17:13:06", NULL);