private void BtnConnect_Click(object sender, RoutedEventArgs e)
{
DataToolsQueueMsg msg = new DataToolsQueueMsg();
msg.type = DataBaseType.ShowDataBase;
msg.marks = "ShowDataBases";
mySQLDataTools.Enqueue(msg);
}
private void DataBaseList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataToolsQueueMsg msg = new DataToolsQueueMsg();
msg.type = DataBaseType.ShowTables;
msg.marks = "ShowTables";
msg.whereName = DataBaseList.SelectedItem.ToString();
mySQLDataTools.Enqueue(msg);
}
/// <summary>
/// 选中表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void TablesListView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (TablesListView.SelectedIndex >= 0)
{
DataToolsQueueMsg msg = new DataToolsQueueMsg();
msg.type = DataBaseType.ShowTableColumns;
msg.whereName = DataBaseList.Text;
msg.whereValue = tableLists[TablesListView.SelectedIndex].Title;
msg.marks = "ShowTableColumns";
mySQLDataTools.Enqueue(msg);
//获取表中数据
DataToolsQueueMsg msgData = new DataToolsQueueMsg();
msgData.type = DataBaseType.ExecuteSQLFromDataBase;
msgData.whereName = DataBaseList.Text;
msgData.sql = "select * from " + tableLists[TablesListView.SelectedIndex].Title + " LIMIT 100;";
msgData.marks = "ShowTableData";
mySQLDataTools.Enqueue(msgData);
}
}
