public int f_update(v_bhytll obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = "update " + schema + ".e_bhytll ";
sql += " set SOPHIEU={SOPHIEU},UBNDTRA={UBNDTRA} ";
sql += " where id={ID} ";
sql = sql.Replace("{ID}", obj.ID.ToString());
sql = sql.Replace("{SOPHIEU}", m_format.f_formatdata(obj.SOPHIEU));
sql = sql.Replace("{UBNDTRA}", obj.UBNDTRA.ToString());
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
public int f_insert(v_bhytll obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
//PHAU THUAT KTC
sql = "insert into " + schema + ".e_bhytll(ID,DIEMTHU,LOAIBN,LOAI,QUYENSO,SOBIENLAI,NGAY,MAKP,SOTIEN,TAMUNG,MIEN,";
sql += "BHYT,NOPTHEM,THIEU,VATTU,LANIN,IDTONGHOP,CHENHLECH,THUA,KETOAN,QUYENSODV,SOBIENLAIDV,BHYTGHICHU,";
sql += "USERID,USERIDNL,MIENCS,MIENDV,MIENCS_NGAYTT,NGAYUD,SOPHIEU,QUYENSOQUYETTOAN,KHAMBENH,THUOC,MAU,";
sql += " XETNGHIEM,CDHA,DVKTTHUONG,DVKTCAO,VTTH,CPVC,TDCN,GIUONG,KHAC,TILEHUONG,TILETHE,THUOCK,UBNDTRA,VTYTTL) values ";
sql += " ({ID},{DIEMTHU},{LOAIBN},{LOAI},{QUYENSO},{SOBIENLAI},{NGAY},{MAKP},{SOTIEN},{TAMUNG},{MIEN},";
sql += "{BHYT},{NOPTHEM},{THIEU},{VATTU},{LANIN},{IDTONGHOP},{CHENHLECH},{THUA},{KETOAN},{QUYENSODV},{SOBIENLAIDV},{BHYTGHICHU},";
sql += "{USERID},{USERIDNL},{MIENCS},{MIENDV},{MIENCS_NGAYTT},{NGAYUD},{SOPHIEU},{QUYENSOQUYETTOAN},{KHAMBENH},{THUOC},{MAU},";
sql += "{XETNGHIEM},{CDHA},{DVKTTHUONG},{DVKTCAO},{VTTH},{CPVC},{TDCN},{GIUONG},{KHAC},{TILEHUONG},{TILETHE},{THUOCK},{UBNDTRA},{VTYTTL})";
sql = sql.Replace("{ID}", obj.ID.ToString());
sql = sql.Replace("{DIEMTHU}", obj.DIEMTHU.ToString());
sql = sql.Replace("{LOAIBN}", obj.LOAIBN.ToString());
sql = sql.Replace("{LOAI}", obj.LOAI.ToString());
sql = sql.Replace("{QUYENSO}", obj.QUYENSO.ToString());
sql = sql.Replace("{SOBIENLAI}", obj.SOBIENLAI.ToString());
sql = sql.Replace("{NGAY}", m_format.f_formatdata(obj.NGAY.ToString(), "date"));
sql = sql.Replace("{MAKP}", m_format.f_formatdata(obj.MAKP.ToString()));
sql = sql.Replace("{SOTIEN}", obj.SOTIEN.ToString());
sql = sql.Replace("{TAMUNG}", obj.TAMUNG.ToString());
sql = sql.Replace("{MIEN}", obj.MIEN.ToString());
sql = sql.Replace("{BHYT}", obj.BHYT.ToString());
sql = sql.Replace("{UBNDTRA}", obj.UBNDTRA.ToString());
sql = sql.Replace("{NOPTHEM}", obj.NOPTHEM.ToString());
sql = sql.Replace("{THIEU}", obj.THIEU.ToString());
sql = sql.Replace("{VATTU}", obj.VATTU.ToString());
sql = sql.Replace("{LANIN}", obj.LANIN.ToString());
sql = sql.Replace("{IDTONGHOP}", obj.IDTONGHOP.ToString());
sql = sql.Replace("{CHENHLECH}", obj.CHENHLECH.ToString());
sql = sql.Replace("{THUA}", obj.THUA.ToString());
sql = sql.Replace("{KETOAN}", obj.KETOAN.ToString());
sql = sql.Replace("{QUYENSODV}", obj.QUYENSODV.ToString());
sql = sql.Replace("{SOBIENLAIDV}", obj.SOBIENLAIDV.ToString());
sql = sql.Replace("{BHYTGHICHU}", m_format.f_formatdata(obj.BHYTGHICHU.ToString()));
sql = sql.Replace("{USERID}", obj.USERID.ToString());
sql = sql.Replace("{USERIDNL}", obj.USERIDNL.ToString());
sql = sql.Replace("{MIENCS}", obj.MIENCS.ToString());
sql = sql.Replace("{MIENDV}", obj.MIENDV.ToString());
sql = sql.Replace("{MIENCS_NGAYTT}", m_format.f_formatdata(obj.MIENCS_NGAYTT.ToString(), "date"));
sql = sql.Replace("{NGAYUD}", m_format.f_formatdata(obj.NGAYUD.ToString(), "date"));
sql = sql.Replace("{SOPHIEU}", obj.SOPHIEU.ToString());
sql = sql.Replace("{QUYENSOQUYETTOAN}", obj.QUYENSOQUYETTOAN.ToString());
sql = sql.Replace("{KHAMBENH}", obj.KHAMBENH.ToString());
sql = sql.Replace("{THUOC}", obj.THUOC.ToString());
sql = sql.Replace("{MAU}", obj.MAU.ToString());
sql = sql.Replace("{XETNGHIEM}", obj.XETNGHIEM.ToString());
sql = sql.Replace("{CDHA}", obj.CDHA.ToString());
sql = sql.Replace("{DVKTTHUONG}", obj.DVKTTHUONG.ToString());
sql = sql.Replace("{DVKTCAO}", obj.DVKTCAO.ToString());
sql = sql.Replace("{VTTH}", obj.VTTH.ToString());
sql = sql.Replace("{CPVC}", obj.CPVC.ToString());
sql = sql.Replace("{TDCN}", obj.TDCN.ToString());
sql = sql.Replace("{GIUONG}", obj.GIUONG.ToString());
sql = sql.Replace("{KHAC}", obj.KHAC.ToString());
sql = sql.Replace("{TILETHE}", obj.TILETHE.ToString());
sql = sql.Replace("{TILEHUONG}", obj.TILEHUONG.ToString());
sql = sql.Replace("{THUOCK}", obj.THUOCK.ToString());
sql = sql.Replace("{VTYTTL}", obj.VTYTTL.ToString());
// string id1 = OraData.f_get_capid(userid);
result = OracleData.f_execute_data(sql);
}catch
{
}
return(result);
}
