Beispiel #1
0
        //>>>>>>> master

        public void MyRefresh()
        {
            dbDic = new Dictionary <string, List <string> >();
            tvc   = new TreeviewController(this.treeView1);

            ZBindNode(); this.Refresh();
        }
Beispiel #2
0
        public MainForm()
        {
            dbDic = new Dictionary <string, List <string> >();
            InitializeComponent();

            materialSkinManager = MaterialSkinManager.Instance;
            materialSkinManager.AddFormToManage(this);
            materialSkinManager.Theme       = MaterialSkinManager.Themes.LIGHT;
            materialSkinManager.ColorScheme = new ColorScheme(Primary.BlueGrey800, Primary.BlueGrey900, Primary.BlueGrey500, Accent.LightBlue200, TextShade.WHITE);

            tvc = new TreeviewController(this.treeView1);
            //con.Open();
            ZBindNode();
            Control.mainform = this;
        }
Beispiel #3
0
        private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            TreeviewController tvc = new TreeviewController(this.treeView1);

            if (this.treeView1.SelectedNode.Name == "db")
            {
                Control.connection.SqlConn.Close();
                Control.connection.SqlConn = tvc.EsConOnDataBase(this.treeView1.SelectedNode);
            }
            if (this.treeView1.SelectedNode.Name == "sc")
            {
                Control.connection.SqlConn.Close();
                Control.connection.SqlConn = tvc.EsConOnSchemas(this.treeView1.SelectedNode);

                String sel_table = "select * from information_schema.tables;";
                // Control.background.tableName = this.treeView1.SelectedNode.Text;
                NpgsqlCommand command = new NpgsqlCommand(sel_table, Control.connection.SqlConn);
                //   Control.connection.SqlConn.Open();
                try
                {
                    command.ExecuteNonQuery();
                    NpgsqlDataAdapter npgsql = new NpgsqlDataAdapter(sel_table, Control.connection.SqlConn);
                    Control.connection.ds = new DataSet();
                    npgsql.Fill(Control.connection.ds);
                    //Control.connection.SqlConn.Close();

                    Control.background2.GetDataGridView1().DataSource = null;
                    Control.background2.GetDataGridView1().EditMode   = DataGridViewEditMode.EditOnEnter;
                    Control.background2.GetDataGridView1().DataSource = Control.connection.ds;

                    Control.background2.GetDataGridView1().DataMember = Control.connection.ds.Tables[0].TableName;

                    Control.background2.GetDataGridView1().EnableHeadersVisualStyles = false;
                    Control.background2.GetDataGridView1().ColumnHeadersDefaultCellStyle.Font = new Font("隶书", 9, FontStyle.Italic);
                    Control.background2.GetDataGridView1().ColumnHeadersDefaultCellStyle.ForeColor = Color.Purple;
                    //Control.background2.SetFormerNum(Control.background2.GetDataGridView1().ColumnCount);
                }
                catch (Exception ee)
                {
                    MessageBox.Show("请检查您的指令!\ntips:" + ee.Message);
                }

                String sel_table2 = "select * from information_schema.columns;";
                // Control.background.tableName = this.treeView1.SelectedNode.Text;
                NpgsqlCommand command2 = new NpgsqlCommand(sel_table2, Control.connection.SqlConn);
                //   Control.connection.SqlConn.Open();
                try
                {
                    command2.ExecuteNonQuery();
                    NpgsqlDataAdapter npgsql = new NpgsqlDataAdapter(sel_table2, Control.connection.SqlConn);
                    Control.connection.ds = new DataSet();
                    npgsql.Fill(Control.connection.ds);
                    //Control.connection.SqlConn.Close();

                    Control.background2.GetDataGridView2().DataSource = null;
                    Control.background2.GetDataGridView2().EditMode   = DataGridViewEditMode.EditOnEnter;
                    Control.background2.GetDataGridView2().DataSource = Control.connection.ds;

                    Control.background2.GetDataGridView2().DataMember = Control.connection.ds.Tables[0].TableName;

                    Control.background2.GetDataGridView2().EnableHeadersVisualStyles = false;//这样就可以使用当前的主题的样式了,这句话十分关键!
                    Control.background2.GetDataGridView2().ColumnHeadersDefaultCellStyle.Font = new Font("隶书", 9, FontStyle.Italic);
                    Control.background2.GetDataGridView2().ColumnHeadersDefaultCellStyle.ForeColor = Color.Purple;
                    //Control.background2.SetFormerNum(Control.background2.GetDataGridView1().ColumnCount);
                }
                catch (Exception ee)
                {
                    MessageBox.Show("请检查您的指令!\ntips:" + ee.Message);
                }
            }
            if (this.treeView1.SelectedNode.Text == "Table")
            {
                Control.connection.SqlConn.Close();
                Control.connection.SqlConn = tvc.EsConOnTable1(this.treeView1.SelectedNode);
                //

                //
            }
            if (this.treeView1.SelectedNode.Name == "tb")
            {
                Control.connection.SqlConn.Close();
                Control.connection.SqlConn = tvc.EsConOnTable2(this.treeView1.SelectedNode);

                String sel_table = "select * from " + this.treeView1.SelectedNode.Text;
                Control.background.tableName = this.treeView1.SelectedNode.Text;
                NpgsqlCommand command = new NpgsqlCommand(sel_table, Control.connection.SqlConn);
                //   Control.connection.SqlConn.Open();
                try
                {
                    command.ExecuteNonQuery();
                    NpgsqlDataAdapter npgsql = new NpgsqlDataAdapter(sel_table, Control.connection.SqlConn);
                    Control.connection.ds = new DataSet();
                    npgsql.Fill(Control.connection.ds);
                    //Control.connection.SqlConn.Close();

                    Control.background.FullFilDataGrid();

                    //Control.background.GetDataGridView().DataMember = Control.connection.ds.Tables[0].TableName;

                    Control.background.GetDataGridView().EnableHeadersVisualStyles = false;//这样就可以使用当前的主题的样式了,这句话十分关键!
                    Control.background.GetDataGridView().ColumnHeadersDefaultCellStyle.Font = new Font("隶书", 9, FontStyle.Italic);
                    Control.background.GetDataGridView().ColumnHeadersDefaultCellStyle.ForeColor = Color.Purple;
                    Control.background.SetFormerNum(Control.background.GetDataGridView().ColumnCount);
                }
                catch (Exception ee)
                {
                    MessageBox.Show("请检查您的指令!\ntips:" + ee.Message);
                }
            }

            if (this.treeView1.SelectedNode.Name == "con")
            {
                Control.connection.SqlConn.Close();
                Control.connection.SqlConn = tvc.EsConOnColumn(this.treeView1.SelectedNode);
            }
        }