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