From 6dd0ff53d732ecf3ff3bf98f360e1b1fb9eaf82a Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期五, 14 六月 2024 16:58:14 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes

---
 hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java                      |   37 ++++++
 hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java                      |    5 
 /dev/null                                                                                                                        |   76 ------------
 hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/job/DownCacheGlassTask.java                              |  163 ++++++++++++++------------
 hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/GlassInfoService.java                               |   13 ++
 hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/DownStorageCageService.java          |    6 +
 hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/impl/DownStorageCageServiceImpl.java |   22 +++
 7 files changed, 167 insertions(+), 155 deletions(-)

diff --git a/hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/GlassInfoService.java b/hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/GlassInfoService.java
index f85f7f8..6d78c74 100644
--- a/hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/GlassInfoService.java
+++ b/hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/GlassInfoService.java
@@ -3,6 +3,7 @@
 import com.mes.glassinfo.entity.GlassInfo;
 import com.github.yulichang.base.MPJBaseService;
 import java.util.List;
+import java.util.Map;
 
 /**
  * <p>
@@ -22,5 +23,17 @@
        * 淇濆瓨灏忕墖琛�
        */
       void saveGlassInfo(List<GlassInfo> glassinfo);
+
+      /**
+       * @param flowCardId
+       * @return 鏍规嵁娴佺▼鍗″彿鏌ヨ鐜荤拑淇℃伅
+       */
+      int getGlassInfoCountByFlowCardId(String flowCardId);
+
+      /**
+       * @return
+       * 鏌ヨ鎵�鏈夊伐绋嬬姸鎬佷笉涓�300涓嶅悓娴佺▼鍗″彿
+       */
+      List<Map<String, Object>> getFlowCardId();
 }
 
diff --git a/hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java b/hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java
index be26553..8ba557f 100644
--- a/hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java
+++ b/hangzhoumesParent/common/servicebase/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java
@@ -1,20 +1,24 @@
 package com.mes.glassinfo.service.impl;
 
 import com.baomidou.dynamic.datasource.annotation.DS;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.github.yulichang.base.MPJBaseServiceImpl;
 import com.github.yulichang.query.MPJQueryWrapper;
+import com.github.yulichang.toolkit.JoinWrappers;
 import com.mes.glassinfo.entity.GlassInfo;
 import com.mes.glassinfo.entity.OptimizeGlassinfo;
 import com.mes.glassinfo.mapper.GlassInfoMapper;
 import com.mes.glassinfo.service.GlassInfoService;
 import com.mes.pp.entity.OptimizeProject;
 import com.mes.pp.mapper.OptimizeProjectMapper;
+import com.mes.uppattenusage.entity.UpPattenUsage;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 
 import java.util.ArrayList;
 import java.util.List;
