如何实现品牌标签管理软件：从概念到实施全解析

// 使用 Entity Framework Core Code First 定义核心领域模型
public class BrandAsset
{
    public Guid Id { get; set; }
    public string FileName { get; set; }
    public string StoragePath { get; set; }
    public long FileSize { get; set; }
    public string MimeType { get; set; }
    // 与标签的多对多关系
    public ICollection<AssetTag> AssetTags { get; set; } = new List<AssetTag>();
}

public class Tag
{
    public Guid Id { get; set; }
    public string Name { get; set; }
    public string Category { get; set; } // 如“场景”、“产品”、“版权”
    public Guid? ParentTagId { get; set; } // 支持层级标签
    public Tag ParentTag { get; set; }
    // 与资产的多对多关系
    public ICollection<AssetTag> AssetTags { get; set; } = new List<AssetTag>();
}

// 联结表实体
public class AssetTag
{
    public Guid BrandAssetId { get; set; }
    public BrandAsset BrandAsset { get; set; }
    public Guid TagId { get; set; }
    public Tag Tag { get; set; }
    public DateTime TaggedAt { get; set; } // 打标签时间
    public string TaggedBy { get; set; } // 操作人
}

// 示例：一个用于批量打标签的组件方法
class AssetTaggingService {
  /**
   * 为一批资产批量添加标签
   * @param {Array<string>} assetIds - 资产ID数组
   * @param {Array<string>} tagIds - 标签ID数组
   * @returns {Promise<BatchOperationResult>}
   */
  async batchTagAssets(assetIds, tagIds) {
    try {
      const response = await fetch('/api/assets/batch-tag', {
        method: 'POST',
        headers: { 'Content-Type': 'application/json' },
        body: JSON.stringify({ assetIds, tagIds }),
      });
      if (!response.ok) throw new Error(`批量操作失败: ${response.status}`);
      return await response.json();
    } catch (error) {
      console.error('批量打标签错误:', error);
      throw error;
    }
  }
}

// 示例：一个包含复杂标签筛选的资产查询服务
public class AssetSearchService
{
    private readonly ApplicationDbContext _context;

    public AssetSearchService(ApplicationDbContext context)
    {
        _context = context;
    }

    public async Task<PagedList<BrandAsset>> SearchAssetsAsync(
        string keyword,
        List<Guid> tagIds,
        int page = 1,
        int pageSize = 20)
    {
        var query = _context.BrandAssets.AsQueryable();

        // 关键词搜索（文件名或关联标签名）
        if (!string.IsNullOrWhiteSpace(keyword))
        {
            query = query.Where(a => a.FileName.Contains(keyword)
                || a.AssetTags.Any(at => at.Tag.Name.Contains(keyword)));
        }

        // 标签筛选：查找包含所有指定标签的资产
        if (tagIds != null && tagIds.Any())
        {
            foreach (var tagId in tagIds)
            {
                query = query.Where(a => a.AssetTags.Any(at => at.TagId == tagId));
            }
        }

        // 包含关联数据并分页
        var totalCount = await query.CountAsync();
        var items = await query
            .Include(a => a.AssetTags)
                .ThenInclude(at => at.Tag)
            .OrderByDescending(a => a.UploadedAt)
            .Skip((page - 1) * pageSize)
            .Take(pageSize)
            .ToListAsync();

        return new PagedList<BrandAsset>(items, totalCount, page, pageSize);
    }
}