From a3c831343b4a975cb3bf71e5c8300e4598bcfef4 Mon Sep 17 00:00:00 2001
From: 1 <1>
Date: 星期四, 25 十二月 2025 11:45:13 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java |  454 ++++++++++++++++++++++++--------------------
 src/main/java/com/zy/core/thread/SiemensDevpThread.java     |  132 ++++++------
 src/main/resources/mapper/WrkMastStaMapper.xml              |    8 
 3 files changed, 322 insertions(+), 272 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 8d1d625..d059e25 100644
--- a/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java
@@ -1040,7 +1040,11 @@
                         if (jsonObject.getInteger("code").equals(200)) {
                             staProtocolOut.setWorkNo(9997);
                             devpThread.setPakMk(staProtocolOut.getSiteId(), false);
-                            boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocolOut));
+                            Integer devpId = 1;
+                            if(staProtocolOut.getSiteId() > 2000){
+                                devpId = 2;
+                            }
+                            boolean result = MessageQueue.offer(SlaveType.Devp, devpId, new Task(2, staProtocolOut));
 
                             if (!result) {
                                 throw new CoolException("鏇存柊plc绔欑偣淇℃伅澶辫触");
@@ -1084,7 +1088,11 @@
                     if (jsonObject.getInteger("code").equals(200)) {
                         staProtocolIn.setWorkNo(9996);
                         devpThread.setPakMk(staProtocolIn.getSiteId(), false);
-                        boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocolIn));
+                        Integer devpId = 1;
+                        if(staProtocolIn.getSiteId() > 2000){
+                            devpId = 2;
+                        }
+                        boolean result = MessageQueue.offer(SlaveType.Devp, devpId, new Task(2, staProtocolIn));
 
                         if (!result) {
                             throw new CoolException("鏇存柊plc绔欑偣淇℃伅澶辫触");
@@ -1151,6 +1159,23 @@
                     }
                 }
             }
+
+            if (crnProtocol.getStatusType() == CrnStatusType.IDLE && crnProtocol.getTaskNo() == 0 && crnProtocol.getModeType() == CrnModeType.AUTO
+                    && crnProtocol.getLoaded() == 0 && crnProtocol.getForkPos() == 0 && crnProtocol.getCrnNo() == 3) {
+                News.warnNoLog(""+mark+" - 0"+" - 寮�濮嬫墽琛屽爢鍨涙満鍏ュ嚭搴撲綔涓氫笅鍙�");
+                if (crnProtocol.getLastIo().equals("O")) {
+                    if (basCrnp.getInEnable().equals("Y")) {
+                        this.locToCrnStn9996(crn, crnProtocol,mark); //  鍏ュ簱
+                    }
+                }
+                // 濡傛灉鏈�杩戜竴娆℃槸鍑哄簱妯″紡
+                else if (crnProtocol.getLastIo().equals("I")) {
+                    if (basCrnp.getOutEnable().equals("Y")) {
+                        this.locToCrnStn9997(crn, crnProtocol,mark); //  鍑哄簱
+                    }
+                }
+            }
+
             // 搴撲綅绉昏浆
             //mark - 3 - ....
             this.locToLoc(crn, crnProtocol,mark);
@@ -1173,7 +1198,7 @@
                     new EntityWrapper<BasCrnp>().eq("crn_no", crnProtocol.getCrnNo())
             );
             boolean result = true;
