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