public static void InphieuChidinhCLS(int id_benhnhan,string ma_luotkham, int v_AssignId, string v_AssignCode,string nhomincls,int selectedIndex, bool inTach ,ref string mayin)
{
try
{
mayin = "";
KcbChidinhcl objAssignInfo = KcbChidinhcl.FetchByID(v_AssignId);
DataTable dt = new KCB_THAMKHAM().KcbThamkhamLaydulieuInphieuCls(id_benhnhan, ma_luotkham, v_AssignCode, nhomincls).Tables[0];
if (dt == null || dt.Rows.Count <= 0)
{
Utility.ShowMsg("Không có dữ liệu in. Mời bạn kiểm tra lại");
return;
}
THU_VIEN_CHUNG.CreateXML(dt,"Thamkham_InphieuCLS.XML");
Utility.UpdateLogotoDatatable(ref dt);
Utility.CreateBarcodeData(ref dt, v_AssignCode);
var crpt = new ReportDocument();
string KhoGiay = "A5";
bool inchung = false;
string tieude = "", reportname = "";
if (PropertyLib._MayInProperties.CoGiayInCLS == Papersize.A4) KhoGiay = "A4";
if (KhoGiay == "A5")
if (inTach && selectedIndex == 0)//Nếu in riêng mà chọn tất
crpt = Utility.GetReport("thamkham_InphieuchidinhCLS_RIENG_A5", ref tieude, ref reportname);
else
{
inchung = true;
crpt = Utility.GetReport("thamkham_InphieuchidinhCLS_A5", ref tieude, ref reportname);
}
else//Khổ giấy A4
if (inTach && selectedIndex == 0)//Nếu in riêng mà chọn tất-->Gọi báo cáo nhóm theo nhóm in
crpt = Utility.GetReport("thamkham_InphieuchidinhCLS_RIENG_A4", ref tieude, ref reportname);
else
{
inchung = true;
crpt = Utility.GetReport("thamkham_InphieuchidinhCLS_A4", ref tieude, ref reportname);
}
if (crpt == null) return;
if (inchung)
{
List<string> lstNhominCLS = (from p in dt.AsEnumerable()
where Utility.DoTrim(Utility.sDbnull(p.Field<string>("nhom_in_cls"))) != ""
select p.Field<string>("nhom_in_cls")
).Distinct().ToList<string>();
if (lstNhominCLS.Count > 1)
{
string tenphieuchidinh = THU_VIEN_CHUNG.Laygiatrithamsohethong("CLS_TENPHIEU_INCHUNG", "PHIẾU CHỈ ĐỊNH CẬN LÂM SÀNG", true); ;
foreach (DataRow dr in dt.Rows)
dr["ten_nhominphieucls"] = tenphieuchidinh;
}
}
var objForm = new frmPrintPreview("IN PHIẾU CHỈ ĐỊNH", crpt, true, true);
try
{
crpt.SetDataSource(dt);
//crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + " Nhân viên Bác sĩ chỉ định ".Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
if (!inTach && selectedIndex == 0)
{
foreach (DataRow dr in dt.Rows)
dr[VKcbChidinhcl.Columns.TenNhominphieucls] = THU_VIEN_CHUNG.Laygiatrithamsohethong("TIEUDE_PHIEUCHIDNHCLS_INCHUNG", "PHIẾU CHỈ ĐỊNH", true);
}
else
{
Utility.SetParameterValue(crpt, "TitleReport", tieude);
}
Utility.SetParameterValue(crpt, "CurrentDate", Utility.FormatDateTimeWithLocation(globalVariables.SysDate, globalVariables.gv_strDiadiem));
objForm.crptViewer.ReportSource = crpt;
if (Utility.isPrintPreview(PropertyLib._MayInProperties.TenMayInBienlai, PropertyLib._MayInProperties.PreviewInCLS))
{
objForm.SetDefaultPrinter(PropertyLib._MayInProperties.TenMayInBienlai, 0);
objForm.ShowDialog();
mayin = PropertyLib._MayInProperties.TenMayInBienlai;
}
else
{
objForm.addTrinhKy_OnFormLoad();
crpt.PrintOptions.PrinterName = PropertyLib._MayInProperties.TenMayInBienlai;
mayin = PropertyLib._MayInProperties.TenMayInBienlai;
crpt.PrintToPrinter(1, false, 0, 0);
}
}
catch (Exception ex)
{
// Utility.DefaultNow(this);
}
}
catch
{
}
}
void LoadData()
{
try
{
decimal BHYT_PTRAM_TRAITUYENNOITRU = Utility.DecimaltoDbnull(THU_VIEN_CHUNG.Laygiatrithamsohethong("BHYT_PTRAM_TRAITUYENNOITRU", "0", false), 0m);
DataSet ds =new KCB_THAMKHAM().NoitruLayDanhsachVtthGoidichvu((int)objLuotkham.IdBenhnhan, objLuotkham.MaLuotkham);
m_dtVTTH = ds.Tables[0];
m_dtGoidichvu = ds.Tables[1];
Utility.SetDataSourceForDataGridEx_Basic(grdGoidichvu, m_dtGoidichvu, false, true, "",
"stt_hthi_dichvu,stt_hthi_chitiet,ten_chitietdichvu");
m_dtVTTHChitiet_View = m_dtVTTH.Clone();
foreach (DataRow row in m_dtVTTH.Rows)
{
row["CHON"] = 0;
DataRow[] drview
= m_dtVTTHChitiet_View
.Select(KcbDonthuocChitiet.Columns.IdThuoc + "=" + Utility.sDbnull(row[KcbDonthuocChitiet.Columns.IdThuoc], "-1")
+ "AND " + KcbDonthuocChitiet.Columns.DonGia + "=" + Utility.sDbnull(row[KcbDonthuocChitiet.Columns.DonGia], "-1"));
if (drview.Length <= 0)
{
//if (!Utility.Byte2Bool(row[KcbDonthuocChitiet.Columns.TuTuc]))
//{
// decimal BHCT = 0m;
// if (objLuotkham.TrangthaiNoitru <= 0)
// BHCT = Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.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(row[KcbDonthuocChitiet.Columns.DonGia], 0) * (Utility.DecimaltoDbnull(objLuotkham.PtramBhytGoc, 0) / 100) * (BHYT_PTRAM_TRAITUYENNOITRU / 100);
// //decimal num2 = (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia], 0) * Utility.DecimaltoDbnull(this.objLuotkham.PtramBhyt, 0)) / 100M;
// decimal num3 = Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia], 0) - BHCT;
// row[KcbDonthuocChitiet.Columns.BhytChitra] = BHCT;
// row[KcbDonthuocChitiet.Columns.BnhanChitra] = num3;
//}
//else
//{
// row[KcbDonthuocChitiet.Columns.PtramBhyt] = 0;
// row[KcbDonthuocChitiet.Columns.BhytChitra] = 0;
// row[KcbDonthuocChitiet.Columns.BnhanChitra] = Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia], 0);
//}
//row["TT_KHONG_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia]);
//row["TT"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia]) + Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu]));
//row["TT_BHYT"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BhytChitra]);
//row["TT_BN"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BnhanChitra], 0) + Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu], 0));
//row["TT_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu], 0);
//row["TT_BN_KHONG_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BnhanChitra], 0);
if (Utility.Byte2Bool(row[KcbDonthuocChitiet.Columns.TrongGoi]))
{
row[KcbDonthuocChitiet.Columns.DonGia] = 0;
row[KcbDonthuocChitiet.Columns.BnhanChitra] = 0;
row[KcbDonthuocChitiet.Columns.BhytChitra] = 0;
row[KcbDonthuocChitiet.Columns.PhuThu] = 0;
row["TT_KHONG_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia]);
row["TT"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.DonGia]) + Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu]));
row["TT_BHYT"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BhytChitra]);
row["TT_BN"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BnhanChitra], 0) + Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu], 0));
row["TT_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.PhuThu], 0);
row["TT_BN_KHONG_PHUTHU"] = Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(row[KcbDonthuocChitiet.Columns.BnhanChitra], 0);
}
m_dtVTTHChitiet_View.ImportRow(row);
}
else
{
drview[0][KcbDonthuocChitiet.Columns.SoLuong] = Utility.Int32Dbnull(drview[0][KcbDonthuocChitiet.Columns.SoLuong], 0) + Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SoLuong], 0);
drview[0]["TT_KHONG_PHUTHU"] = Utility.Int32Dbnull(drview[0][KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(drview[0][KcbDonthuocChitiet.Columns.DonGia]);
drview[0]["TT"] = Utility.Int32Dbnull(drview[0][KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(drview[0][KcbDonthuocChitiet.Columns.DonGia]) + Utility.DecimaltoDbnull(drview[0][KcbDonthuocChitiet.Columns.PhuThu]));
drview[0]["TT_BHYT"] = Utility.Int32Dbnull(drview[0][KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(drview[0][KcbDonthuocChitiet.Columns.BhytChitra]);
drview[0]["TT_BN"] = Utility.Int32Dbnull(drview[0][KcbDonthuocChitiet.Columns.SoLuong]) * (Utility.DecimaltoDbnull(drview[0][KcbDonthuocChitiet.Columns.BnhanChitra], 0) + Utility.DecimaltoDbnull(drview[0][KcbDonthuocChitiet.Columns.PhuThu], 0));
drview[0]["TT_PHUTHU"] = Utility.Int32Dbnull(drview[0][KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(drview[0][KcbDonthuocChitiet.Columns.PhuThu], 0);
drview[0]["TT_BN_KHONG_PHUTHU"] = Utility.Int32Dbnull(drview[0][KcbDonthuocChitiet.Columns.SoLuong]) * Utility.DecimaltoDbnull(drview[0][KcbDonthuocChitiet.Columns.BnhanChitra], 0);
drview[0][KcbDonthuocChitiet.Columns.SttIn] = Math.Min(Utility.Int32Dbnull(row[KcbDonthuocChitiet.Columns.SttIn], 0), Utility.Int32Dbnull(drview[0][KcbDonthuocChitiet.Columns.SttIn], 0));
m_dtVTTHChitiet_View.AcceptChanges();
}
}
//Old-->Utility.SetDataSourceForDataGridEx
Utility.SetDataSourceForDataGridEx_Basic(grdVTTH, m_dtVTTHChitiet_View, false, true, "",KcbDonthuocChitiet.Columns.TrongGoi+","+ KcbDonthuocChitiet.Columns.SttIn);
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}
public void txtMaluotkham_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter && Utility.DoTrim(txtMaluotkham.Text) != "")
{
AllowTextChanged = false;
var dtPatient = new DataTable();
objLuotkham = null;
string _patient_Code = Utility.AutoFullPatientCode(txtMaluotkham.Text);
ClearControls();
dtPatient = new KCB_THAMKHAM().TimkiemBenhnhan(txtMaluotkham.Text,
-1,(byte)1, 0);
DataRow[] arrPatients = dtPatient.Select(KcbLuotkham.Columns.MaLuotkham + "='" + _patient_Code + "'");
if (arrPatients.GetLength(0) <= 0)
{
if (dtPatient.Rows.Count > 1)
{
var frm = new frm_DSACH_BN_TKIEM();
frm.MaLuotkham = txtMaluotkham.Text;
frm.dtPatient = dtPatient;
frm.ShowDialog();
if (!frm.has_Cancel)
{
txtMaluotkham.Text = frm.MaLuotkham;
}
}
}
else
{
txtMaluotkham.Text = _patient_Code;
}
DataTable dt_Patient = new KCB_THAMKHAM().TimkiemThongtinBenhnhansaukhigoMaBN(txtMaluotkham.Text, -1,"ALL");
if (dt_Patient != null && dt_Patient.Rows.Count > 0)
{
txtIdBn.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbDanhsachBenhnhan.Columns.IdBenhnhan], "");
objLuotkham = new Select().From(KcbLuotkham.Schema).Where(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(txtIdBn.Text)
.And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaluotkham.Text)
.ExecuteSingle<KcbLuotkham>();
dtpNgaynhapvien.Value = objLuotkham.NgayNhapvien.Value;
txtTenBN.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbDanhsachBenhnhan.Columns.TenBenhnhan], "");
txttuoi.Text = Utility.sDbnull(dt_Patient.Rows[0]["Tuoi"], "");
txtgioitinh.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbDanhsachBenhnhan.Columns.GioiTinh], "");
txtDiachi.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbDanhsachBenhnhan.Columns.DiaChi], "");
txtmatheBhyt.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.MatheBhyt], "");
txtKhoanoitru.Text = Utility.sDbnull(dt_Patient.Rows[0]["ten_khoaphong_noitru"], "");
txtBuong.Text = Utility.sDbnull(dt_Patient.Rows[0][NoitruDmucBuong.Columns.TenBuong], "");
txtGiuong.Text = Utility.sDbnull(dt_Patient.Rows[0][NoitruDmucGiuongbenh.Columns.TenGiuong], "");
txtIdkhoanoitru.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.IdKhoanoitru], "-1");
txtIdravien.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.IdRavien], "-1");
txtidBuong.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.IdBuong], "-1");
txtidgiuong.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.IdGiuong], "-1");
cmdChuyen.Enabled = true;
if (objLuotkham.TrangthaiNoitru == 0)
{
Utility.ShowMsg("Bệnh nhân chưa vào nội trú nên không thể lập phiếu ra viện. Đề nghị bạn kiểm tra lại");
cmdChuyen.Enabled = false;
return;
}
cmdChuyen.Enabled = objLuotkham != null && objLuotkham.TrangthaiNoitru <= 3;
LoadData();
dtpNgayravien.Focus();
}
}
}
catch (Exception)
{
Utility.ShowMsg("Có lỗi trong quá trình lấy thông tin bệnh nhân");
}
finally
{
AllowTextChanged = true;
}
}
void txtMaluotkham_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter && Utility.DoTrim(txtMaluotkham.Text) != "")
{
var dtPatient = new DataTable();
objLuotkham = null;
string _patient_Code = Utility.AutoFullPatientCode(txtMaluotkham.Text);
ClearControls();
dtPatient = new KCB_THAMKHAM().TimkiemBenhnhan(txtMaluotkham.Text,
-1,0, 0);
DataRow[] arrPatients = dtPatient.Select(KcbLuotkham.Columns.MaLuotkham + "='" + _patient_Code + "'");
if (arrPatients.GetLength(0) <= 0)
{
if (dtPatient.Rows.Count > 1)
{
var frm = new frm_DSACH_BN_TKIEM();
frm.MaLuotkham = txtMaluotkham.Text;
frm.dtPatient = dtPatient;
frm.ShowDialog();
if (!frm.has_Cancel)
{
txtMaluotkham.Text = frm.MaLuotkham;
}
}
}
else
{
txtMaluotkham.Text = _patient_Code;
}
DataTable dt_Patient = new KCB_THAMKHAM().TimkiemThongtinBenhnhansaukhigoMaBN(txtMaluotkham.Text, -1, globalVariables.MA_KHOA_THIEN);
if (dt_Patient != null && dt_Patient.Rows.Count > 0)
{
txtIdBn.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbDanhsachBenhnhan.Columns.IdBenhnhan], "");
objLuotkham = new Select().From(KcbLuotkham.Schema).Where(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(txtIdBn.Text)
.And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaluotkham.Text)
.ExecuteSingle<KcbLuotkham>();
txtTenBN.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbDanhsachBenhnhan.Columns.TenBenhnhan], "");
txttuoi.Text = Utility.sDbnull(dt_Patient.Rows[0]["Tuoi"], "");
txtgioitinh.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbDanhsachBenhnhan.Columns.GioiTinh], "");
txtDiaChi.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbDanhsachBenhnhan.Columns.DiaChi], "");
txtmatheBhyt.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.MatheBhyt], "");
txtKhoanoitru.Text = Utility.sDbnull(dt_Patient.Rows[0]["ten_khoaphong_noitru"], "");
txtBuong.Text = Utility.sDbnull(dt_Patient.Rows[0][NoitruDmucBuong.Columns.TenBuong], "");
txtGiuong.Text = Utility.sDbnull(dt_Patient.Rows[0][NoitruDmucGiuongbenh.Columns.TenGiuong], "");
txtIdkhoanoitru.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.IdKhoanoitru], "-1");
txtIdravien.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.IdRavien], "-1");
txtidBuong.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.IdBuong], "-1");
txtidgiuong.Text = Utility.sDbnull(dt_Patient.Rows[0][KcbLuotkham.Columns.IdGiuong], "-1");
objPhieuchuyenvien = new Select().From(KcbPhieuchuyenvien.Schema)
.Where(KcbPhieuchuyenvien.Columns.IdBenhnhan).IsEqualTo(txtIdBn.Text)
.And(KcbPhieuchuyenvien.Columns.MaLuotkham).IsEqualTo(txtMaluotkham.Text)
.ExecuteSingle<KcbPhieuchuyenvien>();
if (objPhieuchuyenvien != null)
{
txtId.Text = objPhieuchuyenvien.IdPhieu.ToString();
txtNoichuyenden.SetId(objPhieuchuyenvien.IdBenhvienChuyenden);
txtdauhieucls._Text = objPhieuchuyenvien.DauhieuCls;
txtketquaCls.Text = objPhieuchuyenvien.KetquaXnCls;
txtChandoan.Text = objPhieuchuyenvien.ChanDoan;
txtThuocsudung.Text = objPhieuchuyenvien.ThuocSudung;
txtTrangthainguoibenh._Text = objPhieuchuyenvien.TrangthaiBenhnhan;
txtHuongdieutri._Text = objPhieuchuyenvien.HuongDieutri;
txtphuongtienvc._Text = objPhieuchuyenvien.PhuongtienChuyen;
txtNguoivanchuyen.Text = objPhieuchuyenvien.TenNguoichuyen;
cboDoctorAssign.SelectedIndex = Utility.GetSelectedIndex(cboDoctorAssign,Utility.sDbnull( objPhieuchuyenvien.IdBacsiChuyenvien,"-1"));
cmdPrint.Enabled = true;
cmdHuy.Enabled = true;
}
else
{
cmdPrint.Enabled = false;
cmdHuy.Enabled = false;
}
m_enAct = objPhieuchuyenvien == null ? action.Insert : action.Update;
if (m_enAct == action.Insert)
cmdPrint.Enabled = false;
else
cmdPrint.Enabled = true;
dtNgaychuyenvien.Focus();
}
}
}
catch (Exception)
{
Utility.ShowMsg("Có lỗi trong quá trình lấy thông tin bệnh nhân");
}
finally
{
AllowTextChanged = true;
}
}