public override void GetSql(DbTarget db_target, ref StringBuilder sql)
{
sql.Append(" UPDATE ");
sql.Append(Utils.FormatName(TableName, db_target));
sql.Append(" SET ");
if (_Columns != null && _Columns.Count > 0)
{
int colCount = _Columns.Count;
for (int x = 0; x < colCount; x++)
{
sql.Append(Utils.FormatName(_Columns[x].Name, db_target));
sql.Append(" = ");
_Columns[x].Value.GetSql(db_target, ref sql);
if (x + 1 < colCount)
{
sql.Append(",");
}
}
}
sql.Append(" ");
if (_Where != null && _Where.Count > 0)
{
_Where.GetSql(db_target, ref sql);
}
}
public override void GetSql(DbTarget db_target, ref StringBuilder sql)
{
sql.Append("DELETE FROM ");
sql.Append(Utils.FormatName(TableName, db_target));
sql.Append(" ");
if (_Where != null && _Where.Count > 0)
{
_Where.GetSql(db_target, ref sql);
}
}
