Пример #1
0
        // 添加到设计界面
        private void toolStripMenuItem1_Click(object sender, EventArgs e)
        {
            if (tvw.SelectedNode != null)
            {
                string      schemaName  = tvw.SelectedNode.Text;
                MySQLSchema mysqlSchema = _SelectedFields.Find(t => t.tbname.Equals(schemaName, StringComparison.CurrentCultureIgnoreCase));

                if (splitContainer1.Panel1.Controls.Find(mysqlSchema.tbnick, false).Length > 0)
                {
                    return;
                }

                UC_Table uctable = new UC_Table(mysqlSchema);
                uctable.Name        = mysqlSchema.tbnick;
                uctable.Close      += Uctable_Close;
                uctable.ClickField += Uctable_ClickField;
                uctable.AddJoin    += Uctable_AddJoin;

                splitContainer1.Panel1.Controls.Add(uctable);
                if (uctable.IsAccessible == false)
                {
                    uctable.BringToFront();
                }

                BuildSelect();
                AddSubMenu();
            }
        }
Пример #2
0
        private void Uctable_ClickField(string tbname, string fieldname, bool clicked)
        {
            // 更新选择状态
            MySQLSchema mysqlSchema = _SelectedFields.Find(t => t.tbname.Equals(tbname, StringComparison.CurrentCultureIgnoreCase));

            mysqlSchema.tbfields.Find(x => x.FieldName.Equals(fieldname, StringComparison.CurrentCultureIgnoreCase)).Checked = clicked;

            Application.DoEvents();
            BuildSQL();
        }
Пример #3
0
        public UC_Table(MySQLSchema mysqlSchema)
        {
            InitializeComponent();
            this.mysqlSchema = mysqlSchema;

            this.tipInfo.Text = mysqlSchema.tbname + "(" + mysqlSchema.tbnick + ")";
            int flagPos = this.tipInfo.Text.IndexOf("(");

            if (flagPos != -1)
            {
                this.tipInfo.LinkArea = new LinkArea(flagPos + 1, this.tipInfo.Text.Length - flagPos - 2);
            }

            checkedListBox1.Items.Clear();
            foreach (MySQLField sqlField in mysqlSchema.tbfields)
            {
                checkedListBox1.Items.Add(sqlField.FieldName);
            }
        }
Пример #4
0
        private void tvw_AfterSelect(object sender, TreeViewEventArgs e)
        {
            mysqlFields.Clear();

            tbx_TableName.Text = e.Node.Text;
            dt.Rows.Clear();
            //dgv.Rows.Clear();
            MySqlConnection dbConn = new MySqlConnection();

            try {
                dbConn.ConnectionString = getConnectionString();
                dbConn.Open();

                string       schemaName = e.Node.Text;
                MySqlCommand dbCmd      = new MySqlCommand();
                dbCmd.CommandText = "SHOW full COLUMNS FROM " + schemaName;
                dbCmd.Connection  = dbConn;

                MySqlDataAdapter dbAdapter = new MySqlDataAdapter(dbCmd);
                dbAdapter.Fill(dt);
                dt.TableName = Guid.NewGuid().ToString().Replace("-", "");

                dgv.DataSource = dt;
                List <MySQLField> _addFields = new List <MySQLField>();
                foreach (DataRow row in dt.Rows)
                {
                    MySQLField field = new MySQLField();
                    field.FieldName = row["field"].ToString();
                    field.Type      = row["type"].ToString();
                    field.Key       = row["key"].ToString();
                    field.Comment   = row["comment"].ToString();

                    mysqlFields.Add(field);
                    _addFields.Add(field);
                }


                if (_SelectedFields.Exists(t => t.tbname.Equals(schemaName, StringComparison.CurrentCultureIgnoreCase)) == false)
                {
                    string tpnick = "a";
                    //NickIndex index = nickIndex.Find(t => t.Name.Equals(schemaName));
                    //if(index == null) {
                    //    index = new NickIndex();
                    //    index.Name = schemaName;
                    //    index.Index = newNickIndex++;

                    //    nickIndex.Add(index);
                    //}
                    //tpnick += index.Index;

                    MySQLSchema mysqlSchema = new MySQLSchema();
                    mysqlSchema.tbname   = schemaName;
                    mysqlSchema.tbnick   = tpnick;
                    mysqlSchema.tbfields = _addFields;

                    _SelectedFields.Add(mysqlSchema);
                }
                //if(_SelectedFields.ContainsKey(e.Node.Text)== false) {
                //    _SelectedFields.Add(e.Node.Text,_addFields);
                //}
                //if(e.Node.Tag == null) {
                //    e.Node.Tag = mysqlFields;
                //}
            } catch (Exception exc) {
                Console.WriteLine(exc.ToString());
            } finally {
                dbConn.Close();
                dbConn = null;
            }

            if (tabControl2.SelectedTab == tp_selectBuilder && e.Node.Level >= 1)
            {
                contextMenuStrip1.Show(tvw, tvw.PointToClient(MousePosition));
            }
        }