private void toolStripButton5_Click(object sender, EventArgs e) { try { DataTable dt = _MySQL.get_DanhSach("", dTKTuNgay.Value, dTKDenNgay.Value,"0").Tables[0]; CThanhToanBHYTOracle dOracle=new CThanhToanBHYTOracle(); string SoThe=""; foreach (DataRow dr in dt.Rows) { int Tong = 0; int BNtra=0; int BHYTtra=0; Tong = dOracle.f_loadTongTien_v_chidinh(dr["MaBN"].ToString(), dTKTuNgay.Value); if(Tong>f_getMucDongChiTra()) { SoThe=dr["SoThe"].ToString(); BNtra = Tong * (100 - TinhTiLeBHYTthanhtoan(SoThe, 0))/100; } BHYTtra=Tong-BNtra; dr["NoiDung"] = Tong.ToString() + "^" + BHYTtra.ToString(); } AccessData acc = new AccessData(); frmReport frm = new frmReport(acc, dt, "rpt_QuanLyTheBHYT_chuanhan.rpt", "rpt_QuanLyTheBHYT_chuanhan.rpt"); frm.Show(); } catch { } }
private void f_loadchidinh() { try { DataSet ds = new DataSet(); dDanhMuc.Rows.Clear(); if (txtMaBN.Text.Length == 8) { CThanhToanBHYTOracle dataOra = new CThanhToanBHYTOracle(); ds = dataOra.f_loadChiDinh_v_chidinh(txtMaBN.Text, dNgayCD.Value); try { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { dDanhMuc.Rows.Add(dr.ItemArray); } } catch { } } } catch { } }
private void btLoadCD_Click(object sender, EventArgs e) { try { DataSet ds=new DataSet(); if (txtMaMay.Text.Length == 8) { CThanhToanBHYTOracle dataOra=new CThanhToanBHYTOracle(); ds = dataOra.f_loadChiDinh(txtMaMay.Text, dNgayCD.Value); cbChiDinh.DataSource=ds.Tables[0]; cbChiDinh.DisplayMember="Tenvp"; cbChiDinh.ValueMember="ID";; } else { cbChiDinh.DataSource=ds.Tables[0]; } } catch { } }
private void txtMaMay_Leave(object sender, EventArgs e) { try { if (txtMaMay.Text.Length == 8) { CBenhNhan item = new CBenhNhan(); CBenhNhanOracle dataOra = new CBenhNhanOracle(); item = dataOra.getBenhNhan(txtMaMay.Text); txtTen.Text=item.HoTen + " ("+item.NamSinh+")"; CThanhToanBHYTOracle dataBHYTOra = new CThanhToanBHYTOracle(); CThanhToanBHYT bhyt = new CThanhToanBHYT(); bhyt = dataBHYTOra.f_loadTT_BHYT_TiepNhan(txtMaMay.Text,DateTime.Today); txtNguoiYC.Text = bhyt.SoTheBHYT ; txtHSD.Text = string.Format("{0:dd/MM/yyyy}", bhyt.HSD); setList(cbPhuongThuc, bhyt.TraiTuyen.ToString()); } else { txtTen.Text = ""; } } catch { } }
private void txtMaBN_Leave(object sender, EventArgs e) { try { if (txtMaBN.Text.Length == 8) { CBenhNhan item = new CBenhNhan(); CBenhNhanOracle dataOra = new CBenhNhanOracle(); item = dataOra.getBenhNhan(txtMaBN.Text); txtHoten.Text = item.HoTen; txtNamsinh.Text = item.NamSinh.ToString(); CThanhToanBHYTOracle dataBHYTOra = new CThanhToanBHYTOracle(); CThanhToanBHYT bhyt = new CThanhToanBHYT(); bhyt = dataBHYTOra.f_loadTT_BHYT_TiepNhan(txtMaBN.Text, DateTime.Today); txtSothe.Text = bhyt.SoTheBHYT; //txtHSD.Text = string.Format("{0:dd/MM/yyyy}", bhyt.HSD); //setList(cbPhuongThuc, bhyt.TraiTuyen.ToString()); //if(ckLuu.Checked==true) //{ // if (toolSave.Enabled == true) // { // SendKeys.Send("{F5}"); // } //} } else { txtHoten.Text = ""; } } catch { } }
private void f_LoadListUser() { try { CThanhToanBHYTOracle dataOracle = new CThanhToanBHYTOracle(); cbUser.DataSource = dataOracle.f_loadUser_v_chidinh(dNgayCD.Value).Tables[0]; cbUser.DisplayMember = "Ten"; cbUser.ValueMember = "ID"; } catch { } }
private void toolStripButton3_Click(object sender, EventArgs e) { AccessData d = new AccessData(); CThanhToanBHYTOracle data = new CThanhToanBHYTOracle(); //DataSet ds = data.f_loadBaoCaoMau20(tungay, denngay, ""); DataSet ds = data.f_getv_ttrvkp_ct_ALL(txtmabn.Text, txtmavaovien.Text, txtTuNgay.Value, txtDenNgay.Value); frmReport a = new frmReport(d, ds.Tables[0], "rpt_ttravien_kp_ct.rpt", "", "", "", "", "", "", "", "", "", ""); a.Show(); }
private void btLoadDSChuaDuyet_Click(object sender, EventArgs e) { string tungay = haison1.tungay; string denngay = haison1.denngay; CThanhToanBHYTOracle d = new CThanhToanBHYTOracle(); CThanhToanBHYTDAO data = new CThanhToanBHYTDAO(); string smabndaduyet = ""; _dsChuaDuyet = d.f_loadDanhSachCLSChuaDuyet(tungay, denngay, smabndaduyet); f_locdanhsachchuaduyet(txtTimKiemChuaDuyet.Text); }
private void f_loadchidinh() { try { DataSet ds = new DataSet(); dDanhMuc.Rows.Clear(); CThanhToanBHYTOracle dataOra = new CThanhToanBHYTOracle(); string iddaduyet = f_getListIDFrom_v_Chidinh(dNgayCD.Value); ds = dataOra.f_loadChiDinh_v_chidinh_MaBN(_MaBN, dNgayCD.Value, iddaduyet); try { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { dDanhMuc.Rows.Add(dr.ItemArray); } } catch { } } catch { } }