public int f_insert(CDT_history obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
//PHAU THUAT KTC
sql = "insert into " + schema + ".DT_HISTORY(ID,MABS,ID_LOAI,NOIDUNG,TUNGAY,DENNGAY,NGAY,NGAYUD,VALUE) ";
sql += " VALUES ( {ID},'{MABS}','{ID_LOAI}','{NOIDUNG}',{TUNGAY},{DENNGAY},{NGAY},sysdate,{VALUE})";
sql = sql.Replace("{ID}", m_option.f_get_capid(obj.Mabs));
sql = sql.Replace("{MABS}", obj.Mabs);
sql = sql.Replace("{ID_LOAI}", obj.Id_loai);
sql = sql.Replace("{NOIDUNG}", obj.Noidung);
sql = sql.Replace("{TUNGAY}", m_format.f_formatdata(obj.Tungay.ToString(), "date"));
sql = sql.Replace("{DENNGAY}", m_format.f_formatdata(obj.Denngay.ToString(), "date"));
sql = sql.Replace("{NGAY}", m_format.f_formatdata(obj.Ngay.ToString(), "date"));
sql = sql.Replace("{VALUE}", obj.Value.ToString());
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
public int f_update(CDT_history obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
//PHAU THUAT KTC
sql = "update " + schema + ".DT_HISTORY ";
sql += " SET ID={ID},MABS='MABS',ID_LOAI='ID_LOAI',NOIDUNG='NOIDUNG',TUNGAY={TUNGAY}, ";
sql += " DENNGAY={DENNGAY},NGAY={NGAY} ";
sql += " WHERE ID={ID}";
sql = sql.Replace("{ID}", obj.Id);
sql = sql.Replace("{MABS}", obj.Mabs);
sql = sql.Replace("{ID_LOAI}", obj.Id_loai);
sql = sql.Replace("{NOIDUNG}", obj.Noidung);
sql = sql.Replace("{TUNGAY}", m_format.f_formatdata(obj.Tungay.ToString(), "date"));
sql = sql.Replace("{DENNGAY}", m_format.f_formatdata(obj.Denngay.ToString(), "date"));
sql = sql.Replace("{NGAY}", m_format.f_formatdata(obj.Ngay.ToString(), "date"));
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
