/// <summary>
/// hàm thực hiện việc lấy thông tin chi tiết
/// </summary>
/// <returns></returns>
private TPhieutrathuocKholeVekhochanChitiet[] CreateArrPhieuChiTiet()
{
List <TPhieutrathuocKholeVekhochanChitiet> lstItems = new List <TPhieutrathuocKholeVekhochanChitiet>();
foreach (DataRow dr in m_dtDataPhieuChiTiet.Rows)
{
TPhieutrathuocKholeVekhochanChitiet newItem = new TPhieutrathuocKholeVekhochanChitiet();
newItem.IdThuoc =
Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.IdThuoc]);
newItem.NgayHethan =
Convert.ToDateTime(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.NgayHethan]).Date;
newItem.DonGia = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.DonGia], 0);
newItem.GiaNhap = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.GiaNhap], 0);
newItem.GiaBan = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.GiaBan], 0);
newItem.SoLuong = Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.SoLuong], 0);
newItem.ThanhTien =
Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.GiaNhap]) *
Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.SoLuong]);
newItem.Vat = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.Vat], 0);
newItem.IdPhieu = Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.IdPhieu], -1);
newItem.KieuThuocvattu = KIEU_THUOC_VT;
newItem.NgayNhap = Convert.ToDateTime(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.NgayNhap]).Date;
newItem.GiaBhyt = Utility.DecimaltoDbnull(dr[TPhieuNhapxuatthuocChitiet.Columns.GiaBhyt]);
newItem.PhuthuDungtuyen = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.PhuthuDungtuyen]);
newItem.PhuthuTraituyen = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.PhuthuTraituyen]);
newItem.SoLo = Utility.sDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.SoLo], 0);
newItem.SoDky = Utility.sDbnull(dr[TPhieuNhapxuatthuocChitiet.Columns.SoDky], "");
newItem.SoQdinhthau = Utility.sDbnull(dr[TPhieuNhapxuatthuocChitiet.Columns.SoQdinhthau], "");
newItem.IdThuockho = Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.IdThuockho], 0);
newItem.IdChuyen = Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.IdChuyen], 0);
newItem.MaNhacungcap = Utility.sDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.MaNhacungcap], 0);
lstItems.Add(newItem);
}
return(lstItems.ToArray());
}
/// <summary>
/// hàm thực hiện việc xóa thông tin
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdXoaThongTin_Click(object sender, EventArgs e)
{
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdPhieuXuatChiTiet.GetCheckedRows())
{
int ID = Utility.Int32Dbnull(gridExRow.Cells[TPhieutrathuocKholeVekhochanChitiet.Columns.IdPhieuChitiet].Value);
TPhieutrathuocKholeVekhochanChitiet.Delete(ID);
gridExRow.Delete();
grdPhieuXuatChiTiet.UpdateData();
m_dtDataPhieuChiTiet.AcceptChanges();
}
ModifyCommand();
}
/// <summary>
/// hàm thực hiện việc lấy thông tin chi tiết
/// </summary>
/// <returns></returns>
private TPhieutrathuocKholeVekhochanChitiet[] CreateArrPhieuChiTiet()
{
List<TPhieutrathuocKholeVekhochanChitiet> lstItems = new List<TPhieutrathuocKholeVekhochanChitiet>();
foreach (DataRow dr in m_dtDataPhieuChiTiet.Rows)
{
TPhieutrathuocKholeVekhochanChitiet newItem = new TPhieutrathuocKholeVekhochanChitiet();
newItem.IdThuoc =
Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.IdThuoc]);
newItem.NgayHethan =
Convert.ToDateTime(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.NgayHethan]).Date;
newItem.DonGia = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.DonGia], 0);
newItem.GiaNhap = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.GiaNhap], 0);
newItem.GiaBan = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.GiaBan], 0);
newItem.SoLuong = Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.SoLuong], 0);
newItem.ThanhTien =
Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.GiaNhap]) *
Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.SoLuong]);
newItem.Vat = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.Vat], 0);
newItem.IdPhieu = Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.IdPhieu], -1);
newItem.KieuThuocvattu = KIEU_THUOC_VT;
newItem.NgayNhap = Convert.ToDateTime(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.NgayNhap]).Date;
newItem.GiaBhyt = Utility.DecimaltoDbnull(dr[TPhieuNhapxuatthuocChitiet.Columns.GiaBhyt]);
newItem.PhuthuDungtuyen = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.PhuthuDungtuyen]);
newItem.PhuthuTraituyen = Utility.DecimaltoDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.PhuthuTraituyen]);
newItem.SoLo = Utility.sDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.SoLo], 0);
newItem.SoDky = Utility.sDbnull(dr[TPhieuNhapxuatthuocChitiet.Columns.SoDky], "");
newItem.SoQdinhthau = Utility.sDbnull(dr[TPhieuNhapxuatthuocChitiet.Columns.SoQdinhthau], "");
newItem.IdThuockho = Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.IdThuockho], 0);
newItem.IdChuyen = Utility.Int32Dbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.IdChuyen], 0);
newItem.MaNhacungcap = Utility.sDbnull(dr[TPhieutrathuocKholeVekhochanChitiet.Columns.MaNhacungcap], 0);
lstItems.Add(newItem);
}
return lstItems.ToArray();
}
/// <summary>
/// Kiểm tra xem thuốc trong kho xuất đã được sử dụng hay chưa?
/// </summary>
/// <param name="objPhieuNhap"></param>
/// <param name="objPhieuNhapCt"></param>
/// <returns></returns>
public ActionResult Kiemtrathuochuyxacnhan(TPhieutrathuocKholeVekhochan objPhieuNhap, TPhieutrathuocKholeVekhochanChitiet objPhieuNhapCt)
{
TThuockhoCollection vCollection = new TThuockhoController().FetchByQuery(
TThuockho.CreateQuery()
.WHERE(TThuockho.IdKhoColumn.ColumnName, Comparison.Equals, objPhieuNhap.IdKhonhan)
.AND(TThuockho.IdThuocColumn.ColumnName, Comparison.Equals, objPhieuNhapCt.IdThuoc)
.AND(TThuockho.NgayHethanColumn.ColumnName, Comparison.Equals, objPhieuNhapCt.NgayHethan.Date)
.AND(TThuockho.GiaNhapColumn.ColumnName, Comparison.Equals, objPhieuNhapCt.GiaNhap)
.AND(TThuockho.GiaBanColumn.ColumnName, Comparison.Equals, objPhieuNhapCt.GiaBan)
);
if (vCollection.Count <= 0)
{
return(ActionResult.Exceed); //Lỗi không có dòng dữ liệu trong bảng kho-thuốc
}
int SoLuong = vCollection[0].SoLuong;
SoLuong = SoLuong - objPhieuNhapCt.SoLuong;
if (SoLuong < 0)
{
return(ActionResult.NotEnoughDrugInStock); //Thuốc đã sử dụng nhiều nên không thể hủy
}
return(ActionResult.Success);
}
public void Insert(int IdPhieu,DateTime NgayHethan,int IdThuoc,decimal GiaNhap,decimal GiaBan,decimal? DonGia,int SoLuong,string SoLo,int? ChietKhau,decimal ThanhTien,decimal Vat,long? IdThuockho,long? IdChuyen,string MaNhacungcap,string KieuThuocvattu,short? ThangDu,decimal? GiaBhyt,DateTime? NgayNhap)
{
TPhieutrathuocKholeVekhochanChitiet item = new TPhieutrathuocKholeVekhochanChitiet();
item.IdPhieu = IdPhieu;
item.NgayHethan = NgayHethan;
item.IdThuoc = IdThuoc;
item.GiaNhap = GiaNhap;
item.GiaBan = GiaBan;
item.DonGia = DonGia;
item.SoLuong = SoLuong;
item.SoLo = SoLo;
item.ChietKhau = ChietKhau;
item.ThanhTien = ThanhTien;
item.Vat = Vat;
item.IdThuockho = IdThuockho;
item.IdChuyen = IdChuyen;
item.MaNhacungcap = MaNhacungcap;
item.KieuThuocvattu = KieuThuocvattu;
item.ThangDu = ThangDu;
item.GiaBhyt = GiaBhyt;
item.NgayNhap = NgayNhap;
item.Save(UserName);
}
/// <summary>
/// hàm thực hiện việc cập nhập thông tin nhập kho thuốc
/// </summary>
/// <param name="objPhieuNhap"></param>
/// <param name="arrPhieuNhapCts"></param>
/// <returns></returns>
public ActionResult UpdatePhieuTraLaiKho(TPhieutrathuocKholeVekhochan objPhieuNhap, TPhieutrathuocKholeVekhochanChitiet[] arrPhieuNhapCts)
{
try
{
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
objPhieuNhap.NgaySua = globalVariables.SysDate;
objPhieuNhap.NguoiSua = globalVariables.UserName;
objPhieuNhap.MarkOld();
objPhieuNhap.IsNew = false;
objPhieuNhap.Save();
new Delete().From(TPhieutrathuocKholeVekhochanChitiet.Schema)
.Where(TPhieutrathuocKholeVekhochanChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu).Execute();
foreach (TPhieutrathuocKholeVekhochanChitiet objPhieuNhapTraCt in arrPhieuNhapCts)
{
objPhieuNhapTraCt.ThanhTien = Utility.DecimaltoDbnull(objPhieuNhapTraCt.GiaNhap)*
Utility.Int32Dbnull(objPhieuNhapTraCt.SoLuong);
objPhieuNhapTraCt.IdPhieu = Utility.Int32Dbnull(objPhieuNhap.IdPhieu, -1);
objPhieuNhapTraCt.IsNew = true;
objPhieuNhapTraCt.Save();
}
}
Scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
log.Error("Loi trong qua trinh sua phieu nhap kho :{0}", exception);
return ActionResult.Error;
}
}
/// <summary>
/// hàm thực hiện việc thêm phiếu nhập kho thuốc
/// </summary>
/// <param name="objPhieuNhap"></param>
/// <param name="arrPhieuNhapCts"></param>
/// <returns></returns>
public ActionResult ThemPhieuTraLaiKho(TPhieutrathuocKholeVekhochan objPhieuNhap, TPhieutrathuocKholeVekhochanChitiet[] arrPhieuNhapCts)
{
try
{
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
objPhieuNhap.NgayTao = globalVariables.SysDate;
objPhieuNhap.NguoiTao = globalVariables.UserName;
objPhieuNhap.MaPhieu = Utility.sDbnull(THU_VIEN_CHUNG.MaTraLaiKho());
objPhieuNhap.IsNew = true;
objPhieuNhap.Save();
if (objPhieuNhap != null)
{
foreach (TPhieutrathuocKholeVekhochanChitiet objPhieuNhapTraCt in arrPhieuNhapCts)
{
objPhieuNhapTraCt.ThanhTien = Utility.DecimaltoDbnull(objPhieuNhapTraCt.GiaNhap) *
Utility.Int32Dbnull(objPhieuNhapTraCt.SoLuong);
objPhieuNhapTraCt.IdPhieu = Utility.Int32Dbnull(objPhieuNhap.IdPhieu, -1);
objPhieuNhapTraCt.IsNew = true;
objPhieuNhapTraCt.Save();
}
}
}
Scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
log.Error("Loi trong qua trinh them phieu nhap kho :{0}", exception);
return ActionResult.Error;
}
}
/// <summary>
/// Kiểm tra xem thuốc trong kho xuất đã được sử dụng hay chưa?
/// </summary>
/// <param name="objPhieuNhap"></param>
/// <param name="objPhieuNhapCt"></param>
/// <returns></returns>
public ActionResult Kiemtrathuochuyxacnhan(TPhieutrathuocKholeVekhochan objPhieuNhap, TPhieutrathuocKholeVekhochanChitiet objPhieuNhapCt)
{
TThuockhoCollection vCollection = new TThuockhoController().FetchByQuery(
TThuockho.CreateQuery()
.WHERE(TThuockho.IdKhoColumn.ColumnName, Comparison.Equals, objPhieuNhap.IdKhonhan)
.AND(TThuockho.IdThuocColumn.ColumnName, Comparison.Equals, objPhieuNhapCt.IdThuoc)
.AND(TThuockho.NgayHethanColumn.ColumnName, Comparison.Equals, objPhieuNhapCt.NgayHethan.Date)
.AND(TThuockho.GiaNhapColumn.ColumnName, Comparison.Equals, objPhieuNhapCt.GiaNhap)
.AND(TThuockho.GiaBanColumn.ColumnName, Comparison.Equals, objPhieuNhapCt.GiaBan)
);
if (vCollection.Count <= 0) return ActionResult.Exceed;//Lỗi không có dòng dữ liệu trong bảng kho-thuốc
int SoLuong = vCollection[0].SoLuong;
SoLuong = SoLuong - objPhieuNhapCt.SoLuong;
if (SoLuong < 0) return ActionResult.NotEnoughDrugInStock;//Thuốc đã sử dụng nhiều nên không thể hủy
return ActionResult.Success;
}
public void Update(long IdPhieuChitiet,long IdPhieu,DateTime NgayHethan,int IdThuoc,decimal GiaNhap,decimal GiaBan,decimal? DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,int SoLuong,string SoLo,int? ChietKhau,decimal ThanhTien,decimal Vat,long? IdThuockho,long? IdChuyen,string MaNhacungcap,string KieuThuocvattu,short? ThangDu,decimal? GiaBhyt,DateTime? NgayNhap,string SoDky,string SoQdinhthau)
{
TPhieutrathuocKholeVekhochanChitiet item = new TPhieutrathuocKholeVekhochanChitiet();
item.MarkOld();
item.IsLoaded = true;
item.IdPhieuChitiet = IdPhieuChitiet;
item.IdPhieu = IdPhieu;
item.NgayHethan = NgayHethan;
item.IdThuoc = IdThuoc;
item.GiaNhap = GiaNhap;
item.GiaBan = GiaBan;
item.DonGia = DonGia;
item.PhuthuDungtuyen = PhuthuDungtuyen;
item.PhuthuTraituyen = PhuthuTraituyen;
item.SoLuong = SoLuong;
item.SoLo = SoLo;
item.ChietKhau = ChietKhau;
item.ThanhTien = ThanhTien;
item.Vat = Vat;
item.IdThuockho = IdThuockho;
item.IdChuyen = IdChuyen;
item.MaNhacungcap = MaNhacungcap;
item.KieuThuocvattu = KieuThuocvattu;
item.ThangDu = ThangDu;
item.GiaBhyt = GiaBhyt;
item.NgayNhap = NgayNhap;
item.SoDky = SoDky;
item.SoQdinhthau = SoQdinhthau;
item.Save(UserName);
}
