public void ShowBookForm(BookForm BookForm) { BookForm.TopLevel = false; //取消顶层 BookForm.FormBorderStyle = FormBorderStyle.None; //取消标题栏 this.panel1.Controls.Clear(); //清除之前的控制 BookForm.Dock = System.Windows.Forms.DockStyle.Fill; //填充panel this.panel1.Controls.Add(BookForm); BookForm.Show(); }
private void button4_Click(object sender, EventArgs e) { if (searchid == null || searchid == "") { MessageBox.Show("编号不能为空", "提示"); return; } int i = 0; //DataTable dt = (DataTable)dataGridView1.DataSource; for (i = 0; i < this.dataGridView2.Rows.Count; i++) { if ((string)dataGridView2.Rows[i].Cells["id"].Value == searchid) { dataGridView2.Rows[i].Selected = true; dataGridView2.FirstDisplayedScrollingRowIndex = i; break; } } try { id = dataGridView2.Rows[i].Cells[0].Value.ToString(); //获得当前行的第0列的值 name = dataGridView2.Rows[i].Cells[1].Value.ToString(); //获得当前行的第1列的值 publish = dataGridView2.Rows[i].Cells[2].Value.ToString(); //获得当前行的第2列的值 isbn = dataGridView2.Rows[i].Cells[3].Value.ToString(); //获得当前行的第3列的值 state = Convert.ToInt32(dataGridView2.Rows[i].Cells[4].Value.ToString()); //获得当前行的第4列的值 opendate = dataGridView2.Rows[i].Cells[5].Value.ToString(); //获得当前行的第5列的值 price = Convert.ToDouble(dataGridView2.Rows[i].Cells[6].Value.ToString()); //获得当前行的第6列的值 BookForm bf = new BookForm(); Console.WriteLine("新建bookform窗体..."); bf.id = searchid; bf.name = name; bf.publish = publish; bf.isbn = isbn; bf.state = state; bf.opendate = opendate; bf.price = Convert.ToDouble(price); bf.InitRecord(searchid); ShowBookForm(bf); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { } }
private void button1_Click(object sender, EventArgs e) { if (id == null || id == "") { MessageBox.Show("编号不能为空", "提示"); return; } id = textBox1.Text; String connstr = "SslMode=None;datasource=127.0.0.1;port=3306;userid=root;password=123456;pooling=false; database=library;"; MySqlConnection conn = new MySqlConnection(connstr); string sql = "SELECT * FROM book WHERE id='" + id + "';"; try { conn.Open(); Console.WriteLine("数据库连接成功..."); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { name = reader.GetString("name"); publish = reader.GetString("publish"); isbn = reader.GetString("isbn"); state = Convert.ToInt32(reader.GetString("state")); opendate = reader.GetString("opendate"); price = Convert.ToDouble(reader.GetString("price")); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { conn.Close(); } BookForm bf = new BookForm(); bf.id = id; bf.name = name; bf.publish = publish; bf.isbn = isbn; bf.state = state; bf.opendate = opendate; bf.price = price; Login.main.ShowBookForm(bf); //调用login类中静态全局变量main,保证调用对象相同 }
private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e) { int rowindex = e.RowIndex; Console.WriteLine("切换到图书..."); try { id = dataGridView2.Rows[rowindex].Cells[0].Value.ToString(); //获得当前行的第0列的值 name = dataGridView2.Rows[rowindex].Cells[1].Value.ToString(); //获得当前行的第1列的值 publish = dataGridView2.Rows[rowindex].Cells[2].Value.ToString(); //获得当前行的第2列的值 isbn = dataGridView2.Rows[rowindex].Cells[3].Value.ToString(); //获得当前行的第3列的值 state = Convert.ToInt32(dataGridView2.Rows[rowindex].Cells[4].Value.ToString()); //获得当前行的第4列的值 opendate = dataGridView2.Rows[rowindex].Cells[5].Value.ToString(); //获得当前行的第5列的值 price = Convert.ToDouble(dataGridView2.Rows[rowindex].Cells[6].Value.ToString()); //获得当前行的第6列的值 Console.WriteLine(id); //debugging... Console.WriteLine(name); Console.WriteLine(publish); Console.WriteLine(isbn); Console.WriteLine(state); Console.WriteLine(opendate); Console.WriteLine(price); BookForm bf = new BookForm(); Console.WriteLine("新建bookform窗体..."); bf.id = id; bf.name = name; bf.publish = publish; bf.isbn = isbn; bf.state = state; bf.opendate = opendate; bf.price = Convert.ToDouble(price); ShowBookForm(bf); } catch (Exception ex) { Console.WriteLine(ex.Message); } }