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