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