视图导入-导入配置用户选择框值脚本

用户选择框单选

   (function () {      
      var doc = getCurrentDocument();      
      var person_in_charge = doc.getItemValueAsString("person_in_charge");      
      var userid = "";      
      if (person_in_charge != null&&!"".equals(person_in_charge)) {      
          var sql = "select domainid,id from t_user where name = '" + person_in_charge + "'"; // oracle      
          var datas = queryByDSName("数据源名称",sql);      
          if (datas.size() > 0) {      
              userid = datas.iterator().next().get("id");      
          }      
      }      
      return userid;      
   })()

用户选择框多选

(function () {    
        var doc = getCurrentDocument();    
        var collaborator = doc.getItemValueAsString("collaborator");    
        var userid = "";    
        if (collaborator != null && !"".equals(collaborator)) {    
            var collaboratorList = collaborator.split(";");    
            for (var i = 0; i < collaboratorList.length; i++) {    
                var sql = "select domainid,id from t_user where name = '" + collaboratorList[i] + "'";    
                var datas = queryByDSName("数据源名称", sql);    
                if (datas.size() > 0) {    
                    userid += datas.iterator().next().get("id") + ";";    
                }    
            }    
        }    
        return userid.substring(0,userid.length - 1);    
    })()