-            if(crnProtocol.getCrnNo() != 3 ){
+            if(crnProtocol.getCrnNo() != 5 ){
                 return;
             }
             for (CrnSlave.CrnStn crnStn : slave.getCrnInStn()) {
@@ -1465,205 +1490,6 @@
             // 鑾峰彇宸ヤ綔鐘舵�佷负11锛堢敓鎴愬嚭搴揑D锛夌殑鍑哄簱宸ヤ綔妗�
 //            WrkMast wrkMast = wrkMastMapper.selectPakOutStep1(slave.getId(), crnStn.getStaNo());
             List<WrkMast> wrkMasts = wrkMastMapper.selectPakOutStep11(slave.getId(), crnStn.getStaNo());
-            WrkMast wrkMast9997 = wrkMastMapper.selectByWrkNo9997(9997);
-            WrkMast wrkMast9996 = wrkMastMapper.selectByWrkNo9997(9996);
-
-
-            if (slave.getId() == 3 && wrkMast9997 != null) {
-                SiemensDevpThread devpThread1 = (SiemensDevpThread) SlaveConnection.get(SlaveType.Devp, 1);
-                StaProtocol staProtocol2 = devpThread1.getStation().get(1015);
-                if (staProtocol2 == null) {
-                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol2);
-                    break;
-                } else {
-                    staProtocol2 = staProtocol2.clone();
-                }
-                SiemensDevpThread devpThread2 = (SiemensDevpThread) SlaveConnection.get(SlaveType.Devp, 2);
-                StaProtocol staProtocol4004 = devpThread2.getStation().get(4004);
-                if (staProtocol4004 == null) {
-                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol4004);
-                    break;
-                } else {
-                    staProtocol4004 = staProtocol4004.clone();
-                }
-                StaProtocol staProtocol3 = devpThread2.getStation().get(2016);
-                if (staProtocol3 == null) {
-                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol2);
-                    break;
-                } else {
-                    staProtocol3 = staProtocol3.clone();
-                }
-                BasDevp staDetl = basDevpService.selectById(crnStn.getStaNo());
-                if (staDetl == null) {
-                    News.error(""+mark+" - 2"+" - 5"+" - 鍑哄簱 ===>> 鍫嗗灈鏈虹珯鐐瑰湪鏁版嵁搴撲笉瀛樺湪, 绔欑偣缂栧彿={}", crnStn.getStaNo());
-                    break;
-//                    continue;
-                }
-                if(staProtocol2.isLoading() && staProtocol2.isAutoing() && staDetl.getCanouting() != null && staDetl.getCanouting().equals("Y")){
-                    // 鍫嗗灈鏈烘帶鍒惰繃婊�
-                    if (!crnProtocol.getStatusType().equals(CrnStatusType.IDLE) || crnProtocol.getTaskNo() != 0) {
-//                        continue;
-                        break;
-                    }
-                    // 宸茬粡瀛樺湪鍚婅溅鎵ц浠诲姟鏃讹紝鍒欒繃婊�
-                    if (wrkMastMapper.selectWorking(slave.getId()) != null) {
-                        break;
-//                        return;
-                    }
-                    if(staProtocol4004.isLoading()){
-                        continue;
-                    }
-                    // 1.鍫嗗灈鏈哄紑濮嬬Щ鍔�
-                    CrnCommand crnCommand = new CrnCommand();
-                    crnCommand.setCrnNo(slave.getId()); // 鍫嗗灈鏈虹紪鍙�
-                    crnCommand.setTaskNo((short) 9997); // 宸ヤ綔鍙�
-//                    crnCommand.setAckFinish((short) 0);  // 浠诲姟瀹屾垚纭浣�
-                    crnCommand.setTaskMode(CrnTaskModeType.LOC_MOVE); // 浠诲姟妯″紡:  搴撲綅绉昏浆
-                    crnCommand.setSourcePosX((short) 9);     // 婧愬簱浣嶆帓
-                    crnCommand.setSourcePosY((short) 52);     // 婧愬簱浣嶅垪
-                    crnCommand.setSourcePosZ((short) 1);     // 婧愬簱浣嶅眰
-                    crnCommand.setDestinationPosX((short) 11);     // 鐩爣搴撲綅鎺�
-                    crnCommand.setDestinationPosY((short) 52);     // 鐩爣搴撲綅鍒�
-                    crnCommand.setDestinationPosZ((short) 3);     // 鐩爣搴撲綅灞�
-//                crnCommand.setTraySize(sourceSta.getLocType1() == 2);     //搴撲綅绫诲瀷
-                    if (!MessageQueue.offer(SlaveType.Crn, wrkMast9997.getCrnNo(), new Task(2, crnCommand))) {
-                        News.error("" + mark + " - 2" + " - 13" + " - 鍫嗗灈鏈哄懡浠や笅鍙戝け璐ワ紝鍫嗗灈鏈哄彿={}锛屼换鍔℃暟鎹�={}", wrkMast9997.getCrnNo(), JSON.toJSON(crnCommand));
-                    } else {
-                        // 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓�
-                        Date now = new Date();
-                        wrkMast9997.setWrkSts(12L);
-                        wrkMast9997.setCrnStrTime(now);
-                        wrkMast9997.setModiTime(now);
-                        if (wrkMastMapper.updateById(wrkMast9997) == 0) {
-                            News.error("" + mark + " - 2" + " - 14" + " - 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓� 澶辫触锛侊紒锛屽伐浣滃彿={}", wrkMast9997.getWrkNo());
-                        }
-                        break;
-                    }
-                }
-                if(staProtocol3.isLoading() && staProtocol3.isAutoing()){
-                    // 鍫嗗灈鏈烘帶鍒惰繃婊�
-                    if (!crnProtocol.getStatusType().equals(CrnStatusType.IDLE) || crnProtocol.getTaskNo() != 0) {
-//                        continue;
-                        break;
-                    }
-                    // 宸茬粡瀛樺湪鍚婅溅鎵ц浠诲姟鏃讹紝鍒欒繃婊�
-                    if (wrkMastMapper.selectWorking(slave.getId()) != null) {
-                        break;
-//                        return;
-                    }
-                    if(staProtocol4004.isLoading()){
-                        continue;
-                    }
-                    // 1.鍫嗗灈鏈哄紑濮嬬Щ鍔�
-                    CrnCommand crnCommand = new CrnCommand();
-                    crnCommand.setCrnNo(slave.getId()); // 鍫嗗灈鏈虹紪鍙�
-                    crnCommand.setTaskNo((short) 9997); // 宸ヤ綔鍙�
-//                    crnCommand.setAckFinish((short) 0);  // 浠诲姟瀹屾垚纭浣�
-                    crnCommand.setTaskMode(CrnTaskModeType.LOC_MOVE); // 浠诲姟妯″紡:  搴撲綅绉昏浆
-                    crnCommand.setSourcePosX((short) 11);     // 婧愬簱浣嶆帓
-                    crnCommand.setSourcePosY((short) 52);     // 婧愬簱浣嶅垪
-                    crnCommand.setSourcePosZ((short) 2);     // 婧愬簱浣嶅眰
-                    crnCommand.setDestinationPosX((short) 11);     // 鐩爣搴撲綅鎺�
-                    crnCommand.setDestinationPosY((short) 52);     // 鐩爣搴撲綅鍒�
-                    crnCommand.setDestinationPosZ((short) 3);     // 鐩爣搴撲綅灞�
-//                crnCommand.setTraySize(sourceSta.getLocType1() == 2);     //搴撲綅绫诲瀷
-                    if (!MessageQueue.offer(SlaveType.Crn, wrkMast9997.getCrnNo(), new Task(2, crnCommand))) {
-                        News.error("" + mark + " - 2" + " - 13" + " - 鍫嗗灈鏈哄懡浠や笅鍙戝け璐ワ紝鍫嗗灈鏈哄彿={}锛屼换鍔℃暟鎹�={}", wrkMast9997.getCrnNo(), JSON.toJSON(crnCommand));
-                    } else {
-                        // 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓�
-                        Date now = new Date();
-                        wrkMast9997.setWrkSts(12L);
-                        wrkMast9997.setCrnStrTime(now);
-                        wrkMast9997.setModiTime(now);
-                        if (wrkMastMapper.updateById(wrkMast9997) == 0) {
-                            News.error("" + mark + " - 2" + " - 14" + " - 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓� 澶辫触锛侊紒锛屽伐浣滃彿={}", wrkMast9997.getWrkNo());
-                        }
-                        break;
-                    }
-                }
-            }
-            if (slave.getId() == 3 && wrkMast9996 != null) {
-                SiemensDevpThread devpThread1 = (SiemensDevpThread) SlaveConnection.get(SlaveType.Devp, 1);
-
-                SiemensDevpThread devpThread2 = (SiemensDevpThread) SlaveConnection.get(SlaveType.Devp, 2);
-                StaProtocol staProtocol4001 = devpThread2.getStation().get(4001);
-                if (staProtocol4001 == null) {
-                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol4001);
-                    break;
-                } else {
-                    staProtocol4001 = staProtocol4001.clone();
-                }
-                StaProtocol staProtocol2013 = devpThread2.getStation().get(2013);
-                if (staProtocol2013 == null) {
-                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol2013);
-                    break;
-                } else {
-                    staProtocol2013 = staProtocol2013.clone();
-                }
-                StaProtocol staProtocol1019 = devpThread1.getStation().get(1019);
-                if (staProtocol1019 == null) {
-                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol1019);
-                    break;
-                } else {
-                    staProtocol1019 = staProtocol1019.clone();
-                }
-                BasDevp staDetl = basDevpService.selectById(crnStn.getStaNo());
-                if (staDetl == null) {
-                    News.error(""+mark+" - 2"+" - 5"+" - 鍑哄簱 ===>> 鍫嗗灈鏈虹珯鐐瑰湪鏁版嵁搴撲笉瀛樺湪, 绔欑偣缂栧彿={}", crnStn.getStaNo());
-                    break;
-//                    continue;
-                }
-                if(staProtocol4001.isLoading() && staProtocol4001.isAutoing() && staDetl.getCanouting() != null && staDetl.getCanouting().equals("Y")){
-                    // 鍫嗗灈鏈烘帶鍒惰繃婊�
-                    if (!crnProtocol.getStatusType().equals(CrnStatusType.IDLE) || crnProtocol.getTaskNo() != 0) {
-//                        continue;
-                        break;
-                    }
-                    // 宸茬粡瀛樺湪鍚婅溅鎵ц浠诲姟鏃讹紝鍒欒繃婊�
-                    if (wrkMastMapper.selectWorking(slave.getId()) != null) {
-                        break;
-//                        return;
-                    }
-                    if(staProtocol1019.isLoading() && wrkMast9996.getStaNo() < 2000){
-                        continue;
-                    }
-                    if(staProtocol2013.isLoading() && wrkMast9996.getStaNo() > 2000){
-                        continue;
-                    }
-                    // 1.鍫嗗灈鏈哄紑濮嬬Щ鍔�
-                    CrnCommand crnCommand = new CrnCommand();
-                    crnCommand.setCrnNo(slave.getId()); // 鍫嗗灈鏈虹紪鍙�
-                    crnCommand.setTaskNo((short) 9996); // 宸ヤ綔鍙�
-//                    crnCommand.setAckFinish((short) 0);  // 浠诲姟瀹屾垚纭浣�
-                    crnCommand.setTaskMode(CrnTaskModeType.LOC_MOVE); // 浠诲姟妯″紡:  搴撲綅绉昏浆
-                    crnCommand.setSourcePosX((short) 9);     // 婧愬簱浣嶆帓
-                    crnCommand.setSourcePosY((short) 52);     // 婧愬簱浣嶅垪
-                    crnCommand.setSourcePosZ((short) 3);     // 婧愬簱浣嶅眰
-                    if(wrkMast9996.getStaNo()>2000){
-                        crnCommand.setDestinationPosX((short) 9);     // 鐩爣搴撲綅鎺�
-                        crnCommand.setDestinationPosY((short) 52);     // 鐩爣搴撲綅鍒�
-                        crnCommand.setDestinationPosZ((short) 2);     // 鐩爣搴撲綅灞�
-                    }else{
-                        crnCommand.setDestinationPosX((short) 11);     // 鐩爣搴撲綅鎺�
-                        crnCommand.setDestinationPosY((short) 52);     // 鐩爣搴撲綅鍒�
-                        crnCommand.setDestinationPosZ((short) 1);     // 鐩爣搴撲綅灞�
-                    }
-//                crnCommand.setTraySize(sourceSta.getLocType1() == 2);     //搴撲綅绫诲瀷
-                    if (!MessageQueue.offer(SlaveType.Crn, wrkMast9996.getCrnNo(), new Task(2, crnCommand))) {
-                        News.error("" + mark + " - 2" + " - 13" + " - 鍫嗗灈鏈哄懡浠や笅鍙戝け璐ワ紝鍫嗗灈鏈哄彿={}锛屼换鍔℃暟鎹�={}", wrkMast9996.getCrnNo(), JSON.toJSON(crnCommand));
-                    } else {
-                        // 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓�
-                        Date now = new Date();
-                        wrkMast9996.setWrkSts(12L);
-                        wrkMast9996.setCrnStrTime(now);
-                        wrkMast9996.setModiTime(now);
-                        if (wrkMastMapper.updateById(wrkMast9996) == 0) {
-                            News.error("" + mark + " - 2" + " - 14" + " - 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓� 澶辫触锛侊紒锛屽伐浣滃彿={}", wrkMast9996.getWrkNo());
-                        }
-                        break;
-                    }
-                }
-            }
             for (WrkMast wrkMast : wrkMasts) {
                 if (wrkMast == null) {
                     continue;
@@ -1820,6 +1646,222 @@
         News.infoNoLog(""+mark+" - 2"+" - 0"+" - 鍫嗗灈鏈哄叆鍑哄簱浣滀笟涓嬪彂 锛� 鍑哄簱鎵ц瀹屾瘯");
     }
 
+    public synchronized void locToCrnStn9996(CrnSlave slave, CrnProtocol crnProtocol,Integer mark) {
+        News.warnNoLog(""+mark+" - 2"+" - 0"+" - 鍫嗗灈鏈哄叆鍑哄簱浣滀笟涓嬪彂锛氭墽琛屽嚭搴�");
+        for (CrnSlave.CrnStn crnStn : slave.getCrnOutStn()) {
+            // 鑾峰彇宸ヤ綔鐘舵�佷负11锛堢敓鎴愬嚭搴揑D锛夌殑鍑哄簱宸ヤ綔妗�
+//            WrkMast wrkMast = wrkMastMapper.selectPakOutStep1(slave.getId(), crnStn.getStaNo());
+            List<WrkMast> wrkMasts = wrkMastMapper.selectPakOutStep11(slave.getId(), crnStn.getStaNo());
+            WrkMast wrkMast9996 = wrkMastMapper.selectByWrkNo9997(9996);
+            if (slave.getId() == 3 && wrkMast9996 != null) {
+                SiemensDevpThread devpThread1 = (SiemensDevpThread) SlaveConnection.get(SlaveType.Devp, 1);
+
+                SiemensDevpThread devpThread2 = (SiemensDevpThread) SlaveConnection.get(SlaveType.Devp, 2);
+                StaProtocol staProtocol4001 = devpThread2.getStation().get(4001);
+                if (staProtocol4001 == null) {
+                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol4001);
+                    break;
+                } else {
+                    staProtocol4001 = staProtocol4001.clone();
+                }
+                StaProtocol staProtocol2013 = devpThread2.getStation().get(2013);
+                if (staProtocol2013 == null) {
+                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol2013);
+                    break;
+                } else {
+                    staProtocol2013 = staProtocol2013.clone();
+                }
+                StaProtocol staProtocol1019 = devpThread1.getStation().get(1019);
+                if (staProtocol1019 == null) {
+                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol1019);
+                    break;
+                } else {
+                    staProtocol1019 = staProtocol1019.clone();
+                }
+                BasDevp staDetl = basDevpService.selectById(crnStn.getStaNo());
+                if (staDetl == null) {
+                    News.error(""+mark+" - 2"+" - 5"+" - 鍑哄簱 ===>> 鍫嗗灈鏈虹珯鐐瑰湪鏁版嵁搴撲笉瀛樺湪, 绔欑偣缂栧彿={}", crnStn.getStaNo());
+                    break;
+//                    continue;
+                }
+                if(staProtocol4001.isLoading() && staProtocol4001.isAutoing() && staDetl.getCanouting() != null && staDetl.getCanouting().equals("Y")){
+                    // 鍫嗗灈鏈烘帶鍒惰繃婊�
+                    if (!crnProtocol.getStatusType().equals(CrnStatusType.IDLE) || crnProtocol.getTaskNo() != 0) {
+//                        continue;
+                        break;
+                    }
+                    // 宸茬粡瀛樺湪鍚婅溅鎵ц浠诲姟鏃讹紝鍒欒繃婊�
+                    if (wrkMastMapper.selectWorking(slave.getId()) != null) {
+                        break;
+//                        return;
+                    }
+                    if(staProtocol1019.isLoading() && wrkMast9996.getStaNo() < 2000){
+                        continue;
+                    }
+                    if(staProtocol2013.isLoading() && wrkMast9996.getStaNo() > 2000){
+                        continue;
+                    }
+                    // 1.鍫嗗灈鏈哄紑濮嬬Щ鍔�
+                    CrnCommand crnCommand = new CrnCommand();
+                    crnCommand.setCrnNo(slave.getId()); // 鍫嗗灈鏈虹紪鍙�
+                    crnCommand.setTaskNo((short) 9996); // 宸ヤ綔鍙�
+//                    crnCommand.setAckFinish((short) 0);  // 浠诲姟瀹屾垚纭浣�
+                    crnCommand.setTaskMode(CrnTaskModeType.LOC_MOVE); // 浠诲姟妯″紡:  搴撲綅绉昏浆
+                    crnCommand.setSourcePosX((short) 9);     // 婧愬簱浣嶆帓
+                    crnCommand.setSourcePosY((short) 52);     // 婧愬簱浣嶅垪
+                    crnCommand.setSourcePosZ((short) 3);     // 婧愬簱浣嶅眰
+                    if(wrkMast9996.getStaNo()>2000){
+                        crnCommand.setDestinationPosX((short) 9);     // 鐩爣搴撲綅鎺�
+                        crnCommand.setDestinationPosY((short) 52);     // 鐩爣搴撲綅鍒�
+                        crnCommand.setDestinationPosZ((short) 2);     // 鐩爣搴撲綅灞�
+                    }else{
+                        crnCommand.setDestinationPosX((short) 11);     // 鐩爣搴撲綅鎺�
+                        crnCommand.setDestinationPosY((short) 52);     // 鐩爣搴撲綅鍒�
+                        crnCommand.setDestinationPosZ((short) 1);     // 鐩爣搴撲綅灞�
+                    }
+//                crnCommand.setTraySize(sourceSta.getLocType1() == 2);     //搴撲綅绫诲瀷
+                    if (!MessageQueue.offer(SlaveType.Crn, wrkMast9996.getCrnNo(), new Task(2, crnCommand))) {
+                        News.error("" + mark + " - 2" + " - 13" + " - 鍫嗗灈鏈哄懡浠や笅鍙戝け璐ワ紝鍫嗗灈鏈哄彿={}锛屼换鍔℃暟鎹�={}", wrkMast9996.getCrnNo(), JSON.toJSON(crnCommand));
+                    } else {
+                        // 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓�
+                        Date now = new Date();
+                        wrkMast9996.setWrkSts(12L);
+                        wrkMast9996.setCrnStrTime(now);
+                        wrkMast9996.setModiTime(now);
+                        if (wrkMastMapper.updateById(wrkMast9996) == 0) {
+                            News.error("" + mark + " - 2" + " - 14" + " - 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓� 澶辫触锛侊紒锛屽伐浣滃彿={}", wrkMast9996.getWrkNo());
+                        }
+                        break;
+                    }
+                }
+            }
+        }
+        News.infoNoLog(""+mark+" - 2"+" - 0"+" - 鍫嗗灈鏈哄叆鍑哄簱浣滀笟涓嬪彂 锛� 鍑哄簱鎵ц瀹屾瘯");
+    }
+    public synchronized void locToCrnStn9997(CrnSlave slave, CrnProtocol crnProtocol,Integer mark) {
+        News.warnNoLog(""+mark+" - 2"+" - 0"+" - 鍫嗗灈鏈哄叆鍑哄簱浣滀笟涓嬪彂锛氭墽琛屽嚭搴�");
+        for (CrnSlave.CrnStn crnStn : slave.getCrnOutStn()) {
+            // 鑾峰彇宸ヤ綔鐘舵�佷负11锛堢敓鎴愬嚭搴揑D锛夌殑鍑哄簱宸ヤ綔妗�
+//            WrkMast wrkMast = wrkMastMapper.selectPakOutStep1(slave.getId(), crnStn.getStaNo());
+            List<WrkMast> wrkMasts = wrkMastMapper.selectPakOutStep11(slave.getId(), crnStn.getStaNo());
+            WrkMast wrkMast9997 = wrkMastMapper.selectByWrkNo9997(9997);
+
+            if (slave.getId() == 3 && wrkMast9997 != null) {
+                SiemensDevpThread devpThread1 = (SiemensDevpThread) SlaveConnection.get(SlaveType.Devp, 1);
+                StaProtocol staProtocol2 = devpThread1.getStation().get(1015);
+                if (staProtocol2 == null) {
+                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol2);
+                    break;
+                } else {
+                    staProtocol2 = staProtocol2.clone();
+                }
+                SiemensDevpThread devpThread2 = (SiemensDevpThread) SlaveConnection.get(SlaveType.Devp, 2);
+                StaProtocol staProtocol4004 = devpThread2.getStation().get(4004);
+                if (staProtocol4004 == null) {
+                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol4004);
+                    break;
+                } else {
+                    staProtocol4004 = staProtocol4004.clone();
+                }
+                StaProtocol staProtocol3 = devpThread2.getStation().get(2016);
+                if (staProtocol3 == null) {
+                    News.infoNoLog("" + mark + " - 2" + " - 3" + " - 鍫嗗灈鏈哄嚭搴撶珯淇℃伅(staProtocol!=null缁х画鎵ц,鍚﹀垯寰幆缁堟)锛歴taProtocol=" + staProtocol2);
+                    break;
+                } else {
+                    staProtocol3 = staProtocol3.clone();
+                }
+                BasDevp staDetl = basDevpService.selectById(crnStn.getStaNo());
+                if (staDetl == null) {
+                    News.error("" + mark + " - 2" + " - 5" + " - 鍑哄簱 ===>> 鍫嗗灈鏈虹珯鐐瑰湪鏁版嵁搴撲笉瀛樺湪, 绔欑偣缂栧彿={}", crnStn.getStaNo());
+                    break;
+//                    continue;
+                }
+                if (staProtocol2.isLoading() && staProtocol2.isAutoing() && staDetl.getCanouting() != null && staDetl.getCanouting().equals("Y")) {
+                    // 鍫嗗灈鏈烘帶鍒惰繃婊�
+                    if (!crnProtocol.getStatusType().equals(CrnStatusType.IDLE) || crnProtocol.getTaskNo() != 0) {
+//                        continue;
+                        break;
+                    }
+                    // 宸茬粡瀛樺湪鍚婅溅鎵ц浠诲姟鏃讹紝鍒欒繃婊�
+                    if (wrkMastMapper.selectWorking(slave.getId()) != null) {
+                        break;
+//                        return;
+                    }
+                    if (staProtocol4004.isLoading()) {
+                        continue;
+                    }
+                    // 1.鍫嗗灈鏈哄紑濮嬬Щ鍔�
+                    CrnCommand crnCommand = new CrnCommand();
+                    crnCommand.setCrnNo(slave.getId()); // 鍫嗗灈鏈虹紪鍙�
+                    crnCommand.setTaskNo((short) 9997); // 宸ヤ綔鍙�
+//                    crnCommand.setAckFinish((short) 0);  // 浠诲姟瀹屾垚纭浣�
+                    crnCommand.setTaskMode(CrnTaskModeType.LOC_MOVE); // 浠诲姟妯″紡:  搴撲綅绉昏浆
+                    crnCommand.setSourcePosX((short) 9);     // 婧愬簱浣嶆帓
+                    crnCommand.setSourcePosY((short) 52);     // 婧愬簱浣嶅垪
+                    crnCommand.setSourcePosZ((short) 1);     // 婧愬簱浣嶅眰
+                    crnCommand.setDestinationPosX((short) 11);     // 鐩爣搴撲綅鎺�
+                    crnCommand.setDestinationPosY((short) 52);     // 鐩爣搴撲綅鍒�
+                    crnCommand.setDestinationPosZ((short) 3);     // 鐩爣搴撲綅灞�
+//                crnCommand.setTraySize(sourceSta.getLocType1() == 2);     //搴撲綅绫诲瀷
+                    if (!MessageQueue.offer(SlaveType.Crn, wrkMast9997.getCrnNo(), new Task(2, crnCommand))) {
+                        News.error("" + mark + " - 2" + " - 13" + " - 鍫嗗灈鏈哄懡浠や笅鍙戝け璐ワ紝鍫嗗灈鏈哄彿={}锛屼换鍔℃暟鎹�={}", wrkMast9997.getCrnNo(), JSON.toJSON(crnCommand));
+                    } else {
+                        // 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓�
+                        Date now = new Date();
+                        wrkMast9997.setWrkSts(12L);
+                        wrkMast9997.setCrnStrTime(now);
+                        wrkMast9997.setModiTime(now);
+                        if (wrkMastMapper.updateById(wrkMast9997) == 0) {
+                            News.error("" + mark + " - 2" + " - 14" + " - 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓� 澶辫触锛侊紒锛屽伐浣滃彿={}", wrkMast9997.getWrkNo());
+                        }
+                        break;
+                    }
+                }
+                if (staProtocol3.isLoading() && staProtocol3.isAutoing()) {
+                    // 鍫嗗灈鏈烘帶鍒惰繃婊�
+                    if (!crnProtocol.getStatusType().equals(CrnStatusType.IDLE) || crnProtocol.getTaskNo() != 0) {
+//                        continue;
+                        break;
+                    }
+                    // 宸茬粡瀛樺湪鍚婅溅鎵ц浠诲姟鏃讹紝鍒欒繃婊�
+                    if (wrkMastMapper.selectWorking(slave.getId()) != null) {
+                        break;
+//                        return;
+                    }
+                    if (staProtocol4004.isLoading()) {
+                        continue;
+                    }
+                    // 1.鍫嗗灈鏈哄紑濮嬬Щ鍔�
+                    CrnCommand crnCommand = new CrnCommand();
+                    crnCommand.setCrnNo(slave.getId()); // 鍫嗗灈鏈虹紪鍙�
+                    crnCommand.setTaskNo((short) 9997); // 宸ヤ綔鍙�
+//                    crnCommand.setAckFinish((short) 0);  // 浠诲姟瀹屾垚纭浣�
+                    crnCommand.setTaskMode(CrnTaskModeType.LOC_MOVE); // 浠诲姟妯″紡:  搴撲綅绉昏浆
+                    crnCommand.setSourcePosX((short) 11);     // 婧愬簱浣嶆帓
+                    crnCommand.setSourcePosY((short) 52);     // 婧愬簱浣嶅垪
+                    crnCommand.setSourcePosZ((short) 2);     // 婧愬簱浣嶅眰
+                    crnCommand.setDestinationPosX((short) 11);     // 鐩爣搴撲綅鎺�
+                    crnCommand.setDestinationPosY((short) 52);     // 鐩爣搴撲綅鍒�
+                    crnCommand.setDestinationPosZ((short) 3);     // 鐩爣搴撲綅灞�
+//                crnCommand.setTraySize(sourceSta.getLocType1() == 2);     //搴撲綅绫诲瀷
+                    if (!MessageQueue.offer(SlaveType.Crn, wrkMast9997.getCrnNo(), new Task(2, crnCommand))) {
+                        News.error("" + mark + " - 2" + " - 13" + " - 鍫嗗灈鏈哄懡浠や笅鍙戝け璐ワ紝鍫嗗灈鏈哄彿={}锛屼换鍔℃暟鎹�={}", wrkMast9997.getCrnNo(), JSON.toJSON(crnCommand));
+                    } else {
+                        // 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓�
+                        Date now = new Date();
+                        wrkMast9997.setWrkSts(12L);
+                        wrkMast9997.setCrnStrTime(now);
+                        wrkMast9997.setModiTime(now);
+                        if (wrkMastMapper.updateById(wrkMast9997) == 0) {
+                            News.error("" + mark + " - 2" + " - 14" + " - 淇敼宸ヤ綔妗g姸鎬� 11.鐢熸垚鍑哄簱ID => 12.鍚婅溅鍑哄簱涓� 澶辫触锛侊紒锛屽伐浣滃彿={}", wrkMast9997.getWrkNo());
+                        }
+                        break;
+                    }
+                }
+            }
+        }
+        News.infoNoLog(""+mark+" - 2"+" - 0"+" - 鍫嗗灈鏈哄叆鍑哄簱浣滀笟涓嬪彂 锛� 鍑哄簱鎵ц瀹屾瘯");
+    }
 //    /**
 //     * 鍑哄簱  ===>>  搴撲綅鍒板爢鍨涙満绔�
 //     */
