/// <summary>
/// hàm thực hiện việc lấy thông tin của dữ liệu
/// </summary>
private void getData()
{
if (objPhieudieutri != null && objPhieudieutri.IdPhieudieutri > 0)
{
if (objPhieudieutri.NgayDieutri == null)
{
objPhieudieutri.NgayDieutri = DateTime.Now;
}
txtTreat_ID.Text = objPhieudieutri.IdPhieudieutri.ToString();
dtNgayLapPhieu.Value = objPhieudieutri.NgayDieutri.Value;
dtGioLapPhieu.Text = objPhieudieutri.GioDieutri;
txtBstheodoi.Text = objPhieudieutri.ThongtinDieutri;
txtDieuduongtheodoi.Text = objPhieudieutri.ThongtinTheodoi;
cboKhoaNoiTru.SelectedIndex = Utility.GetSelectedIndex(cboKhoaNoiTru, objPhieudieutri.IdKhoanoitru.ToString());
chkPhieuBoSung.Checked = Utility.Byte2Bool(objPhieudieutri.TthaiBosung);
cboBacSy.SelectedIndex = Utility.GetSelectedIndex(cboBacSy, objPhieudieutri.IdBacsi.ToString());
if (objBuongGiuong == null)
{
objBuongGiuong = NoitruPhanbuonggiuong.FetchByID(objPhieudieutri.IdBuongGiuong);
}
}
else
{
dtNgayLapPhieu.Value = dtNgayLapPhieu.MaxDate;
dtGioLapPhieu.Value = dtNgayLapPhieu.MaxDate;
}
}
private void txtMaLanKham_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter && Utility.DoTrim(txtMaLanKham.Text) != "")
{
ObjPhanbuonggiuong = null;
string patientCode = Utility.AutoFullPatientCode(txtMaLanKham.Text);
ClearControl();
txtMaLanKham.Text = patientCode;
BindData();
}
}
public static void TinhPhanTramBHYT(NoitruPhanbuonggiuong objNoitruPhanbuonggiuong, KcbLuotkham objLuotkham, decimal PtramBHYT)
{
try
{
decimal BHYT_PTRAM_TRAITUYENNOITRU = Utility.DecimaltoDbnull(THU_VIEN_CHUNG.Laygiatrithamsohethong("BHYT_PTRAM_TRAITUYENNOITRU", "0", false), 0m);
if (Utility.Int32Dbnull(objNoitruPhanbuonggiuong.TrongGoi, 0) == 1)
{
objNoitruPhanbuonggiuong.BhytChitra = 0;// Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia, 0) * PtramBHYT / 100;
objNoitruPhanbuonggiuong.BnhanChitra = 0;
}
else//Ngoài gói
{
if (objNoitruPhanbuonggiuong.TuTuc == 1)
{
objNoitruPhanbuonggiuong.BhytChitra = 0;
objNoitruPhanbuonggiuong.BnhanChitra = Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia, 0);
}
else
{
decimal BHCT = 0m;
if (objLuotkham.DungTuyen == 1)
{
BHCT = Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia, 0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0) / 100);
}
else
{
if (objLuotkham.TrangthaiNoitru <= 0)
{
BHCT = Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.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(objNoitruPhanbuonggiuong.DonGia, 0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0) / 100) * (BHYT_PTRAM_TRAITUYENNOITRU / 100);
}
}
objNoitruPhanbuonggiuong.BhytChitra = BHCT;// Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia, 0) * PtramBHYT / 100;
objNoitruPhanbuonggiuong.BnhanChitra = Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia, 0) -
BHCT;
}
}
//if (Utility.Int32Dbnull(objNoitruPhanbuonggiuong.TuTuc) == 1 && Utility.Int32Dbnull(objNoitruPhanbuonggiuong.TrongGoi) == 1)
//{
// objNoitruPhanbuonggiuong.BnhanChitra = 0;
// objNoitruPhanbuonggiuong.BhytChitra = 0;
//}
}
catch (Exception)
{
// throw;
}
}
private void BindData()
{
SqlQuery sqlQuery = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLanKham.Text);
if (sqlQuery.GetRecordCount() > 0)
{
objPatientExam = sqlQuery.ExecuteSingle<KcbLuotkham>();
if (objPatientExam != null)
{
if (objPhanbuonggiuong == null)
objPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(Utility.Int32Dbnull(objPatientExam.IdRavien, 0));
txtMaLanKham.Text = Utility.sDbnull(objPatientExam.MaLuotkham);
txtSoBHYT.Text = Utility.sDbnull(objPatientExam.MatheBhyt);
DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(objPatientExam.IdKhoanoitru);
if (objLDepartment != null)
{
txtDepartment_ID.Text = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Tag = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Text = Utility.sDbnull(objLDepartment.TenKhoaphong);
txtKhoadieutri.Text = txtDepartmentName.Text;
}
KcbDanhsachBenhnhan objPatientInfo = KcbDanhsachBenhnhan.FetchByID(objPatientExam.IdBenhnhan);
if (objPatientInfo != null)
{
txtPatient_Name.Text = Utility.sDbnull(objPatientInfo.TenBenhnhan);
txtPatient_ID.Text = Utility.sDbnull(objPatientExam.IdBenhnhan);
txtNamSinh.Text = Utility.sDbnull(objPatientInfo.NamSinh);
txtTuoi.Text = Utility.sDbnull(DateTime.Now.Year - objPatientInfo.NamSinh);
txtPatientSex.Text = objPatientInfo.GioiTinh;// Utility.Int32Dbnull(objPatientInfo.) == 0 ? "Nam" : "Nữ";
}
if (objPhanbuonggiuong != null)
{
txtPatientDept_ID.Text = Utility.sDbnull(objPhanbuonggiuong.Id);
}
DataTable dtGia= new dmucgiagiuong_busrule().dsGetList("-1").Tables[0];
dtGia.DefaultView.Sort = NoitruGiabuonggiuong.Columns.SttHthi + "," + NoitruGiabuonggiuong.Columns.TenGia;
txtGia.Init(dtGia, new System.Collections.Generic.List<string>() { NoitruGiabuonggiuong.Columns.IdGia, NoitruGiabuonggiuong.Columns.MaGia, NoitruGiabuonggiuong.Columns.TenGia });
cboGia.DataSource = dtGia;
cboGia.DataMember = NoitruGiabuonggiuong.Columns.IdGia;
cboGia.ValueMember = NoitruGiabuonggiuong.Columns.IdGia;
cboGia.DisplayMember = NoitruGiabuonggiuong.Columns.TenGia;
m_dtDataRoom = THU_VIEN_CHUNG.NoitruTimkiembuongTheokhoa(Utility.Int32Dbnull(txtDepartment_ID.Text));
Utility.SetDataSourceForDataGridEx_Basic(grdBuong, m_dtDataRoom, true, true, "1=1", "sluong_giuong_trong desc,ten_buong");
if (grdBuong.DataSource != null)
{
grdBuong.MoveFirst();
}
}
}
}
private void BindData()
{
SqlQuery sqlQuery = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLanKham.Text);
if (sqlQuery.GetRecordCount() > 0)
{
objLuotkham = sqlQuery.ExecuteSingle <KcbLuotkham>();
if (objLuotkham != null)
{
txtMaLanKham.Text = Utility.sDbnull(objLuotkham.MaLuotkham);
txtSoBHYT.Text = Utility.sDbnull(objLuotkham.MatheBhyt);
DmucKhoaphong objDmucKhoaphong = DmucKhoaphong.FetchByID(objLuotkham.IdKhoanoitru);
if (objDmucKhoaphong != null)
{
txtDepartmentName.Tag = Utility.sDbnull(objDmucKhoaphong.IdKhoaphong);
txtDepartment_ID.Text = Utility.sDbnull(objDmucKhoaphong.IdKhoaphong);
txtDepartmentName.Text = Utility.sDbnull(objDmucKhoaphong.TenKhoaphong);
}
KcbDanhsachBenhnhan objPatientInfo = KcbDanhsachBenhnhan.FetchByID(objLuotkham.IdBenhnhan);
if (objPatientInfo != null)
{
txtPatient_Name.Text = Utility.sDbnull(objPatientInfo.TenBenhnhan);
txtPatient_ID.Text = Utility.sDbnull(objLuotkham.IdBenhnhan);
txtNamSinh.Text = Utility.sDbnull(objPatientInfo.NamSinh);
txtTuoi.Text = Utility.sDbnull(DateTime.Now.Year - objPatientInfo.NamSinh);
txtPatientSex.Text = objPatientInfo.GioiTinh;// Utility.Int32Dbnull(objPatientInfo.PatientSex) == 0 ? "Nam" : "Nữ";
}
objPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(objLuotkham.IdRavien);
dtNgayvao.Value = objPhanbuonggiuong.NgayVaokhoa;
if (objPhanbuonggiuong != null)
{
txtPatientDept_ID.Text = Utility.sDbnull(objPhanbuonggiuong.Id);
NoitruDmucBuong objRoom = NoitruDmucBuong.FetchByID(objPhanbuonggiuong.IdBuong);
if (objRoom != null)
{
txtSoPhong.Text = Utility.sDbnull(objRoom.TenBuong);
txtSoPhong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdBuong);
}
NoitruDmucGiuongbenh objNoitruDmucGiuongbenh = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if (objNoitruDmucGiuongbenh != null)
{
txtSoGiuong.Text = Utility.sDbnull(objNoitruDmucGiuongbenh.TenGiuong);
txtSoGiuong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdGiuong);
}
}
}
}
ModifyCommand();
}
public static void TinhPhanTramBHYT(NoitruPhanbuonggiuong objNoitruPhanbuonggiuong,KcbLuotkham objLuotkham, decimal PtramBHYT)
{
try
{
decimal BHYT_PTRAM_TRAITUYENNOITRU = Utility.DecimaltoDbnull(THU_VIEN_CHUNG.Laygiatrithamsohethong("BHYT_PTRAM_TRAITUYENNOITRU", "0", false), 0m);
if (Utility.Int32Dbnull(objNoitruPhanbuonggiuong.TrongGoi, 0) == 1)
{
objNoitruPhanbuonggiuong.BhytChitra = 0;// Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia, 0) * PtramBHYT / 100;
objNoitruPhanbuonggiuong.BnhanChitra = 0;
}
else//Ngoài gói
{
if (objNoitruPhanbuonggiuong.TuTuc == 1)
{
objNoitruPhanbuonggiuong.BhytChitra = 0;
objNoitruPhanbuonggiuong.BnhanChitra = Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia, 0);
}
else
{
decimal BHCT = 0m;
if (objLuotkham.DungTuyen == 1)
{
BHCT = Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia,0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0) / 100);
}
else
{
if (objLuotkham.TrangthaiNoitru <= 0)
BHCT = Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.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(objNoitruPhanbuonggiuong.DonGia, 0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0) / 100) * (BHYT_PTRAM_TRAITUYENNOITRU / 100);
}
objNoitruPhanbuonggiuong.BhytChitra = BHCT;// Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia, 0) * PtramBHYT / 100;
objNoitruPhanbuonggiuong.BnhanChitra = Utility.DecimaltoDbnull(objNoitruPhanbuonggiuong.DonGia, 0) -
BHCT;
}
}
//if (Utility.Int32Dbnull(objNoitruPhanbuonggiuong.TuTuc) == 1 && Utility.Int32Dbnull(objNoitruPhanbuonggiuong.TrongGoi) == 1)
//{
// objNoitruPhanbuonggiuong.BnhanChitra = 0;
// objNoitruPhanbuonggiuong.BhytChitra = 0;
//}
}
catch (Exception)
{
// throw;
}
}
public ActionResult PhanGiuongDieuTri(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam, DateTime NgayPhanGiuong, short IDPhong, short IDGiuong)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objPhanbuonggiuong != null)
{
new Update(NoitruDmucGiuongbenh.Schema).Set(NoitruDmucGiuongbenh.Columns.DangSudung).EqualTo(1)
.Where(NoitruDmucGiuongbenh.Columns.IdGiuong).IsEqualTo(IDGiuong).Execute();
objPhanbuonggiuong.IsNew = false;
objPhanbuonggiuong.MarkOld();
objPhanbuonggiuong.IsLoaded = true;
objPhanbuonggiuong.NgayPhangiuong = NgayPhanGiuong;
objPhanbuonggiuong.IdBuong = IDPhong;
objPhanbuonggiuong.IdGiuong = IDGiuong;
objPhanbuonggiuong.IdNhanvienPhangiuong = globalVariables.gv_intIDNhanvien;
objPhanbuonggiuong.NguoiPhangiuong = globalVariables.UserName;
objPhanbuonggiuong.NguoiTao = globalVariables.UserName;
objPhanbuonggiuong.NgayTao = globalVariables.SysDate;
objPhanbuonggiuong.TrangThai = 0;
LayThongTinGia(objPhanbuonggiuong, objPatientExam);
objPhanbuonggiuong.Save();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objPhanbuonggiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(objPhanbuonggiuong.IdGiuong)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(objPhanbuonggiuong.IdBuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objPhanbuonggiuong.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
Utility.CatchException(exception);
return(ActionResult.Error);
}
}
/// <summary>
/// hàm thực hiện việc hoạt động lưu lại thông tin
/// </summary>
private void PerformAction()
{
NoitruPhanbuonggiuong objPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(Utility.Int32Dbnull(txtPatientDept_ID.Text));
if (objPhanbuonggiuong != null)
{
if (Utility.AcceptQuestion("Bạn có muốn chuyển Buồng và giường không", "Thông báo", true))
{
var ngaychuyenkhoa = new DateTime(dtNgayChuyen.Value.Year, dtNgayChuyen.Value.Month,
dtNgayChuyen.Value.Day, Utility.Int32Dbnull(txtGio.Text),
Utility.Int32Dbnull(txtPhut.Text), 00);
objPhanbuonggiuong.SoLuong = Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtSoluong.Text));
objPhanbuonggiuong.SoluongGio = Utility.Int32Dbnull(txtTotalHour.Text);
objPhanbuonggiuong.CachtinhSoluong = (byte)(chkAutoCal.Checked ? 0 : 1);
ActionResult actionResult = new noitru_nhapvien().ChuyenGiuongDieuTri(objPhanbuonggiuong,
objLuotkham,
ngaychuyenkhoa,
Utility.Int16Dbnull(
grdBuong.GetValue(NoitruDmucBuong.Columns.IdBuong)),
Utility.Int16Dbnull(
grdGiuong.GetValue(NoitruDmucGiuongbenh.Columns.IdGiuong)), Utility.Int32Dbnull(txtGia.MyID, -1));
switch (actionResult)
{
case ActionResult.Success:
txtPatientDept_ID.Text = Utility.sDbnull(objPhanbuonggiuong.Id);
Utility.SetMsg(lblMsg, "Bạn chuyển Buồng thành công", true);
// Utility.ShowMsg("Bạn chuyển Buồng thành công", "Thông báo", MessageBoxIcon.Information);
if (b_CallParent)
{
ProcessChuyenKhoa();
b_Cancel = false;
Close();
}
else
{
ClearControl();
}
break;
case ActionResult.Error:
Utility.ShowMsg("Lỗi trong quá trình chuyển khoa", "Thông báo", MessageBoxIcon.Error);
break;
}
}
}
}
public static void LayThongTinGia(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam)
{
objPhanbuonggiuong.TuTuc = 0;
SqlQuery sqlQuery = new Select().From <NoitruQheDoituongBuonggiuong>()
.Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(objPhanbuonggiuong.IdGiuong)
.And(NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb).IsEqualTo(objPatientExam.MaDoituongKcb);
NoitruQheDoituongBuonggiuong objRoomBedObjectType = sqlQuery.ExecuteSingle <NoitruQheDoituongBuonggiuong>();
if (objRoomBedObjectType != null)
{
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objRoomBedObjectType.DonGia);
objPhanbuonggiuong.PhuThu = Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objRoomBedObjectType.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objRoomBedObjectType.PhuthuTraituyen);
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
{
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.DonGia);
objPhanbuonggiuong.KieuThue = "GIUONG";
}
}
else
{
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if (objLBed != null)
{
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objLBed.DonGia);
objPhanbuonggiuong.PhuThu = Utility.DecimaltoDbnull(0);
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.KieuThue = "GIUONG";
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.DonGia);
if (!THU_VIEN_CHUNG.IsBaoHiem(objPatientExam.IdLoaidoituongKcb))
{
objPhanbuonggiuong.TuTuc = 0;
}
}
}
objPhanbuonggiuong.TrongGoi = 0; // Utility.ByteDbnull(objPhanbuonggiuong.TrongGoi);
if (objPhanbuonggiuong.IdGiuong > 0 || objPhanbuonggiuong.IdBuong > 0) //Có giường thì mới tính
{
TinhToanPtramBHYT.TinhPhanTramBHYT(objPhanbuonggiuong, objPatientExam, Utility.DecimaltoDbnull(objPatientExam.PtramBhytGoc));
}
}
private NoitruPhanbuonggiuong TaoBuonggiuong()
{
var objPatientDept = new NoitruPhanbuonggiuong();
objPatientDept.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham);
objPatientDept.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan, -1);
objPatientDept.IdKhoanoitru = Utility.Int16Dbnull(txtKhoanoitru.MyID, -1);
objPatientDept.NgayTao = globalVariables.SysDate;
objPatientDept.NgayVaokhoa = dtNgayNhapVien.Value;
objPatientDept.IdKham = id_kham;
objPatientDept.NguoiTao = globalVariables.UserName;
objPatientDept.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objPatientDept.NoiTru = 1;
objPatientDept.TrangthaiThanhtoan = 0;
objPatientDept.TrangThai = 0;
objPatientDept.DuyetBhyt = 0;
objPatientDept.CachtinhSoluong = 0;
objPatientDept.SoluongGio = 0;
return(objPatientDept);
}
public static void LayThongTinGia(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam)
{
objPhanbuonggiuong.TuTuc = 0;
SqlQuery sqlQuery = new Select().From<NoitruQheDoituongBuonggiuong>()
.Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(objPhanbuonggiuong.IdGiuong)
.And(NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb).IsEqualTo(objPatientExam.MaDoituongKcb);
NoitruQheDoituongBuonggiuong objRoomBedObjectType = sqlQuery.ExecuteSingle<NoitruQheDoituongBuonggiuong>();
if (objRoomBedObjectType != null)
{
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objRoomBedObjectType.DonGia);
objPhanbuonggiuong.PhuThu = Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objRoomBedObjectType.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objRoomBedObjectType.PhuthuTraituyen);
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
{
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.DonGia);
objPhanbuonggiuong.KieuThue = "GIUONG";
}
}
else
{
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if (objLBed != null)
{
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objLBed.DonGia);
objPhanbuonggiuong.PhuThu = Utility.DecimaltoDbnull(0);
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.KieuThue = "GIUONG";
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.DonGia);
if (!THU_VIEN_CHUNG.IsBaoHiem( objPatientExam.IdLoaidoituongKcb))
{
objPhanbuonggiuong.TuTuc = 0;
}
}
}
objPhanbuonggiuong.TrongGoi = 0;// Utility.ByteDbnull(objPhanbuonggiuong.TrongGoi);
if (objPhanbuonggiuong.IdGiuong > 0 || objPhanbuonggiuong.IdBuong > 0)//Có giường thì mới tính
TinhToanPtramBHYT.TinhPhanTramBHYT(objPhanbuonggiuong,objPatientExam, Utility.DecimaltoDbnull(objPatientExam.PtramBhytGoc));
}
private void PerformAction()
{
NoitruPhanbuonggiuong objPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(Utility.Int32Dbnull(txtPatientDept_ID.Text));
if (objPhanbuonggiuong != null)
{
if (Utility.AcceptQuestion(string.Format("Bạn có chắc chắn muốn chuyển khoa điều trị từ {0} đến {1} hay không?", txtDepartmentName.Text, txtKhoanoitru.Text), "Thông báo", true))
{
var ngaychuyenkhoa = new DateTime(dtNgayChuyen.Value.Year, dtNgayChuyen.Value.Month,
dtNgayChuyen.Value.Day, Utility.Int32Dbnull(txtGio.Text),
Utility.Int32Dbnull(txtPhut.Text), 00);
objPhanbuonggiuong.SoLuong = Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtSoluong.Text));
objPhanbuonggiuong.SoluongGio = Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtTotalHour.Text));
objPhanbuonggiuong.CachtinhSoluong = (byte)(chkAutoCal.Checked ? 0 : 1);
ActionResult actionResult = new noitru_nhapvien().ChuyenKhoaDieuTri(objPhanbuonggiuong,
objLuotkham,
ngaychuyenkhoa,
Utility.Int16Dbnull(txtKhoanoitru.MyID, -1), -1,
-1);
switch (actionResult)
{
case ActionResult.Success:
txtPatientDept_ID.Text = Utility.sDbnull(objPhanbuonggiuong.Id);
Utility.SetMsg(lblMsg, "Bạn chuyển phòng thành công", true);
if (b_CallParent)
{
b_Cancel = false;
Close();
}
break;
case ActionResult.Error:
Utility.ShowMsg("Lỗi trong quá trình chuyển khoa", "Thông báo", MessageBoxIcon.Error);
break;
}
}
}
}
public bool Destroy(object Id)
{
return(NoitruPhanbuonggiuong.Destroy(Id) == 1);
}
public static bool CapnhatTrangthaiTutuc(NoitruPhanbuonggiuong 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);
}
if (Utility.Int32Dbnull(objDoituong.TrangthaiHuy, -1) == -1)
{
objDoituong.TrangthaiHuy = 0;
}
// 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);
}
else
{
if (b_ExistPtramBHYT)
{
objDoituong.BhytChitra = Utility.DecimaltoDbnull(objDoituong.DonGia) *
Utility.DecimaltoDbnull(objLuotkham.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);
}
}
public ActionResult HuyBenhNhanVaoBuongGuong(NoitruPhanbuonggiuong objPhanbuonggiuong, ref int IdChuyen)
{
IdChuyen = -1;
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objPhanbuonggiuong != null)
{
NoitruPhanbuonggiuongCollection _NoitruPhanbuonggiuong = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.And(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan).ExecuteAsCollection <NoitruPhanbuonggiuongCollection>();
if (_NoitruPhanbuonggiuong.Count == 1)
{
///update thông tin của phòng giường
objPhanbuonggiuong.MarkOld();
objPhanbuonggiuong.IsLoaded = true;
objPhanbuonggiuong.NgaySua = globalVariables.SysDate;
objPhanbuonggiuong.NguoiSua = globalVariables.UserName;
objPhanbuonggiuong.NgayPhangiuong = null;
objPhanbuonggiuong.NguoiPhangiuong = "";
objPhanbuonggiuong.IdNhanvienPhangiuong = -1;
objPhanbuonggiuong.IdBuong = -1;
objPhanbuonggiuong.IdGiuong = -1;
objPhanbuonggiuong.TrangthaiChuyen = 0;
objPhanbuonggiuong.TrangThai = 0;
objPhanbuonggiuong.Save();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objPhanbuonggiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(objPhanbuonggiuong.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(objPhanbuonggiuong.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objPhanbuonggiuong.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
else//Xóa bản ghi phân buồng giường hiện tại. Đưa về bản ghi phân buồng giường trước đó
{
if (PropertyLib._NoitruProperties.Xoakhihuygiuong)
{
IdChuyen = Utility.Int32Dbnull(objPhanbuonggiuong.IdChuyen.Value, -1);
NoitruPhanbuonggiuong _item = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(IdChuyen).ExecuteSingle <NoitruPhanbuonggiuong>();
if (_item != null)
{
new Delete().From(NoitruPhanbuonggiuong.Schema).Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(objPhanbuonggiuong.Id).Execute();
new Update(NoitruPhanbuonggiuong.Schema)
.Set(NoitruPhanbuonggiuong.Columns.TrangThai).EqualTo(0)
.Set(NoitruPhanbuonggiuong.Columns.TrangthaiChuyen).EqualTo(0)
.Set(NoitruPhanbuonggiuong.Columns.NgayKetthuc).EqualTo(null)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(_item.Id).Execute();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(_item.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(_item.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(_item.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(_item.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
}
else//Chỉ hủy giường
{
///update thông tin của phòng giường
objPhanbuonggiuong.MarkOld();
objPhanbuonggiuong.IsLoaded = true;
objPhanbuonggiuong.NgaySua = globalVariables.SysDate;
objPhanbuonggiuong.NguoiSua = globalVariables.UserName;
objPhanbuonggiuong.NgayPhangiuong = null;
objPhanbuonggiuong.NguoiPhangiuong = "";
objPhanbuonggiuong.IdNhanvienPhangiuong = -1;
objPhanbuonggiuong.IdBuong = -1;
objPhanbuonggiuong.IdGiuong = -1;
objPhanbuonggiuong.TrangthaiChuyen = 0;
objPhanbuonggiuong.TrangThai = 0;
objPhanbuonggiuong.Save();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objPhanbuonggiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(objPhanbuonggiuong.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(objPhanbuonggiuong.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objPhanbuonggiuong.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
}
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
Utility.CatchException(exception);
return(ActionResult.Error);
}
}
public ActionResult UpdateBenhnhanCapcuu(SysTrace mytrace, KcbDanhsachBenhnhan objKcbDanhsachBenhnhan, KcbLuotkham objLuotkham, KcbDangkySokham objSoKCB, NoitruPhanbuonggiuong objBuonggiuong, DateTime ngaychuyenkhoa, decimal PtramBhytCu, decimal PtramBhytgoc, ref string Msg)
{
ActionResult _ActionResult = ActionResult.Success;
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
objKcbDanhsachBenhnhan.IsNew = false;
objKcbDanhsachBenhnhan.IsLoaded = true;
objKcbDanhsachBenhnhan.MarkOld();
objKcbDanhsachBenhnhan.Save();
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 = objBuonggiuong.Id;
objLichsuKcb.IdBuong = objBuonggiuong.IdBuong;
objLichsuKcb.IdGiuong = objBuonggiuong.IdGiuong;
objLichsuKcb.IdKhoanoitru = objBuonggiuong.IdKhoanoitru;
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.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 thông tin sổ khám";
}
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();
}
//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;
}
//Nhập viện
if (objBuonggiuong != null)
{
if (objBuonggiuong.Id <= 0)
{
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("Cập nhật BN 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)
{
log.Error("Loi trong qua trinh update thong tin benh nhan {0}", ex);
return ActionResult.Error;
}
}
public ActionResult ChuyenGiuongDieuTri(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam, DateTime NgayChuyenKhoa, short IDPhong, short IDGiuong)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objPhanbuonggiuong != null)
{
///update thông tin của buồng giường cũ
objPhanbuonggiuong.MarkOld();
objPhanbuonggiuong.IsLoaded = true;
objPhanbuonggiuong.NgaySua = globalVariables.SysDate;
objPhanbuonggiuong.NguoiSua = globalVariables.UserName;
objPhanbuonggiuong.NgayKetthuc = NgayChuyenKhoa;
objPhanbuonggiuong.TrangThai = 1;
objPhanbuonggiuong.TrangthaiChuyen = 1;
objPhanbuonggiuong.Save();
new Update(NoitruDmucGiuongbenh.Schema).Set(NoitruDmucGiuongbenh.Columns.DangSudung).EqualTo(0)
.Where(NoitruDmucGiuongbenh.Columns.IdGiuong).IsEqualTo(objPhanbuonggiuong.IdGiuong).Execute();
//NewItem
objPhanbuonggiuong.IdChuyen = (int?)objPhanbuonggiuong.Id;
objPhanbuonggiuong.IdKhoachuyen = objPhanbuonggiuong.IdKhoanoitru;
objPhanbuonggiuong.Id = -1;
objPhanbuonggiuong.NgayVaokhoa = NgayChuyenKhoa.AddMinutes(1);
objPhanbuonggiuong.NgayPhangiuong = NgayChuyenKhoa.AddMinutes(1);
objPhanbuonggiuong.NgayKetthuc = null;
objPhanbuonggiuong.NoiTru = 1;
objPhanbuonggiuong.SoLuong = 0;
objPhanbuonggiuong.TrangThai = 0;
objPhanbuonggiuong.TrangthaiChuyen = 0;
objPhanbuonggiuong.IdBuong = IDPhong;
objPhanbuonggiuong.IdGiuong = IDGiuong;
objPhanbuonggiuong.NguoiPhangiuong = globalVariables.UserName;
objPhanbuonggiuong.IdNhanvienPhangiuong = globalVariables.gv_intIDNhanvien;
objPhanbuonggiuong.NguoiTao = globalVariables.UserName;
objPhanbuonggiuong.NgayTao = globalVariables.SysDate;
LayThongTinGia(objPhanbuonggiuong, objPatientExam);
objPhanbuonggiuong.IsNew = true;
objPhanbuonggiuong.Save();
new Update(NoitruDmucGiuongbenh.Schema).Set(NoitruDmucGiuongbenh.Columns.DangSudung).EqualTo(1)
.Where(NoitruDmucGiuongbenh.Columns.IdGiuong).IsEqualTo(IDGiuong).Execute();
objPatientExam.IdRavien = Utility.Int32Dbnull(objPhanbuonggiuong.Id);
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objPhanbuonggiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(objPhanbuonggiuong.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(objPhanbuonggiuong.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objPhanbuonggiuong.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
Utility.CatchException(exception);
return(ActionResult.Error);
}
}
/// <summary>
/// hàm thực hiện việc làm sách thông tin của bệnh nhân
/// </summary>
private void ClearControl()
{
Utility.SetMsg(lblMsg, "", false);
//tabControl1.SelectedTab = tabControl1.TabPages[0];
objBuonggiuong = null;
objLuotkham = null;
LstNoitruPhanbuonggiuong = new NoitruPhanbuonggiuongCollection();
m_blnHasJustInsert = false;
txtSolankham.Text = "1";
txtTEN_BN.Clear();
txtNamSinh.Clear();
dtpBOD.Value = globalVariables.SysDate;
txtTuoi.Clear();
txtCMT.Clear();
txtDiachi.Clear();
chkChuyenVien.Checked = false;
txtNoichuyenden.SetCode("-1");
if (m_dtDataRoom != null) m_dtDataRoom.Clear();
if (m_dtDatabed != null) m_dtDatabed.Clear();
if (THU_VIEN_CHUNG.IsNgoaiGio())
{
this.Text= "Bệnh nhân đang khám dịch vụ ngoài giờ";
}
ModifyCommand();
AllowTextChanged = false;
XoathongtinBHYT(true);
_MaDoituongKcb = Utility.sDbnull(cboDoituongKCB.SelectedValue);
objDoituongKCB = new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.MaDoituongKcbColumn).IsEqualTo(_MaDoituongKcb).ExecuteSingle<DmucDoituongkcb>();
if (objDoituongKCB == null) return;
_IdDoituongKcb = objDoituongKCB.IdDoituongKcb;
_IdLoaidoituongKcb = objDoituongKCB.IdLoaidoituongKcb;
_TenDoituongKcb = objDoituongKCB.TenDoituongKcb;
PtramBhytCu = objDoituongKCB.PhantramTraituyen.Value;
PtramBhytGocCu = PtramBhytCu;
chkChuyenVien.Checked = false;
AllowTextChanged = true;
//Chuyển về trạng thái thêm mới
m_enAction = action.Insert;
if (PropertyLib._KCBProperties.SexInput) cboPatientSex.SelectedIndex = -1;
m_dataDataRegExam.Clear();
ucBHYT1.ResetMe(objDoituongKCB);
if (ucBHYT1.IsBHYT)
{
}
else
{
PtramBhytCu = objDoituongKCB.PhantramTraituyen.Value;
PtramBhytGocCu = PtramBhytCu;
txtTEN_BN.Focus();
}
if (m_enAction == action.Insert)
{
dtpInputDate.Value = globalVariables.SysDate;
dtCreateDate.Value = globalVariables.SysDate;
}
}
private void CapnhatthongtinBenhnhan()
{
DateTime ngaychuyenkhoa = new DateTime(dtNgayChuyen.Value.Year, dtNgayChuyen.Value.Month,
dtNgayChuyen.Value.Day, Utility.Int32Dbnull(txtGio.Text),
Utility.Int32Dbnull(txtPhut.Text), 00);
objBenhnhan = TaoBenhNhan();
objLuotkham = TaoLuotkham();
objBuonggiuong = TaodulieuBuonggiuong();
KcbDangkySokham objSokham = TaosoKCB();
string msg = "";
errorProvider1.Clear();
ActionResult actionResult = _KCB_DANGKY.UpdateBenhnhanCapcuu(objBenhnhan, objLuotkham, objSokham, objBuonggiuong, ngaychuyenkhoa, PtramBhytCu, PtramBhytGocCu, ref msg);
// THEM_PHI_DVU_KYC(objLuotkham);
if (msg.Trim() != "")
{
errorProvider1.SetError(txtSoKcb, msg);
}
switch (actionResult)
{
case ActionResult.Success:
if (objLuotkham.SoBenhAn!=null && objLuotkham.SoBenhAn != txtSoBenhAn.Text)
{
Utility.ShowMsg(string.Format( "Chú ý: Số bệnh án nội trú {0} đã được Bệnh nhân khác sử dụng nên số bệnh án nội trú mới của Bệnh nhân là {1}",txtSoBenhAn.Text,objLuotkham.SoBenhAn ));
}
txtSoBenhAn.Text=objLuotkham.SoBenhAn;
//gọi lại nếu thay đổi địa chỉ
m_blnHasJustInsert = false;
PtramBhytCu = Utility.DecimaltoDbnull(txtPtramBHYT.Text, 0);
PtramBhytGocCu = Utility.DecimaltoDbnull(txtptramDauthe.Text, 0);
Utility.SetMsg(lblMsg, "Bạn sửa thông tin Bệnh nhân thành công", false);
UpdateBNVaoTrenLuoi();
if (_OnActionSuccess != null) _OnActionSuccess();
if (string.IsNullOrEmpty(objLuotkham.MatheBhyt))
{
dtInsFromDate.Value = globalVariables.SysDate;
dtInsToDate.Value = globalVariables.SysDate;
txtPtramBHYT.Text = "";
txtptramDauthe.Text = "";
txtMaDtuong_BHYT.Clear();
txtMaQuyenloi_BHYT.Clear();
txtNoiDongtrusoKCBBD.Clear();
txtOthu4.Clear();
txtOthu5.Clear();
txtOthu6.Clear();
chkTraiTuyen.Checked = false;
lblTuyenBHYT.Text = chkTraiTuyen.Checked ? "TRÁI TUYẾN" : "ĐÚNG TUYẾN";
chkChuyenVien.Checked = false;
txtNoiphattheBHYT.Clear();
txtNoiDKKCBBD.Clear();
}
Utility.GotoNewRowJanus(grdList, KcbLuotkham.Columns.MaLuotkham, txtMaLankham.Text);
m_blnCancel = false;
break;
case ActionResult.Error:
Utility.SetMsg(lblMsg, "Bạn thực hiện sửa thông tin không thành công !", true);
break;
case ActionResult.Cancel:
Utility.ShowMsg(string.Format( "Bệnh nhân này đã thanh toán một số dịch vụ nên bạn không được phép chuyển đối tượng hoặc thay đổi phần trăm BHYT\nPhần trăm cũ {0} % - Phần trăm mới {1} %",PtramBhytCu.ToString(),txtPtramBHYT.Text),"Cảnh báo");
break;
}
}
/// <summary>
/// hàm thực hiện việc lấy thông tin của dữ liệu
/// </summary>
private void getData()
{
if (objPhieudieutri != null && objPhieudieutri.IdPhieudieutri>0)
{
if (objPhieudieutri.NgayDieutri == null) objPhieudieutri.NgayDieutri = DateTime.Now;
txtTreat_ID.Text = objPhieudieutri.IdPhieudieutri.ToString();
dtNgayLapPhieu.Value = objPhieudieutri.NgayDieutri.Value;
dtGioLapPhieu.Text = objPhieudieutri.GioDieutri;
txtBstheodoi.Text = objPhieudieutri.ThongtinDieutri;
txtDieuduongtheodoi.Text = objPhieudieutri.ThongtinTheodoi;
cboKhoaNoiTru.SelectedIndex = Utility.GetSelectedIndex(cboKhoaNoiTru, objPhieudieutri.IdKhoanoitru.ToString());
chkPhieuBoSung.Checked = Utility.Byte2Bool(objPhieudieutri.TthaiBosung);
cboBacSy.SelectedIndex = Utility.GetSelectedIndex(cboBacSy, objPhieudieutri.IdBacsi.ToString());
if (objBuongGiuong == null)
objBuongGiuong = NoitruPhanbuonggiuong.FetchByID(objPhieudieutri.IdBuongGiuong);
}
else
{
dtNgayLapPhieu.Value = dtNgayLapPhieu.MaxDate;
dtGioLapPhieu.Value = dtNgayLapPhieu.MaxDate;
}
}
private void BindData()
{
SqlQuery sqlQuery = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLanKham.Text);
if (sqlQuery.GetRecordCount() > 0)
{
_objPatientExam = sqlQuery.ExecuteSingle <KcbLuotkham>();
if (_objPatientExam != null)
{
if (ObjPhanbuonggiuong == null)
{
ObjPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(Utility.Int32Dbnull(_objPatientExam.IdRavien, 0));
}
txtMaLanKham.Text = Utility.sDbnull(_objPatientExam.MaLuotkham);
txtSoBHYT.Text = string.Format("{0}-{1}{2}", Utility.sDbnull(_objPatientExam.MatheBhyt),
Utility.sDbnull(_objPatientExam.MaNoicapBhyt), Utility.sDbnull(_objPatientExam.MaKcbbd));
txtphantramhuong.Text = Utility.sDbnull(_objPatientExam.PtramBhyt);
DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(_objPatientExam.IdKhoanoitru);
if (objLDepartment != null)
{
txtDepartment_ID.Text = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Tag = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Text = Utility.sDbnull(objLDepartment.TenKhoaphong);
txtKhoadieutri.Text = txtDepartmentName.Text;
}
KcbDanhsachBenhnhan objPatientInfo = KcbDanhsachBenhnhan.FetchByID(_objPatientExam.IdBenhnhan);
if (objPatientInfo != null)
{
txtPatient_Name.Text = Utility.sDbnull(objPatientInfo.TenBenhnhan);
txtPatient_ID.Text = Utility.sDbnull(_objPatientExam.IdBenhnhan);
txtNamSinh.Text = Utility.sDbnull(objPatientInfo.NamSinh);
txtTuoi.Text = Utility.sDbnull(DateTime.Now.Year - objPatientInfo.NamSinh);
txtPatientSex.Text = objPatientInfo.GioiTinh;
// Utility.Int32Dbnull(objPatientInfo.) == 0 ? "Nam" : "Nữ";
}
if (ObjPhanbuonggiuong != null)
{
txtPatientDept_ID.Text = Utility.sDbnull(ObjPhanbuonggiuong.Id);
txtsoluongghep.Text = Utility.sDbnull(ObjPhanbuonggiuong.SoLuongGhep);
chkGhepgiuong.Checked = Utility.Byte2Bool(ObjPhanbuonggiuong.IsGhepGiuong);
}
DataTable dtGia = new dmucgiagiuong_busrule().dsGetList("-1").Tables[0];
dtGia.DefaultView.Sort = NoitruGiabuonggiuong.Columns.SttHthi + "," +
NoitruGiabuonggiuong.Columns.TenGia;
txtGia.Init(dtGia,
new List <string>
{
NoitruGiabuonggiuong.Columns.IdGia,
NoitruGiabuonggiuong.Columns.MaGia,
NoitruGiabuonggiuong.Columns.TenGia
});
cboGia.DataSource = dtGia;
cboGia.DataMember = NoitruGiabuonggiuong.Columns.IdGia;
cboGia.ValueMember = NoitruGiabuonggiuong.Columns.IdGia;
cboGia.DisplayMember = NoitruGiabuonggiuong.Columns.TenGia;
_mDtDataRoom = THU_VIEN_CHUNG.NoitruTimkiembuongTheokhoa(Utility.Int32Dbnull(txtDepartment_ID.Text));
Utility.SetDataSourceForDataGridEx_Basic(grdBuong, _mDtDataRoom, true, true, "1=1",
"sluong_giuong_trong desc,ten_buong");
txtRoom_code.Init(_mDtDataRoom,
new List <string>
{
NoitruDmucBuong.Columns.IdBuong,
NoitruDmucBuong.Columns.MaBuong,
NoitruDmucBuong.Columns.TenBuong
});
if (grdBuong.DataSource != null)
{
grdBuong.MoveFirst();
}
}
else
{
string tempt = txtMaLanKham.Text;
ClearControl();
if (_mDtDataRoom != null)
{
_mDtDataRoom.Clear();
}
if (_mDtDatabed != null)
{
if (_mDtDataRoom != null)
{
_mDtDataRoom.Clear();
}
}
txtMaLanKham.Text = tempt;
txtMaLanKham.SelectAll();
txtMaLanKham.Focus();
}
}
}
private void LoadThongtinBenhnhan()
{
PtramBhytCu = 0m;
PtramBhytGocCu = 0m;
AllowTextChanged = false;
LstNoitruPhanbuonggiuong = new NoitruPhanbuonggiuongCollection();
objBuonggiuong = null;
objBenhnhan = KcbDanhsachBenhnhan.FetchByID(txtMaBN.Text);
if (objBenhnhan != null)
{
txtTEN_BN.Text = Utility.sDbnull(objBenhnhan.TenBenhnhan);
txtNamSinh.Text = Utility.sDbnull(objBenhnhan.NamSinh);
txtDiachi.Text = Utility.sDbnull(objBenhnhan.DiaChi);
if (objBenhnhan.NgaySinh != null) dtpBOD.Value = objBenhnhan.NgaySinh.Value;
else dtpBOD.Value = new DateTime((int)objBenhnhan.NamSinh, 1, 1);
txtNamSinh.Text = Utility.sDbnull(objBenhnhan.NamSinh);
txtTuoi.Text = Utility.sDbnull(globalVariables.SysDate.Year - Utility.Int32Dbnull(objBenhnhan.NamSinh));
cboPatientSex.SelectedIndex = Utility.GetSelectedIndex(cboPatientSex, Utility.sDbnull(objBenhnhan.IdGioitinh));
txtCMT.Text = Utility.sDbnull(objBenhnhan.Cmt);
objLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLankham.Text)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(Utility.Int32Dbnull(txtMaBN.Text, -1)).ExecuteSingle
<KcbLuotkham>();
if (objLuotkham != null)
{
lstIDDelete = new List<long>();
m_strMaluotkham = objLuotkham.MaLuotkham;
txtSolankham.Text = Utility.sDbnull(objLuotkham.SolanKham);
_IdDoituongKcb = objLuotkham.IdDoituongKcb;
dtpInputDate.Value = objLuotkham.NgayTiepdon;
dtCreateDate.Value = objLuotkham.NgayTiepdon;
_MaDoituongKcb = Utility.sDbnull(objLuotkham.MaDoituongKcb);
objDoituongKCB = new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.MaDoituongKcbColumn).IsEqualTo(_MaDoituongKcb).ExecuteSingle<DmucDoituongkcb>();
ChangeObjectRegion();
PtramBhytCu = Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0);
PtramBhytGocCu = Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0);
_IdDoituongKcb = objDoituongKCB.IdDoituongKcb;
_TenDoituongKcb = objDoituongKCB.TenDoituongKcb;
cboDoituongKCB.SelectedIndex = Utility.GetSelectedIndex(cboDoituongKCB, _MaDoituongKcb);
chkChuyenVien.Checked = Utility.Int32Dbnull(objLuotkham.TthaiChuyenden, 0) == 1;
txtNoichuyenden.SetId(Utility.Int32Dbnull(objLuotkham.IdBenhvienDen, -1));
if (!string.IsNullOrEmpty(objLuotkham.MatheBhyt))//Thông tin BHYT
{
ucBHYT1.SetValues(chkChuyenVien.Checked, objDoituongKCB, objLuotkham);
}
else
{
XoathongtinBHYT(true);
}
m_dtData = SPs.KcbLaythongtinLichsuDoituongKcb(objLuotkham.IdBenhnhan, objLuotkham.MaLuotkham).GetDataSet().Tables[0];
ProcessData();
Utility.SetDataSourceForDataGridEx(grdList, m_dtData, true, true, "1=1", " fromdate desc,enddate desc");
AllowGridSelecttionChanged = true;
Utility.GotoNewRowJanus(grdList, KcbLichsuDoituongKcb.Columns.IdLichsuDoituongKcb, objLuotkham.IdLichsuDoituongKcb.ToString());
}
else
{
}
}
chkChuyenVien_CheckedChanged(chkChuyenVien, new EventArgs());
}
public void Insert(long IdBenhnhan, int?IdKhoachuyen, short?TrangthaiChuyen, short IdKhoanoitru, string MaLuotkham, short?IdBuong, short?IdGiuong, byte?KieuGiuong, byte TrangThai, DateTime NgayVaokhoa, DateTime?NgayKetthuc, short?IdBacsiChidinh, byte?NguonThanhtoan, string NguoiTao, DateTime NgayTao, string NguoiSua, DateTime?NgaySua, int?TrangthaiHuy, DateTime?NgayThanhtoan, int?TrangthaiThanhtoan, int?DuyetBhyt, int?NoiTru, decimal?SoLuong, int?IdGia, decimal?DonGia, int?TuTuc, int?IdThanhtoan, int?IdKhoaRavien, int?TrangthaiRavien, decimal?BhytChitra, decimal?BnhanChitra, int?IdGoi, int?TrongGoi, int?IdNhanvienPhangiuong, DateTime?NgayPhangiuong, string NguoiPhangiuong, decimal?PhuThu, int?TrangthaiXacnhan, string TenHienthi, decimal?GiaGoc, int?IdKham, int?IdBenhLy, int?IdLoaiBg, string KieuThue, decimal?PhuThuNgoaigoi, int?IdChuyen, int?Stt, byte?CachtinhSoluong, byte?CachtinhGia, int?SoluongGio, byte?TrangthaiChotkhoa, byte?KhoatonghopChot, long?IdLichsuDoituongKcb, string MatheBhyt, byte?IsGhepGiuong, decimal?SoLuongGhep)
{
NoitruPhanbuonggiuong item = new NoitruPhanbuonggiuong();
item.IdBenhnhan = IdBenhnhan;
item.IdKhoachuyen = IdKhoachuyen;
item.TrangthaiChuyen = TrangthaiChuyen;
item.IdKhoanoitru = IdKhoanoitru;
item.MaLuotkham = MaLuotkham;
item.IdBuong = IdBuong;
item.IdGiuong = IdGiuong;
item.KieuGiuong = KieuGiuong;
item.TrangThai = TrangThai;
item.NgayVaokhoa = NgayVaokhoa;
item.NgayKetthuc = NgayKetthuc;
item.IdBacsiChidinh = IdBacsiChidinh;
item.NguonThanhtoan = NguonThanhtoan;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.TrangthaiHuy = TrangthaiHuy;
item.NgayThanhtoan = NgayThanhtoan;
item.TrangthaiThanhtoan = TrangthaiThanhtoan;
item.DuyetBhyt = DuyetBhyt;
item.NoiTru = NoiTru;
item.SoLuong = SoLuong;
item.IdGia = IdGia;
item.DonGia = DonGia;
item.TuTuc = TuTuc;
item.IdThanhtoan = IdThanhtoan;
item.IdKhoaRavien = IdKhoaRavien;
item.TrangthaiRavien = TrangthaiRavien;
item.BhytChitra = BhytChitra;
item.BnhanChitra = BnhanChitra;
item.IdGoi = IdGoi;
item.TrongGoi = TrongGoi;
item.IdNhanvienPhangiuong = IdNhanvienPhangiuong;
item.NgayPhangiuong = NgayPhangiuong;
item.NguoiPhangiuong = NguoiPhangiuong;
item.PhuThu = PhuThu;
item.TrangthaiXacnhan = TrangthaiXacnhan;
item.TenHienthi = TenHienthi;
item.GiaGoc = GiaGoc;
item.IdKham = IdKham;
item.IdBenhLy = IdBenhLy;
item.IdLoaiBg = IdLoaiBg;
item.KieuThue = KieuThue;
item.PhuThuNgoaigoi = PhuThuNgoaigoi;
item.IdChuyen = IdChuyen;
item.Stt = Stt;
item.CachtinhSoluong = CachtinhSoluong;
item.CachtinhGia = CachtinhGia;
item.SoluongGio = SoluongGio;
item.TrangthaiChotkhoa = TrangthaiChotkhoa;
item.KhoatonghopChot = KhoatonghopChot;
item.IdLichsuDoituongKcb = IdLichsuDoituongKcb;
item.MatheBhyt = MatheBhyt;
item.IsGhepGiuong = IsGhepGiuong;
item.SoLuongGhep = SoLuongGhep;
item.Save(UserName);
}
private NoitruPhanbuonggiuong TaodulieuBuonggiuong()
{
NoitruPhanbuonggiuong objPhanbuonggiuong = null;
if (objBuonggiuong != null)
objPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(objBuonggiuong.Id);
else
objPhanbuonggiuong = new NoitruPhanbuonggiuong();
objPhanbuonggiuong.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham);
objPhanbuonggiuong.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan, -1);
objPhanbuonggiuong.IdKhoanoitru = Utility.Int16Dbnull(txtKhoanoitru.MyID, -1);
objPhanbuonggiuong.NgayTao = globalVariables.SysDate;
objPhanbuonggiuong.NgayVaokhoa = new DateTime(dtNgayChuyen.Value.Year, dtNgayChuyen.Value.Month,
dtNgayChuyen.Value.Day, Utility.Int32Dbnull(txtGio.Text),
Utility.Int32Dbnull(txtPhut.Text), 00);
objPhanbuonggiuong.IdKham = -1;
objPhanbuonggiuong.NguoiTao = globalVariables.UserName;
objPhanbuonggiuong.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objPhanbuonggiuong.NoiTru = 1;
objPhanbuonggiuong.TrangthaiThanhtoan = 0;
objPhanbuonggiuong.TrangThai = 0;
objPhanbuonggiuong.DuyetBhyt = 0;
objPhanbuonggiuong.CachtinhSoluong = 0;
objPhanbuonggiuong.SoluongGio = 0;
objPhanbuonggiuong.IdBuong = Utility.Int16Dbnull(txtRoom_code.MyID,-1);
objPhanbuonggiuong.IdGiuong = Utility.Int16Dbnull(txtBedCode.MyID,-1);
objPhanbuonggiuong.IdGia = Utility.Int32Dbnull(txtGia.MyID, -1);
return objPhanbuonggiuong;
}
void GetNoitruPhanbuonggiuong()
{
objNoitruPhanbuonggiuong = null;
if (!Utility.isValidGrid(grdBuongGiuong))
{
txtKhoanoitru_lapphieu.Clear();
txtBuong_lapphieu.Clear();
txtGiuong_lapphieu.Clear();
return;
}
objNoitruPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(Utility.Int32Dbnull(Utility.getValueOfGridCell(grdBuongGiuong, NoitruPhanbuonggiuong.Columns.Id.ToString()), 0));
txtKhoanoitru_lapphieu.Text = Utility.GetValueFromGridColumn(grdBuongGiuong, "ten_khoanoitru");
txtBuong_lapphieu.Text = Utility.GetValueFromGridColumn(grdBuongGiuong, "ten_buong");
txtGiuong_lapphieu.Text = Utility.GetValueFromGridColumn(grdBuongGiuong, "ten_giuong");
}
private void ThemLanKham()
{
DateTime ngaychuyenkhoa = new DateTime(dtNgayChuyen.Value.Year, dtNgayChuyen.Value.Month,
dtNgayChuyen.Value.Day, Utility.Int32Dbnull(txtGio.Text),
Utility.Int32Dbnull(txtPhut.Text), 00);
objBenhnhan = TaoBenhNhan();
objLuotkham = TaoLuotkham();
objBuonggiuong = TaodulieuBuonggiuong();
KcbDangkySokham objSokham = TaosoKCB();
long v_id_kham = -1;
string msg = "";
errorProvider1.Clear();
ActionResult actionResult = _KCB_DANGKY.ThemmoiLuotkhamCapcuu(objBenhnhan, objLuotkham, objSokham, objBuonggiuong, ngaychuyenkhoa, ref msg);
if (msg.Trim() != "")
{
errorProvider1.SetError(txtSoKcb, msg);
}
switch (actionResult)
{
case ActionResult.Success:
if (objLuotkham.SoBenhAn!=null && objLuotkham.SoBenhAn != txtSoBenhAn.Text)
{
Utility.ShowMsg(string.Format( "Chú ý: Số bệnh án nội trú {0} đã được Bệnh nhân khác sử dụng nên số bệnh án nội trú mới của Bệnh nhân là {1}",txtSoBenhAn.Text,objLuotkham.SoBenhAn ));
}
txtSoBenhAn.Text = objLuotkham.SoBenhAn;
PtramBhytCu = Utility.DecimaltoDbnull(txtPtramBHYT.Text, 0);
PtramBhytGocCu = Utility.DecimaltoDbnull(txtptramDauthe.Text, 0);
txtMaLankham.Text = Utility.sDbnull(objLuotkham.MaLuotkham);
txtMaBN.Text = Utility.sDbnull(objLuotkham.IdBenhnhan);
m_blnHasJustInsert = true;
m_enAction = action.Update;
Utility.SetMsg(lblMsg, "Bạn thêm mới lần khám bệnh nhân thành công", false);
ThemMoiLanKhamVaoLuoi();
if (_OnActionSuccess != null) _OnActionSuccess();
Utility.GotoNewRowJanus(grdList, KcbLuotkham.Columns.MaLuotkham, txtMaLankham.Text);
if (chkTudongthemmoi.Checked)
cmdThemMoiBN_Click(cmdThemMoiBN, new EventArgs());
else
{
ucTamung1.ChangePatients(objLuotkham, "LYDOTAMUNGCAPCUU");
tabControl1.SelectedTab = tabControl1.TabPages[1];
ucTamung1.Themmoi();
}
m_blnCancel = false;
break;
case ActionResult.Error:
Utility.SetMsg(lblMsg, "Lỗi trong quá trình thêm lần khám !", true);
cmdSave.Focus();
break;
}
}
private void cmdChuyen_Click(object sender, EventArgs e)
{
Utility.SetMsg(lblMsg, "", false);
if (Utility.DoTrim(txtGioRaVien.Text) == "")
{
Utility.SetMsg(lblMsg, "Bạn phải nhập thông tin giờ ra viện", true);
txtGioRaVien.Focus();
return;
}
if (Utility.Int32Dbnull(txtGioRaVien.Text, 0) >= 24)
{
Utility.SetMsg(lblMsg, "Giờ ra viện nằm trong khoảng giá trị từ 0 đến 23", true);
txtGioRaVien.Focus();
return;
}
if (Utility.DoTrim(txtPhuRaVien.Text) == "")
{
Utility.SetMsg(lblMsg, "Bạn phải nhập thông tin phút ra viện", true);
txtPhuRaVien.Focus();
return;
}
if (Utility.Int32Dbnull(txtPhuRaVien.Text, 0) >= 60)
{
Utility.SetMsg(lblMsg, "Phút ra viện nằm trong khoảng giá trị từ 0 đến 59", true);
txtPhuRaVien.Focus();
return;
}
if (Utility.DoTrim(txtSoRaVien.Text) == "")
{
Utility.SetMsg(lblMsg, "Bạn phải nhập thông tin số phiếu ra viện", true);
txtSoRaVien.Focus();
return;
}
if (chkChuyenvien.Checked)
{
if (txtNoichuyenden.MyCode == "-1")
{
Utility.SetMsg(lblMsg, "Bạn phải nhập thông tin nơi chuyển đến", true);
txtNoichuyenden.Focus();
return;
}
}
//if (txtKqdieutri.MyCode == "-1")
//{
// Utility.SetMsg(lblMsg, "Bạn phải nhập thông tin kết quả điều trị", true);
// txtKqdieutri.Focus();
// return;
//}
//if (txtTinhtrangravien.MyCode == "-1")
//{
// Utility.SetMsg(lblMsg, "Bạn phải nhập thông tin tình trạng ra viện", true);
// txtTinhtrangravien.Focus();
// return;
//}
//if (Utility.DoTrim(txtLoidanBS.Text) == "")
//{
// Utility.SetMsg(lblMsg, "Bạn phải nhập thông tin lời dặn bác sĩ", true);
// txtLoidanBS.Focus();
// return;
//}
try
{
if (m_enAct == action.Insert)
{
objRavien = new NoitruPhieuravien();
objRavien.IsNew = true;
}
else
{
objRavien = NoitruPhieuravien.FetchByID(Utility.Int32Dbnull(txtId.Text));
objRavien.IsNew = false;
objRavien.MarkOld();
}
objRavien.NgayRavien = new DateTime(dtpNgayravien.Value.Year, dtpNgayravien.Value.Month,
dtpNgayravien.Value.Day, Utility.Int32Dbnull(txtGioRaVien.Text, 0),
Utility.Int32Dbnull(txtPhuRaVien.Text, 0), 0);
objRavien.SophieuRavien = Utility.DoTrim(txtSoRaVien.Text);
objRavien.TongsongayDieutri = Utility.Int32Dbnull(txtTongSoNgayDtri.Text);
objRavien.MabenhChinh = txtBenhchinh.MyCode;
objRavien.MotaBenhchinh = txtBenhchinh.Text;
objRavien.IdBenhnhan = objLuotkham.IdBenhnhan;
objRavien.MaLuotkham = objLuotkham.MaLuotkham;
objRavien.SoBenhAn = Utility.Int32Dbnull(objLuotkham.SoBenhAn, -1);
objRavien.IdKhoaravien = globalVariables.idKhoatheoMay;
objRavien.IdKhoanoitru = objLuotkham.IdKhoanoitru;
objRavien.TrangThai = 0;
objRavien.MabenhGiaiphau = txtBenhgiaiphau.MyCode;
objRavien.MabenhBienchung = txtBenhbienchung.MyCode;
objRavien.MabenhNguyennhan = txtBenhnguyennhan.MyCode;
objRavien.MaKquaDieutri = txtKqdieutri.MyCode;
objRavien.MaKieuchuyenvien = txtKieuchuyenvien.MyCode;
objRavien.MaTinhtrangravien = txtTinhtrangravien.MyCode;
objRavien.IdBacsiChuyenvien = Utility.Int16Dbnull(cboDoctorAssign.SelectedValue, -1);
objRavien.PhuongphapDieutri = Utility.DoTrim(txtPhuongphapdieutri.Text);
objRavien.TrangthaiChuyenvien = Utility.Bool2byte(chkChuyenvien.Checked);
objRavien.IdBenhvienDi = Utility.Int16Dbnull(txtNoichuyenden.MyID, -1);
objRavien.LoidanBacsi = Utility.DoTrim(txtLoidanBS.Text);
objRavien.YkienDexuat = Utility.DoTrim(txtYkien.Text);
objRavien.PhuhopChandoanlamsang = Utility.Bool2byte(chkPhuHopChanDoanCLS.Checked);
objRavien.NgayCapgiayravien = dtNGAY_CAP_GIAY_RVIEN.Value;
KcbPhieuchuyenvien _phieuchuyenvien = null;
if (chkChuyenvien.Checked)
{
_phieuchuyenvien = new Select().From(KcbPhieuchuyenvien.Schema)
.Where(KcbPhieuchuyenvien.Columns.IdBenhnhan).IsEqualTo(txtIdBn.Text)
.And(KcbPhieuchuyenvien.Columns.MaLuotkham).IsEqualTo(txtMaluotkham.Text)
.And(KcbPhieuchuyenvien.Columns.NoiTru).IsEqualTo(1)
.ExecuteSingle <KcbPhieuchuyenvien>();
if (_phieuchuyenvien == null)
{
_phieuchuyenvien = new KcbPhieuchuyenvien();
_phieuchuyenvien.IsNew = true;
}
else
{
_phieuchuyenvien.IsNew = false;
_phieuchuyenvien.MarkOld();
}
_phieuchuyenvien.IdBenhnhan = objLuotkham.IdBenhnhan;
_phieuchuyenvien.MaLuotkham = objLuotkham.MaLuotkham;
_phieuchuyenvien.IdBenhvienChuyenden = Utility.Int16Dbnull(txtNoichuyenden.MyID, -1);
_phieuchuyenvien.DauhieuCls = Utility.DoTrim(txtTinhtrangravien.Text);
_phieuchuyenvien.KetquaXnCls = "";
_phieuchuyenvien.ChanDoan = "";
_phieuchuyenvien.NgayChuyenvien = objRavien.NgayRavien;
_phieuchuyenvien.IdBacsiChuyenvien = objRavien.IdBacsiChuyenvien;
_phieuchuyenvien.ThuocSudung = "";
_phieuchuyenvien.TrangthaiBenhnhan = Utility.DoTrim(txtKqdieutri.Text);
_phieuchuyenvien.HuongDieutri = Utility.DoTrim(txtPhuongphapdieutri.Text);
_phieuchuyenvien.PhuongtienChuyen = Utility.DoTrim(txtphuongtienvc.Text);
_phieuchuyenvien.TenNguoichuyen = Utility.DoTrim(txtNguoivanchuyen.Text);
_phieuchuyenvien.IdRavien = Utility.Int32Dbnull(txtIdravien.Text, -1);
_phieuchuyenvien.IdKhoanoitru = Utility.Int32Dbnull(txtIdkhoanoitru.Text, -1);
_phieuchuyenvien.IdBuong = Utility.Int32Dbnull(txtidBuong.Text, -1);
_phieuchuyenvien.IdGiuong = Utility.Int32Dbnull(txtidgiuong.Text, -1);
}
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
objRavien.Save();
if (_phieuchuyenvien != null)
{
_phieuchuyenvien.Save();
objLuotkham.TthaiChuyendi = 1;
objLuotkham.IdBacsiChuyenvien = _phieuchuyenvien.IdBacsiChuyenvien;
objLuotkham.NgayRavien = objRavien.NgayRavien;
objLuotkham.IdBenhvienDi = Utility.Int16Dbnull(txtNoichuyenden.MyID, -1);
}
objLuotkham.NgayRavien = objRavien.NgayRavien;
objLuotkham.IdRavien = objRavien.IdRavien;
objLuotkham.SoRavien = Utility.sDbnull(objRavien.IdRavien);
objLuotkham.TrangthaiNoitru = 3;
objLuotkham.IsNew = false;
objLuotkham.MarkOld();
objLuotkham.Save();
NoitruPhanbuonggiuong objNoitruPhanbuonggiuong =
NoitruPhanbuonggiuong.FetchByID(objLuotkham.IdRavien.Value);
if (objNoitruPhanbuonggiuong != null)
{
objNoitruPhanbuonggiuong.MarkOld();
objNoitruPhanbuonggiuong.IsNew = false;
objNoitruPhanbuonggiuong.NgayKetthuc = objRavien.NgayRavien;
objNoitruPhanbuonggiuong.CachtinhSoluong = 0;
objNoitruPhanbuonggiuong.SoluongGio =
(int)
Math.Ceiling(
(objNoitruPhanbuonggiuong.NgayKetthuc.Value -
objNoitruPhanbuonggiuong.NgayVaokhoa).TotalHours);
objNoitruPhanbuonggiuong.SoLuong =
THU_VIEN_CHUNG.Songay(objNoitruPhanbuonggiuong.NgayKetthuc.Value,
objNoitruPhanbuonggiuong.NgayVaokhoa);
objNoitruPhanbuonggiuong.Save();
}
}
scope.Complete();
}
mv_blnCancel = false;
Utility.SetMsg(lblMsg,
m_enAct == action.Insert ? "Thêm mới phiếu ra viện thành công" : "Cập nhật phiếu ra viện thành công",
false);
if (m_enAct == action.Insert)
{
cmdPrint.Enabled = true;
}
cmdHuy.Enabled = objRavien != null && objLuotkham != null && objLuotkham.TrangthaiNoitru <= 3;
m_enAct = action.Update;
txtId.Text = objRavien.IdRavien.ToString();
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
/// <summary>
/// hàm thực hiện việc làm sách thông tin của bệnh nhân
/// </summary>
private void ClearControl()
{
Utility.SetMsg(lblMsg, "", false);
objBuonggiuong = null;
objLuotkham = null;
LstNoitruPhanbuonggiuong = new NoitruPhanbuonggiuongCollection();
m_blnHasJustInsert = false;
txtSolankham.Text = "1";
txtTEN_BN.Clear();
txtNamSinh.Clear();
dtpBOD.Value = globalVariables.SysDate;
txtTuoi.Clear();
txtCMT.Clear();
txtNgheNghiep.Clear();
txtDiachi.Clear();
txtDantoc.Clear();
txtTrieuChungBD.Clear();
txtSoDT.Clear();
chkChuyenVien.Checked = false;
txtNoichuyenden.SetCode("-1");
txtKhoanoitru.SetCode("-1");
txtGia.SetCode("-1");
txtRoom_code.SetCode("-1");
txtBedCode.SetCode("-1");
if (m_dtDataRoom != null) m_dtDataRoom.Clear();
if (m_dtDatabed != null) m_dtDatabed.Clear();
if (THU_VIEN_CHUNG.IsNgoaiGio())
{
this.Text= "Bệnh nhân đang khám dịch vụ ngoài giờ";
}
ModifyCommand();
AllowTextChanged = false;
XoathongtinBHYT(true);
_MaDoituongKcb = Utility.sDbnull(cboDoituongKCB.SelectedValue);
objDoituongKCB = new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.MaDoituongKcbColumn).IsEqualTo(_MaDoituongKcb).ExecuteSingle<DmucDoituongkcb>();
if (objDoituongKCB == null) return;
_IdDoituongKcb = objDoituongKCB.IdDoituongKcb;
_IdLoaidoituongKcb = objDoituongKCB.IdLoaidoituongKcb;
_TenDoituongKcb = objDoituongKCB.TenDoituongKcb;
PtramBhytCu = objDoituongKCB.PhantramTraituyen.Value;
PtramBhytGocCu = PtramBhytCu;
txtPtramBHYT.Text = objDoituongKCB.PhantramTraituyen.ToString();
txtptramDauthe.Text = objDoituongKCB.PhantramTraituyen.ToString();
if (objDoituongKCB.IdLoaidoituongKcb == 0)//ĐỐi tượng BHYT
{
pnlBHYT.Enabled = true;
lblPtram.Text = "Phần trăm BHYT";
TinhPtramBHYT();
txtMaDtuong_BHYT.SelectAll();
txtMaDtuong_BHYT.Focus();
}
else//Đối tượng khác BHYT
{
pnlBHYT.Enabled = false;
lblPtram.Text = "P.trăm giảm giá";
txtTEN_BN.Focus();
}
chkTraiTuyen.Checked = false;
lblTuyenBHYT.Text = chkTraiTuyen.Checked ? "TRÁI TUYẾN" : "ĐÚNG TUYẾN";
lblPtramdauthe.Visible = objDoituongKCB.IdLoaidoituongKcb == 0;
txtptramDauthe.Visible = objDoituongKCB.IdLoaidoituongKcb == 0;
chkChuyenVien.Checked = false;
chkCapCuu.Checked = false;
txtPtramBHYT.Text = "0";
txtptramDauthe.Text = "0";
AllowTextChanged = true;
//Chuyển về trạng thái thêm mới
m_enAction = action.Insert;
if (PropertyLib._KCBProperties.SexInput) cboPatientSex.SelectedIndex = -1;
lnkThem.Visible = false;
SinhMaLanKham();
txtSoBenhAn.Text = THU_VIEN_CHUNG.LaySoBenhAn();
m_dataDataRegExam.Clear();
if (pnlBHYT.Enabled)
{
lblPtram.Text = "Phần trăm BHYT";
txtMaDtuong_BHYT.Focus();
}
else
{
lblPtram.Text = "P.trăm giảm giá";
PtramBhytCu = objDoituongKCB.PhantramTraituyen.Value;
PtramBhytGocCu = PtramBhytCu;
txtPtramBHYT.Text = objDoituongKCB.PhantramTraituyen.ToString();
txtptramDauthe.Text = objDoituongKCB.PhantramTraituyen.ToString();
txtTEN_BN.Focus();
}
if (m_enAction == action.Insert)
{
dtpInputDate.Value = globalVariables.SysDate;
dtCreateDate.Value = globalVariables.SysDate;
dtInsFromDate.Value = new DateTime(globalVariables.SysDate.Year, 1, 1);
dtInsToDate.Value = new DateTime(globalVariables.SysDate.Year, 12, 31);
}
SetActionStatus();
}
public ActionResult HuyBenhNhanVaoBuongGuong(NoitruPhanbuonggiuong objPhanbuonggiuong, ref int IdChuyen)
{
IdChuyen = -1;
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objPhanbuonggiuong != null)
{
NoitruPhanbuonggiuongCollection _NoitruPhanbuonggiuong = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.And(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan).ExecuteAsCollection<NoitruPhanbuonggiuongCollection>();
if (_NoitruPhanbuonggiuong.Count == 1)
{
///update thông tin của phòng giường
objPhanbuonggiuong.MarkOld();
objPhanbuonggiuong.IsLoaded = true;
objPhanbuonggiuong.NgaySua = globalVariables.SysDate;
objPhanbuonggiuong.NguoiSua = globalVariables.UserName;
objPhanbuonggiuong.NgayPhangiuong = null;
objPhanbuonggiuong.NguoiPhangiuong = "";
objPhanbuonggiuong.IdNhanvienPhangiuong = -1;
objPhanbuonggiuong.IdBuong = -1;
objPhanbuonggiuong.IdGiuong = -1;
objPhanbuonggiuong.DonGia = 0;
objPhanbuonggiuong.GiaGoc = 0;
objPhanbuonggiuong.BnhanChitra = 0;
objPhanbuonggiuong.BhytChitra = 0;
objPhanbuonggiuong.CachtinhGia = 0;
objPhanbuonggiuong.CachtinhSoluong = 0;
objPhanbuonggiuong.TrangthaiChuyen = 0;
objPhanbuonggiuong.TrangThai = 0;
objPhanbuonggiuong.Save();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objPhanbuonggiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(objPhanbuonggiuong.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(objPhanbuonggiuong.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objPhanbuonggiuong.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
else//Xóa bản ghi phân buồng giường hiện tại. Đưa về bản ghi phân buồng giường trước đó
{
if (THU_VIEN_CHUNG.Laygiatrithamsohethong("NOITRU_XOAKHIHUYGIUONG", "0", true) == "1")
{
IdChuyen = Utility.Int32Dbnull(objPhanbuonggiuong.IdChuyen.Value, -1);
NoitruPhanbuonggiuong _item = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(IdChuyen).ExecuteSingle<NoitruPhanbuonggiuong>();
if (_item != null)
{
new Delete().From(NoitruPhanbuonggiuong.Schema).Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(objPhanbuonggiuong.Id).Execute();
new Update(NoitruPhanbuonggiuong.Schema)
.Set(NoitruPhanbuonggiuong.Columns.TrangThai).EqualTo(0)
.Set(NoitruPhanbuonggiuong.Columns.TrangthaiChuyen).EqualTo(0)
.Set(NoitruPhanbuonggiuong.Columns.NgayKetthuc).EqualTo(null)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(_item.Id).Execute();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(_item.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(_item.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(_item.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(_item.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
}
else//Chỉ hủy giường
{
///update thông tin của phòng giường
objPhanbuonggiuong.MarkOld();
objPhanbuonggiuong.IsLoaded = true;
objPhanbuonggiuong.NgaySua = globalVariables.SysDate;
objPhanbuonggiuong.NguoiSua = globalVariables.UserName;
objPhanbuonggiuong.NgayPhangiuong = null;
objPhanbuonggiuong.NguoiPhangiuong = "";
objPhanbuonggiuong.IdNhanvienPhangiuong = -1;
objPhanbuonggiuong.IdBuong = -1;
objPhanbuonggiuong.IdGiuong = -1;
objPhanbuonggiuong.DonGia = 0;
objPhanbuonggiuong.GiaGoc = 0;
objPhanbuonggiuong.BnhanChitra = 0;
objPhanbuonggiuong.BhytChitra = 0;
objPhanbuonggiuong.CachtinhGia = 0;
objPhanbuonggiuong.CachtinhSoluong = 0;
objPhanbuonggiuong.TrangthaiChuyen = 0;
objPhanbuonggiuong.TrangThai = 0;
objPhanbuonggiuong.Save();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objPhanbuonggiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(objPhanbuonggiuong.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(objPhanbuonggiuong.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objPhanbuonggiuong.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
}
}
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
Utility.CatchException(exception);
return ActionResult.Error;
}
}
public ActionResult HuyKhoanoitru(NoitruPhanbuonggiuong objPhanbuonggiuong, ref int IdChuyen)
{
IdChuyen = -1;
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objPhanbuonggiuong != null)
{
NoitruPhanbuonggiuongCollection _NoitruPhanbuonggiuong = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.And(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan).ExecuteAsCollection <NoitruPhanbuonggiuongCollection>();
if (_NoitruPhanbuonggiuong.Count == 1)
{
if (!Utility.AcceptQuestion("Chú ý: Bệnh nhân mới nhập viện. Bạn có muốn hủy nhập viện cho bệnh nhân này hay không?", "Cảnh báo", true))
{
return(ActionResult.Cancel);
}
}
IdChuyen = Utility.Int32Dbnull(objPhanbuonggiuong.IdChuyen.Value, -1);
NoitruPhanbuonggiuong _item = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(IdChuyen).ExecuteSingle <NoitruPhanbuonggiuong>();
if (_item != null)//Chuyển về khoa trước
{
new Delete().From(NoitruPhanbuonggiuong.Schema).Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(objPhanbuonggiuong.Id).Execute();
new Update(NoitruPhanbuonggiuong.Schema)
.Set(NoitruPhanbuonggiuong.Columns.TrangThai).EqualTo(0)
.Set(NoitruPhanbuonggiuong.Columns.TrangthaiChuyen).EqualTo(0)
.Set(NoitruPhanbuonggiuong.Columns.NgayKetthuc).EqualTo(null)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(_item.Id).Execute();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(_item.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(_item.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(_item.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(_item.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
else//Hủy nhập viện
{
KcbLuotkham _KcbLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham).ExecuteSingle <KcbLuotkham>();
Huynhapvien(_KcbLuotkham);
}
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
Utility.CatchException(exception);
return(ActionResult.Error);
}
}
public ActionResult Nhapvien(NoitruPhanbuonggiuong objBuongGiuong, KcbLuotkham objLuotkham,
NoitruGoinhapvien objThongtinGoiDvu)
{
try
{
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
if (objBuongGiuong != null)
{
NoitruPhanbuonggiuongCollection _NoitruPhanbuonggiuong = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.And(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan).ExecuteAsCollection<NoitruPhanbuonggiuongCollection>();
if (_NoitruPhanbuonggiuong!=null && _NoitruPhanbuonggiuong.Count == 1)
{
if (Utility.Int32Dbnull(_NoitruPhanbuonggiuong[0].IdBuong, -1) == -1)
{
//Chỉ việc cập nhật lại thông tin khoa
new Update(NoitruPhanbuonggiuong.Schema)
.Set(NoitruPhanbuonggiuong.Columns.IdKhoanoitru).EqualTo(objBuongGiuong.IdKhoanoitru)
.Set(NoitruPhanbuonggiuong.Columns.NguoiSua).EqualTo(objBuongGiuong.NguoiSua)
.Set(NoitruPhanbuonggiuong.Columns.NgaySua).EqualTo(objBuongGiuong.NgaySua)
.Set(NoitruPhanbuonggiuong.Columns.NgayVaokhoa).EqualTo(objBuongGiuong.NgayVaokhoa)
.Set(NoitruPhanbuonggiuong.Columns.IdBacsiChidinh).EqualTo(objBuongGiuong.IdBacsiChidinh)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(_NoitruPhanbuonggiuong[0].Id)
.Execute();
objBuongGiuong.Id = _NoitruPhanbuonggiuong[0].Id;
}
}
else
{
if (objBuongGiuong.NgayVaokhoa <= Convert.ToDateTime("01/01/1900"))
objBuongGiuong.NgayVaokhoa = DateTime.Now;
if (objBuongGiuong.NgayTao <= Convert.ToDateTime("01/01/1900"))
objBuongGiuong.NgayTao = DateTime.Now;
if (objLuotkham.NgayNhapvien <= Convert.ToDateTime("01/01/1900"))
objLuotkham.NgayNhapvien = DateTime.Now;
new Delete().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.AndExpression(NoitruPhanbuonggiuong.Columns.IdBuong)
.IsEqualTo(-1)
.Or(NoitruPhanbuonggiuong.Columns.IdBuong)
.IsNull().CloseExpression().Execute();
objBuongGiuong.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objBuongGiuong.IdBuong = -1;
objBuongGiuong.IdGiuong = -1;
objBuongGiuong.IdChuyen = -1;
objBuongGiuong.SoLuong = 1;
objBuongGiuong.TuTuc = 0;
objBuongGiuong.IdGoi = -1;
objBuongGiuong.TrongGoi = -1;
objBuongGiuong.IdNhanvienPhangiuong = -1;
objBuongGiuong.TrangthaiXacnhan = 0;
objBuongGiuong.TenHienthi = "Nhập viện nội trú";
objBuongGiuong.NguoiTao = globalVariables.UserName;
objBuongGiuong.NgayTao = globalVariables.SysDate;
objBuongGiuong.NoiTru = 1;
objBuongGiuong.IsNew = true;
objBuongGiuong.Save();
}
KcbLuotkham _tempt=new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsNotEqualTo(objLuotkham.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsNotEqualTo(objLuotkham.IdBenhnhan)
.And(KcbLuotkham.Columns.SoBenhAn).IsEqualTo(objLuotkham.SoBenhAn)
.ExecuteSingle<KcbLuotkham>();
//Tạm bỏ -->Phải giữ nguyên số bệnh án nội trú chứ?
//if (_tempt != null)
// objLuotkham.SoBenhAn = THU_VIEN_CHUNG.LaySoBenhAn();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.SoBenhAn).EqualTo(objLuotkham.SoBenhAn)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objBuongGiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdNhapvien).EqualTo(objBuongGiuong.Id)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objBuongGiuong.Id)
.Set(KcbLuotkham.Columns.TrangthaiNoitru).EqualTo(1)
.Set(KcbLuotkham.Columns.NgayNhapvien).EqualTo(objBuongGiuong.NgayVaokhoa)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan).Execute();
//Phần gói này sẽ thiết kế lại sau
if (objThongtinGoiDvu != null)
{
if (Utility.Int32Dbnull(objThongtinGoiDvu.TrangthaiHuy, -1) <= 0) objThongtinGoiDvu.TrangthaiHuy = 0;
if (Utility.Int32Dbnull(objThongtinGoiDvu.TrangthaiDattruoc, -1) <= 0)
objThongtinGoiDvu.TrangthaiDattruoc = 0;
if (objThongtinGoiDvu.NgayTao <= Convert.ToDateTime("01/01/1900"))
objThongtinGoiDvu.NgayTao = globalVariables.SysDate;
SqlQuery sqlQuery = new Select().From(NoitruGoinhapvien.Schema)
.Where(NoitruGoinhapvien.Columns.MaLuotkham).IsEqualTo(
objThongtinGoiDvu.MaLuotkham)
.And(NoitruGoinhapvien.Columns.IdBenhnhan).IsEqualTo(objThongtinGoiDvu.IdBenhnhan)
.And(NoitruGoinhapvien.Columns.NoiTru).IsEqualTo(objThongtinGoiDvu.NoiTru)
.And(NoitruGoinhapvien.Columns.TrangthaiThanhtoan).IsEqualTo(1);
if (sqlQuery.GetRecordCount() > 0)
{
return ActionResult.ExistedRecord;
}
sqlQuery = new Select().From(NoitruGoinhapvien.Schema)
.Where(NoitruGoinhapvien.Columns.MaLuotkham).IsEqualTo(
objThongtinGoiDvu.MaLuotkham)
.And(NoitruGoinhapvien.Columns.IdBenhnhan).IsEqualTo(objThongtinGoiDvu.IdBenhnhan)
.And(NoitruGoinhapvien.Columns.NoiTru).IsEqualTo(objThongtinGoiDvu.NoiTru);
if (sqlQuery.GetRecordCount() <= 0)
{
//objThongtinGoiDvu.DatTruoc = 0;
objThongtinGoiDvu.IdNhanvien = globalVariables.gv_intIDNhanvien;
objThongtinGoiDvu.IsNew = true;
objThongtinGoiDvu.Save();
}
else
{
new Update(NoitruGoinhapvien.Schema)
.Set(NoitruGoinhapvien.Columns.IdNhanvien)
.EqualTo(globalVariables.gv_intIDNhanvien)
.Set(NoitruGoinhapvien.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(NoitruGoinhapvien.Columns.NgaySua).EqualTo(DateTime.Now)
.Set(NoitruGoinhapvien.Columns.IdGoi).EqualTo(objThongtinGoiDvu.IdGoi)
.Set(NoitruGoinhapvien.Columns.SoTien).EqualTo(objThongtinGoiDvu.SoTien)
.Set(NoitruGoinhapvien.Columns.SoNgay).EqualTo(objThongtinGoiDvu.SoNgay)
.Where(NoitruGoinhapvien.Columns.MaLuotkham).IsEqualTo(
objThongtinGoiDvu.MaLuotkham)
.And(NoitruGoinhapvien.Columns.IdBenhnhan).IsEqualTo(
objThongtinGoiDvu.IdBenhnhan)
.And(NoitruGoinhapvien.Columns.NoiTru).IsEqualTo(objThongtinGoiDvu.NoiTru).
Execute();
}
}
}
else
{
return ActionResult.Error;
}
}
Scope.Complete();
return ActionResult.Success;
}
}
catch (Exception ex)
{
Utility.CatchException( ex);
return ActionResult.Error;
}
}
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 static void LayThongTinGia(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam)
{
objPhanbuonggiuong.TuTuc = 0;
NoitruGiabuonggiuong objGia=NoitruGiabuonggiuong.FetchByID(objPhanbuonggiuong.IdGia);
if (THU_VIEN_CHUNG.Laygiatrithamsohethong("NOITRU_APGIABUONGGIUONG_THEODANHMUCGIA", "0", true) == "0")
objGia = null;
NoitruDmucGiuongbenh objGiuong = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if(objGia!=null)
{
objPhanbuonggiuong.DonGia = (objPatientExam.MaDoituongKcb == "DV" ? Utility.DecimaltoDbnull(objGia.GiaDichvu) : (objPatientExam.MaDoituongKcb == "BHYT" ? Utility.DecimaltoDbnull(objGia.GiaBhyt) : Utility.DecimaltoDbnull(objGia.GiaKhac)));
objPhanbuonggiuong.PhuThu = (objPatientExam.MaDoituongKcb == "BHYT" ? (Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objGia.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objGia.PhuthuTraituyen)) : 0);
objPhanbuonggiuong.TuTuc = objGiuong.TthaiTunguyen;
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objGiuong.TenGiuong);
objPhanbuonggiuong.GiaGoc = objPhanbuonggiuong.DonGia;
objPhanbuonggiuong.KieuThue = "GIUONG";
}
else if (objGiuong != null)
{
objPhanbuonggiuong.DonGia = (objPatientExam.MaDoituongKcb == "DV" ? Utility.DecimaltoDbnull(objGiuong.GiaDichvu) : (objPatientExam.MaDoituongKcb == "BHYT" ? Utility.DecimaltoDbnull(objGiuong.GiaBhyt) : Utility.DecimaltoDbnull(objGiuong.GiaKhac)));
objPhanbuonggiuong.PhuThu =(objPatientExam.MaDoituongKcb == "BHYT"? (Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objGiuong.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objGiuong.PhuthuTraituyen)):0);
objPhanbuonggiuong.TuTuc = objGiuong.TthaiTunguyen;
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objGiuong.TenGiuong);
objPhanbuonggiuong.GiaGoc = objPhanbuonggiuong.DonGia;
objPhanbuonggiuong.KieuThue = "GIUONG";
}
else//Tìm vào các bảng quan hệ
{
SqlQuery sqlQuery = new Select().From<NoitruQheDoituongBuonggiuong>()
.Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(objPhanbuonggiuong.IdGiuong)
.And(NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb).IsEqualTo(objPatientExam.MaDoituongKcb);
NoitruQheDoituongBuonggiuong objQhe = sqlQuery.ExecuteSingle<NoitruQheDoituongBuonggiuong>();
if (objQhe != null)
{
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objQhe.DonGia);
objPhanbuonggiuong.PhuThu = Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objQhe.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objQhe.PhuthuTraituyen);
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
{
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.GiaDichvu);
objPhanbuonggiuong.KieuThue = "GIUONG";
}
}
else
{
NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if (objLBed != null)
{
objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong);
objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objLBed.GiaDichvu);
objPhanbuonggiuong.PhuThu = Utility.DecimaltoDbnull(0);
objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen;
objPhanbuonggiuong.KieuThue = "GIUONG";
objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.GiaDichvu);
if (!THU_VIEN_CHUNG.IsBaoHiem(objPatientExam.IdLoaidoituongKcb))
{
objPhanbuonggiuong.TuTuc = 0;
}
}
}
}
if (!THU_VIEN_CHUNG.IsBaoHiem(objPatientExam.IdLoaidoituongKcb))
{
objPhanbuonggiuong.TuTuc = 0;
}
objPhanbuonggiuong.TrongGoi = 0;
if (objPhanbuonggiuong.IdGiuong > 0 || objPhanbuonggiuong.IdBuong > 0)//Có giường thì mới tính
TinhToanPtramBHYT.TinhPhanTramBHYT(objPhanbuonggiuong,objPatientExam, Utility.DecimaltoDbnull(objPatientExam.PtramBhytGoc));
}
public ActionResult Nhapvien(NoitruPhanbuonggiuong objBuongGiuong, KcbLuotkham objLuotkham,
NoitruGoinhapvien objThongtinGoiDvu)
{
try
{
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
if (objBuongGiuong != null)
{
NoitruPhanbuonggiuongCollection _NoitruPhanbuonggiuong = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.And(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan).ExecuteAsCollection <NoitruPhanbuonggiuongCollection>();
if (_NoitruPhanbuonggiuong != null && _NoitruPhanbuonggiuong.Count == 1)
{
if (Utility.Int32Dbnull(_NoitruPhanbuonggiuong[0].IdBuong, -1) == -1)
{
//Chỉ việc cập nhật lại thông tin khoa
new Update(NoitruPhanbuonggiuong.Schema)
.Set(NoitruPhanbuonggiuong.Columns.IdKhoanoitru).EqualTo(objBuongGiuong.IdKhoanoitru)
.Set(NoitruPhanbuonggiuong.Columns.NguoiSua).EqualTo(objBuongGiuong.NguoiSua)
.Set(NoitruPhanbuonggiuong.Columns.NgaySua).EqualTo(objBuongGiuong.NgaySua)
.Set(NoitruPhanbuonggiuong.Columns.NgayVaokhoa).EqualTo(objBuongGiuong.NgayVaokhoa)
.Set(NoitruPhanbuonggiuong.Columns.IdBacsiChidinh).EqualTo(objBuongGiuong.IdBacsiChidinh)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(_NoitruPhanbuonggiuong[0].Id)
.Execute();
}
}
else
{
if (objBuongGiuong.NgayVaokhoa <= Convert.ToDateTime("01/01/1900"))
{
objBuongGiuong.NgayVaokhoa = DateTime.Now;
}
if (objBuongGiuong.NgayTao <= Convert.ToDateTime("01/01/1900"))
{
objBuongGiuong.NgayTao = DateTime.Now;
}
if (objLuotkham.NgayNhapvien <= Convert.ToDateTime("01/01/1900"))
{
objLuotkham.NgayNhapvien = DateTime.Now;
}
new Delete().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.AndExpression(NoitruPhanbuonggiuong.Columns.IdBuong)
.IsEqualTo(-1)
.Or(NoitruPhanbuonggiuong.Columns.IdBuong)
.IsNull().CloseExpression().Execute();
objBuongGiuong.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objBuongGiuong.IdBuong = -1;
objBuongGiuong.IdGiuong = -1;
objBuongGiuong.IdChuyen = -1;
objBuongGiuong.SoLuong = 1;
objBuongGiuong.TuTuc = 0;
objBuongGiuong.IdGoi = -1;
objBuongGiuong.TrongGoi = -1;
objBuongGiuong.IdNhanvienPhangiuong = -1;
objBuongGiuong.TrangthaiXacnhan = 0;
objBuongGiuong.TenHienthi = "Nhập viện nội trú";
objBuongGiuong.NguoiTao = globalVariables.UserName;
objBuongGiuong.NgayTao = globalVariables.SysDate;
objBuongGiuong.NoiTru = 1;
objBuongGiuong.IsNew = true;
objBuongGiuong.Save();
}
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.SoBenhAn).EqualTo(objLuotkham.SoBenhAn)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objBuongGiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdNhapvien).EqualTo(objBuongGiuong.Id)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objBuongGiuong.Id)
.Set(KcbLuotkham.Columns.TrangthaiNoitru).EqualTo(1)
.Set(KcbLuotkham.Columns.NgayNhapvien).EqualTo(objBuongGiuong.NgayVaokhoa)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan).Execute();
if (objThongtinGoiDvu != null)
{
if (Utility.Int32Dbnull(objThongtinGoiDvu.TrangthaiHuy, -1) <= 0)
{
objThongtinGoiDvu.TrangthaiHuy = 0;
}
if (Utility.Int32Dbnull(objThongtinGoiDvu.TrangthaiDattruoc, -1) <= 0)
{
objThongtinGoiDvu.TrangthaiDattruoc = 0;
}
if (objThongtinGoiDvu.NgayTao <= Convert.ToDateTime("01/01/1900"))
{
objThongtinGoiDvu.NgayTao = globalVariables.SysDate;
}
SqlQuery sqlQuery = new Select().From(NoitruGoinhapvien.Schema)
.Where(NoitruGoinhapvien.Columns.MaLuotkham).IsEqualTo(
objThongtinGoiDvu.MaLuotkham)
.And(NoitruGoinhapvien.Columns.IdBenhnhan).IsEqualTo(objThongtinGoiDvu.IdBenhnhan)
.And(NoitruGoinhapvien.Columns.NoiTru).IsEqualTo(objThongtinGoiDvu.NoiTru)
.And(NoitruGoinhapvien.Columns.TrangthaiThanhtoan).IsEqualTo(1);
if (sqlQuery.GetRecordCount() > 0)
{
return(ActionResult.ExistedRecord);
}
sqlQuery = new Select().From(NoitruGoinhapvien.Schema)
.Where(NoitruGoinhapvien.Columns.MaLuotkham).IsEqualTo(
objThongtinGoiDvu.MaLuotkham)
.And(NoitruGoinhapvien.Columns.IdBenhnhan).IsEqualTo(objThongtinGoiDvu.IdBenhnhan)
.And(NoitruGoinhapvien.Columns.NoiTru).IsEqualTo(objThongtinGoiDvu.NoiTru);
if (sqlQuery.GetRecordCount() <= 0)
{
//objThongtinGoiDvu.DatTruoc = 0;
objThongtinGoiDvu.IdNhanvien = globalVariables.gv_intIDNhanvien;
objThongtinGoiDvu.IsNew = true;
objThongtinGoiDvu.Save();
}
else
{
new Update(NoitruGoinhapvien.Schema)
.Set(NoitruGoinhapvien.Columns.IdNhanvien)
.EqualTo(globalVariables.gv_intIDNhanvien)
.Set(NoitruGoinhapvien.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(NoitruGoinhapvien.Columns.NgaySua).EqualTo(DateTime.Now)
.Set(NoitruGoinhapvien.Columns.IdGoi).EqualTo(objThongtinGoiDvu.IdGoi)
.Set(NoitruGoinhapvien.Columns.SoTien).EqualTo(objThongtinGoiDvu.SoTien)
.Set(NoitruGoinhapvien.Columns.SoNgay).EqualTo(objThongtinGoiDvu.SoNgay)
.Where(NoitruGoinhapvien.Columns.MaLuotkham).IsEqualTo(
objThongtinGoiDvu.MaLuotkham)
.And(NoitruGoinhapvien.Columns.IdBenhnhan).IsEqualTo(
objThongtinGoiDvu.IdBenhnhan)
.And(NoitruGoinhapvien.Columns.NoiTru).IsEqualTo(objThongtinGoiDvu.NoiTru).
Execute();
}
}
}
else
{
return(ActionResult.Error);
}
}
Scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception ex)
{
Utility.CatchException(ex);
return(ActionResult.Error);
}
}
private 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 (objLuotkham.TrangthaiNoitru == 4)
{
Utility.SetMsg(lblMsg,
"Bệnh nhân đã được xác nhận dữ liệu nội trú để ra viện nên bạn không thể hủy ra viện", true);
return;
}
if (objLuotkham.TrangthaiNoitru == 5)
{
Utility.SetMsg(lblMsg,
"Bệnh nhân đã được duyệt thanh toán nội trú để ra viện nên bạn không thể hủy ra viện", true);
return;
}
if (objLuotkham.TrangthaiNoitru == 6)
{
Utility.SetMsg(lblMsg,
"Bệnh nhân đã kết thúc điều trị nội trú(Đã thanh toán xong) nên bạn không thể hủy ra viện", true);
return;
}
if (
Utility.AcceptQuestion(
string.Format("Bạn có chắc chắn muốn hủy ra viện cho bệnh nhân {0} hay không?", txtTenBN.Text),
"Xác nhận hủy ra viện", true))
{
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
objLuotkham.TthaiChuyendi = 0;
objLuotkham.IdBenhvienDi = -1;
objLuotkham.IdBacsiChuyenvien = -1;
objLuotkham.TrangthaiNoitru = 2;
objLuotkham.NgayRavien = null;
objLuotkham.IdRavien = -1;
objLuotkham.SoRavien = "";
objLuotkham.IsNew = false;
objLuotkham.MarkOld();
objLuotkham.Save();
new Delete().From(NoitruPhieuravien.Schema)
.Where(NoitruPhieuravien.Columns.IdRavien)
.IsEqualTo(Utility.Int32Dbnull(txtId.Text, -1))
.Execute();
NoitruPhanbuonggiuong objNoitruPhanbuonggiuong =
NoitruPhanbuonggiuong.FetchByID(objLuotkham.IdRavien.Value);
if (objNoitruPhanbuonggiuong != null)
{
objNoitruPhanbuonggiuong.MarkOld();
objNoitruPhanbuonggiuong.IsNew = false;
objNoitruPhanbuonggiuong.SoLuong = 0;
objNoitruPhanbuonggiuong.SoluongGio = 0;
objNoitruPhanbuonggiuong.NgayKetthuc = null;
objNoitruPhanbuonggiuong.Save();
}
}
scope.Complete();
mv_blnCancel = false;
Utility.SetMsg(lblMsg, string.Format("Hủy ra viện cho bệnh nhân {0} thành công", txtTenBN.Text),
true);
cmdHuy.Enabled = false;
cmdPrint.Enabled = false;
cmdChuyen.Enabled = objLuotkham != null && objLuotkham.TrangthaiNoitru <= 3;
}
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
}
public void Insert(long IdBenhnhan,int? IdKhoachuyen,short? TrangthaiChuyen,short IdKhoanoitru,string MaLuotkham,short? IdBuong,short? IdGiuong,byte? KieuGiuong,byte TrangThai,DateTime NgayVaokhoa,DateTime? NgayKetthuc,short? IdBacsiChidinh,string NguoiTao,DateTime NgayTao,string NguoiSua,DateTime? NgaySua,int? TrangthaiHuy,DateTime? NgayThanhtoan,int? TrangthaiThanhtoan,int? DuyetBhyt,int? NoiTru,int? SoLuong,decimal? DonGia,int? TuTuc,int? IdThanhtoan,int? IdKhoaRavien,int? TrangthaiRavien,decimal? BhytChitra,decimal? BnhanChitra,int? IdGoi,int? TrongGoi,int? IdNhanvienPhangiuong,DateTime? NgayPhangiuong,string NguoiPhangiuong,decimal? PhuThu,int? TrangthaiXacnhan,string TenHienthi,decimal? GiaGoc,int? IdKham,int? IdBenhLy,int? IdLoaiBg,string KieuThue,decimal? PhuThuNgoaigoi,int? IdChuyen,int? Stt,byte? CachTinh,byte? SoluongGio)
{
NoitruPhanbuonggiuong item = new NoitruPhanbuonggiuong();
item.IdBenhnhan = IdBenhnhan;
item.IdKhoachuyen = IdKhoachuyen;
item.TrangthaiChuyen = TrangthaiChuyen;
item.IdKhoanoitru = IdKhoanoitru;
item.MaLuotkham = MaLuotkham;
item.IdBuong = IdBuong;
item.IdGiuong = IdGiuong;
item.KieuGiuong = KieuGiuong;
item.TrangThai = TrangThai;
item.NgayVaokhoa = NgayVaokhoa;
item.NgayKetthuc = NgayKetthuc;
item.IdBacsiChidinh = IdBacsiChidinh;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.TrangthaiHuy = TrangthaiHuy;
item.NgayThanhtoan = NgayThanhtoan;
item.TrangthaiThanhtoan = TrangthaiThanhtoan;
item.DuyetBhyt = DuyetBhyt;
item.NoiTru = NoiTru;
item.SoLuong = SoLuong;
item.DonGia = DonGia;
item.TuTuc = TuTuc;
item.IdThanhtoan = IdThanhtoan;
item.IdKhoaRavien = IdKhoaRavien;
item.TrangthaiRavien = TrangthaiRavien;
item.BhytChitra = BhytChitra;
item.BnhanChitra = BnhanChitra;
item.IdGoi = IdGoi;
item.TrongGoi = TrongGoi;
item.IdNhanvienPhangiuong = IdNhanvienPhangiuong;
item.NgayPhangiuong = NgayPhangiuong;
item.NguoiPhangiuong = NguoiPhangiuong;
item.PhuThu = PhuThu;
item.TrangthaiXacnhan = TrangthaiXacnhan;
item.TenHienthi = TenHienthi;
item.GiaGoc = GiaGoc;
item.IdKham = IdKham;
item.IdBenhLy = IdBenhLy;
item.IdLoaiBg = IdLoaiBg;
item.KieuThue = KieuThue;
item.PhuThuNgoaigoi = PhuThuNgoaigoi;
item.IdChuyen = IdChuyen;
item.Stt = Stt;
item.CachTinh = CachTinh;
item.SoluongGio = SoluongGio;
item.Save(UserName);
}
private void LoadThongtinBenhnhan()
{
PtramBhytCu = 0m;
PtramBhytGocCu = 0m;
AllowTextChanged = false;
LstNoitruPhanbuonggiuong = new NoitruPhanbuonggiuongCollection();
objBuonggiuong = null;
objBenhnhan = KcbDanhsachBenhnhan.FetchByID(txtMaBN.Text);
if (objBenhnhan != null)
{
txtTEN_BN.Text = Utility.sDbnull(objBenhnhan.TenBenhnhan);
txtNamSinh.Text = Utility.sDbnull(objBenhnhan.NamSinh);
txtSoDT.Text = Utility.sDbnull(objBenhnhan.DienThoai);
txtDiachi_bhyt._Text = Utility.sDbnull(objBenhnhan.DiachiBhyt);
txtDiachi._Text = Utility.sDbnull(objBenhnhan.DiaChi);
if (objBenhnhan.NgaySinh != null) dtpBOD.Value = objBenhnhan.NgaySinh.Value;
else dtpBOD.Value = new DateTime((int)objBenhnhan.NamSinh, 1, 1);
txtNamSinh.Text = Utility.sDbnull(objBenhnhan.NamSinh);
txtTuoi.Text = Utility.sDbnull(globalVariables.SysDate.Year - Utility.Int32Dbnull(objBenhnhan.NamSinh));
txtNgheNghiep._Text = Utility.sDbnull(objBenhnhan.NgheNghiep);
cboPatientSex.SelectedIndex = Utility.GetSelectedIndex(cboPatientSex, Utility.sDbnull(objBenhnhan.IdGioitinh));
if (Utility.Int32Dbnull(objBenhnhan.DanToc) > 0)
txtDantoc._Text = objBenhnhan.DanToc;
txtCMT.Text = Utility.sDbnull(objBenhnhan.Cmt);
objLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLankham.Text)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(Utility.Int32Dbnull(txtMaBN.Text, -1)).ExecuteSingle
<KcbLuotkham>();
if (objLuotkham != null)
{
LstNoitruPhanbuonggiuong = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham).ExecuteAsCollection<NoitruPhanbuonggiuongCollection>();
if (LstNoitruPhanbuonggiuong.Count > 0)
objBuonggiuong = LstNoitruPhanbuonggiuong[0];
ucTamung1.ChangePatients(objLuotkham,"LYDOTAMUNGCAPCUU");
KcbDangkySokham objSoKCB=new Select().From(KcbDangkySokham.Schema)
.Where(KcbDangkySokham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(KcbDangkySokham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.ExecuteSingle<KcbDangkySokham>();
if (objSoKCB != null)
{
chkLaysokham.Checked = true;
txtSoKcb.SetCode(objSoKCB.MaSokcb);
}
else
{
chkLaysokham.Checked = false;
txtSoKcb.SetDefaultItem();
}
if (string.IsNullOrEmpty(Utility.sDbnull(objLuotkham.SoBenhAn, "")))
{
txtSoBenhAn.Text = THU_VIEN_CHUNG.LaySoBenhAn();
}
else
{
txtSoBenhAn.Text = Utility.sDbnull(objLuotkham.SoBenhAn, "");
}
m_strMaluotkham = objLuotkham.MaLuotkham;
if (objBuonggiuong != null)
{
AllowGridSelecttionChanged = false;
txtKhoanoitru.SetId(objBuonggiuong.IdKhoanoitru);
txtKhoanoitru__OnEnterMe();
txtGia.SetId(objBuonggiuong.IdGia);
txtRoom_code.SetId(objBuonggiuong.IdBuong);
txtRoom_code__OnEnterMe();
ChonBuong();
txtBedCode.SetId(objBuonggiuong.IdGiuong);
txtBedCode__OnEnterMe();
AllowGridSelecttionChanged = true;
dtNgayChuyen.Value = Convert.ToDateTime(objBuonggiuong.NgayVaokhoa);
txtGio.Text = Utility.sDbnull(dtNgayChuyen.Value.Hour);
txtPhut.Text = Utility.sDbnull(dtNgayChuyen.Value.Minute);
}
txtSolankham.Text = Utility.sDbnull(objLuotkham.SolanKham);
_IdDoituongKcb = objLuotkham.IdDoituongKcb;
dtpInputDate.Value = objLuotkham.NgayTiepdon;
dtCreateDate.Value = objLuotkham.NgayTiepdon;
chkCapCuu.Checked = Utility.Int32Dbnull(objLuotkham.TrangthaiCapcuu, 0) == 1;
chkTraiTuyen.Checked = Utility.Int32Dbnull(objLuotkham.DungTuyen, 0) == 0;
lblTuyenBHYT.Text = chkTraiTuyen.Checked ? "TRÁI TUYẾN" : "ĐÚNG TUYẾN";
_MaDoituongKcb = Utility.sDbnull(objLuotkham.MaDoituongKcb);
objDoituongKCB = new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.MaDoituongKcbColumn).IsEqualTo(_MaDoituongKcb).ExecuteSingle<DmucDoituongkcb>();
ChangeObjectRegion();
PtramBhytCu = Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0);
PtramBhytGocCu = Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0);
_IdDoituongKcb = objDoituongKCB.IdDoituongKcb;
_TenDoituongKcb = objDoituongKCB.TenDoituongKcb;
cboDoituongKCB.SelectedIndex = Utility.GetSelectedIndex(cboDoituongKCB, _MaDoituongKcb);
chkChuyenVien.Checked = Utility.Int32Dbnull(objLuotkham.TthaiChuyenden, 0) == 1;
txtNoichuyenden.SetId(Utility.Int32Dbnull(objLuotkham.IdBenhvienDen, -1));
if (!string.IsNullOrEmpty(objLuotkham.MatheBhyt))//Thông tin BHYT
{
txtTrieuChungBD._Text = Utility.sDbnull(objLuotkham.TrieuChung);
if (!string.IsNullOrEmpty(Utility.sDbnull(objLuotkham.NgaybatdauBhyt)))
dtInsFromDate.Value = Convert.ToDateTime(objLuotkham.NgaybatdauBhyt);
if (!string.IsNullOrEmpty(Utility.sDbnull(objLuotkham.NgayketthucBhyt)))
dtInsToDate.Value = Convert.ToDateTime(objLuotkham.NgayketthucBhyt);
txtPtramBHYT.Text = Utility.sDbnull(objLuotkham.PtramBhyt, "0");
txtptramDauthe.Text = Utility.sDbnull(objLuotkham.PtramBhytGoc, "0");
//HS7010340000005
txtMaDtuong_BHYT.Text = Utility.sDbnull(objLuotkham.MaDoituongBhyt);
txtMaQuyenloi_BHYT.Text = Utility.sDbnull(objLuotkham.MaQuyenloi);
txtNoiDongtrusoKCBBD.Text = Utility.sDbnull(objLuotkham.NoiDongtrusoKcbbd);
txtOthu4.Text = Utility.sDbnull(objLuotkham.MatheBhyt).Substring(5, 2);
txtOthu5.Text = Utility.sDbnull(objLuotkham.MatheBhyt).Substring(7, 3);
txtOthu6.Text = Utility.sDbnull(objLuotkham.MatheBhyt).Substring(10, 5);
txtMaDTsinhsong.SetCode(objLuotkham.MadtuongSinhsong);
chkGiayBHYT.Checked = Utility.Byte2Bool(objLuotkham.GiayBhyt);
txtNoiphattheBHYT.Text = Utility.sDbnull(objLuotkham.MaNoicapBhyt);
txtNoiDKKCBBD.Text = Utility.sDbnull(objLuotkham.MaKcbbd);
pnlBHYT.Enabled = true;
}
else
{
XoathongtinBHYT(true);
}
}
else
{
}
}
chkChuyenVien_CheckedChanged(chkChuyenVien, new EventArgs());
}
void txtMaLanKham_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter && Utility.DoTrim(txtMaLanKham.Text) != "")
{
objPhanbuonggiuong = null;
string _patient_Code = Utility.AutoFullPatientCode(txtMaLanKham.Text);
ClearControl();
txtMaLanKham.Text = _patient_Code;
BindData();
}
}
public bool Delete(object Id)
{
return(NoitruPhanbuonggiuong.Delete(Id) == 1);
}
public ActionResult ChuyenKhoaDieuTri(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam, DateTime NgayChuyenKhoa, short IDKhoaChuyenDen, short IDPhong, short IDGiuong)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objPhanbuonggiuong != null)
{
if (Utility.Int32Dbnull(objPhanbuonggiuong.IdBuong, -1) == -1 && Utility.Int32Dbnull(objPhanbuonggiuong.IdGiuong, -1) == -1)
{
//Chỉ việc cập nhật lại khoa nội trú do chưa phân buồng giường
objPhanbuonggiuong.MarkOld();
objPhanbuonggiuong.IsLoaded = true;
objPhanbuonggiuong.SoLuong = 0;
objPhanbuonggiuong.NgayVaokhoa = NgayChuyenKhoa;
objPhanbuonggiuong.TrangthaiXacnhan = Utility.ByteDbnull(objPhanbuonggiuong.TrangthaiXacnhan);
objPhanbuonggiuong.NgaySua = globalVariables.SysDate;
objPhanbuonggiuong.NguoiSua = globalVariables.UserName;
objPhanbuonggiuong.IdKhoanoitru = IDKhoaChuyenDen;
objPhanbuonggiuong.Save();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objPhanbuonggiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(objPhanbuonggiuong.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(objPhanbuonggiuong.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objPhanbuonggiuong.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
else
{
///update thông tin của phòng giường
objPhanbuonggiuong.MarkOld();
objPhanbuonggiuong.IsLoaded = true;
objPhanbuonggiuong.TrangthaiXacnhan = Utility.ByteDbnull(objPhanbuonggiuong.TrangthaiXacnhan);
objPhanbuonggiuong.NgaySua = globalVariables.SysDate;
objPhanbuonggiuong.NguoiSua = globalVariables.UserName;
objPhanbuonggiuong.NgayKetthuc = NgayChuyenKhoa;
objPhanbuonggiuong.TrangthaiChuyen = 1;
objPhanbuonggiuong.TrangThai = 1;
objPhanbuonggiuong.Save();
//NewItem
objPhanbuonggiuong.IdChuyen = (int?)objPhanbuonggiuong.Id;
objPhanbuonggiuong.IdKhoachuyen = objPhanbuonggiuong.IdKhoanoitru;
objPhanbuonggiuong.Id = -1;
objPhanbuonggiuong.NgayVaokhoa = NgayChuyenKhoa.AddMinutes(1);
objPhanbuonggiuong.NgayKetthuc = null;
objPhanbuonggiuong.NoiTru = 1;
objPhanbuonggiuong.TrangThai = 0;
objPhanbuonggiuong.TrangthaiChuyen = 0;
objPhanbuonggiuong.IdKhoanoitru = IDKhoaChuyenDen;
objPhanbuonggiuong.SoLuong = 0;
objPhanbuonggiuong.IdBuong = -1;
objPhanbuonggiuong.IdGiuong = -1;
objPhanbuonggiuong.NgayPhangiuong = null;
objPhanbuonggiuong.NguoiPhangiuong = "";
objPhanbuonggiuong.IdNhanvienPhangiuong = -1;
if (IDPhong > 0)
objPhanbuonggiuong.IdBuong = IDPhong;
if (IDGiuong > 0)
objPhanbuonggiuong.IdGiuong = IDGiuong;
if (IDPhong > 0 || IDGiuong > 0)
{
objPhanbuonggiuong.NgayPhangiuong = NgayChuyenKhoa;
objPhanbuonggiuong.NguoiPhangiuong = globalVariables.UserName;
objPhanbuonggiuong.IdNhanvienPhangiuong = globalVariables.gv_intIDNhanvien;
LayThongTinGia(objPhanbuonggiuong, objPatientExam);
}
objPhanbuonggiuong.NguoiTao = globalVariables.UserName;
objPhanbuonggiuong.NgayTao = globalVariables.SysDate;
objPhanbuonggiuong.IsNew = true;
objPhanbuonggiuong.Save();
objPatientExam.IdRavien = Utility.Int32Dbnull(objPhanbuonggiuong.Id);
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objPhanbuonggiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(objPhanbuonggiuong.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(objPhanbuonggiuong.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objPhanbuonggiuong.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
}
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
Utility.CatchException(exception);
return ActionResult.Error;
}
}
public ActionResult SaoChepDonThuocTheoPhieuDieuTriFullTransaction(KcbDonthuoc objDonthuoc, NoitruPhieudieutri objTreatment, KcbDonthuocChitiet[] arrChitietdonthuoc)
{
try
{
using (var scope = new TransactionScope())
{
using (var dbscope = new SharedDbConnectionScope())
{
objDonthuoc.IdPhieudieutri = objTreatment.IdPhieudieutri;
objDonthuoc.IdDonthuocthaythe = -1;
objDonthuoc.IdKham = objTreatment.IdPhieudieutri;
objDonthuoc.IdBacsiChidinh = objTreatment.IdBacsi;
objDonthuoc.NgaySua = null;
objDonthuoc.NguoiSua = null;
objDonthuoc.NgayKedon = Convert.ToDateTime(objTreatment.NgayDieutri);
objDonthuoc.Noitru = 1;
NoitruPhanbuonggiuong objPatientDept = NoitruPhanbuonggiuong.FetchByID(objTreatment.IdBuongGiuong);
if (objPatientDept != null)
{
objDonthuoc.IdKhoadieutri = Utility.Int16Dbnull(objPatientDept.IdKhoanoitru);
objDonthuoc.IdBuongNoitru = Utility.Int16Dbnull(objPatientDept.IdBuong);
objDonthuoc.IdGiuongNoitru = Utility.Int16Dbnull(objPatientDept.IdGiuong);
}
objDonthuoc.NgayXacnhan = null;
objDonthuoc.NgayCapphat = null;
objDonthuoc.TrangThai = 0;
objDonthuoc.TrangthaiThanhtoan = 0;
objDonthuoc.KieuDonthuoc = 0;
objDonthuoc.MaKhoaThuchien = globalVariables.MA_KHOA_THIEN;
//objDonthuoc.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objDonthuoc.MotaThem = "Sao chép";
objDonthuoc.NguoiTao = globalVariables.UserName;
objDonthuoc.NgayTao = globalVariables.SysDate;
objDonthuoc.IpMaytao = globalVariables.gv_strIPAddress;
objDonthuoc.TenMaytao = globalVariables.gv_strComputerName;
objDonthuoc.IsNew = true;
objDonthuoc.Save();
foreach (var objChitietdonthuoc in arrChitietdonthuoc)
{
KcbDonthuocChitiet newItem = KcbDonthuocChitiet.FetchByID(objChitietdonthuoc.IdChitietdonthuoc);
newItem.IdKham = objTreatment.IdPhieudieutri;
newItem.SoluongHuy = 0;
newItem.NgayHuy = null;
newItem.TrangthaiHuy = 0;
newItem.NguoiHuy = null;
newItem.TrangThai = 0;
newItem.SluongLinh = 0;
newItem.SluongSua = 0;
newItem.NgayXacnhan = null;
newItem.IdThanhtoan = -1;
newItem.TrangthaiThanhtoan = 0;
newItem.TrangthaiTonghop = 0;
newItem.NgayThanhtoan = null;
newItem.TrangthaiChuyen = 0;
newItem.NgaySua = null;
newItem.NguoiSua = null;
newItem.TileChietkhau = 0;
newItem.TienChietkhau = 0;
newItem.IdGoi = -1;
newItem.TrongGoi = 0;
newItem.IdDonthuoc = Utility.Int32Dbnull(objDonthuoc.IdDonthuoc);
newItem.NguoiTao = globalVariables.UserName;
newItem.NgayTao = globalVariables.SysDate;
newItem.IpMaytao = globalVariables.gv_strIPAddress;
newItem.TenMaytao = globalVariables.gv_strComputerName;
newItem.IsNew = true;
newItem.Save();
}
}
scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
return(ActionResult.Error);
}
}
public ActionResult HuyKhoanoitru(NoitruPhanbuonggiuong objPhanbuonggiuong, ref int IdChuyen)
{
IdChuyen = -1;
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objPhanbuonggiuong != null)
{
NoitruPhanbuonggiuongCollection _NoitruPhanbuonggiuong = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.And(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan).ExecuteAsCollection<NoitruPhanbuonggiuongCollection>();
if (_NoitruPhanbuonggiuong.Count == 1)
if (!Utility.AcceptQuestion("Chú ý: Bệnh nhân mới nhập viện. Bạn có muốn hủy nhập viện cho bệnh nhân này hay không?", "Cảnh báo", true))
{
return ActionResult.Cancel;
}
IdChuyen = Utility.Int32Dbnull(objPhanbuonggiuong.IdChuyen.Value, -1);
NoitruPhanbuonggiuong _item = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(IdChuyen).ExecuteSingle<NoitruPhanbuonggiuong>();
if (_item != null)//Chuyển về khoa trước
{
new Delete().From(NoitruPhanbuonggiuong.Schema).Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(objPhanbuonggiuong.Id).Execute();
new Update(NoitruPhanbuonggiuong.Schema)
.Set(NoitruPhanbuonggiuong.Columns.TrangThai).EqualTo(0)
.Set(NoitruPhanbuonggiuong.Columns.TrangthaiChuyen).EqualTo(0)
.Set(NoitruPhanbuonggiuong.Columns.NgayKetthuc).EqualTo(null)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(_item.Id).Execute();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(_item.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(_item.IdBuong)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(_item.IdGiuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(_item.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
else//Hủy nhập viện
{
KcbLuotkham _KcbLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham).ExecuteSingle<KcbLuotkham>();
Huynhapvien(_KcbLuotkham);
}
}
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
Utility.CatchException(exception);
return ActionResult.Error;
}
}
private NoitruPhanbuonggiuong TaoBuonggiuong()
{
NoitruPhanbuonggiuong objPatientDept = new NoitruPhanbuonggiuong();
objPatientDept.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham);
objPatientDept.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan, -1);
objPatientDept.IdKhoanoitru = Utility.Int16Dbnull(txtKhoanoitru.MyID, -1);
objPatientDept.NgayTao = globalVariables.SysDate;
objPatientDept.NgayVaokhoa = dtNgayNhapVien.Value;
objPatientDept.IdKham = id_kham;
objPatientDept.NguoiTao = globalVariables.UserName;
objPatientDept.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objPatientDept.NoiTru = 1;
objPatientDept.TrangthaiThanhtoan = 0;
objPatientDept.TrangThai = 0;
objPatientDept.DuyetBhyt = 0;
objPatientDept.CachtinhSoluong = 0;
objPatientDept.SoluongGio = 0;
return objPatientDept;
}
public ActionResult PhanGiuongDieuTri(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam, DateTime NgayPhanGiuong, short IDPhong, short IDGiuong)
{
try
{
using (var scope = new TransactionScope())
{
using (var sh = new SharedDbConnectionScope())
{
if (objPhanbuonggiuong != null)
{
new Update(NoitruDmucGiuongbenh.Schema).Set(NoitruDmucGiuongbenh.Columns.DangSudung).EqualTo(1)
.Where(NoitruDmucGiuongbenh.Columns.IdGiuong).IsEqualTo(IDGiuong).Execute();
objPhanbuonggiuong.IsNew = false;
objPhanbuonggiuong.MarkOld();
objPhanbuonggiuong.IsLoaded = true;
objPhanbuonggiuong.NgayPhangiuong = NgayPhanGiuong;
objPhanbuonggiuong.IdBuong = IDPhong;
objPhanbuonggiuong.IdGiuong = IDGiuong;
objPhanbuonggiuong.IdNhanvienPhangiuong = globalVariables.gv_intIDNhanvien;
objPhanbuonggiuong.NguoiPhangiuong = globalVariables.UserName;
objPhanbuonggiuong.NguoiTao = globalVariables.UserName;
objPhanbuonggiuong.NgayTao = globalVariables.SysDate;
objPhanbuonggiuong.TrangThai = 0;
LayThongTinGia(objPhanbuonggiuong, objPatientExam);
objPhanbuonggiuong.Save();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objPhanbuonggiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdGiuong).EqualTo(objPhanbuonggiuong.IdGiuong)
.Set(KcbLuotkham.Columns.IdBuong).EqualTo(objPhanbuonggiuong.IdBuong)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objPhanbuonggiuong.Id)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPhanbuonggiuong.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPhanbuonggiuong.IdBenhnhan)
.Execute();
}
}
scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
Utility.CatchException( exception);
return ActionResult.Error;
}
}
public static ActionResult NhapvienCapcuu(NoitruPhanbuonggiuong objBuongGiuong, KcbLuotkham objLuotkham)
{
try
{
using (var Scope = new TransactionScope())
{
if (objBuongGiuong != null)
{
NoitruPhanbuonggiuongCollection _NoitruPhanbuonggiuong = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.And(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan).ExecuteAsCollection<NoitruPhanbuonggiuongCollection>();
if (_NoitruPhanbuonggiuong != null && _NoitruPhanbuonggiuong.Count == 1)
{
if (Utility.Int32Dbnull(_NoitruPhanbuonggiuong[0].IdBuong, -1) == -1)
{
//Chỉ việc cập nhật lại thông tin khoa
new Update(NoitruPhanbuonggiuong.Schema)
.Set(NoitruPhanbuonggiuong.Columns.IdKhoanoitru).EqualTo(objBuongGiuong.IdKhoanoitru)
.Set(NoitruPhanbuonggiuong.Columns.NguoiSua).EqualTo(objBuongGiuong.NguoiSua)
.Set(NoitruPhanbuonggiuong.Columns.NgaySua).EqualTo(objBuongGiuong.NgaySua)
.Set(NoitruPhanbuonggiuong.Columns.NgayVaokhoa).EqualTo(objBuongGiuong.NgayVaokhoa)
.Set(NoitruPhanbuonggiuong.Columns.IdBacsiChidinh).EqualTo(objBuongGiuong.IdBacsiChidinh)
.Where(NoitruPhanbuonggiuong.Columns.Id).IsEqualTo(_NoitruPhanbuonggiuong[0].Id)
.Execute();
objBuongGiuong.Id = _NoitruPhanbuonggiuong[0].Id;
}
}
else
{
if (objBuongGiuong.NgayVaokhoa <= Convert.ToDateTime("01/01/1900"))
objBuongGiuong.NgayVaokhoa = DateTime.Now;
if (objBuongGiuong.NgayTao <= Convert.ToDateTime("01/01/1900"))
objBuongGiuong.NgayTao = DateTime.Now;
if (objLuotkham.NgayNhapvien <= Convert.ToDateTime("01/01/1900"))
objLuotkham.NgayNhapvien = DateTime.Now;
new Delete().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan)
.And(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.AndExpression(NoitruPhanbuonggiuong.Columns.IdBuong)
.IsEqualTo(-1)
.Or(NoitruPhanbuonggiuong.Columns.IdBuong)
.IsNull().CloseExpression().Execute();
objBuongGiuong.IdBacsiChidinh = globalVariables.gv_intIDNhanvien;
objBuongGiuong.IdChuyen = -1;
objBuongGiuong.SoLuong = 1;
objBuongGiuong.TuTuc = 0;
objBuongGiuong.IdGoi = -1;
objBuongGiuong.TrongGoi = -1;
objBuongGiuong.IdNhanvienPhangiuong = objBuongGiuong.IdBuong > 0 ? globalVariables.gv_intIDNhanvien : -1;
objBuongGiuong.TrangthaiXacnhan = 0;
objBuongGiuong.TenHienthi = "Nhập viện nội trú";
objBuongGiuong.NguoiTao = globalVariables.UserName;
objBuongGiuong.NgayTao = globalVariables.SysDate;
objBuongGiuong.NoiTru = 1;
objBuongGiuong.IsNew = true;
objBuongGiuong.Save();
}
KcbLuotkham _tempt = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsNotEqualTo(objLuotkham.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsNotEqualTo(objLuotkham.IdBenhnhan)
.And(KcbLuotkham.Columns.SoBenhAn).IsEqualTo(objLuotkham.SoBenhAn)
.ExecuteSingle<KcbLuotkham>();
//Kiểm tra xem số BA đã dùng cho đối tượng nào chưa
if (_tempt != null)
objLuotkham.SoBenhAn = THU_VIEN_CHUNG.LaySoBenhAn();
new Update(KcbLuotkham.Schema)
.Set(KcbLuotkham.Columns.SoBenhAn).EqualTo(objLuotkham.SoBenhAn)
.Set(KcbLuotkham.Columns.IdKhoanoitru).EqualTo(objBuongGiuong.IdKhoanoitru)
.Set(KcbLuotkham.Columns.IdNhapvien).EqualTo(objBuongGiuong.Id)
.Set(KcbLuotkham.Columns.IdRavien).EqualTo(objBuongGiuong.Id)
.Set(KcbLuotkham.Columns.TrangthaiNoitru).EqualTo(1)
.Set(KcbLuotkham.Columns.NgayNhapvien).EqualTo(objBuongGiuong.NgayVaokhoa)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan).Execute();
new Update(KcbLichsuDoituongKcb.Schema)
.Set(KcbLichsuDoituongKcb.Columns.IdKhoanoitru).EqualTo(objBuongGiuong.IdKhoanoitru)
.Set(KcbLichsuDoituongKcb.Columns.IdRavien).EqualTo(objBuongGiuong.Id)
.Set(KcbLichsuDoituongKcb.Columns.TrangthaiNoitru).EqualTo(1)
.Where(KcbLichsuDoituongKcb.Columns.MaLuotkham).IsEqualTo(objLuotkham.MaLuotkham)
.And(KcbLichsuDoituongKcb.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan).Execute();
}
else
{
return ActionResult.Error;
}
Scope.Complete();
return ActionResult.Success;
}
}
catch (Exception ex)
{
Utility.CatchException(ex);
return ActionResult.Error;
}
}
/// <summary>
///
/// </summary>
/// <param name="objRegExam"></param>
/// <param name="b_HasLoaded"></param>
/// <returns></returns>
public int AddRegExam(KcbDangkyKcb objRegExam, KcbLuotkham objLuotkham, bool b_HasLoaded, int KieuKham)
{
int v_RegId = -1;
decimal BHYT_PTRAM_TRAITUYENNOITRU = Utility.DecimaltoDbnull(THU_VIEN_CHUNG.Laygiatrithamsohethong("BHYT_PTRAM_TRAITUYENNOITRU", "0", false), 0m);
try
{
using (var scope = new TransactionScope())
{
objRegExam.SttKham = THU_VIEN_CHUNG.LaySothutuKCB(Utility.Int32Dbnull(objRegExam.IdPhongkham, -1));
objRegExam.PtramBhyt = objLuotkham.PtramBhyt;
objRegExam.PtramBhytGoc = objLuotkham.PtramBhytGoc;
if (!THU_VIEN_CHUNG.IsBaoHiem(objLuotkham.IdLoaidoituongKcb))
objRegExam.TuTuc = 0;
if (Utility.ByteDbnull(objRegExam.TuTuc, 0) == 1)
{
objRegExam.BhytChitra =0;// objRegExam.DonGia * Utility.DecimaltoDbnull(objLuotkham.PtramBhyt) / 100;
objRegExam.BnhanChitra = objRegExam.DonGia;
}
else
{
decimal BHCT = 0m;
if (objLuotkham.DungTuyen == 1)
{
BHCT = objRegExam.DonGia * Utility.DecimaltoDbnull(objLuotkham.PtramBhyt) / 100;
}
else
{
if (objLuotkham.TrangthaiNoitru <= 0)
BHCT = objRegExam.DonGia * (Utility.DecimaltoDbnull(objLuotkham.PtramBhyt, 0) / 100);
else//Nội trú cần tính=đơn giá * % đầu thẻ * % tuyến
BHCT = objRegExam.DonGia * (Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0) / 100) * (BHYT_PTRAM_TRAITUYENNOITRU / 100);
}
objRegExam.BhytChitra =BHCT;// objRegExam.DonGia * Utility.DecimaltoDbnull(objLuotkham.PtramBhyt) / 100;
objRegExam.BnhanChitra = objRegExam.DonGia - objRegExam.BhytChitra;
}
objRegExam.MaKhoaThuchien = globalVariables.MA_KHOA_THIEN;
objRegExam.TrangThai = 0;
objRegExam.IsNew = true;
objRegExam.Save();
//Thêm bản ghi trong bảng phân buồng giường để tiện tính toán
NoitruPhanbuonggiuong _newItem = new NoitruPhanbuonggiuong();
_newItem.IdBenhnhan = objRegExam.IdBenhnhan;
_newItem.MaLuotkham = objRegExam.MaLuotkham;
_newItem.IdKham = (int)objRegExam.IdKham;
_newItem.IdKhoanoitru = objRegExam.IdKhoakcb.Value;
_newItem.NgayVaokhoa = objRegExam.NgayDangky.Value;
_newItem.IdBacsiChidinh = objRegExam.IdBacsikham;
_newItem.NguoiTao = objRegExam.NguoiTao;
_newItem.NgayTao = objRegExam.NgayDangky.Value;
_newItem.NoiTru =0;
_newItem.DuyetBhyt = 0;
_newItem.TrongGoi =-1;
_newItem.SoLuong = 1;
_newItem.DonGia = objRegExam.DonGia;
_newItem.PhuThu = objRegExam.PhuThu;
_newItem.BnhanChitra = objRegExam.BnhanChitra;
_newItem.BhytChitra = objRegExam.BhytChitra;
_newItem.TenHienthi = objRegExam.TenDichvuKcb;
_newItem.TuTuc = objRegExam.TuTuc;
_newItem.TrangthaiXacnhan = 0;
_newItem.GiaGoc = objRegExam.DonGia + objRegExam.PhuThu;
_newItem.IdBuong = -1;
_newItem.IdGiuong = -1;
_newItem.IdChuyen = -1;
_newItem.IdNhanvienPhangiuong = -1;
_newItem.IsNew = true;
_newItem.Save();
v_RegId = Utility.Int32Dbnull(objRegExam.IdKham);
if (objRegExam.IdKham > 0)
{
KieuKham = Utility.Int32Dbnull(objRegExam.IdDichvuKcb);
long _regid = objRegExam.IdKham;
//Lấy phí kèm theo trong bảng Quan hệ kiểu khám và đẩy vào bảng T_RegExam
//THEM_PHI_DVU_KYC(objLuotkham,objRegExam, KieuKham);
//Lấy phí kèm theo trong bảng DmucPhikemtheoCollection
//(cấu hình theo từng phòng khám thay vì theo từng kiểu khám) và đẩy vào bảng T_RegExam
THEM_PHI_DVU_KYC(objLuotkham, objRegExam);
//Lấy phí dịch vụ trong bảng Quan hệ kiểu khám và đẩy vào bảng CLS
//THEM_PHI_DVU_KYC(objLuotkham, KieuKham);
}
scope.Complete();
}
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return v_RegId;
}
private void BindData()
{
SqlQuery sqlQuery = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLanKham.Text);
if (sqlQuery.GetRecordCount() > 0)
{
objLuotkham = sqlQuery.ExecuteSingle <KcbLuotkham>();
if (objLuotkham != null)
{
txtMaLanKham.Text = Utility.sDbnull(objLuotkham.MaLuotkham);
txtSoBHYT.Text = Utility.sDbnull(objLuotkham.MatheBhyt);
DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(objLuotkham.IdKhoanoitru);
if (objLDepartment != null)
{
txtDepartment_ID.Text = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Tag = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Text = Utility.sDbnull(objLDepartment.TenKhoaphong);
}
KcbDanhsachBenhnhan objPatientInfo = KcbDanhsachBenhnhan.FetchByID(objLuotkham.IdBenhnhan);
if (objPatientInfo != null)
{
txtPatient_Name.Text = Utility.sDbnull(objPatientInfo.TenBenhnhan);
txtPatient_ID.Text = Utility.sDbnull(objLuotkham.IdBenhnhan);
txtNamSinh.Text = Utility.sDbnull(objPatientInfo.NamSinh);
txtTuoi.Text = Utility.sDbnull(DateTime.Now.Year - objPatientInfo.NamSinh);
txtPatientSex.Text = objPatientInfo.GioiTinh; // Utility.Int32Dbnull(objPatientInfo.) == 0 ? "Nam" : "Nữ";
}
NoitruPhanbuonggiuong objPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(IDBuonggiuong); // noitru_nhapvien.LaythongtinBuonggiuongHtai(objLuotkham);
if (objPhanbuonggiuong != null)
{
dtNgayvao.Value = objPhanbuonggiuong.NgayVaokhoa;
txtPatientDept_ID.Text = Utility.sDbnull(objPhanbuonggiuong.Id);
NoitruDmucBuong objRoom = NoitruDmucBuong.FetchByID(objPhanbuonggiuong.IdBuong);
if (objRoom != null)
{
txtSoPhong.Text = Utility.sDbnull(objRoom.TenBuong);
txtSoPhong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdBuong);
}
NoitruDmucGiuongbenh objNoitruDmucGiuongbenh = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if (objNoitruDmucGiuongbenh != null)
{
txtSoGiuong.Text = Utility.sDbnull(objNoitruDmucGiuongbenh.TenGiuong);
txtSoGiuong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdGiuong);
}
}
DataTable dtGia = new dmucgiagiuong_busrule().dsGetList("-1").Tables[0];
dtGia.DefaultView.Sort = NoitruGiabuonggiuong.Columns.SttHthi + "," + NoitruGiabuonggiuong.Columns.TenGia;
txtGia.Init(dtGia,
new List <string>()
{
NoitruGiabuonggiuong.Columns.IdGia,
NoitruGiabuonggiuong.Columns.MaGia,
NoitruGiabuonggiuong.Columns.TenGia
});
cboGia.DataSource = dtGia;
cboGia.DataMember = NoitruGiabuonggiuong.Columns.IdGia;
cboGia.ValueMember = NoitruGiabuonggiuong.Columns.IdGia;
cboGia.DisplayMember = NoitruGiabuonggiuong.Columns.TenGia;
m_dtDataRoom = THU_VIEN_CHUNG.NoitruTimkiembuongTheokhoa(Utility.Int32Dbnull(txtDepartment_ID.Text));
Utility.SetDataSourceForDataGridEx_Basic(grdBuong, m_dtDataRoom, true, true, "1=1", "sluong_giuong_trong desc,ten_buong");
txtRoom_code.Init(m_dtDataRoom, new List <string>()
{
NoitruDmucBuong.Columns.IdBuong, NoitruDmucBuong.Columns.MaBuong, NoitruDmucBuong.Columns.TenBuong
});
if (grdBuong.DataSource != null)
{
grdBuong.MoveFirst();
}
}
else
{
string tempt = txtMaLanKham.Text;
ClearControl();
if (m_dtDataRoom != null)
{
m_dtDataRoom.Clear();
}
if (m_dtDatabed != null)
{
m_dtDataRoom.Clear();
}
txtMaLanKham.Text = tempt;
txtMaLanKham.SelectAll();
txtMaLanKham.Focus();
}
}
}
