From c88db5e02d675f2a877ec484dd39ad5baab0d0b8 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期六, 12 九月 2020 14:58:47 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java |  308 ++++++++++++++++++++++++++++----------------------
 1 files changed, 173 insertions(+), 135 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 3932449..0767166 100644
--- a/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java
@@ -35,8 +35,12 @@
 import org.springframework.scheduling.annotation.Async;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
+import org.springframework.transaction.interceptor.TransactionAspectSupport;
 
-import java.util.*;
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.List;
+import java.util.Set;
 import java.util.stream.Collectors;
 
 /**
@@ -47,6 +51,27 @@
 @Service("mainService")
 @Transactional
 public class MainServiceImpl {
+
+    @Autowired
+    private RowLastnoService rowLastnoService;
+
+    public void test(){
+        try {
+            // 宸ヤ綔鍙�
+            int workNo = commonService.getWorkNo(0);
+            System.out.println(workNo);
+            if (workNo > 0) {
+                throw new CoolException("21321");
+            }
+            RowLastno rowLastno = rowLastnoService.selectById(1);
+            rowLastno.setCurrentRow(rowLastno.getCurrentRow() + 1);
+            rowLastnoService.updateById(rowLastno);
+            System.out.println(rowLastno.getCurrentRow());
+        } catch (Exception e) {
+            e.printStackTrace();
+            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+        }
+    }
 
     @Autowired
     private CommonService commonService;
@@ -103,61 +128,67 @@
                         log.error("鏃犳鍏ュ簱鏉$爜鏁版嵁銆傛潯鐮佸彿={}", barcode);
                         continue;
                     }
-                    // 宸ヤ綔鍙�
-                    int workNo = commonService.getWorkNo(0);
-                    // 妫�绱㈠簱浣�
-                    List<String> matNos = waitPakins.stream().map(WaitPakin::getMatnr).distinct().collect(Collectors.toList());
-                    StartupDto startupDto = commonService.getLocNo(1, 1, inSta.getStaNo(), matNos);
-                    // 鎻掑叆宸ヤ綔鏄庣粏妗�
-                    wrkDetlService.createWorkDetail(workNo, waitPakins, barcode);
 
-                    // 鎻掑叆宸ヤ綔涓绘。
-                    wrkMast = new WrkMast();
-                    wrkMast.setWrkNo(workNo);
-                    wrkMast.setIoTime(new Date());
-                    wrkMast.setWrkSts(2L); // 宸ヤ綔鐘舵�侊細2.璁惧涓婅蛋
-                    wrkMast.setIoType(1); // 鍏ュ嚭搴撶姸鎬侊細1.鍏ュ簱
-                    wrkMast.setIoPri(10D); // 浼樺厛绾э細10
-                    wrkMast.setCrnNo(startupDto.getCrnNo());
-                    wrkMast.setSourceStaNo(startupDto.getSourceStaNo());
-                    wrkMast.setStaNo(startupDto.getStaNo());
-                    wrkMast.setLocNo(startupDto.getLocNo());
-                    wrkMast.setBarcode(barcode); // 鎵樼洏鐮�
-                    wrkMast.setFullPlt("Y"); // 婊℃澘锛歒
-                    wrkMast.setPicking("N"); // 鎷f枡
-                    wrkMast.setExitMk("N"); // 閫�鍑�
-                    wrkMast.setEmptyMk("N"); // 绌烘澘
-                    wrkMast.setLinkMis("N");
+                    try {
+                        // 宸ヤ綔鍙�
+                        int workNo = commonService.getWorkNo(0);
+                        // 妫�绱㈠簱浣�
+                        List<String> matNos = waitPakins.stream().map(WaitPakin::getMatnr).distinct().collect(Collectors.toList());
+                        StartupDto startupDto = commonService.getLocNo(1, 1, inSta.getStaNo(), matNos);
+                        // 鎻掑叆宸ヤ綔鏄庣粏妗�
+                        wrkDetlService.createWorkDetail(workNo, waitPakins, barcode);
+
+                        // 鎻掑叆宸ヤ綔涓绘。
+                        wrkMast = new WrkMast();
+                        wrkMast.setWrkNo(workNo);
+                        wrkMast.setIoTime(new Date());
+                        wrkMast.setWrkSts(2L); // 宸ヤ綔鐘舵�侊細2.璁惧涓婅蛋
+                        wrkMast.setIoType(1); // 鍏ュ嚭搴撶姸鎬侊細1.鍏ュ簱
+                        wrkMast.setIoPri(10D); // 浼樺厛绾э細10
+                        wrkMast.setCrnNo(startupDto.getCrnNo());
+                        wrkMast.setSourceStaNo(startupDto.getSourceStaNo());
+                        wrkMast.setStaNo(startupDto.getStaNo());
+                        wrkMast.setLocNo(startupDto.getLocNo());
+                        wrkMast.setBarcode(barcode); // 鎵樼洏鐮�
+                        wrkMast.setFullPlt("Y"); // 婊℃澘锛歒
+                        wrkMast.setPicking("N"); // 鎷f枡
+                        wrkMast.setExitMk("N"); // 閫�鍑�
+                        wrkMast.setEmptyMk("N"); // 绌烘澘
+                        wrkMast.setLinkMis("N");
 //                    wrkMast.setCtnType(sourceStaNo.getCtnType()); // 瀹瑰櫒绫诲瀷
-                    // 鎿嶄綔浜哄憳鏁版嵁
-                    wrkMast.setAppeTime(new Date());
-                    wrkMast.setModiTime(new Date());
-                    Integer insert = wrkMastMapper.insert(wrkMast);
-                    if (insert == 0) {
-                        throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐�");
-                    }
-                    // 鏇存柊鐩爣搴撲綅鐘舵��
-                    LocMast locMast = locMastService.selectById(startupDto.getLocNo());
-                    locMast.setLocSts("S"); // S.鍏ュ簱棰勭害
-                    locMast.setModiTime(new Date());
-                    if (!locMastService.updateById(locMast)){
-                        throw new CoolException("鏀瑰彉搴撲綅鐘舵�佸け璐�");
-                    }
-                    // 灏嗗叆搴撻�氱煡妗d慨鏀逛负宸插惎鍔�
-                    if (wrkMastMapper.updateWaitPakInStep1(barcode) == 0) {
-                        throw new CoolException("淇敼鍏ュ簱閫氱煡妗g姸鎬佷负宸插惎鍔ㄥけ璐�");
-                    }
+                        // 鎿嶄綔浜哄憳鏁版嵁
+                        wrkMast.setAppeTime(new Date());
+                        wrkMast.setModiTime(new Date());
+                        Integer insert = wrkMastMapper.insert(wrkMast);
+                        if (insert == 0) {
+                            throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐�");
+                        }
+                        // 鏇存柊鐩爣搴撲綅鐘舵��
+                        LocMast locMast = locMastService.selectById(startupDto.getLocNo());
+                        locMast.setLocSts("S"); // S.鍏ュ簱棰勭害
+                        locMast.setModiTime(new Date());
+                        if (!locMastService.updateById(locMast)){
+                            throw new CoolException("鏀瑰彉搴撲綅鐘舵�佸け璐�");
+                        }
+                        // 灏嗗叆搴撻�氱煡妗d慨鏀逛负宸插惎鍔�
+                        if (wrkMastMapper.updateWaitPakInStep1(barcode) == 0) {
+                            throw new CoolException("淇敼鍏ュ簱閫氱煡妗g姸鎬佷负宸插惎鍔ㄥけ璐�");
+                        }
 
-                    // 鍛戒护涓嬪彂鍖� --------------------------------------------------------------------------
+                        // 鍛戒护涓嬪彂鍖� --------------------------------------------------------------------------
 
-                    // 鏇存柊绔欑偣淇℃伅 涓� 涓嬪彂plc鍛戒护
-                    barcodeThread.setBarcode("");
-                    staProtocol.setWorkNo((short) workNo);
-                    staProtocol.setStaNo(startupDto.getStaNo().shortValue());
-                    staProtocol.setPakMk(false);
-                    boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocol));
-                    if (!result) {
-                        throw new CoolException("鏇存柊plc绔欑偣淇℃伅澶辫触");
+                        // 鏇存柊绔欑偣淇℃伅 涓� 涓嬪彂plc鍛戒护
+                        barcodeThread.setBarcode("");
+                        staProtocol.setWorkNo((short) workNo);
+                        staProtocol.setStaNo(startupDto.getStaNo().shortValue());
+                        staProtocol.setPakMk(false);
+                        boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocol));
+                        if (!result) {
+                            throw new CoolException("鏇存柊plc绔欑偣淇℃伅澶辫触");
+                        }
+
+                    } catch (Exception e) {
+                        TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
                     }
 
                 }
@@ -259,39 +290,40 @@
                         continue;
                     }
 
-                    // todo:luxiaotao
+                    try {
+                        // 淇濆瓨宸ヤ綔鏄庣粏妗e巻鍙叉。
+                        if (wrkMastMapper.saveWrkDetlLog(wrkMast.getWrkNo()) == 0) {
+                            throw new CoolException("淇濆瓨宸ヤ綔鏄庣粏妗e巻鍙叉。澶辫触");
+                        }
+                        // 淇濆瓨宸ヤ綔涓绘。鍘嗗彶妗�
+                        if (wrkMastMapper.saveWrkMastLog(wrkMast.getWrkNo()) == 0) {
+                            throw new CoolException("淇濆瓨宸ヤ綔涓绘。鍘嗗彶妗eけ璐�");
+                        }
 
-                    // 淇濆瓨宸ヤ綔鏄庣粏妗e巻鍙叉。
-                    if (wrkMastMapper.saveWrkDetlLog(wrkMast.getWrkNo()) == 0) {
-                        throw new CoolException("淇濆瓨宸ヤ綔鏄庣粏妗e巻鍙叉。澶辫触");
+                        // 鍫嗗灈鏈虹珯鐐�(鐩爣绔�)
+                        Integer staNo = staDesc.getCrnStn();
+                        // 鏇存柊宸ヤ綔妗f暟鎹姸鎬�
+                        wrkMast.setIoType(wrkMast.getIoType() - 50); // 鍏ュ嚭搴撶被鍨�: 103->53,104->54,107->57
+                        wrkMast.setWrkSts(2L); // 宸ヤ綔鐘舵��: 2.璁惧涓婅蛋
+                        wrkMast.setSourceStaNo(wrkMast.getStaNo()); // 婧愮珯
+                        wrkMast.setStaNo(staNo); // 鐩爣绔�
+                        wrkMast.setLocNo(wrkMast.getSourceLocNo()); // 鐩爣搴撲綅 = 鍑哄簱鏃剁殑婧愬簱浣�
+                        wrkMast.setSourceLocNo(""); // 婧愬簱浣嶆竻绌�
+                        wrkMast.setModiTime(new Date());
+                        if (wrkMastMapper.updateById(wrkMast) == 0) {
+                            throw new CoolException("鏇存柊宸ヤ綔妗f暟鎹姸鎬佸け璐�");
+                        }
+                        // 淇敼搴撲綅鐘舵�� Q.鎷f枡/鐩樼偣/骞舵澘鍐嶅叆搴�
+                        LocMast locMast = locMastService.selectById(wrkMast.getLocNo());
+                        locMast.setLocSts("Q");
+                        locMast.setModiTime(new Date());
+                        if (!locMastService.updateById(locMast)) {
+                            throw new CoolException("淇敼搴撲綅鐘舵�佸け璐�");
+                        }
+                    } catch (Exception e) {
+                        e.printStackTrace();
+                        TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
                     }
-                    // 淇濆瓨宸ヤ綔涓绘。鍘嗗彶妗�
-                    if (wrkMastMapper.saveWrkMastLog(wrkMast.getWrkNo()) == 0) {
-                        throw new CoolException("淇濆瓨宸ヤ綔涓绘。鍘嗗彶妗eけ璐�");
-                    }
-
-                    // 鍫嗗灈鏈虹珯鐐�(鐩爣绔�)
-                    Integer staNo = staDesc.getCrnStn();
-                    // 鏇存柊宸ヤ綔妗f暟鎹姸鎬�
-                    wrkMast.setIoType(wrkMast.getIoType() - 50); // 鍏ュ嚭搴撶被鍨�: 103->53,104->54,107->57
-                    wrkMast.setWrkSts(2L); // 宸ヤ綔鐘舵��: 2.璁惧涓婅蛋
-                    wrkMast.setSourceStaNo(wrkMast.getStaNo()); // 婧愮珯
-                    wrkMast.setStaNo(staNo); // 鐩爣绔�
-                    wrkMast.setLocNo(wrkMast.getSourceLocNo()); // 鐩爣搴撲綅 = 鍑哄簱鏃剁殑婧愬簱浣�
-                    wrkMast.setSourceLocNo(""); // 婧愬簱浣嶆竻绌�
-                    wrkMast.setModiTime(new Date());
-                    if (wrkMastMapper.updateById(wrkMast) == 0) {
-                        throw new CoolException("鏇存柊宸ヤ綔妗f暟鎹姸鎬佸け璐�");
-                    }
-                    // 淇敼搴撲綅鐘舵�� Q.鎷f枡/鐩樼偣/骞舵澘鍐嶅叆搴�
-                    LocMast locMast = locMastService.selectById(wrkMast.getLocNo());
-                    locMast.setLocSts("Q");
-                    locMast.setModiTime(new Date());
-                    if (!locMastService.updateById(locMast)) {
-                        throw new CoolException("淇敼搴撲綅鐘舵�佸け璐�");
-                    }
-
-
 
                 }
 
@@ -686,50 +718,52 @@
                     // 妫�绱㈠簱浣�
                     StartupDto startupDto = commonService.getLocNo(1, 10, emptyInSta.getStaNo(), null);
 
-                    // todo:luxiaotao
-
-                    // 鎻掑叆宸ヤ綔涓绘。
-                    WrkMast wrkMast = new WrkMast();
-                    wrkMast.setWrkNo(workNo);
-                    wrkMast.setIoTime(new Date());
-                    wrkMast.setWrkSts(2L); // 宸ヤ綔鐘舵�侊細2.璁惧涓婅蛋
-                    wrkMast.setIoType(10); // 鍏ュ嚭搴撶姸鎬侊細10.绌烘澘鍏ュ簱
-                    wrkMast.setIoPri(10D); // 浼樺厛绾э細10
-                    wrkMast.setCrnNo(startupDto.getCrnNo());
-                    wrkMast.setSourceStaNo(startupDto.getSourceStaNo());
-                    wrkMast.setStaNo(startupDto.getStaNo());
-                    wrkMast.setLocNo(startupDto.getLocNo());
-                    wrkMast.setFullPlt("N"); // 婊℃澘
-                    wrkMast.setPicking("N"); // 鎷f枡
-                    wrkMast.setExitMk("N"); // 閫�鍑�
-                    wrkMast.setEmptyMk("Y"); // 绌烘澘
-                    wrkMast.setLinkMis("N");
+                    try {
+                        // 鎻掑叆宸ヤ綔涓绘。
+                        WrkMast wrkMast = new WrkMast();
+                        wrkMast.setWrkNo(workNo);
+                        wrkMast.setIoTime(new Date());
+                        wrkMast.setWrkSts(2L); // 宸ヤ綔鐘舵�侊細2.璁惧涓婅蛋
+                        wrkMast.setIoType(10); // 鍏ュ嚭搴撶姸鎬侊細10.绌烘澘鍏ュ簱
+                        wrkMast.setIoPri(10D); // 浼樺厛绾э細10
+                        wrkMast.setCrnNo(startupDto.getCrnNo());
+                        wrkMast.setSourceStaNo(startupDto.getSourceStaNo());
+                        wrkMast.setStaNo(startupDto.getStaNo());
+                        wrkMast.setLocNo(startupDto.getLocNo());
+                        wrkMast.setFullPlt("N"); // 婊℃澘
+                        wrkMast.setPicking("N"); // 鎷f枡
+                        wrkMast.setExitMk("N"); // 閫�鍑�
+                        wrkMast.setEmptyMk("Y"); // 绌烘澘
+                        wrkMast.setLinkMis("N");
 //                    wrkMast.setCtnType(sourceStaNo.getCtnType()); // 瀹瑰櫒绫诲瀷
-                    // 鎿嶄綔浜哄憳鏁版嵁
-                    wrkMast.setAppeTime(new Date());
-                    wrkMast.setModiTime(new Date());
-                    Integer insert = wrkMastMapper.insert(wrkMast);
-                    if (insert == 0) {
-                        throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐�");
-                    }
-                    // 鏇存柊鐩爣搴撲綅鐘舵��
-                    LocMast locMast = locMastService.selectById(startupDto.getLocNo());
-                    locMast.setLocSts("S"); // S.鍏ュ簱棰勭害
-                    locMast.setModiTime(new Date());
-                    if (!locMastService.updateById(locMast)){
-                        throw new CoolException("鏀瑰彉搴撲綅鐘舵�佸け璐�");
-                    }
-                    // 鍛戒护涓嬪彂鍖� --------------------------------------------------------------------------
+                        // 鎿嶄綔浜哄憳鏁版嵁
+                        wrkMast.setAppeTime(new Date());
+                        wrkMast.setModiTime(new Date());
+                        Integer insert = wrkMastMapper.insert(wrkMast);
+                        if (insert == 0) {
+                            throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐�");
+                        }
+                        // 鏇存柊鐩爣搴撲綅鐘舵��
+                        LocMast locMast = locMastService.selectById(startupDto.getLocNo());
+                        locMast.setLocSts("S"); // S.鍏ュ簱棰勭害
+                        locMast.setModiTime(new Date());
+                        if (!locMastService.updateById(locMast)){
+                            throw new CoolException("鏀瑰彉搴撲綅鐘舵�佸け璐�");
+                        }
+                        // 鍛戒护涓嬪彂鍖� --------------------------------------------------------------------------
 
-                    // 鏇存柊绔欑偣淇℃伅 涓� 涓嬪彂plc鍛戒护
-                    staProtocol.setWorkNo((short) workNo);
-                    staProtocol.setStaNo(startupDto.getStaNo().shortValue());
-                    staProtocol.setPakMk(false);
-                    boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocol));
-                    if (!result) {
-                        throw new CoolException("鏇存柊plc绔欑偣淇℃伅澶辫触");
+                        // 鏇存柊绔欑偣淇℃伅 涓� 涓嬪彂plc鍛戒护
+                        staProtocol.setWorkNo((short) workNo);
+                        staProtocol.setStaNo(startupDto.getStaNo().shortValue());
+                        staProtocol.setPakMk(false);
+                        boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocol));
+                        if (!result) {
+                            throw new CoolException("鏇存柊plc绔欑偣淇℃伅澶辫触");
+                        }
+                    } catch (Exception e) {
+                        e.printStackTrace();
+                        TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
                     }
-
 
                 }
 
@@ -806,19 +840,23 @@
                 }
             }
 
-            // todo:luxiaotao
-
-            // 淇敼涓绘。led鏍囪
-            for (WrkMast wrkMast : wrkMasts) {
-                wrkMast.setOveMk("Y");
-                wrkMast.setModiTime(new Date());
-                if (wrkMastMapper.updateById(wrkMast) == 0) {
-                    throw new CoolException("鏇存柊宸ヤ綔妗eけ璐�");
+            try {
+                // 淇敼涓绘。led鏍囪
+                for (WrkMast wrkMast : wrkMasts) {
+                    wrkMast.setOveMk("Y");
+                    wrkMast.setModiTime(new Date());
+                    if (wrkMastMapper.updateById(wrkMast) == 0) {
+                        throw new CoolException("鏇存柊宸ヤ綔妗eけ璐�");
+                    }
                 }
-            }
 
-            // 鏇存柊绾跨▼褰撳墠宸ヤ綔鍙烽泦鍚�
-            ledThread.setWorkNos(workNos);
+                // 鏇存柊绾跨▼褰撳墠宸ヤ綔鍙烽泦鍚�
+                ledThread.setWorkNos(workNos);
+
+            } catch (Exception e) {
+                e.printStackTrace();
+                TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+            }
 
         }
     }

--
Gitblit v1.9.1