本帖最后由 Jarod 于 2014-6-24 18:21 编辑
前段时间我提问过相关问题,但是当时只是测试了插入一个字段的内容:
http://www.teemlink.com/bbs/viewthread.php?tid=198334
今天准备试着插入一个表的多个字段到子表单中,结果写好下列语句在视图选择框的确定条件里之后报错:“请选择一个字段”。
我想请问一下,插入多个字段不能用这种方法是吗?
代码:
var doc1 = getCurrentDocument();
var childs = doc1.getChilds("Annual_ITP_Boss_Sublist");
var process = getDocumentProcess();
var formProcess = getFormProcess();
var id = getParentDocument().getId();
println(id);
var selects=getParameterAsText("_selects");
var sel=selects.replace(";","','");
sel="('"+sel+"')";
var sql = "select * from tlk_v_annual_itp where id in "+sel;
var datas = queryBySQL(sql);
println("Select=====" + datas);
if (datas.size() > 0) {
for (var iter = datas.iterator(); iter.hasNext();) {
var data = iter.next();
deptname = data.getItemValueAsString("dept_name");
deptcode = data.getItemValueAsString("dept_code");
var subform = formProcess.doView("11e3-f050-05fccbfd-af41-63cd55d3fa68");
var doc = process.doNew(subform,getWebUser(),createParamsTable());
doc.addStringItem("dept_name",deptname);
doc.addStringItem("dept_code",deptcode);
doc.setParent(id);
process.doCreate(doc);
}
} |