+import java.util.Map;
 
 /**
  * <p>
@@ -80,4 +84,37 @@
     public void saveGlassInfo(List<GlassInfo> glassinfo) {
         this.saveBatch(glassinfo);
     }
+
+
+
+
+
+
+    @Override
+    public int getGlassInfoCountByFlowCardId(String flowCardId) {
+        return baseMapper.selectCount(new QueryWrapper<GlassInfo>().lambda()
+                .eq(GlassInfo::getFlowCardId, flowCardId));
+    }
+
+
+
+    @Override
+    public List<Map<String, Object>> getFlowCardId() {
+        return baseMapper.selectJoinMaps(JoinWrappers.lambda(GlassInfo.class)
+                .select(GlassInfo::getFlowCardId)
+                .leftJoin(UpPattenUsage.class, on -> on
+                        .eq(OptimizeProject::getProjectNo, GlassInfo::getEngineerId)
+                        .ne(OptimizeProject::getState, 300)
+                )
+                .groupBy(GlassInfo::getFlowCardId)
+        );
+    }
+
+
+
+
+
+
+
+
 }
diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/controller/GlassInfoController.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/controller/GlassInfoController.java
deleted file mode 100644
index 08fa5a6..0000000
--- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/controller/GlassInfoController.java
+++ /dev/null
@@ -1,54 +0,0 @@
-package com.mes.glassinfo.controller;
-
-import com.mes.glassinfo.entity.GlassInfo;
-import com.mes.glassinfo.service.GlassInfoService;
-import com.mes.utils.Result;
-import io.swagger.annotations.Api;
-import io.swagger.annotations.ApiOperation;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.web.bind.annotation.PostMapping;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.ResponseBody;
-import org.springframework.web.bind.annotation.RestController;
-
-import java.util.List;
-
-/**
- * <p>
- * 鍓嶇鎺у埗鍣�
- * </p>
- *
- * @author zhoush
- * @since 2024-04-07
- */
-@Api(description = "鐜荤拑淇℃伅灏忕墖")
-@RestController
-@RequestMapping("/glassInfo")
-public class GlassInfoController {
-
-    @Autowired
-    private GlassInfoService glassInfoService;
-
-    @ApiOperation("鏍规嵁鐜荤拑灏忕墖ID鏌ヨ 鐜荤拑鏁版嵁锛氬弬鏁�(鐜荤拑ID)")
-    @PostMapping("/selectId")
-    @ResponseBody
-    public Result selectId(String ProcessId) {
-        List<GlassInfo> list = glassInfoService.selectId(ProcessId);
-        return Result.build(200,"鎴愬姛",list);
-    }
-    @ApiOperation("鏌ヨ鎵�鏈夌幓鐠冨皬鐗囦俊鎭� 鐜荤拑鏁版嵁   鍙傛暟()")
-    @PostMapping("/selectAll")
-    @ResponseBody
-    public Result selectAll() {
-        List<GlassInfo> list = glassInfoService.selectAll();
-        return Result.build(200,"鎴愬姛",list);
-    }
-    @ApiOperation("鏌ヨ宸ョ▼涓嬬殑鐜荤拑灏忕墖淇℃伅 鐜荤拑鏁版嵁  鍙傛暟(宸ョ▼鍙�)")
-    @PostMapping("/selectFlowCardId")
-    @ResponseBody
-    public Result selectFlowCardId(String flowCardId) {
-        List<GlassInfo> list = glassInfoService.selectFlowCardId(flowCardId);
-        return Result.build(200,"鎴愬姛",list);
-    }
-}
-
diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/mapper/GlassInfoMapper.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/mapper/GlassInfoMapper.java
deleted file mode 100644
index ade0460..0000000
--- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/mapper/GlassInfoMapper.java
+++ /dev/null
@@ -1,17 +0,0 @@
-package com.mes.glassinfo.mapper;
-
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.github.yulichang.base.MPJBaseMapper;
-import com.mes.glassinfo.entity.GlassInfo;
-
-/**
- * <p>
- * Mapper 鎺ュ彛
- * </p>
- *
- * @author zhoush
- * @since 2024-04-07
- */
-public interface GlassInfoMapper extends MPJBaseMapper<GlassInfo> {
-
-}
diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/service/GlassInfoService.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/service/GlassInfoService.java
deleted file mode 100644
index f5117b0..0000000
--- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/service/GlassInfoService.java
+++ /dev/null
@@ -1,37 +0,0 @@
-package com.mes.glassinfo.service;
-
-import com.baomidou.mybatisplus.extension.service.IService;
-import com.mes.glassinfo.entity.GlassInfo;
-
-import java.util.List;
-
-/**
- * <p>
- *  鏈嶅姟绫�
- * </p>
- *
- * @author zhoush
- * @since 2024-04-07
- */
-public interface GlassInfoService extends IService<GlassInfo> {
-
-    /**
-     * 鏌ヨ鎵�鏈夌幓鐠冨皬鐗囦俊鎭�
-     * @return
-     */
-    public List<GlassInfo> selectAll();
-
-    /**
-     * 鏍规嵁鐜荤拑缂栧彿鏌ヨ鐜荤拑灏忕墖淇℃伅
-     * @param glassId
-     * @return
-     */
-    public List<GlassInfo> selectId(String glassId);
-
-    /**
-     * 鏍规嵁宸ョ▼鍙锋煡璇㈢幓鐠冨皬鐗囦俊鎭�
-     * @param flowCardId
-     * @return
-     */
-    public List<GlassInfo> selectFlowCardId(String flowCardId);
-}
diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java
deleted file mode 100644
index 7e04d74..0000000
--- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java
+++ /dev/null
@@ -1,60 +0,0 @@
-package com.mes.glassinfo.service.impl;
-
-import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.github.yulichang.query.MPJLambdaQueryWrapper;
-import com.github.yulichang.wrapper.MPJLambdaWrapper;
-import com.mes.glassinfo.entity.GlassInfo;
-import com.mes.glassinfo.mapper.GlassInfoMapper;
-import com.mes.glassinfo.service.GlassInfoService;
-import com.mes.taskcache.entity.TaskCache;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
-
-import java.util.List;
-import java.util.Map;
-
-/**
- * <p>
- *  鏈嶅姟瀹炵幇绫�
- * </p>
- *
- * @author zhoush
- * @since 2024-04-07
- */
-@Service
-public class GlassInfoServiceImpl extends ServiceImpl<GlassInfoMapper, GlassInfo> implements GlassInfoService {
-
-
-    /**
-     * 鏍规嵁ID 鑾峰彇灏忕墖鏁版嵁
-     * @param glassId
-     * @return
-     */
-    @Override
-    public List<GlassInfo> selectId(String glassId){
-        return baseMapper.selectList(new MPJLambdaWrapper<GlassInfo>().selectAll(GlassInfo.class).eq(GlassInfo::getGlassId,glassId));
-//        return baseMapper.selectList(new QueryWrapper<GlassInfo>().eq("glass_id",glassId));
-    };
-
-    /**
-     * 鑾峰彇鍏ㄩ儴灏忕墖鏁版嵁
-     * @return
-     */
-    @Override
-    public List<GlassInfo> selectAll(){
-        return baseMapper.selectList(null);
-    };
-
-    /**
-     * 鏍规嵁宸ョ▼ 鑾峰彇灏忕墖鏁版嵁
-     * @param flowCardId
-     * @return
-     */
-    @Override
-    public List<GlassInfo> selectFlowCardId(String flowCardId){
-        return baseMapper.selectList(new MPJLambdaWrapper<GlassInfo>().selectAll(GlassInfo.class).eq(GlassInfo::getFlowCardId,flowCardId));
-        //Sql鐗堟湰
-//        return baseMapper.selectList(new QueryWrapper<GlassInfo>().eq("flow_card_id",flowCardId));
-    };
-}
diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java
index 0f57394..4bf1348 100644
--- a/hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java
+++ b/hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java
@@ -112,11 +112,6 @@
         log.info("Sql鏁版嵁锛歿}", Arrays.asList(list));
     }
 
