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)
{
}
