From 65ae6084f552c035eb5640afbd8f73e6054e3b6c Mon Sep 17 00:00:00 2001 From: zhoushihao <zsh19950802@163.com> Date: 星期二, 16 七月 2024 21:15:53 +0800 Subject: [PATCH] 1、大理片:fixbug:大理片出片逻辑修改,钢化版图是否到齐:sql逻辑问题,包含人工出片任务,造成钢化版图是否到齐需要获取已出片的玻璃,造成已出笼的玻璃会重复计算并准备生成钢化任务,但获取的玻璃信息为空,造成插入钢化表异常。且排除已出笼的钢化版图较复杂(暂不关联钢化小片表),目前解决方案:把所有到齐的钢化版图数据查出来,排除笼内玻璃为空的 2、移除已配置完mapperscan已扫描仍有@Mapper注解的 --- hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/tools/ExcelToJsonConverter.java | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/tools/ExcelToJsonConverter.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/tools/ExcelToJsonConverter.java index 8fbb58a..d5cc9c8 100644 --- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/tools/ExcelToJsonConverter.java +++ b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/tools/ExcelToJsonConverter.java @@ -18,13 +18,13 @@ public class ExcelToJsonConverter { public static void main(String[] args) { - String excelFilePath = "src/main/resources/JsonFile/alarm.xlsx"; + String excelFilePath = "src/main/resources/JsonFile/PlcdownGlass.xlsx"; String sheetName = "Sheet1"; int addressColumnIndex = 0; int nameColumnIndex = 1; //int unitColumnIndex = 2; - String outputFilePath = "src/main/resources/JsonFile/PlcAlarm.json"; + String outputFilePath = "src/main/resources/JsonFile/PlcdownGlass.json"; try (Workbook workbook = new XSSFWorkbook(new FileInputStream(excelFilePath))) { Sheet sheet = workbook.getSheet(sheetName); @@ -75,8 +75,8 @@ LinkedHashMap<String, Object> resultObject = new LinkedHashMap<>(); resultObject.put("plcAddressBegin", "DB100.0"); resultObject.put("plcAddressLenght", String.valueOf(plcAddressLength)); - // resultObject.put("dataType", "word"); - resultObject.put("dataType", "bit"); + resultObject.put("dataType", "word"); + // resultObject.put("dataType", "bit"); resultObject.put("parameteInfor", jsonList); Gson gson = new Gson(); -- Gitblit v1.8.0