视图确认脚本的简单代码

(function(){
    var relate = getRelateDocument();
    var selectId = getParameterAsText("_selects");
    var sel=selectId.replace(";","','");
    if(sel !=null && sel.trim().length()>0){
        var relateId = relate.getId();
        var curDoc = getCurrentDocument();
        var docProcess = getDocumentProcess();
        var formProcess = getFormProcess();
        var newForm = formProcess.doViewByFormName("明细表单",getApplication());
        sel="('"+sel+"')";
        var sql="select domainid,item_string类型,item_double类型 from tlk_表单 where 条件 in "+sel;
        var datas = queryBySQL(sql);
        if(datas!=null || datas.size()>0){
            for(var it = datas.iterator();it.hasNext(); ){
                var data = it.next();
                var dataId = data.getId();
                var newDoc = docProcess.doNew(newForm,getWebUser(),createParamsTable());
                //检测是否存在.一般都写在视图内这块不用
                var isExistSql = "select domainid from tlk_明细表单 where parent='"+relateId+"' and item_.... ='"+dataId+"'";
                var isExistData = countBySQL(isExistSql);
                if(isExistData <=0){
                    var sproNum = data.getItemValueAsString("单项编号");
                    var contractNum = data.getItemValueAsString("合同编号");
                    var invoiceNum = data.getItemValueAsString("发票号");
                    var projectNumber=getProNumBySProNum(sproNum);
                    newDoc.setParent(relateId);
                    newDoc.setAuthor(getWebUser().getId());
                    newDoc.setIstmp(false);
                    newDoc.setApplicationid(getApplication());
                    newDoc.setDomainid(getWebUser().getDomainid());
                    newDoc.addStringItem("string类型",data.getItemValueAsString("string类型"));
                    newDoc.addDoubleItem("double类型",data.getItemValueAsDouble("double类型"));
                    docProcess.doCreate(newDoc);
                }
            }
        }
    }
})();