public ObjectSearcher(MainForm Parent, SqlConnector DataProvider)
{
InitializeComponent();
this.DataProvider = DataProvider;
this.Parent = Parent;
CmbSearchType.SelectedIndex = 0;
}
public CompletionDataProvider(SqlConnector SqlServerData, ImageList imageList)
{
this.SqlServerData = SqlServerData;
this.imageList = imageList;
ComplementaryObjects = new List<ISqlObject>();
FilteringOption = FilteringType.Any;
}
public CompletionDataProvider(SqlConnector SqlServerData, ImageList imageList, string FSchema, string FObject, string FChild)
{
this.SqlServerData = SqlServerData;
this.imageList = imageList;
this.FSchema = FSchema;
this.FObject = FObject;
this.FChild = FChild;
ComplementaryObjects = new List<ISqlObject>();
FilteringOption = FilteringType.Any;
}
public QueryForm(MainForm Parent, SqlConnector DataProvider, string Script = "")
{
InitializeComponent();
this.Parent = Parent;
this.DataProvider = DataProvider;
Query.Text = Script;
CurrentScript = Script;
Executor = new QueryExecutor();
if (DataProvider != null && !String.IsNullOrEmpty(DataProvider.ConnectionString))
Executor.Initialize(DataProvider.ConnectionString);
Executor.FinishExec += new ProcessingQuery(Conx_FinishExec);
Executor.StartExec += new ProcessingQuery(Conx_StartExec);
ServerTxt.Text = DataProvider.Server;
BDTxt.Text = DataProvider.DataBase;
ConnectionGroup = Parent.ConxGroup;
ConnectionName = Parent.ConxName;
#region Code to load the Highlight rules(files in resources) and the folding strategy class
try
{
HighlightingManager.Manager.AddSyntaxModeFileProvider(new FileSyntaxModeProvider(MainForm.DataStorageDir + "\\SintaxHighLight\\"));
Query.Document.HighlightingStrategy = HighlightingManager.Manager.FindHighlighter("SQL");
Query.Document.FormattingStrategy = new Ez_SQL.TextEditorClasses.SqlBracketMatcher();
Query.Document.FoldingManager.FoldingStrategy = new Ez_SQL.TextEditorClasses.SqlFolder();
Query.Document.FoldingManager.UpdateFoldings(null, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
#endregion
#region Code to assign the method that will handle the key press event and the method to refresh the folding
//Method that handles autocomplete and key shortcuts
Query.ActiveTextAreaControl.TextArea.DoProcessDialogKey += Query_DoProcessDialogKey;
//Method that refresh the folding
Query.Document.DocumentChanged += Query_DocumentChanged;
#endregion
//capture mouse click, to manage ctr + click
Query.ActiveTextAreaControl.TextArea.MouseClick += MouseClicked;
this.AutoScroll = false;
//handle mouse click, to show a context menu for the tabs
TabHolder.MouseClick += new MouseEventHandler(TabHolder_MouseClick);
//for locked tabs there can be some "comments" shown as tooltip
TabHolder.ShowToolTips = true;
#region Matching types, between SQL and C#, both ways
if (SqlVsCSharp == null)
{
SqlVsCSharp = new Dictionary<string, string>(StringComparer.OrdinalIgnoreCase);
SqlVsCSharp.Add("bigint", "int");
SqlVsCSharp.Add("binary", "int");
SqlVsCSharp.Add("bit", "bool");
SqlVsCSharp.Add("char", "string");
SqlVsCSharp.Add("date", "DateTime");
SqlVsCSharp.Add("datetime", "DateTime");
SqlVsCSharp.Add("datetime2", "DateTime");
SqlVsCSharp.Add("float", "double");
SqlVsCSharp.Add("int", "int");
SqlVsCSharp.Add("decimal", "double");
SqlVsCSharp.Add("money", "double");
SqlVsCSharp.Add("nchar", "string");
SqlVsCSharp.Add("ntext", "string");
SqlVsCSharp.Add("numeric", "int");
SqlVsCSharp.Add("nvarchar", "string");
SqlVsCSharp.Add("real", "double");
SqlVsCSharp.Add("smalldatetime", "DateTime");
SqlVsCSharp.Add("smallint", "int");
SqlVsCSharp.Add("smallmoney", "double");
SqlVsCSharp.Add("sysname", "string");
SqlVsCSharp.Add("text", "string");
SqlVsCSharp.Add("timestamp", "DateTime");
SqlVsCSharp.Add("tinyint", "int");
SqlVsCSharp.Add("varbinary", "int");
SqlVsCSharp.Add("varchar", "string");
SqlVsCSharp.Add("System.Boolean", "bool");
SqlVsCSharp.Add("System.Int32", "int");
SqlVsCSharp.Add("System.String", "string");
SqlVsCSharp.Add("System.Decimal", "float");
SqlVsCSharp.Add("System.Double", "float");
SqlVsCSharp.Add("System.DateTime", "DateTime");
}
if (SqlVsCSharpDb == null)
{
SqlVsCSharpDb = new Dictionary<string, string>(StringComparer.OrdinalIgnoreCase);
SqlVsCSharpDb.Add("bigint", "SqlDbType.BigInt");
SqlVsCSharpDb.Add("binary", "SqlDbType.Binary");
SqlVsCSharpDb.Add("bit", "SqlDbType.Bit");
SqlVsCSharpDb.Add("char", "SqlDbType.Char");
SqlVsCSharpDb.Add("datetime", "SqlDbType.DateTime");
SqlVsCSharpDb.Add("float", "SqlDbType.Float");
SqlVsCSharpDb.Add("int", "SqlDbType.Int");
SqlVsCSharpDb.Add("decimal", "SqlDbType.Decimal");
SqlVsCSharpDb.Add("money", "SqlDbType.Float");
SqlVsCSharpDb.Add("nchar", "SqlDbType.NChar");
SqlVsCSharpDb.Add("ntext", "SqlDbType.NText");
SqlVsCSharpDb.Add("numeric", "SqlDbType.Int");
SqlVsCSharpDb.Add("nvarchar", "SqlDbType.NVarChar");
SqlVsCSharpDb.Add("real", "SqlDbType.Real");
SqlVsCSharpDb.Add("smalldatetime", "SqlDbType.SmallDateTime");
SqlVsCSharpDb.Add("smallint", "SqlDbType.SmallInt");
SqlVsCSharpDb.Add("smallmoney", "SqlDbType.SmallMoney");
SqlVsCSharpDb.Add("sysname", "SqlDbType.Text");
SqlVsCSharpDb.Add("text", "SqlDbType.Text");
SqlVsCSharpDb.Add("timestamp", "SqlDbType.Timestamp");
SqlVsCSharpDb.Add("tinyint", "SqlDbType.TinyInt");
SqlVsCSharpDb.Add("varbinary", "SqlDbType.VarBinary");
SqlVsCSharpDb.Add("varchar", "SqlDbType.VarChar");
}
if (CSharpVsSql == null)
{
CSharpVsSql = new Dictionary<string, string>(StringComparer.OrdinalIgnoreCase);
CSharpVsSql.Add("System.Char", "char");
CSharpVsSql.Add("System.Boolean", "bit");
CSharpVsSql.Add("System.Int16", "int");
CSharpVsSql.Add("System.Int32", "int");
CSharpVsSql.Add("System.Int64", "int");
CSharpVsSql.Add("System.String", "varchar");
CSharpVsSql.Add("System.Single", "float");
CSharpVsSql.Add("System.Decimal", "float");
CSharpVsSql.Add("System.Double", "float");
CSharpVsSql.Add("System.DateTime", "DateTime");
}
#endregion
}
private void AddressBarSelectionChange(object sender, AddressBarExt.Controls.NodeChangedArgs nca)
{
string[] Data;
if (nca.OUniqueID.ToString().Contains("Name"))
{
Data = nca.OUniqueID.ToString().Split('|');
_ConxGroup = Data[1].Split(':')[1];
_ConxName = Data[2].Split(':')[1];
CurConStr = Data[3].Split(':')[1];
//ConStrCad.Text = CurConStr;
if (Connectors == null)
Connectors = new List<SqlConnector>();
foreach (SqlConnector _DbConx in Connectors)
{
if (_DbConx.ConnectionString.Equals(CurConStr, StringComparison.CurrentCultureIgnoreCase))
{
_CurrentConnection = _DbConx;
return;
}
}
Connectors.Add(new SqlConnector(CurConStr));
_CurrentConnection = Connectors[Connectors.Count - 1];
}
else
{//If there is no connection selected clean connection variables
_ConxGroup = "";
_ConxName = "";
}
}
public void AddQueryForm(string title, string text, SqlConnector DataProvider)
{
MultiQueryForm.QueryForm dlg = new MultiQueryForm.QueryForm(this, DataProvider, text);
dlg.ToolTipText = String.Format("{0} - {1} / {2} - {3}", DataProvider.Server, DataProvider.DataBase, ConxGroup, ConxName);
dlg.Text = String.Format("{0}", title);
dlg.ShowIcon = true;
dlg.Show(WorkPanel, WeifenLuo.WinFormsUI.Docking.DockState.Document);
}
private void SourceConnectionChange(object sender, AddressBarExt.Controls.NodeChangedArgs nca)
{
string[] Data;
if (nca.OUniqueID.ToString().Contains("Name"))
{
Data = nca.OUniqueID.ToString().Split('|');
string CurConStr = Data[3].Split(':')[1];
//ConStrCad.Text = CurConStr;
if (Connectors == null)
Connectors = new List<SqlConnector>();
foreach (SqlConnector _DbConx in Connectors)
{
if (_DbConx.ConnectionString.Equals(CurConStr, StringComparison.CurrentCultureIgnoreCase))
{
sourceConx = _DbConx;
return;
}
}
Connectors.Add(new SqlConnector(CurConStr));
sourceConx = Connectors[Connectors.Count - 1];
}
else
{
sourceConx = null;
}
}
