private AttributesImpl createProcessBinding(AttributesImpl atts, X_AD_Process m_Process) { String sql = null; String name = null; atts.clear(); if (m_Process.getAD_Process_ID() <= PackOut.MAX_OFFICIAL_ID) atts.addAttribute( "", "", "AD_Process_ID", "CDATA", Integer.toString(m_Process.getAD_Process_ID())); atts.addAttribute( "", "", "Name", "CDATA", (m_Process.getName() != null ? m_Process.getName() : "")); if (m_Process.getAD_Workflow_ID() > 0) { sql = "SELECT Name FROM AD_Workflow WHERE AD_Workflow_ID=?"; name = DB.getSQLValueString(null, sql, m_Process.getAD_Workflow_ID()); atts.addAttribute("", "", "ADWorkflowNameID", "CDATA", name); } else atts.addAttribute("", "", "ADWorkflowNameID", "CDATA", ""); if (m_Process.getAD_Process_ID() > 0) { sql = "SELECT Name FROM AD_Process WHERE AD_Process_ID=?"; name = DB.getSQLValueString(null, sql, m_Process.getAD_Process_ID()); atts.addAttribute("", "", "ADProcessNameID", "CDATA", name); } else atts.addAttribute("", "", "ADProcessNameID", "CDATA", ""); if (m_Process.getAD_PrintFormat_ID() > 0) { sql = "SELECT Name FROM AD_PrintFormat WHERE AD_PrintFormat_ID=?"; name = DB.getSQLValueString(null, sql, m_Process.getAD_PrintFormat_ID()); atts.addAttribute("", "", "ADPrintFormatNameID", "CDATA", name); } else atts.addAttribute("", "", "ADPrintFormatNameID", "CDATA", ""); if (m_Process.getAD_ReportView_ID() > 0) { sql = "SELECT Name FROM AD_ReportView WHERE AD_ReportView_ID=?"; name = DB.getSQLValueString(null, sql, m_Process.getAD_ReportView_ID()); atts.addAttribute("", "", "ADReportViewNameID", "CDATA", name); } else atts.addAttribute("", "", "ADReportViewNameID", "CDATA", ""); if (m_Process.getAD_Form_ID() > 0) { sql = "SELECT Name FROM AD_Form WHERE AD_Form_ID=?"; name = DB.getSQLValueString(null, sql, m_Process.getAD_Form_ID()); atts.addAttribute("", "", "ADFormNameID", "CDATA", name); } else atts.addAttribute("", "", "ADFormNameID", "CDATA", ""); if (m_Process.getAD_Browse_ID() > 0) { sql = "SELECT Name FROM AD_Browse WHERE AD_Browse_ID=?"; name = DB.getSQLValueString(null, sql, m_Process.getAD_Browse_ID()); atts.addAttribute("", "", "ADBrowseNameID", "CDATA", name); } else atts.addAttribute("", "", "ADBrowseNameID", "CDATA", ""); atts.addAttribute( "", "", "AccessLevel", "CDATA", (m_Process.getAccessLevel() != null ? m_Process.getAccessLevel() : "")); atts.addAttribute( "", "", "Classname", "CDATA", (m_Process.getClassname() != null ? m_Process.getClassname() : "")); atts.addAttribute( "", "", "Description", "CDATA", (m_Process.getDescription() != null ? m_Process.getDescription() : "")); atts.addAttribute( "", "", "EntityType", "CDATA", (m_Process.getEntityType() != null ? m_Process.getEntityType() : "")); atts.addAttribute( "", "", "Help", "CDATA", (m_Process.getHelp() != null ? m_Process.getHelp() : "")); atts.addAttribute( "", "", "isBetaFunctionality", "CDATA", (m_Process.isBetaFunctionality() == true ? "true" : "false")); atts.addAttribute( "", "", "isDirectPrint", "CDATA", (m_Process.isDirectPrint() == true ? "true" : "false")); atts.addAttribute( "", "", "isReport", "CDATA", (m_Process.isReport() == true ? "true" : "false")); atts.addAttribute( "", "", "isActive", "CDATA", (m_Process.isActive() == true ? "true" : "false")); atts.addAttribute( "", "", "ProcedureName", "CDATA", (m_Process.getProcedureName() != null ? m_Process.getProcedureName() : "")); atts.addAttribute("", "", "StatisticCount", "CDATA", "0"); atts.addAttribute("", "", "StatisticSeconds", "CDATA", "0"); atts.addAttribute( "", "", "Value", "CDATA", (m_Process.getValue() != null ? m_Process.getValue() : "")); atts.addAttribute( "", "", "WorkflowValue", "CDATA", (m_Process.getWorkflowValue() != null ? m_Process.getWorkflowValue() : "")); atts.addAttribute( "", "", "ShowHelp", "CDATA", (m_Process.getShowHelp() != null ? m_Process.getShowHelp() : "")); atts.addAttribute( "", "", "JasperReport", "CDATA", (m_Process.getJasperReport() != null ? m_Process.getJasperReport() : "")); return atts; }