泛微OA根据value获取下拉框的显示值

 

• 代码如下，主要是看里面的SQL：
• b.id  为workflowid
• f.fieldname 为流程里的表单字段名称

    private  static String  getSelectName(String selectValeu){
        if (selectValeu==null && org.apache.commons.lang3.StringUtils.isBlank(selectValeu)){
            return "";
        }

        RecordSet rs = new RecordSet();
        rs.execute("select S.selectname from workflow_base B, workflow_billfield F, workflow_SelectItem S where B.Formid = F.Billid and F.Id = S.Fieldid and B.id = 2843 " +
                "and F.Fieldname = 'gn' and S.Selectvalue = '" + selectValeu+"'");
        rs.next();
        String select = rs.getString("selectname");
        return select;
    }