From 675ed4fa602e79e220e76fcdbc56e4630c0fb21c Mon Sep 17 00:00:00 2001 From: lsh <1> Date: 星期三, 17 七月 2024 17:17:40 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java | 8 ++++++++ src/main/resources/mapper/BasJarMastMapper.xml | 14 ++++++++++++++ src/main/java/com/zy/asrs/service/impl/BasJarMastServiceImpl.java | 5 +++++ src/main/java/com/zy/asrs/service/BasJarMastService.java | 2 ++ src/main/java/com/zy/asrs/mapper/BasJarMastMapper.java | 2 ++ 5 files changed, 31 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/BasJarMastMapper.java b/src/main/java/com/zy/asrs/mapper/BasJarMastMapper.java index 7696029..65b9ae9 100644 --- a/src/main/java/com/zy/asrs/mapper/BasJarMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/BasJarMastMapper.java @@ -21,6 +21,8 @@ List<BasJarMast> getJarMastByJarIdAndStatusListB(@Param("jarId") Integer jarId,@Param("statusList") List<Integer> statusList); + List<BasJarMast> getJarMastByJarIdAndStatusListCharge(@Param("jarId") Integer jarId,@Param("statusList") List<Integer> statusList); + BasJarMast getJarMastByJarIdMax(@Param("jarId") Integer jarId,@Param("statusList") List<Integer> statusList); BasJarMast getJarMastByJarIdMaxB(@Param("jarId") Integer jarId,@Param("statusList") List<Integer> statusList); diff --git a/src/main/java/com/zy/asrs/service/BasJarMastService.java b/src/main/java/com/zy/asrs/service/BasJarMastService.java index dd00056..ff43bbc 100644 --- a/src/main/java/com/zy/asrs/service/BasJarMastService.java +++ b/src/main/java/com/zy/asrs/service/BasJarMastService.java @@ -15,6 +15,8 @@ List<BasJarMast> getJarMastByJarIdAndStatusList(Integer jarId,List<Integer> statusList); + List<BasJarMast> getJarMastByJarIdAndStatusListCharge(Integer jarId,List<Integer> statusList); + List<BasJarMast> getJarMastByJarIdAndStatusListB(Integer jarId,List<Integer> statusList); List<BasJarMast> getJarMastByJarIdAndStatusList(Integer jarId,Integer type); diff --git a/src/main/java/com/zy/asrs/service/impl/BasJarMastServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/BasJarMastServiceImpl.java index b320e29..451a215 100644 --- a/src/main/java/com/zy/asrs/service/impl/BasJarMastServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/BasJarMastServiceImpl.java @@ -44,6 +44,11 @@ } @Override + public List<BasJarMast> getJarMastByJarIdAndStatusListCharge(Integer jarId,List<Integer> statusList) { + return this.baseMapper.getJarMastByJarIdAndStatusListCharge(jarId,statusList); + } + + @Override public List<BasJarMast> getJarMastByJarIdAndStatusList(Integer jarId,Integer type) { ArrayList<Integer> statusList = new ArrayList<>(); switch (type){ diff --git a/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java index d4e0038..f27f5b2 100644 --- a/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java @@ -7842,6 +7842,14 @@ continue; } } else if (steProtocol.getCharge()<80.0F){ + List<BasJarMast> basJarMastList = basJarMastService.getJarMastByJarIdAndStatusListCharge(steSlave.getId(), new ArrayList<Integer>() {{ + add(5); + add(11); + add(16); + }}); + if(!basJarMastList.isEmpty()){ + continue; + } if (wrkMastExecuteService.selectNoStart(steSlave.getId())!=0){ continue; } diff --git a/src/main/resources/mapper/BasJarMastMapper.xml b/src/main/resources/mapper/BasJarMastMapper.xml index 6b72f0e..d713143 100644 --- a/src/main/resources/mapper/BasJarMastMapper.xml +++ b/src/main/resources/mapper/BasJarMastMapper.xml @@ -67,6 +67,20 @@ order by jar_loc_digit desc </select> + <select id="getJarMastByJarIdAndStatusListCharge" resultMap="BaseResultMap"> + select * from asr_bas_jar_mast + where 1=1 + and + ( + status not in + <foreach collection="statusList" item="status" index="index" open="(" close=")" separator=","> + #{status} + </foreach> + ) + and jar_regin = #{jarId} + order by jar_loc_digit desc + </select> + <select id="getJarMastByJarIdMax" resultMap="BaseResultMap"> select top 1 * from asr_bas_jar_mast where 1=1 -- Gitblit v1.9.1