From 2e71ee94af4962b9aaf83805bc912d9a8fe118fa Mon Sep 17 00:00:00 2001
From: whycq <123456>
Date: 星期一, 08 八月 2022 13:31:43 +0800
Subject: [PATCH] #

---
 src/main/resources/mapper/WrkDetlMapper.xml                 |    8 
 src/main/java/com/zy/asrs/utils/VersionUtils.java           |   14 
 src/main/java/com/zy/core/thread/LedThread.java             |   39 +-
 src/main/java/com/zy/asrs/entity/LocDetl.java               |  234 +++++++++++++------
 src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java |   10 
 src/main/resources/mapper/LocDetlMapper.xml                 |   51 +++-
 src/main/java/com/zy/asrs/entity/WrkDetl.java               |  309 ++++++++++++++++++++-----
 src/main/resources/application.yml                          |   12 
 8 files changed, 480 insertions(+), 197 deletions(-)

diff --git a/src/main/java/com/zy/asrs/entity/LocDetl.java b/src/main/java/com/zy/asrs/entity/LocDetl.java
index 9899b48..87c44d8 100644
--- a/src/main/java/com/zy/asrs/entity/LocDetl.java
+++ b/src/main/java/com/zy/asrs/entity/LocDetl.java
@@ -1,14 +1,13 @@
 package com.zy.asrs.entity;
 
+import com.alibaba.excel.annotation.ExcelProperty;
 import com.baomidou.mybatisplus.annotations.TableField;
-import com.baomidou.mybatisplus.annotations.TableId;
 import com.baomidou.mybatisplus.annotations.TableName;
-import com.baomidou.mybatisplus.enums.IdType;
+import com.core.common.Cools;
+import com.core.common.SpringUtils;
 import com.zy.asrs.service.LocMastService;
 import com.zy.system.entity.User;
 import com.zy.system.service.UserService;
-import com.core.common.Cools;
-import com.core.common.SpringUtils;
 import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
 
@@ -22,57 +21,119 @@
 
     private static final long serialVersionUID = 1L;
 
-
     @ApiModelProperty(value= "搴撲綅鍙�")
-    @TableId(value = "loc_no", type = IdType.INPUT)
     @TableField("loc_no")
     private String locNo;
-
-    @ApiModelProperty(value= "浜у搧缂栫爜")
-    @TableId(value = "mat_no", type = IdType.INPUT)
-    @TableField("mat_no")
-    private String matNo;
-
-    @ApiModelProperty(value= "浜у搧鍚嶇О")
-    @TableId(value = "mat_name")
-    @TableField("mat_name")
-    private String matName;
-
-    @ApiModelProperty(value= "瑙勬牸")
-    private String specs;
-
-    @ApiModelProperty(value= "灏哄")
-    private String size;
-
-    @ApiModelProperty(value= "棰滆壊")
-    private String color;
-
-    @ApiModelProperty(value= "鍗曢噸")
-    private Double weight;
-
-    @ApiModelProperty(value= "渚涘簲鍟�")
-    private String supplier;
-
-    @ApiModelProperty(value= "浠撳簱")
-    private String warehouse;
-
-    @ApiModelProperty(value= "鍝佺墝")
-    private String brand;
-
-    @ApiModelProperty(value= "鏁伴噺")
-    private Double qty;
-
-    @ApiModelProperty(value= "鍗曚綅")
-    private String unit;
 
     @ApiModelProperty(value= "鎵樼洏鏉$爜")
     private String zpallet;
 
-    @ApiModelProperty(value= "鐢ㄦ埛ID")
-    private String bname;
+    @ApiModelProperty(value= "鏁伴噺")
+    @ExcelProperty("鏁伴噺")
+    private Double anfme;
 
