private static void ProcessSqlNode(BaseFormatterState state, XmlElement contentElement)
        {
            if (contentElement.GetAttribute(SqlXmlConstants.ANAME_HASERROR) == "1")
                state.OpenClass(SqlHtmlConstants.CLASS_ERRORHIGHLIGHT);

            switch (contentElement.Name)
            {
                case SqlXmlConstants.ENAME_DDLDETAIL_PARENS:
                case SqlXmlConstants.ENAME_DDL_PARENS:
				case SqlXmlConstants.ENAME_FUNCTION_PARENS:
				case SqlXmlConstants.ENAME_IN_PARENS:
				case SqlXmlConstants.ENAME_EXPRESSION_PARENS:
                case SqlXmlConstants.ENAME_SELECTIONTARGET_PARENS:
                    state.AddOutputContent("(");
                    ProcessSqlNodeList(state, contentElement.SelectNodes("*"));
                    state.AddOutputContent(")");
                    break;

                case SqlXmlConstants.ENAME_SQL_ROOT:
                case SqlXmlConstants.ENAME_SQL_STATEMENT:
                case SqlXmlConstants.ENAME_SQL_CLAUSE:
                case SqlXmlConstants.ENAME_BOOLEAN_EXPRESSION:
                case SqlXmlConstants.ENAME_DDL_PROCEDURAL_BLOCK:
                case SqlXmlConstants.ENAME_DDL_OTHER_BLOCK:
                case SqlXmlConstants.ENAME_DDL_DECLARE_BLOCK:
                case SqlXmlConstants.ENAME_CURSOR_DECLARATION:
                case SqlXmlConstants.ENAME_BEGIN_END_BLOCK:
                case SqlXmlConstants.ENAME_TRY_BLOCK:
                case SqlXmlConstants.ENAME_CATCH_BLOCK:
                case SqlXmlConstants.ENAME_CASE_STATEMENT:
                case SqlXmlConstants.ENAME_CASE_INPUT:
                case SqlXmlConstants.ENAME_CASE_WHEN:
                case SqlXmlConstants.ENAME_CASE_THEN:
                case SqlXmlConstants.ENAME_CASE_ELSE:
                case SqlXmlConstants.ENAME_IF_STATEMENT:
                case SqlXmlConstants.ENAME_ELSE_CLAUSE:
                case SqlXmlConstants.ENAME_WHILE_LOOP:
                case SqlXmlConstants.ENAME_DDL_AS_BLOCK:
                case SqlXmlConstants.ENAME_BETWEEN_CONDITION:
                case SqlXmlConstants.ENAME_BETWEEN_LOWERBOUND:
                case SqlXmlConstants.ENAME_BETWEEN_UPPERBOUND:
                case SqlXmlConstants.ENAME_CTE_WITH_CLAUSE:
                case SqlXmlConstants.ENAME_CTE_ALIAS:
                case SqlXmlConstants.ENAME_CTE_AS_BLOCK:
                case SqlXmlConstants.ENAME_CURSOR_FOR_BLOCK:
                case SqlXmlConstants.ENAME_CURSOR_FOR_OPTIONS:
                case SqlXmlConstants.ENAME_TRIGGER_CONDITION:
                case SqlXmlConstants.ENAME_COMPOUNDKEYWORD:
                case SqlXmlConstants.ENAME_BEGIN_TRANSACTION:
                case SqlXmlConstants.ENAME_ROLLBACK_TRANSACTION:
                case SqlXmlConstants.ENAME_SAVE_TRANSACTION:
                case SqlXmlConstants.ENAME_COMMIT_TRANSACTION:
                case SqlXmlConstants.ENAME_BATCH_SEPARATOR:
                case SqlXmlConstants.ENAME_SET_OPERATOR_CLAUSE:
                case SqlXmlConstants.ENAME_CONTAINER_OPEN:
                case SqlXmlConstants.ENAME_CONTAINER_MULTISTATEMENT:
                case SqlXmlConstants.ENAME_CONTAINER_SINGLESTATEMENT:
                case SqlXmlConstants.ENAME_CONTAINER_GENERALCONTENT:
                case SqlXmlConstants.ENAME_CONTAINER_CLOSE:
                case SqlXmlConstants.ENAME_SELECTIONTARGET:
                case SqlXmlConstants.ENAME_PERMISSIONS_BLOCK:
                case SqlXmlConstants.ENAME_PERMISSIONS_DETAIL:
                case SqlXmlConstants.ENAME_PERMISSIONS_TARGET:
                case SqlXmlConstants.ENAME_PERMISSIONS_RECIPIENT:
                case SqlXmlConstants.ENAME_DDL_WITH_CLAUSE:
                case SqlXmlConstants.ENAME_MERGE_CLAUSE:
                case SqlXmlConstants.ENAME_MERGE_TARGET:
                case SqlXmlConstants.ENAME_MERGE_USING:
                case SqlXmlConstants.ENAME_MERGE_CONDITION:
                case SqlXmlConstants.ENAME_MERGE_WHEN:
                case SqlXmlConstants.ENAME_MERGE_THEN:
                case SqlXmlConstants.ENAME_MERGE_ACTION:
                case SqlXmlConstants.ENAME_JOIN_ON_SECTION:
                    foreach (XmlNode childNode in contentElement.ChildNodes)
                    {
                        switch (childNode.NodeType)
                        {
                            case XmlNodeType.Element:
                                ProcessSqlNode(state, (XmlElement)childNode);
                                break;
                            case XmlNodeType.Text:
                            case XmlNodeType.Comment:
                                //ignore; valid text is in appropriate containers, displayable T-SQL comments are elements.
                                break;
                            default:
                                throw new Exception("Unexpected xml node type encountered!");
                        }
                    }
                    break;

                case SqlXmlConstants.ENAME_COMMENT_MULTILINE:
                    state.AddOutputContent("/*" + contentElement.InnerText + "*/", Interfaces.SqlHtmlConstants.CLASS_COMMENT);
                    break;
                case SqlXmlConstants.ENAME_COMMENT_SINGLELINE:
                    state.AddOutputContent("--" + contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_COMMENT);
                    break;
                case SqlXmlConstants.ENAME_COMMENT_SINGLELINE_CSTYLE:
                    state.AddOutputContent("//" + contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_COMMENT);
                    break;
                case SqlXmlConstants.ENAME_STRING:
                    state.AddOutputContent("'" + contentElement.InnerText.Replace("'", "''") + "'", Interfaces.SqlHtmlConstants.CLASS_STRING);
                    break;
                case SqlXmlConstants.ENAME_NSTRING:
                    state.AddOutputContent("N'" + contentElement.InnerText.Replace("'", "''") + "'", Interfaces.SqlHtmlConstants.CLASS_STRING);
                    break;
                case SqlXmlConstants.ENAME_QUOTED_STRING:
                    state.AddOutputContent("\"" + contentElement.InnerText.Replace("\"", "\"\"") + "\"");
                    break;
                case SqlXmlConstants.ENAME_BRACKET_QUOTED_NAME:
                    state.AddOutputContent("[" + contentElement.InnerText.Replace("]", "]]") + "]");
                    break;

                case SqlXmlConstants.ENAME_COMMA:
                case SqlXmlConstants.ENAME_PERIOD:
                case SqlXmlConstants.ENAME_SEMICOLON:
                case SqlXmlConstants.ENAME_ASTERISK:
                case SqlXmlConstants.ENAME_EQUALSSIGN:
                case SqlXmlConstants.ENAME_SCOPERESOLUTIONOPERATOR:
                case SqlXmlConstants.ENAME_AND_OPERATOR:
                case SqlXmlConstants.ENAME_OR_OPERATOR:
                case SqlXmlConstants.ENAME_ALPHAOPERATOR:
                case SqlXmlConstants.ENAME_OTHEROPERATOR:
                    state.AddOutputContent(contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_OPERATOR);
                    break;

                case SqlXmlConstants.ENAME_FUNCTION_KEYWORD:
                    state.AddOutputContent(contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_FUNCTION);
                    break;

                case SqlXmlConstants.ENAME_OTHERKEYWORD:
                case SqlXmlConstants.ENAME_DATATYPE_KEYWORD:
                case SqlXmlConstants.ENAME_DDL_RETURNS:
                case SqlXmlConstants.ENAME_PSEUDONAME:
                    state.AddOutputContent(contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_KEYWORD);
                    break;

                case SqlXmlConstants.ENAME_OTHERNODE:
                case SqlXmlConstants.ENAME_WHITESPACE:
                case SqlXmlConstants.ENAME_NUMBER_VALUE:
                case SqlXmlConstants.ENAME_MONETARY_VALUE:
                case SqlXmlConstants.ENAME_BINARY_VALUE:
                case SqlXmlConstants.ENAME_LABEL:
                    state.AddOutputContent(contentElement.InnerText);
                    break;
                default:
                    throw new Exception("Unrecognized element in SQL Xml!");
            }

            if (contentElement.GetAttribute(SqlXmlConstants.ANAME_HASERROR) == "1")
                state.CloseClass();
        }
        private static void ProcessSqlNode(BaseFormatterState state, XmlElement contentElement)
        {
            if (contentElement.GetAttribute(SqlXmlConstants.ANAME_HASERROR) == "1")
            {
                state.OpenClass(SqlHtmlConstants.CLASS_ERRORHIGHLIGHT);
            }

            switch (contentElement.Name)
            {
            case SqlXmlConstants.ENAME_DDLDETAIL_PARENS:
            case SqlXmlConstants.ENAME_DDL_PARENS:
            case SqlXmlConstants.ENAME_FUNCTION_PARENS:
            case SqlXmlConstants.ENAME_IN_PARENS:
            case SqlXmlConstants.ENAME_EXPRESSION_PARENS:
            case SqlXmlConstants.ENAME_SELECTIONTARGET_PARENS:
                state.AddOutputContent("(");
                ProcessSqlNodeList(state, contentElement.SelectNodes("*"));
                state.AddOutputContent(")");
                break;

            case SqlXmlConstants.ENAME_SQL_ROOT:
            case SqlXmlConstants.ENAME_SQL_STATEMENT:
            case SqlXmlConstants.ENAME_SQL_CLAUSE:
            case SqlXmlConstants.ENAME_BOOLEAN_EXPRESSION:
            case SqlXmlConstants.ENAME_DDL_PROCEDURAL_BLOCK:
            case SqlXmlConstants.ENAME_DDL_OTHER_BLOCK:
            case SqlXmlConstants.ENAME_DDL_DECLARE_BLOCK:
            case SqlXmlConstants.ENAME_CURSOR_DECLARATION:
            case SqlXmlConstants.ENAME_BEGIN_END_BLOCK:
            case SqlXmlConstants.ENAME_TRY_BLOCK:
            case SqlXmlConstants.ENAME_CATCH_BLOCK:
            case SqlXmlConstants.ENAME_CASE_STATEMENT:
            case SqlXmlConstants.ENAME_CASE_INPUT:
            case SqlXmlConstants.ENAME_CASE_WHEN:
            case SqlXmlConstants.ENAME_CASE_THEN:
            case SqlXmlConstants.ENAME_CASE_ELSE:
            case SqlXmlConstants.ENAME_IF_STATEMENT:
            case SqlXmlConstants.ENAME_ELSE_CLAUSE:
            case SqlXmlConstants.ENAME_WHILE_LOOP:
            case SqlXmlConstants.ENAME_DDL_AS_BLOCK:
            case SqlXmlConstants.ENAME_BETWEEN_CONDITION:
            case SqlXmlConstants.ENAME_BETWEEN_LOWERBOUND:
            case SqlXmlConstants.ENAME_BETWEEN_UPPERBOUND:
            case SqlXmlConstants.ENAME_CTE_WITH_CLAUSE:
            case SqlXmlConstants.ENAME_CTE_ALIAS:
            case SqlXmlConstants.ENAME_CTE_AS_BLOCK:
            case SqlXmlConstants.ENAME_CURSOR_FOR_BLOCK:
            case SqlXmlConstants.ENAME_CURSOR_FOR_OPTIONS:
            case SqlXmlConstants.ENAME_TRIGGER_CONDITION:
            case SqlXmlConstants.ENAME_COMPOUNDKEYWORD:
            case SqlXmlConstants.ENAME_BEGIN_TRANSACTION:
            case SqlXmlConstants.ENAME_ROLLBACK_TRANSACTION:
            case SqlXmlConstants.ENAME_SAVE_TRANSACTION:
            case SqlXmlConstants.ENAME_COMMIT_TRANSACTION:
            case SqlXmlConstants.ENAME_BATCH_SEPARATOR:
            case SqlXmlConstants.ENAME_SET_OPERATOR_CLAUSE:
            case SqlXmlConstants.ENAME_CONTAINER_OPEN:
            case SqlXmlConstants.ENAME_CONTAINER_MULTISTATEMENT:
            case SqlXmlConstants.ENAME_CONTAINER_SINGLESTATEMENT:
            case SqlXmlConstants.ENAME_CONTAINER_GENERALCONTENT:
            case SqlXmlConstants.ENAME_CONTAINER_CLOSE:
            case SqlXmlConstants.ENAME_SELECTIONTARGET:
            case SqlXmlConstants.ENAME_PERMISSIONS_BLOCK:
            case SqlXmlConstants.ENAME_PERMISSIONS_DETAIL:
            case SqlXmlConstants.ENAME_PERMISSIONS_TARGET:
            case SqlXmlConstants.ENAME_PERMISSIONS_RECIPIENT:
            case SqlXmlConstants.ENAME_DDL_WITH_CLAUSE:
            case SqlXmlConstants.ENAME_MERGE_CLAUSE:
            case SqlXmlConstants.ENAME_MERGE_TARGET:
            case SqlXmlConstants.ENAME_MERGE_USING:
            case SqlXmlConstants.ENAME_MERGE_CONDITION:
            case SqlXmlConstants.ENAME_MERGE_WHEN:
            case SqlXmlConstants.ENAME_MERGE_THEN:
            case SqlXmlConstants.ENAME_MERGE_ACTION:
            case SqlXmlConstants.ENAME_JOIN_ON_SECTION:
                foreach (XmlNode childNode in contentElement.ChildNodes)
                {
                    switch (childNode.NodeType)
                    {
                    case XmlNodeType.Element:
                        ProcessSqlNode(state, (XmlElement)childNode);
                        break;

                    case XmlNodeType.Text:
                    case XmlNodeType.Comment:
                        //ignore; valid text is in appropriate containers, displayable T-SQL comments are elements.
                        break;

                    default:
                        throw new Exception("Unexpected xml node type encountered!");
                    }
                }
                break;

            case SqlXmlConstants.ENAME_COMMENT_MULTILINE:
                state.AddOutputContent("/*" + contentElement.InnerText + "*/", Interfaces.SqlHtmlConstants.CLASS_COMMENT);
                break;

            case SqlXmlConstants.ENAME_COMMENT_SINGLELINE:
                state.AddOutputContent("--" + contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_COMMENT);
                break;

            case SqlXmlConstants.ENAME_COMMENT_SINGLELINE_CSTYLE:
                state.AddOutputContent("//" + contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_COMMENT);
                break;

            case SqlXmlConstants.ENAME_STRING:
                state.AddOutputContent("'" + contentElement.InnerText.Replace("'", "''") + "'", Interfaces.SqlHtmlConstants.CLASS_STRING);
                break;

            case SqlXmlConstants.ENAME_NSTRING:
                state.AddOutputContent("N'" + contentElement.InnerText.Replace("'", "''") + "'", Interfaces.SqlHtmlConstants.CLASS_STRING);
                break;

            case SqlXmlConstants.ENAME_QUOTED_STRING:
                state.AddOutputContent("\"" + contentElement.InnerText.Replace("\"", "\"\"") + "\"");
                break;

            case SqlXmlConstants.ENAME_BRACKET_QUOTED_NAME:
                state.AddOutputContent("[" + contentElement.InnerText.Replace("]", "]]") + "]");
                break;

            case SqlXmlConstants.ENAME_COMMA:
            case SqlXmlConstants.ENAME_PERIOD:
            case SqlXmlConstants.ENAME_SEMICOLON:
            case SqlXmlConstants.ENAME_ASTERISK:
            case SqlXmlConstants.ENAME_EQUALSSIGN:
            case SqlXmlConstants.ENAME_SCOPERESOLUTIONOPERATOR:
            case SqlXmlConstants.ENAME_AND_OPERATOR:
            case SqlXmlConstants.ENAME_OR_OPERATOR:
            case SqlXmlConstants.ENAME_ALPHAOPERATOR:
            case SqlXmlConstants.ENAME_OTHEROPERATOR:
                state.AddOutputContent(contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_OPERATOR);
                break;

            case SqlXmlConstants.ENAME_FUNCTION_KEYWORD:
                state.AddOutputContent(contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_FUNCTION);
                break;

            case SqlXmlConstants.ENAME_OTHERKEYWORD:
            case SqlXmlConstants.ENAME_DATATYPE_KEYWORD:
            case SqlXmlConstants.ENAME_DDL_RETURNS:
            case SqlXmlConstants.ENAME_PSEUDONAME:
                state.AddOutputContent(contentElement.InnerText, Interfaces.SqlHtmlConstants.CLASS_KEYWORD);
                break;

            case SqlXmlConstants.ENAME_OTHERNODE:
            case SqlXmlConstants.ENAME_WHITESPACE:
            case SqlXmlConstants.ENAME_NUMBER_VALUE:
            case SqlXmlConstants.ENAME_MONETARY_VALUE:
            case SqlXmlConstants.ENAME_BINARY_VALUE:
            case SqlXmlConstants.ENAME_LABEL:
                state.AddOutputContent(contentElement.InnerText);
                break;

            default:
                throw new Exception("Unrecognized element in SQL Xml!");
            }

            if (contentElement.GetAttribute(SqlXmlConstants.ANAME_HASERROR) == "1")
            {
                state.CloseClass();
            }
        }
