yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/materialstock/MesWmMaterialStockController.java
@@ -10,6 +10,9 @@
import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockAdjustReqVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockFreezeReqVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockImportExcelVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockImportReqVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockImportRespVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockMoveReqVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockPageReqVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockRespVO;
@@ -135,6 +138,30 @@
                buildRespVOList(pageResult.getList()));
    }
    @GetMapping("/import-template")
    @Operation(summary = "下载库存现有量导入模板")
    @PreAuthorize("@ss.hasPermission('mes:wm-material-stock:import')")
    public void importTemplate(HttpServletResponse response) throws IOException {
        // 输出示例数据,方便使用者参考
        List<MesWmMaterialStockImportExcelVO> list = List.of(
                MesWmMaterialStockImportExcelVO.builder().itemCode("M001").warehouse("原料仓")
                        .location("A区").area("A-01").batchCode("B20260101").vendor("XX供应商")
                        .operationType("覆盖").quantity(new BigDecimal("100")).build()
        );
        ExcelUtils.write(response, "库存现有量导入模板.xls", "库存列表",
                MesWmMaterialStockImportExcelVO.class, list);
    }
    @PostMapping("/import")
    @Operation(summary = "导入库存现有量")
    @PreAuthorize("@ss.hasPermission('mes:wm-material-stock:import')")
    public CommonResult<MesWmMaterialStockImportRespVO> importExcel(
            @Valid MesWmMaterialStockImportReqVO importReqVO) throws Exception {
        List<MesWmMaterialStockImportExcelVO> list = ExcelUtils.read(
                importReqVO.getFile(), MesWmMaterialStockImportExcelVO.class);
        return success(materialStockService.importMaterialStockList(list));
    }
    // ==================== 拼接 VO ====================
    private List<MesWmMaterialStockRespVO> buildRespVOList(List<MesWmMaterialStockDO> list) {