-    @ApiModelProperty(value= "澶囨敞")
-    private String memo;
+    @ApiModelProperty(value= "鍟嗗搧缂栧彿")
+    @ExcelProperty("鍟嗗搧缂栧彿")
+    private String matnr;
+
+    @ApiModelProperty(value= "鍟嗗搧鍚嶇О")
+    @ExcelProperty("鍟嗗搧鍚嶇О")
+    private String maktx;
+
+    @ApiModelProperty(value= "鎵瑰彿")
+    @ExcelProperty("鎵瑰彿")
+    private String batch;
+
+    @ApiModelProperty(value= "鍗曟嵁缂栧彿")
+    @ExcelProperty("鍗曟嵁缂栧彿")
+    @TableField("order_no")
+    private String orderNo;
+
+    @ApiModelProperty(value= "瑙勬牸")
+    private String specs;
+
+    @ApiModelProperty(value= "鍨嬪彿")
+    private String model;
+
+    @ApiModelProperty(value= "棰滆壊")
+    private String color;
+
+    @ApiModelProperty(value= "鍝佺墝")
+    private String brand;
+
+    @ApiModelProperty(value= "鍗曚綅")
+    private String unit;
+
+    @ApiModelProperty(value= "鍗曚环")
+    private Double price;
+
+    @ApiModelProperty(value= "sku")
+    private String sku;
+
+    @ApiModelProperty(value= "鍗曚綅閲�")
+    private Double units;
+
+    @ApiModelProperty(value= "鏉$爜")
+    private String barcode;
+
+    @ApiModelProperty(value= "浜у湴")
+    private String origin;
+
+    @ApiModelProperty(value= "鍘傚")
+    private String manu;
+
+    @ApiModelProperty(value= "鐢熶骇鏃ユ湡")
+    @TableField("manu_date")
+    private String manuDate;
+
+    @ApiModelProperty(value= "鍝侀」鏁�")
+    @TableField("item_num")
+    private String itemNum;
+
+    @ApiModelProperty(value= "瀹夊叏搴撳瓨閲�")
+    @TableField("safe_qty")
+    private Double safeQty;
+
+    @ApiModelProperty(value= "閲嶉噺")
+    private Double weight;
+
+    @ApiModelProperty(value= "闀垮害")
+    private Double length;
+
+    @ApiModelProperty(value= "浣撶Н")
+    private Double volume;
+
+    @ApiModelProperty(value= "涓夋柟缂栫爜")
+    @TableField("three_code")
+    private String threeCode;
+
+    @ApiModelProperty(value= "渚涘簲鍟�")
+    private String supp;
+
+    @ApiModelProperty(value= "渚涘簲鍟嗙紪鐮�")
+    @TableField("supp_code")
+    private String suppCode;
+
+    @ApiModelProperty(value= "鏄惁鎵规 1: 鏄�  0: 鍚�  ")
+    @TableField("be_batch")
+    private Integer beBatch;
+
+    @ApiModelProperty(value= "淇濊川鏈�")
+    @TableField("dead_time")
+    private String deadTime;
+
+    @ApiModelProperty(value= "棰勮澶╂暟")
+    @TableField("dead_warn")
+    private Integer deadWarn;
+
+    @ApiModelProperty(value= "鍒惰喘 1: 鍒堕��  2: 閲囪喘  3: 澶栧崗  ")
+    private Integer source;
+
+    @ApiModelProperty(value= "瑕佹眰妫�楠� 1: 鏄�  0: 鍚�  ")
+    private Integer inspect;
+
+    @ApiModelProperty(value= "鍗遍櫓鍝� 1: 鏄�  0: 鍚�  ")
+    private Integer danger;
 
     @ApiModelProperty(value= "淇敼浜哄憳")
     @TableField("modi_user")
@@ -90,30 +151,8 @@
     @TableField("appe_time")
     private Date appeTime;
 
-    @TableField("bill_no")
-    private String billNo;
-
-    @TableField("seq_no")
-    private int seqNo;
-
-    @TableField("bill_type")
-    private int billType;
-
-    @TableField("object_id")
-    private String objectId;
-
-    @TableField("object_name")
-    private String objectName;
-
-    @TableField("det_id")
-    private int detId;
-
-    @TableId(value = "Item_batch", type = IdType.INPUT)
-    @TableField("Item_batch")
-    private String itemBatch;
-
-    @TableField("order_no")
-    private String orderNo;
+    @ApiModelProperty(value= "澶囨敞")
+    private String memo;
 
     public String getLocNo$(){
         LocMastService service = SpringUtils.getBean(LocMastService.class);
@@ -122,6 +161,56 @@
             return String.valueOf(locMast.getLocNo());
         }
         return null;