Esempio n. 3
0
        private static void ProcessSqlNode(BaseFormatterState state, Node contentElement)
        {
            if (contentElement.GetAttributeValue(SqlStructureConstants.ANAME_HASERROR) == "1")
            {
                state.OpenClass(SqlHtmlConstants.CLASS_ERRORHIGHLIGHT);
            }

            switch (contentElement.Name)
            {
            case SqlStructureConstants.ENAME_DDLDETAIL_PARENS:
            case SqlStructureConstants.ENAME_DDL_PARENS:
            case SqlStructureConstants.ENAME_FUNCTION_PARENS:
            case SqlStructureConstants.ENAME_IN_PARENS:
            case SqlStructureConstants.ENAME_EXPRESSION_PARENS:
            case SqlStructureConstants.ENAME_SELECTIONTARGET_PARENS:
                state.AddOutputContent("(");
                ProcessSqlNodeList(contentElement.Children, state);
                state.AddOutputContent(")");
                break;

            case SqlStructureConstants.ENAME_SQL_ROOT:
            case SqlStructureConstants.ENAME_SQL_STATEMENT:
            case SqlStructureConstants.ENAME_SQL_CLAUSE:
            case SqlStructureConstants.ENAME_BOOLEAN_EXPRESSION:
            case SqlStructureConstants.ENAME_DDL_PROCEDURAL_BLOCK:
            case SqlStructureConstants.ENAME_DDL_OTHER_BLOCK:
            case SqlStructureConstants.ENAME_DDL_DECLARE_BLOCK:
            case SqlStructureConstants.ENAME_CURSOR_DECLARATION:
            case SqlStructureConstants.ENAME_BEGIN_END_BLOCK:
            case SqlStructureConstants.ENAME_TRY_BLOCK:
            case SqlStructureConstants.ENAME_CATCH_BLOCK:
            case SqlStructureConstants.ENAME_CASE_STATEMENT:
            case SqlStructureConstants.ENAME_CASE_INPUT:
            case SqlStructureConstants.ENAME_CASE_WHEN:
            case SqlStructureConstants.ENAME_CASE_THEN:
            case SqlStructureConstants.ENAME_CASE_ELSE:
            case SqlStructureConstants.ENAME_IF_STATEMENT:
            case SqlStructureConstants.ENAME_ELSE_CLAUSE:
            case SqlStructureConstants.ENAME_WHILE_LOOP:
            case SqlStructureConstants.ENAME_DDL_AS_BLOCK:
            case SqlStructureConstants.ENAME_BETWEEN_CONDITION:
            case SqlStructureConstants.ENAME_BETWEEN_LOWERBOUND:
            case SqlStructureConstants.ENAME_BETWEEN_UPPERBOUND:
            case SqlStructureConstants.ENAME_CTE_WITH_CLAUSE:
            case SqlStructureConstants.ENAME_CTE_ALIAS:
            case SqlStructureConstants.ENAME_CTE_AS_BLOCK:
            case SqlStructureConstants.ENAME_CURSOR_FOR_BLOCK:
            case SqlStructureConstants.ENAME_CURSOR_FOR_OPTIONS:
            case SqlStructureConstants.ENAME_TRIGGER_CONDITION:
            case SqlStructureConstants.ENAME_COMPOUNDKEYWORD:
            case SqlStructureConstants.ENAME_BEGIN_TRANSACTION:
            case SqlStructureConstants.ENAME_ROLLBACK_TRANSACTION:
            case SqlStructureConstants.ENAME_SAVE_TRANSACTION:
            case SqlStructureConstants.ENAME_COMMIT_TRANSACTION:
            case SqlStructureConstants.ENAME_BATCH_SEPARATOR:
            case SqlStructureConstants.ENAME_SET_OPERATOR_CLAUSE:
            case SqlStructureConstants.ENAME_CONTAINER_OPEN:
            case SqlStructureConstants.ENAME_CONTAINER_MULTISTATEMENT:
            case SqlStructureConstants.ENAME_CONTAINER_SINGLESTATEMENT:
            case SqlStructureConstants.ENAME_CONTAINER_GENERALCONTENT:
            case SqlStructureConstants.ENAME_CONTAINER_CLOSE:
            case SqlStructureConstants.ENAME_SELECTIONTARGET:
            case SqlStructureConstants.ENAME_PERMISSIONS_BLOCK:
            case SqlStructureConstants.ENAME_PERMISSIONS_DETAIL:
            case SqlStructureConstants.ENAME_PERMISSIONS_TARGET:
            case SqlStructureConstants.ENAME_PERMISSIONS_RECIPIENT:
            case SqlStructureConstants.ENAME_DDL_WITH_CLAUSE:
            case SqlStructureConstants.ENAME_MERGE_CLAUSE:
            case SqlStructureConstants.ENAME_MERGE_TARGET:
            case SqlStructureConstants.ENAME_MERGE_USING:
            case SqlStructureConstants.ENAME_MERGE_CONDITION:
            case SqlStructureConstants.ENAME_MERGE_WHEN:
            case SqlStructureConstants.ENAME_MERGE_THEN:
            case SqlStructureConstants.ENAME_MERGE_ACTION:
            case SqlStructureConstants.ENAME_JOIN_ON_SECTION:
            case SqlStructureConstants.ENAME_DDL_RETURNS:
                foreach (Node childNode in contentElement.Children)
                {
                    ProcessSqlNode(state, childNode);
                }
                break;

            case SqlStructureConstants.ENAME_COMMENT_MULTILINE:
                state.AddOutputContent("/*" + contentElement.TextValue + "*/", SqlHtmlConstants.CLASS_COMMENT);
                break;

            case SqlStructureConstants.ENAME_COMMENT_SINGLELINE:
                state.AddOutputContent("--" + contentElement.TextValue, SqlHtmlConstants.CLASS_COMMENT);
                break;

            case SqlStructureConstants.ENAME_COMMENT_SINGLELINE_CSTYLE:
                state.AddOutputContent("//" + contentElement.TextValue, SqlHtmlConstants.CLASS_COMMENT);
                break;

            case SqlStructureConstants.ENAME_STRING:
                state.AddOutputContent("'" + contentElement.TextValue.Replace("'", "''") + "'", SqlHtmlConstants.CLASS_STRING);
                break;

            case SqlStructureConstants.ENAME_NSTRING:
                state.AddOutputContent("N'" + contentElement.TextValue.Replace("'", "''") + "'", SqlHtmlConstants.CLASS_STRING);
                break;

            case SqlStructureConstants.ENAME_QUOTED_STRING:
                state.AddOutputContent("\"" + contentElement.TextValue.Replace("\"", "\"\"") + "\"");
                break;

            case SqlStructureConstants.ENAME_BRACKET_QUOTED_NAME:
                state.AddOutputContent("[" + contentElement.TextValue.Replace("]", "]]") + "]");
                break;

            case SqlStructureConstants.ENAME_COMMA:
            case SqlStructureConstants.ENAME_PERIOD:
            case SqlStructureConstants.ENAME_SEMICOLON:
            case SqlStructureConstants.ENAME_ASTERISK:
            case SqlStructureConstants.ENAME_EQUALSSIGN:
            case SqlStructureConstants.ENAME_SCOPERESOLUTIONOPERATOR:
            case SqlStructureConstants.ENAME_ALPHAOPERATOR:
            case SqlStructureConstants.ENAME_OTHEROPERATOR:
                state.AddOutputContent(contentElement.TextValue, SqlHtmlConstants.CLASS_OPERATOR);
                break;

            case SqlStructureConstants.ENAME_AND_OPERATOR:
            case SqlStructureConstants.ENAME_OR_OPERATOR:
                state.AddOutputContent(contentElement.ChildByName(SqlStructureConstants.ENAME_OTHERKEYWORD).TextValue, SqlHtmlConstants.CLASS_OPERATOR);
                break;

            case SqlStructureConstants.ENAME_FUNCTION_KEYWORD:
                state.AddOutputContent(contentElement.TextValue, SqlHtmlConstants.CLASS_FUNCTION);
                break;

            case SqlStructureConstants.ENAME_OTHERKEYWORD:
            case SqlStructureConstants.ENAME_DATATYPE_KEYWORD:
            case SqlStructureConstants.ENAME_PSEUDONAME:
                state.AddOutputContent(contentElement.TextValue, SqlHtmlConstants.CLASS_KEYWORD);
                break;

            case SqlStructureConstants.ENAME_OTHERNODE:
            case SqlStructureConstants.ENAME_WHITESPACE:
            case SqlStructureConstants.ENAME_NUMBER_VALUE:
            case SqlStructureConstants.ENAME_MONETARY_VALUE:
            case SqlStructureConstants.ENAME_BINARY_VALUE:
            case SqlStructureConstants.ENAME_LABEL:
                state.AddOutputContent(contentElement.TextValue);
                break;

            default:
                throw new Exception("Unrecognized element in SQL Xml!");
            }

            if (contentElement.GetAttributeValue(SqlStructureConstants.ANAME_HASERROR) == "1")
            {
                state.CloseClass();
            }
        }