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));
}
