public static ResultSet getHallSchemaNC(Connection conn, Map<String, String> params) throws SQLException, InvalidParameterException {
        PreparedStatement sp = null;
        try {
            sp = conn.prepareStatement("exec dbo.Wga_GetHallSchemaNC ?, ?, ?");
            if ((params.get(IDHALL) != null) && (!"null".equalsIgnoreCase(params.get(IDHALL)))) {
                sp.setInt(1, Integer.parseInt(params.get(IDHALL)));
            } else {
                sp.setNull(1, java.sql.Types.INTEGER);
            }
            if ((params.get(IDPERFORMANCE) != null) && (!"null".equalsIgnoreCase(params.get(IDPERFORMANCE)))) {
                sp.setInt(2, Integer.parseInt(params.get(IDPERFORMANCE)));
            } else {
                sp.setNull(2, java.sql.Types.INTEGER);
            }
            if ((params.get(IDPRICECATEGORY) != null) && (!"null".equalsIgnoreCase(IDPRICECATEGORY))) {
                sp.setInt(3, Integer.parseInt(params.get(IDPRICECATEGORY)));
            } else {
                sp.setNull(3, java.sql.Types.INTEGER);
            }
            return sp.executeQuery();
        } finally {
            if (sp != null) {
                sp.close();
            }
        }
    }