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