From cfe3b8044b61ced5772914bfbbdc629fbedf4bd5 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期五, 19 四月 2024 11:33:21 +0800
Subject: [PATCH] 程序新增单体剩余容量数据读取
---
iec61850_forFoShanAES_Model/src/com/dec/fbs9100/BTS61850_Task_Thread_SQL.java | 25 +++++++++++++++++++++++++
1 files changed, 25 insertions(+), 0 deletions(-)
diff --git a/iec61850_forFoShanAES_Model/src/com/dec/fbs9100/BTS61850_Task_Thread_SQL.java b/iec61850_forFoShanAES_Model/src/com/dec/fbs9100/BTS61850_Task_Thread_SQL.java
index 044ca89..7661773 100644
--- a/iec61850_forFoShanAES_Model/src/com/dec/fbs9100/BTS61850_Task_Thread_SQL.java
+++ b/iec61850_forFoShanAES_Model/src/com/dec/fbs9100/BTS61850_Task_Thread_SQL.java
@@ -4,6 +4,7 @@
import java.sql.SQLException;
import java.util.Date;
import com.base.Com;
+import com.battdata_rt.BattData_RT;
public class BTS61850_Task_Thread_SQL {
@@ -133,4 +134,28 @@
sql.close_con();
}
}
+
+ public static void updateBattRtState_Table(MysqlConnPool pool,FBS9100_VCData vc_data,BattData_RT[] battdata) {
+ for(int i=0;i<battdata.length;i++) {
+ if(null == battdata[i]) {
+ continue;
+ }
+ String sql_str = " UPDATE " + Sql_Mysql.BattRsAlarm_Table + ""
+ + " SET record_time = '"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"'"
+ + ",groupvol_alm = " + vc_data.groupvolalm[i]
+ + ",test_end_cap=" + vc_data.test_end_cap[i]
+ + ",test_end_vol=" + vc_data.test_end_vol[i]
+ + ",test_timelong= " + vc_data.test_timelong[i] +
+ " WHERE BattGroupId = " + battdata[i].BattGroupId;
+ Sql_Mysql sql = new Sql_Mysql(pool);
+ try {
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ sql.logger.error("BTS61850_Task_Thread_SQL.updateBattRtState_Table():" + e.toString(), e);
+ } finally {
+ sql.close_con();
+ }
+
+ }
+ }
}
--
Gitblit v1.9.1