viewobjectsdaoimpl.java

CRM源码This file describes some issues that should be implemented in future and how it should be imple

            focus.putObject(subFocus.getName(), subFocus);
        }
        rs.close();
        ps.close();
    }

    private void loadTabs(Connection con, SubFocus subFocus) throws SQLException {
        PreparedStatement ps;
        PreparedStatement selectHelplink = sqlWrapper.doPreparedStatement(con, 
                DBRealmManager.getSql("select_helplink"));
        ResultSet helplink;
        ResultSet rs;
        String subFocusName = subFocus.getName();
        ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_all_tabs"));
        ps.setString(1, subFocusName);
        rs = sqlWrapper.executeQuery(ps);
        while(rs.next()) {
            Tab tab = new Tab();
            tab.setSubFocus(subFocusName);
            tab.setName(sqlWrapper.getStringParser().getValue(rs, 1));
            tab.setOrder(sqlWrapper.getIntParser().getValue(rs, 2));
            tab.setInframelinks(
                    sqlWrapper.getIntParser().getValue(rs, 3).intValue() == 0
                            ? Boolean.FALSE : Boolean.TRUE);
            tab.setGrid(
                    sqlWrapper.getIntParser().getValue(rs, 4).intValue() == 0
                            ? Boolean.FALSE : Boolean.TRUE);
            sqlWrapper.getStringParser().setValue(selectHelplink, 1, tab.getName());
            helplink = sqlWrapper.executeQuery(selectHelplink);
            if (helplink.next()) {
                tab.setHelplink(sqlWrapper.getStringParser().getValue(helplink, 1));
            }
            else {
                tab.setHelplink("");
            }
            subFocus.addTab(tab);
            subFocus.putObject(tab.getName(), tab);
        }
        rs.close();
        ps.close();
    }

    private void loadForms(Connection con, Tab tab) throws SQLException {
        PreparedStatement ps;
        ResultSet rs;
        ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_all_forms"));
        ps.setString(1, tab.getName());
        rs = sqlWrapper.executeQuery(ps);
        while(rs.next()) {
            Form form = new Form();
            form.setTab(tab.getName());
            form.setName(sqlWrapper.getStringParser().getValue(rs, 1));
            form.setEntity(sqlWrapper.getStringParser().getValue(rs, 2));
            form.setOrder(sqlWrapper.getIntParser().getValue(rs, 3));
            Integer grid = sqlWrapper.getIntParser().getValue(rs, 4);
            if(grid != null) {
                form.setGrid(grid == 1 ? Boolean.TRUE:Boolean.FALSE);
            }
            Integer defaultactions = sqlWrapper.getIntParser().getValue(rs, 5);
            if(defaultactions != null) {
                form.setDefaultactions(defaultactions == 1 ? Boolean.TRUE : Boolean.FALSE);
            }
            Integer labelsLayout = sqlWrapper.getIntParser().getValue(rs, 6);
            if(labelsLayout != null && labelsLayout == 1) {
                form.setLabelsOrientation(FormLabelsOrientationType.VERTICAL);
            } else {
                form.setLabelsOrientation(FormLabelsOrientationType.HORIZONTAL);
            }
            Integer myqueweb = sqlWrapper.getIntParser().getValue(rs, 7);
            if(myqueweb != null) {
                form.setMyqueweb(myqueweb == 1 ? Boolean.TRUE : Boolean.FALSE);
            }
            Integer autoSearch = sqlWrapper.getIntParser().getValue(rs, 8);
            if(autoSearch != null) {
                form.setAutosearch(autoSearch == 1 ? Boolean.TRUE : Boolean.FALSE);
            }
            loadButtons(con, form);
            loadHtmlElements(con, form);
            loadHeaders(con, form);
            loadRows(con, form);
            loadHiddenControls(con, form);
            loadLinks(con, form);

            tab.addForm(form);
            tab.putObject(form.getName(), form);
        }
        rs.close();
        ps.close();
    }

    private void loadButtons(Connection con, Form form) throws SQLException {
        PreparedStatement ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_button"));
        try {
            sqlWrapper.getStringParser().setValue(ps, 1, form.getName());
            ResultSet rs = sqlWrapper.executeQuery(ps);
            while(rs.next()) {
                Button button = new Button();
                button.setName(sqlWrapper.getStringParser().getValue(rs, 1));
                button.setPermission(loadPermission(sqlWrapper.getIntParser().getValue(rs, 2)));
                EntityHelper.FormHelper.addFormButton(form, button);
            }
        }
        finally {
            ps.close();
        }
    }

    private void loadHtmlElements(Connection con, Form form) throws SQLException {
        PreparedStatement ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_html_element"));
        try {
            sqlWrapper.getStringParser().setValue(ps, 1, form.getName());
            ResultSet rs = sqlWrapper.executeQuery(ps);
            List<Htmlelement> elements = new ArrayList<Htmlelement>();
            while(rs.next()) {
                Htmlelement htmlElement = new Htmlelement();
                htmlElement.setName(sqlWrapper.getStringParser().getValue(rs, 1));
                elements.add(htmlElement);
            }
            if(!elements.isEmpty()){
                Htmlelements htmlElements = form.getHtmlelements();
                if(htmlElements == null)
                    htmlElements = new Htmlelements();
                
                for (Htmlelement element : elements) {
                    htmlElements.addHtmlelement(element);
                }
                
                form.setHtmlelements(htmlElements);
            }
        }
        finally {
            ps.close();
        }
    }

    private void loadHeaders(Connection con, Form form) throws SQLException {
        PreparedStatement ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_header"));
        try {
            sqlWrapper.getStringParser().setValue(ps, 1, form.getName());
            ResultSet rs = sqlWrapper.executeQuery(ps);
            while(rs.next()) {
                Header header = new Header();
                header.setClientwidth(sqlWrapper.getIntParser().getValue(rs, 1));
                EntityHelper.FormHelper.addHeaderIntoLayout(form, header);
            }
        }
        finally {
            ps.close();
        }
    }

    private void loadRows(Connection con, Form form) throws SQLException {
        PreparedStatement rowSt = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_row"));
        PreparedStatement colSt = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_col"));
        try {
            sqlWrapper.getStringParser().setValue(rowSt, 1, form.getName());
            ResultSet rows = sqlWrapper.executeQuery(rowSt);
            while(rows.next()) {
                Row row = new Row();
                row.setOrder(sqlWrapper.getIntParser().getValue(rows, 1));
                sqlWrapper.getStringParser().setValue(colSt, 1, form.getName());
                sqlWrapper.getIntParser().setValue(colSt, 2, row.getOrder());
                ResultSet cols = sqlWrapper.executeQuery(colSt);
                while(cols.next()) {
                    Col col = new Col();
                    String fieldId = sqlWrapper.getStringParser().getValue(cols, 1);
                    col.setFieldid(fieldId != null ? fieldId : "");
                    col.setRowspan(sqlWrapper.getIntParser().getValue(cols, 2));
                    col.setColspan(sqlWrapper.getIntParser().getValue(cols, 3));
                    row.addCol(col);
                }
                EntityHelper.FormHelper.addLayoutRow(form, row);
            }
        }
        finally {
            colSt.close();
            rowSt.close();
        }
    }

    private void loadExternalSets(Connection con, Form form) throws SQLException {
        PreparedStatement ps;
        ResultSet rs;
        ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_external_set"));
        ps.setString(1, form.getName());
        rs = sqlWrapper.executeQuery(ps);
        while(rs.next()) {
            ExternalSet extSet = new ExternalSet();
            extSet.setName(sqlWrapper.getStringParser().getValue(rs, 1));
            form.addExternalSet(extSet);
        }
        rs.close();
        ps.close();
    }

    private void loadExternalForms(Connection con, Form form) throws SQLException {
        PreparedStatement ps;
        ResultSet rs;
        ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_external_form"));
        ps.setString(1, form.getName());
        rs = sqlWrapper.executeQuery(ps);
        while(rs.next()) {
            ExternalForm extForm = new ExternalForm();
            extForm.setName(sqlWrapper.getStringParser().getValue(rs, 1));
            form.addExternalForm(extForm);
        }
        rs.close();
        ps.close();
    }

    private void loadExternalFields(Connection con, Form form) throws SQLException {
        PreparedStatement ps;
        ResultSet rs;
        ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_external_field"));
        ps.setString(1, form.getName());
        rs = sqlWrapper.executeQuery(ps);
        while(rs.next()) {
            ExternalField extField = new ExternalField();
            extField.setForm(sqlWrapper.getStringParser().getValue(rs, 1));
            extField.setName(sqlWrapper.getStringParser().getValue(rs, 2));
            extField.setSourceField(sqlWrapper.getStringParser().getValue(rs, 3));
            form.addExternalField(extField);
        }
        rs.close();
        ps.close();
    }

    private void loadInternalFields(Connection con, Form form) throws SQLException {
        PreparedStatement ps;
        ResultSet rs;
        ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_internal_field"));
        ps.setString(1, form.getName());
        rs = sqlWrapper.executeQuery(ps);
        while(rs.next()) {
            InternalField intField = new InternalField();
            intField.setForm(sqlWrapper.getStringParser().getValue(rs, 1));
            intField.setName(sqlWrapper.getStringParser().getValue(rs, 2));
            form.addInternalField(intField);
        }
        rs.close();
        ps.close();
    }

    private void loadLinkedDatasets(Connection con, Form form) throws SQLException {
        PreparedStatement ps;
        ResultSet rs;
        ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_linked_datasource"));
        ps.setString(1, form.getName());
        rs = sqlWrapper.executeQuery(ps);
        while(rs.next()) {
            LinkedDataset linkedDataset = new LinkedDataset();
            linkedDataset.setForm(sqlWrapper.getStringParser().getValue(rs, 1));
            linkedDataset.setName(sqlWrapper.getStringParser().getValue(rs, 2));
            form.addLinkedDataset(linkedDataset);
        }
        rs.close();
        ps.close();
    }

    private void loadHiddenControls(Connection con, Form form) throws SQLException {
        PreparedStatement ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_hiddencontrol"));
        ResultSet rs;
        try {
            sqlWrapper.getStringParser().setValue(ps, 1, form.getName());
            rs = sqlWrapper.executeQuery(ps);
            while(rs.next()) {
                HiddenControl hiddenControl = new HiddenControl();
                hiddenControl.setFieldid(sqlWrapper.getStringParser().getValue(rs, 1));
                EntityHelper.FormHelper.addHiddenControl(form, hiddenControl);
            }
        }
        finally {
            ps.close();
        }
    }

    private void saveLinks(Connection con, Form form) throws SQLException {
        Link[] links = EntityHelper.FormHelper.getFormLinks(form);
        if(links.length != 0) {
            PreparedStatement ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("insert_link"));
            try {
                for(Link link : links) {
                    sqlWrapper.getStringParser().setValue(ps, 1, form.getName());
                    sqlWrapper.getStringParser().setValue(ps, 2, link.getField());
                    sqlWrapper.getStringParser().setValue(ps, 3, link.getForm());
                    sqlWrapper.executeUpdate(ps);
                }
            }
            finally {
                ps.close();
            }
        }
    }

    private void loadLinks(Connection con, Form form) throws SQLException {
        PreparedStatement ps = sqlWrapper.doPreparedStatement(con, DBRealmManager.getSql("select_link"));
        try {
            sqlWrapper.getStringParser().setValue(ps, 1, form.getName());
            ResultSet rs = sqlWrapper.executeQuery(ps);
            while(rs.next()) {
                Link link = new Link();
                link.setField(sqlWrapper.getStringParser().getValue(rs, 1));
                link.setForm(sqlWrapper.getStringParser().getValue(rs, 2));
                EntityHelper.FormHelper.addFormLink(form, link);
            }
        }
        finally {
            ps.close();
        }
    }

    private PermissionsType loadPermission(int permissionType) {
        switch(permissionType) {
            case PermissionsType.READ_TYPE:
                return PermissionsType.READ;
            case PermissionsType.WRITE_TYPE:
                return PermissionsType.WRITE;
            case PermissionsType.OWNER_TYPE:
                return PermissionsType.OWNER;
            case PermissionsType.FULLCONTROL_TYPE:
                return PermissionsType.FULLCONTROL;
        }
        return PermissionsType.READ;
    }
}