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); } }
private void ToolStripMenuItem_Click(object sender, EventArgs e) { if (sender == Button_AnalysisSQL) { Boolean r = DepositoryDataTable.AnalysisSQLCommand(sql_CommandEditor.Text); String msg = (r ? "语句正确!" : "语句有错误!"); MessageBoxIcon BoxIcon = (r? MessageBoxIcon.Information : MessageBoxIcon.Error); MessageBox.Show(msg, "提示", MessageBoxButtons.OK, BoxIcon); } else if (sender == Button_Import) { openFileDialog1.FileName = ""; openFileDialog1.Filter = "sql files (*.sql)|*.sql"; openFileDialog1.FilterIndex = 2; openFileDialog1.InitialDirectory = Application.StartupPath; openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { using (TextReader tr = new StreamReader(openFileDialog1.FileName)) { sql_CommandEditor.Text = tr.ReadToEnd(); } } } else if (sender == Button_Export) { saveFileDialog1.FileName = ""; saveFileDialog1.Filter = "sql files (*.sql)|*.sql"; saveFileDialog1.FilterIndex = 2; saveFileDialog1.InitialDirectory = Application.StartupPath; saveFileDialog1.RestoreDirectory = true; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { using (TextWriter sw = new StreamWriter(saveFileDialog1.FileName)) { sw.Write(sql_CommandEditor.Text); sw.Close(); } } } }