1.通过网上查阅资料,建立数据库表,完成了对进销存系统的信息添加与删除功能.
添加药品实现代码:
private void button1_Click(object sender, EventArgs e)//添加按钮
{
string ActiveIngredient = null;//药品类型变量
if (radioButton1.Checked)
{
ActiveIngredient = radioButton1.Text.Trim();//接收按钮1的值
}
else if (radioButton2.Checked)
{
ActiveIngredient = radioButton2.Text.Trim();//接收按钮2的值
}
Dao dao = new Dao();
string sql = $" insert into Drugs values('{textBox1.Text}','{textBox2.Text}','{ActiveIngredient}','{textBox4.Text}',{textBox5.Text},{textBox6.Text})";
int n=dao.Execute(sql);
if(n > 0)
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}
}
2.删除药品实现代码
private void button3_Click(object sender, EventArgs e)//删除按钮
{
try
{
string id=dataGridView1.SelectedRows[0].Cells[0].Value.ToString();//药品编号强制转换成字符串
label2.Text=id+dataGridView1.SelectedRows[0].Cells[1].Value.ToString();//显示当前选中的药品
DialogResult dr =MessageBox.Show("确认删除吗?","信息提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);//弹出删除警示框
if(dr == DialogResult.OK)
{
string sql = $"delete from Drugs where DrugID='{id}'";
Dao dao=new Dao();
if (dao.Execute(sql)>0)
{
MessageBox.Show("删除成功");
Table();//重新获取数据
}
else
{
MessageBox.Show("删除失败"+sql);
}
dao.DaoClose();
}
}
catch
{
MessageBox.Show("请先选中要删除的药品记录","信息提示",MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}