数据是由另一个数据库插入到这个环境的数据库中的,插入了对应表单和t_document数据,
var i_sql=" insert into tlk_POLICY_FILE_NOTICE@Link08 ( LASTMODIFIED, FORMNAME, AUTHOR, CREATED, FORMID, ISTMP, VERSIONS, APPLICATIONID, STATEINT, LASTMODIFIER, DOMAINID, AUDITORLIST, item_TITLE, item_CNN_POLICY, item_CONTENT, item_CREATE_DEPT, item_CREATER, item_CREATION_TIME, item_MODIFY_TIME, item_IS_FS ,ID) select a.LASTMODIFIED, 'ERP企业管理中心/政策文件通知/POLICY_FILE_NOTICE', '"+userid+"', cast(sysdate as timestamp(6)), a.FORMID, 0, 1, '11e7-88b4-8e23efbb-9105-3f20b48e07c7', 0, '"+userid+"', '11e7-886d-c1af8de1-8389-abccceaa15dc', a.AUDITORLIST, a.item_TITLE, a.item_CNN_POLICY, a.item_CONTENT, a.item_CREATE_DEPT, a.item_CREATER, cast(sysdate as timestamp(6)), cast(sysdate as timestamp(6)), '否' ,a.ID from tlk_POLICY_FILE_NOTICE a where a.id = '"+id+"' and not exists (select 1 from tlk_POLICY_FILE_NOTICE@Link08 b where a.id = b.id) ";
insertByDSName("ERP开发",i_sql);
var i_sql2=" merge into t_document@Link08 t using (select ID, LASTMODIFIED, FORMNAME, AUTHOR, CREATED, FORMID, ISTMP, VERSIONS, APPLICATIONID, LASTMODIFIER, DOMAINID, ID MAPPINGID from tlk_POLICY_FILE_NOTICE a where a.id = '"+id+"') d on (d.ID = t.ID) when matched then update set t.Lastmodified = cast(sysdate as timestamp(6)) when not matched then insert (t.ID, t.LASTMODIFIED, t.FORMNAME, t.AUTHOR, t.CREATED, t.FORMID, t.ISTMP, t.VERSIONS, t.APPLICATIONID, t.LASTMODIFIER, t.DOMAINID, t.MAPPINGID) values (d.ID, d.LASTMODIFIED, d.FORMNAME, d.AUTHOR, d.CREATED, d.FORMID, d.ISTMP, d.VERSIONS, d.APPLICATIONID, d.LASTMODIFIER, d.DOMAINID, d.ID) ";
insertByDSName("ERP开发",i_sql2);另一个环境生成了数据后打开表单点击报错会报上面的这个校验,这个校验应该是平台内置的 |