本帖最后由 白沙烟草 于 2014-6-12 15:28 编辑
经过向论坛里众多贴子学习,基本实现通过视图选择框批量向子表单插入数据的功能,但是仍存在以下问题:
1、通过视图选择框的确定条件里写脚本来实现插入子表,也勾选了刷新,但是插入后,在保存主表单前,主从表结构表单中,以视图形式显示的子表不显示插入数据。保存主表单后才显示。这个问题如何解决?
附上我写的代码:
var doc1 = getCurrentDocument();
var childs = doc1.getChilds("Annual_ITP_Boss_Sublist");
var process = getDocumentProcess();
var formProcess = getFormProcess();
var id = getParentDocument().getId();
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");
var subform = formProcess.doView("11e3-f050-05fccbfd-af41-63cd55d3fa68");
var doc = process.doNew(subform,getWebUser(),createParamsTable());
doc.addStringItem("dept_name",deptname);
doc.setParent(id);
process.doCreate(doc);
}
} |