From 5bbbefadb317d2d9c0c66d86c7ee7f8c3dcb19a3 Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期四, 16 五月 2024 16:37:46 +0800
Subject: [PATCH] 问题反馈

---
 lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/EquipmentWorkLineServiceImpl.java |   47 ++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 42 insertions(+), 5 deletions(-)

diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/EquipmentWorkLineServiceImpl.java b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/EquipmentWorkLineServiceImpl.java
index b5233df..5d910c2 100644
--- a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/EquipmentWorkLineServiceImpl.java
+++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/EquipmentWorkLineServiceImpl.java
@@ -34,10 +34,47 @@
 
     @Override
     @Transactional(readOnly = true)
-    public List<EquipmentMachingDto> getEquipmentSequencenumber(String drivetype, String equipmentid, Date startTime, Date endTime) {
-        String tableName = drivetype + "_" + equipmentid;
-        List<Map<String, Object>> list = equipmentWorkLineMapper.getEquipmentSequenceNumber(tableName, startTime, endTime);
-        return convertData(list);
+    public List<EquipmentMachingDto> getEquipmentSequencenumber(String tableName, Date startTime, Date endTime) {
+        try {
+            List<Map<String, Object>> list = equipmentWorkLineMapper.getEquipmentSequenceNumber(tableName, startTime, endTime);
+            return convertData(list);
+        } catch (Exception e) {
+            return null;
+        }
+    }
+
+    @Override
+    public Boolean isTableExist(String tableName) {
+        Integer count = equipmentWorkLineMapper.isTableExist(tableName);
+        return count != 0;
+    }
+
+    @Override
+    public List<String> findRunningData(String tableName, Date startTime, Date endTime) {
+        return equipmentWorkLineMapper.findRunningData(tableName, startTime, endTime);
+    }
+
+    @Override
+    public List<EquipmentMachingDto> getEquipProgramNum(String drivetype, String equipmentid, Date startTime, Date endTime) {
+        return equipmentWorkLineMapper.getEquipProgramNum(drivetype + "_" + equipmentid, startTime, endTime);
+    }
+
+    @Override
+    public MdcEquipmentDto findProductCountStartTime(String saveTableName, String productCount, Date startTime, Date endTime) {
+        try {
+            return equipmentWorkLineMapper.findProductCountStartTime(saveTableName, productCount, startTime, endTime);
+        } catch (Exception e) {
+            return null;
+        }
+    }
+
+    @Override
+    public MdcEquipmentDto findProductCountEndTime(String saveTableName, String productCount, Date startTime, Date endTime) {
+        try {
+            return equipmentWorkLineMapper.findProductCountEndTime(saveTableName, productCount, startTime, endTime);
+        } catch (Exception e) {
+            return null;
+        }
     }
 
     private List<EquipmentMachingDto> convertData(List<Map<String, Object>> list) {
@@ -59,7 +96,7 @@
             ei.setFeedrate(map.get("feedrate") == null ? null : map.get("feedrate").toString());
             ei.setFeedbeilv(map.get("feedbeilv") == null ? null : map.get("feedbeilv").toString());
             ei.setProgramnumber(map.get("Programnumber") == null ? null : map.get("Programnumber").toString());
-            ei.setSequencenumber(map.get("SEQUENCENUMBER") == null ? null : map.get("SEQUENCENUMBER").toString());
+            ei.setSequencenumber(map.get("Sequencenumber") == null ? null : map.get("Sequencenumber").toString());
             ei.setExecutingcode(map.get("executingcode") == null ? null : map.get("executingcode").toString());
             ei.setProductName(map.get("ProductName") == null ? null : map.get("ProductName").toString());
             dto.add(ei);

--
Gitblit v1.9.3