public Format ( string inputSQL ) : string | ||
inputSQL | string | |
Результат | string |
public string FormatSql(SqlTiming timing) { var sqlFormatter = new SqlServerFormatter(); var sqlFormat = sqlFormatter.FormatSql(timing); var poorMansFormatter = new TSqlStandardFormatter(); var fullFormatter = new SqlFormattingManager(poorMansFormatter); return fullFormatter.Format(sqlFormat); }
protected override void WndProc(ref Message m) { switch (m.Msg) { case WM_DRAWCLIPBOARD: if (Clipboard.ContainsText()) { string lSelect = "select"; string lFrom = "from"; string lInsert = "insert"; string lInto = "into"; string lUpdate = "update"; string lSet = "set"; string clipText = Clipboard.GetText(); if ((clipText.ToUpper().Contains(lSelect.ToUpper()) && clipText.ToUpper().Contains(lFrom.ToUpper())) || (clipText.ToUpper().Contains(lInsert.ToUpper()) && clipText.ToUpper().Contains(lInto.ToUpper())) || (clipText.ToUpper().Contains(lUpdate.ToUpper()) && clipText.ToUpper().Contains(lSet.ToUpper())) ) { SqlFormattingManager format = new SqlFormattingManager(); format.Formatter.ErrorOutputPrefix = ""; string sqlFormatado = format.Format(clipText); sqlFormatado = sqlFormatado.Replace(": ", ":"); Clipboard.SetText(sqlFormatado); if (!Clipboard.ContainsText()) { Clipboard.SetText(clipText); } } } SendMessage(proxjanela, WM_DRAWCLIPBOARD, m.WParam, m.LParam); break; case WM_CHANGECBCHAIN: if (m.WParam == proxjanela) { proxjanela = m.LParam; } else { SendMessage(proxjanela, WM_DRAWCLIPBOARD, m.WParam, m.LParam); } break; default: base.WndProc(ref m); break; } }