protected void gridXuathang_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { int IDPhieuXuat = Convert.ToInt32(e.Keys[0].ToString()); using (var scope = new TransactionScope()) { try { var XuatKho = DBDataProvider.DB.kPhieuXuatKhacs.Where(x => x.IDPhieuXuat == IDPhieuXuat).FirstOrDefault(); if (XuatKho != null) { if (XuatKho.DaXoa == 0) { XuatKho.DaXoa = 1; // đã xóa List <kPhieuXuatKhacChiTiet> ctXuatKho = DBDataProvider.XuatKhacKhoChiTiet(IDPhieuXuat); foreach (var xk in ctXuatKho) { int IDHangHoa = Convert.ToInt32(xk.HangHoaID); int SoLuong = Convert.ToInt32(xk.SoLuong); var HangHoa = DBDataProvider.DB.hhHangHoas.Where(x => x.IDHangHoa == IDHangHoa).FirstOrDefault(); if (HangHoa != null) { #region ghi thẻ kho kTheKho thekho = new kTheKho(); thekho.NgayNhap = DateTime.Now; thekho.DienGiai = "Xóa phiếu xuất khác #" + XuatKho.MaPhieuXuat; thekho.Nhap = SoLuong; thekho.Xuat = 0; thekho.Ton = HangHoa.hhTonKhos.Where(tk => tk.ChiNhanhID == XuatKho.ChiNhanhID).FirstOrDefault().SoLuong += SoLuong; // cộng tồn kho luôn thekho.HangHoaID = IDHangHoa; thekho.GiaThoiDiem = 0; thekho.NhanVienID = Formats.IDUser(); thekho.ChiNhanhID = Formats.IDChiNhanh(); DBDataProvider.DB.kTheKhos.InsertOnSubmit(thekho); #endregion } } DBDataProvider.DB.SubmitChanges(); scope.Complete(); } } } catch (Exception ex) { throw ex; } } gridXuathang.CancelEdit(); e.Cancel = true; gridXuathang.DataBind(); }