本帖最后由 karrman 于 2016-12-21 17:49 编辑
Q:如果在视图选择框中,获取多个记录,插入的当前表单的子表中,
A:配置视图选择框-是多选模式,之后在确定条件中,添加如下脚本,注意视图选择框需要勾选刷新,包含元素勾选重计算- (function(){
- var flag =true;
- var selectId = getParameterAsText("_selects");
- var relate = getParentDocument();
- var curDoc = getCurrentDocument();
- var docProcess = getDocumentProcess();
- var formProcess = getFormProcess();
- var newForm = formProcess.doViewByFormName("调货单",getApplication());
- var sel=selectId.replace(";","','");
- sel="('"+sel+"')";
- if(selectId !=null || selectId.length>0){
- var sql = "select * from tlk_fm_client where id in "+sel;
- var datas = queryBySQL(sql);
- if(datas!=null || datas.size()>0){
- for(var iter = datas.iterator();iter.hasNext();){
- var data = iter.next();
- var sinNum = data.getId();
- var parentId = relate.getId();
- var sqlChard ="select * from tlk_fm_client where parent ='"+sinNum+"'";
- var dataChard = findBySQL(sqlChard);
- if(dataChard==null){
- var newDoc = docProcess.doNew(newForm,getWebUser(),createParamsTable());
- newDoc.setParent(parentId);
- newDoc.setAuthor(getWebUser().getId());
- newDoc.setIstmp(false);
- newDoc.setApplicationid(getApplication());
- newDoc.setDomainid(getWebUser().getDomainid());
- newDoc.addStringItem("名称",data.getItemValueAsString("客户名"));
- docProcess.doCreate(newDoc);
- return flag;
- }
- }
- }
- }
- })();
复制代码
|