public Form1()

{

InitializeComponent();

Init();

}

#region 初始化配置

ISqlTokenizer _tokenizer;

ISqlTokenParser _parser;

ISqlTreeFormatter _formatter;

public void Init()

{

    chk_default.Checked = true;

    _tokenizer = new BaiSqlFormatLib.Tokenizers.TSqlStandardTokenizer();

    _parser = new BaiSqlFormatLib.Parsers.TSqlStandardParser();

}

#endregion

#region 格式化

private void textBox1_KeyDown(object sender, KeyEventArgs e)

{

    if (e.KeyData == Keys.F6)

    {

        txt_format.DocumentText = Format(txt_sql.Text);

    }

}

private string Format(string inputSql)

{

    SetFormatter();

    var tokenizedSql = _tokenizer.TokenizeSQL(inputSql, inputSql.Length);

    var parsedSql = _parser.ParseSQL(tokenizedSql);

    string subSqlHtml = _formatter.FormatSQLTree(parsedSql);

    return subSqlHtml;

}

/// <summary>

/// 設(shè)置格式化屬性

/// </summary>

private void SetFormatter()

{

ISqlTreeFormatter innerFormatter = new BaiSqlFormatLib.Formatters.TSqlStandardFormatter(new BaiSqlFormatLib.Formatters.TsqlStandardFormatterOptions{

        IndentString = "\\s\\s\\s\\s", //縮進(jìn)內(nèi)容

        SpacesPerTab = 4,

        MaxLineWidth = Convert.ToInt32(txt_maxWidth.Text), //單行字符串最大長(zhǎng)度

        ExpandCommaLists = !chk_columnNotNewline.Checked,  //false 字段換行

        KeywordAlign = chk_keywordAlign.Checked,     //字段對(duì)齊

        TrailingCommas = true,   //true 逗號(hào)在字段之后

        SpaceAfterExpandedComma = true,  //true 逗號(hào)后追加空格

        ExpandBooleanExpressions = chk_conditionNewline.Checked,  //true 條件換行

        ExpandCaseStatements = chk_expandCase.Checked,      //true case when換行

        ExpandBetweenConditions = chk_expandBetween.Checked,  //true between 換行

        ExpandInLists = chk_expandIn.Checked,   //true in 內(nèi)容換行

        BreakJoinOnSections = chk_expandOn.Checked, //true join on中on 條件換行

        UppercaseKeywords = chk_uppercaseKeywords.Checked, //true 關(guān)鍵字大寫

        AllUpper = chk_allUpper.Checked, //true 全部大寫

        HTMLColoring = chk_coloring.Checked, //true HTML顏色標(biāo)記 默認(rèn)為true

        KeywordStandardization = true,//true 關(guān)鍵字標(biāo)準(zhǔn)化

        NewStatementLineBreaks = 2, //新語句換行數(shù)

        NewClauseLineBreaks = 1,//遇到關(guān)鍵字 換行數(shù)

        AllIndent = chk_allIndent.Checked, //整體縮進(jìn)一個(gè)IndentString

        AsAlign = chk_asAlign.Checked, //true as對(duì)齊

        KeywordLengthOfAs = Convert.ToInt32(txt_asMaxWidth.Text)//as字段的最大長(zhǎng)度

    });

    _formatter = new BaiSqlFormatLib.Formatters.HtmlPageWrapper(innerFormatter);

}

#region 頁(yè)面配置

private void chk_default_CheckedChanged(object sender, EventArgs e)

{

    if (chk_default.Checked)

    {

        chk_custom.CheckState = CheckState.Unchecked;
        txt_maxWidth.Text = "170";

        chk_columnNotNewline.CheckState = CheckState.Unchecked;

        chk_keywordAlign.CheckState = CheckState.Checked;

        chk_conditionNewline.CheckState = CheckState.Checked;

        chk_expandCase.CheckState = CheckState.Checked;

        chk_expandBetween.CheckState = CheckState.Unchecked;

        chk_expandIn.CheckState = CheckState.Unchecked;

        chk_expandOn.CheckState = CheckState.Checked;

        chk_uppercaseKeywords.CheckState = CheckState.Unchecked;

        chk_allUpper.CheckState = CheckState.Unchecked;

        chk_coloring.CheckState = CheckState.Checked;

        chk_allIndent.CheckState = CheckState.Checked;

        chk_asAlign.CheckState = CheckState.Checked;

        txt_asMaxWidth.Text = "35";

        chk_addSemicolon.CheckState = CheckState.Checked;
        txt_maxWidth.Enabled = false;

        chk_columnNotNewline.Enabled = false;

        chk_keywordAlign.Enabled = false;

        chk_conditionNewline.Enabled = false;

        chk_expandCase.Enabled = false;

        chk_expandBetween.Enabled = false;

        chk_expandIn.Enabled = false;

        chk_expandOn.Enabled = false;

        chk_uppercaseKeywords.Enabled = false;

        chk_allUpper.Enabled = false;

        chk_coloring.Enabled = false;

        chk_allIndent.Enabled = false;

        chk_asAlign.Enabled = false;

        txt_asMaxWidth.Enabled = false;

        chk_addSemicolon.Enabled = false;

    }

    else

        chk_custom.CheckState = CheckState.Checked;

}

private void chk_custom_CheckedChanged(object sender, EventArgs e)

{

    if (chk_custom.Checked)

    {

        chk_default.CheckState = CheckState.Unchecked;

        chk_columnNotNewline.Enabled = true;

        chk_keywordAlign.Enabled = true;

        chk_conditionNewline.Enabled = true;

        chk_expandCase.Enabled = true;

        chk_expandBetween.Enabled = true;

        chk_expandIn.Enabled = true;

        chk_expandOn.Enabled = true;

        chk_uppercaseKeywords.Enabled = true;

        chk_allUpper.Enabled = true;

        chk_coloring.Enabled = true;

        chk_allIndent.Enabled = true;

        chk_asAlign.Enabled = true;

        chk_addSemicolon.Enabled = true;

        txt_maxWidth.Enabled = true;

        txt_asMaxWidth.Enabled = true;
    }

    else

        chk_default.CheckState = CheckState.Checked;

}

#endregion