-    @Test
-    public void testglassinfo() {
-        List<GlassInfo> glassInfos = glassInfoService.selectId("7");
-        log.info("鐜荤拑鏁版嵁鏁版嵁锛歿}", Arrays.asList(glassInfos));
-    }
 
     @Test
     public void testCacheGlass() {
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/DownStorageCageService.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/DownStorageCageService.java
index 32d55a3..f5d4ad5 100644
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/DownStorageCageService.java
+++ b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/DownStorageCageService.java
@@ -50,6 +50,12 @@
      */
     List<Map<String, Object>> selectDownStorageCages();
 
+
+    /**
+     * @return 鏌ヨ缂撳瓨涓渶澶氱殑娴佺▼鍗�
+     */
+    List<DownStorageCageDetails> selectCacheMax();
+
 }
 
 
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/impl/DownStorageCageServiceImpl.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/impl/DownStorageCageServiceImpl.java
index 53d6be3..f85dcee 100644
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/impl/DownStorageCageServiceImpl.java
+++ b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downstorage/service/impl/DownStorageCageServiceImpl.java
@@ -6,6 +6,7 @@
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
 
 //import com.mes.device.PlcParameterObject;
+import com.google.common.base.Functions;
 import com.mes.downglassinfo.entity.DownGlassTask;
 import com.mes.downglassinfo.service.DownGlassTaskService;
 import com.mes.downstorage.entity.DownStorageCage;
@@ -19,6 +20,7 @@
 import com.mes.glassinfo.service.GlassInfoService;
 import com.mes.pp.entity.OptimizeDetail;
 import lombok.extern.slf4j.Slf4j;
+import net.sf.jsqlparser.statement.select.SelectItem;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
@@ -90,6 +92,26 @@
         );
     }
 
