Beispiel #1
0
        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();
        }
Beispiel #2
0
        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);
            }
        }
Beispiel #3
0
 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();
             }
         }
     }
 }