@@ -4862,8 +4904,9 @@
                         basArmMast.setArmNo(basArm.getArmNo());
                         basArmMast.setStaNo(basArm.getStaNoSou());
                         basArmMast.setSortingLine(basArm.getSortingLineSou());
-                        if(basArmMastList2.size() > num){
+                        if(basArmMastList2.size() >= num){
                             basArmMastFinal = basArmMast;
+                            num = basArmMastList2.size();
                         }
                     }
                     if(basArmMastFinal != null){
@@ -5518,9 +5561,10 @@
                                 LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no",dto.getLocNo()));
                                 locMast.setBarcode(wrkMast.getBarcode());
                                 locMastService.updateById(locMast);
+                            }else{
+                                agvBindCtnrAndBinParam.setCtnrTyp("1");
+                                ReturnT<String> resultBind = new PostMesDataUtils().postMesDataAgv("AGV瀹瑰櫒缁戝畾", AgvConstant.AGV_URL, AgvConstant.AGV_CTNRANDBING, agvBindCtnrAndBinParam);
                             }
-                            agvBindCtnrAndBinParam.setCtnrTyp("1");
-                            ReturnT<String> resultBind = new PostMesDataUtils().postMesDataAgv("AGV瀹瑰櫒缁戝畾", AgvConstant.AGV_URL, AgvConstant.AGV_CTNRANDBING, agvBindCtnrAndBinParam);
                             wrkMast.setTakeNone("2");
                             wrkMastMapper.updateById(wrkMast);
                         } else {
diff --git a/src/main/java/com/zy/core/thread/SiemensDevpThread.java b/src/main/java/com/zy/core/thread/SiemensDevpThread.java
index 194a78e..0114b65 100644
--- a/src/main/java/com/zy/core/thread/SiemensDevpThread.java
+++ b/src/main/java/com/zy/core/thread/SiemensDevpThread.java
@@ -895,79 +895,83 @@
         Integer offset = siteOffsetMap.get(siteId);
         Integer offset2 = getOffsetBySiteId(siteId);
         Integer offset3 = getOffsetBySiteId2(siteId);
-        //浠诲姟涓嬪彂娆℃暟
         OperateResult write = null;
         OperateResult write1 = null;
+        //浠诲姟涓嬪彂娆℃暟
         int writeCount = 0;
         do {
 
-            String workNoAddress = "";
-            String staNoAddress = "";
-
-            // 鏍规嵁绔欑偣鍒ゆ柇鍦板潃
-            if (siteId < 1029) {
-                workNoAddress = "DB100." + (offset + offset2);
-                staNoAddress = "DB100." + (offset + offset2 + 12);
-            } else if (siteId < 1042) {
-                workNoAddress = "DB101." + (offset + offset2);
-                staNoAddress = "DB101." + (offset + offset2 + 12);
-            } else if (siteId < 1054) {
-                workNoAddress = "DB104." + (offset + offset2);
-                staNoAddress = "DB104." + (offset + offset2 + (specialSites2.contains(siteId) ? 48 : 12));
-            } else if (siteId < 1080) {
-                workNoAddress = "DB103." + (offset + offset2);
-                staNoAddress = "DB103." + (offset + offset2 + (specialSites2.contains(siteId) ? 48 : 12));
-            } else if (siteId < 1111) {
-                workNoAddress = "DB102." + (offset + offset2);
-                staNoAddress = "DB102." + (offset + offset2 + (specialSites2.contains(siteId) ? 48 : 12));
-            } else if (siteId < 2031) {
-                workNoAddress = "DB200." + (offset + offset2);
-                staNoAddress = "DB200." + (offset + offset2 + (specialSites2.contains(siteId) ? 48 : 12));
-            } else if (siteId < 2121) {
-                workNoAddress = "DB201." + (offset + offset2);
-                staNoAddress = "DB201." + (offset + offset2 + (specialSites2.contains(siteId) ? 48 : 12));
-            } else if (siteId < 4000) {
-                Integer offsetBarcode = site2lBarcodeOffsetMap.get(siteId);
-                workNoAddress = "DB202." + offsetBarcode;
-                staNoAddress = "DB202." + offsetBarcode;  // For barcode site, only one address used
-            } else {
-                workNoAddress = "DB400." + (offset + offset2);
-                staNoAddress = "DB400." + (offset + offset2 + (specialSites2.contains(siteId) ? 48 : 12));
-            }
-
-            // 鎵ц鍐欏叆
-            write = siemensS7Net.Write(workNoAddress, staProtocol.getWorkNo()); // 鍐欏叆宸ヤ綔鍙�
-            Thread.sleep(200);
-            write1 = siemensS7Net.Write(staNoAddress, staProtocol.getStaNo().intValue()); // 鍐欏叆鐩爣绔�
-
-            // 璇诲彇骞堕獙璇�
-            if (write.IsSuccess && write1.IsSuccess) {
-                // 鍋囪浣跨敤 ReadInt() 鏂规硶璇诲彇 Int32 鏁版嵁
-                OperateResultExOne<byte[]> readResult1 = siemensS7Net.Read(workNoAddress, (short) 4); // 璇诲彇宸ヤ綔鍙�
-                OperateResultExOne<byte[]> readResult2 = siemensS7Net.Read(staNoAddress,(short) 4); // 璇诲彇鐩爣绔�
-                if (readResult1.IsSuccess && readResult2.IsSuccess) {
-                    Integer writtenWorkNo = staProtocol.getWorkNo();
-                    Integer writtenStaNo = staProtocol.getStaNo().intValue();
-                    Integer workNo = siemensS7Net.getByteTransform().TransInt32(readResult1.Content, 0);
-                    Integer staNo = siemensS7Net.getByteTransform().TransInt32(readResult2.Content, 0);
-
-                    // 瀵规瘮璇诲彇鍒扮殑鏁版嵁涓庡啓鍏ョ殑鏁版嵁鏄惁涓�鑷�
-                    if (workNo == writtenWorkNo && staNo == writtenStaNo) {
-                        log.error("鍐欏叆杈撻�佺嚎鍛戒护鎴愬姛銆傝緭閫佺嚎plc缂栧彿={}锛岀珯鐐规暟鎹�={},鍐欏叆娆℃暟={}", slave.getId(), JSON.toJSON(staProtocol), writeCount);
-                        break; // 鏁版嵁涓�鑷达紝璺冲嚭寰幆
-                    } else {
-                        writeCount++;
-                        log.error("鍐欏叆杈撻�佺嚎鍛戒护澶辫触锛屾暟鎹笉涓�鑷淬�傝緭閫佺嚎plc缂栧彿={}锛岀珯鐐规暟鎹�={},鍐欏叆娆℃暟={}", slave.getId(), JSON.toJSON(staProtocol), writeCount);
-                    }
+            if(siteId < 1029){
+                write = siemensS7Net.Write("DB100." + (offset + offset2), staProtocol.getWorkNo());    // 宸ヤ綔鍙�
+                Thread.sleep(200);
+                write1 = siemensS7Net.Write("DB100." + (offset + offset2 + 12), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+            }else if(siteId < 1042){
+                write = siemensS7Net.Write("DB101." + (offset + offset2), staProtocol.getWorkNo());    // 宸ヤ綔鍙�
+                Thread.sleep(200);
+                write1 = siemensS7Net.Write("DB101." + (offset + offset2 + 12), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+            }else if(siteId < 1054){
+                write = siemensS7Net.Write("DB104." + (offset + offset2), staProtocol.getWorkNo());    // 宸ヤ綔鍙�
+                Thread.sleep(200);
+                if(specialSites2.contains(siteId)){
+                    write1 = siemensS7Net.Write("DB104." + (offset + offset2 + 48), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }else{
+                    write1 = siemensS7Net.Write("DB104." + (offset + offset2 + 12), staProtocol.getStaNo().intValue());    // 鐩爣绔�
                 }
-            } else {
+            }else if(siteId < 1080){
+                write = siemensS7Net.Write("DB103." + (offset + offset2), staProtocol.getWorkNo());    // 宸ヤ綔鍙�
+                Thread.sleep(200);
+                if(specialSites2.contains(siteId)){
+                    write1 = siemensS7Net.Write("DB103." + (offset + offset2 + 48), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }else{
+                    write1 = siemensS7Net.Write("DB103." + (offset + offset2 + 12), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }
+            }else if(siteId < 1111){
+                write = siemensS7Net.Write("DB102." + (offset + offset2), staProtocol.getWorkNo());    // 宸ヤ綔鍙�
+                Thread.sleep(200);
+                if(specialSites2.contains(siteId)){
+                    write1 = siemensS7Net.Write("DB102." + (offset + offset2 + 48), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }else{
+                    write1 = siemensS7Net.Write("DB102." + (offset + offset2 + 12), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }
+            }else if(siteId < 2031){
+                write = siemensS7Net.Write("DB200." + (offset + offset2), staProtocol.getWorkNo());    // 宸ヤ綔鍙�
+                Thread.sleep(200);
+                if(specialSites2.contains(siteId)){
+                    write1 = siemensS7Net.Write("DB200." + (offset + offset2 + 48), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }else{
+                    write1 = siemensS7Net.Write("DB200." + (offset + offset2 + 12), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }
+            }else if(siteId < 2121){
+                write = siemensS7Net.Write("DB201." + (offset + offset2), staProtocol.getWorkNo());    // 宸ヤ綔鍙�
+                Thread.sleep(200);
+                if(specialSites2.contains(siteId)){
+                    write1 = siemensS7Net.Write("DB201." + (offset + offset2 + 48), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }else{
+                    write1 = siemensS7Net.Write("DB201." + (offset + offset2 + 12), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }
+            } else if(siteId < 4000){
+                Integer offsetBarcode = site2lBarcodeOffsetMap.get(siteId);
+                write = siemensS7Net.Write("DB202." + offsetBarcode, staProtocol.getBarcode());    // 鏉$爜
+                write1 = siemensS7Net.Write("DB202." + offsetBarcode, staProtocol.getBarcode());
+                Thread.sleep(200);
+            }else{
+                write = siemensS7Net.Write("DB400." + (offset + offset2), staProtocol.getWorkNo());    // 宸ヤ綔鍙�
+                Thread.sleep(200);
+                if(specialSites2.contains(siteId)){
+                    write1 = siemensS7Net.Write("DB400." + (offset + offset2 + 48), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }else{
+                    write1 = siemensS7Net.Write("DB400." + (offset + offset2 + 12), staProtocol.getStaNo().intValue());    // 鐩爣绔�
+                }
+            }
+            if(write.IsSuccess && write1.IsSuccess){
+                log.error("鍐欏叆杈撻�佺嚎鍛戒护鎴愬姛銆傝緭閫佺嚎plc缂栧彿={}锛岀珯鐐规暟鎹�={},鍐欏叆娆℃暟={}", slave.getId(), JSON.toJSON(staProtocol), writeCount);
+                break;
+            }
+            else {
                 writeCount++;
                 log.error("鍐欏叆杈撻�佺嚎鍛戒护澶辫触銆傝緭閫佺嚎plc缂栧彿={}锛岀珯鐐规暟鎹�={},鍐欏叆娆℃暟={}", slave.getId(), JSON.toJSON(staProtocol), writeCount);
             }
-
-        } while (writeCount < 5); // 閲嶈瘯鏈�澶�5娆�
-
-
+        }while (writeCount<5);
         try {
             // 鏃ュ織璁板綍
             BasDevpOptService bean = SpringUtils.getBean(BasDevpOptService.class);
diff --git a/src/main/resources/mapper/WrkMastStaMapper.xml b/src/main/resources/mapper/WrkMastStaMapper.xml
index ebc1221..9250187 100644
--- a/src/main/resources/mapper/WrkMastStaMapper.xml
+++ b/src/main/resources/mapper/WrkMastStaMapper.xml
@@ -119,10 +119,12 @@
         or sta_end = 0
         )
         and wrk_sts=0
-        and sta_end in (2006.2012,2018,2024,2030,1004,1014,1018,1028,1035)
         and wrk_no = #{workNo}
-        order by
-        case when mk = 1 then 0 else 1 end,
+        ORDER BY
+        CASE
+        WHEN mk = 1 THEN 0
+        ELSE 1
+        END,
         line_number,
         id
     </select>

--
Gitblit v1.9.1