From a566bdd94c21b60f57a0669fc923ffb9e16f0f4d Mon Sep 17 00:00:00 2001
From: whycq <123456>
Date: 星期四, 16 三月 2023 17:06:31 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java | 34 ++++++++++++++++++++++++++++++++--
src/main/resources/mapper/WrkMastMapper.xml | 5 ++++-
2 files changed, 36 insertions(+), 3 deletions(-)
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 136df8d..a86899e 100644
--- a/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java
@@ -532,7 +532,37 @@
wrkMast.setIoTime(now);
wrkMast.setIoType(wrkMast.getIoType() - 50); // 鍏ュ嚭搴撶被鍨�: 103->53,104->54,107->57
wrkMast.setWrkSts(2L); // 宸ヤ綔鐘舵��: 2.璁惧涓婅蛋
- wrkMast.setSourceStaNo(wrkMast.getStaNo()); // 婧愮珯
+
+ Integer sourceStaNo = 0;
+ switch (wrkMast.getStaNo()){
+ case 100:
+ sourceStaNo = 101;
+ break;
+ case 103:
+ sourceStaNo = 104;
+ break;
+ case 110:
+ sourceStaNo = 111;
+ break;
+ case 113:
+ sourceStaNo = 114;
+ break;
+ case 200:
+ sourceStaNo = 201;
+ break;
+ case 203:
+ sourceStaNo = 204;
+ break;
+ case 300:
+ sourceStaNo = 301;
+ break;
+ case 303:
+ sourceStaNo = 304;
+ break;
+ }
+
+ wrkMast.setSourceStaNo(sourceStaNo); // 婧愮珯
+// wrkMast.setSourceStaNo(wrkMast.getStaNo()); // 婧愮珯
wrkMast.setStaNo(staNo); // 鐩爣绔�
wrkMast.setLocNo(wrkMast.getSourceLocNo()); // 鐩爣搴撲綅 = 鍑哄簱鏃剁殑婧愬簱浣�
wrkMast.setSourceLocNo(""); // 婧愬簱浣嶆竻绌�
@@ -888,7 +918,7 @@
List<WrkMast> wrkMasts = wrkMastMapper.selectPakOutStep11(slave.getId(), crnStn.getStaNo());
// 鑾峰彇宸ヤ綔鐘舵�佷负14鐨勫伐浣滄。
WrkMast wrkMast1 = wrkMastMapper.selectPakOutStep14(slave.getId(), crnStn.getStaNo());
- if ( wrkMast1 !=null && (wrkMast1.getIoType().equals(103) || wrkMast1.getIoType().equals(107)) ) {
+ if ( wrkMast1 !=null) {
continue;
}
for (WrkMast wrkMast : wrkMasts) {
diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml
index 6260939..3bcdc93 100644
--- a/src/main/resources/mapper/WrkMastMapper.xml
+++ b/src/main/resources/mapper/WrkMastMapper.xml
@@ -161,7 +161,10 @@
</select>
<select id="selectPakOutStep14" resultMap="BaseResultMap">
- select top 1 * from dbo.asr_wrk_mast where crn_no=#{crnNo} and source_sta_no=#{sourceStaNo} and wrk_sts=14 and io_type>100 order by io_pri desc,io_time,wrk_no asc
+ select top 1 * from dbo.asr_wrk_mast
+ where crn_no=#{crnNo}
+ and ((wrk_sts=14 and io_type in (103,107) and source_sta_no=#{sourceStaNo}) or (wrk_sts in (2,3) and io_type in (53,57) and sta_no=#{sourceStaNo}))
+ order by io_pri desc,io_time,wrk_no asc
</select>
<!-- 鍏ュ嚭搴撴ā寮忕浉鍏� -->
--
Gitblit v1.9.1