+    }
+
+    public String getBeBatch$(){
+        if (null == this.beBatch){ return null; }
+        switch (this.beBatch){
+            case 1:
+                return "鏄�";
+            case 0:
+                return "鍚�";
+            default:
+                return String.valueOf(this.beBatch);
+        }
+    }
+
+    public String getSource$(){
+        if (null == this.source){ return null; }
+        switch (this.source){
+            case 1:
+                return "鍒堕��";
+            case 2:
+                return "閲囪喘";
+            case 3:
+                return "澶栧崗";
+            default:
+                return String.valueOf(this.source);
+        }
+    }
+
+    public String getInspect$(){
+        if (null == this.inspect){ return null; }
+        switch (this.inspect){
+            case 1:
+                return "鏄�";
+            case 0:
+                return "鍚�";
+            default:
+                return String.valueOf(this.inspect);
+        }
+    }
+
+    public String getDanger$(){
+        if (null == this.danger){ return null; }
+        switch (this.danger){
+            case 1:
+                return "鏄�";
+            case 0:
+                return "鍚�";
+            default:
+                return String.valueOf(this.danger);
+        }
     }
 
     public String getModiUser$(){
@@ -140,7 +229,6 @@
         return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.modiTime);
     }
 
-
     public String getAppeUser$(){
         UserService service = SpringUtils.getBean(UserService.class);
         User user = service.selectById(this.appeUser);
@@ -156,4 +244,6 @@
         }
         return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.appeTime);
     }
+
+
 }
diff --git a/src/main/java/com/zy/asrs/entity/WrkDetl.java b/src/main/java/com/zy/asrs/entity/WrkDetl.java
index 37c368d..05c9703 100644
--- a/src/main/java/com/zy/asrs/entity/WrkDetl.java
+++ b/src/main/java/com/zy/asrs/entity/WrkDetl.java
@@ -1,24 +1,19 @@
 package com.zy.asrs.entity;
 
 import com.baomidou.mybatisplus.annotations.TableField;
-import com.baomidou.mybatisplus.annotations.TableId;
 import com.baomidou.mybatisplus.annotations.TableName;
 import com.core.common.Cools;
 import com.core.common.SpringUtils;
 import com.zy.system.entity.User;
 import com.zy.system.service.UserService;
 import io.swagger.annotations.ApiModelProperty;
-import lombok.AllArgsConstructor;
 import lombok.Data;
-import lombok.NoArgsConstructor;
 
 import java.io.Serializable;
 import java.text.SimpleDateFormat;
 import java.util.Date;
 
 @Data
