public void CariPasien(string NoReg)
{
string SQL;
SqlDataReader ObjReader;
bool vAda = true;
SqlCommand oCmd = default;
SQL = SQLCariPasien(NoReg, false);
if (clMain.DBConn.DBOpenConnection() == 0)
{
oCmd = new SqlCommand(SQL, clMain.DBConn.objConnection);
// oCmd.Connection = clMain.clUtama.objConnection
oCmd.CommandTimeout = 0;
ObjReader = oCmd.ExecuteReader(); // clMain.clUtama.GeneralQuery(SQL)
oCmd.Dispose();
if (ObjReader.HasRows)
{
ObjReader.Read();
txtNoReg.Text = ObjReader["vc_no_reg"].ToString();
txtNoRM.Text = ObjReader["vc_no_rm"].ToString();
LblNama.Text = ObjReader["vc_nama_p"].ToString();
LblAlamat.Text = ObjReader["vc_alamat"].ToString();
LblKel.Text = ObjReader["vc_kelurahan"].ToString();
LblKec.Text = ObjReader["vc_kecamatan"].ToString();
LblKota.Text = ObjReader["vc_kota"].ToString();
LblTahun.Text = ObjReader["in_umurth"].ToString() + " Tahun";
LblBulan.Text = ObjReader["in_umurbl"].ToString() + " Bulan";
LblHari.Text = ObjReader["in_umurhr"].ToString() + " Hari";
LblJnsKel.Text = ObjReader["vc_jenis_k"].ToString();
LblKelas.Text = ObjReader["vc_kelas"].ToString();
LblKamar.Text = ObjReader["vc_nama"].ToString();
LblKdDr.Text = ObjReader["vc_nid"].ToString() + " -" + ObjReader["vc_NAMA_KRY"].ToString();
LblRuang.Text = ObjReader["vc_n_ruang"].ToString();
m_TglMasuk = (DateTime)ObjReader["dt_tgl_msk"];
this.dtTglAwal.Value = m_TglMasuk;
lblPng.Text = ObjReader["vc_n_png"].ToString();
LblKodePng.Text = ObjReader["vc_k_png"].ToString();
m_KlasTrans = ObjReader["vc_kd_gsklco"].ToString() + ObjReader["vc_k_kelas"].ToString();
if (Information.IsDBNull(ObjReader["bt_hak_akpn"]) == true)
{
m_Hak_AKPN = false;
}
else if ((bool)ObjReader["bt_hak_akpn"] == true)
{
m_Hak_AKPN = true;
}
else
{
m_Hak_AKPN = false;
}
if (Information.IsDBNull(ObjReader["dt_tgl_pul"]))
{
m_Pulang = false;
}
else if (ObjReader["dt_tgl_pul"].ToString() != "")
{
m_Pulang = true;
}
else
{
m_Pulang = false;
}
if (Information.IsDBNull(ObjReader["bt_print_pulang"]) == true)
{
m_KuitPrinted = false;
}
else if ((bool)ObjReader["bt_print_pulang"] == true)
{
m_KuitPrinted = true;
}
else
{
m_KuitPrinted = false;
}
// Mengambil Data Keubayar
}
else
{
vAda = false;
MsgBoxUtil.MsgInfo("Data pasien tidak ditemukan !");
}
ObjReader.Close();
}
this.Refresh();
if (vAda)
{
m_Bayar = GetKuitansiBayar(txtNoReg.Text);
FillGridRincian();
HitungTotal();
}
}