private void button2_Click(object sender, EventArgs e)
{
if (txtDname.Text == "")
{
PromptingForm p = new PromptingForm("请选择需要修改的数据 !");
p.ShowDialog();
return;
}
Drug_insert Dupdate = new Drug_insert();
Dupdate.Dname = txtDname.Text;
Dupdate.Dtype = cboDtype.Text;
Dupdate.DcostName = cboDcostName.Text;
Dupdate.Dspec = cboDspec.Text;
Dupdate.DjiXing = cboDjiXing.Text;
Dupdate.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dupdate.DsellPrice = int.Parse(txtDsellPrice.Text);
Dupdate.Dstock = int.Parse(txtDstock.Text);
Dupdate.DstockMax = int.Parse(txtDstockMax.Text);
Dupdate.DstockMin = int.Parse(txtDstockMin.Text);
Dupdate.DeffectTime = dtpDproductTime.Text;
Dupdate.DproductTime = dtpDeffectTime.Text;
Dupdate.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Update(Dupdate);
button3_Click(null, null);
PromptingForm pp = new PromptingForm(mes);
pp.ShowDialog();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtDname.Text == "")
{
MessageBox.Show("请选择需要修改的数据 !");
return;
}
Drug_insert Dupdate = new Drug_insert();
Dupdate.Dname = txtDname.Text;
Dupdate.Dtype = cboDtype.Text;
Dupdate.DcostName = cboDcostName.Text;
Dupdate.Dspec = cboDspec.Text;
Dupdate.DjiXing = cboDjiXing.Text;
Dupdate.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dupdate.DsellPrice = int.Parse(txtDsellPrice.Text);
Dupdate.Dstock = int.Parse(txtDstock.Text);
Dupdate.DstockMax = int.Parse(txtDstockMax.Text);
Dupdate.DstockMin = int.Parse(txtDstockMin.Text);
Dupdate.DeffectTime = dtpDproductTime.Text;
Dupdate.DproductTime = dtpDeffectTime.Text;
Dupdate.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Update(Dupdate);
txtDname.Text = "";
btnSelect_Click(null, null);
MessageBox.Show(mes);
}
public string Delete(Drug_insert di)
{
int re = new Drug_insert_DAL().Delete(di);
if (re == 0)
{
return("药品删除成功");
}
else
{
return("药品删除失败");
}
}
public string Update(Drug_insert di)
{
int re = new Drug_insert_DAL().Update(di);
if (re == 0)
{
return("药品修改成功");
}
else
{
return("药品修改失败");
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
foreach (Control item in groupBox1.Controls)
{
if (item is TextBox)
{
if (item.Text == "")
{
PromptingForm p = new PromptingForm("请把信息填写完整 !");
p.ShowDialog();
return;
}
}
if (item is ComboBox)
{
if (item.Text == "")
{
PromptingForm p = new PromptingForm("请把信息填写完整 !");
p.ShowDialog();
return;
}
}
}
Drug_insert Dinsert = new Drug_insert();
Dinsert.Dname = txtDname.Text;
Dinsert.Dtype = cboDtype.Text;
Dinsert.DcostName = cboDcostName.Text;
Dinsert.Dspec = cboDspec.Text;
Dinsert.DjiXing = cboDjiXing.Text;
Dinsert.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dinsert.DsellPrice = int.Parse(txtDsellPrice.Text);
Dinsert.Dstock = int.Parse(txtDstock.Text);
Dinsert.DstockMax = int.Parse(txtDstockMax.Text);
Dinsert.DstockMin = int.Parse(txtDstockMin.Text);
Dinsert.DeffectTime = dtpDproductTime.Text;
Dinsert.DproductTime = dtpDeffectTime.Text;
Dinsert.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Insert(Dinsert);
txtDname.Text = "";
btnSelect_Click(null, null);
PromptingForm pp = new PromptingForm(mes);
pp.ShowDialog();
}
public string Insert(Drug_insert di)
{
int re = new Drug_insert_DAL().Insert(di);
if (re == 0)
{
return("该药品已经存在");
}
else if (re == 1)
{
return("药品添加成功");
}
else
{
return("药品添加失败");
}
}
public int Delete(Drug_insert di)
{
SqlParameter Dname = new SqlParameter("@DName", SqlDbType.VarChar);
Dname.Value = di.Dname;
SqlParameter[] sp = { Dname };
bool f = DBHelper.ExecuteNonQueryProc("Drug_Delete_p", sp);
if (f)
{
return(0); //(int)result.Value;
}
else
{
return(-1);
}
}
public int Insert(Drug_insert di)
{
SqlParameter Dname = new SqlParameter("@DName", SqlDbType.VarChar);
SqlParameter Dtype = new SqlParameter("@Dtype", SqlDbType.VarChar);
SqlParameter DcostName = new SqlParameter("@DcostName", SqlDbType.VarChar);
SqlParameter Dspec = new SqlParameter("@Dspec", SqlDbType.VarChar);
SqlParameter DjiXing = new SqlParameter("@DjiXing", SqlDbType.VarChar);
SqlParameter DinsertPrice = new SqlParameter("@DinsertPrice", SqlDbType.Int);
SqlParameter DsellPrice = new SqlParameter("@DsellPrice", SqlDbType.Int);
SqlParameter Dstock = new SqlParameter("@Dstock", SqlDbType.Int);
SqlParameter DstockMax = new SqlParameter("@DstockMax", SqlDbType.Int);
SqlParameter DstockMin = new SqlParameter("@DstockMin", SqlDbType.Int);
SqlParameter DeffectTime = new SqlParameter("@DeffectTime", SqlDbType.SmallDateTime);
SqlParameter DproductTime = new SqlParameter("@DproductTime", SqlDbType.SmallDateTime);
SqlParameter Efficay = new SqlParameter("@Efficay", SqlDbType.VarChar);
SqlParameter result = new SqlParameter("@result", SqlDbType.Int);
result.Direction = ParameterDirection.Output;
Dname.Value = di.Dname;
Dtype.Value = di.Dtype;
DcostName.Value = di.DcostName;
Dspec.Value = di.Dspec;
DjiXing.Value = di.DjiXing;
DinsertPrice.Value = di.DinsertPrice;
DsellPrice.Value = di.DsellPrice;
Dstock.Value = di.Dstock;
DstockMax.Value = di.DstockMax;
DstockMin.Value = di.DstockMin;
DeffectTime.Value = di.DeffectTime;
DproductTime.Value = di.DproductTime;
Efficay.Value = di.Efficay;
SqlParameter[] sp = { Dname, Dtype, DcostName, Dspec, DjiXing, DinsertPrice, DsellPrice, Dstock, DstockMax, DstockMin, DeffectTime, DproductTime, Efficay, result };
bool f = DBHelper.ExecuteNonQueryProc("Drug_insert_p", sp);
if (f)
{
return((int)result.Value);
}
else
{
return(-1);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtDname.Text == "" && lvwShow.SelectedItems.Count == 0)
{
PromptingForm p = new PromptingForm("请选择需要删除的数据 !");
p.ShowDialog();
return;
}
Drug_insert Ddelete = new Drug_insert();
Ddelete.Dname = txtDname.Text;
DialogResult dr = MessageBox.Show("确定要删除吗？", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
string mes = new Drug_insert_BLL().Delete(Ddelete);
txtDname.Text = "";
comboBox1_SelectedIndexChanged(null, null);
PromptingForm p = new PromptingForm(mes);
p.ShowDialog();
}
}
public List <Drug_insert> SelectAll(string Sname)
{
List <Drug_insert> di = new List <Drug_insert>();
SqlParameter pid = new SqlParameter("@Dname", SqlDbType.VarChar);
pid.Value = Sname;
bool f = DBHelper.ExecuteBatchProc("Drug_SelectName_p", pid);
if (f == true)
{
while (DBHelper.reader.Read())
{
Drug_insert dri = new Drug_insert();
dri.Dname = DBHelper.reader["Dname"] + "";
dri.Dtype = DBHelper.reader["Dtype"] + "";
dri.DcostName = DBHelper.reader["DcostName"] + "";
dri.Dspec = DBHelper.reader["Dspec"] + "";
dri.DjiXing = DBHelper.reader["DjiXing"] + "";
dri.DinsertPrice = Convert.ToInt32(DBHelper.reader["DinsertPrice"]);
dri.DsellPrice = Convert.ToInt32(DBHelper.reader["DsellPrice"]);
dri.Dstock = Convert.ToInt32(DBHelper.reader["Dstock"]);
dri.DstockMax = Convert.ToInt32(DBHelper.reader["DstockMax"]);
dri.DstockMin = Convert.ToInt32(DBHelper.reader["DstockMin"]);
dri.DeffectTime = DBHelper.reader["DeffectTime"] + "";
dri.DproductTime = DBHelper.reader["DproductTime"] + "";
dri.Efficay = DBHelper.reader["Efficay"] + "";
di.Add(dri);
}
}
DBHelper.con.Close();
DBHelper.reader.Dispose();
DBHelper.cmd.Dispose();
DBHelper.con.Dispose();
return(di);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Button btn = e.Source as Button;
string s = btn.Content.ToString();
switch (s)
{
case "查找":
if (txtDname.Text == "")
{
var t1 = new Tip("请输入药品名字！");
t1.ShowDialog();
return;
}
lvwShow.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtDname.Text);
if (di.Count == 0)
{
var t2 = new Tip("没有你要查找的数据！");
t2.ShowDialog();
return;
}
lvwShow.Items.Clear();
for (int i = 0; i < di.Count; i++)
{
lvwShow.Items.Add(new
{
drugname = di[i].Dname,
type = di[i].Dtype,
fare = di[i].DcostName,
dosetype = di[i].Dspec,
spec = di[i].DjiXing,
in_price = di[i].DinsertPrice,
sell_price = di[i].DsellPrice,
stock = di[i].Dstock,
stockMax = di[i].DstockMax,
stockMin = di[i].DstockMin,
proDate = di[i].DeffectTime,
effDate = di[i].DproductTime,
effect = di[i].Efficay
});
}
break;
case "药品出库":
if (txtDname.Text == "" && lvwShow.SelectedItems.Count == 0)
{
var t1 = new Tip("请选择需要删除的数据 !");
t1.ShowDialog();
return;
}
Drug_insert Ddelete = new Drug_insert();
Ddelete.Dname = txtDname.Text;
string mes = new Drug_insert_BLL().Delete(Ddelete);
lvwShow.Items.RemoveAt(lvwShow.SelectedIndex);
txtDname.Text = "";
Init_Load();
var p = new Tip(mes);
p.ShowDialog();
break;
case "清除":
txtDname.Text = "";
break;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Button btn = e.Source as Button;
string s = btn.Content.ToString();
switch (s)
{
case "清空全部":
txtDinsertPrice.Text = "";
txtDname.Text = "";
txtDsellPrice.Text = "";
txtDstock.Text = "";
txtDstockMax.Text = "";
txtDstockMin.Text = "";
txtEfficay.Text = "";
cboDcostName.Text = "";
cboDjiXing.Text = "";
cboDspec.Text = "";
cboDtype.Text = "";
dtpDeffectTime.Text = "";
dtpDproductTime.Text = "";
break;
case "显示全部":
#region 列表添加显示所有药品
List <Drug_insert> di = new Drug_insert_BLL().SelectAll("");
for (int i = 0; i < di.Count; i++)
{
lvwShow.Items.Add(new
{
drugname = di[i].Dname,
type = di[i].Dtype,
fare = di[i].DcostName,
dosetype = di[i].Dspec,
spec = di[i].DjiXing,
in_price = di[i].DinsertPrice,
sell_price = di[i].DsellPrice,
stock = di[i].Dstock,
stockMax = di[i].DstockMax,
stockMin = di[i].DstockMin,
proDate = di[i].DeffectTime,
effDate = di[i].DproductTime,
effect = di[i].Efficay
});
}
#endregion
break;
case "药品修改":
if (txtDname.Text == "")
{
Tip p = new Tip("请选择需要修改的数据 !");
p.ShowDialog();
return;
}
Drug_insert Dupdate = new Drug_insert();
Dupdate.Dname = txtDname.Text;
Dupdate.Dtype = cboDtype.Text;
Dupdate.DcostName = cboDcostName.Text;
Dupdate.Dspec = cboDspec.Text;
Dupdate.DjiXing = cboDjiXing.Text;
Dupdate.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dupdate.DsellPrice = int.Parse(txtDsellPrice.Text);
Dupdate.Dstock = int.Parse(txtDstock.Text);
Dupdate.DstockMax = int.Parse(txtDstockMax.Text);
Dupdate.DstockMin = int.Parse(txtDstockMin.Text);
Dupdate.DeffectTime = dtpDproductTime.Text;
Dupdate.DproductTime = dtpDeffectTime.Text;
Dupdate.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Update(Dupdate);
break;
case "药品入库":
Drug_Insert();
break;
}
}
//药品入库
private void Drug_Insert()
{
#region 控件列表集合
List <Control> con_list = new List <Control>()
{
txtDinsertPrice,
txtDname,
txtDsellPrice,
txtDstock,
txtDstockMax,
txtDstockMin,
txtEfficay,
cboDcostName,
cboDjiXing,
cboDspec,
cboDtype,
dtpDeffectTime,
dtpDproductTime
};
#endregion
foreach (Control item in con_list)
{
if (item is TextBox)
{
if (((TextBox)item).Text == "")
{
Tip p = new Tip("请把信息填写完整 !");
p.ShowDialog();
return;
}
}
if (item is ComboBox)
{
if (((ComboBox)item).Text == "")
{
Tip p = new Tip("请把信息填写完整 !");
p.ShowDialog();
return;
}
}
}
Drug_insert Dinsert = new Drug_insert();
Dinsert.Dname = txtDname.Text;
Dinsert.Dtype = cboDtype.Text;
Dinsert.DcostName = cboDcostName.Text;
Dinsert.Dspec = cboDspec.Text;
Dinsert.DjiXing = cboDjiXing.Text;
Dinsert.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dinsert.DsellPrice = int.Parse(txtDsellPrice.Text);
Dinsert.Dstock = int.Parse(txtDstock.Text);
Dinsert.DstockMax = int.Parse(txtDstockMax.Text);
Dinsert.DstockMin = int.Parse(txtDstockMin.Text);
Dinsert.DeffectTime = dtpDproductTime.Text;
Dinsert.DproductTime = dtpDeffectTime.Text;
Dinsert.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Insert(Dinsert);
txtDname.Text = "";
Method();
Tip pp = new Tip(mes);
pp.ShowDialog();
}
