public int f_updateBYT(d_dmbdbh obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = " update {schema}.d_dmbdbh ";
sql += " set ID_BYT='{ID_BYT}',BV_APTHAU='{BV_APTHAU}' ";
sql += " ,QD_STT='{QD_STT}',NGAYHIEULUC='{NGAYHIEULUC}',HIEULUCDEN='{HIEULUCDEN}' ";
sql += " ,SOQD_MUASAM='{SOQD_MUASAM}',NHOM_BYT='{NHOM_BYT}' ";
sql += " ,TEN_BYT='{TEN_BYT}' ";
sql += " where id={id} ";
sql = sql.Replace("{id}", obj.ID.ToString());
sql = sql.Replace("{schema}", schema);
sql = sql.Replace("{ID_BYT}", obj.Idbyt);
sql = sql.Replace("{BV_APTHAU}", obj.Bv_apthau);
sql = sql.Replace("{QD_STT}", obj.Qd_stt);
sql = sql.Replace("{NGAYHIEULUC}", obj.Ngayhieuluc);
sql = sql.Replace("{HIEULUCDEN}", obj.Hieulucden);
sql = sql.Replace("{SOQD_MUASAM}", obj.Sodq_muasam);
sql = sql.Replace("{NHOM_BYT}", obj.Nhom_bhyt);
sql = sql.Replace("{TEN_BYT}", obj.Ten_byt);
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
private void f_save()
{
try
{
d_dmbdbh item = new d_dmbdbh();
d_dmbdbh_Orace Ora_d_dmbdbh = new d_dmbdbh_Orace();
int i = 0;
foreach (DataGridViewRow row in dDanhMuc.Rows)
{
try
{
item.ID = long.Parse(row.Cells["MaTB"].Value.ToString());
item.ID_TYPE = row.Cells[2].Value.ToString();
item.ENABLE = (row.Cells[3].Value.ToString().CompareTo("True") == 0 || row.Cells[3].Value.ToString().CompareTo("1") == 0 ? 1 : 0);
item.BHYT = int.Parse(row.Cells["BHYT"].Value.ToString());
Ora_d_dmbdbh.f_update(item);
if (i > 30)
{
break;
}
else
{
i++;
}
}
catch { }
}
}
catch { }
}
private void f_update()
{
try{
d_dmbdbh item = new d_dmbdbh();
item.ID = long.Parse(txtID.Text);
item.Idbyt = txtidbyt.Text;
item.Bv_apthau = txtbvapthau.Text;
item.Ngayhieuluc = txtngayhl.Text;
item.Hieulucden = txthlden.Text;
item.Sodq_muasam = txtsqdmua.Text;
item.Nhom_bhyt = txtnhombyt.Text;
item.Ten_byt = txttenbyt.Text;
item.Qd_stt = txtqdstt.Text;
dmbd_oracle.f_updateBYT(item);
}catch {}
}
public DataTable getListBaoCao(d_dmbdbh obj)
{
DataTable dt_refult = new DataTable();
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = " select * from bv115.d_dmbdbh ";
sql = sql.Replace("@enable", obj.ENABLE.ToString());
DataSet ds = OracleData.get_data(sql);
dt_refult = ds.Tables[0];
}
catch
{
}
return(dt_refult);
}
public int f_update(d_dmbdbh obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = " update {schema}.d_dmbdbh ";
sql += " set id_type='@id_type',filter=@enable ,bhyt=@bhyt";
sql += " where id=@id ";
sql = sql.Replace("@id_type", obj.ID_TYPE);
sql = sql.Replace("@id", obj.ID.ToString());
sql = sql.Replace("@enable", obj.ENABLE.ToString());
sql = sql.Replace("@bhyt", obj.BHYT.ToString());
sql = sql.Replace("{schema}", schema);
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
