private void txtsearch_TextChanged(object sender, EventArgs e)
{
try
{
dDanhMuc.Rows.Clear();
CDanhMucOracle ora_danhmuc = new CDanhMucOracle();
dt_dmbd = ora_danhmuc.get_danhmucbd_bhyt(txtsearch.Text);
foreach (DataRow dr in dt_dmbd.Rows)
{
dDanhMuc.Rows.Add(dr.ItemArray);
}
// dDanhMuc.DataSource = dt_dmbd;
}
catch { }
//try
//{
// foreach (DataGridViewRow dr in dDanhMuc.Rows)
// {
// if (dr.Cells["ten"].Value.ToString().ToLower().IndexOf(txtsearch.Text.ToLower()) > 0)
// dr.Visible = true;
// else
// dr.Visible = false;
// }
//}
//catch { }
}
private void f_loadcbb()
{
try
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
DataTable dtdm_khoaphong = dataOracle.d_getDMKhoaPhongFromLoai("0");
cbDanhMucKP.DataSource = dtdm_khoaphong;
cbDanhMucKP.DisplayMember = "TEN";
cbDanhMucKP.ValueMember = "ID";
cbDanhMucKP.SelectedIndex = 0;
DataTable dtdm_nhomnhanvien = dataOracle.d_getnhomnhanvien();
cbNhom.DataSource = dtdm_nhomnhanvien;
cbNhom.DisplayMember = "TEN";
cbNhom.ValueMember = "ID";
cbNhom.SelectedIndex = 0;
DataTable dtdm_trinhdo = dataOracle.d_gettrinhdo();
cbtrinhdo.DataSource = dtdm_trinhdo;
cbtrinhdo.DisplayMember = "TEN";
cbtrinhdo.ValueMember = "ID";
cbtrinhdo.SelectedIndex = 0;
DataTable dtdm_chuyenkhoa = dataOracle.d_getchuyenkhoa();
cbchuyenkhoa.DataSource = dtdm_chuyenkhoa;
cbchuyenkhoa.DisplayMember = "TEN";
cbchuyenkhoa.ValueMember = "ID";
cbchuyenkhoa.SelectedIndex = 0;
}
catch { }
}
private void frmBCDuocMau20_Load(object sender, EventArgs e)
{
cbLoai.SelectedIndex = 0;
CDanhMucOracle dm = new CDanhMucOracle();
treeView_HAISON1.setDataSource(dm.d_getDMNhomCDHA(AccessData._NHOM_CDHA), "ten", "id", "Danh mục Nhóm BHYT", false, "Chọn Nhóm CDHA để báo cáo");
}
private void f_init_addmodul()
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
DMNV_Oracle nv_Oracle = new DMNV_Oracle();
DataTable dtdm_dichvu = nv_Oracle.f_get("");
listicd10.DataSource = dtdm_dichvu;
listicd10.DisplayMember = "HOTEN";
listicd10.ValueMember = "MA";
/*DataTable dtdm_khoaphong = dataOracle.d_getDMKhoaPhong();
* cbDanhMucKP.DataSource = dtdm_khoaphong;
* cbDanhMucKP.DisplayMember = "TEN";
* cbDanhMucKP.ValueMember = "ID";
* cbDanhMucKP.SelectedIndex = 0;*/
DataTable dtdm_dt_loai = dataOracle.d_getDMDT_LOAI(S_idnhom);
cbLoai.DataSource = dtdm_dt_loai;
cbLoai.DisplayMember = "TEN";
cbLoai.ValueMember = "ID";
cbLoai.SelectedIndex = 0;
}
private void f_load()
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
DMNV_Oracle nv_Oracle = new DMNV_Oracle();
DataTable dtdm_dichvu = nv_Oracle.f_get("");
dgridChiTiet.DataSource = dtdm_dichvu;
}
private void frmBCDuocMau20_Load(object sender, EventArgs e)
{
cbLoai.SelectedIndex = 0;
DSMauC79_80a_HD();
CDanhMucOracle dm = new CDanhMucOracle();
treeView_HAISON1.setDataSource(dm.d_getDMNhomBHYT(), "ten", "id", "Danh mục Nhóm BHYT", false, "Chọn Nhóm BHYT để báo cáo");
init_cbloaibc();
}
private void cbLoaiBC_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
CDanhMucOracle oracle_danhmuc = new CDanhMucOracle();
stypereport = oracle_danhmuc.d_getDM_BCDieuKien_FromID(cbLoaiBC.SelectedValue.ToString());
}
catch { }
//MessageBox.Show(stypereport);
}
private void f_load()
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
DMNV_Oracle nv_Oracle = new DMNV_Oracle();
DataTable dtdm_dichvu = dmbd_oracle.getBYT_d_dmbd("");
dgridChiTiet.DataSource = dtdm_dichvu;
}
private void init_cbloaibc()
{
try {
CDanhMucOracle dataOracle = new CDanhMucOracle();
DataTable dtdm_loaibc = dataOracle.d_getDM_BCDieuKien("");
cbLoaiBC.DataSource = dtdm_loaibc;
cbLoaiBC.DisplayMember = "TEN";
cbLoaiBC.ValueMember = "MA";
cbLoaiBC.SelectedIndex = 0;
}
catch { }
}
private void cbLoaiBC_SelectedIndexChanged_1(object sender, EventArgs e)
{
try
{
CDanhMucOracle oracle_danhmuc = new CDanhMucOracle();
stypereport = oracle_danhmuc.d_getDM_BCDieuKien_FromID(cbLoaiBC.SelectedValue.ToString());
s_tenreport = oracle_danhmuc.d_getDM_BCDieuKien_TenReport_FromID(cbLoaiBC.SelectedValue.ToString());
s_tieuDeExcel = oracle_danhmuc.d_getDM_BCDieuKien_TieuDeExcel_FromID(cbLoaiBC.SelectedValue.ToString());
s_tenBaoCao = oracle_danhmuc.d_getDM_BCDieuKien_TenBaoCao_FromID(cbLoaiBC.SelectedValue.ToString());
}
catch { }
}
private void init_cbloaiyc()
{
try
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
DataTable dtdm_loaibc = dataOracle.get_NHOMXHH();
cbLoai.DataSource = dtdm_loaibc;
cbLoai.DisplayMember = "NAME";
cbLoai.ValueMember = "ID";
}
catch { }
}
private void initcbkhu()
{
try
{
CDanhMucOracle DMOracle = new CDanhMucOracle();
cbkhu.DataSource = DMOracle.d_getDMKHU("");
cbkhu.DisplayMember = "Name";
cbkhu.ValueMember = "ID";
cbkhu.SelectedIndex = 0;
}
catch { }
}
private void CanhBao()
{
if (ckKhamBenh.Checked == true)
{
CDanhMucOracle OraDanhmuc = new CDanhMucOracle();
double khambenh = double.Parse(f_clearDot(txtKhamBenh.Text));
if (khambenh != _khambenh)
{
MessageBox.Show("Vui lòng kiểm tra tiền khám!");
}
}
}
private void frmDuyetBHYT_Load(object sender, EventArgs e)
{
BN = new CBenhNhan();
BHYT = new CThanhToanBHYT();
CDanhMucOracle OraDanhmuc = new CDanhMucOracle();
_khambenh = OraDanhmuc.f_getgiaVP("30228");
lbkhu.Text = AccessData.s_tenkhuvuc;
//f_init_addmodul();
Listthuock = new List <string>();
d_dmbdbh_Orace ora_dmbd = new d_dmbdbh_Orace();
Listthuock = ora_dmbd.getDanhSachThuocK();
}
private void f_loadDanhSach()
{
try
{
dDanhMuc.Rows.Clear();
CDanhMucOracle ora_danhmuc = new CDanhMucOracle();
DataTable dt = ora_danhmuc.get_danhmuc(_tableName, -1);
foreach (DataRow dr in dt.Rows)
{
dDanhMuc.Rows.Add(dr.ItemArray);
}
}
catch { }
}
private void init_cbKhoaPhong()
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
bv_dlogin log = new bv_dlogin();
CLoginOracle logOra = new CLoginOracle();
log = logOra.f_getUser(AccessData.m_userid);
System.Data.DataTable dtdm_khoaphong = dataOracle.d_getDMKhoaPhong(log.Khoaphong);
//System.Data.DataTable dtdm_khoaphong = dataOracle.d_getDMKhoaPhong();
cbDanhMucKP.DataSource = dtdm_khoaphong;
cbDanhMucKP.DisplayMember = "TEN";
cbDanhMucKP.ValueMember = "ID";
cbDanhMucKP.SelectedIndex = 0;
}
private void frmDuyetBHYT_Load(object sender, EventArgs e)
{
BN = new CBenhNhan();
BHYT = new CThanhToanBHYT();
CDanhMucOracle OraDanhmuc = new CDanhMucOracle();
_khambenh = OraDanhmuc.f_getgiaVP("30228");
lbkhu.Text = AccessData.s_tenkhuvuc;
panel1.Visible = false;
panel2.Visible = false;
d_dmbdbh_Orace ora_dmbd = new d_dmbdbh_Orace();
init();
}
private void f_loadDanhSach()
{
try
{
dDanhMuc.Rows.Clear();
CDanhMucOracle ora_danhmuc = new CDanhMucOracle();
dt_dmbd = ora_danhmuc.get_danhmucbd_bhyt("");
foreach (DataRow dr in dt_dmbd.Rows)
{
dDanhMuc.Rows.Add(dr.ItemArray);
}
// dDanhMuc.DataSource = dt_dmbd;
}
catch { }
}
private void f_init_addmodul()
{
CDanhMucOracle dataOracle = new CDanhMucOracle();
DataTable dtdm_dichvu = dataOracle.f_getDMDuoc_VienPhi();
listicd10.DataSource = dtdm_dichvu;
listicd10.DisplayMember = "TEN";
listicd10.ValueMember = "ID";
DataTable dtdm_khoaphong = dataOracle.d_getDMKhoaPhong();
cbDanhMucKP.DataSource = dtdm_khoaphong;
cbDanhMucKP.DisplayMember = "TEN";
cbDanhMucKP.ValueMember = "ID";
cbDanhMucKP.SelectedIndex = 0;
cbdoituong.DataSource = dataOracle.d_getDMDoiTuong();
cbdoituong.DisplayMember = "ten";
cbdoituong.ValueMember = "ma";
cbdoituong.SelectedIndex = 0;
}
private void f_loadct()
{
try {
CDanhMucOracle dataOracle = new CDanhMucOracle();
DMNV_Oracle nv_Oracle = new DMNV_Oracle();
DataTable dtdm_chitiet = nv_Oracle.f_getbyid(txtID.Text);
txtHoTen.Text = dtdm_chitiet.Rows[0]["HOTEN"].ToString();
txtDiaChi.Text = dtdm_chitiet.Rows[0]["DIACHI"].ToString();
txtDienThoai.Text = dtdm_chitiet.Rows[0]["DIENTHOAI"].ToString();
dngaysinh.Value = m_format.DateTime_parse(dtdm_chitiet.Rows[0]["NGAYSINH"].ToString());
txtNgoaiNgu.Text = dtdm_chitiet.Rows[0]["NGONNGU"].ToString();
setList(cbchuyenkhoa, dtdm_chitiet.Rows[0]["CHUYENKHOA"].ToString());
txtbangcap.Text = dtdm_chitiet.Rows[0]["BANGCAP"].ToString();
txtdtnuocngoai.Text = dtdm_chitiet.Rows[0]["DTNUOCNGOAI"].ToString();
txtkinhnghiem.Text = dtdm_chitiet.Rows[0]["KINHNGHIEM"].ToString();
setList(cbtrinhdo, dtdm_chitiet.Rows[0]["TRINHDO"].ToString());
setList(cbDanhMucKP, dtdm_chitiet.Rows[0]["MAKP"].ToString());
setList(cbNhom, dtdm_chitiet.Rows[0]["MANHOM"].ToString());
string s_phai = dtdm_chitiet.Rows[0]["PHAI"].ToString();
cbPhai.SelectedIndex = int.Parse(s_phai);
}
catch { }
}
private void txtSL_Leave(object sender, EventArgs e)
{
CDanhMucOracle OraDanhmuc = new CDanhMucOracle();
txtDonGia.Text = OraDanhmuc.f_getgiaVP(tl_danhmuc.get_id()).ToString();
}
