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(); } }