コード例 #1
0
 private void serverExplorer_Connected(object sender, EventArgs e)
 {
     if (treeView.Items.Count > 0)
     {
         //TreeViewItem tvi = treeView.ItemContainerGenerator.ContainerFromItem(treeView.Items[0]) as TreeViewItem;
         //RefreshImage(tvi);
     }
     databaseDetails.Clear();
     databasesDetail = null;
     procedureDetail = null;
     proceduresDetails.Clear();
     serverDetail = null;
     tableDetail  = null;
     tablesDetails.Clear();
     userDetail  = null;
     usersDetail = null;
     viewDetail  = null;
     viewsDetails.Clear();
 }
コード例 #2
0
        private void treeView_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs <object> e)
        {
            // TODO: I can assign the panel and DataContext generically
            IElement node = e.NewValue as IElement;

            if (node != null)
            {
                if (node.Name == "Connections")
                {
                    if (connectionDetail == null)
                    {
                        connectionDetail             = new ConnectionDetail();
                        connectionDetail.DataContext = serverExplorer;
                    }
                    DetailPanel.Content = connectionDetail;
                }
                else if (node.TypeName == "Server")
                {
                    if (serverDetail == null)
                    {
                        serverDetail             = new ServerDetail();
                        serverDetail.DataContext = node;
                    }
                    DetailPanel.Content = serverDetail;
                }
                else if (node.TypeName == nameof(Query))
                {
                    if (queryEditor == null)
                    {
                        queryEditor             = new QueryEditor();
                        queryEditor.DataContext = node;
                    }
                    DetailPanel.Content = queryEditor;
                }
                else if (node.Name == "Databases")
                {
                    if (databasesDetail == null)
                    {
                        databasesDetail             = new DatabasesDetail();
                        databasesDetail.DataContext = node;
                    }
                    DetailPanel.Content = databasesDetail;
                }
                else if (node.Name == "Users")
                {
                    if (usersDetail == null)
                    {
                        usersDetail             = new UsersDetail();
                        usersDetail.DataContext = node;
                    }
                    DetailPanel.Content = usersDetail;
                }
                else if (node.TypeName == "Database")
                {
                    if (!databaseDetails.ContainsKey(node.Name))
                    {
                        DatabaseDetail dd = new DatabaseDetail();
                        dd.DataContext = node;
                        databaseDetails.Add(node.Name, dd);
                    }
                    DetailPanel.Content = databaseDetails[node.Name];
                }
                else if (node.Name == "Tables")
                {
                    if (!tablesDetails.ContainsKey(node.Parent.Name))
                    {
                        TablesDetail td = new TablesDetail();
                        td.DataContext = node;
                        tablesDetails.Add(node.Parent.Name, td);
                    }
                    DetailPanel.Content = tablesDetails[node.Parent.Name];
                }
                else if (node.Name == "Procedures")
                {
                    if (!proceduresDetails.ContainsKey(node.Parent.Name))
                    {
                        ProceduresDetail pd = new ProceduresDetail();
                        pd.DataContext = node;
                        proceduresDetails.Add(node.Parent.Name, pd);
                    }
                    DetailPanel.Content = proceduresDetails[node.Parent.Name];
                }
                else if (node.Name == "Views")
                {
                    if (!viewsDetails.ContainsKey(node.Parent.Name))
                    {
                        ViewsDetail vd = new ViewsDetail();
                        vd.DataContext = node;
                        viewsDetails.Add(node.Parent.Name, vd);
                    }
                    DetailPanel.Content = viewsDetails[node.Parent.Name];
                }
                else if (node.TypeName == nameof(Table))
                {
                    if (tableDetail == null)
                    {
                        tableDetail = new TableDetail();
                    }
                    Table     t    = node as Table;
                    IDatabase d    = (IDatabase)t.Parent;
                    Task      task = new Task(() => { Dispatcher.Invoke(() => tableDetail.DataContext = d.GetTable(node.Name)); });
                    task.Start();
                    DetailPanel.Content = tableDetail;
                }
                else if (node.TypeName == nameof(Procedure))
                {
                    if (procedureDetail == null)
                    {
                        procedureDetail = new ProcedureDetail();
                    }
                    Procedure p    = node as Procedure;
                    IDatabase d    = (IDatabase)p.Parent;
                    Task      task = new Task(() => { Dispatcher.Invoke(() => procedureDetail.DataContext = d.GetProcedure(node.Name)); });
                    task.Start();
                    DetailPanel.Content = procedureDetail;
                }
                else if (node.TypeName == nameof(View))
                {
                    if (viewDetail == null)
                    {
                        viewDetail = new ViewDetail();
                    }
                    View      v    = node as View;
                    IDatabase d    = (IDatabase)v.Parent;
                    Task      task = new Task(() => { Dispatcher.Invoke(() => viewDetail.DataContext = d.GetView(node.Name)); });
                    task.Start();
                    DetailPanel.Content = viewDetail;
                }
                else if (node.TypeName == nameof(User))
                {
                    if (userDetail == null)
                    {
                        userDetail = new UserDetail();
                    }
                    DetailPanel.Content = userDetail;
                }
            }
        }