public int f_updateBYT(v_giavpbh obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = " update bv115.v_giavpbh ";
sql += " set id_byt='{id_byt}',qd_stt='{s_qd_stt}',ten_byt='{s_ten_byt}',bhyt={bhyt},giacu={giacu}";
sql += " where id='{id}' ";
sql = sql.Replace("{id}", obj.ID.ToString());
sql = sql.Replace("{id_byt}", obj.Id_byt);
sql = sql.Replace("{s_qd_stt}", obj.Qd_stt);
sql = sql.Replace("{s_ten_byt}", obj.Ten_byt);
sql = sql.Replace("{bhyt}", obj.BHYT.ToString());
sql = sql.Replace("{giacu}", obj.Giacu.ToString());
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
private void f_update()
{
try{
v_giavpbh item = new v_giavpbh();
item.ID = long.Parse(txtID.Text);
item.Id_byt = txtidbyt.Text;
item.Ten_byt = txttenbyt.Text;
item.Qd_stt = txtqdstt.Text;
item.BHYT = int.Parse(txtBHYTtra.Text);
try {
item.Giacu = double.Parse(txtgiacu.Text);
}catch {}
data_oracle.f_updateBYT(item);
}catch {}
}
public DataTable getListBaoCao(v_giavpbh obj)
{
DataTable dt_refult = new DataTable();
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = " select * from bv115.v_giavpbh ";
sql = sql.Replace("@enable", obj.ENABLE.ToString());
DataSet ds = OracleData.get_data(sql);
dt_refult = ds.Tables[0];
}
catch
{
}
return(dt_refult);
}
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 { }
}
public int f_update(v_giavpbh obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = " update bv115.v_giavpbh ";
sql += " set id_type='{id_type}',filter={enable} ,ktcgoi={ktcgoi} ,bhyt={bhyt},id_byt='{id_byt}'";
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("{ktcgoi}", obj.Ktcgoi.ToString());
sql = sql.Replace("{bhyt}", obj.BHYT.ToString());
sql = sql.Replace("{id_byt}", obj.Id_byt.ToString());
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
