public async Task AddAsync(ProducType entity, string userId) { var db = _databaseLocator.GetProductCenterManagementDatabase(); var tran = _databaseLocator.GetDbTransaction(db); StringBuilder sql = new StringBuilder(); sql.Append($" INSERT INTO {_TABLE} "); sql.Append(" (Id, ParentId, LevelCode, TypeName, TypeCode, SortOrder, CreatedById, CreatedAt) "); sql.Append($" VALUES "); sql.Append(" (nextval('PT'), @ParentId, @LevelCode, @TypeName, @TypeCode, @SortOrder, @CreatedById, NOW()) "); await db.ExecuteAsync(sql.ToString(), new { entity.ParentId, entity.LevelCode, entity.TypeCode, entity.TypeName, entity.SortOrder, CreatedById = userId }, tran); }
public async Task UpdateAsync(ProducType entity, string userId) { var db = _databaseLocator.GetProductCenterManagementDatabase(); var tran = _databaseLocator.GetDbTransaction(db); StringBuilder updatedParams = new StringBuilder(); if (!string.IsNullOrWhiteSpace(entity.TypeName)) { updatedParams.Append("TypeName = @TypeName,"); } if (entity.Deleted.HasValue) { updatedParams.Append("Deleted = @Deleted,"); updatedParams.Append("DeletedAt = NOW(),"); } if (!string.IsNullOrWhiteSpace(userId)) { updatedParams.Append("DeletedById = @DeletedById,"); } if (!string.IsNullOrWhiteSpace(userId)) { updatedParams.Append("UpdatedById = @UpdatedById,"); } if (!string.IsNullOrWhiteSpace(updatedParams.ToString())) { updatedParams.Append("UpdatedAt = NOW()"); await db.ExecuteAsync( $"UPDATE {_TABLE} SET {updatedParams.ToString()} WHERE Id=@Id ", new { entity.Id, entity.TypeName, entity.Deleted, DeletedById = userId, UpdatedById = userId, }, tran); } }