+    @Override
+    public List<DownStorageCageDetails> selectCacheMax() {
+        return baseMapper.selectJoinList(DownStorageCageDetails.class,
+                JoinWrappers.lambda(DownStorageCage.class)
+                        // 娣诲姞 DownStorageCage 鐨� enableState 涓� 1 鐨勬潯浠�
+                        .select(DownStorageCageDetails::getFlowCardId)
+                        .leftJoin(DownStorageCageDetails.class, on -> on
+                                .eq(DownStorageCageDetails::getDeviceId, DownStorageCage::getDeviceId)
+                                .eq(DownStorageCageDetails::getSlot, DownStorageCage::getSlot))
+                        .isNull(DownStorageCageDetails::getSlot)
+                        .eq(DownStorageCage::getEnableState, 1)
+                        .groupBy(DownStorageCageDetails::getFlowCardId) // 鏍规嵁 flowCardId 鍒嗙粍
+                        // 浣跨敤瀛愭煡璇㈠拰鎺掑簭鏉ヨ幏鍙栫浉鍚� FlowCardId 涓殑鏈�澶氳褰�
+                        .having("count(*) = (select max(cnt) from (select count(*) as cnt from down_storage_cage_details group by flow_card_id) as temp)")
+
+        );
+    }
+
+
+
 
 
 
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/controller/EngineeringController.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/controller/EngineeringController.java
deleted file mode 100644
index 66f6dee..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/controller/EngineeringController.java
+++ /dev/null
@@ -1,29 +0,0 @@
-package com.mes.engineering.controller;
-
-
-import com.mes.engineering.entity.Engineering;
-import com.mes.engineering.service.EngineeringService;
-
-import com.mes.utils.Result;
-import io.swagger.annotations.ApiOperation;
-import lombok.extern.slf4j.Slf4j;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.web.bind.annotation.*;
-
-import java.util.List;
-
-/**
- * <p>
- *  鍓嶇鎺у埗鍣�
- * </p>
- *
- * @author wu
- * @since 2024-04-22
- */
-@RestController
-@Slf4j
-@RequestMapping("/engineering/engineering")
-public class EngineeringController {
-
-}
-
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/entity/Engineering.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/entity/Engineering.java
deleted file mode 100644
index 586a7b3..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/entity/Engineering.java
+++ /dev/null
@@ -1,100 +0,0 @@
-package com.mes.engineering.entity;
-
-import com.baomidou.mybatisplus.annotation.IdType;
-import com.baomidou.mybatisplus.annotation.TableId;
-import java.io.Serializable;
-import lombok.Data;
-import lombok.EqualsAndHashCode;
-
-/**
- * <p>
- * 
- * </p>
- *
- * @author wu
- * @since 2024-04-22
- */
-@Data
-@EqualsAndHashCode(callSuper = false)
-public class Engineering implements Serializable {
-
-    private static final long serialVersionUID = 1L;
-
-    /**
-     * 宸ョ▼琛╥d
-     */
-      @TableId(value = "id", type = IdType.AUTO)
-    private Long id;
-
-    /**
-     * 宸ョ▼鍙�
-     */
-    private String  engineerId;
-
-    /**
-     * 宸ョ▼鍚嶇О
-     */
-    private String engineerName;
-
-    /**
-     * 骞冲潎鍒╃敤鐜�
-     */
-    private Double avgAvailability;
-
-    /**
-     * 鏈夋晥鍒╃敤鐜�
-     */
-    private Double validAvailability;
-
-    /**
-     * 灏剧墖鍒╃敤鐜�
-     */
-    private Double lastAvailability;
-
-    /**
-     * 鐘舵��
-     */
-    private Integer state;
-
-    /**
-     * 灏忕墖鎬绘暟
-     */
-    private Integer glassTotal;
-
-    /**
-     * 灏忕墖鎬婚潰绉�
-     */
-    private Double glassTotalArea;
-
-    /**
-     * 璁″垝鍘熺墖鎬绘暟
-     */
-    private Integer planPatternTotal;
-
-    /**
-     * 璁″垝鍘熺墖鎬婚潰绉�
-     */
-    private Double planPatternTotalArea;
-
-    /**
-     * 瀹為檯鍘熺墖鎬绘暟
-     */
-    private Integer realityPatternTotal;
-
-    /**
-     * 瀹為檯鍘熺墖鎬婚潰绉�
-     */
-    private Double realityPatternTotalArea;
-
-    /**
-     * 鑶滅郴id
-     */
-    private String filmsId;
-
-    /**
-     * 澶囨敞
-     */
-    private String notes;
-
-
-}
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/mapper/EngineeringMapper.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/mapper/EngineeringMapper.java
deleted file mode 100644
index d92eae7..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/mapper/EngineeringMapper.java
+++ /dev/null
@@ -1,17 +0,0 @@
-package com.mes.engineering.mapper;
-
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.github.yulichang.base.MPJBaseMapper;
-import com.mes.engineering.entity.Engineering;
-
-/**
- * <p>
- *  Mapper 鎺ュ彛
- * </p>
- *
- * @author wu
- * @since 2024-04-22
- */
-public interface EngineeringMapper extends MPJBaseMapper<Engineering> {
-
-}
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/mapper/xml/EngineeringMapper.xml b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/mapper/xml/EngineeringMapper.xml
deleted file mode 100644
index bff1839..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/mapper/xml/EngineeringMapper.xml
+++ /dev/null
@@ -1,5 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.mes.engineering.mapper.EngineeringMapper">
-
-</mapper>
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/service/EngineeringService.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/service/EngineeringService.java
deleted file mode 100644
index f453b11..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/service/EngineeringService.java
+++ /dev/null
@@ -1,20 +0,0 @@
-package com.mes.engineering.service;
-
-import com.baomidou.mybatisplus.extension.service.IService;
-import com.mes.engineering.entity.Engineering;
-
-import java.util.List;
-
-/**
- * <p>
- *  鏈嶅姟绫�
- * </p>
- *
- * @author wu
- * @since 2024-04-22
- */
-public interface EngineeringService extends IService<Engineering> {
-
-
-
-}
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/service/impl/EngineeringServiceImpl.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/service/impl/EngineeringServiceImpl.java
deleted file mode 100644
index 1feaa37..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/engineering/service/impl/EngineeringServiceImpl.java
+++ /dev/null
@@ -1,33 +0,0 @@
-package com.mes.engineering.service.impl;
-
-import com.baomidou.dynamic.datasource.annotation.DS;
-import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.mes.engineering.entity.Engineering;
-import com.mes.engineering.mapper.EngineeringMapper;
-import com.mes.engineering.service.EngineeringService;
-import com.mes.pp.entity.OptimizeProject;
-import com.mes.pp.mapper.OptimizeProjectMapper;
-import lombok.extern.slf4j.Slf4j;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
-
-import java.util.ArrayList;
-import java.util.List;
-
-/**
- * <p>
- *  鏈嶅姟瀹炵幇绫�
- * </p>
- *
- * @author wu
- * @since 2024-04-22
- */
-@Service
-@Slf4j
-public class EngineeringServiceImpl extends ServiceImpl<EngineeringMapper, Engineering> implements EngineeringService {
-
-
-
-}
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/controller/GlassInfoController.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/controller/GlassInfoController.java
deleted file mode 100644
index b58b5b0..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/controller/GlassInfoController.java
+++ /dev/null
@@ -1,20 +0,0 @@
-package com.mes.glassinfo.controller;
-
-
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RestController;
-
-/**
- * <p>
- * 鍓嶇鎺у埗鍣�
- * </p>
- *
- * @author zhoush
- * @since 2024-03-27
- */
-@RestController
-@RequestMapping("/glassInfo")
-public class GlassInfoController {
-
-}
-
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/mapper/GlassInfoMapper.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/mapper/GlassInfoMapper.java
deleted file mode 100644
index 7bfe24e..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/mapper/GlassInfoMapper.java
+++ /dev/null
@@ -1,21 +0,0 @@
-package com.mes.glassinfo.mapper;
-
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.github.yulichang.base.MPJBaseMapper;
-import com.mes.glassinfo.entity.GlassInfo;
-import org.mapstruct.Mapper;
-
-/**
- * <p>
- * Mapper 鎺ュ彛
- * </p>
- *
- * @author zhoush
- * @since 2024-03-27
- */
-@Mapper
-public interface GlassInfoMapper extends MPJBaseMapper<GlassInfo> {
-
-
-
-}
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/service/GlassInfoService.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/service/GlassInfoService.java
deleted file mode 100644
index 2f827dc..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/service/GlassInfoService.java
+++ /dev/null
@@ -1,37 +0,0 @@
-package com.mes.glassinfo.service;
-
-import com.baomidou.mybatisplus.extension.service.IService;
-import com.mes.glassinfo.entity.GlassInfo;
-
-import java.util.List;
-import java.util.Map;
-
-/**
- * <p>
- * 鏈嶅姟绫�
- * </p>
- *
- * @author zhoush
- * @since 2024-03-27
- */
-public interface GlassInfoService extends IService<GlassInfo> {
-
-    /**
-     * @param flowCardId
-     * @return 鏍规嵁娴佺▼鍗″彿鏌ヨ鐜荤拑淇℃伅
-     */
-    int getGlassInfoCountByFlowCardId(String flowCardId);
-
-    /**
-     * @return
-     * 鏌ヨ鎵�鏈変笉鍚屾祦绋嬪崱鍙�
-     */
-    List<Map<String, Object>> getFlowCardId();
-
-    /**
-     * @param id
-     * @return 鏍规嵁鐜荤拑id鏌ヨ鐜荤拑淇℃伅
-     */
-    GlassInfo selectGlassId(String id);
-//    List<GlassInfo> getmaxglass(GlassInfo glassInfo);
-}
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java
deleted file mode 100644
index cd2bc4d..0000000
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/glassinfo/service/impl/GlassInfoServiceImpl.java
+++ /dev/null
@@ -1,76 +0,0 @@
-package com.mes.glassinfo.service.impl;
-
-import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
-import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.github.yulichang.toolkit.JoinWrappers;
-import com.mes.downstorage.entity.DownStorageCage;
-import com.mes.downstorage.entity.DownStorageCageDetails;
-import com.mes.engineering.entity.Engineering;
-import com.mes.engineering.mapper.EngineeringMapper;
-import com.mes.glassinfo.entity.GlassInfo;
-import com.mes.glassinfo.mapper.GlassInfoMapper;
-import com.mes.glassinfo.service.GlassInfoService;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
-
-import java.util.List;
-import java.util.Map;
-
-/**
- * <p>
- * 鏈嶅姟瀹炵幇绫�
- * </p>
- *
- * @author zhoush
- * @since 2024-03-27
- */
-@Service
-public class GlassInfoServiceImpl extends ServiceImpl<GlassInfoMapper, GlassInfo> implements GlassInfoService {
-
-    private EngineeringMapper engineeringMapper;
-    private GlassInfoMapper glassInfoMapper;
-
-    @Autowired(required=false)
-    public GlassInfoServiceImpl(GlassInfoMapper glassInfoMapper, EngineeringMapper engineeringMapper) {
-        this.glassInfoMapper = glassInfoMapper;
-        this.engineeringMapper = engineeringMapper;
-    }
-
-    @Override
-    public int getGlassInfoCountByFlowCardId(String flowCardId) {
-        return baseMapper.selectCount(new QueryWrapper<GlassInfo>().lambda()
-                .eq(GlassInfo::getFlowCardId, flowCardId));
-    }
-
-
-
-    @Override
-    public List<Map<String, Object>> getFlowCardId() {
-        return baseMapper.selectJoinMaps(JoinWrappers.lambda(GlassInfo.class)
-                .select(GlassInfo::getFlowCardId)
-                .leftJoin(Engineering.class, on -> on
-                        .eq(Engineering::getEngineerId, GlassInfo::getEngineerId)
-                        .eq(Engineering::getState, 0)
-                )
-                .groupBy(GlassInfo::getFlowCardId)
-        );
-    }
-
-
-
-
-
-
-
-
-    @Override
-    public GlassInfo selectGlassId(String id) {
-        return baseMapper.selectOne(new QueryWrapper<GlassInfo>().lambda()
-                .eq(GlassInfo::getGlassId, id));
-    }
-
-
-
-
-}
diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/job/DownCacheGlassTask.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/job/DownCacheGlassTask.java
index e858451..96d5887 100644
--- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/job/DownCacheGlassTask.java
+++ b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/job/DownCacheGlassTask.java
@@ -16,6 +16,7 @@
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.scheduling.annotation.Scheduled;
 import org.springframework.stereotype.Component;
 
 import java.util.List;
