From 6d2fa862707301c65b14a383ff8623938afbd76b Mon Sep 17 00:00:00 2001 From: lsh <lsh@163.com> Date: 星期三, 21 八月 2024 08:36:31 +0800 Subject: [PATCH] #优化 --- src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java | 5 +++++ src/main/resources/mapper/LocMastMapper.xml | 13 +++++++++++++ src/main/java/com/zy/asrs/mapper/LocMastMapper.java | 2 ++ src/main/java/com/zy/asrs/service/LocMastService.java | 2 ++ 4 files changed, 22 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java index e757e6b..d59a4c0 100644 --- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java @@ -44,6 +44,8 @@ //鎵惧崟鍝佺被鍨嬶紝鏈�鍐呬晶绌哄簱浣� List<LocMast> findInEmptyLocMast(Short locType1, @Param("rows") List<Integer> rows, Integer crnNo); + List<LocMast> findInEmptyLocMastNew(Short locType1, @Param("locNos") List<String> locNos, Integer crnNo); + //鍦ㄥ簱浣嶇粍涓悳绱㈠彲鍏ョ殑绌哄簱浣� List<LocMast> findEmptyLocMastByLocNos(Short locType1, @Param("locNos") List<String> locNos, Integer crnNo); diff --git a/src/main/java/com/zy/asrs/service/LocMastService.java b/src/main/java/com/zy/asrs/service/LocMastService.java index ec6efa3..86498ca 100644 --- a/src/main/java/com/zy/asrs/service/LocMastService.java +++ b/src/main/java/com/zy/asrs/service/LocMastService.java @@ -68,6 +68,8 @@ //鎵惧崟鍝佺被鍨嬶紝鏈�鍐呬晶绌哄簱浣� List<LocMast> findInEmptyLocMast(Short locType1, List<Integer> rows, Integer crnNo); + List<LocMast> findInEmptyLocMastNew(Short locType1, List<String> locNos, Integer crnNo); + //鍦ㄥ簱浣嶇粍涓悳绱㈠彲鍏ョ殑绌哄簱浣� List<LocMast> findEmptyLocMastByLocNos(Short locType1, List<String> locNos, Integer crnNo); diff --git a/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java index 220790b..ec31817 100644 --- a/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java @@ -234,6 +234,11 @@ } @Override + public List<LocMast> findInEmptyLocMastNew(Short locType1, List<String> locNos, Integer crnNo) { + return this.baseMapper.findInEmptyLocMastNew(locType1, locNos, crnNo); + } + + @Override public List<LocMast> findEmptyLocMastByLocNos(Short locType1, List<String> locNos, Integer crnNo) { return this.baseMapper.findEmptyLocMastByLocNos(locType1, locNos, crnNo); } diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml index d883d4b..feff422 100644 --- a/src/main/resources/mapper/LocMastMapper.xml +++ b/src/main/resources/mapper/LocMastMapper.xml @@ -308,6 +308,19 @@ order by bay1,lev1,row1 </select> + <select id="findInEmptyLocMastNew" resultMap="BaseResultMap"> + select * from asr_loc_mast + where loc_type2 = 1 + and loc_type1 = #{locType1} + and loc_no in + <foreach item="item" collection="locNos" index="index" separator="," open="(" close=")"> + #{item} + </foreach> + and loc_sts = 'O' + and crn_no = #{crnNo} + order by bay1,lev1,row1 + </select> + <select id="findEmptyLocMastByLocNos" resultMap="BaseResultMap"> select * from asr_loc_mast where loc_type2 = 1 -- Gitblit v1.9.1