From 45d602719964509214d06ec5173f23e5307d5dfe Mon Sep 17 00:00:00 2001 From: zyx <zyx123456> Date: 星期二, 16 四月 2024 12:24:10 +0800 Subject: [PATCH] 无空库位时,不做空板入库操作 --- src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java index dad9fa8..73d8b03 100644 --- a/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java @@ -46,4 +46,7 @@ int deleteLocDetl(@Param("locNo")String locNo, @Param("anfme")Double anfme, @Param("matnr")String matnr, @Param("batch")String batch, @Param("csocode")String csocode, @Param("isocode")String isocode); AgvLocDetl selectLocdetl(@Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("csocode")String csocode, @Param("isocode")String isocode); + + @Update("update agv_loc_detl set loc_no = '${targetLoc}' where loc_no = '${sourceLoc}' and supp_code = '${containerCode}'") + void updateLocNo(String targetLoc, String sourceLoc, String containerCode); } -- Gitblit v1.9.1