public void Update(int tranUserId) { DatabaseAccessLayer dataAccessLayer = GetDatabaseAccessLayer(); QueryBuilder query = new QueryBuilder(); query.AddText("UPDATE "); query.AddTableName(this.GetTableName()); query.AddText("SET "); Field[] fields = GetFields(); for (int i = 0; i < fields.Length; i++) { if (i > 0) query.AddText(","); query.AddColumn(fields[i].ColumnName); query.AddText("="); query.AddParam(fields[i]); } if (this.HasAccessColumns() == true) { query.AddText(","); query.AddLastUpdate(tranUserId); } query.AddEqualsFilter(this.GetPrimaryKey()); int rows = dataAccessLayer.ExecuteUpdate(query); }
public void Remove(int tranUserId) { DatabaseAccessLayer dataAccessLayer = GetDatabaseAccessLayer(); QueryBuilder query = new QueryBuilder(); query.AddText("DELETE FROM"); query.AddTableName(this.GetTableName()); query.AddEqualsFilter(this.GetPrimaryKey()); dataAccessLayer.ExecuteDelete(query); }