南通审计档案管理平台如何实现智能化高效管理？

// 审计档案实体模型
using System;
using System.Collections.Generic;

namespace AuditArchivePlatform.Models
{
    public class AuditArchive
    {
        public int Id { get; set; } // 主键
        public string ArchiveNumber { get; set; } // 档案号
        public string Title { get; set; } // 档案标题
        public int CategoryId { get; set; } // 分类ID
        public DateTime AuditDate { get; set; } // 审计日期
        public string Keywords { get; set; } // 关键词，用于智能检索
        public string DigitalFilePath { get; set; } // 数字化文件存储路径
        public string OCRTextContent { get; set; } // OCR识别的全文文本
        public DateTime CreateTime { get; set; } = DateTime.Now; // 创建时间
        public bool IsConfidential { get; set; } // 是否涉密

        // 导航属性
        public ArchiveCategory Category { get; set; }
        public ICollection BorrowRecords { get; set; }
    }

    // 档案分类实体
    public class ArchiveCategory
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public string Code { get; set; }
        public ICollection Archives { get; set; }
    }
}

// 档案检索服务示例
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace AuditArchivePlatform.Services
{
    public interface IArchiveSearchService
    {
        Task<>> IntelligentSearchAsync(string query, int? categoryId);
    }

    public class ArchiveSearchService : IArchiveSearchService
    {
        private readonly ArchiveDbContext _context;

        public ArchiveSearchService(ArchiveDbContext context)
        {
            _context = context;
        }

        // 智能检索方法：匹配档案号、标题、关键词及OCR全文内容
        public async Task<>> IntelligentSearchAsync(string query, int? categoryId)
        {
            var q = _context.AuditArchives.AsQueryable();

            // 按分类筛选
            if (categoryId.HasValue)
            {
                q = q.Where(a => a.CategoryId == categoryId.Value);
            }

            if (!string.IsNullOrWhiteSpace(query))
            {
                // 多条件联合查询，提升检索命中率
                q = q.Where(a => a.ArchiveNumber.Contains(query) ||
                                 a.Title.Contains(query) ||
                                 a.Keywords.Contains(query) ||
                                 (a.OCRTextContent != null && a.OCRTextContent.Contains(query)));
            }

            // 按审计日期倒序排列，返回最新档案
            return await q.OrderByDescending(a => a.AuditDate)
                          .Take(50) // 限制返回数量，提升性能
                          .ToListAsync();
        }
    }
}

// 数据库上下文定义
using Microsoft.EntityFrameworkCore;

namespace AuditArchivePlatform.Data
{
    public class ArchiveDbContext : DbContext
    {
        public ArchiveDbContext(DbContextOptions options)
            : base(options)
        {
        }

        public DbSet AuditArchives { get; set; }
        public DbSet ArchiveCategories { get; set; }
        public DbSet BorrowRecords { get; set; }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);

            // 配置实体关系及索引，优化查询性能
            modelBuilder.Entity(entity =>
            {
                entity.HasIndex(e => e.ArchiveNumber).IsUnique(); // 档案号唯一索引
                entity.HasIndex(e => e.CategoryId); // 分类ID索引
                entity.HasIndex(e => e.AuditDate); // 审计日期索引
                // 可配置全文索引（具体取决于数据库类型，如SQL Server的Full-Text Search）
            });

            modelBuilder.Entity(entity =>
            {
                entity.HasIndex(e => e.Code).IsUnique();
            });
        }
    }
}