1.药品查询功能
代码:
//从数据库读取数据显示到表
public void Table()
{
dataGridView1.Rows.Clear();//清空旧数据
Dao dao = new Dao();
string sql = "select * from Drugs";
IDataReader dc=dao.read(sql);
while (dc.Read())
{
dataGridView1.Rows.Add(dc[0].ToString(), dc[1].ToString(), dc[2].ToString(), dc[3].ToString(), dc[4].ToString(), dc[5].ToString());
}
dc.Close();
dao.DaoClose();
}
//根据药品编号查询
public void DrugID()
{
dataGridView1.Rows.Clear();//清空旧数据
Dao dao = new Dao();
string sql = $"select * from Drugs where DrugID='{textBox1.Text}'";
IDataReader dc = dao.read(sql);
while (dc.Read())
{
dataGridView1.Rows.Add(dc[0].ToString(), dc[1].ToString(), dc[2].ToString(), dc[3].ToString(), dc[4].ToString(), dc[5].ToString());
}
dc.Close();
dao.DaoClose();
}
//根据药品名称查询
public void DrugName()
{
dataGridView1.Rows.Clear();//清空旧数据
Dao dao = new Dao();
string sql = $"select * from Drugs where DrugName like '%{textBox2.Text}%'";
IDataReader dc = dao.read(sql);
while (dc.Read())
{
dataGridView1.Rows.Add(dc[0].ToString(), dc[1].ToString(), dc[2].ToString(), dc[3].ToString(), dc[4].ToString(), dc[5].ToString());
}
dc.Close();
dao.DaoClose();
}
2.修改药品功能
2.代码
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的值
}
string sql = $"update Drugs set DrugID='{textBox1.Text}',DrugName='{textBox2.Text}',ActiveIngredient='{ActiveIngredient}',ManufacturerDate='{textBox4.Text}',Number={textBox5.Text},Price={textBox6.Text} where DrugID='{ID}'";
Dao dao = new Dao();
if (dao.Execute(sql)>0)
{
MessageBox.Show("修改成功");
this.Close();
}
}