private void btnSave_Click(object sender, EventArgs e) { try { TimeSpan sp = dtpDue.Value.Subtract(dtpProDate.Value); AddMedicine addMedicine = new AddMedicine(); addMedicine.MedID = txtMedId.Text.Trim(); addMedicine.MedName = txtName.Text.Trim(); addMedicine.Production = cmbProduce.Text.Trim(); addMedicine.ProduteDate = dtpProDate.Value; addMedicine.DueDate = dtpDue.Value; addMedicine.ReleaseDay = Convert.ToInt32(sp.Days); addMedicine.Quantity = Convert.ToInt32(numSum.Value); addMedicine.MedBid = Convert.ToDecimal(numBid.Text); addMedicine.MedUnitPrice = Convert.ToDecimal(numSale.Text.Trim()); addMedicine.Memary = txtMemary.Text.Trim(); if (BllMedicine.InsertInMed(addMedicine)) { MessageBox.Show(@"添加成功!"); Information.Medicine = null; this.Close(); } else { MessageBox.Show(@"添加失败,请检查后重试!"); } } catch (Exception ex) { MessageBox.Show(@"需要输入纯数字的地方是否正确输入!" + ex); return; } }
private void button2_Click(object sender, EventArgs e) { AddMedicine am = new AddMedicine(this); am.Show(); this.Hide(); }
private void 修改库存信息ToolStripMenuItem_Click(object sender, EventArgs e) { if (dgvMedicine.CurrentRow == null) { MessageBox.Show(@"请选择需要修改的行!"); return; } AddMedicine addMedicine = new AddMedicine(); addMedicine.MedID = dgvMedicine.CurrentRow.Cells["MedID"].Value.ToString(); addMedicine.MedName = dgvMedicine.CurrentRow.Cells["MedName"].Value.ToString(); addMedicine.MedBarCode = dgvMedicine.CurrentRow.Cells["MedBarCode"].Value.ToString(); addMedicine.Production = dgvMedicine.CurrentRow.Cells["Production"].Value.ToString(); addMedicine.ProduteDate = dgvMedicine.CurrentRow.Cells["ProduteDate"].Value.SafeDbDateTime(); addMedicine.ReleaseDay = dgvMedicine.CurrentRow.Cells["ReleaseDay"].Value.SafeDbInt32(); addMedicine.Quantity = dgvMedicine.CurrentRow.Cells["Quantity"].Value.SafeDbInt32(); addMedicine.MedBid = dgvMedicine.CurrentRow.Cells["MedBid"].Value.SafeDbDecimal(); addMedicine.MedUnitPrice = dgvMedicine.CurrentRow.Cells["MedUnitPrice"].Value.SafeDbDecimal(); addMedicine.Memary = dgvMedicine.CurrentRow.Cells["Memary"].Value.ToString(); addMedicine.DueDate = dgvMedicine.CurrentRow.Cells["DueDate"].Value.SafeDbDateTime(); Medicine medicine = new Medicine(); medicine.MedUnit = dgvMedicine.CurrentRow.Cells["MedUnit"].Value.ToString(); medicine.MedStandard = dgvMedicine.CurrentRow.Cells["MedStandard"].Value.ToString(); medicine.MedTypeId = dgvMedicine.CurrentRow.Cells["StyleName"].Value.ToString(); medicine.MedApproval = dgvMedicine.CurrentRow.Cells["MedApproval"].Value.ToString(); FrmAddMedStock frmAddMed = new FrmAddMedStock(@"修改", addMedicine, medicine); frmAddMed.ShowDialog(); btnSearch_Click(null, null); }
public FrmAddMedStock(string operateStyle, AddMedicine addMedicine, Medicine medicine) { InitializeComponent(); _operateStyle = operateStyle; _addMedicine = addMedicine; _medicine = medicine; IniteData(); }
/// <summary> /// 药品入库 /// </summary> /// <param name="medId"></param> /// <param name="medName"></param> /// <param name="medbarcode"></param> /// <param name="proction"></param> /// <param name="prodateTime"></param> /// <param name="expirationTime"></param> /// <param name="releaseDay"></param> /// <param name="sum"></param> /// <param name="bid"></param> /// <param name="price"></param> /// <param name="memary"></param> /// <param name="empId"></param> /// <returns></returns> public static bool InsertInMed(AddMedicine addMedicine) { string sql = $@"if not exists (select * from InMed where MedID = '{addMedicine.MedID}' and MedBarCode = '{addMedicine.MedBarCode}') Begin insert into InMed(MedID, MedBarCode, Production, InDate, ProduteDate, DueDate, ReleaseDay, Quantity, MedBid, MedUnitPrice, Memary) values('{addMedicine.MedID}','{addMedicine.MedBarCode}','{addMedicine.Production}',GETDATE(),'{addMedicine.ProduteDate}','{addMedicine.DueDate}','{addMedicine.ReleaseDay}','{addMedicine.Quantity}','{addMedicine.MedBid}','{addMedicine.MedUnitPrice}','{addMedicine.Memary}') Insert into MedLog(OperType,Notes,OperateTime,OperateEmpID) values('药品进货','编号:{addMedicine.MedID},名称:{addMedicine.MedName},条码:{addMedicine.MedBarCode},数量:{addMedicine.Quantity},进价:{addMedicine.MedBid},售价:{addMedicine.MedUnitPrice},保质期:{addMedicine.ReleaseDay},备注:{addMedicine.Memary}',GETDATE(),'{Information.CurrentUser.Id}') End else Begin Update InMed set Production= '{addMedicine.Production}',ProduteDate = '{addMedicine.ProduteDate}',DueDate = '{addMedicine.DueDate}', ReleaseDay = '{addMedicine.ReleaseDay}',Quantity = '{addMedicine.Quantity}',MedBid = '{addMedicine.MedBid}',MedUnitPrice = '{addMedicine.MedUnitPrice}',Memary = '{addMedicine.Memary}' where MedID = '{addMedicine.MedID}' and MedBarCode = '{addMedicine.MedBarCode}' Insert into MedLog(OperType,Notes,OperateTime,OperateEmpID) values('库存修改','编号:{addMedicine.MedID},名称:{addMedicine.MedName},条码:{addMedicine.MedBarCode},数量:{addMedicine.Quantity},进价:{addMedicine.MedBid},售价:{addMedicine.MedUnitPrice},保质期:{addMedicine.ReleaseDay},备注:{addMedicine.Memary}',GETDATE(),'{Information.CurrentUser.Id}') End"; return(ExecuteNonQuery(sql) > 0); }
public static bool InsertInMed(AddMedicine addMedicine) { return(ErpServer.InsertInMed(addMedicine)); }