/// <summary> /// hàm thực hiệnv iệc update thông tin của biên lại hóa đơn /// </summary> /// <param name="objhoalog"></param> /// <param name="objPayment"></param> /// <param name="HOADON_CAPPHAT_ID"></param> /// <returns></returns> public ActionResult UpdateBienLaiHoaDon(HoadonLog objhoalog, KcbThanhtoan objPayment, int HOADON_CAPPHAT_ID) { try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { objhoalog.IdThanhtoan = Utility.Int32Dbnull(objPayment.IdThanhtoan); objhoalog.IdBenhnhan = Utility.Int32Dbnull(objPayment.IdBenhnhan); objhoalog.MaLuotkham = Utility.sDbnull(objPayment.MaLuotkham); objhoalog.MaNhanvien = globalVariables.UserName; objhoalog.NgayIn = globalVariables.SysDate; objhoalog.TrangThai = 0; objhoalog.IsNew = true; objhoalog.Save(); new Update(HoadonCapphat.Schema) .Set(HoadonCapphat.Columns.SerieHientai).EqualTo(objhoalog.Serie) .Set(HoadonCapphat.Columns.TrangThai).EqualTo(1) .Where(HoadonCapphat.Columns.IdCapphat).IsEqualTo(HOADON_CAPPHAT_ID). Execute(); } Scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { return ActionResult.Error; } }
protected override void On_ActionEdit(object sender, EventArgs e) { using (TransactionScope ts = new TransactionScope( )) { using (SharedDbConnectionScope ss = new SharedDbConnectionScope( )) { try { if (formView.Save<SysCompanyAd>(AdsID) == 0) { ts.Complete( ); txtMessage.InnerHtml = "保存成功"; //formView.ClearValue( ); } else txtMessage.InnerHtml = "保存失败"; } catch (Exception ex) { txtMessage.InnerHtml = ex.Message; Logging.Log("CompanyAdsEdit->On_ActionEdit", ex, true); } } } On_ActionQuery(sender, e); }
public ActionResult HUYCHOT_CAPPHAT(List <int> lstIDDonthuoc, Int16 id_kho, DateTime ngayhuy, string lydohuy) { int v_intResult; ActionResult actResult; try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { TPhieuXuatthuocBenhnhanCollection vCollection = new Select() .From(TPhieuXuatthuocBenhnhan.Schema) .Where(TPhieuXuatthuocBenhnhan.IdDonthuocColumn).In(lstIDDonthuoc) .And(TPhieuXuatthuocBenhnhan.NgayChotColumn).IsNotNull() .And(TPhieuXuatthuocBenhnhan.IdKhoColumn).IsEqualTo(id_kho) .ExecuteAsCollection <TPhieuXuatthuocBenhnhanCollection>(); List <int> lstIdchot = (from p in vCollection select Utility.Int32Dbnull(p.IdChot, -1)).ToList <int>(); foreach (TPhieuXuatthuocBenhnhan _item in vCollection) { new Update(TPhieuXuatthuocBenhnhan.Schema.TableName) .Set(TPhieuXuatthuocBenhnhan.NgayChotColumn).EqualTo(null) .Set(TPhieuXuatthuocBenhnhan.NgayHuychotColumn).EqualTo(ngayhuy) .Set(TPhieuXuatthuocBenhnhan.LydoHuychotColumn).EqualTo(lydohuy) .Set(TPhieuXuatthuocBenhnhan.NguoiHuychotColumn).EqualTo(globalVariables.UserName) .Set(TPhieuXuatthuocBenhnhan.IdChotColumn).EqualTo(null) .Where(TPhieuXuatthuocBenhnhan.IdPhieuColumn).IsEqualTo(_item.IdPhieu) .Execute(); new Update(KcbDonthuoc.Schema.TableName) .Set(KcbDonthuoc.NgayChotColumn).EqualTo(null) .Set(KcbDonthuoc.NgayHuychotColumn).EqualTo(ngayhuy) .Set(KcbDonthuoc.LydoHuychotColumn).EqualTo(lydohuy) .Set(KcbDonthuoc.NguoiHuychotColumn).EqualTo(globalVariables.UserName) .Set(KcbDonthuoc.IdChotColumn).EqualTo(null) .Where(KcbDonthuoc.IdDonthuocColumn).IsEqualTo(_item.IdDonthuoc) .Execute(); } int itemremains = new Select() .From(TPhieuXuatthuocBenhnhan.Schema) .Where(TPhieuXuatthuocBenhnhan.IdChotColumn).In(lstIdchot) .And(TPhieuXuatthuocBenhnhan.NgayChotColumn).IsNotNull() .And(TPhieuXuatthuocBenhnhan.IdKhoColumn).IsEqualTo(id_kho) .ExecuteAsCollection <TPhieuXuatthuocBenhnhanCollection>().Count; if (itemremains <= 0) { new Delete().From(TLichsuChotthuoc.Schema).Where(TLichsuChotthuoc.IdChotColumn).In(lstIdchot).Execute(); } } scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { Utility.ShowMsg("Lỗi:\n" + ex.ToString()); return(ActionResult.Error); } }
/// <summary> /// ham thực hiện việc cạp nhập thông tin của update /// </summary> /// <param name="objChidinhclsChitiet"></param> /// <param name="AceeptStatus"></param> /// <returns></returns> public ActionResult PerformActionUpdate(KcbChidinhclsChitiet objChidinhclsChitiet) { try { using (var scope = new TransactionScope()) { using (var sp = new SharedDbConnectionScope()) { new Update(KcbChidinhclsChitiet.Schema) .Set(KcbChidinhclsChitiet.Columns.TrangThai).EqualTo(objChidinhclsChitiet.TrangThai) .Set(KcbChidinhclsChitiet.Columns.KetQua).EqualTo(objChidinhclsChitiet.KetQua) .Set(KcbChidinhclsChitiet.Columns.ImgPath1).EqualTo(objChidinhclsChitiet.ImgPath1) .Set(KcbChidinhclsChitiet.Columns.ImgPath2).EqualTo(objChidinhclsChitiet.ImgPath2) .Set(KcbChidinhclsChitiet.Columns.ImgPath3).EqualTo(objChidinhclsChitiet.ImgPath3) .Set(KcbChidinhclsChitiet.Columns.ImgPath4).EqualTo(objChidinhclsChitiet.ImgPath4) .Set(KcbChidinhclsChitiet.Columns.FTPImage).EqualTo(objChidinhclsChitiet.FTPImage) .Set(KcbChidinhclsChitiet.Columns.IdKhoaThuchien).EqualTo(objChidinhclsChitiet.IdKhoaThuchien) .Set(KcbChidinhclsChitiet.Columns.IdPhongThuchien).EqualTo(objChidinhclsChitiet.IdPhongThuchien) .Set(KcbChidinhclsChitiet.Columns.NgayThuchien).EqualTo(objChidinhclsChitiet.NgayThuchien) .Set(KcbChidinhclsChitiet.Columns.NguoiThuchien).EqualTo(objChidinhclsChitiet.NguoiThuchien) .Set(KcbChidinhclsChitiet.Columns.NgaySua).EqualTo(objChidinhclsChitiet.NgayThuchien) .Set(KcbChidinhclsChitiet.Columns.NguoiSua).EqualTo(objChidinhclsChitiet.NguoiThuchien) .Where(KcbChidinhclsChitiet.Columns.IdChitietchidinh).IsEqualTo(objChidinhclsChitiet.IdChitietchidinh). Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { return(ActionResult.Error); } }
public static ActionResult ChuyenPhong(long idKham, string lydoChuyen, DmucDichvukcb objDichvuKcb) { try { ActionResult actionResult = ActionResult.Success; using (var scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { int sttkham = THU_VIEN_CHUNG.LaySothutuKCB(objDichvuKcb.IdPhongkham); new Update(KcbDangkyKcb.Schema) .Set(KcbDangkyKcb.Columns.IdPhongkham).EqualTo(objDichvuKcb.IdPhongkham) .Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(-1) .Set(KcbDangkyKcb.Columns.SttKham).EqualTo(sttkham) .Set(KcbDangkyKcb.Columns.IdDichvuKcb).EqualTo(objDichvuKcb.IdDichvukcb) .Set(KcbDangkyKcb.Columns.IdKieukham).EqualTo(objDichvuKcb.IdKieukham) .Set(KcbDangkyKcb.Columns.TenDichvuKcb).EqualTo(objDichvuKcb.TenDichvukcb.ToUpper()) .Set(KcbDangkyKcb.Columns.NgayDangky).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.NguoiChuyen).EqualTo(globalVariables.UserName) .Set(KcbDangkyKcb.Columns.NgayChuyen).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.LydoChuyen).EqualTo(lydoChuyen) .Set(KcbDangkyKcb.Columns.TrangthaiChuyen).EqualTo(1) .Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(idKham) .Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n" + ex.Message); return(ActionResult.Exception); } }
public ActionResult UpdateXacNhanDaThucHien(int IdChitietchidinh, int TrangThai, int TrangthaiXacnhan) { try { using (var scope = new TransactionScope()) { using (var sps = new SharedDbConnectionScope()) { new Update(KcbChidinhclsChitiet.Schema) .Set(KcbChidinhclsChitiet.Columns.TrangThai).EqualTo(TrangThai) .Set(KcbChidinhclsChitiet.Columns.TrangthaiXacnhan).EqualTo(TrangthaiXacnhan) .Set(KcbChidinhclsChitiet.Columns.NgayThuchien).EqualTo(globalVariables.SysDate) .Set(KcbChidinhclsChitiet.Columns.NguoiThuchien).EqualTo(globalVariables.UserName) .Where(KcbChidinhclsChitiet.Columns.IdChitietchidinh).IsEqualTo(IdChitietchidinh). Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { return(ActionResult.Error); } }
protected override void On_ActionEdit(object sender, EventArgs e) { using (TransactionScope ts = new TransactionScope( )) { using (SharedDbConnectionScope ss = new SharedDbConnectionScope( )) { try { if (CompanyBLL.IsMaxPointLevel(CurrentUser.CompanyId.Value, 0)) txtMessage.InnerHtml = "累计赠送的积分已经超过500,须进行积分结算后才能继续操作系统"; else if (formView.Save<SysCompanyAd>(AdsID) == 0) { ts.Complete( ); txtMessage.InnerHtml = "保存成功"; //formView.ClearValue( ); } else txtMessage.InnerHtml = "保存失败"; } catch (Exception ex) { Logging.Log("CompanyAdsEdit->On_ActionEdit", ex, true); txtMessage.InnerHtml = ex.Message; } } } On_ActionQuery(sender, e); }
public ActionResult CHOT_CAPPHAT(List <int> lstIDDonthuoc, DateTime Ngay_Chot) { int v_intResult; ActionResult actResult; try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { TLichsuChotthuoc _newItem = new TLichsuChotthuoc(); _newItem.NgayChot = Ngay_Chot; _newItem.NguoiChot = globalVariables.UserName; _newItem.IsNew = true; _newItem.Save(); object obj = TLichsuChotthuoc.CreateQuery().GetMax("ID_CHOT"); TPhieuXuatthuocBenhnhanCollection vCollection = new TPhieuXuatthuocBenhnhanCollection(); v_intResult = new Update(TPhieuXuatthuocBenhnhan.Schema.TableName).Set(TPhieuXuatthuocBenhnhan.NgayChotColumn).EqualTo(Ngay_Chot) .Set(TPhieuXuatthuocBenhnhan.IdChotColumn).EqualTo(Utility.Int32Dbnull(obj, -1)) .Where(TPhieuXuatthuocBenhnhan.NgayChotColumn).IsNull() .And(TPhieuXuatthuocBenhnhan.IdDonthuocColumn).In(lstIDDonthuoc) .Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { Utility.ShowMsg("Lỗi:\n" + ex.ToString()); return(ActionResult.Error); } }
/// <summary> /// /// </summary> /// <param name="objPatientExam"></param> /// <param name="Khoanoitru_tonghop">true= Khoa nội trú tự chốt dữ liệu;fasle= Khoa tổng hợp chốt dữ liệu</param> /// <returns></returns> public static ActionResult TongHopChiPhi(KcbLuotkham objPatientExam,short idKhoanoitru, bool Khoanoitru_tonghop) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.TrangthaiNoitru).EqualTo(Utility.Int32Dbnull(objPatientExam.TrangthaiNoitru)) .Set(KcbLuotkham.Columns.TthaiThopNoitru).EqualTo(Utility.Int32Dbnull(objPatientExam.TthaiThopNoitru)) .Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName) .Set(KcbLuotkham.Columns.NgaySua).EqualTo(DateTime.Now) .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham) .And(KcbLuotkham.Columns.IdBenhnhan) .IsEqualTo(Utility.Int32Dbnull(objPatientExam.IdBenhnhan)) .Execute(); SPs.NoitruChotdulieuravien(objPatientExam.MaLuotkham, objPatientExam.IdBenhnhan, idKhoanoitru, Utility.Bool2byte(Khoanoitru_tonghop), (byte)(Utility.Byte2Bool(KcbLuotkham.Columns.TthaiThopNoitru) ? 1 : 0)).Execute(); } scope.Complete(); return ActionResult.Success; } } catch (Exception ex) { return ActionResult.Error; } }
public static ActionResult ChuyenPhong(long IdKham,string LydoChuyen, DmucDichvukcb objDichvuKcb) { try { ActionResult _ActionResult = ActionResult.Success; using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { new Update(KcbDangkyKcb.Schema) .Set(KcbDangkyKcb.Columns.IdPhongkham).EqualTo(objDichvuKcb.IdPhongkham) .Set(KcbDangkyKcb.Columns.IdDichvuKcb).EqualTo(objDichvuKcb.IdDichvukcb) .Set(KcbDangkyKcb.Columns.IdKieukham).EqualTo(objDichvuKcb.IdKieukham) .Set(KcbDangkyKcb.Columns.TenDichvuKcb).EqualTo(objDichvuKcb.TenDichvukcb) .Set(KcbDangkyKcb.Columns.NgayDangky).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.NguoiChuyen).EqualTo(globalVariables.UserName) .Set(KcbDangkyKcb.Columns.NgayChuyen).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.LydoChuyen).EqualTo(LydoChuyen) .Set(KcbDangkyKcb.Columns.TrangthaiChuyen).EqualTo(1) .Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(IdKham) .Execute(); } Scope.Complete(); return ActionResult.Success; } } catch (Exception ex) { Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n"+ex.Message); return ActionResult.Exception; } }
public static ActionResult UpdatePatientInfo(LPatientInfo pitems) { try { using (var scope = new TransactionScope()) { using (var sp = new SharedDbConnectionScope()) { if (LPatientInfo.FetchByID(pitems.PatientId) != null) { new Update(LPatientInfo.Schema) .Set(LPatientInfo.Columns.YearBirth).EqualTo(pitems.YearBirth) .Set(LPatientInfo.Columns.PatientName).EqualTo(pitems.PatientName) .Set(LPatientInfo.Columns.ObjectType).EqualTo(pitems.ObjectType) .Set(LPatientInfo.Columns.DepartmentID).EqualTo(pitems.DepartmentID) .Set(LPatientInfo.Columns.Sex).EqualTo(pitems.Sex) .Set(LPatientInfo.Columns.Address).EqualTo(pitems.Address) .Set(LPatientInfo.Columns.Room).EqualTo(pitems.Room) .Set(LPatientInfo.Columns.Bed).EqualTo(pitems.Bed) .Set(LPatientInfo.Columns.InsuranceNum).EqualTo(pitems.InsuranceNum) .Set(LPatientInfo.Columns.IdentifyNum).EqualTo(pitems.IdentifyNum) .Where(LPatientInfo.Columns.PatientId).IsEqualTo(pitems.PatientId).Execute(); } scope.Complete(); return(ActionResult.Success); } } } catch (Exception exception) { return(ActionResult.Error); } }
public ActionResult DanhdautrangthaiTiem(KcbDonthuocChitiet objChitiet, long _IdKham, bool Da_tiem) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { if (objChitiet != null) { objChitiet.IsNew = false; objChitiet.DaDung = Utility.Bool2byte(Da_tiem); objChitiet.MarkOld(); objChitiet.Save(); } else { new Update(KcbDonthuocChitiet.Schema) .Set(KcbDonthuocChitiet.Columns.DaDung).EqualTo(Utility.Bool2byte(Da_tiem)) .Where(KcbDonthuocChitiet.Columns.IdKham).IsEqualTo(_IdKham) .Execute(); } } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { log.Error("Loi trong qua trinh chuyen vien khoi noi tru {0}", exception); return(ActionResult.Error); } }
protected override void On_ActionAdd(object sender, EventArgs e) { if (AppContext.Context.CompanyType == CompanyType.MealCompany) { txtMessage.InnerHtml = "阁下的商家类型无权使用此功能"; return; } if (!ValidateData( )) { txtMessage.InnerHtml = "保存失败!"; return; } try { using (TransactionScope ts = new TransactionScope( )) { using (SharedDbConnectionScope ss = new SharedDbConnectionScope( )) { SaveData( ); OrderBLL.UpdateBalance( ); ts.Complete( ); } } txtMessage.InnerHtml = "保存成功!"; ResetField( ); } catch (Exception ex) { Logging.Log("FinanceCash->On_ActionAdd", ex, true); txtMessage.InnerHtml = ex.Message; } }
public static bool NoptienTamung(NoitruTamung objTamung) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { objTamung.Save(); KcbLuotkham objKcbLuotkham = Utility.getKcbLuotkham(objTamung.IdBenhnhan, objTamung.MaLuotkham); if (objKcbLuotkham != null) { objKcbLuotkham.IsNew = false; objKcbLuotkham.MarkOld(); if (Utility.ByteDbnull(objKcbLuotkham.TrangthaiNoitru, 0) == 1) { objKcbLuotkham.TrangthaiNoitru = 2; objKcbLuotkham.Save(); } } } scope.Complete(); } return(true); } catch (Exception ex) { return(false); } }
/// <summary> /// Threadings the target. /// </summary> /// <param name="state">The state.</param> public void ThreadingTarget(object state) { int index = (int)state; //string p1OriginalProductName = new Product(1).ProductName; //string p2OriginalProductName = new Product(2).ProductName; //using(TransactionScope ts = new TransactionScope()) //{ // using(SharedDbConnectionScope connScope = new SharedDbConnectionScope()) // { // SaveProduct(1, "new name of product 1"); // SaveProduct(2, "new name of product 2"); // } //} //Assert.AreEqual(p1OriginalProductName, new Product(1).ProductName); //Assert.AreEqual(p2OriginalProductName, new Product(2).ProductName); using (TransactionScope ts = new TransactionScope()) { using (SharedDbConnectionScope connScope = new SharedDbConnectionScope()) { SaveProduct(1, "product 1 process " + index.ToString()); SaveProduct(2, "product 2 process " + index.ToString()); } ts.Complete(); } resetEvents[index].Set(); }
/// <summary> /// </summary> /// <param name="objPatientExam"></param> /// <param name="Khoanoitru_tonghop">true= Khoa nội trú tự chốt dữ liệu;fasle= Khoa tổng hợp chốt dữ liệu</param> /// <returns></returns> public static ActionResult TongHopChiPhi(KcbLuotkham objPatientExam, short idKhoanoitru, bool Khoanoitru_tonghop) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.TrangthaiNoitru) .EqualTo(Utility.Int32Dbnull(objPatientExam.TrangthaiNoitru)) .Set(KcbLuotkham.Columns.TthaiThopNoitru) .EqualTo(Utility.Int32Dbnull(objPatientExam.TthaiThopNoitru)) .Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName) .Set(KcbLuotkham.Columns.NgaySua).EqualTo(DateTime.Now) .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham) .And(KcbLuotkham.Columns.IdBenhnhan) .IsEqualTo(Utility.Int32Dbnull(objPatientExam.IdBenhnhan)) .Execute(); SPs.NoitruChotdulieuravien(objPatientExam.MaLuotkham, objPatientExam.IdBenhnhan, idKhoanoitru, Utility.Bool2byte(Khoanoitru_tonghop), (byte)(Utility.Byte2Bool(KcbLuotkham.Columns.TthaiThopNoitru) ? 1 : 0)).Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { return(ActionResult.Error); } }
public static ActionResult CapnhatPhieuhen(List <KcbPhieuhenTiemchungChitiet> lstItems, List <long> lstDel, ref string ErrMsg) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { if (lstDel.Count > 0) { new Delete().From(KcbPhieuhenTiemchungChitiet.Schema).Where(KcbPhieuhenTiemchungChitiet.Columns.IdChitiet).In(lstDel).Execute(); } foreach (KcbPhieuhenTiemchungChitiet item in lstItems) { item.Save(); } } scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { ErrMsg = ex.Message; return(ActionResult.Error); } }
/// <summary> /// hàm thực hiệnv iệc update thông tin của biên lại hóa đơn /// </summary> /// <param name="objhoalog"></param> /// <param name="objPayment"></param> /// <param name="HOADON_CAPPHAT_ID"></param> /// <returns></returns> public ActionResult UpdateBienLaiHoaDon(HoadonLog objhoalog, KcbThanhtoan objPayment, int HOADON_CAPPHAT_ID) { try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { objhoalog.IdThanhtoan = Utility.Int32Dbnull(objPayment.IdThanhtoan); objhoalog.IdBenhnhan = Utility.Int32Dbnull(objPayment.IdBenhnhan); objhoalog.MaLuotkham = Utility.sDbnull(objPayment.MaLuotkham); objhoalog.MaNhanvien = globalVariables.UserName; objhoalog.NgayIn = globalVariables.SysDate; objhoalog.TrangThai = 0; objhoalog.IsNew = true; objhoalog.Save(); new Update(HoadonCapphat.Schema) .Set(HoadonCapphat.Columns.SerieHientai).EqualTo(objhoalog.Serie) .Set(HoadonCapphat.Columns.TrangThai).EqualTo(1) .Where(HoadonCapphat.Columns.IdCapphat).IsEqualTo(HOADON_CAPPHAT_ID). Execute(); } Scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { return(ActionResult.Error); } }
void cmdHuy_Click(object sender, EventArgs e) { if (objLuotkham == null) { Utility.SetMsg(lblMsg, "Bạn cần chọn bệnh nhân trước khi thực hiện hủy chuyển viện", true); return; } if (Utility.AcceptQuestion(string.Format("Bạn có chắc chắn muốn hủy chuyển viện cho bệnh nhân {0} hay không?", txtTenBN.Text), "Xác nhận hủy chuyển viện", true)) { try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { objLuotkham.TthaiChuyendi = 0; objLuotkham.IdBenhvienDi = -1; objLuotkham.IdBacsiChuyenvien = -1; objLuotkham.NgayRavien = null; objLuotkham.IsNew = false; objLuotkham.MarkOld(); objLuotkham.Save(); new Delete().From(KcbPhieuchuyenvien.Schema).Where(KcbPhieuchuyenvien.Columns.IdPhieu).IsEqualTo(Utility.Int32Dbnull(txtId.Text, -1)).Execute(); } scope.Complete(); Utility.SetMsg(lblMsg, string.Format("Hủy chuyển viện cho bệnh nhân {0} thành công", txtTenBN.Text), true); } } catch (Exception ex) { Utility.CatchException(ex); } } }
public ActionResult UpdateSysConfigRadio(SysConfigRadio objConfigRadio) { try { using (var scope = new TransactionScope()) { using (var sp = new SharedDbConnectionScope()) { SqlQuery q = new SqlQuery().From(SysConfigRadio.Schema).Where(SysConfigRadio.Columns.SysId).IsEqualTo(1); if (q.GetRecordCount() <= 0) { objConfigRadio.IsNew = true; objConfigRadio.Save(); } else { new Update(SysConfigRadio.Schema) .Set(SysConfigRadio.PassWordColumn).EqualTo(objConfigRadio.PassWord) .Set(SysConfigRadio.UserNameColumn).EqualTo(objConfigRadio.UserName) .Set(SysConfigRadio.DomainColumn).EqualTo(objConfigRadio.Domain) .Set(SysConfigRadio.PathUNCColumn).EqualTo(objConfigRadio.PathUNC) .Where(SysConfigRadio.SysIdColumn).IsEqualTo(1).Execute(); } } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { return(ActionResult.Error); } }
public ActionResult UpdateDynamicValues(List <DynamicValue> lstValues) { try { using (var scope = new TransactionScope()) { using (var sp = new SharedDbConnectionScope()) { foreach (DynamicValue _object in lstValues) { if (_object.Id > 0) { _object.MarkOld(); _object.IsNew = false; _object.Save(); } else//Insert { _object.IsNew = true; _object.Save(); } } } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { Utility.ShowMsg(exception.Message); return(ActionResult.Error); } }
public ActionResult CHOT_CAPPHAT(List<int> lstIDDonthuoc, DateTime Ngay_Chot) { int v_intResult; ActionResult actResult; try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { TLichsuChotthuoc _newItem = new TLichsuChotthuoc(); _newItem.NgayChot = Ngay_Chot; _newItem.NguoiChot = globalVariables.UserName; _newItem.IsNew = true; _newItem.Save(); object obj = TLichsuChotthuoc.CreateQuery().GetMax("ID_CHOT"); TPhieuXuatthuocBenhnhanCollection vCollection = new TPhieuXuatthuocBenhnhanCollection(); v_intResult = new Update(TPhieuXuatthuocBenhnhan.Schema.TableName).Set(TPhieuXuatthuocBenhnhan.NgayChotColumn).EqualTo(Ngay_Chot) .Set(TPhieuXuatthuocBenhnhan.IdChotColumn).EqualTo(Utility.Int32Dbnull(obj, -1)) .Where(TPhieuXuatthuocBenhnhan.NgayChotColumn).IsNull() .And(TPhieuXuatthuocBenhnhan.IdDonthuocColumn).In(lstIDDonthuoc) .Execute(); } scope.Complete(); return ActionResult.Success; } } catch (Exception ex) { Utility.ShowMsg("Lỗi:\n" + ex.ToString()); return ActionResult.Error; } }
/// <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); } }
public ActionResult ChuyenVTTHvaogoi(long IdDonthuoc_source, long IdDonthuoc_des, List <long> lstchitiet, int id_goi) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { new Update(KcbDonthuocChitiet.Schema) .Set(KcbDonthuocChitiet.Columns.IdGoi).EqualTo(id_goi) .Set(KcbDonthuocChitiet.Columns.IdDonthuoc).EqualTo(IdDonthuoc_des) .Set(KcbDonthuocChitiet.Columns.IdDonthuocChuyengoi).EqualTo(IdDonthuoc_source) .Set(KcbDonthuocChitiet.Columns.TrongGoi).EqualTo(1) .Where(KcbDonthuocChitiet.Columns.IdChitietdonthuoc).In(lstchitiet).Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { log.Error("loi trong qua trinh xoa phieu dieu tri {0}", exception.ToString()); return(ActionResult.Error); } }
/// <summary> /// hàm thực hiện việc xác nhận thông tin /// </summary> /// <param name="objPhieuNhap"></param> /// <returns></returns> public ActionResult HuyXacNhanPhieuTraLaiKho(TPhieuNhapxuatthuoc objPhieuNhap) { HisDuocProperties objHisDuocProperties = PropertyLib._HisDuocProperties; string errorMessage = ""; try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { SqlQuery sqlQuery = new Select().From(TPhieuNhapxuatthuocChitiet.Schema) .Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu); TPhieuNhapxuatthuocChitietCollection objPhieuNhapCtCollection = sqlQuery.ExecuteAsCollection <TPhieuNhapxuatthuocChitietCollection>(); foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in objPhieuNhapCtCollection) { //Kiểm tra ở kho nhập xem thuốc đã sử dụng chưa ActionResult _Kiemtrathuochuyxacnhan = Kiemtrathuochuyxacnhan(objPhieuNhap, objPhieuNhapCt); if (_Kiemtrathuochuyxacnhan != ActionResult.Success) { return(_Kiemtrathuochuyxacnhan); } int id_thuockho = -1; StoredProcedure sp = SPs.ThuocNhapkhoOutput(objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan, objPhieuNhapCt.SoLuong, Utility.DecimaltoDbnull(objPhieuNhapCt.Vat), objPhieuNhapCt.IdThuoc, objPhieuNhap.IdKhonhap, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo, objPhieuNhapCt.SoDky, objPhieuNhapCt.SoQdinhthau, -1, id_thuockho, objPhieuNhap.NgayXacnhan, objPhieuNhapCt.GiaBhyt, objPhieuNhapCt.GiaPhuthuDungtuyen, objPhieuNhapCt.GiaPhuthuTraituyen, objPhieuNhapCt.KieuThuocvattu); sp.Execute(); sp = SPs.ThuocXuatkho(objPhieuNhap.IdKhoxuat, objPhieuNhapCt.IdThuoc, objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan, Utility.DecimaltoDbnull(objPhieuNhapCt.Vat), Utility.Int32Dbnull(objPhieuNhapCt.SoLuong), objPhieuNhapCt.IdThuockho, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo, objHisDuocProperties.XoaDulieuKhiThuocDaHet ? 1 : 0, errorMessage); sp.Execute(); errorMessage = Utility.sDbnull(sp.OutputValues[0]); } //Xóa toàn bộ chi tiết trong TBiendongThuoc new Delete().From(TBiendongThuoc.Schema) .Where(TBiendongThuoc.IdPhieuColumn).IsEqualTo(objPhieuNhap.IdPhieu).Execute(); new Update(TPhieuNhapxuatthuoc.Schema) .Set(TPhieuNhapxuatthuoc.Columns.IdNhanvien).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.NguoiXacnhan).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.NgayXacnhan).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.TrangThai).EqualTo(0) .Where(TPhieuNhapxuatthuoc.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu).Execute(); } Scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { log.Error("Loi ban ra tu sp :{0}", errorMessage); log.Error("Loi trong qua trinh xac nhan don thuoc :{0}", exception); return(ActionResult.Error); } }
public ActionResult ChuyentoanboVTTHvaogoi(long IdDonthuoc,int id_goi) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { new Update(KcbDonthuoc.Schema) .Set(KcbDonthuoc.Columns.IdGoi).EqualTo(id_goi) .Set(KcbDonthuoc.Columns.TrongGoi).EqualTo(1) .Where(KcbDonthuoc.Columns.IdDonthuoc).IsEqualTo(IdDonthuoc).Execute(); new Update(KcbDonthuocChitiet.Schema) .Set(KcbDonthuocChitiet.Columns.IdGoi).EqualTo(id_goi) .Set(KcbDonthuocChitiet.Columns.TrongGoi).EqualTo(1) .Where(KcbDonthuocChitiet.Columns.IdDonthuoc).IsEqualTo(IdDonthuoc).Execute(); } scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { log.Error("loi trong qua trinh xoa phieu dieu tri {0}", exception.ToString()); return ActionResult.Error; } }
public static ActionResult Capnhatgia(long id, decimal don_gia, byte cachtinh_gia) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { new Update(NoitruPhanbuonggiuong.Schema) .Set(NoitruPhanbuonggiuong.Columns.DonGia).EqualTo(don_gia) .Set(NoitruPhanbuonggiuong.Columns.CachtinhGia).EqualTo(cachtinh_gia) .Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(id).Execute(); } scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { Utility.CatchException(exception); return ActionResult.Error; } }
public ActionResult ChuyentoanboVTTHrakhoigoi(long IdDonthuoc) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { new Update(KcbDonthuoc.Schema) .Set(KcbDonthuoc.Columns.IdGoi).EqualTo(-1) .Set(KcbDonthuoc.Columns.TrongGoi).EqualTo(0) .Where(KcbDonthuoc.Columns.IdDonthuoc).IsEqualTo(IdDonthuoc).Execute(); new Update(KcbDonthuocChitiet.Schema) .Set(KcbDonthuocChitiet.Columns.IdGoi).EqualTo(-1) .Set(KcbDonthuocChitiet.Columns.IdDonthuocChuyengoi).EqualTo(-1) .Set(KcbDonthuocChitiet.Columns.TrongGoi).EqualTo(0) .Where(KcbDonthuocChitiet.Columns.IdDonthuoc).IsEqualTo(IdDonthuoc).Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { log.Error("loi trong qua trinh xoa phieu dieu tri {0}", exception.ToString()); return(ActionResult.Error); } }
public ActionResult HUYCHOT_CAPPHAT(DateTime Ngay_Chot) { int v_intResult; ActionResult actResult; try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { TPhieuXuatthuocBenhnhanCollection vCollection = new TPhieuXuatthuocBenhnhanController().FetchByQuery( TPhieuXuatthuocBenhnhan.CreateQuery() .WHERE(TPhieuXuatthuocBenhnhan.NgayChotColumn.ColumnName, Comparison.Equals, Ngay_Chot)); //Lấy danh sách các lần chốt List <int> lstIDChot = (from p in vCollection.AsEnumerable() select p.IdChot.Value).Distinct().ToList <int>(); //Update thông tin chốt về giá trị mặc định v_intResult = new Update(TPhieuXuatthuocBenhnhan.Schema.TableName).Set(TPhieuXuatthuocBenhnhan.NgayChotColumn).EqualTo(null) .Set(TPhieuXuatthuocBenhnhan.IdChotColumn).EqualTo(0) .Where(TPhieuXuatthuocBenhnhan.NgayChotColumn).IsEqualTo(Ngay_Chot) .Execute(); //Xóa lịch sử chốt new Delete().From(TLichsuChotthuoc.Schema).Where(TLichsuChotthuoc.IdChotColumn).In(lstIDChot).Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { Utility.ShowMsg("Lỗi:\n" + ex.ToString()); return(ActionResult.Error); } }
public ActionResult ChuyenVTTHvaogoi(long IdDonthuoc, List <long> lstchitiet, int id_goi) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { //Tạo phiếu mới KcbDonthuoc objnew = KcbDonthuoc.FetchByID(IdDonthuoc); objnew.IsNew = true; objnew.IdGoi = id_goi; objnew.Noitru = 1; objnew.TrongGoi = 1; objnew.Save(); new Update(KcbDonthuocChitiet.Schema) .Set(KcbDonthuocChitiet.Columns.IdGoi).EqualTo(id_goi) .Set(KcbDonthuocChitiet.Columns.IdDonthuoc).EqualTo(objnew.IdDonthuoc) .Set(KcbDonthuocChitiet.Columns.IdDonthuocChuyengoi).EqualTo(IdDonthuoc) .Set(KcbDonthuocChitiet.Columns.TrongGoi).EqualTo(1) .Where(KcbDonthuocChitiet.Columns.IdChitietdonthuoc).In(lstchitiet).Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { log.Error("loi trong qua trinh xoa phieu dieu tri {0}", exception.ToString()); return(ActionResult.Error); } }
public static ActionResult ChuyenPhong(long IdKham, string LydoChuyen, DmucDichvukcb objDichvuKcb) { try { ActionResult _ActionResult = ActionResult.Success; using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { new Update(KcbDangkyKcb.Schema) .Set(KcbDangkyKcb.Columns.IdPhongkham).EqualTo(objDichvuKcb.IdPhongkham) .Set(KcbDangkyKcb.Columns.IdDichvuKcb).EqualTo(objDichvuKcb.IdDichvukcb) .Set(KcbDangkyKcb.Columns.IdKieukham).EqualTo(objDichvuKcb.IdKieukham) .Set(KcbDangkyKcb.Columns.TenDichvuKcb).EqualTo(objDichvuKcb.TenDichvukcb) .Set(KcbDangkyKcb.Columns.NgayDangky).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.NguoiChuyen).EqualTo(globalVariables.UserName) .Set(KcbDangkyKcb.Columns.NgayChuyen).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.LydoChuyen).EqualTo(LydoChuyen) .Set(KcbDangkyKcb.Columns.TrangthaiChuyen).EqualTo(1) .Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(IdKham) .Execute(); } Scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n" + ex.Message); return(ActionResult.Exception); } }
public ActionResult ThemPhieutrathuocthua(TPhieutrathuocthua _phieutra, List <long> lstIdCt) { try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { _phieutra.IsNew = true; _phieutra.Save(); if (_phieutra.Id > 0) { new Update(TPhieuCapphatChitiet.Schema) .Set(TPhieuCapphatChitiet.Columns.IdPhieutralai).EqualTo(_phieutra.Id) .Set(TPhieuCapphatChitiet.Columns.TrangthaiTralai).EqualTo(1) .Where(TPhieuCapphatChitiet.Columns.IdChitiet).In(lstIdCt) .Execute(); } } Scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { Utility.CatchException("Lỗi khi thêm phiếu trả thuốc thừa", ex); return(ActionResult.Error); } }
public ActionResult LINH_THUOC(int Idcapphat, List <int> lstIDDonthuoc, DateTime Ngay_linh) { int v_intResult; ActionResult actResult; try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { v_intResult = new Update(TPhieuCapphatChitiet.Schema.TableName) .Set(TPhieuCapphatChitiet.DaLinhColumn).EqualTo(1) .Set(TPhieuCapphatChitiet.Columns.NguoiSua).EqualTo(globalVariables.UserName) .Set(TPhieuCapphatChitiet.Columns.NgaySua).EqualTo(globalVariables.SysDate) .Where(TPhieuCapphatChitiet.Columns.IdCapphat).IsEqualTo(Idcapphat) .And(TPhieuCapphatChitiet.IdDonthuocColumn).In(lstIDDonthuoc) .And(TPhieuCapphatChitiet.DaLinhColumn).IsEqualTo(0) .Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { Utility.ShowMsg("Lỗi:\n" + ex.ToString()); return(ActionResult.Error); } }
public static ActionResult UpdateResult(List <KcbKetquaCl> lstResult, List <KcbChidinhclsChitiet> lstDetails) { try { using (var scope = new TransactionScope()) { using (var sp = new SharedDbConnectionScope()) { foreach (KcbKetquaCl _result in lstResult) { _result.Save(); } foreach (KcbChidinhclsChitiet _detail in lstDetails) { _detail.Save(); } } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { Utility.ShowMsg(exception.Message); return(ActionResult.Error); } }
public ActionResult DanhdautrangthaiTiem(KcbDonthuocChitiet objChitiet, long _IdKham, bool Da_tiem) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { if (objChitiet != null) { objChitiet.IsNew = false; objChitiet.DaDung = Utility.Bool2byte(Da_tiem); objChitiet.MarkOld(); objChitiet.Save(); } else { new Update(KcbDonthuocChitiet.Schema) .Set(KcbDonthuocChitiet.Columns.DaDung).EqualTo(Utility.Bool2byte(Da_tiem)) .Where(KcbDonthuocChitiet.Columns.IdKham).IsEqualTo(_IdKham) .Execute(); } } scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { log.Error("Loi trong qua trinh chuyen vien khoi noi tru {0}", exception); return ActionResult.Error; } }
protected override void On_ActionDelete(object sender, EventArgs e) { TransactionScope ts = new TransactionScope( ); SharedDbConnectionScope ss = new SharedDbConnectionScope( ); try { int cashID = Utilities.ToInt(EVENTARGUMENT); string message; if (OrderBLL.DeleteMemberCash(cashID, AppContext.Context.Company, out message)) { OrderBLL.UpdateBalance( ); ts.Complete( ); } txtMessage.InnerHtml = message; } catch (Exception ex) { Logging.Log("FinanceList->On_ActionDelete", ex, true); txtMessage.InnerHtml = ex.Message; } finally { ss.Dispose( ); ts.Dispose( ); } On_ActionQuery(sender, e); }
public ActionResult LockExamInfo(KcbLuotkham objPatientExam) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.Locked).EqualTo(objPatientExam.Locked) .Set(KcbLuotkham.Columns.NguoiKetthuc).EqualTo(objPatientExam.NguoiKetthuc) .Set(KcbLuotkham.Columns.NgayKetthuc).EqualTo(objPatientExam.NgayKetthuc) .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham) .And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan).Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { log.Error("Loi trong qua trinh chuyen vien khoi noi tru {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); } }
public ActionResult XoaPhieuTrathuocthua(int idphieu) { try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { new Delete().From(TPhieutrathuocthua.Schema).Where(TPhieutrathuocthua.Columns.Id).IsEqualTo(idphieu).Execute(); new Update(TPhieuCapphatChitiet.Schema) .Set(TPhieuCapphatChitiet.Columns.IdPhieutralai).EqualTo(-1) .Set(TPhieuCapphatChitiet.Columns.TrangthaiTralai).EqualTo(0) .Where(TPhieuCapphatChitiet.Columns.IdPhieutralai).IsEqualTo(idphieu) .Execute(); Scope.Complete(); } return(ActionResult.Success); } } catch (Exception ex) { Utility.CatchException("Lỗi khi xóa phiếu trả thuốc thừa", ex); return(ActionResult.Error); } }
public ActionResult Capnhattrangthaithanhtoan(long IdThanhtoan) { try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { new Update(KcbThanhtoan.Schema) .Set(KcbThanhtoan.Columns.NguoiIn).EqualTo(globalVariables.UserName) .Set(KcbThanhtoan.Columns.NgayIn).EqualTo(globalVariables.SysDate) .Set(KcbThanhtoan.Columns.TrangthaiIn).EqualTo(1) .Where(KcbThanhtoan.Columns.IdThanhtoan).IsEqualTo(IdThanhtoan).Execute(); } scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { log.InfoException("Ban ra loi exception=", exception); return ActionResult.Error; } }
public static bool NoptienTamung(NoitruTamung objTamung) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { objTamung.Save(); KcbLuotkham objKcbLuotkham = Utility.getKcbLuotkham(objTamung.IdBenhnhan, objTamung.MaLuotkham); if (objKcbLuotkham != null) { objKcbLuotkham.IsNew = false; objKcbLuotkham.MarkOld(); if (Utility.ByteDbnull(objKcbLuotkham.TrangthaiNoitru, 0) == 1) { objKcbLuotkham.TrangthaiNoitru = 2; objKcbLuotkham.Save(); } } } scope.Complete(); } return true; } catch (Exception ex) { return false; } }
public static ActionResult CapnhatSoluong(long id, int soluongngay,byte cachtinhsoluong) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { new Update(NoitruPhanbuonggiuong.Schema) .Set(NoitruPhanbuonggiuong.Columns.SoLuong).EqualTo(soluongngay) .Set(NoitruPhanbuonggiuong.Columns.CachtinhSoluong).EqualTo(cachtinhsoluong) .Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(id).Execute(); } scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { Utility.CatchException(exception); return ActionResult.Error; } }
public ActionResult BoHoadondo( long IdHdonLog) { try { using (var scope = new TransactionScope()) { using (var db = new SharedDbConnectionScope()) { new Delete().From(HoadonLog.Schema) .Where(HoadonLog.Columns.IdHdonLog).IsEqualTo(IdHdonLog).Execute(); new Update(KcbThanhtoan.Schema) .Set(KcbThanhtoan.Columns.Serie).EqualTo("") .Set(KcbThanhtoan.Columns.MauHoadon).EqualTo("") .Set(KcbThanhtoan.Columns.MaQuyen).EqualTo("") .Set(KcbThanhtoan.Columns.KiHieu).EqualTo("") .Set(KcbThanhtoan.Columns.IdHdonLog).EqualTo(-1) .Set(KcbThanhtoan.Columns.IdCapphat).EqualTo(-1) .Set(KcbThanhtoan.Columns.TrangthaiSeri).EqualTo(0) .Where(KcbThanhtoan.Columns.IdHdonLog).IsEqualTo(IdHdonLog).Execute(); } scope.Complete(); return ActionResult.Success; } } catch { return ActionResult.Exception; } }
public ActionResult UpdateDynamicValues(List<DynamicValue> lstValues) { try { using (var scope = new TransactionScope()) { using (var sp = new SharedDbConnectionScope()) { foreach (DynamicValue _object in lstValues) { if (_object.Id > 0) { _object.MarkOld(); _object.IsNew = false; _object.Save(); } else//Insert { _object.IsNew = true; _object.Save(); } } } scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { Utility.ShowMsg(exception.Message); return ActionResult.Error; } }
public static string Insert(DmucThuoc objThuoc, QheCamchidinhChungphieuCollection lstQhe) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { objThuoc.Save(); if (!objThuoc.IsNew) { } new Delete().From(QheCamchidinhChungphieu.Schema) .Where(QheCamchidinhChungphieu.Columns.IdDichvu).IsEqualTo(objThuoc.IdThuoc) .And(QheCamchidinhChungphieu.Columns.Loai).IsEqualTo(0) .Execute(); new Delete().From(QheCamchidinhChungphieu.Schema) .Where(QheCamchidinhChungphieu.Columns.IdDichvuCamchidinhchung).IsEqualTo(objThuoc.IdThuoc) .And(QheCamchidinhChungphieu.Columns.Loai).IsEqualTo(0) .Execute(); foreach (QheCamchidinhChungphieu obj in lstQhe) { obj.IdDichvu = objThuoc.IdThuoc; } lstQhe.SaveAll(); } scope.Complete(); } return(string.Empty); } catch (Exception ex) { return(ex.Message); } }
protected override void On_ActionEdit(object sender, EventArgs e) { if (!CompanyBLL.CheckIsOwnerUser(UserID, CurrentUser.CompanyId.Value)) { txtMessage.InnerHtml = "你无权编辑非本店会员"; goto lbl_end; } if (UserID == CurrentUser.Id) { txtMessage.InnerHtml = "此账号为系统内置账号,不能修改."; goto lbl_end; } using (TransactionScope ts = new TransactionScope( )) { using (SharedDbConnectionScope ss = new SharedDbConnectionScope( )) { if (formView.Save<SysMember>(UserID) == 0) { if(isChangePhoneNum) { UcFormView.FormViewRow phone = formView.GetViewRow(SysMember.MemberPhoneNumberColumn); CompanyBLL.UpdateUserPhone(phone.ParamValue, phone.DbValue); } ts.Complete( ); txtMessage.InnerHtml = "保存成功!"; } else txtMessage.InnerHtml = "保存失败"; } } lbl_end: On_ActionQuery(sender, e); }
/// <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 UpdatePhieuNhapKho(TPhieuNhapxuatthuoc objPhieuNhap, List <TPhieuNhapxuatthuocChitiet> arrPhieuNhapCts) { try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { objPhieuNhap.NgaySua = globalVariables.SysDate; objPhieuNhap.NguoiSua = globalVariables.UserName; objPhieuNhap.TongTien = arrPhieuNhapCts.Sum(c => c.ThanhTien); objPhieuNhap.Save(); new Delete().From(TPhieuNhapxuatthuocChitiet.Schema) .Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu).Execute(); foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in arrPhieuNhapCts) { objPhieuNhapCt.IdPhieu = Utility.Int32Dbnull(objPhieuNhap.IdPhieu, -1); objPhieuNhapCt.IsNew = true; objPhieuNhapCt.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 xác nhận thông tin /// </summary> /// <param name="objPhieuNhap"></param> /// <returns></returns> public ActionResult HuyXacNhanPhieuTraLaiKho(TPhieuNhapxuatthuoc objPhieuNhap) { HisDuocProperties objHisDuocProperties = PropertyLib._HisDuocProperties; string errorMessage = ""; try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { SqlQuery sqlQuery = new Select().From(TPhieuNhapxuatthuocChitiet.Schema) .Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu); TPhieuNhapxuatthuocChitietCollection objPhieuNhapCtCollection = sqlQuery.ExecuteAsCollection<TPhieuNhapxuatthuocChitietCollection>(); foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in objPhieuNhapCtCollection) { //Kiểm tra ở kho nhập xem thuốc đã sử dụng chưa ActionResult _Kiemtrathuochuyxacnhan = Kiemtrathuochuyxacnhan(objPhieuNhap, objPhieuNhapCt); if (_Kiemtrathuochuyxacnhan != ActionResult.Success) return _Kiemtrathuochuyxacnhan; int id_thuockho = -1; StoredProcedure sp = SPs.ThuocNhapkhoOutput(objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan, objPhieuNhapCt.SoLuong, Utility.DecimaltoDbnull(objPhieuNhapCt.Vat), objPhieuNhapCt.IdThuoc, objPhieuNhap.IdKhonhap, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo, objPhieuNhapCt.SoDky, objPhieuNhapCt.SoQdinhthau, -1, id_thuockho, objPhieuNhap.NgayXacnhan, objPhieuNhapCt.GiaBhyt, objPhieuNhapCt.GiaPhuthuDungtuyen, objPhieuNhapCt.GiaPhuthuTraituyen, objPhieuNhapCt.KieuThuocvattu); sp.Execute(); sp = SPs.ThuocXuatkho(objPhieuNhap.IdKhoxuat, objPhieuNhapCt.IdThuoc, objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap,objPhieuNhapCt.GiaBan, Utility.DecimaltoDbnull(objPhieuNhapCt.Vat), Utility.Int32Dbnull(objPhieuNhapCt.SoLuong), objPhieuNhapCt.IdThuockho, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo, objHisDuocProperties.XoaDulieuKhiThuocDaHet ? 1 : 0, errorMessage); sp.Execute(); errorMessage = Utility.sDbnull(sp.OutputValues[0]); } //Xóa toàn bộ chi tiết trong TBiendongThuoc new Delete().From(TBiendongThuoc.Schema) .Where(TBiendongThuoc.IdPhieuColumn).IsEqualTo(objPhieuNhap.IdPhieu).Execute(); new Update(TPhieuNhapxuatthuoc.Schema) .Set(TPhieuNhapxuatthuoc.Columns.IdNhanvien).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.NguoiXacnhan).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.NgayXacnhan).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.TrangThai).EqualTo(0) .Where(TPhieuNhapxuatthuoc.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu).Execute(); } Scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { log.Error("Loi ban ra tu sp :{0}", errorMessage); log.Error("Loi trong qua trinh xac nhan don thuoc :{0}", exception); return ActionResult.Error; } }
public ActionResult Add(string format) { PointDataSummary newSummary = null; using (TransactionScope ts = new TransactionScope()) using (SharedDbConnectionScope sharedConnectionScope = new SharedDbConnectionScope()) { try { newSummary = new PointDataSummary(); // Get POST data TryUpdateModel<PointDataSummary>(newSummary, new[] { "Description", "LayerId", "Latitude", "Longitude", "Guid", "Name", "Tag" }); if (newSummary.Latitude == 0) { string lat = HttpContext.Request["Latitude"]; newSummary.Latitude = decimal.Parse(lat, CultureInfo.InvariantCulture); } if (newSummary.Longitude == 0) { string longi = HttpContext.Request["Longitude"]; newSummary.Longitude = decimal.Parse(longi, CultureInfo.InvariantCulture); } PointDataSummary testSummary = GetSummary(newSummary.Guid, newSummary.LayerId); if (testSummary != null) { throw new Exception("PointDataSummary already exists in database guid, layerId"); } newSummary.Description = newSummary.Description ?? string.Empty; newSummary.Tag = newSummary.Tag ?? string.Empty; newSummary.CreatedOn = DateTime.UtcNow; newSummary.ModifiedOn = newSummary.CreatedOn; newSummary.CreatedById = CurrentUserId; newSummary.Save(); if (RoleEnvironment.IsAvailable) SearchEngine.Instance.Index(newSummary.Id); ts.Complete(); // Set 201 status code, and Location header HttpContext.Response.StatusCode = 201; string location = this.BuildUrlFromExpression<SummariesController>(c => c.ShowById(newSummary.Id, format)); HttpContext.Response.AddHeader("Location", location); } catch (Exception ex) { HttpContext.Response.StatusCode = 400; return Json( CreateErrorObject(ex) ); } } return Json(newSummary); }
private void cmdSave_Click(object sender, EventArgs e) { try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { var exists = Exists(); if (exists) { int record = new Update(BangGium.Schema).Set(BangGium.Columns.Price).EqualTo(nmrPrice.Value) .Where(BangGium.Columns.TestTypeId).IsEqualTo(_TestTypeId).And( BangGium.Columns.TestDataId) .IsEqualTo(-1).Execute(); if (record <= 0) { BangGium bangGium = new BangGium(); bangGium.TestTypeId = _TestTypeId; bangGium.TestDataId = "-1"; bangGium.Price = Utility.DecimaltoDbnull(nmrPrice.Value, 0); bangGium.IsNew = true; bangGium.Save(); } } else { decimal price = Utility.DecimaltoDbnull(grdDataControl.CurrentRow.Cells["Price"].Value, 0); nmrPrice.Value = price; int record = new Update(BangGium.Schema).Set(BangGium.Columns.Price).EqualTo(nmrPrice.Value) .Where(BangGium.Columns.TestTypeId).IsEqualTo(_TestTypeId) .And(BangGium.Columns.TestDataId).IsEqualTo(_TestDataId).Execute(); if (record <= 0) { BangGium bangGium = new BangGium(); bangGium.TestTypeId = _TestTypeId; bangGium.TestDataId = _TestDataId; bangGium.Price = Utility.DecimaltoDbnull(nmrPrice.Value, 0); bangGium.IsNew = true; bangGium.Save(); } } } Scope.Complete(); //Utility.ShowMsg("Lưu thông tin thành công."); } } catch (Exception) { Utility.ShowMsg("Có lỗi trong quá trình lưu thông tin"); throw; } }
public void Connection_Should_Not_Be_Reused_When_Within_SharedConnectionScope_When_Provider_Is_Different() { var p1 = ProviderFactory.GetProvider(TestConfiguration.MsSql2008TestConnectionString, DbClientTypeName.MsSql); using (var scope = new SharedDbConnectionScope(p1)) { var p2 = ProviderFactory.GetProvider(TestConfiguration.SQLiteTestsConnectionString, DbClientTypeName.SqlLite); Assert.NotSame(p1.CurrentSharedConnection, p2.CurrentSharedConnection); Assert.Same(scope.CurrentConnection, p1.CurrentSharedConnection); } }
/// <summary> /// hàm thực hiện việc xác nhận thông tin /// </summary> /// <param name="objPhieuNhap"></param> /// <returns></returns> public ActionResult HuyXacNhanPhieuNhapKho(TPhieuNhapxuatthuoc objPhieuNhap, ref string errMsg) { try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { SqlQuery sqlQuery = new Select().From(TPhieuNhapxuatthuocChitiet.Schema) .Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu); TPhieuNhapxuatthuocChitietCollection objPhieuNhapCtCollection = sqlQuery.ExecuteAsCollection<TPhieuNhapxuatthuocChitietCollection>(); foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in objPhieuNhapCtCollection) { ActionResult _Kiemtrathuochuyxacnhan = Kiemtrathuochuyxacnhan(objPhieuNhap, objPhieuNhapCt); if (_Kiemtrathuochuyxacnhan != ActionResult.Success) return _Kiemtrathuochuyxacnhan; //Xóa toàn bộ chi tiết trong TBiendongThuoc new Delete().From(TBiendongThuoc.Schema) .Where(TBiendongThuoc.IdPhieuColumn).IsEqualTo(objPhieuNhap.IdPhieu) .And(TBiendongThuoc.IdPhieuChitietColumn).IsEqualTo(objPhieuNhapCt.IdPhieuchitiet) .And(TBiendongThuoc.MaLoaiphieuColumn).IsEqualTo(objPhieuNhap.LoaiPhieu).Execute(); new Update(TPhieuNhapxuatthuocChitiet.Schema).Set(TPhieuNhapxuatthuocChitiet.Columns.IdThuockho).EqualTo(-1) .Set(TPhieuNhapxuatthuocChitiet.Columns.NgayNhap).EqualTo(null) .Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieuchitiet).IsEqualTo(objPhieuNhapCt.IdPhieuchitiet).Execute(); StoredProcedure sp = SPs.ThuocXuatkho(objPhieuNhap.IdKhonhap,objPhieuNhapCt.IdThuoc, objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan, Utility.DecimaltoDbnull(objPhieuNhap.Vat), objPhieuNhapCt.SoLuong,objPhieuNhapCt.IdThuockho,objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo, 0, errMsg); sp.Execute(); } new Update(TPhieuNhapxuatthuoc.Schema) .Set(TPhieuNhapxuatthuoc.Columns.IdNhanvien).EqualTo(-1) .Set(TPhieuNhapxuatthuoc.Columns.NguoiXacnhan).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.NgayXacnhan).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.TrangThai).EqualTo(0) .Where(TPhieuNhapxuatthuoc.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu).Execute(); } Scope.Complete(); return ActionResult.Success; } } catch (Exception ex) { Utility.CatchException("Lỗi khi hủy xác nhận nhập kho", ex); return ActionResult.Error; } }
public static ActionResult BenhNhanLinhThuoc(int idPhieucapphat,List<int> lstIdDonthuoc, int Trang_thai,ref List<int> lstNoValidData) { ActionResult _result = ActionResult.Success; try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { foreach (int IdDonthuoc in lstIdDonthuoc) { if (Trathuocthua.ThuocNoitruKiemtraThuoctralai(idPhieucapphat, IdDonthuoc)) { lstNoValidData.Add(IdDonthuoc); continue; } DataTable dtData = SPs.ThuocNoitruLaychitietdonthuocTheophieulinhthuocnoitru(idPhieucapphat, IdDonthuoc).GetDataSet().Tables[0]; foreach (DataRow dr in dtData.Rows) { int ID_CAPPHAT = Utility.Int32Dbnull(dr[TPhieuCapphatChitiet.Columns.IdCapphat], -1); int ID_DONTHUOC = Utility.Int32Dbnull(dr[TPhieuCapphatChitiet.Columns.IdDonthuoc], -1); int IdChitietdonthuoc = Utility.Int32Dbnull(dr[TPhieuCapphatChitiet.Columns.IdChitietdonthuoc], -1); int soluongtralai = Utility.Int32Dbnull(dr[TPhieuCapphatChitiet.Columns.SoLuongtralai], 0); int SoLuong = Utility.Int32Dbnull(dr[TPhieuCapphatChitiet.Columns.SoLuong], 0); int thuclinh = SoLuong - soluongtralai;// Utility.Int32Dbnull(dr[TPhieuCapphatChitiet.Columns.ThucLinh], -1); if(Trang_thai==0) { soluongtralai = 0; thuclinh = 0; } new Update(TPhieuCapphatChitiet.Schema) .Set(TPhieuCapphatChitiet.DaLinhColumn.ColumnName).EqualTo(Trang_thai) .Set(TPhieuCapphatChitiet.ThucLinhColumn.ColumnName).EqualTo(thuclinh) .Set(TPhieuCapphatChitiet.SoLuongtralaiColumn.ColumnName).EqualTo(soluongtralai) .Set(TPhieuCapphatChitiet.Columns.NguoiSua).EqualTo(globalVariables.UserName) .Set(TPhieuCapphatChitiet.Columns.NgaySua).EqualTo(globalVariables.SysDate) .Where(TPhieuCapphatChitiet.IdCapphatColumn).IsEqualTo(ID_CAPPHAT) .And(TPhieuCapphatChitiet.IdDonthuocColumn).IsEqualTo(ID_DONTHUOC) .And(TPhieuCapphatChitiet.Columns.IdChitietdonthuoc).IsEqualTo(IdChitietdonthuoc) .Execute(); } } } Scope.Complete(); return ActionResult.Success; } } catch (Exception) { return ActionResult.Error; } }
public ActionResult HuyXacNhanPhieuHuy_thanhly_Thuoc(TPhieuNhapxuatthuoc objPhieuNhap, ref string errMsg) { HisDuocProperties objHisDuocProperties = PropertyLib._HisDuocProperties; string errorMessage = ""; try { using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { SqlQuery sqlQuery = new Select().From(TPhieuNhapxuatthuocChitiet.Schema) .Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu); TPhieuNhapxuatthuocChitietCollection objPhieuNhapCtCollection = sqlQuery.ExecuteAsCollection<TPhieuNhapxuatthuocChitietCollection>(); foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in objPhieuNhapCtCollection) { long idthuockho = -1; //Nhập lại kho thanh lý StoredProcedure sp = SPs.ThuocNhapkhoOutput(objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan, objPhieuNhapCt.SoLuong, Utility.DecimaltoDbnull(objPhieuNhapCt.Vat), objPhieuNhapCt.IdThuoc, objPhieuNhap.IdKhoxuat, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo, objPhieuNhapCt.SoDky, objPhieuNhapCt.SoQdinhthau, idthuockho, idthuockho, objPhieuNhapCt.NgayNhap, objPhieuNhapCt.GiaBhyt, objPhieuNhapCt.GiaPhuthuDungtuyen, objPhieuNhapCt.GiaPhuthuTraituyen, objPhieuNhapCt.KieuThuocvattu); sp.Execute(); idthuockho = Utility.Int64Dbnull(sp.OutputValues[0], -1); if (idthuockho != objPhieuNhapCt.IdThuockho)//Nếu ai đó xóa bằng tay trong bảng thuốc kho thì cần update lại new Update(TPhieuNhapxuatthuocChitiet.Schema).Set(TPhieuNhapxuatthuocChitiet.Columns.IdThuockho).EqualTo(idthuockho) .Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieuchitiet).IsEqualTo(objPhieuNhapCt.IdPhieuchitiet).Execute(); } //Xóa toàn bộ chi tiết trong TBiendongThuoc new Delete().From(TBiendongThuoc.Schema) .Where(TBiendongThuoc.IdPhieuColumn).IsEqualTo(objPhieuNhap.IdPhieu) .And(TBiendongThuoc.MaLoaiphieuColumn).IsEqualTo(objPhieuNhap.LoaiPhieu).Execute(); new Update(TPhieuNhapxuatthuoc.Schema) .Set(TPhieuNhapxuatthuoc.Columns.NguoiSua).EqualTo(globalVariables.UserName) .Set(TPhieuNhapxuatthuoc.Columns.NgaySua).EqualTo(globalVariables.SysDate) .Set(TPhieuNhapxuatthuoc.Columns.NguoiXacnhan).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.NgayXacnhan).EqualTo(null) .Set(TPhieuNhapxuatthuoc.Columns.TrangThai).EqualTo(0) .Where(TPhieuNhapxuatthuoc.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu) .And(TPhieuNhapxuatthuoc.LoaiPhieuColumn).IsEqualTo(objPhieuNhap.LoaiPhieu).Execute(); } Scope.Complete(); return ActionResult.Success; } } catch (Exception ex) { Utility.CatchException("Lỗi khi hủy xác nhận phiếu ",ex); return ActionResult.Error; } }
public ActionResult AddNewPatientExam(KcbDanhsachBenhnhan objPatientInfo, KcbLuotkham objLuotkham, KcbDangkyKcb objRegExam, int KieuKham) { try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { UpdatePatientInfo(objPatientInfo); SqlQuery sqlQueryPatientExam = new Select().From(KcbLuotkham.Schema) .Where(KcbLuotkham.Columns.IdBenhnhan).IsNotEqualTo(objLuotkham.IdBenhnhan) .And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham); if (sqlQueryPatientExam.GetRecordCount() > 0)//Nếu BN khác đã lấy mã này { objLuotkham.MaLuotkham = THU_VIEN_CHUNG.KCB_SINH_MALANKHAM(); } objLuotkham.IsNew = true; objLuotkham.Save(); if (objLuotkham.TrangthaiNoitru >= 1) { SqlQuery sqlQuery = new Select().From(KcbLuotkham.Schema).Where( KcbLuotkham.Columns.MaLuotkham).IsNotEqualTo(objLuotkham.MaLuotkham) .And(KcbLuotkham.Columns.SoBenhAn).IsEqualTo(objLuotkham.SoBenhAn) .And(KcbLuotkham.Columns.TrangthaiNoitru).IsGreaterThanOrEqualTo(1); if (sqlQuery.GetRecordCount() > 0) { var query = new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.SoBenhAn).EqualTo(THU_VIEN_CHUNG.LaySoBenhAn()) .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham). Execute(); } } if (objRegExam != null) { objRegExam.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham); objRegExam.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan); AddRegExam(objRegExam,objLuotkham, false, KieuKham); } scope.Complete(); return ActionResult.Success; } } } catch (Exception ex) { return ActionResult.Error; } }
public static ActionResult Chuyendoituong(KcbLuotkham objLuotkham,decimal PtramBHYTcu) { try { ActionResult _ActionResult = ActionResult.Success; using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { //if (PtramBHYTcu != objLuotkham.PtramBhyt.Value ) _ActionResult= CapnhatGiatheodoituong(objLuotkham); if (_ActionResult == ActionResult.Cancel) { return _ActionResult; } new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.LuongCoban).EqualTo(objLuotkham.LuongCoban) .Set(KcbLuotkham.Columns.TthaiChuyendi).EqualTo(objLuotkham.TthaiChuyendi) .Set(KcbLuotkham.Columns.MatheBhyt).EqualTo(objLuotkham.MatheBhyt) .Set(KcbLuotkham.Columns.MaNoicapBhyt).EqualTo(objLuotkham.MaNoicapBhyt) .Set(KcbLuotkham.Columns.MaQuyenloi).EqualTo(objLuotkham.MaQuyenloi) .Set(KcbLuotkham.Columns.NgaybatdauBhyt).EqualTo(objLuotkham.NgaybatdauBhyt) .Set(KcbLuotkham.Columns.NgayketthucBhyt).EqualTo(objLuotkham.NgayketthucBhyt) .Set(KcbLuotkham.Columns.NoicapBhyt).EqualTo(objLuotkham.NoicapBhyt) .Set(KcbLuotkham.Columns.IdDoituongKcb).EqualTo(objLuotkham.IdDoituongKcb) .Set(KcbLuotkham.Columns.MaKcbbd).EqualTo(objLuotkham.MaKcbbd) .Set(KcbLuotkham.Columns.NoiDongtrusoKcbbd).EqualTo(objLuotkham.NoiDongtrusoKcbbd) .Set(KcbLuotkham.Columns.MaDoituongBhyt).EqualTo(objLuotkham.MaDoituongBhyt) .Set(KcbLuotkham.Columns.DungTuyen).EqualTo(objLuotkham.DungTuyen) .Set(KcbLuotkham.Columns.MaDoituongKcb).EqualTo(objLuotkham.MaDoituongKcb) .Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName) .Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate) .Set(KcbLuotkham.Columns.MadtuongSinhsong).EqualTo(objLuotkham.MadtuongSinhsong) .Set(KcbLuotkham.Columns.GiayBhyt).EqualTo(objLuotkham.GiayBhyt) .Set(KcbLuotkham.Columns.PtramBhyt).EqualTo(objLuotkham.PtramBhyt) .Set(KcbLuotkham.Columns.PtramBhytGoc).EqualTo(objLuotkham.PtramBhytGoc) .Set(KcbLuotkham.Columns.DiachiBhyt).EqualTo(objLuotkham.DiachiBhyt) .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham) .And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan) .Execute(); } Scope.Complete(); return ActionResult.Success; } } catch (Exception ex) { Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n"+ex.Message); return ActionResult.Exception; } }
/// <summary> /// ham thực hiện việc thêm mới thông tni bệnh nhân /// </summary> /// <param name="objBenhNhan"></param> /// <param name="objKhamBnhan"></param> /// <returns></returns> public ActionResult ThemMoiBenhNhan(RisBenhNhan objBenhNhan,ref int IDBenhNhan,ref string PID) { Query _Query = RisBenhNhan.CreateQuery(); Query _QueryPhieu = RisPhieuCdinh.CreateQuery(); try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { objBenhNhan.IsNew = true; objBenhNhan.Save(); objBenhNhan.IdBnhan = Utility.Int32Dbnull(_Query.GetMax(RisBenhNhan.Columns.IdBnhan), -1); log.Info("Them thong tin benh nhan cua ris voi ID_BenhNhan=" + objBenhNhan.IdBnhan); SqlQuery sqlQuery = new Select().From(RisBenhNhan.Schema) .Where(RisBenhNhan.Columns.IdBnhan).IsNotEqualTo(objBenhNhan.IdBnhan) .And(RisBenhNhan.Columns.Pid).IsEqualTo(objBenhNhan.Pid); log.Info( "Kiem tra thong tin xem benh nhan voi PID da co chua, neu chua co thi commit, neu co rui thi thuc hien sinh lai"); if(sqlQuery.GetRecordCount()>0) { objBenhNhan.Pid = VietBaIT.CommonLibrary.CommonBusiness.SinhPID(); log.Info("Neu ton tai PID thi cap nhap lai PID voi ma moi nhat PID=" + objBenhNhan.Pid); new Update(RisBenhNhan.Schema) .Set(RisBenhNhan.Columns.Pid).EqualTo(objBenhNhan.Pid) .Where(RisBenhNhan.Columns.IdBnhan).IsEqualTo(objBenhNhan.IdBnhan).Execute(); } } log.Info("Hoan thanh viec them moi benh nhan"); scope.Complete(); IDBenhNhan = objBenhNhan.IdBnhan; PID = objBenhNhan.Pid; return ActionResult.Success; } } catch (Exception exception) { log.Error("Loi trong qua trinh them moi benh nhan {0}", exception.ToString()); VietBaIT.CommonLibrary.ErrorLog.InsertErrorlog(exception.ToString(), Assembly.GetExecutingAssembly().GetName().Name, Assembly.GetExecutingAssembly().FullName); return ActionResult.Error; } }
protected override void On_ActionEdit(object sender, EventArgs e) { using (TransactionScope ts = new TransactionScope( )) { using (SharedDbConnectionScope ss = new SharedDbConnectionScope( )) { if (formView.Save<SysCompany>(Utilities.ToInt(Request.Params["id"])) == 0) { ts.Complete( ); lblMessage.InnerHtml = "保存成功!"; } else lblMessage.InnerHtml = "保存失败,请检查错误信息!"; } } On_ActionQuery(sender, e); }
protected override void On_ActionEdit(object sender, EventArgs e) { using (TransactionScope ts = new TransactionScope( )) { using (SharedDbConnectionScope ss = new SharedDbConnectionScope( )) { if (formView.Save<SysCompany>(CurrentUser.CompanyId) == 0) { ts.Complete( ); txtMessage.InnerHtml = "保存成功!"; } else txtMessage.InnerHtml = "保存失败!"; } } On_ActionQuery(sender, e); }
public void Nested_SharedConnectionScope_With_Different_Providers() { using (var sqlScope = new SharedDbConnectionScope(TestConfiguration.MsSql2008TestConnectionString, DbClientTypeName.MsSql)) { using (var sqliteScope = new SharedDbConnectionScope(TestConfiguration.SQLiteTestsConnectionString, DbClientTypeName.SqlLite)) { var p1 = ProviderFactory.GetProvider(TestConfiguration.MsSql2008TestConnectionString, DbClientTypeName.MsSql); var p2 = ProviderFactory.GetProvider(TestConfiguration.SQLiteTestsConnectionString, DbClientTypeName.SqlLite); var p3 = ProviderFactory.GetProvider(TestConfiguration.MsSql2008TestConnectionString, DbClientTypeName.MsSql); var p4 = ProviderFactory.GetProvider(TestConfiguration.SQLiteTestsConnectionString, DbClientTypeName.SqlLite); Assert.Same(p1.CurrentSharedConnection, p3.CurrentSharedConnection); Assert.Same(p2.CurrentSharedConnection, p4.CurrentSharedConnection); Assert.NotSame(p1.CurrentSharedConnection, p2.CurrentSharedConnection); Assert.NotSame(p3.CurrentSharedConnection, p4.CurrentSharedConnection); } } }