private string CreateUpdateSql(ModelBase model)
{
var cols = model.GetModifColumnsField();
if (cols.Count == 0)
{
return(string.Empty);
}
var sql = $"UPDATE {model.TableName} SET {{0}} WHERE Id = {model.Id}";
var updates = new StringBuilder();
foreach (dynamic col in cols)
{
if (col is Many2Many ||
col is Many2One ||
col is One2Many)
{
continue;
}
if (updates.Length == 0)
{
updates.Append($"{col.ColumnName} = {col.ColumnValue}");
}
else
{
updates.Append($",{col.ColumnName} = {col.ColumnValue}");
}
}
return(string.Format(sql, updates.ToString()));
}
