public ActionResult InsertDataChiDinhCLS(KcbChidinhcl objAssignInfo, KcbLuotkham objPatientExam, KcbChidinhclsChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objAssignInfo != null)
{
if (objPatientExam == null)
{
objPatientExam = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objAssignInfo.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
Utility.Int32Dbnull(objAssignInfo.IdBenhnhan)).ExecuteSingle <KcbLuotkham>();
}
if (objPatientExam != null)
{
objAssignInfo.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLS();
objAssignInfo.IsNew = true;
objAssignInfo.Save();
InsertAssignDetail(objAssignInfo, objPatientExam, arrAssignDetails);
}
else
{
return(ActionResult.Error);
}
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
log.InfoException("Loi thong tin {0}", exception);
return(ActionResult.Error);
}
}
public ActionResult InsertDataChiDinhCLS(KcbChidinhcl objKcbChidinhcls, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objKcbChidinhcls != null)
{
if (objLuotkham == null)
{
objLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objKcbChidinhcls.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
Utility.Int32Dbnull(objKcbChidinhcls.IdBenhnhan)).ExecuteSingle<KcbLuotkham>();
}
if (objLuotkham != null)
{
objKcbChidinhcls.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLS();
objKcbChidinhcls.MaDoituongKcb = objLuotkham.MaDoituongKcb;
objKcbChidinhcls.IdLoaidoituongKcb = objLuotkham.IdLoaidoituongKcb;
objKcbChidinhcls.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objKcbChidinhcls.MaKhoaChidinh = globalVariables.MA_KHOA_THIEN;
objKcbChidinhcls.IsNew = true;
objKcbChidinhcls.Save();
InsertAssignDetail(objKcbChidinhcls, objLuotkham, arrAssignDetails);
}
else
{
return ActionResult.Error;
}
}
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
log.InfoException("Loi thong tin {0}", exception);
return ActionResult.Error;
}
}
public ActionResult UpdateDataChiDinhCLS(KcbChidinhcl objKcbChidinhcls, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrAssignDetails)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objLuotkham == null)
{
objLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objKcbChidinhcls.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(
Utility.Int32Dbnull(objKcbChidinhcls.IdBenhnhan)).ExecuteSingle<KcbLuotkham>();
}
objKcbChidinhcls.Save();
if (Utility.Int32Dbnull(objKcbChidinhcls.IdKham) > 0)
{
new Update(KcbDangkyKcb.Schema)
.Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(objKcbChidinhcls.IdBacsiChidinh)
.Where(KcbDangkyKcb.IdKhamColumn).IsEqualTo(objKcbChidinhcls.IdKham).Execute();
}
log.Info("Cap nhap lai thong tin cua phieu chi dinh voi Assign_ID=" + objKcbChidinhcls.IdChidinh);
InsertAssignDetail(objKcbChidinhcls, objLuotkham, arrAssignDetails);
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
log.InfoException("Loi thong tin ", exception);
return ActionResult.Error;
}
}
public void Insert(long? IdKham,long? IdBuongGiuong,int? IdDieutri,int? IdKhoadieutri,string MaLuotkham,long IdBenhnhan,DateTime NgayChidinh,short? IdBacsiChidinh,short? IdPhongChidinh,DateTime? NgayThanhtoan,byte TrangthaiThanhtoan,byte? TrangThai,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua,byte? TinhtrangIn,string Barcode,byte? Noitru,short? IdKhoaChidinh,string MaKhoaChidinh,string MaChidinh,short? IdDoituongKcb,byte? IdLoaidoituongKcb,string MaDoituongKcb,byte? ChidinhGoidichvu,string IpMaytao,string IpMaysua,string TenMaytao,string TenMaysua)
{
KcbChidinhcl item = new KcbChidinhcl();
item.IdKham = IdKham;
item.IdBuongGiuong = IdBuongGiuong;
item.IdDieutri = IdDieutri;
item.IdKhoadieutri = IdKhoadieutri;
item.MaLuotkham = MaLuotkham;
item.IdBenhnhan = IdBenhnhan;
item.NgayChidinh = NgayChidinh;
item.IdBacsiChidinh = IdBacsiChidinh;
item.IdPhongChidinh = IdPhongChidinh;
item.NgayThanhtoan = NgayThanhtoan;
item.TrangthaiThanhtoan = TrangthaiThanhtoan;
item.TrangThai = TrangThai;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.TinhtrangIn = TinhtrangIn;
item.Barcode = Barcode;
item.Noitru = Noitru;
item.IdKhoaChidinh = IdKhoaChidinh;
item.MaKhoaChidinh = MaKhoaChidinh;
item.MaChidinh = MaChidinh;
item.IdDoituongKcb = IdDoituongKcb;
item.IdLoaidoituongKcb = IdLoaidoituongKcb;
item.MaDoituongKcb = MaDoituongKcb;
item.ChidinhGoidichvu = ChidinhGoidichvu;
item.IpMaytao = IpMaytao;
item.IpMaysua = IpMaysua;
item.TenMaytao = TenMaytao;
item.TenMaysua = TenMaysua;
item.Save(UserName);
}
public ActionResult SaoChepPhieuDieuTri(NoitruPhieudieutri[] lstPhieudieutri, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrChidinhCLSChitiet, KcbDonthuocChitiet[] arrDonthuocChitiet)
{
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
foreach (NoitruPhieudieutri objTreatment in lstPhieudieutri)
{
objTreatment.NguoiTao = globalVariables.UserName;
objTreatment.NgayTao = DateTime.Now;
objTreatment.TthaiBosung = 0;
objTreatment.IdBacsi = globalVariables.gv_intIDNhanvien;
objTreatment.IdKhoanoitru = objLuotkham.IdKhoanoitru;
objTreatment.MaLuotkham = objLuotkham.MaLuotkham;
objTreatment.IdBenhnhan = objTreatment.IdBenhnhan;
objTreatment.IdBuongGiuong = objLuotkham.IdRavien;
objTreatment.TrangThai = 0;
objTreatment.TthaiIn = 0;
objTreatment.IpMaytao = globalVariables.gv_strIPAddress;
objTreatment.TenMaytao = globalVariables.gv_strComputerName;
objTreatment.GioDieutri = Utility.GetFormatDateTime(globalVariables.SysDate, "hh:mm:ss");
objTreatment.IsNew = true;
objTreatment.Save();
if (arrChidinhCLSChitiet.Length > 0)
{
KcbChidinhcl objAssignInfo = new KcbChidinhcl();
objAssignInfo.IdDieutri = objTreatment.IdPhieudieutri;
objAssignInfo.IdBuongGiuong = objTreatment.IdBuongGiuong;
objAssignInfo.MaLuotkham = objTreatment.MaLuotkham;
objAssignInfo.IdBenhnhan = Utility.Int32Dbnull(objTreatment.IdBenhnhan);
objAssignInfo.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objAssignInfo.Noitru = 1;
objAssignInfo.IdKhoadieutri = objTreatment.IdKhoanoitru;
objAssignInfo.IdKhoaChidinh = objTreatment.IdKhoanoitru;
objAssignInfo.IdKham=-1;
objAssignInfo.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objAssignInfo.IdPhongChidinh = objTreatment.IdKhoanoitru;
objAssignInfo.Barcode = string.Empty;
objAssignInfo.NgayChidinh = objTreatment.NgayDieutri.Value;
objAssignInfo.NguoiTao = globalVariables.UserName;
objAssignInfo.NgayTao = globalVariables.SysDate;
objAssignInfo.IpMaytao = globalVariables.gv_strIPAddress;
objAssignInfo.TenMaytao = globalVariables.gv_strComputerName;
objAssignInfo.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLS();
objAssignInfo.IsNew = true;
objAssignInfo.Save();
List<KcbChidinhclsChitiet> lstChidinhCLSChitiet=new List<KcbChidinhclsChitiet>();
foreach (KcbChidinhclsChitiet objAssignDetail in arrChidinhCLSChitiet)
{
KcbChidinhclsChitiet objDetail = KcbChidinhclsChitiet.FetchByID(objAssignDetail.IdChitietchidinh);
if (objDetail != null)
{
objDetail.IdChitietchidinh = -1;
objDetail.IdChidinh = objAssignInfo.IdChidinh;
objDetail.IdKham = -1;
objDetail.TrangthaiThanhtoan = 0;
objDetail.NgayThanhtoan = null;
objDetail.TrangthaiHuy = 0;
objDetail.ImgPath1 = string.Empty;
objDetail.ImgPath2 = string.Empty;
objDetail.ImgPath3 = string.Empty;
objDetail.ImgPath4 = string.Empty;
objDetail.TrangThai =0;
//objDetail.MotaThem = null;
objDetail.TrangthaiBhyt = 0;
objDetail.IdThanhtoan = -1;
objDetail.IdKhoaThuchien =(short) objAssignInfo.IdKhoadieutri;
objDetail.IdPhongThuchien = objDetail.IdKhoaThuchien;
objDetail.IdGoi = -1;
objDetail.IdBacsiThuchien = -1;
objDetail.NgayThuchien = null;
objDetail.NguoiThuchien = null;
//objDetail.KetLuan = null;
objDetail.KetQua = null;
//objDetail.DeNghi = null;
//objDetail.MaVungkhaosat = null;
objDetail.NguoiTao = globalVariables.UserName;
objDetail.NgayTao = globalVariables.SysDate;
objDetail.IpMaytao = globalVariables.gv_strIPAddress;
objDetail.TenMaytao = globalVariables.gv_strComputerName;
objDetail.IsNew=true;
lstChidinhCLSChitiet.Add(objDetail);
}
new KCB_CHIDINH_CANLAMSANG().InsertAssignDetail(objAssignInfo, objLuotkham, lstChidinhCLSChitiet.ToArray<KcbChidinhclsChitiet>());
}
}
if (arrDonthuocChitiet.Length > 0)
{
var query = (from donthuoc in arrDonthuocChitiet.AsEnumerable()
let y = donthuoc.IdDonthuoc
select y).Distinct();
foreach (var pres_id in query.ToList())
{
KcbDonthuoc objPresInfo = KcbDonthuoc.FetchByID(Utility.Int32Dbnull(pres_id));
if (objPresInfo != null)
{
objPresInfo.Noitru = 1;
List<KcbDonthuocChitiet> lstDonthuocchitiet = (from donthuoc in arrDonthuocChitiet.AsEnumerable()
where donthuoc.IdDonthuoc == pres_id
select donthuoc).ToList<KcbDonthuocChitiet>();
SaoChepDonThuocTheoPhieuDieuTri(objPresInfo, objTreatment, lstDonthuocchitiet.ToArray<KcbDonthuocChitiet>());
}
}
}
}
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
return ActionResult.Error;
}
}
public ActionResult SaoChepPhieuDieuTri(NoitruPhieudieutri[] lstPhieudieutri, KcbLuotkham objLuotkham, KcbChidinhclsChitiet[] arrChidinhCLSChitiet, KcbDonthuocChitiet[] arrDonthuocChitiet)
{
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
foreach (NoitruPhieudieutri objTreatment in lstPhieudieutri)
{
objTreatment.NguoiTao = globalVariables.UserName;
objTreatment.NgayTao = DateTime.Now;
objTreatment.TthaiBosung = 0;
objTreatment.IdBacsi = globalVariables.gv_intIDNhanvien;
objTreatment.IdKhoanoitru = objLuotkham.IdKhoanoitru;
objTreatment.MaLuotkham = objLuotkham.MaLuotkham;
objTreatment.IdBenhnhan = objTreatment.IdBenhnhan;
objTreatment.IdBuongGiuong = objLuotkham.IdRavien;
objTreatment.TrangThai = 0;
objTreatment.TthaiIn = 0;
objTreatment.IpMaytao = globalVariables.gv_strIPAddress;
objTreatment.TenMaytao = globalVariables.gv_strComputerName;
objTreatment.GioDieutri = Utility.GetFormatDateTime(globalVariables.SysDate, "hh:mm:ss");
objTreatment.IsNew = true;
objTreatment.Save();
if (arrChidinhCLSChitiet.Length > 0)
{
KcbChidinhcl objAssignInfo = new KcbChidinhcl();
objAssignInfo.IdDieutri = objTreatment.IdPhieudieutri;
objAssignInfo.IdBuongGiuong = objTreatment.IdBuongGiuong;
objAssignInfo.MaLuotkham = objTreatment.MaLuotkham;
objAssignInfo.IdBenhnhan = Utility.Int32Dbnull(objTreatment.IdBenhnhan);
objAssignInfo.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objAssignInfo.Noitru = 1;
objAssignInfo.IdKhoadieutri = objTreatment.IdKhoanoitru;
objAssignInfo.IdKhoaChidinh = objTreatment.IdKhoanoitru;
objAssignInfo.IdKham = -1;
objAssignInfo.IdDoituongKcb = objLuotkham.IdDoituongKcb;
objAssignInfo.IdPhongChidinh = objTreatment.IdKhoanoitru;
objAssignInfo.Barcode = string.Empty;
objAssignInfo.NgayChidinh = objTreatment.NgayDieutri.Value;
objAssignInfo.NguoiTao = globalVariables.UserName;
objAssignInfo.NgayTao = globalVariables.SysDate;
objAssignInfo.IpMaytao = globalVariables.gv_strIPAddress;
objAssignInfo.TenMaytao = globalVariables.gv_strComputerName;
objAssignInfo.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLS();
objAssignInfo.IsNew = true;
objAssignInfo.Save();
List <KcbChidinhclsChitiet> lstChidinhCLSChitiet = new List <KcbChidinhclsChitiet>();
foreach (KcbChidinhclsChitiet objAssignDetail in arrChidinhCLSChitiet)
{
KcbChidinhclsChitiet objDetail = KcbChidinhclsChitiet.FetchByID(objAssignDetail.IdChitietchidinh);
if (objDetail != null)
{
objDetail.IdChitietchidinh = -1;
objDetail.IdChidinh = objAssignInfo.IdChidinh;
objDetail.IdKham = -1;
objDetail.TrangthaiThanhtoan = 0;
objDetail.NgayThanhtoan = null;
objDetail.TrangthaiHuy = 0;
objDetail.ImgPath1 = string.Empty;
objDetail.ImgPath2 = string.Empty;
objDetail.ImgPath3 = string.Empty;
objDetail.ImgPath4 = string.Empty;
objDetail.TrangThai = 0;
//objDetail.MotaThem = null;
objDetail.TrangthaiBhyt = 0;
objDetail.IdThanhtoan = -1;
objDetail.IdKhoaThuchien = (short)objAssignInfo.IdKhoadieutri;
objDetail.IdPhongThuchien = objDetail.IdKhoaThuchien;
objDetail.IdGoi = -1;
objDetail.IdBacsiThuchien = -1;
objDetail.NgayThuchien = null;
objDetail.NguoiThuchien = null;
//objDetail.KetLuan = null;
objDetail.KetQua = null;
//objDetail.DeNghi = null;
//objDetail.MaVungkhaosat = null;
objDetail.NguoiTao = globalVariables.UserName;
objDetail.NgayTao = globalVariables.SysDate;
objDetail.IpMaytao = globalVariables.gv_strIPAddress;
objDetail.TenMaytao = globalVariables.gv_strComputerName;
objDetail.IsNew = true;
lstChidinhCLSChitiet.Add(objDetail);
}
new KCB_CHIDINH_CANLAMSANG().InsertAssignDetail(objAssignInfo, objLuotkham, lstChidinhCLSChitiet.ToArray <KcbChidinhclsChitiet>());
}
}
if (arrDonthuocChitiet.Length > 0)
{
var query = (from donthuoc in arrDonthuocChitiet.AsEnumerable()
let y = donthuoc.IdDonthuoc
select y).Distinct();
foreach (var pres_id in query.ToList())
{
KcbDonthuoc objPresInfo = KcbDonthuoc.FetchByID(Utility.Int32Dbnull(pres_id));
if (objPresInfo != null)
{
objPresInfo.Noitru = 1;
List <KcbDonthuocChitiet> lstDonthuocchitiet = (from donthuoc in arrDonthuocChitiet.AsEnumerable()
where donthuoc.IdDonthuoc == pres_id
select donthuoc).ToList <KcbDonthuocChitiet>();
SaoChepDonThuocTheoPhieuDieuTri(objPresInfo, objTreatment, lstDonthuocchitiet.ToArray <KcbDonthuocChitiet>());
}
}
}
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
return(ActionResult.Error);
}
}
public void Insert(long? IdKham,long? IdBuongGiuong,long? IdDieutri,int? IdKhoadieutri,long IdBenhnhan,string MaLuotkham,DateTime NgayChidinh,short? IdBacsiChidinh,short? IdPhongChidinh,DateTime? NgayThanhtoan,byte TrangthaiThanhtoan,byte? TrangThai,byte? TinhtrangIn,string Barcode,byte? Noitru,short? IdKhoaChidinh,string MaKhoaChidinh,string MaChidinh,string MaBenhpham,short? IdDoituongKcb,byte? IdLoaidoituongKcb,string MaDoituongKcb,byte? KieuChidinh,long? IdLichsuDoituongKcb,string MatheBhyt,string IpMaytao,string IpMaysua,string TenMaytao,string TenMaysua,string NguoigiaoMau,string NguoinhanMau,string MotaThem,byte? DaBangiaomau,int? LuongmauHoaly,int? LuongmauVisinh,int? LuongmauGui,byte? LuuMau,string DieukienLuumau,byte? ThanhlyMau,DateTime? NgayThanhly,string NguoiThanhly,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua,string LastActionName)
{
KcbChidinhcl item = new KcbChidinhcl();
item.IdKham = IdKham;
item.IdBuongGiuong = IdBuongGiuong;
item.IdDieutri = IdDieutri;
item.IdKhoadieutri = IdKhoadieutri;
item.IdBenhnhan = IdBenhnhan;
item.MaLuotkham = MaLuotkham;
item.NgayChidinh = NgayChidinh;
item.IdBacsiChidinh = IdBacsiChidinh;
item.IdPhongChidinh = IdPhongChidinh;
item.NgayThanhtoan = NgayThanhtoan;
item.TrangthaiThanhtoan = TrangthaiThanhtoan;
item.TrangThai = TrangThai;
item.TinhtrangIn = TinhtrangIn;
item.Barcode = Barcode;
item.Noitru = Noitru;
item.IdKhoaChidinh = IdKhoaChidinh;
item.MaKhoaChidinh = MaKhoaChidinh;
item.MaChidinh = MaChidinh;
item.MaBenhpham = MaBenhpham;
item.IdDoituongKcb = IdDoituongKcb;
item.IdLoaidoituongKcb = IdLoaidoituongKcb;
item.MaDoituongKcb = MaDoituongKcb;
item.KieuChidinh = KieuChidinh;
item.IdLichsuDoituongKcb = IdLichsuDoituongKcb;
item.MatheBhyt = MatheBhyt;
item.IpMaytao = IpMaytao;
item.IpMaysua = IpMaysua;
item.TenMaytao = TenMaytao;
item.TenMaysua = TenMaysua;
item.NguoigiaoMau = NguoigiaoMau;
item.NguoinhanMau = NguoinhanMau;
item.MotaThem = MotaThem;
item.DaBangiaomau = DaBangiaomau;
item.LuongmauHoaly = LuongmauHoaly;
item.LuongmauVisinh = LuongmauVisinh;
item.LuongmauGui = LuongmauGui;
item.LuuMau = LuuMau;
item.DieukienLuumau = DieukienLuumau;
item.ThanhlyMau = ThanhlyMau;
item.NgayThanhly = NgayThanhly;
item.NguoiThanhly = NguoiThanhly;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.LastActionName = LastActionName;
item.Save(UserName);
}
public static ActionResult Thembenhnhan(KcbDanhsachBenhnhan objdanhsachbenhnhan, KcbLuotkham objluotkham,
KcbChidinhcl objchidinh, KcbDangkyKcb objDangkyKcb,
KcbChidinhclsChitiet[] objchidinhchitiet,
ref string errMsg)
{
Logger log = LogManager.GetCurrentClassLogger();
try
{
var option = new TransactionOptions
{
IsolationLevel = IsolationLevel.Snapshot, Timeout = TimeSpan.FromMinutes(5)
};
using (var trans = new TransactionScope())
{
using (var shs = new SharedDbConnectionScope())
{
log.Trace("1.Bắt đầu thêm mới bệnh nhân " + objdanhsachbenhnhan.TenBenhnhan + "");
string PatientCode =
THU_VIEN_CHUNG.KCB_SINH_MALANKHAM(
(byte)(Utility.Int16Dbnull(objdanhsachbenhnhan.KieuBenhnhan, 1)));
// Them moi thong tin benh nhan
SqlQuery objdbenhnhan = new Select().From(KcbDanhsachBenhnhan.Schema)
.Where(KcbDanhsachBenhnhan.Columns.IdBenhnhan).IsEqualTo(objdanhsachbenhnhan.IdBenhnhan);
if (objdbenhnhan.GetRecordCount() > 0)
{
objdanhsachbenhnhan.MarkOld();
objdanhsachbenhnhan.IsLoaded = true;
}
else
{
objdanhsachbenhnhan.IsNew = true;
}
objdanhsachbenhnhan.Save();
log.Trace("2. Đã thêm mới Bệnh nhân");
// them moi lan kham cho benh nhan
objluotkham.MaLuotkham = Utility.sDbnull(PatientCode, "");
SqlQuery sqlPatientExam = new Select().From(KcbLuotkham.Schema).Where(
KcbLuotkham.Columns.MaLuotkham)
.IsEqualTo(objluotkham.MaLuotkham);
if (sqlPatientExam.GetRecordCount() > 0)
{
objluotkham.MarkOld();
objluotkham.IsLoaded = true;
}
else
{
objluotkham.IsNew = true;
objluotkham.MaLuotkham = PatientCode;
objluotkham.IdBenhnhan = objdanhsachbenhnhan.IdBenhnhan;
}
objluotkham.Save();
log.Trace("3. Đã thêm mới Lượt khám Bệnh nhân");
DataTable dtCheck =
SPs.SpKcbKiemtraTrungMaLuotkham(objluotkham.IdBenhnhan, objluotkham.MaLuotkham).
GetDataSet().Tables[0];
if (dtCheck != null && dtCheck.Rows.Count > 0)
{
log.Trace("3.1 Đã phát hiện trùng mã Bệnh nhân-->Lấy lại mã mới");
string patientCode =
THU_VIEN_CHUNG.KCB_SINH_MALANKHAM(
(byte)(Utility.Int16Dbnull(objdanhsachbenhnhan.KieuBenhnhan, 1)));
SPs.SpKcbCapnhatLuotkhamMaluotkham(patientCode, objluotkham.MaLuotkham,
objluotkham.IdBenhnhan).Execute();
log.Trace("3.2 Cập nhập mã lượt khám này được sử dụng rồi");
// SPs.SpKcbCapnhatMaluotkhamLichsudoituongKcb(patientCode, objLichsuKcb.IdLichsuDoituongKcb).Execute();
// log.Trace("3.2 Đã Cập nhật lại mã lượt khám mới");
objluotkham.MaLuotkham = patientCode;
}
SPs.SpKcbCapnhatDmucLuotkham(objluotkham.MaLuotkham,
(byte)(Utility.Int16Dbnull(objdanhsachbenhnhan.KieuBenhnhan, 1)), 1, 2,
globalVariables.UserName).Execute();
log.Trace("4. Đã đánh dấu mã lượt khám đã được sử dụng trong hệ thống");
// Them moi thong tin chi dinh cho benh nhan
if (objDangkyKcb != null)
{
SqlQuery sqldangkykcb = new Select().From(KcbDangkyKcb.Schema).Where(
KcbDangkyKcb.Columns.IdKham)
.IsEqualTo(Utility.Int64Dbnull(objDangkyKcb.IdKham, -1));
if (sqldangkykcb.GetRecordCount() > 0)
{
objDangkyKcb.MarkOld();
objDangkyKcb.IsLoaded = true;
}
else
{
objDangkyKcb.IsNew = true;
objDangkyKcb.MaLuotkham = PatientCode;
objDangkyKcb.IdBenhnhan = objdanhsachbenhnhan.IdBenhnhan;
}
objDangkyKcb.Save();
}
SqlQuery sqlAssignInfo = new Select().From(KcbChidinhcl.Schema)
.Where(KcbChidinhcl.Columns.IdChidinh).IsEqualTo(objchidinh.IdChidinh);
if (objDangkyKcb != null)
{
objchidinh.IdKham = objDangkyKcb.IdKham;
}
objchidinh.IdDoituongKcb = 3;
objchidinh.MaDoituongKcb = "KSK";
objchidinh.IdLoaidoituongKcb = 2;
if (sqlAssignInfo.GetRecordCount() > 0)
{
objchidinh.MarkOld();
objchidinh.IsLoaded = true;
}
else
{
objchidinh.IsNew = true;
objchidinh.MaChidinh = THU_VIEN_CHUNG.SinhMaChidinhCLSKSK();
}
objchidinh.IdBenhnhan = objluotkham.IdBenhnhan;
objchidinh.MaLuotkham = objluotkham.MaLuotkham;
objchidinh.NguoiSua = globalVariables.UserName;
objchidinh.NgaySua = DateTime.Now;
if (string.IsNullOrEmpty(objchidinh.MaKhoaChidinh))
{
objchidinh.MaKhoaChidinh = Utility.sDbnull(objluotkham.MaKhoaThuchien);
}
objchidinh.Save();
log.Trace("5. Đã thêm mới phiếu chỉ định cho bệnh nhân");
if (Utility.Int32Dbnull(objchidinh.IdChidinh) > 0)
{
foreach (KcbChidinhclsChitiet objAssignDetail in objchidinhchitiet)
{
// Them chi tiet chi dinh cho benh nhan
SqlQuery sqlAssignDetail = new Select().From(KcbChidinhclsChitiet.Schema)
.Where(KcbChidinhclsChitiet.Columns.IdChitietchidinh).IsEqualTo(
objAssignDetail.IdChitietchidinh);
if (sqlAssignDetail.GetRecordCount() > 0)
{
objAssignDetail.MarkOld();
objAssignDetail.IsLoaded = true;
}
else
{
objAssignDetail.IsNew = true;
}
objAssignDetail.IdDoituongKcb = Utility.Int16Dbnull(objluotkham.IdDoituongKcb);
objAssignDetail.MaLuotkham = objchidinh.MaLuotkham;
objAssignDetail.IdBenhnhan = objchidinh.IdBenhnhan;
objAssignDetail.IdKham = objchidinh.IdKham;
objAssignDetail.IdChidinh = Utility.Int32Dbnull(objchidinh.IdChidinh);
// objAssignDetail.IdKham = -1;
objAssignDetail.IpMaytao = globalVariables.gv_strIPAddress;
objAssignDetail.PtramBhyt =
Utility.DecimaltoDbnull(objluotkham.PtramBhyt);
objAssignDetail.IdBacsiThuchien = globalVariables.IdKhoaNhanvien;
// objAssignDetail.IsNew = true;
objAssignDetail.Save();
log.Info(
"Them moi thong tin cua phieu chi dinh chi tiet voi ma phieu Assign_ID=" +
objchidinh.IdChidinh);
}
log.Trace("6. Đã thêm mới chi tiết phiếu chỉ định cho bệnh nhân");
}
else
{
log.Trace("7. Lỗi thêm bệnh nhân vào hệ thống");
return(ActionResult.Error);
}
}
trans.Complete();
log.Trace("8. Thêm bệnh nhân có ID_Benhnhan " + objdanhsachbenhnhan.IdBenhnhan +
" vào hệ thống thành công");
errMsg = @"Thêm mới thành công bệnh nhân";
return(ActionResult.Success);
}
}
catch (Exception ex)
{
errMsg = "Lỗi thêm mới bệnh nhân : " + ex.Message;
log.Error(ex.Message);
return(ActionResult.Error);
}
}
public void Insert(long?IdKham, long?IdBuongGiuong, long?IdDieutri, int?IdKhoadieutri, string MaLuotkham, long IdBenhnhan, DateTime NgayChidinh, short?IdBacsiChidinh, short?IdPhongChidinh, DateTime?NgayThanhtoan, byte TrangthaiThanhtoan, byte?TrangThai, string NguoiTao, DateTime?NgayTao, string NguoiSua, DateTime?NgaySua, byte?TinhtrangIn, string Barcode, byte?Noitru, short?IdKhoaChidinh, string MaKhoaChidinh, string MaChidinh, string MaBenhpham, short?IdDoituongKcb, byte?IdLoaidoituongKcb, string MaDoituongKcb, byte?KieuChidinh, long?IdLichsuDoituongKcb, string MatheBhyt, string IpMaytao, string IpMaysua, string TenMaytao, string TenMaysua, string NguoigiaoMau, string NguoinhanMau, string MotaThem, byte?DaBangiaomau, int?LuongmauHoaly, int?LuongmauVisinh, int?LuongmauGui, byte?LuuMau, string DieukienLuumau, byte?ThanhlyMau, DateTime?NgayThanhly, string NguoiThanhly, string LastActionName)
{
KcbChidinhcl item = new KcbChidinhcl();
item.IdKham = IdKham;
item.IdBuongGiuong = IdBuongGiuong;
item.IdDieutri = IdDieutri;
item.IdKhoadieutri = IdKhoadieutri;
item.MaLuotkham = MaLuotkham;
item.IdBenhnhan = IdBenhnhan;
item.NgayChidinh = NgayChidinh;
item.IdBacsiChidinh = IdBacsiChidinh;
item.IdPhongChidinh = IdPhongChidinh;
item.NgayThanhtoan = NgayThanhtoan;
item.TrangthaiThanhtoan = TrangthaiThanhtoan;
item.TrangThai = TrangThai;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.TinhtrangIn = TinhtrangIn;
item.Barcode = Barcode;
item.Noitru = Noitru;
item.IdKhoaChidinh = IdKhoaChidinh;
item.MaKhoaChidinh = MaKhoaChidinh;
item.MaChidinh = MaChidinh;
item.MaBenhpham = MaBenhpham;
item.IdDoituongKcb = IdDoituongKcb;
item.IdLoaidoituongKcb = IdLoaidoituongKcb;
item.MaDoituongKcb = MaDoituongKcb;
item.KieuChidinh = KieuChidinh;
item.IdLichsuDoituongKcb = IdLichsuDoituongKcb;
item.MatheBhyt = MatheBhyt;
item.IpMaytao = IpMaytao;
item.IpMaysua = IpMaysua;
item.TenMaytao = TenMaytao;
item.TenMaysua = TenMaysua;
item.NguoigiaoMau = NguoigiaoMau;
item.NguoinhanMau = NguoinhanMau;
item.MotaThem = MotaThem;
item.DaBangiaomau = DaBangiaomau;
item.LuongmauHoaly = LuongmauHoaly;
item.LuongmauVisinh = LuongmauVisinh;
item.LuongmauGui = LuongmauGui;
item.LuuMau = LuuMau;
item.DieukienLuumau = DieukienLuumau;
item.ThanhlyMau = ThanhlyMau;
item.NgayThanhly = NgayThanhly;
item.NguoiThanhly = NguoiThanhly;
item.LastActionName = LastActionName;
item.Save(UserName);
}
private void BtnTestTypeClick(object sender, EventArgs e)
{
try
{
int count;
var btn = (UIButton)sender;
var sql =
new Select().From(KcbDanhsachBenhnhan.Schema.Name)
.Where(KcbDanhsachBenhnhan.Columns.Pid)
.IsEqualTo(txtPID.Text.Trim())
.ExecuteSingle<KcbDanhsachBenhnhan>();
patientId = Utility.Int32Dbnull(sql.IdBenhnhan);
idnhomdv = Utility.Int16Dbnull(btn.Tag);
count = KcbChidinhcl.CreateQuery().WHERE(KcbChidinhcl.Columns.IdBenhnhan, patientId).
WHERE(KcbChidinhcl.Columns.IdLoaidichvu, idnhomdv).GetRecordCount();
if (count > 0)
{
//Utility.ShowMsg("Loại Xét Nghiệm đã được đăng ký");
//Todo: focus vào test đã đăng ký
for (int i = 0; i < grdTestInfo.RowCount; i++)
{
string idloaidv = Utility.sDbnull(grdTestInfo.GetRow(i).Cells["id_loaidichvu"].Value);
if ((idloaidv) == (string)btn.Tag)
{
grdTestInfo.MoveTo(i);
dtResultDetail = SPs.DmucLaydanhmucDichvuCLSChitiet(Utility.Int16Dbnull(idloaidv)).GetDataSet().Tables[0];
grdDichVuChiTiet.DataSource = dtResultDetail;
break;
}
}
return;
}
string vBarcode = "";
DataRow drTestType = Utility.GetDataRow(dtTestTypeList, VDmucDichvucl.Columns.IdDichvu, btn.Tag);
{
vBarcode = CommonBussines.GetBarcodeForPatient(patientId, idnhomdv, drTestType[VDmucDichvucl.Columns.SttHthiLoaidvu].ToString());
if (vBarcode == "-1")
{
Utility.ShowMsg("Không tìm được Barcode");
return;
}
}
var obj = new KcbChidinhcl();
obj.IdLoaidichvu = Utility.Int16Dbnull(idnhomdv);
obj.Barcode = vBarcode;
obj.IdBenhnhan = patientId;
obj.NgayTao = DateTime.Now;
obj.NguoiTao = globalVariables.UserName;
obj.Barcode = vBarcode;
obj.IdDoituongKcb = Utility.Int16Dbnull(cbodoituong.SelectedValue);
obj.NgayChidinh = DateTime.Now;
obj.IsNew = true;
obj.Save();
short id = Utility.Int16Dbnull(btn.Tag);
dtResultDetail = SPs.DmucLaydanhmucDichvuCLSChitiet(id).GetDataSet().Tables[0];
grdDichVuChiTiet.DataSource = dtResultDetail;
DataRow dr = dtTestInfo.NewRow();
dr[KcbChidinhcl.Columns.IdChidinh] = KcbChidinhcl.CreateQuery().WHERE(KcbChidinhcl.Columns.IdBenhnhan, patientId).
WHERE(KcbChidinhcl.Columns.IdLoaidichvu, idnhomdv).GetMax(KcbChidinhcl.Columns.IdChidinh);
dr[KcbChidinhcl.Columns.NgayChidinh] = obj.NgayChidinh;
dr[KcbChidinhcl.Columns.Barcode] = obj.Barcode;
dr[KcbChidinhcl.Columns.IdBenhnhan] = obj.IdBenhnhan;
dr[KcbChidinhcl.Columns.IdLoaidichvu] = obj.IdLoaidichvu;
dr[KcbChidinhcl.Columns.NguoiTao] = obj.NguoiSua;
dr[DmucDichvucl.Columns.TenDichvu] = drTestType[DmucDichvucl.Columns.TenDichvu].ToString();
dtTestInfo.Rows.InsertAt(dr, 0);
grdTestInfo.SelectionChanged -= grdTestInfo_SelectionChanged;
dtTestInfo.AcceptChanges();
grdTestInfo.SelectionChanged += grdTestInfo_SelectionChanged;
grdTestInfo.MoveFirst();
grdTestInfo.DataSource = dtTestInfo;
// Todo: xử lý sau khi nhấn nút đăng ký
//Nếu ô đăng ký test có dl thì chuyển sang
//if (flpTestGroup.Controls.Count > 0) flpTestGroup.Focus();
//else flpStandardTest.Focus();
//LoadRegisteredTestType();
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
finally { FocusButtonDetail(); }
}
