/// <summary>
/// 设置软删除
/// </summary>
private string BuildSoftDeleteSql(out string softDeleteSingleSql)
{
softDeleteSingleSql = string.Empty;
if (!_descriptor.IsSoftDelete)
{
return(string.Empty);
}
var sb = new StringBuilder("UPDATE {0} SET ");
sb.AppendFormat("{0}={1},", AppendQuote(_descriptor.GetDeletedColumnName()), _descriptor.SqlAdapter.SqlDialect == SqlDialect.PostgreSQL ? "TRUE" : "1");
sb.AppendFormat("{0}={1},", AppendQuote(_descriptor.GetDeletedTimeColumnName()), AppendParameter("DeletedTime"));
sb.AppendFormat("{0}={1} ", AppendQuote(_descriptor.GetDeletedByColumnName()), AppendParameter("DeletedBy"));
var softDeleteSql = sb.ToString();
if (!_descriptor.PrimaryKey.IsNo())
{
sb.AppendFormat(" WHERE {0}={1}", AppendQuote(_primaryKey.Name), AppendParameter(_primaryKey.PropertyInfo.Name));
//多租户
if (_descriptor.IsEnableTenant())
{
sb.AppendFormat(" AND {0}={1};", AppendQuote(_descriptor.TenantIdColumnName), TENANT_ID_PLACEHOLDER);
}
softDeleteSingleSql = sb.ToString();
}
return(softDeleteSql);
}
/// <summary>
/// 设置软删除
/// </summary>
private string BuildSoftDeleteSql(out string softDeleteSingleSql)
{
if (!_descriptor.SoftDelete)
{
softDeleteSingleSql = string.Empty;
return(string.Empty);
}
var sb = new StringBuilder("UPDATE {0} SET ");
sb.AppendFormat("{0}={1},", AppendQuote(_descriptor.GetDeletedColumnName()), _descriptor.SqlAdapter.SqlDialect == SqlDialect.PostgreSQL ? "TRUE" : "1");
sb.AppendFormat("{0}={1},", AppendQuote(_descriptor.GetDeletedTimeColumnName()), AppendParameter("DeletedTime"));
sb.AppendFormat("{0}={1} ", AppendQuote(_descriptor.GetDeletedByColumnName()), AppendParameter("DeletedBy"));
var softDeleteSql = sb.ToString();
sb.AppendFormat(" WHERE {0}={1};", AppendQuote(_primaryKey.Name), AppendParameter(_primaryKey.PropertyInfo.Name));
softDeleteSingleSql = sb.ToString();
return(softDeleteSql);
}
