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