-@NoArgsConstructor
-@AllArgsConstructor
 @TableName("asr_wrk_detl")
 public class WrkDetl implements Serializable {
 
@@ -38,59 +33,11 @@
     @TableField("io_time")
     private Date ioTime;
 
-    @ApiModelProperty(value= "浜у搧缂栫爜")
-    @TableId(value = "mat_no")
-    @TableField("mat_no")
-    private String matNo;
-
-    @ApiModelProperty(value= "浜у搧鍚嶇О")
-    @TableId(value = "mat_name")
-    @TableField("mat_name")
-    private String matName;
-
-    @ApiModelProperty(value= "瑙勬牸")
-    private String specs;
-
-    @ApiModelProperty(value= "灏哄")
-    private String size;
-
-    @ApiModelProperty(value= "棰滆壊")
-    private String color;
-
-    @ApiModelProperty(value= "鍗曢噸")
-    private Double weight;
-
-    /**
-     * 鍗曟嵁缂栧彿
-     */
-    @ApiModelProperty(value= "鍗曟嵁缂栧彿")
-    @TableField("bill_no")
-    private String billNo;
-
-    /**
-     * 搴忓彿
-     */
-    @ApiModelProperty(value= "搴忓彿")
-    @TableField("seq_no")
-    private Integer seqNo;
-
-    /**
-     * 浠撳簱鍙�
-     */
-    @ApiModelProperty(value= "鍝佺墝")
-    private String brand;
-
     /**
      * 鏁伴噺
      */
     @ApiModelProperty(value= "鏁伴噺")
-    private Double qty;
-
-    /**
-     * 鍗曚綅
-     */
-    @ApiModelProperty(value= "鍗曚綅")
-    private String unit;
+    private Double anfme;
 
     /**
      * 鎵樼洏鏉$爜
@@ -99,16 +46,193 @@
     private String zpallet;
 
     /**
-     * 鐢ㄦ埛ID
+     * 鐗╂枡
      */
-    @ApiModelProperty(value= "鐢ㄦ埛ID")
-    private String bname;
+    @ApiModelProperty(value= "鍟嗗搧缂栧彿")
+    private String matnr;
 
     /**
-     * 澶囨敞
+     * 鐗╂枡鎻忚堪
      */
-    @ApiModelProperty(value= "澶囨敞")
-    private String memo;
+    @ApiModelProperty(value= "鍟嗗搧鍚嶇О")
+    private String maktx;
+
+    /**
+     * 鎵瑰彿
+     */
+    @ApiModelProperty(value= "鎵瑰彿")
+    private String batch;
+
+    /**
+     * 鍗曟嵁缂栧彿
+     */
+    @ApiModelProperty(value= "鍗曟嵁缂栧彿")
+    @TableField("order_no")
+    private String orderNo;
+
+    /**
+     * 瑙勬牸
+     */
+    @ApiModelProperty(value= "瑙勬牸")
+    private String specs;
+
+    /**
+     * 鍨嬪彿
+     */
+    @ApiModelProperty(value= "鍨嬪彿")
+    private String model;
+
+    /**
+     * 棰滆壊
+     */
+    @ApiModelProperty(value= "棰滆壊")
+    private String color;
+
+    /**
+     * 鍝佺墝
+     */
+    @ApiModelProperty(value= "鍝佺墝")
+    private String brand;
+
+    /**
+     * 鍗曚綅
+     */
+    @ApiModelProperty(value= "鍗曚綅")
+    private String unit;
+
+    /**
+     * 鍗曚环
+     */
+    @ApiModelProperty(value= "鍗曚环")
+    private Double price;
+
+    /**
+     * sku
+     */
+    @ApiModelProperty(value= "sku")
+    private String sku;
+
+    /**
+     * 鍗曚綅閲�
+     */
+    @ApiModelProperty(value= "鍗曚綅閲�")
+    private Double units;
+
+    /**
+     * 鏉$爜
+     */
+    @ApiModelProperty(value= "鏉$爜")
+    private String barcode;
+
+    /**
+     * 浜у湴
+     */
+    @ApiModelProperty(value= "浜у湴")
+    private String origin;
+
+    /**
+     * 鍘傚
+     */
+    @ApiModelProperty(value= "鍘傚")
+    private String manu;
+
+    /**
+     * 鐢熶骇鏃ユ湡
+     */
+    @ApiModelProperty(value= "鐢熶骇鏃ユ湡")
+    @TableField("manu_date")
+    private String manuDate;
+
+    /**
+     * 鍝侀」鏁�
+     */
+    @ApiModelProperty(value= "鍝侀」鏁�")
+    @TableField("item_num")
+    private String itemNum;
+
+    /**
+     * 瀹夊叏搴撳瓨閲�
+     */
+    @ApiModelProperty(value= "瀹夊叏搴撳瓨閲�")
+    @TableField("safe_qty")
+    private Double safeQty;
+
+    /**
+     * 閲嶉噺
+     */
+    @ApiModelProperty(value= "閲嶉噺")
+    private Double weight;
+
+    /**
+     * 闀垮害
+     */
+    @ApiModelProperty(value= "闀垮害")
+    private Double length;
+
+    /**
+     * 浣撶Н
+     */
+    @ApiModelProperty(value= "浣撶Н")
+    private Double volume;
+
+    /**
+     * 涓夋柟缂栫爜
+     */
+    @ApiModelProperty(value= "涓夋柟缂栫爜")
+    @TableField("three_code")
+    private String threeCode;
+
+    /**
+     * 渚涘簲鍟�
+     */
+    @ApiModelProperty(value= "渚涘簲鍟�")
+    private String supp;
+
+    /**
+     * 渚涘簲鍟嗙紪鐮�
+     */
+    @ApiModelProperty(value= "渚涘簲鍟嗙紪鐮�")
+    @TableField("supp_code")
+    private String suppCode;
+
+    /**
+     * 鏄惁鎵规 1: 鏄�  0: 鍚�
+     */
+    @ApiModelProperty(value= "鏄惁鎵规 1: 鏄�  0: 鍚�  ")
+    @TableField("be_batch")
+    private Integer beBatch;
+
+    /**
+     * 淇濊川鏈�
+     */
+    @ApiModelProperty(value= "淇濊川鏈�")
+    @TableField("dead_time")
+    private String deadTime;
+
+    /**
+     * 棰勮澶╂暟
+     */
+    @ApiModelProperty(value= "棰勮澶╂暟")
+    @TableField("dead_warn")
+    private Integer deadWarn;
+
+    /**
+     * 鍒惰喘 1: 鍒堕��  2: 閲囪喘  3: 澶栧崗
+     */
+    @ApiModelProperty(value= "鍒惰喘 1: 鍒堕��  2: 閲囪喘  3: 澶栧崗  ")
+    private Integer source;
+
+    /**
+     * 瑕佹眰妫�楠� 1: 鏄�  0: 鍚�
+     */
+    @ApiModelProperty(value= "瑕佹眰妫�楠� 1: 鏄�  0: 鍚�  ")
+    private Integer inspect;
+
+    /**
+     * 鍗遍櫓鍝� 1: 鏄�  0: 鍚�
+     */
+    @ApiModelProperty(value= "鍗遍櫓鍝� 1: 鏄�  0: 鍚�  ")
+    private Integer danger;
 
     /**
      * 淇敼浜哄憳
@@ -138,21 +262,67 @@
     @TableField("appe_time")
     private Date appeTime;
 
-    @ApiModelProperty(value= "搴撲綅鍙�")
-    @TableField(exist = false)
-    private String locNo;
-
-    @TableField("Item_batch")
-    private String itemBatch;
-
-    @TableField("order_no")
-    private String orderNo;
+    /**
+     * 澶囨敞
+     */
+    @ApiModelProperty(value= "澶囨敞")
+    private String memo;
 
     public String getIoTime$(){
         if (Cools.isEmpty(this.ioTime)){
             return "";
         }
         return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.ioTime);
+    }
+
+    public String getBeBatch$(){
+        if (null == this.beBatch){ return null; }
+        switch (this.beBatch){
+            case 1:
+                return "鏄�";
+            case 0:
+                return "鍚�";
+            default:
+                return String.valueOf(this.beBatch);
+        }
+    }
+
+    public String getSource$(){
+        if (null == this.source){ return null; }
+        switch (this.source){
+            case 1:
+                return "鍒堕��";
+            case 2:
+                return "閲囪喘";
+            case 3:
+                return "澶栧崗";
+            default:
+                return String.valueOf(this.source);
+        }
+    }
+
+    public String getInspect$(){
+        if (null == this.inspect){ return null; }
+        switch (this.inspect){
+            case 1:
+                return "鏄�";
+            case 0:
+                return "鍚�";
+            default:
+                return String.valueOf(this.inspect);
+        }
+    }
+
+    public String getDanger$(){
+        if (null == this.danger){ return null; }
+        switch (this.danger){
+            case 1:
+                return "鏄�";
+            case 0:
+                return "鍚�";
+            default:
+                return String.valueOf(this.danger);
+        }
     }
 
     public String getModiUser$(){
@@ -187,4 +357,5 @@
         return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.appeTime);
     }
 
