如何做纸业ERP软件

// 纸卷（成品/半成品）实体模型
public class PaperReel
{
    public int Id { get; set; }
    public string ReelNumber { get; set; } // 卷号，唯一标识
    public int ProductId { get; set; } // 产品规格
    public decimal Width { get; set; } // 幅宽(mm)
    public decimal Length { get; set; } // 长度(m)
    public decimal Weight { get; set; } // 重量(kg)
    public string BatchNumber { get; set; } // 生产批次号
    public ReelStatus Status { get; set; } // 状态：在库、已锁定、已发货等
    public int LocationId { get; set; } // 库位
    public virtual Product Product { get; set; }
    public virtual WarehouseLocation Location { get; set; }
}

// 库存转换记录（如分切）
public class InventoryTransaction
{
    public int Id { get; set; }
    public int FromReelId { get; set; } // 原纸卷
    public int? ToReelId { get; set; } // 新生成纸卷（分切后可能多个）
    public TransactionType Type { get; set; } // 操作类型：分切、复卷、合并
    public DateTime TransactionTime { get; set; }
    public string Operator { get; set; }
    public virtual PaperReel FromReel { get; set; }
    public virtual PaperReel ToReel { get; set; }
}

// 生产订单服务示例
public class ProductionOrderService
{
    private readonly ApplicationDbContext _context;

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

    /// 

    /// 创建生产订单并生成物料需求清单
    /// 
    public async Task CreateOrderAsync(ProductionOrderDto orderDto)
    {
        // 1. 获取产品配方
        var formula = await _context.ProductFormulas
            .Include(f => f.MaterialItems)
            .FirstOrDefaultAsync(f => f.ProductId == orderDto.ProductId);
        if (formula == null) throw new ArgumentException("产品配方不存在");

        // 2. 创建生产订单
        var order = new ProductionOrder
        {
            OrderNumber = GenerateOrderNumber(),
            ProductId = orderDto.ProductId,
            PlannedQuantity = orderDto.Quantity,
            PlannedStartDate = orderDto.StartDate,
            Status = ProductionStatus.Planned
        };
        _context.ProductionOrders.Add(order);

        // 3. 计算并生成物料需求
        var materialRequirements = new List();
        foreach (var item in formula.MaterialItems)
        {
            var requiredAmount = item.StandardConsumption * orderDto.Quantity;
            materialRequirements.Add(new MaterialRequirement
            {
                ProductionOrder = order,
                MaterialId = item.MaterialId,
                RequiredAmount = requiredAmount,
                Unit = item.Unit
            });
        }
        _context.MaterialRequirements.AddRange(materialRequirements);

        await _context.SaveChangesAsync();
        return order;
    }
}

// 纸卷库存查询组件示例
class ReelInventorySearch {
    constructor(apiClient) {
        this.apiClient = apiClient;
        this.filters = {
            productCode: '',
            batchNumber: '',
            status: 'IN_STOCK',
            widthMin: null,
            widthMax: null
        };
    }

    // 查询库存
    async searchInventory() {
        try {
            const queryParams = new URLSearchParams();
            Object.keys(this.filters).forEach(key => {
                if (this.filters[key] !== null && this.filters[key] !== '') {
                    queryParams.append(key, this.filters[key]);
                }
            });

            const response = await this.apiClient.get(`/api/inventory/reels?${queryParams}`);
            this.displayResults(response.data);
        } catch (error) {
            console.error('查询库存失败:', error);
            this.showError('获取数据失败，请重试');
        }
    }

    // 显示结果（示例方法）
    displayResults(reels) {
        const tableBody = document.getElementById('inventoryTableBody');
        tableBody.innerHTML = reels.map(reel => `
            
                ${reel.reelNumber}
                ${reel.productName}
                ${reel.batchNumber}
                ${reel.width} mm
                ${reel.length} m
                ${reel.weight} kg
                ${reel.locationCode}
                ${this.getStatusText(reel.status)}
            
        `).join('');
    }

    getStatusText(status) {
        const statusMap = { 'IN_STOCK': '在库', 'RESERVED': '已锁定', 'SHIPPED': '已发货' };
        return statusMap[status] || status;
    }
}