public void Insert(long IdBenhnhan,string MaLuotkham,string MaSokcb,decimal DonGia,decimal BhytChitra,decimal BnhanChitra,decimal PtramBhytGoc,decimal PtramBhyt,decimal PhuThu,byte TrangthaiThanhtoan,long? IdThanhtoan,DateTime? NgayThanhtoan,string NguoiThanhtoan,byte TuTuc,string MaDoituongkcb,short IdDoituongkcb,byte IdLoaidoituongkcb,short IdKhoakcb,short? IdNhanvien,int? IdGoi,byte? TrongGoi,byte? NguonThanhtoan,byte? Noitru,long? IdLichsuDoituongKcb,string MatheBhyt,DateTime NgayTao,string NguoiTao,DateTime? NgaySua,string NguoiSua)
{
KcbDangkySokham item = new KcbDangkySokham();
item.IdBenhnhan = IdBenhnhan;
item.MaLuotkham = MaLuotkham;
item.MaSokcb = MaSokcb;
item.DonGia = DonGia;
item.BhytChitra = BhytChitra;
item.BnhanChitra = BnhanChitra;
item.PtramBhytGoc = PtramBhytGoc;
item.PtramBhyt = PtramBhyt;
item.PhuThu = PhuThu;
item.TrangthaiThanhtoan = TrangthaiThanhtoan;
item.IdThanhtoan = IdThanhtoan;
item.NgayThanhtoan = NgayThanhtoan;
item.NguoiThanhtoan = NguoiThanhtoan;
item.TuTuc = TuTuc;
item.MaDoituongkcb = MaDoituongkcb;
item.IdDoituongkcb = IdDoituongkcb;
item.IdLoaidoituongkcb = IdLoaidoituongkcb;
item.IdKhoakcb = IdKhoakcb;
item.IdNhanvien = IdNhanvien;
item.IdGoi = IdGoi;
item.TrongGoi = TrongGoi;
item.NguonThanhtoan = NguonThanhtoan;
item.Noitru = Noitru;
item.IdLichsuDoituongKcb = IdLichsuDoituongKcb;
item.MatheBhyt = MatheBhyt;
item.NgayTao = NgayTao;
item.NguoiTao = NguoiTao;
item.NgaySua = NgaySua;
item.NguoiSua = NguoiSua;
item.Save(UserName);
}
public static bool CapnhatTrangthaiTutuc(KcbDangkySokham objDoituong, KcbLuotkham objLuotkham, bool noitru, byte tu_tuc, decimal PTramBHYT)
{
try
{
byte TrangthaiBhyt = 1;
decimal BHYT_PTRAM_TRAITUYENNOITRU = Utility.DecimaltoDbnull(THU_VIEN_CHUNG.Laygiatrithamsohethong("BHYT_PTRAM_TRAITUYENNOITRU", "0", false), 0m);
bool b_ExistPtramBHYT = false;
objDoituong.TuTuc = tu_tuc;
if (!THU_VIEN_CHUNG.IsBaoHiem(objLuotkham.IdLoaidoituongKcb.Value))//Đối tượng DV
{
TrangthaiBhyt = (byte)0;
objDoituong.TuTuc = 0;
}
else
{
TrangthaiBhyt = (byte)(globalVariables.gv_blnApdungChedoDuyetBHYT ? 0 : 1);
}
objDoituong.PtramBhyt = PTramBHYT;
objDoituong.PtramBhytGoc = Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, PTramBHYT);
// objChidinhChitiet.LoaiChietkhau = 0;
// objChidinhChitiet.TrangthaiBhyt = TrangthaiBhyt;
//objChidinhChitiet.IdLoaichidinh = 0;//Chưa hiểu trường này-->Cần xem lại
if (Utility.Int32Dbnull(objDoituong.TuTuc, 0) == 1)
{
objDoituong.BhytChitra = 0;
objDoituong.BnhanChitra = Utility.DecimaltoDbnull(objDoituong.DonGia, 0);
objDoituong.PtramBhyt = 0;
}
else
{
if (b_ExistPtramBHYT)
{
objDoituong.BhytChitra = Utility.DecimaltoDbnull(objDoituong.DonGia) *
Utility.DecimaltoDbnull(objDoituong.PtramBhyt) / 100;
objDoituong.BnhanChitra = Utility.DecimaltoDbnull(objDoituong.DonGia, 0) -
Utility.DecimaltoDbnull(objDoituong.BhytChitra);
}
else//99% rơi vào nhánh này
{
PTramBHYT = Utility.DecimaltoDbnull(objLuotkham.PtramBhyt);
decimal BHCT = 0m;
if (objLuotkham.DungTuyen == 1)//BHYT đúng tuyến rơi vào nhánh này dù nội trú ngay ngoại trú
{
BHCT = Utility.DecimaltoDbnull(objDoituong.DonGia, 0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0) / 100);
}
else//DV và BHYT trái tuyến
{
if (objLuotkham.TrangthaiNoitru <= 0 || !noitru)//Đối tượng ngoại trú hoặc Chỉ định ngoại trú-->Lấy phần trăm ngoại trú
{
BHCT = Utility.DecimaltoDbnull(objDoituong.DonGia, 0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0) / 100);
}
else//Nội trú cần tính=đơn giá * % đầu thẻ * % tuyến
{
BHCT = Utility.DecimaltoDbnull(objDoituong.DonGia, 0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0) / 100) * (BHYT_PTRAM_TRAITUYENNOITRU / 100);
}
}
decimal BNCT = Utility.DecimaltoDbnull(objDoituong.DonGia, 0) - BHCT;
objDoituong.BhytChitra = BHCT;
objDoituong.BnhanChitra = BNCT;
}
}
objDoituong.MarkOld();
objDoituong.IsNew = false;
objDoituong.Save();
return(true);
}
catch (Exception ex)
{
Utility.CatchException(ex);
return(false);
}
}
private KcbDangkySokham TaosoKCB()
{
KcbDangkySokham objSokham = null;
if (objDoituongKCB == null) return null;
if (chkLaysokham.Checked && txtSoKcb.myCode != "-1")
{
DmucChung objDmucchung = THU_VIEN_CHUNG.LaydoituongDmucChung(txtSoKcb.LOAI_DANHMUC, txtSoKcb.myCode);
if (objDmucchung != null)
{
objSokham = new KcbDangkySokham();
if (objDoituongKCB != null)
{
objSokham.IdLoaidoituongkcb = objDoituongKCB.IdLoaidoituongKcb;
objSokham.MaDoituongkcb = objDoituongKCB.MaDoituongKcb;
objSokham.IdDoituongkcb = objDoituongKCB.IdDoituongKcb;
}
objSokham.MaSokcb = txtSoKcb.myCode;
objSokham.PhuThu = 0;
objSokham.TrongGoi = 0;
objSokham.IdGoi = -1;
objSokham.IdNhanvien = globalVariables.gv_intIDNhanvien;
objSokham.DonGia = Utility.DecimaltoDbnull(objDmucchung.VietTat, 0);
objSokham.BhytChitra = 0;
objSokham.BnhanChitra = objSokham.DonGia;
objSokham.PtramBhyt = 0;
objSokham.PtramBhytGoc = 0;
objSokham.TrangthaiThanhtoan = 0;
objSokham.IdThanhtoan = -1;
objSokham.NgayThanhtoan = null;
objSokham.Noitru = 0;
objSokham.NguonThanhtoan = 0;
objSokham.TuTuc = Utility.Bool2byte(THU_VIEN_CHUNG.IsBaoHiem(objSokham.IdLoaidoituongkcb));
objSokham.IdKhoakcb = globalVariablesPrivate.objKhoaphong.IdKhoaphong;
}
}
return objSokham;
}
public ActionResult ThemmoiBenhnhanCapcuu(SysTrace mytrace, KcbDanhsachBenhnhan objKcbDanhsachBenhnhan, KcbLuotkham objLuotkham, KcbDangkySokham objSoKCB, NoitruPhanbuonggiuong objBuonggiuong, DateTime ngaychuyenkhoa, ref string Msg)
{
int v_IdBenhnhan = -1;
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
objKcbDanhsachBenhnhan.IsNew = true;
objKcbDanhsachBenhnhan.Save();
KcbLichsuDoituongKcb objLichsuKcb = new KcbLichsuDoituongKcb();
objLichsuKcb.IdBenhnhan = objKcbDanhsachBenhnhan.IdBenhnhan;
objLichsuKcb.MaLuotkham = objLuotkham.MaLuotkham;
objLichsuKcb.NgayHieuluc = objLuotkham.NgayTiepdon;
objLichsuKcb.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objLichsuKcb.MaDoituongKcb = objLuotkham.MaDoituongKcb;
objLichsuKcb.IdLoaidoituongKcb = objLuotkham.IdLoaidoituongKcb;
objLichsuKcb.MatheBhyt = objLuotkham.MatheBhyt;
objLichsuKcb.PtramBhyt = objLuotkham.PtramBhyt;
objLichsuKcb.PtramBhytGoc = objLuotkham.PtramBhytGoc;
objLichsuKcb.NgaybatdauBhyt = objLuotkham.NgaybatdauBhyt;
objLichsuKcb.NgayketthucBhyt = objLuotkham.NgayketthucBhyt;
objLichsuKcb.NoicapBhyt = objLuotkham.NoicapBhyt;
objLichsuKcb.MaNoicapBhyt = objLuotkham.MaNoicapBhyt;
objLichsuKcb.MaDoituongBhyt = objLuotkham.MaDoituongBhyt;
objLichsuKcb.MaQuyenloi = objLuotkham.MaQuyenloi;
objLichsuKcb.NoiDongtrusoKcbbd = objLuotkham.NoiDongtrusoKcbbd;
objLichsuKcb.MaKcbbd = objLuotkham.MaKcbbd;
objLichsuKcb.TrangthaiNoitru = 0;
objLichsuKcb.DungTuyen = objLuotkham.DungTuyen;
objLichsuKcb.Cmt = objLuotkham.Cmt;
objLichsuKcb.IdRavien = objLuotkham.IdRavien;
objLichsuKcb.IdBuong = objLuotkham.IdBuong;
objLichsuKcb.IdGiuong = objLuotkham.IdGiuong;
objLichsuKcb.IdKhoanoitru = objLuotkham.IdKhoanoitru;
objLichsuKcb.NguoiTao = globalVariables.UserName;
objLichsuKcb.NgayTao = globalVariables.SysDate;
objLichsuKcb.IsNew = true;
objLichsuKcb.Save();
//Thêm lần khám
objLuotkham.IdBenhnhan = objKcbDanhsachBenhnhan.IdBenhnhan;
objLuotkham.IdLichsuDoituongKcb = objLichsuKcb.IdLichsuDoituongKcb;
objLuotkham.SttKham = THU_VIEN_CHUNG.LaySTTKhamTheoDoituong(objLuotkham.IdDoituongKcb);
objLuotkham.NgayTao = globalVariables.SysDate;
objLuotkham.NguoiTao = globalVariables.UserName;
objLuotkham.IsNew = true;
objLuotkham.Save();
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)
{
string patientCode = THU_VIEN_CHUNG.KCB_SINH_MALANKHAM((byte)(objKcbDanhsachBenhnhan.KieuBenhnhan == 0 ? 0 : 1));
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.MaLuotkham).EqualTo(patientCode)
.Where(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham).Execute();
new Update(KcbLichsuDoituongKcb.Schema)
.Set(KcbLichsuDoituongKcb.Columns.MaLuotkham).EqualTo(patientCode)
.Where(KcbLichsuDoituongKcb.Columns.IdLichsuDoituongKcb).IsEqualTo(objLichsuKcb.IdLichsuDoituongKcb).Execute();
objLuotkham.MaLuotkham = patientCode;
}
new Update(KcbDmucLuotkham.Schema)
.Set(KcbDmucLuotkham.Columns.TrangThai).EqualTo(2)
.Set(KcbDmucLuotkham.Columns.EndTime).EqualTo(DateTime.Now)
.Where(KcbDmucLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(KcbDmucLuotkham.Columns.Loai).IsEqualTo((byte)(objKcbDanhsachBenhnhan.KieuBenhnhan == 0 ? 0 : 1))
.And(KcbDmucLuotkham.Columns.TrangThai).IsLessThanOrEqualTo(1)
.And(KcbDmucLuotkham.Columns.UsedBy).IsLessThanOrEqualTo(globalVariables.UserName)
.Execute();
//.And(KcbDmucLuotkham.Columns.Nam).IsEqualTo(globalVariables.SysDate.Year)//Tạm bỏ tránh máy client cố tình điều chỉnh khác máy server
;
if (objSoKCB != null)
{
//Kiểm tra xem có sổ KCB hay chưa
objSoKCB.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham);
objSoKCB.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan);
KcbDangkySokham _temp = new Select().From(KcbDangkySokham.Schema).Where(KcbDangkySokham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(KcbDangkySokham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.ExecuteSingle<KcbDangkySokham>();
if (_temp == null)
{
objSoKCB.NgayTao = globalVariables.SysDate;
objSoKCB.NguoiTao = globalVariables.UserName;
objSoKCB.IsNew = true;
objSoKCB.Save();
}
else
{
if (Utility.Int64Dbnull(_temp.IdThanhtoan, 0) > 0)//Ko làm gì cả
{
Msg = "Đã thu tiền sổ khám của Bệnh nhân nên không được phép xóa hoặc cập nhật lại";
}
else//Update lại sổ KCB
{
_temp.DonGia = objSoKCB.DonGia;
_temp.BnhanChitra = objSoKCB.BnhanChitra;
_temp.BhytChitra = objSoKCB.BhytChitra;
_temp.PtramBhyt = objSoKCB.PtramBhyt;
_temp.PtramBhytGoc = objSoKCB.PtramBhytGoc;
_temp.PhuThu = objSoKCB.PhuThu;
_temp.TuTuc = objSoKCB.TuTuc;
_temp.NguonThanhtoan = objSoKCB.NguonThanhtoan;
_temp.IdLoaidoituongkcb = objSoKCB.IdLoaidoituongkcb;
_temp.IdDoituongkcb = objSoKCB.IdDoituongkcb;
_temp.MaDoituongkcb = objSoKCB.MaDoituongkcb;
_temp.Noitru = objSoKCB.Noitru;
_temp.IdGoi = objSoKCB.IdGoi;
_temp.TrongGoi = objSoKCB.TrongGoi;
_temp.IdNhanvien = objSoKCB.IdNhanvien;
_temp.NgaySua = globalVariables.SysDate;
_temp.NguoiSua = globalVariables.UserName;
_temp.IsNew = false;
_temp.MarkOld();
_temp.Save();
}
}
}
else
{
new Delete().From(KcbDangkySokham.Schema).Where(KcbDangkySokham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(KcbDangkySokham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(KcbDangkySokham.Columns.TrangthaiThanhtoan).IsEqualTo(0)
.Execute();
}
//Nhập viện
if (objBuonggiuong != null)
{
objBuonggiuong.IdBenhnhan = objLuotkham.IdBenhnhan;
objBuonggiuong.MaLuotkham = objLuotkham.MaLuotkham;
noitru_nhapvien.NhapvienCapcuu(objBuonggiuong, objLuotkham);
//Chuyển vào buồng giường
if (Utility.Int16Dbnull(objBuonggiuong.IdBuong) > -1 && Utility.Int16Dbnull(objBuonggiuong.IdGiuong) > -1)
noitru_nhapvien.PhanGiuongDieuTriCapcuu(objBuonggiuong, objLuotkham, ngaychuyenkhoa, Utility.Int16Dbnull(objBuonggiuong.IdBuong), Utility.Int16Dbnull(objBuonggiuong.IdGiuong));
objLuotkham.IdKhoanoitru = objBuonggiuong.IdKhoanoitru;
objLuotkham.IdBuong = objBuonggiuong.IdBuong;
objLuotkham.IdGiuong = objBuonggiuong.IdGiuong;
objLuotkham.IdRavien = objBuonggiuong.Id;
objLuotkham.IdNhapvien = objBuonggiuong.Id;
}
mytrace.Desc = string.Format("Thêm mới Bệnh nhân cấp cứu ID={0}, Code={1}, Name={2}", objKcbDanhsachBenhnhan.IdBenhnhan.ToString(), objLuotkham.MaLuotkham, objKcbDanhsachBenhnhan.TenBenhnhan);
mytrace.Lot = 0;
mytrace.IsNew = true;
mytrace.Save();
scope.Complete();
return ActionResult.Success;
}
}
}
catch (Exception ex)
{
return ActionResult.Error;
}
}
public ActionResult UpdateLanKham(SysTrace mytrace, KcbDanhsachBenhnhan objKcbDanhsachBenhnhan, KcbLuotkham objLuotkham, KcbDangkyKcb objKcbDangkyKcb, KcbDangkySokham objSoKCB, int KieuKham, decimal PtramBhytCu, decimal PtramBhytgoc, ref string Msg)
{
ActionResult _ActionResult = ActionResult.Success;
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
UpdatePatientInfo(objKcbDanhsachBenhnhan);
long IdLichsuDoituongKcb = KcbLayIdDoituongKCBHientai(objLuotkham.IdBenhnhan, objLuotkham.MaLuotkham);
KcbLichsuDoituongKcb objLichsuKcb = null;
if (IdLichsuDoituongKcb > 0)
{
objLichsuKcb = KcbLichsuDoituongKcb.FetchByID(IdLichsuDoituongKcb);
objLichsuKcb.MarkOld();
objLichsuKcb.IsNew = false;
}
else
{
objLichsuKcb = new KcbLichsuDoituongKcb();
objLichsuKcb.IsNew = true;
}
if (objLichsuKcb == null)
{
Msg = "NULL-->Không lấy được thông tin lịch sử đối tượng KCB của Bệnh nhân";
return ActionResult.Error;
}
objLichsuKcb.IdBenhnhan = objLuotkham.IdBenhnhan;
objLichsuKcb.MaLuotkham = objLuotkham.MaLuotkham;
objLichsuKcb.NgayHieuluc = objLuotkham.NgayTiepdon;
objLichsuKcb.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objLichsuKcb.MaDoituongKcb = objLuotkham.MaDoituongKcb;
objLichsuKcb.IdLoaidoituongKcb = objLuotkham.IdLoaidoituongKcb;
objLichsuKcb.MatheBhyt = objLuotkham.MatheBhyt;
objLichsuKcb.PtramBhyt = objLuotkham.PtramBhyt;
objLichsuKcb.PtramBhytGoc = objLuotkham.PtramBhytGoc;
objLichsuKcb.NgaybatdauBhyt = objLuotkham.NgaybatdauBhyt;
objLichsuKcb.NgayketthucBhyt = objLuotkham.NgayketthucBhyt;
objLichsuKcb.NoicapBhyt = objLuotkham.NoicapBhyt;
objLichsuKcb.MaNoicapBhyt = objLuotkham.MaNoicapBhyt;
objLichsuKcb.MaDoituongBhyt = objLuotkham.MaDoituongBhyt;
objLichsuKcb.MaQuyenloi = objLuotkham.MaQuyenloi;
objLichsuKcb.NoiDongtrusoKcbbd = objLuotkham.NoiDongtrusoKcbbd;
objLichsuKcb.MaKcbbd = objLuotkham.MaKcbbd;
objLichsuKcb.TrangthaiNoitru = 0;
objLichsuKcb.DungTuyen = objLuotkham.DungTuyen;
objLichsuKcb.Cmt = objLuotkham.Cmt;
objLichsuKcb.IdRavien = -1;
objLichsuKcb.IdBuong = -1;
objLichsuKcb.IdGiuong = -1;
objLichsuKcb.IdKhoanoitru = -1;
objLichsuKcb.NguoiTao = globalVariables.UserName;
objLichsuKcb.NgayTao = globalVariables.SysDate;
objLichsuKcb.Save();
objLuotkham.IdLichsuDoituongKcb = objLichsuKcb.IdLichsuDoituongKcb;
objLuotkham.MarkOld();
objLuotkham.IsNew = false;
objLuotkham.Save();
if (objSoKCB != null)
{
//Kiểm tra xem có sổ KCB hay chưa
objSoKCB.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham);
objSoKCB.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan);
KcbDangkySokham _temp = new Select().From(KcbDangkySokham.Schema).Where(KcbDangkySokham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(KcbDangkySokham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.ExecuteSingle<KcbDangkySokham>();
if (_temp == null)
{
objSoKCB.IdLichsuDoituongKcb = objLichsuKcb.IdLichsuDoituongKcb;
objSoKCB.NgayTao = globalVariables.SysDate;
objSoKCB.NguoiTao = globalVariables.UserName;
objSoKCB.IsNew = true;
objSoKCB.Save();
}
else
{
if (Utility.Int64Dbnull(_temp.IdThanhtoan, 0) > 0)//Ko làm gì cả
{
Msg = "Đã thu tiền sổ khám của Bệnh nhân nên không được phép xóa hoặc cập nhật lại";
}
else//Update lại sổ KCB
{
_temp.DonGia = objSoKCB.DonGia;
_temp.BnhanChitra = objSoKCB.BnhanChitra;
_temp.BhytChitra = objSoKCB.BhytChitra;
_temp.PtramBhyt = objSoKCB.PtramBhyt;
_temp.PtramBhytGoc = objSoKCB.PtramBhytGoc;
_temp.PhuThu = objSoKCB.PhuThu;
_temp.TuTuc = objSoKCB.TuTuc;
_temp.NguonThanhtoan = objSoKCB.NguonThanhtoan;
_temp.IdLoaidoituongkcb = objSoKCB.IdLoaidoituongkcb;
_temp.IdDoituongkcb = objSoKCB.IdDoituongkcb;
_temp.MaDoituongkcb = objSoKCB.MaDoituongkcb;
_temp.IdLichsuDoituongKcb = objLichsuKcb.IdLichsuDoituongKcb;
_temp.Noitru = objSoKCB.Noitru;
_temp.IdGoi = objSoKCB.IdGoi;
_temp.TrongGoi = objSoKCB.TrongGoi;
_temp.IdNhanvien = objSoKCB.IdNhanvien;
_temp.NgaySua = globalVariables.SysDate;
_temp.NguoiSua = globalVariables.UserName;
_temp.IsNew = false;
_temp.MarkOld();
_temp.Save();
}
}
}
else
{
new Delete().From(KcbDangkySokham.Schema).Where(KcbDangkySokham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(KcbDangkySokham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(KcbDangkySokham.Columns.TrangthaiThanhtoan).IsEqualTo(0)
.Execute();
}
//Kiểm tra nếu % bị thay đổi thì cập nhật lại tất cả các bảng
if (PtramBhytCu != Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0) || PtramBhytgoc != Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0))
_ActionResult = THU_VIEN_CHUNG.UpdatePtramBHYT(objLuotkham, -1);
if (_ActionResult == ActionResult.Cancel)//Báo không cho phép thay đổi phần trăm BHYT do đã có dịch vụ đã thanh toán
{
return _ActionResult;
}
if (objKcbDangkyKcb != null)
{
objKcbDangkyKcb.IdLichsuDoituongKcb = objLichsuKcb.IdLichsuDoituongKcb;
objKcbDangkyKcb.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham);
objKcbDangkyKcb.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan);
AddRegExam(objKcbDangkyKcb, objLuotkham, false, KieuKham);
}
mytrace.Desc = string.Format("Cập nhật Bệnh nhân ID={0}, Code={1}, Name={2}", objKcbDanhsachBenhnhan.IdBenhnhan.ToString(), objLuotkham.MaLuotkham, objKcbDanhsachBenhnhan.TenBenhnhan);
mytrace.Lot = 0;
mytrace.IsNew = true;
mytrace.Save();
scope.Complete();
return ActionResult.Success;
}
}
}
catch (Exception ex)
{
log.Error("Loi trong qua trinh update thong tin benh nhan {0}", ex);
return ActionResult.Error;
}
}
public ActionResult ThemmoiLuotkham(SysTrace mytrace, KcbDanhsachBenhnhan objKcbDanhsachBenhnhan, KcbLuotkham objLuotkham, KcbDangkyKcb objKcbDangkyKcb, KcbDangkySokham objSoKCB, int KieuKham, ref long id_kham, ref string Msg)
{
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
UpdatePatientInfo(objKcbDanhsachBenhnhan);
KcbLichsuDoituongKcb objLichsuKcb = new KcbLichsuDoituongKcb();
objLichsuKcb.IdBenhnhan = objLuotkham.IdBenhnhan;
objLichsuKcb.MaLuotkham = objLuotkham.MaLuotkham;
objLichsuKcb.NgayHieuluc = objLuotkham.NgayTiepdon;
objLichsuKcb.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objLichsuKcb.MaDoituongKcb = objLuotkham.MaDoituongKcb;
objLichsuKcb.IdLoaidoituongKcb = objLuotkham.IdLoaidoituongKcb;
objLichsuKcb.MatheBhyt = objLuotkham.MatheBhyt;
objLichsuKcb.PtramBhyt = objLuotkham.PtramBhyt;
objLichsuKcb.PtramBhytGoc = objLuotkham.PtramBhytGoc;
objLichsuKcb.NgaybatdauBhyt = objLuotkham.NgaybatdauBhyt;
objLichsuKcb.NgayketthucBhyt = objLuotkham.NgayketthucBhyt;
objLichsuKcb.NoicapBhyt = objLuotkham.NoicapBhyt;
objLichsuKcb.MaNoicapBhyt = objLuotkham.MaNoicapBhyt;
objLichsuKcb.MaDoituongBhyt = objLuotkham.MaDoituongBhyt;
objLichsuKcb.MaQuyenloi = objLuotkham.MaQuyenloi;
objLichsuKcb.NoiDongtrusoKcbbd = objLuotkham.NoiDongtrusoKcbbd;
objLichsuKcb.MaKcbbd = objLuotkham.MaKcbbd;
objLichsuKcb.TrangthaiNoitru = 0;
objLichsuKcb.DungTuyen = objLuotkham.DungTuyen;
objLichsuKcb.Cmt = objLuotkham.Cmt;
objLichsuKcb.IdRavien = -1;
objLichsuKcb.IdBuong = -1;
objLichsuKcb.IdGiuong = -1;
objLichsuKcb.IdKhoanoitru = -1;
objLichsuKcb.NguoiTao = globalVariables.UserName;
objLichsuKcb.NgayTao = globalVariables.SysDate;
objLichsuKcb.IsNew = true;
objLichsuKcb.Save();
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((byte)(objKcbDanhsachBenhnhan.KieuBenhnhan == 0 ? 0 : 1));
new Update(KcbLichsuDoituongKcb.Schema)
.Set(KcbLichsuDoituongKcb.Columns.MaLuotkham).EqualTo(objLuotkham.MaLuotkham)
.Where(KcbLichsuDoituongKcb.Columns.IdLichsuDoituongKcb).IsEqualTo(objLichsuKcb.IdLichsuDoituongKcb).Execute();
}
objLuotkham.IdLichsuDoituongKcb = objLichsuKcb.IdLichsuDoituongKcb;
objLuotkham.IsNew = true;
objLuotkham.Save();
new Update(KcbDmucLuotkham.Schema)
.Set(KcbDmucLuotkham.Columns.TrangThai).EqualTo(2)
.Set(KcbDmucLuotkham.Columns.EndTime).EqualTo(DateTime.Now)
.Where(KcbDmucLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(KcbDmucLuotkham.Columns.Loai).IsEqualTo((byte)(objKcbDanhsachBenhnhan.KieuBenhnhan == 0 ? 0 : 1))
.And(KcbDmucLuotkham.Columns.TrangThai).IsLessThanOrEqualTo(1)
.And(KcbDmucLuotkham.Columns.Nam).IsEqualTo(globalVariables.SysDate.Year)
.And(KcbDmucLuotkham.Columns.UsedBy).IsLessThanOrEqualTo(globalVariables.UserName)
.Execute();
;
if (objSoKCB != null)
{
//Kiểm tra xem có sổ KCB hay chưa
objSoKCB.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham);
objSoKCB.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan);
KcbDangkySokham _temp = new Select().From(KcbDangkySokham.Schema).Where(KcbDangkySokham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(KcbDangkySokham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.ExecuteSingle<KcbDangkySokham>();
if (_temp == null)
{
objSoKCB.IdLichsuDoituongKcb = objLichsuKcb.IdLichsuDoituongKcb;
objSoKCB.NgayTao = globalVariables.SysDate;
objSoKCB.NguoiTao = globalVariables.UserName;
objSoKCB.IsNew = true;
objSoKCB.Save();
}
else
{
if (Utility.Int64Dbnull(_temp.IdThanhtoan, 0) > 0)//Ko làm gì cả
{
Msg = "Đã thu tiền sổ khám của Bệnh nhân nên không được phép xóa hoặc cập nhật lại";
}
else//Update lại sổ KCB
{
_temp.DonGia = objSoKCB.DonGia;
_temp.BnhanChitra = objSoKCB.BnhanChitra;
_temp.BhytChitra = objSoKCB.BhytChitra;
_temp.PtramBhyt = objSoKCB.PtramBhyt;
_temp.PtramBhytGoc = objSoKCB.PtramBhytGoc;
_temp.PhuThu = objSoKCB.PhuThu;
_temp.TuTuc = objSoKCB.TuTuc;
_temp.NguonThanhtoan = objSoKCB.NguonThanhtoan;
_temp.IdLoaidoituongkcb = objSoKCB.IdLoaidoituongkcb;
_temp.IdDoituongkcb = objSoKCB.IdDoituongkcb;
_temp.MaDoituongkcb = objSoKCB.MaDoituongkcb;
_temp.IdLichsuDoituongKcb = objLichsuKcb.IdLichsuDoituongKcb;
_temp.Noitru = objSoKCB.Noitru;
_temp.IdGoi = objSoKCB.IdGoi;
_temp.TrongGoi = objSoKCB.TrongGoi;
_temp.IdNhanvien = objSoKCB.IdNhanvien;
_temp.NgaySua = globalVariables.SysDate;
_temp.NguoiSua = globalVariables.UserName;
_temp.IsNew = false;
_temp.MarkOld();
_temp.Save();
}
}
}
else
{
new Delete().From(KcbDangkySokham.Schema).Where(KcbDangkySokham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(KcbDangkySokham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(KcbDangkySokham.Columns.TrangthaiThanhtoan).IsEqualTo(0)
.Execute();
}
if (objKcbDangkyKcb != null)
{
objKcbDangkyKcb.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham);
objKcbDangkyKcb.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan);
objKcbDangkyKcb.IdLichsuDoituongKcb = objLichsuKcb.IdLichsuDoituongKcb;
id_kham= AddRegExam(objKcbDangkyKcb,objLuotkham, false, KieuKham);
}
mytrace.Desc = string.Format("Thêm mới lượt khám ID={0}, Code={1}, Name={2}", objKcbDanhsachBenhnhan.IdBenhnhan.ToString(), objLuotkham.MaLuotkham, objKcbDanhsachBenhnhan.TenBenhnhan);
mytrace.Lot = 0;
mytrace.IsNew = true;
mytrace.Save();
scope.Complete();
return ActionResult.Success;
}
}
}
catch (Exception ex)
{
return ActionResult.Error;
}
}