+
 }
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 6ce64f9..6d9409d 100644
--- a/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java
@@ -130,7 +130,7 @@
                 // 鍒ゆ柇鏄惁婊¤冻鍏ュ簱鏉′欢
                 if (staProtocol.isAutoing() && staProtocol.isLoading()
                         && staProtocol.isInEnable()
-                        && !staProtocol.isEmptyMk() && (staProtocol.getWorkNo() == 0 || staProtocol.getWorkNo() == 9999)
+                        && !staProtocol.isEmptyMk() && (staProtocol.getWorkNo() == 0 || staProtocol.getWorkNo() > 9990)
                         && staProtocol.isPakMk()){// && !Cools.isEmpty(barcode)) {
 
 //                    if(Cools.isEmpty(barcode) || "NG".endsWith(barcode) || "NoRead".equals(barcode)) {
@@ -1408,7 +1408,7 @@
                 ledCommand.setStaNo(wrkMast.getStaNo());
                 if (wrkMast.getIoType() != 110) {
                     List<WrkDetl> wrkDetls = wrkDetlService.findByWorkNo(wrkMast.getWrkNo());
-                    wrkDetls.forEach(wrkDetl -> ledCommand.getMatDtos().add(new MatDto(wrkDetl.getMatNo(), wrkDetl.getMatName(), wrkDetl.getQty())));
+                    wrkDetls.forEach(wrkDetl -> ledCommand.getMatDtos().add(new MatDto(wrkDetl.getMatnr(), wrkDetl.getMaktx(), wrkDetl.getAnfme())));
                 }
                 commands.add(ledCommand);
             }
@@ -1499,7 +1499,7 @@
                 }
             }
             // 鑾峰彇led绾跨▼
