private void toolStripButton2_Click(object sender, EventArgs e)
{
string reportname = "xuat_excel.rpt";
v_giavpbh_Oracle Ora_dmbd = new v_giavpbh_Oracle();
DataTable dt = new DataTable();
AccessData d = new AccessData();
dt = Ora_dmbd.getListBaoCaoFromChoice(m_format.DateTime_parse(haison1.tungay), m_format.DateTime_parse(haison1.denngay), cbLoaiBN.SelectedIndex.ToString());
frmReport a = new frmReport(d, dt, reportname, "TỪ NGÀY " + haison1.tungay + " ĐẾN NGÀY " + haison1.denngay, "", "", "", "", "", "", "", "", "");
a.Show();
}
private void f_loadDanhSach()
{
try
{
dDanhMuc.Rows.Clear();
v_giavpbh_Oracle ora_danhmuc = new v_giavpbh_Oracle();
dt_dmbd = ora_danhmuc.get_danhmucvp_bhyt("");
foreach (DataRow dr in dt_dmbd.Rows)
{
dDanhMuc.Rows.Add(dr.ItemArray);
}
// dDanhMuc.DataSource = dt_dmbd;
}
catch { }
}
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.Rows.Clear();
v_giavpbh_Oracle ora_danhmuc = new v_giavpbh_Oracle();
dt_dmbd = ora_danhmuc.get_danhmucvp_bhyt(txtsearch.Text);
foreach (DataRow dr in dt_dmbd.Rows)
{
dDanhMuc.Rows.Add(dr.ItemArray);
}
//foreach (DataGridViewRow dr in dDanhMuc.Rows)
//{
// if (dr.Cells["ten"].Value.ToString().IndexOf(txtsearch.Text) > -1)
// {
// dr.Visible = true;
// }
// else
// {
// dr.Visible = false;
// }
//}
// 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 button1_Click(object sender, EventArgs e)
{
v_giavpbh_Oracle data = new v_giavpbh_Oracle();
foreach (DataGridViewRow row in dGrid.Rows)
{
if (row.IsNewRow == false)
{
string s_id = row.Cells["id"].Value.ToString();
string s_ten37 = row.Cells["ten37"].Value.ToString();
string s_gia37 = row.Cells["gia37"].Value.ToString();
string s_stt37 = row.Cells["stt37"].Value.ToString();
data.f_update_medibv115_v_giavp(s_id, s_ten37, s_gia37, s_stt37);
}
}
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
string reportname = "xuat_excel.rpt";
v_giavpbh_Oracle Ora_dmbd = new v_giavpbh_Oracle();
DataTable dt = new DataTable();
AccessData d = new AccessData();
dt = Ora_dmbd.getListBaoCaoFromList_ICU(m_format.DateTime_parse(haison1.tungay), m_format.DateTime_parse(haison1.denngay), cbLoaiBN.SelectedIndex.ToString(), txtMaVPChoice.Text);
/*
* foreach (DataRow row in dt.Rows)
* {
*
* row["ketluan"] = f_convert_from_RTF(row["ketluan"].ToString());
* }*/
frmReport a = new frmReport(d, dt, reportname, "TỪ NGÀY " + haison1.tungay + " ĐẾN NGÀY " + haison1.denngay, "", "", "", "", "", "", "", "", "");
a.Show();
}
private void f_save()
{
try
{
v_giavpbh item = new v_giavpbh();
v_giavpbh_Oracle Ora_v_giavpbh = new v_giavpbh_Oracle();
foreach (DataGridViewRow row in dDanhMuc.Rows)
{
try
{
item.ID = long.Parse(row.Cells["MaTB"].Value.ToString());
item.ID_TYPE = row.Cells["cbloai"].Value.ToString();
item.ENABLE = (row.Cells["filter"].Value.ToString().CompareTo("True") == 0 || row.Cells[3].Value.ToString().CompareTo("1") == 0 ? 1 : 0);
item.BHYT = int.Parse(row.Cells["BHYT"].Value.ToString());
item.Id_byt = row.Cells["id_byt"].Value.ToString();
item.Ktcgoi = (row.Cells["ktcgoi"].Value.ToString().CompareTo("True") == 0 || row.Cells[3].Value.ToString().CompareTo("1") == 0 ? 1 : 0);
Ora_v_giavpbh.f_update(item);
}
catch { }
}
}
catch { }
}
