public Main()
{
InitializeComponent();
commtc = new TabControl_Comm(this, tcMain);
//BindTableCompare();
DataBaseList dblist = new DataBaseList();
commtc.OpenTabPage(dblist);
}
private void Button_Click_2(object sender, RoutedEventArgs e)
{
//ImportModel1.Name = Name.Text;
if (!string.IsNullOrEmpty(ImportModel1.Name) && !string.IsNullOrEmpty(ImportModel1.File))
{
DataBaseList.Add(ImportModel1);
}
// this.PropertyChanged?.Invoke(this, new PropertyChangedEventArgs("DataBaseList"));
this.Close();
}
private void ContextMenuClose(object sender, RoutedEventArgs e)
{
MenuItemEx menuItem = sender as MenuItemEx;
var name = "N" + menuItem.Name.Split('_')[1];
TreeViewExNode item = DataBaseList.FindName(name) as TreeViewExNode;
var removeItems = new List <TabItemEx>();
// 关闭关联视图
if (menuItem.ItemType == ItemTypes.Server)
{
foreach (TabItemEx temp in TabController.Items)
{
if (temp.DataSource == item.DataSource &&
temp.ConnectionId == item.ConnectionId)
{
removeItems.Add(temp);
}
}
}
else if (menuItem.ItemType == ItemTypes.DataBase)
{
foreach (TabItemEx temp in TabController.Items)
{
if (temp.DataBase == item.DataBase &&
temp.DataSource == item.DataSource &&
temp.ConnectionId == item.ConnectionId)
{
removeItems.Add(temp);
}
}
}
foreach (TabItemEx temp in removeItems)
{
TabController.Items.Remove(temp);
}
if (item != null)
{
DockPanel1.UnregisterName(name);
item.Items.Clear();
}
}
private void UiLoginMessage(DataToolsUIMsg message)
{
this.Dispatcher.BeginInvoke(System.Windows.Threading.DispatcherPriority.Background, new Action(() =>
{
switch (message.type)
{
case "ShowTables":
//显示某个数据库的数据表
if (null != message.dataSet && message.dataSet.Tables[0].Rows.Count > 0)
{
TablesListView.BeginInit();
//TablesListView.Items.Clear();
tableLists.Clear();
int i = 0;
foreach (DataRow row in message.dataSet.Tables[0].Rows)
{
i++;
tableLists.Add(new DataList(i.ToString(), row[0].ToString()));
}
TablesListView.ItemsSource = tableLists;
TablesListView.EndInit();
}
break;
case "ShowTableColumns":
//显示某个数据库的数据表的所有字段
if (null != message.dataSet && message.dataSet.Tables[0].Rows.Count > 0)
{
ColumnsListView.BeginInit();
columnsLists.Clear();
int i = 0;
foreach (DataRow row in message.dataSet.Tables[0].Rows)
{
i++;
columnsLists.Add(new DataList(i.ToString(), row[0].ToString(), row[1].ToString()));
}
ColumnsListView.ItemsSource = columnsLists;
ColumnsListView.EndInit();
}
break;
case "ShowDataBases":
//显示所有数据库
if (null != message.dataSet && message.dataSet.Tables[0].Rows.Count > 0)
{
DataBaseList.BeginInit();
DataBaseList.Items.Clear();
foreach (DataRow row in message.dataSet.Tables[0].Rows)
{
DataBaseList.Items.Add(row[0].ToString());
}
DataBaseList.EndInit();
}
if (DataBaseList.Items.Count > 0)
{
DataBaseList.SelectedIndex = 0;
}
break;
case "ShowTableData":
//显示表中数据
if (null != message.dataSet && message.dataSet.Tables[0].Rows.Count > 0)
{
AllTableData.BeginInit();
AllTableData.ItemsSource = message.dataSet.Tables[0].DefaultView;
AllTableData.EndInit();
}
else
{
AllTableData.BeginInit();
AllTableData.ItemsSource = null;
AllTableData.EndInit();
}
break;
case "exception":
MessageBox.Show(message.message);
Status1.Content = message.message;
break;
}
}));
}
/// <summary>
/// 设置表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DBSetting_Click(object sender, EventArgs e)
{
DataBaseList dblist = new DataBaseList();
commtc.OpenTabPage(dblist);
}
