private void btnFormatSQL_Click(object sender, EventArgs e) { tbCtrlStage.SelectedIndex = 0; setupformatoptions(); TGSqlParser sqlparser = new TGSqlParser(getDBVendor()); sqlparser.SqlText.Text = inputsql.Text; int i = sqlparser.PrettyPrint(); if (i == 0) { outputsql.Text = sqlparser.FormattedSqlText.Text; } else { outputsql.Text = sqlparser.ErrorMessages; } }
public override bool Format(string sql, out string formatSql) { formatSql = sql; try { TGSqlParser sqlparser = new TGSqlParser(TDbVendor.DbVMssql); sqlparser.SqlText.Text = sql; int ret = sqlparser.PrettyPrint(); if (ret != 0) { this.message = sqlparser.ErrorMessages; return(false); } formatSql = sqlparser.FormattedSqlText.Text; return(true); } catch (Exception ex) { this.message = ex.Message; LogHelper.Error(ex); return(false); } }
private void analyseRequest() { Cursor.Current = Cursors.WaitCursor; //for more format options, please check document lzbasetype.gFmtOpt.Select_Columnlist_Style = TAlignStyle.asStacked; lzbasetype.gFmtOpt.Select_Columnlist_Comma = TLinefeedsCommaOption.lfAfterComma; lzbasetype.gFmtOpt.SelectItemInNewLine = false; lzbasetype.gFmtOpt.AlignAliasInSelectList = true; lzbasetype.gFmtOpt.TreatDistinctAsVirtualColumn = false; //setup more format options ... lzbasetype.gFmtOpt.linenumber_enabled = false; lzbasetype.gFmtOpt.HighlightingFontname = "Courier New"; lzbasetype.gFmtOpt.HighlightingFontsize = 10; //for other elements you want to customize, please check document lzbasetype.gFmtOpt.HighlightingElements[(int)TLzHighlightingElement.sfkIdentifer].SetForegroundInRGB("#008000"); lzbasetype.gFmtOpt.HighlightingElements[(int)TLzHighlightingElement.sfkIdentifer].StyleBold = true; lzbasetype.gFmtOpt.HighlightingElements[(int)TLzHighlightingElement.sfkIdentifer].StyleItalic = false; lzbasetype.gFmtOpt.HighlightingElements[(int)TLzHighlightingElement.sfkIdentifer].StyleStrikeout = false; lzbasetype.gFmtOpt.HighlightingElements[(int)TLzHighlightingElement.sfkIdentifer].StyleUnderline = false; TGSqlParser parser = new TGSqlParser(TDbVendor.DbVOracle); parser.SqlText.Text = rtbEditor.Text; int i = parser.PrettyPrint(); if (i == 0) { rtbEditor.Rtf = parser.ToRTF(TOutputFmt.ofrtf); } Cursor.Current = Cursors.Default; }