public TextRange FindNext(bool viaF3, bool searchBackward, string messageIfNotFound)
{
if (_findForm == null)
_findForm = new SearchAndReplace();
TextEditorSearcher _search = new TextEditorSearcher();
_lastSearchWasBackward = searchBackward;
_search.Document = SharpText.Document;
_search.LookFor = _findForm.LookFor;
_search.MatchCase = _findForm.MatchCase;
_search.MatchWholeWordOnly = _findForm.MatchWholeWordOnly;
var caret = SharpText.ActiveTextAreaControl.Caret;
if (viaF3 && _search.HasScanRegion && !caret.Offset.IsInRange(_search.BeginOffset, _search.EndOffset))
{
// user moved outside of the originally selected region
_search.ClearScanRegion();
}
int startFrom = caret.Offset - (searchBackward ? 1 : 0);
TextRange range = _search.FindNext(startFrom, searchBackward, out _lastSearchLoopedAround);
if (range != null)
SelectResult(range);
else if (messageIfNotFound != null)
MessageBox.Show(messageIfNotFound);
return range;
}
private void BtnSearch_Click(object sender, EventArgs e)
{
if (_findForm == null)
_findForm = new SearchAndReplace();
_findForm.ShowFor(this, Query, false);
}
//Process hot keys
bool Query_DoProcessDialogKey(Keys keyData)
{
bool NoEcho = true, Echo = false;
int CurPos;
string TxtBef, TxtAft, CurrentWord;
Token CurrentToken, LastToken;
// Echo == true, then NoEcho == false
#region Key shortcut processing
switch (keyData)
{
case Keys.F5://Execute query
if (BtnExecute.Enabled)
BtnExecute_Click(null, null);
return NoEcho;
case Keys.Shift | Keys.F5://Stop execution
if (BtnStop.Enabled)
BtnStop_Click(null, null);
return NoEcho;
case Keys.Control | Keys.F5://Forced stop execution
if (BtnExtremeStop.Enabled)
BtnExtremeStop_Click(null, null);
return NoEcho;
case Keys.Control | Keys.C://Comment selection / Collapse outlining
if (LastKeyPressed == (Keys.Control | Keys.K))
{//comment selection, or current line
LastKeyPressed = Keys.Space;//clean the last key pressed aux var, to avoid wrong behavior
if (Query.Enabled)
BtnComment_Click(null, null);
return NoEcho;
}
else if (LastKeyPressed == (Keys.Control | Keys.O))
{//collapse outlining
LastKeyPressed = Keys.Space;//clean the last key pressed aux var, to avoid wrong behavior
if (Query.Enabled)
collapseToolStripMenuItem_Click(null, null);
return NoEcho;
}
return Echo;
case Keys.Control | Keys.U://Uncomment selection / to lower case the selection
if (LastKeyPressed == (Keys.Control | Keys.K))
{
LastKeyPressed = Keys.Space;//clean the last key pressed aux var, to avoid wrong behavior
if (Query.Enabled)
BtnUncomment_Click(null, null);
return NoEcho;
}
else
{//to lower case the selection
toLowerCaseToolStripMenuItem1_Click(null, null);
}
return NoEcho;
case Keys.Control | Keys.Shift | Keys.U://to upper case selection
toUpperCseToolStripMenuItem_Click(null, null);
break;
case Keys.Control | Keys.F://Open search dialog
BtnSearch_Click(null, null);
return NoEcho;
case Keys.Control | Keys.F3:
string lookFor;
if (Query.ActiveTextAreaControl.TextArea.SelectionManager.HasSomethingSelected)
{
lookFor = Query.ActiveTextAreaControl.TextArea.SelectionManager.SelectedText;
}
else
{
Token selToken;
TokenList tokens = Query.Text.GetTokens();
selToken = tokens.GetTokenAtOffset(Query.CurrentOffset());
lookFor = selToken.Text;
}
if (_findForm == null)
_findForm = new SearchAndReplace();
if (!String.IsNullOrEmpty(lookFor) && lookFor.Trim(' ', '\t', '\r', '\n').Length > 0)
{
_findForm.SetSearchString(lookFor);
FindNext(true, false, String.Format("Specified text: {0}, was not found.", _findForm.LookFor));
return NoEcho;
}
break;
case Keys.F3://Search next (forward)
if (_findForm != null && !String.IsNullOrEmpty(_findForm.LookFor) && _findForm.LookFor.Trim(' ', '\t', '\r', '\n').Length > 0)
{
FindNext(true, false, String.Format("Specified text: {0}, was not found.", _findForm.LookFor));
}
return NoEcho;
case Keys.Shift | Keys.F3://Search next (Backward)
if (_findForm != null && !String.IsNullOrEmpty(_findForm.LookFor) && _findForm.LookFor.Trim(' ', '\t', '\r', '\n').Length > 0)
{
FindNext(true, true, String.Format("Specified text: {0}, was not found.", _findForm.LookFor));
}
return NoEcho;
case Keys.F2://Toggle bookmark
BtnBookmark_Click(null, null);
return NoEcho;
case Keys.Shift | Keys.F2://Go to previous bookmark
BtnPrevious_Click(null, null);
return NoEcho;
case Keys.Control | Keys.F2://Go to next bookmark
BtnNext_Click(null, null);
return NoEcho;
case Keys.Control | Keys.Shift | Keys.F2://Clear bookmarks
BtnClearBookmarks_Click(null, null);
return NoEcho;
case Keys.Control | Keys.G://Save to file
BtnSave_Click(null, null);
return NoEcho;
case Keys.Control | Keys.L://Load file
BtnLoad_Click(null, null);
return NoEcho;
case Keys.Control | Keys.W://Hide/show results tab
BtnShowHideResults_Click(null, null);
return NoEcho;
case Keys.F12://go to definition
Token selToken2;
TokenList tokens2 = Query.Text.GetTokens();
selToken2 = tokens2.GetTokenAtOffset(Query.CurrentOffset());
if (selToken2 != null && selToken2.Type == TokenType.WORD)
{
ISqlObject Obj = DataProvider.IsSqlObject(selToken2.Text);
if (Obj != null)
{
Parent.AddQueryForm(Obj.Name, Obj.Script, DataProvider);
}
}
return NoEcho;
case Keys.Control | Keys.E://Expand outlining
if (LastKeyPressed == (Keys.Control | Keys.O))
{
LastKeyPressed = Keys.Space;//clean the last key pressed aux var, to avoid wrong behavior
if (Query.Enabled)
expandToolStripMenuItem_Click(null, null);
return NoEcho;
}
return NoEcho;
case Keys.Control | Keys.T://Toggle outlining
if (LastKeyPressed == (Keys.Control | Keys.O))
{
LastKeyPressed = Keys.Space; //clean the last key pressed aux var, to avoid wrong behavior
if (Query.Enabled)
toggleToolStripMenuItem_Click(null, null);
return NoEcho;
}
else
{
break;
}
}
#endregion
CurPos = Query.CurrentOffset();
TxtBef = Query.Document.GetText(0, CurPos);
TxtAft = Query.Document.GetText(CurPos, Query.Text.Length - CurPos);
#region Autocomplete/intellisense code
if (IsIntellisenseOn)
{
#region Code to handle the key pressed if the "intellisense" is active
switch (keyData)
{
case Keys.Back:
AutocompleteDialog.Close();
if (!String.IsNullOrEmpty(CurrentFilterString))
{
CurrentFilterString = CurrentFilterString.Remove(CurrentFilterString.Length - 1);
CancelAutoCompleteClosure = true;
ShowIntellisense(CurrentFilterString, GetAliasesAndAuxiliarTables(Query.Text), curFiltering);
}
return NoEcho;
case Keys.Escape:
AutocompleteDialog.Close();
curFiltering = FilteringType.None;
break;
case Keys.OemMinus:
CurrentFilterString += "-";
ShowIntellisense(CurrentFilterString, GetAliasesAndAuxiliarTables(Query.Text), curFiltering);
return Echo;
case Keys.OemMinus | Keys.Shift:
CurrentFilterString += "_";
ShowIntellisense(CurrentFilterString, GetAliasesAndAuxiliarTables(Query.Text), curFiltering);
return Echo;
case (Keys)65601:
case Keys.A:
case (Keys)65602:
case Keys.B:
case (Keys)65603:
case Keys.C:
case (Keys)65604:
case Keys.D:
case (Keys)65605:
case Keys.E:
case (Keys)65606:
case Keys.F:
case (Keys)65607:
case Keys.G:
case (Keys)65608:
case Keys.H:
case (Keys)65609:
case Keys.I:
case (Keys)65610:
case Keys.J:
case (Keys)65611:
case Keys.K:
case (Keys)65612:
case Keys.L:
case (Keys)65613:
case Keys.M:
case (Keys)65614:
case Keys.N:
case (Keys)65615:
case Keys.O:
case (Keys)65616:
case Keys.P:
case (Keys)65617:
case Keys.Q:
case (Keys)65618:
case Keys.R:
case (Keys)65619:
case Keys.S:
case (Keys)65620:
case Keys.T:
case (Keys)65621:
case Keys.U:
case (Keys)65622:
case Keys.V:
case (Keys)65623:
case Keys.W:
case (Keys)65624:
case Keys.X:
case (Keys)65625:
case Keys.Y:
case (Keys)65626:
case Keys.Z:
case Keys.NumPad0:
case Keys.NumPad1:
case Keys.NumPad2:
case Keys.NumPad3:
case Keys.NumPad4:
case Keys.NumPad5:
case Keys.NumPad6:
case Keys.NumPad7:
case Keys.NumPad8:
case Keys.NumPad9:
case System.Windows.Forms.Keys.LButton | System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
case System.Windows.Forms.Keys.RButton | System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
case System.Windows.Forms.Keys.LButton | System.Windows.Forms.Keys.RButton | System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
case System.Windows.Forms.Keys.MButton | System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
case System.Windows.Forms.Keys.LButton | System.Windows.Forms.Keys.MButton | System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
case System.Windows.Forms.Keys.RButton | System.Windows.Forms.Keys.MButton | System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
case System.Windows.Forms.Keys.LButton | System.Windows.Forms.Keys.RButton | System.Windows.Forms.Keys.MButton | System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
case System.Windows.Forms.Keys.Back | System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
case System.Windows.Forms.Keys.LButton | System.Windows.Forms.Keys.Back | System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
case System.Windows.Forms.Keys.ShiftKey | System.Windows.Forms.Keys.Space:
CurrentFilterString += ((char)keyData).ToString();
ShowIntellisense(CurrentFilterString, GetAliasesAndAuxiliarTables(Query.Text), curFiltering);
return Echo;
case Keys.Delete:
case Keys.Left:
case Keys.Right:
return NoEcho;
default:
if (IsIntellisenseOn)
return Echo;
else
return NoEcho;
}
#endregion
}
else
{
LastKeyPressed = keyData;
#region Code to handle the key pressed if the intellisense is inactive
switch (keyData)
{
case Keys.Control | Keys.OemPeriod://ctrl + . , Show autocomplete
case Keys.Space | Keys.Control://ctrl + space, Show autocomplete
CurrentToken = TxtBef.GetLastToken();
if (CurrentToken.Type == TokenType.EMPTYSPACE || CurrentToken.Type == TokenType.COMMA)
{
CurrentWord = "";
}
else
{
CurrentWord = CurrentToken.Text;
}
CurrentFilterString = CurrentWord;
AutoCompleteStartOffset = CurPos - CurrentWord.Length;
curFiltering = FilteringType.Smart;
ShowIntellisense(CurrentWord, GetAliasesAndAuxiliarTables(Query.Text), curFiltering);
return NoEcho;
case Keys.T | Keys.Control://ctrl + T , Show autocomplete for "field" items
CurrentToken = TxtBef.GetLastToken();
if (CurrentToken.Type == TokenType.EMPTYSPACE || CurrentToken.Type == TokenType.COMMA)
{
CurrentWord = "";
}
else
{
CurrentWord = CurrentToken.Text;
}
CurrentFilterString = CurrentWord;
AutoCompleteStartOffset = CurPos - CurrentWord.Length;
curFiltering = FilteringType.FieldItem;
ShowIntellisense(CurrentWord, GetAliasesAndAuxiliarTables(Query.Text), curFiltering);
return NoEcho;
case Keys.Space://if the text before is an @ or an #, show posible vars or temp tables
LastToken = TxtBef.GetLastToken();
if (LastToken.Text == "@")
{
TokenList Tokens = Query.Text.GetTokens();
List<string> Helper = new List<string>();
foreach (Token t in Tokens.List.Where(X => X.Type == TokenType.VARIABLE))
{
string buff = t.Text.Contains(".") ? t.Text.Split('.')[0] : t.Text;
if (!Helper.Contains(buff, StringComparer.CurrentCultureIgnoreCase))
Helper.Add(buff);
}
if (Helper.Count > 0)
{
ObjectSelector Os = new ObjectSelector("Variables detected on script", "Select variable", Helper);
if (Os.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Query.InsertString(Os.SelectedObject.Length > 0 && Os.SelectedObject.StartsWith("@") ? Os.SelectedObject.Substring(1) : Os.SelectedObject);
return NoEcho;
}
else
{
return Echo;
}
}
return Echo;
}
else if (LastToken.Text == "#")
{
TokenList Tokens = Query.Text.GetTokens();
List<string> Helper = new List<string>();
foreach (Token t in Tokens.List.Where(X => X.Type == TokenType.TEMPTABLE))
{
string buff = t.Text.Contains(".") ? t.Text.Split('.')[0] : t.Text;
if (!Helper.Contains(buff, StringComparer.CurrentCultureIgnoreCase))
Helper.Add(buff);
}
if (Helper.Count > 0)
{
ObjectSelector Os = new ObjectSelector("Variables temp tables on script", "Select table", Helper);
if (Os.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Query.InsertString(Os.SelectedObject.Length > 0 && Os.SelectedObject.StartsWith("#") ? Os.SelectedObject.Substring(1) : Os.SelectedObject);
return NoEcho;
}
else
{
return Echo;
}
}
return Echo;
}
else if (LastToken.Text.Equals("from", StringComparison.CurrentCultureIgnoreCase) || LastToken.Text.Equals("join", StringComparison.CurrentCultureIgnoreCase))
{
Query.InsertString(" ");
CurrentFilterString = "";
AutoCompleteStartOffset = CurPos + 1;
curFiltering = FilteringType.FieldItem;
ShowIntellisense("", GetAliasesAndAuxiliarTables(Query.Text), curFiltering);
return NoEcho;
}
break;
case Keys.OemPeriod:
case Keys.Decimal://show Sql Object childs... if any
Query.InsertString(".");
CurPos = Query.CurrentOffset();
TxtBef = Query.Document.GetText(0, CurPos);
TxtAft = Query.Document.GetText(CurPos, Query.Text.Length - CurPos);
CurrentToken = TxtBef.GetLastToken();
if (CurrentToken.Type == TokenType.EMPTYSPACE || CurrentToken.Type == TokenType.COMMA)
{
CurrentWord = "";
}
else
{
CurrentWord = CurrentToken.Text;
}
CurrentFilterString = CurrentWord;
AutoCompleteStartOffset = CurPos - CurrentWord.Length;
curFiltering = FilteringType.Smart;
ShowIntellisense(CurrentWord, GetAliasesAndAuxiliarTables(Query.Text), curFiltering);
return NoEcho;
case Keys.S | Keys.Control://ctrl + s , show list of snippets
List<string> SnippetsNames = new List<string>();
List<string> SnippetsValues = new List<string>();
foreach (Snippet sn in Parent.GetSnippetList())
{
SnippetsNames.Add(sn.Name);
SnippetsValues.Add(sn.ShortCut);
}
ObjectSelector SnSelector = new ObjectSelector("Snippets detected", "Select the snippet, to insert his shortcut", SnippetsValues, SnippetsNames, false, 1);
if (SnSelector.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Query.InsertString(SnSelector.SelectedObject);
return NoEcho;
}
else
{
return Echo;
}
break;
case Keys.Tab://check if it is a request for a snippet, a variable or a temp table
LastToken = TxtBef.GetLastToken();
if (LastToken.Text == "@")
{
TokenList Tokens = Query.Text.GetTokens();
List<string> Helper = new List<string>();
foreach (Token t in Tokens.List.Where(X => X.Type == TokenType.VARIABLE))
{
string buff = t.Text.Contains(".") ? t.Text.Split('.')[0] : t.Text;
if (!Helper.Contains(buff, StringComparer.CurrentCultureIgnoreCase))
Helper.Add(buff);
}
if (Helper.Count > 0)
{
ObjectSelector Os = new ObjectSelector("Variables detected on script", "Select variable", Helper);
if (Os.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Query.InsertString(Os.SelectedObject.Length > 0 && Os.SelectedObject.StartsWith("@") ? Os.SelectedObject.Substring(1) : Os.SelectedObject);
return NoEcho;
}
else
{
return Echo;
}
}
return Echo;
}
else if (LastToken.Text == "#")
{
TokenList Tokens = Query.Text.GetTokens();
List<string> Helper = new List<string>();
foreach (Token t in Tokens.List.Where(X => X.Type == TokenType.TEMPTABLE))
{
string buff = t.Text.Contains(".") ? t.Text.Split('.')[0] : t.Text;
if (!Helper.Contains(buff, StringComparer.CurrentCultureIgnoreCase))
Helper.Add(buff);
}
if (Helper.Count > 0)
{
ObjectSelector Os = new ObjectSelector("Variables temp tables on script", "Select table", Helper);
if (Os.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Query.InsertString(Os.SelectedObject.Length > 0 && Os.SelectedObject.StartsWith("#") ? Os.SelectedObject.Substring(1) : Os.SelectedObject);
return NoEcho;
}
else
{
return Echo;
}
}
return Echo;
}
else if (LastToken.Type == TokenType.WORD)
{//check for snippet
string SnippetScript = Parent.IsInsertSnippet(LastToken.Text);
if (!String.IsNullOrEmpty(SnippetScript))
{
int Offset = Query.CurrentOffset();
Query.SetSelectionByOffset(Offset - LastToken.Text.Length, Offset);
InsertSnippet(SnippetScript);
return NoEcho;
}
return Echo;
}
break;
default:
//this.Text = keyData.ToString();
return Echo;
}
#endregion
}
#endregion
return Echo;
}
//Process hot keys
bool SharpText_DoProcessDialogKey(Keys keyData)
{
bool NoEcho = true, Echo = false;
// Echo == true, then NoEcho == false
#region Key shortcut processing
switch (keyData)
{
case Keys.Control | Keys.C://Comment selection / Collapse outlining
if (LastKeyPressed == (Keys.Control | Keys.K))
{//comment selection, or current line
LastKeyPressed = Keys.Space;//clean the last key pressed aux var, to avoid wrong behavior
if (SharpText.Enabled)
BtnComment_Click(null, null);
return NoEcho;
}
else if (LastKeyPressed == (Keys.Control | Keys.O))
{//collapse outlining
LastKeyPressed = Keys.Space;//clean the last key pressed aux var, to avoid wrong behavior
if (SharpText.Enabled)
collapseToolStripMenuItem_Click(null, null);
return NoEcho;
}
return Echo;
case Keys.Control | Keys.U://Uncomment selection / to lower case the selection
if (LastKeyPressed == (Keys.Control | Keys.K))
{
LastKeyPressed = Keys.Space;//clean the last key pressed aux var, to avoid wrong behavior
if (SharpText.Enabled)
BtnUncomment_Click(null, null);
return NoEcho;
}
else
{//to lower case the selection
toLowerCaseToolStripMenuItem1_Click(null, null);
}
return NoEcho;
case Keys.Control | Keys.Shift | Keys.U://to upper case selection
toUpperCseToolStripMenuItem_Click(null, null);
break;
case Keys.Control | Keys.F://Open search dialog
BtnSearch_Click(null, null);
return NoEcho;
case Keys.Control | Keys.F3:
string lookFor;
if (SharpText.ActiveTextAreaControl.TextArea.SelectionManager.HasSomethingSelected)
{
lookFor = SharpText.ActiveTextAreaControl.TextArea.SelectionManager.SelectedText;
}
else
{
Token selToken;
TokenList tokens = SharpText.Text.GetTokens();
selToken = tokens.GetTokenAtOffset(SharpText.CurrentOffset());
lookFor = selToken.Text;
}
if (_findForm == null)
_findForm = new SearchAndReplace();
if (!String.IsNullOrEmpty(lookFor) && lookFor.Trim(' ', '\t', '\r', '\n').Length > 0)
{
_findForm.SetSearchString(lookFor);
FindNext(true, false, String.Format("Specified text: {0}, was not found.", _findForm.LookFor));
return NoEcho;
}
break;
case Keys.F3://Search next (forward)
if (_findForm != null && !String.IsNullOrEmpty(_findForm.LookFor) && _findForm.LookFor.Trim(' ', '\t', '\r', '\n').Length > 0)
{
FindNext(true, false, String.Format("Specified text: {0}, was not found.", _findForm.LookFor));
}
return NoEcho;
case Keys.Shift | Keys.F3://Search next (Backward)
if (_findForm != null && !String.IsNullOrEmpty(_findForm.LookFor) && _findForm.LookFor.Trim(' ', '\t', '\r', '\n').Length > 0)
{
FindNext(true, true, String.Format("Specified text: {0}, was not found.", _findForm.LookFor));
}
return NoEcho;
case Keys.F2://Toggle bookmark
BtnBookmark_Click(null, null);
return NoEcho;
case Keys.Shift | Keys.F2://Go to previous bookmark
BtnPrevious_Click(null, null);
return NoEcho;
case Keys.Control | Keys.F2://Go to next bookmark
BtnNext_Click(null, null);
return NoEcho;
case Keys.Control | Keys.Shift | Keys.F2://Clear bookmarks
BtnClearBookmarks_Click(null, null);
return NoEcho;
case Keys.Control | Keys.G://Save to file
BtnSave_Click(null, null);
return NoEcho;
case Keys.Control | Keys.L://Load file
BtnLoad_Click(null, null);
return NoEcho;
case Keys.Control | Keys.E://Expand outlining
if (LastKeyPressed == (Keys.Control | Keys.O))
{
LastKeyPressed = Keys.Space;//clean the last key pressed aux var, to avoid wrong behavior
if (SharpText.Enabled)
expandToolStripMenuItem_Click(null, null);
return NoEcho;
}
return NoEcho;
case Keys.Control | Keys.T://Toggle outlining
if (LastKeyPressed == (Keys.Control | Keys.O))
{
LastKeyPressed = Keys.Space;//clean the last key pressed aux var, to avoid wrong behavior
if (SharpText.Enabled)
toggleToolStripMenuItem_Click(null, null);
return NoEcho;
}
return NoEcho;
}
#endregion
LastKeyPressed = keyData;
return Echo;
}