-            LedThread ledThread = (LedThread) SlaveConnection.get(SlaveType.Led, led.getDevpPlcId());
+            LedThread ledThread = (LedThread) SlaveConnection.get(SlaveType.Led, led.getId());
             // led鏄剧ず榛樿鍐呭
             if (reset && !ledThread.isLedMk()) {
                 ledThread.setLedMk(true);
@@ -1553,7 +1553,7 @@
                 WrkDetl wrkDetl = new WrkDetl();
                 wrkDetl.setWrkNo(workNo);
                 wrkDetl.setIoTime(now);
-                wrkDetl.setQty(locDetl.getQty());
+                wrkDetl.setAnfme(locDetl.getAnfme());
                 VersionUtils.setWrkDetl(wrkDetl, locDetl); // 鐗堟湰鎺у埗
                 wrkDetl.setAppeTime(now);
                 wrkDetl.setModiTime(now);
@@ -1670,7 +1670,7 @@
                     WrkDetl wrkDetl = new WrkDetl();
                     wrkDetl.setWrkNo(workNo);
                     wrkDetl.setIoTime(new Date());
-                    wrkDetl.setQty(locDetl.getQty());
+                    wrkDetl.setAnfme(locDetl.getAnfme());
                     VersionUtils.setWrkDetl(wrkDetl, locDetl); // 鐗堟湰鎺у埗
                     wrkDetl.setAppeTime(new Date());
                     wrkDetl.setModiTime(new Date());
diff --git a/src/main/java/com/zy/asrs/utils/VersionUtils.java b/src/main/java/com/zy/asrs/utils/VersionUtils.java
index bb6afba..0e8be1f 100644
--- a/src/main/java/com/zy/asrs/utils/VersionUtils.java
+++ b/src/main/java/com/zy/asrs/utils/VersionUtils.java
@@ -28,11 +28,11 @@
     }
 
     public static void setWrkDetl(WrkDetl wrkDetl, LocDetl locDetl) {
-        wrkDetl.setMatNo(locDetl.getMatNo()); // 浜у搧缂栧彿
-        wrkDetl.setMatName(locDetl.getMatName()); // 浜у搧鎻忚堪
+        wrkDetl.setMatnr(locDetl.getMatnr()); // 浜у搧缂栧彿
+        wrkDetl.setMaktx(locDetl.getMaktx()); // 浜у搧鎻忚堪
         wrkDetl.setSpecs(locDetl.getSpecs()); // 瑙勬牸
         wrkDetl.setUnit(locDetl.getUnit()); // 鍗曚綅
-        wrkDetl.setSize(locDetl.getSize()); // 灏哄
+//        wrkDetl.setSize(locDetl.getSize()); // 灏哄
         wrkDetl.setColor(locDetl.getColor()); // 棰滆壊
         wrkDetl.setWeight(locDetl.getWeight()); // 鍗曢噸
         wrkDetl.setZpallet(locDetl.getZpallet()); // 鎵樼洏鏉$爜
@@ -52,13 +52,13 @@
     }
 
     public static void setLocDetl(LocDetl locDetl, WrkDetl wrkDetl) {
-        locDetl.setMatNo(wrkDetl.getMatNo()); // 浜у搧缂栧彿
-        locDetl.setMatName(wrkDetl.getMatName()); // 浜у搧鎻忚堪
+        locDetl.setMatnr(wrkDetl.getMatnr()); // 浜у搧缂栧彿
+        locDetl.setMaktx(wrkDetl.getMaktx()); // 浜у搧鎻忚堪
         locDetl.setSpecs(wrkDetl.getSpecs()); // 瑙勬牸
         locDetl.setUnit(wrkDetl.getUnit()); // 鍗曚綅
-        locDetl.setSize(wrkDetl.getSize()); // 灏哄
+//        locDetl.setSize(wrkDetl.getSize()); // 灏哄
         locDetl.setColor(wrkDetl.getColor()); // 棰滆壊
-        locDetl.setQty(wrkDetl.getQty()); // 鏁伴噺
+        locDetl.setAnfme(wrkDetl.getAnfme()); // 鏁伴噺
         locDetl.setZpallet(wrkDetl.getZpallet()); // 鎵樼洏鏉$爜
     }
 