@@ -41,38 +42,58 @@
     @Autowired
     DownWorkstationService downWorkstationService;
     @Autowired
-     DownGlassInfoService downGlassInfoService;
-
-
+    DownGlassInfoService downGlassInfoService;
 
 
     @Autowired
     private DownWorkstationTaskService downWorkstationTaskService;
 
-//    @Value("${mes.threshold}")
+    //    @Value("${mes.threshold}")
     private int threshold;
 
-  // @Scheduled(fixedDelay = 1000)
+    @Scheduled(fixedDelay = 1000)
+    public void autoBindRack() {
+        log.info("鏍规嵁缂撳瓨涓凡缁忚繘鐗囩殑鐜荤拑绉嶆暟閲忔渶澶氱殑娴佺▼鍗″彿鑷姩缁戝畾涓�涓惎鐢ㄧ姸鎬佺殑绌烘灦瀛�");
+
+        List<DownStorageCageDetails> Details = downStorageCageService.selectCacheMax();
+        if (Details.size() > 0) {
+            DownStorageCageDetails downStorageCageDetails = Details.get(0);
+            String flowCardId = downStorageCageDetails.getFlowCardId();
+            int glassInfoCount = glassInfoService.getGlassInfoCountByFlowCardId(flowCardId);
+            DownWorkstation downWorkstation = downWorkstationService.getOne(new LambdaQueryWrapper<DownWorkstation>().eq(DownWorkstation::getFlowCardId, null));
+            List<DownWorkstation> downWorkstations = downWorkstationService.list(new LambdaQueryWrapper<DownWorkstation>()
+                    .eq(DownWorkstation::getEnableState, 1));
+
+            if (!downWorkstations.stream().anyMatch(workstation -> workstation.getFlowCardId().equals(flowCardId))) {
+                downWorkstationService.updateFlowCardIdAndCount(flowCardId, glassInfoCount, downWorkstation.getWorkstationId());
+            }
+
+
+        }
+    }
+
+
+    // @Scheduled(fixedDelay = 1000)
     public void plcdownGlassTask() {
-   //   PlcParameterObject plcParameterObject = S7object.getinstance().PlcMesObject;
+        //   PlcParameterObject plcParameterObject = S7object.getinstance().PlcMesObject;
 //        String taskRequestTypeValue = plcParameterObject.getPlcParameter("A06_request_word").getValue();
 //        String glassIdeValue = plcParameterObject.getPlcParameter("A05_scanning_ID").getValue();
 //        String confirmationWrodValue = plcParameterObject.getPlcParameter("MES_confirmation_word").getValue();
 //        String outGlassstate = plcParameterObject.getPlcParameter("A09_glass_status").getValue();
 //        String confirmationWrodAddress = plcParameterObject.getPlcParameter("MES_confirmation_word").getAddress();
-      // String G06RobotTaskRequestWord = plcParameterObject.getPlcParameter("G06RobotTaskRequestWord").getAddress();
+        // String G06RobotTaskRequestWord = plcParameterObject.getPlcParameter("G06RobotTaskRequestWord").getAddress();
 
 
-                String taskRequestTypeValue ="0";
-        String glassIdeValue ="NG24041101C002-2-6-1-6";
-        String confirmationWrodValue ="1";
-        String outGlassstate="1";
-        String confirmationWrodAddress="1";
-        String G11RobotTaskRequestWord ="0";
-        String G06RobotTaskRequestWord ="0";
-        String G13RobotTaskRequestWord ="0";
+        String taskRequestTypeValue = "0";
+        String glassIdeValue = "NG24041101C002-2-6-1-6";
+        String confirmationWrodValue = "1";
+        String outGlassstate = "1";
+        String confirmationWrodAddress = "1";
+        String G11RobotTaskRequestWord = "0";
+        String G06RobotTaskRequestWord = "0";
+        String G13RobotTaskRequestWord = "0";
 
-                log.info("1銆佽幏鍙栧埌鐨勮姹傚瓧涓猴細{}锛岃幏鍙栧埌鐨勬壂鎻廔D涓猴細{}锛岃幏鍙栧埌鐨勭‘璁ゅ瓧涓猴細{}锛岃幏鍙栧埌鐨勫嚭鐗囩姸鎬佷负锛歿}",
+        log.info("1銆佽幏鍙栧埌鐨勮姹傚瓧涓猴細{}锛岃幏鍙栧埌鐨勬壂鎻廔D涓猴細{}锛岃幏鍙栧埌鐨勭‘璁ゅ瓧涓猴細{}锛岃幏鍙栧埌鐨勫嚭鐗囩姸鎬佷负锛歿}",
                 taskRequestTypeValue, glassIdeValue, confirmationWrodValue, outGlassstate);
 
 //        if ("0".equals(taskRequestTypeValue)) {
@@ -96,7 +117,7 @@
         } else if ("2".equals(taskRequestTypeValue)) {
 
             log.info("3銆佸嚭鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�");
-            outTo( confirmationWrodAddress);
+            outTo(confirmationWrodAddress);
 
         } else if ("3".equals(taskRequestTypeValue)) {
             log.info("3銆佽繘鐗囧拰鍑虹墖閮界┖闂诧紝鎵ц鍑虹墖浠诲姟");
@@ -107,7 +128,7 @@
             }
         }
 
