private void Button_Ok_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TextBox_Table.Text))
{
TextBox_Table.SelectAll();
TextBox_Table.Focus();
return;
}
if (!DepositoryDataTable.AnalysisSQLCommand(sql_CommandEditor.Text))
{
sql_CommandEditor.SelectAll();
sql_CommandEditor.Focus();
return;
}
TableData.SetTableName(TextBox_Table.Text);
TableData.SetTableText(TextBox_Table.Text);
TableData.SetQueryCommand(sql_CommandEditor.Text);
//将数据列添加到TableData中
List <string> DataColumns = DepositoryDataTable.GetFields(sql_CommandEditor.Text);
foreach (string col in DataColumns)
{
int Index = TableData.AddStringColumn(col);
TableData.SetColumnText(Index, col);
}
this.DialogResult = DialogResult.OK;
Close();
}
public static void LoadTableList(TreeView View)
{
View.Nodes.Clear();
List <string> Tables = DepositoryDataTable.GetTables();
foreach (string table in Tables)
{
TreeNode TableNode = new TreeNode(table);
TableNode.Name = table;
TableNode.SelectedImageIndex = 0;
TableNode.ImageIndex = 0;
View.Nodes.Add(TableNode);
}
DataTable Data = DepositoryDataTable.GetFields(Tables.ToArray());
foreach (DataRow Row in Data.Rows)
{
String TableName = Row["TableName"].ToString();
String ColumnName = Row["ColumnName"].ToString();
int Index = View.Nodes.IndexOfKey(TableName);
TreeNode TableNode = View.Nodes[Index];
TreeNode ColNode = new TreeNode(ColumnName);
ColNode.Name = ColumnName;
ColNode.SelectedImageIndex = 0;
ColNode.ImageIndex = 0;
TableNode.Nodes.Add(ColNode);
}
}