diff --git a/src/main/java/com/zy/core/thread/LedThread.java b/src/main/java/com/zy/core/thread/LedThread.java
index 3305f41..cdc583a 100644
--- a/src/main/java/com/zy/core/thread/LedThread.java
+++ b/src/main/java/com/zy/core/thread/LedThread.java
@@ -40,7 +40,7 @@
     TextCaptionBxArea area;
     DisplayStyleFactory.DisplayStyle[] styles = DisplayStyleFactory.getStyles().toArray(new DisplayStyleFactory.DisplayStyle[0]);
     private Set<Integer> workNos = new HashSet<>();
-    private boolean ledMk = true;
+    private boolean ledMk = false;
     private boolean resetStatus = false;    // 澶嶄綅鐘舵��
 
     public LedThread(Slave slave) {
@@ -114,7 +114,7 @@
         }
 
         // 璁剧疆瀛椾綋
-        page.setFont(new Font("瀹嬩綋",Font.PLAIN,10));
+        page.setFont(new Font("瀹嬩綋",Font.PLAIN,12));
         // 璁剧疆鏂囨湰棰滆壊
         page.setForeground(Color.red);
         // 璁剧疆鏄剧ず鐗规妧涓哄揩閫熸墦鍑�
@@ -133,9 +133,9 @@
     }
 
     private void reset() throws Bx5GException {
-//        if (!connect()) {
-//            return;
-//        }
+        if (!connect()) {
+            return;
+        }
 //        if (resetStatus) {
 //            return;
 //        }
@@ -146,20 +146,21 @@
         // 鍒涘缓涓�涓暟鎹〉
         TextBxPage page = new TextBxPage();
 
-        List<String> list = null;
-        try {
-            String ledDefaultMsg = Parameter.get().getLedDefaultMsg();
-            list = JSON.parseArray(ledDefaultMsg, String.class);
-        } catch (Exception ignore) {
-        }
-        if (!Cools.isEmpty(list)) {
-            for (String str : list) {
-                page.newLine(str);
-            }
-        } else {
-            page.newLine("鑷姩鍖栫珛浣撲粨搴�");
-            page.newLine("瑗挎牸杩堣偂浠芥湁闄愬叕鍙�");
-        }
+//        List<String> list = null;
+//        try {
+//            String ledDefaultMsg = Parameter.get().getLedDefaultMsg();
+//            list = JSON.parseArray(ledDefaultMsg, String.class);
+//        } catch (Exception ignore) {
+//        }
+//        if (!Cools.isEmpty(list)) {
+//            for (String str : list) {
+//                page.newLine(str);
+//            }
+//        } else {
+//            page.newLine("鑷姩鍖栫珛浣撲粨搴�");
+//            page.newLine("瑗挎牸杩堣偂浠芥湁闄愬叕鍙�");
+//        }
+        page.newLine("");
 
         // 璁剧疆瀛椾綋
         page.setFont(new Font("瀹嬩綋",Font.PLAIN,13));
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index a440e63..45ee0c8 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -185,39 +185,39 @@
     ip: 10.10.10.201
     port: 5005
     devpPlcId: ${wcs-slave.devp[0].id}
-    staArr: 110
+    staArr: 102
   # LED2
   led[1]:
     id: 2
     ip: 10.10.10.202
     port: 5005
     devpPlcId: ${wcs-slave.devp[0].id}
-    staArr: 117
+    staArr: 103
   # LED3
   led[2]:
     id: 3
     ip: 10.10.10.203
     port: 5005
     devpPlcId: ${wcs-slave.devp[0].id}
-    staArr: 124
+    staArr: 202
   # LED4
   led[3]:
     id: 4
     ip: 10.10.10.204
     port: 5005
     devpPlcId: ${wcs-slave.devp[0].id}
-    staArr: 131
+    staArr: 203
   # LED5
   led[4]:
     id: 5
     ip: 10.10.10.205
     port: 5005
     devpPlcId: ${wcs-slave.devp[0].id}
-    staArr: 136
+    staArr: 303
   # LED6
   led[5]:
     id: 5
     ip: 10.10.10.206
     port: 5005
     devpPlcId: ${wcs-slave.devp[0].id}
-    staArr: 136
\ No newline at end of file
+    staArr: 305
\ No newline at end of file
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index d66d35c..4fb3cbf 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -5,24 +5,45 @@
     <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
     <resultMap id="BaseResultMap" type="com.zy.asrs.entity.LocDetl">
         <result column="loc_no" property="locNo" />
-        <result column="mat_no" property="matNo" />
-        <result column="mat_name" property="matName" />
-        <result column="specs" property="specs" />
-        <result column="size" property="size" />
-        <result column="color" property="color" />
-        <result column="weight" property="weight" />
-        <result column="supplier" property="supplier" />
-        <result column="warehouse" property="warehouse" />
-        <result column="brand" property="brand" />
-        <result column="qty" property="qty" />
-        <result column="unit" property="unit" />
         <result column="zpallet" property="zpallet" />
-        <result column="bname" property="bname" />
-        <result column="memo" property="memo" />
+        <result column="anfme" property="anfme" />
+        <result column="matnr" property="matnr" />
+        <result column="maktx" property="maktx" />
+        <result column="batch" property="batch" />
+        <result column="order_no" property="orderNo" />
+
+        <result column="specs" property="specs" />
+        <result column="model" property="model" />
+        <result column="color" property="color" />
+        <result column="brand" property="brand" />
+        <result column="unit" property="unit" />
+        <result column="price" property="price" />
+        <result column="sku" property="sku" />
+        <result column="units" property="units" />
+        <result column="barcode" property="barcode" />
+        <result column="origin" property="origin" />
+        <result column="manu" property="manu" />
+        <result column="manu_date" property="manuDate" />
+        <result column="item_num" property="itemNum" />
+        <result column="safe_qty" property="safeQty" />
+        <result column="weight" property="weight" />
+        <result column="length" property="length" />
+        <result column="volume" property="volume" />
+        <result column="three_code" property="threeCode" />
+        <result column="supp" property="supp" />
+        <result column="supp_code" property="suppCode" />
+        <result column="be_batch" property="beBatch" />
+        <result column="dead_time" property="deadTime" />
+        <result column="dead_warn" property="deadWarn" />
+        <result column="source" property="source" />
+        <result column="inspect" property="inspect" />
+        <result column="danger" property="danger" />
+
         <result column="modi_user" property="modiUser" />
         <result column="modi_time" property="modiTime" />
         <result column="appe_user" property="appeUser" />
         <result column="appe_time" property="appeTime" />
+        <result column="memo" property="memo" />
     </resultMap>
 
     <sql id="stockOutCondition">
@@ -30,10 +51,10 @@
             and a.loc_no like '%' + #{loc_no} + '%'
         </if>
         <if test="matNo!=null and matNo!='' ">
-            and a.mat_no like '%' + #{matNo} + '%'
+            and a.matnr like '%' + #{matNo} + '%'
         </if>
         <if test="matName!=null and matName!='' ">
-            and a.mat_name like '%' + #{matName} + '%'
+            and a.maktx like '%' + #{matName} + '%'
         </if>
         <if test="anfme!=null and anfme!='' ">
             and a.anfme like '%' + #{anfme} + '%'
diff --git a/src/main/resources/mapper/WrkDetlMapper.xml b/src/main/resources/mapper/WrkDetlMapper.xml
index 1d078f3..a28c05b 100644
--- a/src/main/resources/mapper/WrkDetlMapper.xml
+++ b/src/main/resources/mapper/WrkDetlMapper.xml
@@ -6,8 +6,8 @@
     <resultMap id="BaseResultMap" type="com.zy.asrs.entity.WrkDetl">
         <result column="wrk_no" property="wrkNo" />
         <result column="io_time" property="ioTime" />
-        <result column="mat_no" property="matNo" />
-        <result column="mat_name" property="matName" />
+        <result column="matnr" property="matnr" />
+        <result column="maktx" property="maktx" />
         <result column="specs" property="specs" />
         <result column="size" property="size" />
         <result column="color" property="color" />
@@ -15,7 +15,7 @@
         <result column="bill_no" property="billNo" />
         <result column="seq_no" property="seqNo" />
         <result column="brand" property="brand" />
-        <result column="qty" property="qty" />
+        <result column="anfme" property="anfme" />
         <result column="unit" property="unit" />
         <result column="zpallet" property="zpallet" />
         <result column="bname" property="bname" />
@@ -27,7 +27,7 @@
     </resultMap>
 
     <select id="findByWorkNo" resultMap="BaseResultMap">
-        select wrk_no, mat_no, mat_name, qty from asr_wrk_detl where 1=1 and wrk_no = #{workNo}
+        select wrk_no, matnr, maktx, anfme from asr_wrk_detl where 1=1 and wrk_no = #{workNo}
     </select>
 
     <update id="updateIoTime">

--
Gitblit v1.9.1