/// <summary>
/// 判断所输药品名称是否与数据库中冲突
/// </summary>
/// <param name="drug"></param>
/// <param name="medicine"></param>
/// <returns></returns>
public bool isRepeatName(drugsroreContext drug, Medicine medicine)
{
var data = from u in drug.Medicines select u;
foreach (var item in data)
{
if (item.NAME == this.skinTextBox1.Text.Trim())
{
return(true);
}
}
return(false);
}
/// <summary>
/// 在checkedlistbox中显示数据库中药品种类名称
/// </summary>
public void Init()
{
drugsroreContext drug = new drugsroreContext();
var result = (from u in drug.Medicines select u);
int i = 0;
foreach (var item in result)
{
this.checkedListBox1.Items.AddRange(new object[]
{
item.NAME
});
i++;
}
}
/// <summary>
/// 新增药品种类界面确定按钮单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void skinButton8_Click(object sender, EventArgs e)
{
drugsroreContext drug = new drugsroreContext();
Medicine medicine = new Medicine();
if (this.skinTextBox1.Text.Equals("") || this.skinTextBox1.Text == null)
{
MessageBox.Show("请输入药品名称！");
}
else if (isRepeatName(drug, medicine))
{
MessageBox.Show("药品名称重复！");
}
else
{
medicine.ID = "";
medicine.NAME = this.skinTextBox1.Text;
medicine.DOSAGE = this.skinTextBox2.Text;
medicine.MOLECULES = this.skinComboBox2.Text;
medicine.STOCK_NUM = 0;
medicine.PROADRESS = this.skinTextBox3.Text;
medicine.LOTSELL_PRICE = this.skinTextBox4.Text;
medicine.SELL_PRICE = this.skinTextBox5.Text;
drug.Medicines.Add(medicine);
drug.SaveChanges();
MessageBox.Show("新增成功");
this.addDrugs.Hide();
var result = (from u in drug.Medicines where u.NAME == this.skinTextBox1.Text.Trim() select u);
foreach (var item in result)
{
this.checkedListBox1.Items.AddRange(new object[]
{
item.NAME
});
}
foreach (Control c in this.addDrugs.Controls) //遍历所有控件
{
if (c is SkinTextBox) //判断是否是textBox控件，是则清空
{
c.Text = "";
}
}
}
}
