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 loadBHYT() { try { CBenhNhanOracle BNOracle = new CBenhNhanOracle(); BN = BNOracle.getBenhNhan(txtMaBN.Text); BN.HoTen = s_prepair(BN.HoTen); BN.DiaChi = s_prepair(BN.DiaChi); txtNamSinh.Text = BN.NamSinh.ToString(); txtHoTen.Text = BN.HoTen; txtDiaChi.Text = BN.DiaChi; f_setcbPhai(BN.GioiTinh); CThanhToanBHYTOracleNoiTru DataOracle = new CThanhToanBHYTOracleNoiTru(); DataSet dsdotdt = DataOracle.f_loadNgayNhapVien_MaQL(txtMaBN.Text, haison1.tungay, haison1.denngay, ckLocNgay.Checked); cbdotdieutri.DataSource = null; cbdotdieutri.DataSource = dsdotdt.Tables[0]; cbdotdieutri.DisplayMember = "dotdieutri"; cbdotdieutri.ValueMember = "mavaovien"; cbdotdieutri.SelectedIndex = 0; //btLuu.Select(); txtMaBN.Enabled = false; } 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 { } }
public void Insert(CBenhNhan bn) { sql = "Insert into btdbn(mabn,hoten,namsinh,thon,phai)"; sql += " values('" + bn.MaBN + "',N'" + bn.HoTen + "','" + bn.NamSinh + "',N'" + bn.DiaChi + "'," + bn.GioiTinh + ")"; CConnection data = new CConnection(); data.setData(sql); }
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 loadBHYT() { try { CBenhNhanOracle BNOracle = new CBenhNhanOracle(); BN = BNOracle.getBenhNhan(txtMaBN.Text); BN.HoTen = s_prepair(BN.HoTen); BN.DiaChi = s_prepair(BN.DiaChi); txtNamSinh.Text = BN.NamSinh.ToString(); txtHoTen.Text = BN.HoTen; txtDiaChi.Text = BN.DiaChi; f_setcbPhai(BN.GioiTinh); } catch { } }
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 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 + ")"; } 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); txtTen.Text = item.HoTen; txtNamSinh.Text = item.NamSinh.ToString(); } else { txtTen.Text = ""; } } catch { } }
public CBenhNhan getBenhNhan(string MaBN) { CBenhNhan bn = new CBenhNhan(); sql = "select bn.hoten,bn.namsinh,bn.phai,bn.sonha,bn.thon,tt.tentt, q.tenquan, px.tenpxa, bn.cholam "; sql += "from btdbn bn,btdtt tt,btdquan q,btdpxa px "; sql += " where bn.mabn='" + MaBN + "' and bn.matt=tt.matt and bn.maqu=q.maqu and bn.maphuongxa=px.maphuongxa"; DataSet dset = new DataSet(); try { dset = data.get_data(sql); bn.MaBN = MaBN; bn.HoTen = dset.Tables[0].Rows[0]["HOTEN"].ToString(); bn.NamSinh = int.Parse(dset.Tables[0].Rows[0]["NAMSINH"].ToString()); bn.GioiTinh = int.Parse(dset.Tables[0].Rows[0]["PHAI"].ToString()); bn.DiaChi = dset.Tables[0].Rows[0]["SONHA"].ToString() + " " + dset.Tables[0].Rows[0]["THON"].ToString() + ", " + dset.Tables[0].Rows[0]["TENPXA"].ToString() + ", " + dset.Tables[0].Rows[0]["TENQUAN"].ToString() + ", " + dset.Tables[0].Rows[0]["TENTT"].ToString(); } catch { } return(bn); }
public void Insert(CBenhNhan bn) { }