private void RemoveDetail(Janus.Windows.GridEX.GridEXRow gridExRow)
{
try
{
string manhacungcap = "";
string NgayHethan = "";
DateTime dtmNgayHethan = DateTime.Now;
string solo = "";
int id_thuoc = -1;
decimal dongia = 0m;
decimal Giaban = 0m;
decimal GiaBhyt = 0m;
Int32 soluong = 0;
decimal vat = 0m;
int isHetHan = 0;
long IdThuockho = 0;
DateTime NgayNhap = DateTime.Now;
NgayNhap = Convert.ToDateTime(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.NgayNhap].Value).Date;
dtmNgayHethan = Convert.ToDateTime(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.NgayHethan].Value).Date;
NgayHethan = Utility.sDbnull(gridExRow.Cells["NGAY_HET_HAN"].Value);
solo = Utility.sDbnull(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.SoLo].Value);
id_thuoc = Utility.Int32Dbnull(gridExRow.Cells[TThuockho.Columns.IdThuoc].Value, -1);
IdThuockho = Utility.Int32Dbnull(gridExRow.Cells[TThuockho.Columns.IdChuyen].Value, -1);
dongia = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.GiaNhap].Value, 0);
GiaBhyt = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.GiaBhyt].Value, 0);
Giaban = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.GiaBan].Value, 0);
soluong = Utility.Int32Dbnull(gridExRow.Cells["SO_LUONG"].Value, 0);
vat = Utility.DecimaltoDbnull(gridExRow.Cells[TThuockho.Columns.Vat].Value, 0);
isHetHan = Utility.Int32Dbnull(gridExRow.Cells["IsHetHan"].Value, 0);
manhacungcap = Utility.sDbnull(gridExRow.Cells[TThuockho.Columns.MaNhacungcap].Value, 0);
DataRow[] arrDr = m_dtDataThuocKho.Select(TPhieuNhapxuatthuocChitiet.Columns.IdThuockho + "=" + IdThuockho.ToString());
if (arrDr.Length <= 0)
{
DataRow drv = m_dtDataThuocKho.NewRow();
drv[TPhieuNhapxuatthuocChitiet.Columns.IdThuoc] = id_thuoc;
drv["ten_donvitinh"] = Utility.sDbnull(gridExRow.Cells["ten_donvitinh"].Value);
drv["IsHetHan"] = isHetHan;
DmucThuoc objLDrug = DmucThuoc.FetchByID(id_thuoc);
if (objLDrug != null)
{
drv[DmucThuoc.Columns.TenThuoc] = Utility.sDbnull(objLDrug.TenThuoc);
drv[DmucThuoc.Columns.HamLuong] = Utility.sDbnull(objLDrug.HamLuong);
drv[DmucThuoc.Columns.HoatChat] = Utility.sDbnull(objLDrug.HoatChat);
drv[DmucThuoc.Columns.NuocSanxuat] = Utility.sDbnull(objLDrug.NuocSanxuat);
drv[DmucThuoc.Columns.HangSanxuat] = Utility.sDbnull(objLDrug.HangSanxuat);
}
drv[TPhieuNhapxuatthuocChitiet.Columns.Vat] = vat;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaBhyt] = GiaBhyt;
drv[TPhieuNhapxuatthuocChitiet.Columns.NgayNhap] = NgayNhap;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaNhap] = dongia;
drv[TPhieuNhapxuatthuocChitiet.Columns.DonGia] = dongia;
drv[TPhieuNhapxuatthuocChitiet.Columns.MaNhacungcap] = manhacungcap;
drv[TPhieuNhapxuatthuocChitiet.Columns.SoLo] = solo;
drv[TPhieuNhapxuatthuocChitiet.Columns.SoDky] = Utility.sDbnull(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.SoDky].Value);
drv[TPhieuNhapxuatthuocChitiet.Columns.SoQdinhthau] = Utility.sDbnull(gridExRow.Cells[TPhieuNhapxuatthuocChitiet.Columns.SoQdinhthau].Value);
drv[TPhieuNhapxuatthuocChitiet.Columns.IdThuockho] = IdThuockho;
drv[TPhieuNhapxuatthuocChitiet.Columns.GiaBan] = Giaban;
drv[TPhieuNhapxuatthuocChitiet.Columns.SluongChia] = Utility.Int32Dbnull(gridExRow.Cells[DmucThuoc.Columns.SluongChia].Value, 0); ;
drv[TPhieuNhapxuatthuocChitiet.Columns.SoLuong] = soluong;
drv[TPhieuNhapxuatthuocChitiet.Columns.ThanhTien] = dongia * soluong;
drv[TPhieuNhapxuatthuocChitiet.Columns.ChietKhau] = 0;
drv["NGAY_HET_HAN"] = NgayHethan;
drv[TPhieuNhapxuatthuocChitiet.Columns.NgayHethan] = dtmNgayHethan;
drv[TPhieuNhapxuatthuocChitiet.Columns.IdPhieu] = -1;
m_dtDataThuocKho.Rows.Add(drv);
}
else
{
arrDr[0]["SO_LUONG"] = Utility.Int32Dbnull(arrDr[0]["SO_LUONG"]) + soluong;
//arrDr[0]["SO_LUONG_THAT"] = Utility.Int32Dbnull(arrDr[0]["SO_LUONG"],0) + Utility.Int32Dbnull(arrDr[0]["sLuongAo"], 0);
m_dtDataThuocKho.AcceptChanges();
}
gridExRow.Delete();
grdPhieuXuatChiTiet.UpdateData();
grdPhieuXuatChiTiet.Refresh();
m_dtDataPhieuChiTiet.AcceptChanges();
m_dtDataThuocKho.AcceptChanges();
ModifyCommand();
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi hủy chuyển thuốc:\n" + ex.Message);
}
}
private void RemoveDetail(Janus.Windows.GridEX.GridEXRow gridExRow)
{
try
{
gridExRow.Delete();
grdPhieuXuatChiTiet.UpdateData();
grdPhieuXuatChiTiet.Refresh();
m_dtDataPhieuChiTiet.AcceptChanges();
ModifyCommand();
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi trả trả thuốc:\n" + ex.Message);
}
}
