/// <summary> /// 删除按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { // 实例化商品类,并委托给代理者类添加到数据库 DB_GOODS goods = new DB_GOODS(name, type, price, unit, count); proxy.setRealSubject(goods); proxy.recordDelete(adapter, dataGridView1); proxy.recordSelect(adapter, dataGridView1); }
/// <summary> /// 增添商品按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { price = Convert.ToString(textBox3.Text); //if(textBox3.Text.Trim ()== String.Empty) type = Convert.ToString(textBox2.Text); name = Convert.ToString(textBox1.Text); unit = Convert.ToString(textBox4.Text); count = Convert.ToString(textBox5.Text); // 实例化商品类,并委托给代理者类添加到数据库 DB_GOODS goods = new DB_GOODS(name, type, price, unit, count); proxy.setRealSubject(goods); proxy.recordInsert(adapter); proxy.recordSelect(adapter, dataGridView1); }
/// <summary> /// 修改按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button3_Click(object sender, EventArgs e) //流程是先选中指定行,然后输入要修改的信息,再点击修改,弹出对话框修改完成,清空输入框内容 { //判断文本框是否为空值,空值则判断为null。 if (textBox3.Text.Trim() != String.Empty) { price = null; } else { price = Convert.ToString(textBox3.Text); } if (textBox3.Text.Trim() != String.Empty) { type = null; } else { type = Convert.ToString(textBox2.Text); } if (textBox3.Text.Trim() != String.Empty) { name = null; } else { name = Convert.ToString(textBox1.Text); } if (textBox3.Text.Trim() != String.Empty) { unit = null; } else { unit = Convert.ToString(textBox4.Text); } if (textBox3.Text.Trim() != String.Empty) { count = null; } else { count = Convert.ToString(textBox5.Text); } // 实例化商品类,并委托给代理者类添加到数据库 DB_GOODS goods = new DB_GOODS(name, type, price, unit, count); proxy.setRealSubject(goods); proxy.recordUpdate(adapter, dataGridView1); proxy.recordSelect(adapter, dataGridView1); }