已经QQ协助客户解决该问题。问题解决,帖子关闭。正确的代码如下:
(function(){
var docProcess = getDocumentProcess();
var formProcess = getFormProcess();
var newForm = formProcess.doViewByFormName("检修计划",getApplication());
var sql="SELECT a.domainid AS domainid, a.item_编号 AS item_编号, a.item_设备名称 AS item_设备名称 FROM tlk_设备信息主表 a LEFT JOIN tlk_检修计划 b ON a.item_编号 = b.item_编号 AND a.item_设备名称 = b.item_设备名称";
//println("sql-->"+ sql);
var datas=queryBySQL(sql);
println("query------"+datas.size());
if(datas!=null || datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
var data = iter.next();
var newDoc = docProcess.doNew(newForm,getWebUser(),createParamsTable());
var aa=data.getItemValueAsString("设备名称");
var bb=data.getItemValueAsString("编号");
newDoc.setAuthor(getWebUser().getId());
newDoc.setIstmp(false);
newDoc.setApplicationid(getApplication());
newDoc.setDomainid(getWebUser().getDomainid());
newDoc.addStringItem("设备名称",aa);
newDoc.addStringItem("编号",bb);
docProcess.doCreate(newDoc);
}}
})() |