From 230b4029e603c22c6160063cb109001080123670 Mon Sep 17 00:00:00 2001
From: whyclxw <http://whyclxw@118.89.139.230:10101/r/~whyclxw/IdeaTest.git>
Date: 星期四, 25 三月 2021 16:27:09 +0800
Subject: [PATCH] 修改电源
---
Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java | 66 +++++++++++++++++++++++++++++++++
1 files changed, 66 insertions(+), 0 deletions(-)
diff --git a/Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java b/Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java
index f213baf..d536b6f 100644
--- a/Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java
+++ b/Demo_Manage_Simul/src/com/thread/Manage_Simul_SQL.java
@@ -9,6 +9,8 @@
import com.base.Com;
import com.mode.Device_Inf;
import com.mode.Dynamicload_State_rt;
+import com.mode.Electric_State_2kw;
+import com.mode.Electric_state;
import com.sql.MysqlConnPool;
import com.sql.Sql_Mysql;
@@ -95,4 +97,68 @@
sql.close_con();
}
}
+ //加载4MW电源实时数据
+ public static void update4MWPower(MysqlConnPool conn_pool, Electric_state state) {
+ String sql_str = " update "+ Sql_Mysql.Tb_Electric_State_Table +" "
+ + " SET case_trip_output = "+state.case_trip_output+","
+ +" record_time='" + Com.getDateTimeFormat(state.getRecord_time(), Com.DTF_YMDhms)+"',"
+ + " fault_reset_signal = "+state.fault_reset_signal+","
+ + " high_vol_switch_status = "+state.high_vol_switch_status+","
+ + " stop_button = "+state.stop_button+","
+ + " main_cabinet_fan_status = "+state.main_cabinet_fan_status+","
+ + " trans_cabinet_door_lock = "+state.trans_cabinet_door_lock+","
+ + " trans_cabinet_overtem_alarm = "+state.trans_cabinet_overtem_alarm+","
+ + " trans_cabinet_overtem_trip = "+state.trans_cabinet_overtem_trip+","
+ + " qs1_state = "+state.qs1_state+","
+ + " qs2_state = "+state.qs2_state+","
+ + " switch_cabinet_door_status = "+state.switch_cabinet_door_status+","
+ + " alldcvol = "+state.alldcvol+","
+ + " alldccurr = "+state.alldccurr+","
+ + " conn_flag = "+state.conn_flag+" "
+ + " WHERE electric_id ="+state.electric_id;
+ Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
+ try {
+ //System.out.println(sql_str);
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+ //加载2MW电源实时数据
+ public static void update2MWPower(MysqlConnPool conn_pool, Electric_State_2kw state) {
+ String sql_str = " UPDATE "+Sql_Mysql.Tb_Electric2mw_State_Table +
+ " Set brachdcvol= " + state.brachdcvol +
+ ",record_time='" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) +
+ "',brachdccurr=" + state.brachdccurr +
+ ",alldcvol=" + state.alldcvol +
+ ",alldccurr=" + state.alldccurr +
+ ",stopchargevol_one=" + state.stopchargevol_one +
+ ",stopchargevol_two=" + state.stopchargevol_two +
+ ",stopchargevol_three=" + state.stopchargevol_three +
+ ",stopchargevol_four=" + state.stopchargevol_four +
+ ",stopchargevol_five=" + state.stopchargevol_five +
+ ",controlangle=" + state.controlangle +
+ ",localgivevol=" + state.localgivevol +
+ ",volset=" + state.volset +
+ ",localgivecurr=" + state.localgivecurr +
+ ",currset=" + state.currset +
+ ",chargecurr_one=" + state.chargecurr_one +
+ ",chargecurr_two=" + state.chargecurr_two +
+ ",chargecurr_three=" + state.chargecurr_three +
+ ",chargecurr_four=" + state.chargecurr_four +
+ ",chargecurr_five=" + state.chargecurr_five +
+ ",consvolmode_chargecurr=" +state.consvolmode_chargecurr+
+ " Where electric2KW_id = " + state.electric2KW_id;
+ Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
+ try {
+ //System.out.println(sql_str);
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
}
--
Gitblit v1.9.1