/// <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);
        }