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;
}