如何搭建设备管理系统？从 0 到 1 全面搭建指南（含步骤拆解）

// 设备实体类示例
public class Equipment
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Model { get; set; }
    public string SerialNumber { get; set; }
    public DateTime PurchaseDate { get; set; }
    public decimal PurchasePrice { get; set; }
    public EquipmentStatus Status { get; set; }
    public int DepartmentId { get; set; }
    public DateTime LastMaintenanceDate { get; set; }
    public DateTime NextMaintenanceDate { get; set; }
}

// 设备状态枚举
public enum EquipmentStatus
{
    Normal = 1,     // 正常
    Maintaining = 2, // 维护中
    Fault = 3,      // 故障
    Scrapped = 4    // 已报废
}

// 设备服务接口
public interface IEquipmentService
{
    Task GetEquipmentByIdAsync(int id);
    Task<>> GetEquipmentsByDepartmentAsync(int departmentId);
    Task AddEquipmentAsync(Equipment equipment);
    Task UpdateEquipmentStatusAsync(int equipmentId, EquipmentStatus status);
    Task<>> GetEquipmentsDueForMaintenanceAsync();
}

// 设备服务实现
public class EquipmentService : IEquipmentService
{
    private readonly IEquipmentRepository _equipmentRepository;
    
    public EquipmentService(IEquipmentRepository equipmentRepository)
    {
        _equipmentRepository = equipmentRepository;
    }
    
    public async Task GetEquipmentByIdAsync(int id)
    {
        return await _equipmentRepository.GetByIdAsync(id);
    }
    
    // 其他方法实现...
}

// 设备列表组件示例
class EquipmentList extends React.Component {
  constructor(props) {
    super(props);
    this.state = {
      equipments: [],
      loading: true,
      error: null
    };
  }
  
  async componentDidMount() {
    try {
      const response = await fetch('/api/equipments');
      const data = await response.json();
      this.setState({ 
        equipments: data,
        loading: false 
      });
    } catch (error) {
      this.setState({ 
        error: error.message,
        loading: false 
      });
    }
  }
  
  render() {
    const { equipments, loading, error } = this.state;
    
    if (loading) return 
加载中...
;
    if (error) return 
错误: {error}
;
    
    return (
      

        
设备列表
        
            {equipments.map(equipment => (
              
            ))}
          

          

            

              
设备名称
              
型号
              
状态
              
最后维护日期
            
          
          

                
{equipment.name}
                
{equipment.model}
                
{this.renderStatus(equipment.status)}
                
{equipment.lastMaintenanceDate}
              
        
      
    );
  }
}

// 数据库上下文
public class EquipmentManagementContext : DbContext
{
    public EquipmentManagementContext(DbContextOptions options) 
        : base(options)
    {
    }
    
    public DbSet Equipments { get; set; }
    public DbSet MaintenanceRecords { get; set; }
    public DbSet WorkOrders { get; set; }
    public DbSet SpareParts { get; set; }
    
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        // 配置设备实体
        modelBuilder.Entity(entity =>
        {
            entity.HasKey(e => e.Id);
            entity.Property(e => e.Name).IsRequired().HasMaxLength(100);
            entity.Property(e => e.Model).HasMaxLength(50);
            entity.Property(e => e.SerialNumber).HasMaxLength(50);
            entity.Property(e => e.PurchasePrice).HasColumnType("decimal(18,2)");
            entity.Property(e => e.Status).HasConversion();
        });
        
        // 其他实体配置...
    }
}

// 应用启动时数据库迁移
public static void InitializeDatabase(IApplicationBuilder app)
{
    using (var serviceScope = app.ApplicationServices.GetService().CreateScope())
    {
        var context = serviceScope.ServiceProvider.GetRequiredService();
        context.Database.Migrate();
    }
}