/// <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 = ""; } } } }