物资领用管理系统全流程设计：入库、申领、审批、出库模块拆解（附操作逻辑）

// 物资入库操作示例
public class MaterialInService
{
    public async Task MaterialIn(MaterialInDto dto)
    {
        // 验证物资信息
        if (!ValidateMaterial(dto))
            return BadRequest("物资信息验证失败");
        
        // 更新库存
        var stock = await _dbContext.Stocks
            .FirstOrDefaultAsync(s => s.MaterialId == dto.MaterialId);
        
        if (stock == null)
        {
            // 新增库存记录
            stock = new Stock {
                MaterialId = dto.MaterialId,
                Quantity = dto.Quantity,
                WarehouseId = dto.WarehouseId
            };
            _dbContext.Stocks.Add(stock);
        }
        else
        {
            // 增加库存数量
            stock.Quantity += dto.Quantity;
        }
        
        // 生成入库记录
        var record = new MaterialInRecord {
            MaterialId = dto.MaterialId,
            Quantity = dto.Quantity,
            Operator = dto.Operator,
            InTime = DateTime.Now
        };
        _dbContext.MaterialInRecords.Add(record);
        
        await _dbContext.SaveChangesAsync();
        return Ok("入库成功");
    }
}

-- 出库操作事务处理
BEGIN TRANSACTION;

-- 检查库存是否充足
IF (SELECT Quantity FROM Stocks WHERE MaterialId = @materialId) >= @outQuantity
BEGIN
    -- 扣减库存
    UPDATE Stocks 
    SET Quantity = Quantity - @outQuantity,
        LastOutTime = GETDATE()
    WHERE MaterialId = @materialId;
    
    -- 记录出库明细
    INSERT INTO MaterialOutRecords (
        MaterialId, Quantity, Applicant, 
        Approver, OutTime, WarehouseId
    ) VALUES (
        @materialId, @outQuantity, @applicant,
        @approver, GETDATE(), @warehouseId
    );
    
    COMMIT TRANSACTION;
    SELECT '出库成功' AS Result;
END
ELSE
BEGIN
    ROLLBACK TRANSACTION;
    SELECT '库存不足' AS Result;
END

// 物资查询API接口示例
const express = require('express');
const router = express.Router();
const Material = require('../models/Material');

// 获取物资库存信息
router.get('/api/materials/stock', async (req, res) => {
  try {
    const { page = 1, limit = 10, category } = req.query;
    
    const query = {};
    if (category) query.category = category;
    
    const materials = await Material.find(query)
      .limit(limit * 1)
      .skip((page - 1) * limit)
      .populate('currentStock');
    
    const total = await Material.countDocuments(query);
    
    res.json({
      materials,
      totalPages: Math.ceil(total / limit),
      currentPage: page
    });
  } catch (err) {
    res.status(500).json({ message: err.message });
  }
});

module.exports = router;