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