From 5000a7f971fd5632c1e729e80e3b8a0441eb20b0 Mon Sep 17 00:00:00 2001
From: ZY <zc857179121@qq.com>
Date: 星期五, 07 二月 2025 07:57:09 +0800
Subject: [PATCH] 关闭订单
---
src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java b/src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java
index 96abd30..8251128 100644
--- a/src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java
@@ -10,7 +10,7 @@
public interface AgvLocMastMapper extends BaseMapper<AgvLocMast>{
//@Delete("delete from agv_loc_mast")
- @Delete("delete from agv_loc_mast where floor = '3'")
+ @Delete("delete from agv_loc_mast")
public void deleteAll();
@Update("update agv_loc_mast set loc_type2 = ${locType2}" +
@@ -30,4 +30,11 @@
@Select("SELECT * FROM agv_loc_mast WHERE lev1 = #{lev} And floor = #{floor}")
List<AgvLocMast> selectLocByLevAndFloor(@Param("lev")int lev, @Param("floor")int floor);
+
+ @Select("SELECT loc_type2 FROM agv_loc_mast WHERE loc_type1 = #{locType1} AND loc_type2 IS NOT NULL GROUP BY loc_type2")
+ List<String> queryContainerTypeByLocType1(@Param("locType1")Short locType1);
+
+
+ @Select("SELECT distinct map_row1 as mapRow1,right_side as rightSide FROM agv_loc_mast WHERE lev1 = #{lev1} And floor = #{floor} order by map_row1")
+ List<AgvLocMast> selectDistinctLocByLevAndFloor(@Param("lev1")Integer lev1,@Param("floor")Integer floor);
}
--
Gitblit v1.9.1