如何做进出货管理软件

// 商品实体类
public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Code { get; set; }
    public string Category { get; set; }
    public decimal Price { get; set; }
    public int SafetyStock { get; set; } // 安全库存
    public DateTime CreateTime { get; set; }
    
    // 导航属性
    public virtual ICollection Inventories { get; set; }
    public virtual ICollection StockIns { get; set; }
    public virtual ICollection StockOuts { get; set; }
}

// 入库记录实体类
public class StockIn
{
    public int Id { get; set; }
    public int ProductId { get; set; }
    public int Quantity { get; set; }
    public DateTime InTime { get; set; }
    public string Operator { get; set; }
    public string Remark { get; set; }
    
    // 导航属性
    public virtual Product Product { get; set; }
}

// 库存实体类
public class Inventory
{
    public int Id { get; set; }
    public int ProductId { get; set; }
    public int Quantity { get; set; }
    public DateTime UpdateTime { get; set; }
    
    // 导航属性
    public virtual Product Product { get; set; }
}

// 库存服务类
public class InventoryService
{
    private readonly ApplicationDbContext _context;
    
    public InventoryService(ApplicationDbContext context)
    {
        _context = context;
    }
    
    // 入库操作
    public async Task StockInAsync(StockIn stockIn)
    {
        using var transaction = await _context.Database.BeginTransactionAsync();
        
        try
        {
            // 添加入库记录
            _context.StockIns.Add(stockIn);
            
            // 更新库存
            var inventory = await _context.Inventories
                .FirstOrDefaultAsync(i => i.ProductId == stockIn.ProductId);
                
            if (inventory == null)
            {
                inventory = new Inventory
                {
                    ProductId = stockIn.ProductId,
                    Quantity = stockIn.Quantity,
                    UpdateTime = DateTime.Now
                };
                _context.Inventories.Add(inventory);
            }
            else
            {
                inventory.Quantity += stockIn.Quantity;
                inventory.UpdateTime = DateTime.Now;
            }
            
            await _context.SaveChangesAsync();
            await transaction.CommitAsync();
            
            // 检查库存预警
            await CheckInventoryWarning(stockIn.ProductId);
            
            return true;
        }
        catch
        {
            await transaction.RollbackAsync();
            throw;
        }
    }
    
    // 库存预警检查
    private async Task CheckInventoryWarning(int productId)
    {
        var product = await _context.Products.FindAsync(productId);
        var inventory = await _context.Inventories
            .FirstOrDefaultAsync(i => i.ProductId == productId);
            
        if (inventory != null && inventory.Quantity <= product.SafetyStock)
        {
            // 触发库存预警逻辑
            await TriggerInventoryWarning(product, inventory.Quantity);
        }
    }
}

// 库存查询组件
class InventoryQueryComponent {
  private currentPage: number = 1;
  private pageSize: number = 20;
  
  // 查询库存列表
  async queryInventoryList(params: QueryParams): Promise {
    try {
      const response = await fetch('/api/inventory/query', {
        method: 'POST',
        headers: {
          'Content-Type': 'application/json',
        },
        body: JSON.stringify({
          ...params,
          page: this.currentPage,
          pageSize: this.pageSize
        })
      });
      
      if (!response.ok) {
        throw new Error('查询失败');
      }
      
      const result = await response.json();
      return result.data;
    } catch (error) {
      console.error('查询库存失败:', error);
      throw error;
    }
  }
  
  // 导出库存报表
  async exportInventoryReport(): Promise {
    try {
      const response = await fetch('/api/inventory/export');
      const blob = await response.blob();
      
      // 创建下载链接
      const url = window.URL.createObjectURL(blob);
      const link = document.createElement('a');
      link.href = url;
      link.download = `库存报表_${new Date().toLocaleDateString()}.xlsx`;
      link.click();
      
      // 清理资源
      window.URL.revokeObjectURL(url);
    } catch (error) {
      console.error('导出报表失败:', error);
      throw error;
    }
  }
}

// 库存数据类型定义
interface Inventory {
  id: number;
  productName: string;
  productCode: string;
  category: string;
  quantity: number;
  safetyStock: number;
  updateTime: string;
}

interface QueryParams {
  productName?: string;
  category?: string;
  minQuantity?: number;
  maxQuantity?: number;
}