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