public frmImport()
{
repClinic = new ClinicRepository();
repDefine = new DefineRepository();
repMedicine = new MedicineRepository();
repwh = new WareHouseRepository();
repwhDetail = new WareHouseDetailRepository();
_repwhIo = new WareHouseIORepository();
_repwhIoDetail = new WareHouseIODetailRepository();
InitializeComponent();
repClinic = new ClinicRepository();
FillToComboboxClinic(0);
dateImport.Value = DateTime.Now.Date;
try
{
InitGrid();
//bindingSource3.DataSource = repMedicine.GetAll();
}
catch (Exception ex)
{
throw;
}
}
public frmExportDetail(int exportId)
{
repClinic = new ClinicRepository();
repDefine = new DefineRepository();
repMedicine = new MedicineRepository();
repwh = new WareHouseRepository();
repwhDetail = new WareHouseDetailRepository();
_repwhIo = new WareHouseIORepository();
_repwhIoDetail = new WareHouseIODetailRepository();
whExport = new WareHouseExportAllocateRepository();
InitializeComponent();
repClinic = new ClinicRepository();
cbClinic.DataSource = repClinic.GetAll();
dateImport.Value = DateTime.Now.Date;
whPaperId = exportId;
try
{
InitGrid();
LoadData(exportId);
}
catch (Exception ex)
{
throw;
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
try
{
//Insert data to WareHousePaper
WareHouseIO wareHouseIo = new WareHouseIO();
wareHouseIo.ClinicId = int.Parse(cbClinic.SelectedValue.ToString());
wareHouseIo.Date = dateImport.Value.Date;
// wareHouseIo.Deliverer = txtDeliverer.Text;
//wareHouseIo.Recipient = txtRecipient.Text;
//wareHouseIo.Type = 0;
wareHouseIo.Version = 0;
wareHouseIo.No = txtNo.Text;
wareHouseIo.Note = txtNote.Text;
WareHouseIORepository wareHouseIoRepository = new WareHouseIORepository();
wareHouseIoRepository.Insert(wareHouseIo);
//Insert data to WareHousePaperDetail
foreach (DataGridViewRow row in grd.Rows)
{
if (ValidateRowData(row))
{
WareHouseIODetail item = new WareHouseIODetail();
//item.WareHousePaperId = wareHouseIo.Id;
item.LotNo = row.Cells["LotNo"].Value.ToString();
//item.Type = 0;
item.MedicineId = int.Parse(row.Cells["MedicineId"].Value.ToString());
//item.Volumn = int.Parse(row.Cells["Volumn"].Value.ToString());
//item.Unit = int.Parse(row.Cells["Unit"].Value.ToString());
item.UnitPrice = int.Parse(row.Cells["UnitPrice"].Value.ToString());
item.Amount = int.Parse(row.Cells["Amount"].Value.ToString());
item.ExpireDate = DateTime.Parse(row.Cells["ExpireDate"].Value.ToString());
if (row.Cells["Note"].Value != null)
{
//item.Note = row.Cells["Note"].Value.ToString();
item.CreatedDate = wareHouseIo.CreatedDate;
}
_repwhIoDetail.Insert(item);
//Insert data to WareHouse
var wareHouse = repwh.GetByIdMedicine(item.MedicineId, wareHouseIo.ClinicId);
if (wareHouse != null)
{
//wareHouse.Volumn += item.Volumn;
repwh.Update(wareHouse);
}
else
{
wareHouse = new WareHouse();
wareHouse.MedicineId = item.MedicineId;
wareHouse.ClinicId = wareHouseIo.ClinicId;
//wareHouse.Volumn = item.Volumn;
wareHouse.MinAllowed = 0;
repwh.Insert(wareHouse);
}
//Insert data to WareHouseDetail
WareHouseDetail wareHouseDetail = new WareHouseDetail();
wareHouseDetail.MedicineId = item.MedicineId;
wareHouseDetail.WareHouseId = wareHouse.Id;
wareHouseDetail.WareHouseIODetailId = item.Id;
wareHouseDetail.LotNo = item.LotNo;
wareHouseDetail.ExpiredDate = item.ExpireDate;
//wareHouseDetail.OriginalVolumn = item.Volumn;
//wareHouseDetail.CurrentVolumn = item.Volumn;
wareHouseDetail.BadVolumn = 0;
//wareHouseDetail.Unit = item.Unit;
wareHouseDetail.UnitPrice = item.UnitPrice.Value;
wareHouseDetail.CreatedDate = DateTime.Now;
wareHouseDetail.LastUpdatedDate = DateTime.Now;
repwhDetail.Insert(wareHouseDetail);
}
}
MessageBox.Show("Nhập kho thành công!");
dateImport.Value = DateTime.Now;
txtDeliverer.Text = string.Empty;
txtNo.Text = string.Empty;
txtNote.Text = string.Empty;
txtRecipient.Text = string.Empty;
grd.Rows.Clear();
}
catch (Exception ex)
{
}
}
private void LoadData()
{
WareHouseIORepository whIoRepository = new WareHouseIORepository();
int type = cbTypeWHPage.Text.Equals("Nhập kho", StringComparison.OrdinalIgnoreCase) ? 0 : (cbTypeWHPage.Text.Equals("Xuất kho", StringComparison.OrdinalIgnoreCase) ? 1 : -1);
//grd.DataSource = whIoRepository.Search("type", dpkFromDate.Value, dpkToDate.Value);
}
private void btnInsert_Click(object sender, EventArgs e)
{
try
{
//Insert data to WareHousePaper
WareHouseIO wareHouseIo = new WareHouseIO();
wareHouseIo.ClinicId = int.Parse(cbClinic.SelectedValue.ToString());
wareHouseIo.Date = dateImport.Value.Date;
//wareHouseIo.Deliverer = txtDeliverer.Text;
//wareHouseIo.Recipient = txtRecipient.Text;
//wareHouseIo.Type = 1;
wareHouseIo.Version = 0;
wareHouseIo.No = txtNo.Text;
wareHouseIo.Note = txtNote.Text;
WareHouseIORepository wareHouseIoRepository = new WareHouseIORepository();
wareHouseIoRepository.Insert(wareHouseIo);
foreach (DataGridViewRow row in grd.Rows)
{
if (row.Cells["Volumn"].Value != null)
{
int medicineId = int.Parse(row.Cells["MedicineIdHidden"].Value.ToString());
int export = int.Parse(row.Cells["Export"].Value.ToString());
//update data to WareHouse
var wareHouse = repwh.GetByIdMedicine(medicineId, AppContext.CurrentClinic.Id);
if (wareHouse != null)
{
wareHouse.Volumn -= export;
repwh.Update(wareHouse);
}
var list = repwhDetail.GetMeicineExport(wareHouse.Id, medicineId);
foreach (var obj in list)
{
if (obj.CurrentVolumn >= export)
{
//Update whDetail
obj.CurrentVolumn -= export;
repwhDetail.Update(obj);
//Insert data to WareHousePaperDetail
WareHouseIODetail item = new WareHouseIODetail();
//item.WareHousePaperId = wareHouseIo.Id;
item.LotNo = obj.LotNo;
//item.Type = 1;
item.MedicineId = obj.MedicineId;
//item.Volumn = export;
//item.Unit = obj.Unit;
item.UnitPrice = obj.UnitPrice;
item.ExpireDate = obj.ExpiredDate;
_repwhIoDetail.Insert(item);
//Insert whExportAllocate
WareHouseExportAllocate wareHouseExportAllocate = new WareHouseExportAllocate();
wareHouseExportAllocate.WareHouseDetailId = obj.Id;
wareHouseExportAllocate.WareHouseIODetailId = item.Id;
wareHouseExportAllocate.Volumn = export;
wareHouseExportAllocate.Unit = obj.Unit;
// whExport.Insert(wareHouseExportAllocate);
break;
}
else
{
//Insert data to WareHousePaperDetail
WareHouseIODetail item = new WareHouseIODetail();
//item.WareHousePaperId = wareHouseIo.Id;
item.LotNo = obj.LotNo;
//item.Type = 1;
item.MedicineId = obj.MedicineId;
//item.Volumn = obj.CurrentVolumn;
//item.Unit = obj.Unit;
item.UnitPrice = obj.UnitPrice;
item.ExpireDate = obj.ExpiredDate;
_repwhIoDetail.Insert(item);
export -= obj.CurrentVolumn;
//Update whDetail
obj.CurrentVolumn = 0;
repwhDetail.Update(obj);
//Insert whExportAllocate
WareHouseExportAllocate wareHouseExportAllocate = new WareHouseExportAllocate();
wareHouseExportAllocate.WareHouseDetailId = obj.Id;
wareHouseExportAllocate.WareHouseIODetailId = item.Id;
wareHouseExportAllocate.Volumn = obj.CurrentVolumn;
wareHouseExportAllocate.Unit = obj.Unit;
// whExport.Insert(wareHouseExportAllocate);
}
}
}
}
MessageBox.Show("Xuất kho thành công!");
dateImport.Value = DateTime.Now;
txtDeliverer.Text = string.Empty;
txtNo.Text = string.Empty;
txtNote.Text = string.Empty;
txtRecipient.Text = string.Empty;
grd.Rows.Clear();
}
catch (Exception ex)
{
}
}