- //从非myapps的表取数,插入到myapps的表中
- //var sql = "select to_char(xcrq,'yyyy-mm-dd hh:mm:ss'),ch,id from zx.gzcck where id is not null";
- var sqlid ="select distinct gzcck.xcrq,gzcck.ch,gzcck.id from gzcck where gzcck.id not in(select distinct gzcck.id from gzcck,t_document where gzcck.id =t_document.MAPPINGID) and gzcck.id is not null";
- var datasid = queryByDSName("zx",sqlid);
- println("sql"+sqlid);
- println("datas"+datasid);
- var uuid = new Packages.cn.myapps.util.sequence.Sequence();//取id
- //println(uuid);
- if(datasid!=null && datasid.size() > 0){
- for(var iterator = datasid.iterator();iterator.hasNext();){
- var map1 = iterator.next();
- var xcrq= map1.get("to_char(xcrq,'yyyy-mm-ddhh:mm:ss')");
- var ch= map1.get("ch");
- var id= map1.get("id");
- var sql1 = "insert into T_DOCUMENT(id,applicationid,domainid,formid,author,author_dept_index,formname,istmp,stateint,lastmodifier,MAPPINGID) values('"+uuid.getSequence()+"','11e2-ce52-e7c9ac94-a60a-174b8b3a23ac','"+getDomainid()+"','11e2-cf49-71cbcd49-9e77-f983b4b0f11d','11e2-2a47-a2681254-9db2-038f0b4abf8b','','锦州车辆段站修管理系统2.0/站修生产管理/hmis/hmisys','0','','11e2-abe3-55e7b399-90b5-952f544aa741','"+id+"' )";
- insertByDSName("zx",sql1);
- }
- }
复制代码 |