-        if (("1".equals(G11RobotTaskRequestWord) || "1".equals(G06RobotTaskRequestWord))  || "1".equals(G13RobotTaskRequestWord)) {
+        if (("1".equals(G11RobotTaskRequestWord) || "1".equals(G06RobotTaskRequestWord)) || "1".equals(G13RobotTaskRequestWord)) {
             log.info("4銆佹湁鏈哄櫒浜轰笅鐗囪姹傦紝鎵ц涓嬬墖浠诲姟");
             insertdownglassinfo();
         }
@@ -115,13 +136,11 @@
         //鑷姩缁戝畾鏋跺瓙锛屽鏋滃伐浣嶈〃娌℃湁缁戝畾鏋跺瓙锛岄粯璁ゅ皢绗煎瓙涓暟閲忔渶澶氱殑娴佺▼鍗″彿缁戝畾鏈哄櫒鎵�2鐨勭┖鏋跺瓙
 
 
-
-
-
     }
 
     /**
      * 杩涚墖浠诲姟
+     *
      * @param glassId
      * @param confirmationWrodAddress
      * @param
@@ -135,41 +154,39 @@
         }
         log.info("2銆佽幏鍙栧埌鐨勭幓鐠冧俊鎭负{}", glassInfo);
 
-        if (glassInfo.getGlassId().equals(downStorageCageDetailsService.DirectConnection()) ) {
+        if (glassInfo.getGlassId().equals(downStorageCageDetailsService.DirectConnection())) {
             //鐩撮��
             log.info("3銆佸鏋滃綋鍓嶇幓鐠冨睘浜庣増鍥緄d鍜岀墖搴忕殑椤哄簭鍒欑洿閫氾紝鎵ц涓嬬墖浠诲姟");
             DownWorkstation downWorkstation = downWorkstationService.getOne(new LambdaQueryWrapper<DownWorkstation>().eq(DownWorkstation::getFlowCardId, glassInfo.getFlowCardId()));
-            int WorkstationId=downWorkstation.getWorkstationId();
+            int WorkstationId = downWorkstation.getWorkstationId();
             DownGlassTask downGlassTask = downStorageCageService.createDownGlassTask(glassInfo, "0", String.valueOf(WorkstationId), "3");
             downGlassTaskService.insertCacheTask(downGlassTask);
 
-        }else{
+        } else {
 
             log.info("4銆佸鏋滀笉灞炰簬鐗堝浘id鍜岀墖搴忕殑椤哄簭鎵ц杩涚墖浠诲姟");
-        //娣诲姞杩涚墖浠诲姟  鏌ユ壘绌烘牸
-        List<DownStorageCageDetails> list = downStorageCageService.selectCacheEmpty();
-        if(list.size()>0){
-            DownStorageCageDetails item = list.get(0);
+            //娣诲姞杩涚墖浠诲姟  鏌ユ壘绌烘牸
+            List<DownStorageCageDetails> list = downStorageCageService.selectCacheEmpty();
+            if (list.size() > 0) {
+                DownStorageCageDetails item = list.get(0);
 
 
+                log.info("5銆佹煡璇㈠崸寮忕悊鐗囩閲岄潰鐨勭┖鏍�:{}", list);
+                log.info("6銆佸皢鐜荤拑淇℃伅鎻掑叆鍗у紡鐞嗙墖绗�,褰撳墠鐜荤拑淇℃伅:{}", glassInfo);
+                DownStorageCageDetails details = new DownStorageCageDetails();
+                BeanUtils.copyProperties(glassInfo, details);
+                details.setState(1);
+                details.setGlassId(glassInfo.getGlassId());
+                details.setSlot(item.getSlot());
+                details.setDeviceId(item.getDeviceId());
+                downStorageCageDetailsService.save(details);
+                log.info("7銆佺幓鐠冧俊鎭凡瀛樺叆鐞嗙墖绗艰鎯呰〃锛岀幓鐠冧俊鎭负{}", details);
 
-        log.info("5銆佹煡璇㈠崸寮忕悊鐗囩閲岄潰鐨勭┖鏍�:{}", list);
-        log.info("6銆佸皢鐜荤拑淇℃伅鎻掑叆鍗у紡鐞嗙墖绗�,褰撳墠鐜荤拑淇℃伅:{}", glassInfo);
-        DownStorageCageDetails details = new DownStorageCageDetails();
-        BeanUtils.copyProperties(glassInfo, details);
-        details.setState(1);
-        details.setGlassId(glassInfo.getGlassId());
-        details.setSlot(item.getSlot());
-        details.setDeviceId(item.getDeviceId());
-        downStorageCageDetailsService.save(details);
-        log.info("7銆佺幓鐠冧俊鎭凡瀛樺叆鐞嗙墖绗艰鎯呰〃锛岀幓鐠冧俊鎭负{}", details);
-
-            DownGlassTask downGlassTask = downStorageCageService.createDownGlassTask(glassInfo, "0", item.getSlot() + "", "1");
-        //娣诲姞杩涚墖浠诲姟
-        log.info("8銆佺敓鎴愯繘鐗囦换鍔′俊鎭瓨鍏ヤ换鍔¤〃{}", downGlassTask);
-            downGlassTaskService.insertCacheTask(downGlassTask);
-        }
-
+                DownGlassTask downGlassTask = downStorageCageService.createDownGlassTask(glassInfo, "0", item.getSlot() + "", "1");
+                //娣诲姞杩涚墖浠诲姟
+                log.info("8銆佺敓鎴愯繘鐗囦换鍔′俊鎭瓨鍏ヤ换鍔¤〃{}", downGlassTask);
+                downGlassTaskService.insertCacheTask(downGlassTask);
+            }
 
 
         }
@@ -181,15 +198,14 @@
      * 鍑虹墖浠诲姟
      *
      * @param confirmationWrodAddress
-     *
      */
