public NoitruPhanbuonggiuongCollection FetchAll()
{
NoitruPhanbuonggiuongCollection coll = new NoitruPhanbuonggiuongCollection();
Query qry = new Query(NoitruPhanbuonggiuong.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public NoitruPhanbuonggiuongCollection FetchByQuery(Query qry)
{
NoitruPhanbuonggiuongCollection coll = new NoitruPhanbuonggiuongCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public NoitruPhanbuonggiuongCollection FetchAll()
{
NoitruPhanbuonggiuongCollection coll = new NoitruPhanbuonggiuongCollection();
Query qry = new Query(NoitruPhanbuonggiuong.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public NoitruPhanbuonggiuongCollection FetchByQuery(Query qry)
{
NoitruPhanbuonggiuongCollection coll = new NoitruPhanbuonggiuongCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public NoitruPhanbuonggiuongCollection FetchByID(object Id)
{
NoitruPhanbuonggiuongCollection coll = new NoitruPhanbuonggiuongCollection().Where("id", Id).Load();
return coll;
}
/// <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();
}
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());
}
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 NoitruPhanbuonggiuongCollection FetchByID(object Id)
{
NoitruPhanbuonggiuongCollection coll = new NoitruPhanbuonggiuongCollection().Where("id", Id).Load();
return(coll);
}
/// <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;
}
}
