From c0eaf42288e354a7d281056624c1aa62a46f1ff3 Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期五, 02 六月 2023 14:52:47 +0800
Subject: [PATCH] 随机可用堆垛机号
---
src/main/resources/mapper/LocMastMapper.xml | 2 +-
src/main/java/com/zy/asrs/mapper/LocMastMapper.java | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
index f884606..ffecd1d 100644
--- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
@@ -37,7 +37,7 @@
void updateLocSts(@Param("locNo") String locNo,@Param("locSts") String locSts);
//鎵惧渚х┖搴撲綅
- List<LocMast> findOutMast(Short locType1, List<Integer> crnNos);
+ List<LocMast> findOutMast(Short locType1,@Param("crnNos") List<Integer> crnNos);
//鎵惧崟鍝佺被鍨嬶紝鏈�鍐呬晶绌哄簱浣�
List<LocMast> findInEmptyLocMast(Short locType1, @Param("rows") List<Integer> rows, Integer crnNo);
diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index 1a4ced9..e464b67 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -292,7 +292,7 @@
#{item}
</foreach>
and loc_sts = 'O'
- order by bay1,lev1,row1,
+ order by bay1,lev1,row1
</select>
<select id="findInEmptyLocMast" resultMap="BaseResultMap">
--
Gitblit v1.9.1