-    private Boolean outTo( String confirmationWrodAddress) {
+    private Boolean outTo(String confirmationWrodAddress) {
         log.info("鍗曠墖鎯呭喌鏍规嵁浼犲叆鐨勬枡鏋跺彿 鏌ヨ绗﹀悎鎸夌収鐗堝浘id鍜岀墖搴忓嚭鐗�,骞朵笖浼樺厛鍑烘弧鏋剁殑灏忕墖");
-        List<DownStorageCageDetails> list = downStorageCageDetailsService.CacheOut1(1,3);
+        List<DownStorageCageDetails> list = downStorageCageDetailsService.CacheOut1(1, 3);
 
-        List<DownStorageCageDetails> list2 = downStorageCageDetailsService.CacheOut1(4,6);
+        List<DownStorageCageDetails> list2 = downStorageCageDetailsService.CacheOut1(4, 6);
 
-        List<DownStorageCageDetails> list3 = downStorageCageDetailsService.CacheOut1(1,6);
+        List<DownStorageCageDetails> list3 = downStorageCageDetailsService.CacheOut1(1, 6);
         // 浼樺厛 瓒呭嚭灏哄浼樺厛浜哄伐鍑虹墖 浜哄伐澶勭悊
         if (!list3.isEmpty()) {
 
@@ -201,11 +217,10 @@
 
                 DownGlassTask downGlassTask = downStorageCageService.createDownGlassTask(item3, "9", endcell, "2");
                 downGlassTaskService.insertCacheTask(downGlassTask);
-              // S7object.getinstance().plccontrol.WriteWord(confirmationWrodAddress, (short) 2);
+                // S7object.getinstance().plccontrol.WriteWord(confirmationWrodAddress, (short) 2);
 
-              return true;
-            }
-            else if (!list2.isEmpty() && !list3.isEmpty()) {
+                return true;
+            } else if (!list2.isEmpty() && !list3.isEmpty()) {
                 log.info("鍓嶅悗绔兘绌洪棽 浼樺厛鍚庣鍑虹墖骞朵笖浼樺厛婊℃灦");
                 DownStorageCageDetails item4 = list2.get(0);
 
@@ -253,34 +268,34 @@
     }
 
 
-//
+    //
     public void insertdownglassinfo() {
         try {
 
-        List<DownGlassTask> taskdownGlassInf = downGlassTaskService.getUnloadingTaskState();
-        if (taskdownGlassInf != null && !taskdownGlassInf.isEmpty()) {
+            List<DownGlassTask> taskdownGlassInf = downGlassTaskService.getUnloadingTaskState();
+            if (taskdownGlassInf != null && !taskdownGlassInf.isEmpty()) {
 
-            for (DownGlassTask downGlassInfo : taskdownGlassInf) {
-                // 鍒涘缓鏂扮殑 DownGlassInfo 瀵硅薄骞惰缃浉鍏冲睘鎬�
-                DownGlassInfo newdownGlassInfo = new DownGlassInfo();
+                for (DownGlassTask downGlassInfo : taskdownGlassInf) {
+                    // 鍒涘缓鏂扮殑 DownGlassInfo 瀵硅薄骞惰缃浉鍏冲睘鎬�
+                    DownGlassInfo newdownGlassInfo = new DownGlassInfo();
 
-                Integer maxSequence = downGlassInfoService.getMaxSequenceByFlowCardId(downGlassInfo.getFlowCardId());
-                // 鍒濆鍖栭『搴忓瓧娈靛��
-                int sequence = maxSequence != null ? maxSequence + 1 : 1;
-                BeanUtils.copyProperties(downGlassInfo, newdownGlassInfo);
-                // 璁剧疆椤哄簭瀛楁鍊�
-                newdownGlassInfo.setSequence(sequence);
-                // 鎻掑叆鏁版嵁鍒颁笅鐗囩幓鐠冧俊鎭〃
-                downGlassInfoService.insertDownGlassInfo(newdownGlassInfo);
-                log.info("鎻掑叆鏁版嵁鍒颁笅鐗囩幓鐠冧俊鎭〃");
-                DownWorkstation downWorkstation1 = downWorkstationService.selectByFlowCardId(downGlassInfo.getFlowCardId());
-                downWorkstationService.updateracksnumber(downGlassInfo.getFlowCardId(), downWorkstation1.getRacksnumber() + 1);
-                log.info("鏇存柊钀芥灦鏁伴噺");
-                sequence++; // 閫掑椤哄簭瀛楁鍊�
+                    Integer maxSequence = downGlassInfoService.getMaxSequenceByFlowCardId(downGlassInfo.getFlowCardId());
+                    // 鍒濆鍖栭『搴忓瓧娈靛��
+                    int sequence = maxSequence != null ? maxSequence + 1 : 1;
+                    BeanUtils.copyProperties(downGlassInfo, newdownGlassInfo);
+                    // 璁剧疆椤哄簭瀛楁鍊�
+                    newdownGlassInfo.setSequence(sequence);
+                    // 鎻掑叆鏁版嵁鍒颁笅鐗囩幓鐠冧俊鎭〃
+                    downGlassInfoService.insertDownGlassInfo(newdownGlassInfo);
+                    log.info("鎻掑叆鏁版嵁鍒颁笅鐗囩幓鐠冧俊鎭〃");
+                    DownWorkstation downWorkstation1 = downWorkstationService.selectByFlowCardId(downGlassInfo.getFlowCardId());
+                    downWorkstationService.updateracksnumber(downGlassInfo.getFlowCardId(), downWorkstation1.getRacksnumber() + 1);
+                    log.info("鏇存柊钀芥灦鏁伴噺");
+                    sequence++; // 閫掑椤哄簭瀛楁鍊�
 
 
+                }
             }
-        }
         } catch (Exception e) {
             // 鎵撳嵃寮傚父淇℃伅
             e.printStackTrace();

--
Gitblit v1.8.0