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); }