From 64cad8c9b74d1450e873ce378110a7ed8c1aef56 Mon Sep 17 00:00:00 2001
From: wuyouming666 <2265557248@qq.com>
Date: 星期一, 22 一月 2024 09:04:34 +0800
Subject: [PATCH] 增加xlsx转换为json 工具类
---
springboot-vue3/src/main/java/com/example/springboot/component/PLCAutomaticParameterSettingReview.java | 184 +++++++++++++++++++++++-----------------------
1 files changed, 92 insertions(+), 92 deletions(-)
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/PLCAutomaticParameterSettingReview.java b/springboot-vue3/src/main/java/com/example/springboot/component/PLCAutomaticParameterSettingReview.java
index b1c3859..19d4b56 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/PLCAutomaticParameterSettingReview.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/PLCAutomaticParameterSettingReview.java
@@ -26,10 +26,10 @@
this.storageCageService = storageCageService;
this.plcParameterObject = new PlcParameterObject();
this.plcBitObject = new PlcBitObject();
- String jsonFilePath = "JsonFile/PlcParameter.json";
- InitUtil.initword(jsonFilePath); // 鍒濆鍖� PlcParameterObject
- String jsonFilePath2 = "JsonFile/PlcSign.json";
- InitUtil.initbit(jsonFilePath2); // 鍒濆鍖� PlcSign
+ // String jsonFilePath = "JsonFile/PlcParameter.json";
+ // InitUtil.initword(jsonFilePath); // 鍒濆鍖� PlcParameterObject
+ // String jsonFilePath2 = "JsonFile/PlcSign.json";
+ // InitUtil.initbit(jsonFilePath2); // 鍒濆鍖� PlcSign
}
@@ -89,7 +89,7 @@
String addressList2 = "DB100.18";
String addressList3 = "DB100.22";
String addressList4 = "DB100.14";
-
+System.out.println(plcParameterObject.getPlcParameterValues(Autoaddresses));
@@ -108,7 +108,7 @@
JSONObject jsonObject = new JSONObject();
// new short[]{1,1, 1, 1, 1, 1, 2, 33, 2,3, 4, 5}
// new short[]{0,0, 0, 0, 0, 0, 0, 0, 0, 0}
-System.out.println(plcParameterObject.getPlcParameterValues(addresses));
+//System.out.println(plcParameterObject.getPlcParameterValues(addresses));
jsonObject.append("params", plcParameterObject.getPlcParameterValues(addresses));
jsonObject.append("dache1", plcParameterObject.getPlcParameter("A01A02TRAVELPOSVelocityAUTO").getValue());
jsonObject.append("xiaoche", plcParameterObject.getPlcParameter("B01B02TRAVELPOSVelocityAUTO").getValue());
@@ -118,94 +118,94 @@
jsonObject.append("xiaoche2", plcParameterObject.getPlcParameter("B01B02TRAVELJOGVelocity").getValue());
ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("AutomaticParameterSetting");
- if (sendwServer != null) {
- for (WebSocketServer webserver : sendwServer) {
- webserver.sendMessage(jsonObject.toString());
+// if (sendwServer != null) {
+// for (WebSocketServer webserver : sendwServer) {
+// webserver.sendMessage(jsonObject.toString());
// WebSocketServer webSocketServer = WebSocketServer.sessionMap.get("AutomaticParameterSetting");
- if (webserver != null) {
- List<String> messages = webserver.getMessages();
-
-
- if (!messages.isEmpty()) {
- // 灏嗘渶鍚庝竴涓秷鎭浆鎹负 short 绫诲瀷鐨勫垪琛�
- String lastMessage = messages.get(messages.size() - 1);
- // System.out.println("lastMessage锛�" + lastMessage);
- JSONArray messageArray = new JSONArray(lastMessage);
-
- // 鏁村悎绗� 1 鍒� 2 涓暟缁勫苟鍘绘帀 null 鍏冪礌
- List<Short> mergedList = new ArrayList<>();
- for (int i = 0; i < 2; i++) {
- JSONArray sublist = messageArray.getJSONArray(i);
- for (int j = 0; j < sublist.size(); j++) {
- Object value = sublist.get(j);
- if (value != null && !value.toString().equals("null")) {
- try {
- String cleanedValue = value.toString().replaceAll("[^0-9-]", "");
- short sValue = Short.parseShort(cleanedValue.trim());
- mergedList.add(sValue);
- } catch (NumberFormatException e) {
- // 濡傛灉鏃犳硶瑙ｆ瀽涓� short 绫诲瀷锛屽垯蹇界暐璇ラ儴鍒�
- System.err.println("Could not parse value: " + value);
- }
- }
- }
- }
- System.out.println(messageArray);
- // 鍐欏叆绗竴涓湴鍧�
- customS7Control.WriteWordsToPLC(messageArray, addressList2,2);
- // 鍐欏叆绗簩涓湴鍧�
- customS7Control.WriteWordsToPLC(messageArray, addressList3,3);
- // 鍐欏叆绗笁涓湴鍧�
- customS7Control.WriteWordsToPLC(messageArray, addressList4,4);
- // 鍐欏叆绗洓涓湴鍧�
- if (!mergedList.isEmpty()) {
- S7control.getinstance().WriteWord(addressList1, mergedList);
- System.out.println("messageValue锛�" + mergedList + " written to PLC at address " + addressList1);
- }
-
- //List<String> waddresses1 = Arrays.asList(config.getProperty("Auto.shusong").split(","));
- String addressList22 = "DB100.8";
- String addressList33 = "DB100.12";
- if (!messages.isEmpty()) {
- // 灏嗘渶鍚庝竴涓秷鎭浆鎹负 short 绫诲瀷鐨勫垪琛�
- // 鏁村悎绗� 1 鍒� 3 涓暟缁勫苟鍘绘帀 null 鍏冪礌
- List<Short> mergedList2 = new ArrayList<>();
- for (int i = 5; i < 8; i++) {
- JSONArray sublist = messageArray.getJSONArray(i);
- for (int j = 0; j < sublist.size(); j++) {
- Object value = sublist.get(j);
- if (value != null && !value.toString().equals("null")) {
- try {
- String cleanedValue = value.toString().replaceAll("[^0-9-]", "");
- short sValue = Short.parseShort(cleanedValue.trim());
- mergedList2.add(sValue);
- } catch (NumberFormatException e) {
- // 濡傛灉鏃犳硶瑙ｆ瀽涓� short 绫诲瀷锛屽垯蹇界暐璇ラ儴鍒�
- System.err.println("Could not parse value: " + value);
- }
- }
- }
- }
-
- // 鍐欏叆绗紞涓湴鍧�
- customS7Control.WriteWordsToPLC(messageArray, addressList22,8);
- // 鍐欏叆绗叚涓湴鍧�
- customS7Control.WriteWordsToPLC(messageArray, addressList33,9);
- // 鍐欏叆绗竷涓湴鍧�
- // plcParameterObject.getPlcParameter("conveyorVelocity(AutoFAST)").getAddress(index)
- if (!mergedList2.isEmpty()) {
- //S7control.getinstance().WriteWord(plcParameterObject.getPlcParameter(Autoaddresses), mergedList2);
- // System.out.println("messageValue锛�" + mergedList2 + " written to PLC at address " + waddresses1);
- }
- // 娓呯┖娑堟伅鍒楄〃
- webserver.clearMessages();
- }
- }
- }
-
- }
- }
+// if (webserver != null) {
+// List<String> messages = webserver.getMessages();
+//
+//
+// if (!messages.isEmpty()) {
+// // 灏嗘渶鍚庝竴涓秷鎭浆鎹负 short 绫诲瀷鐨勫垪琛�
+// String lastMessage = messages.get(messages.size() - 1);
+// // System.out.println("lastMessage锛�" + lastMessage);
+// JSONArray messageArray = new JSONArray(lastMessage);
+//
+// // 鏁村悎绗� 1 鍒� 2 涓暟缁勫苟鍘绘帀 null 鍏冪礌
+// List<Short> mergedList = new ArrayList<>();
+// for (int i = 0; i < 2; i++) {
+// JSONArray sublist = messageArray.getJSONArray(i);
+// for (int j = 0; j < sublist.size(); j++) {
+// Object value = sublist.get(j);
+// if (value != null && !value.toString().equals("null")) {
+// try {
+// String cleanedValue = value.toString().replaceAll("[^0-9-]", "");
+// short sValue = Short.parseShort(cleanedValue.trim());
+// mergedList.add(sValue);
+// } catch (NumberFormatException e) {
+// // 濡傛灉鏃犳硶瑙ｆ瀽涓� short 绫诲瀷锛屽垯蹇界暐璇ラ儴鍒�
+// System.err.println("Could not parse value: " + value);
+// }
+// }
+// }
+// }
+// System.out.println(messageArray);
+// // 鍐欏叆绗竴涓湴鍧�
+// customS7Control.WriteWordsToPLC(messageArray, addressList2,2);
+// // 鍐欏叆绗簩涓湴鍧�
+// customS7Control.WriteWordsToPLC(messageArray, addressList3,3);
+// // 鍐欏叆绗笁涓湴鍧�
+// customS7Control.WriteWordsToPLC(messageArray, addressList4,4);
+// // 鍐欏叆绗洓涓湴鍧�
+// if (!mergedList.isEmpty()) {
+// S7control.getinstance().WriteWord(addressList1, mergedList);
+// System.out.println("messageValue锛�" + mergedList + " written to PLC at address " + addressList1);
+// }
+//
+// //List<String> waddresses1 = Arrays.asList(config.getProperty("Auto.shusong").split(","));
+// String addressList22 = "DB100.8";
+// String addressList33 = "DB100.12";
+// if (!messages.isEmpty()) {
+// // 灏嗘渶鍚庝竴涓秷鎭浆鎹负 short 绫诲瀷鐨勫垪琛�
+// // 鏁村悎绗� 1 鍒� 3 涓暟缁勫苟鍘绘帀 null 鍏冪礌
+// List<Short> mergedList2 = new ArrayList<>();
+// for (int i = 5; i < 8; i++) {
+// JSONArray sublist = messageArray.getJSONArray(i);
+// for (int j = 0; j < sublist.size(); j++) {
+// Object value = sublist.get(j);
+// if (value != null && !value.toString().equals("null")) {
+// try {
+// String cleanedValue = value.toString().replaceAll("[^0-9-]", "");
+// short sValue = Short.parseShort(cleanedValue.trim());
+// mergedList2.add(sValue);
+// } catch (NumberFormatException e) {
+// // 濡傛灉鏃犳硶瑙ｆ瀽涓� short 绫诲瀷锛屽垯蹇界暐璇ラ儴鍒�
+// System.err.println("Could not parse value: " + value);
+// }
+// }
+// }
+// }
+//
+// // 鍐欏叆绗紞涓湴鍧�
+// customS7Control.WriteWordsToPLC(messageArray, addressList22,8);
+// // 鍐欏叆绗叚涓湴鍧�
+// customS7Control.WriteWordsToPLC(messageArray, addressList33,9);
+// // 鍐欏叆绗竷涓湴鍧�
+// // plcParameterObject.getPlcParameter("conveyorVelocity(AutoFAST)").getAddress(index)
+// if (!mergedList2.isEmpty()) {
+// //S7control.getinstance().WriteWord(plcParameterObject.getPlcParameter(Autoaddresses), mergedList2);
+// // System.out.println("messageValue锛�" + mergedList2 + " written to PLC at address " + waddresses1);
+// }
+// // 娓呯┖娑堟伅鍒楄〃
+// webserver.clearMessages();
+// }
+// }
+// }
+//
+// }
+// }
}
--
Gitblit v1.8.0