示例:视图框确定脚本,自动生成子表记录,刷新子表
- //视图框确定脚本,刷新子表
- var did = getId();
- var parentId = getParameterAsText("_selects");
- //获取视图选择框对应的doc
- var parentDoc = findDocument(parentId);
- if(parentDoc!=null && parentId !=null && parentId.trim().length()>0){
- //获取视图选择框对应的doc的子doc
- var subDocs1 = parentDoc.getChilds("施工物料明细");
- var process = getDocumentProcess();
- var domain = getDomainid();
- var application = getApplication();
-
- //如果子doc不为空,遍历子doc,取出每个子doc的值并保存到另一张子doc中。
- if(subDocs1!=null){
- var sql = "delete from tlk_施工物料明细 where PARENT='"+did+"'";
- deleteByDSName("rims",sql);
- var formService = getFormProcess();
- var form = formService.doViewByFormName("施工物料明细",application);
- for(var iter = subDocs1.iterator(); iter.hasNext();){
- var subdoc = iter.next();
- var uuid = new Packages.cn.myapps.util.sequence.Sequence();
- var doc = process.doNew(subform,getWebUser(),createParamsTable());
- doc.setIstmp(false);
- doc.setParent(did);
- doc.addStringItem("施工物料名称",subdoc.getItemValueAsString("施工物料名称"));
- doc.addStringItem("数量",subdoc.getItemValueAsString("数量"));
- doc.addStringItem("单位",subdoc.getItemValueAsString("单位"));
- doc.addStringItem("申请人",subdoc.getItemValueAsString("申请人"));
- process.doCreate(doc);
- }
- }
- }
- var rtn = "<script>";
- rtn += "var subfrms = getFormFieldByName('包含元素名称');";
- rtn += "if (subfrms){ ";
- rtn += "subfrms.document.location.reload();";
- rtn +="}";
- rtn +="</script>";
- rtn;
复制代码 |