package com.power.data;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.Date;
|
|
import org.apache.logging.log4j.LogManager;
|
import org.apache.logging.log4j.Logger;
|
|
import com.base.Com;
|
import com.power.mysql.MysqlConnPool;
|
import com.power.mysql.Sql_Mysql;
|
|
public class PowerData_RT_SQL {
|
|
static Logger logger = LogManager.getLogger(PowerData_RT_SQL.class);
|
|
public static void insertPower_Data_RT_Table(MysqlConnPool conn_pool, int dev_id, String tablestr) {
|
|
String sqlstr = "SELECT 1 FROM " + tablestr
|
+ " WHERE PowerDeviceId="+dev_id + " limit 1;";
|
|
String sqlstr1 = "INSERT INTO " + tablestr + " "
|
+ " (PowerDeviceId)"
|
+ " VALUES " + "(" + dev_id + ");";
|
|
//logger.info(sqlstr);
|
|
boolean recordexists = false;
|
|
Sql_Mysql sql = null;
|
|
try {
|
sql = new Sql_Mysql(conn_pool.getConn());
|
|
|
ResultSet rs_t = sql.sqlMysqlQuery(sqlstr);
|
|
if(rs_t.next()) {
|
recordexists = true;
|
|
//logger.info("recordexists = true");
|
}
|
|
if(false == recordexists) {
|
|
sql.sqlMysqlExecute(sqlstr1);
|
}
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
public static void insertPower_StaInfo_Table(MysqlConnPool conn_pool, int dev_id) {
|
|
String sqlstr = "SELECT 1 FROM " + Sql_Mysql.PWRDEV_STAINF_TABLE
|
+ " WHERE PowerDeviceId="+dev_id + " limit 1;";
|
|
String sqlstr1 = "INSERT INTO " + Sql_Mysql.PWRDEV_STAINF_TABLE + " "
|
+ " (PowerDeviceId,RunCompany,HistoryAlarmRelatRecord)"
|
+ " VALUES " + "(" + dev_id + "," + "''" + "," + "''" + ");";
|
|
//logger.info(sqlstr1);
|
|
boolean recordexists = false;
|
|
Sql_Mysql sql = null;
|
|
try {
|
sql = new Sql_Mysql(conn_pool.getConn());
|
|
|
ResultSet rs_t = sql.sqlMysqlQuery(sqlstr);
|
|
if(rs_t.next()) {
|
recordexists = true;
|
|
//logger.info("recordexists = true");
|
}
|
|
if(false == recordexists) {
|
|
sql.sqlMysqlExecute(sqlstr1);
|
}
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
public static void insertPower_acmInfo_Table(MysqlConnPool conn_pool, int dev_id) {
|
|
String sqlstr = "SELECT 1 FROM " + Sql_Mysql.PWRDEV_ACINF_TABLE
|
+ " WHERE PowerDeviceId="+dev_id + " limit 1;";
|
|
String sqlstr1 = "INSERT INTO " + Sql_Mysql.PWRDEV_ACINF_TABLE + " "
|
+ " (PowerDeviceId,InputSWCount,OutputSWCount,Cap,UsePurPose)"
|
+ " VALUES " + "(" + dev_id + "," + 60 + "," + 60 + "," + 10 + "," + "''" + ");";
|
|
//logger.info(sqlstr1);
|
|
boolean recordexists = false;
|
|
Sql_Mysql sql = null;
|
|
try {
|
sql = new Sql_Mysql(conn_pool.getConn());
|
|
|
ResultSet rs_t = sql.sqlMysqlQuery(sqlstr);
|
|
if(rs_t.next()) {
|
recordexists = true;
|
|
//logger.info("recordexists = true");
|
}
|
|
if(false == recordexists) {
|
|
sql.sqlMysqlExecute(sqlstr1);
|
}
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
public static void insertPower_acdcmInfo_Table(MysqlConnPool conn_pool, int dev_id) {
|
|
String sqlstr = "SELECT 1 FROM " + Sql_Mysql.PWRDEV_ACDCINF_TABLE
|
+ " WHERE PowerDeviceId="+dev_id + " limit 1;";
|
|
String sqlstr1 = "INSERT INTO " + Sql_Mysql.PWRDEV_ACDCINF_TABLE + " "
|
+ " (PowerDeviceId,ModuleInUseCount,ModuleCap,ModuleSlotCount) "
|
+ " VALUES " + "(" + dev_id + "," + 16 + "," + 50 + "," + 16 + ");";
|
|
//logger.info(sqlstr1);
|
|
boolean recordexists = false;
|
|
Sql_Mysql sql = null;
|
|
try {
|
sql = new Sql_Mysql(conn_pool.getConn());
|
|
|
ResultSet rs_t = sql.sqlMysqlQuery(sqlstr);
|
|
if(rs_t.next()) {
|
recordexists = true;
|
|
//logger.info("recordexists = true");
|
}
|
|
if(false == recordexists) {
|
|
sql.sqlMysqlExecute(sqlstr1);
|
}
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
public static void insertPower_dcmInfo_Table(MysqlConnPool conn_pool, int dev_id) {
|
|
String sqlstr = "SELECT 1 FROM " + Sql_Mysql.PWRDEV_DCINF_TABLE
|
+ " WHERE PowerDeviceId="+dev_id + " limit 1;";
|
|
String sqlstr1 = "INSERT INTO " + Sql_Mysql.PWRDEV_DCINF_TABLE + " "
|
+ " (PowerDeviceId,InputSWCount,OutputSWCount,Cap,UsePurPose)"
|
+ " VALUES " + "(" + dev_id + "," + 60 + "," + 60 + "," + 10 + "," + "''"+ ");";
|
|
//logger.info(sqlstr);
|
|
boolean recordexists = false;
|
|
Sql_Mysql sql = null;
|
|
try {
|
sql = new Sql_Mysql(conn_pool.getConn());
|
|
|
ResultSet rs_t = sql.sqlMysqlQuery(sqlstr);
|
|
if(rs_t.next()) {
|
recordexists = true;
|
|
//logger.info("recordexists = true");
|
}
|
|
if(false == recordexists) {
|
|
sql.sqlMysqlExecute(sqlstr1);
|
}
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
public static void updatePower_ACDC_Data_RT_Table(MysqlConnPool conn_pool, PowerData_RT rtdata) {
|
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
|
try
|
{
|
String sql_str = "UPDATE " + Sql_Mysql.PWRDEV_ACDCDATA_TABLE
|
+ " SET "
|
+ " record_datetime='" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "',"
|
+ " acIn1_volA=" + rtdata.m_acdcData.acIn1_volA + ","
|
+ " acIn1_volB=" + rtdata.m_acdcData.acIn1_volB + ","
|
+ " acIn1_volC=" + rtdata.m_acdcData.acIn1_volC + ","
|
+ " acIn2_volA=" + rtdata.m_acdcData.acIn2_volA + ","
|
+ " acIn2_volB=" + rtdata.m_acdcData.acIn2_volB + ","
|
+ " acIn2_volC=" + rtdata.m_acdcData.acIn2_volC + ","
|
+ " acOut_volA=" + rtdata.m_acdcData.acOut_volA + ","
|
+ " acOut_volB=" + rtdata.m_acdcData.acOut_volB + ","
|
+ " acOut_volC=" + rtdata.m_acdcData.acOut_volC + ","
|
+ " acOut_currA=" + rtdata.m_acdcData.acOut_currA + ","
|
+ " acOut_currB=" + rtdata.m_acdcData.acOut_currB + ","
|
+ " acOut_currC=" + rtdata.m_acdcData.acOut_currC + ","
|
+ " dcOut_vol=" + rtdata.m_acdcData.dcOut_vol + ","
|
+ " dcOut_curr=" + rtdata.m_acdcData.dcOut_curr + ","
|
+ " battgroup1_vol=" + rtdata.m_acdcData.battgroup1_vol + ","
|
+ " battgroup1_curr=" + rtdata.m_acdcData.battgroup1_curr + ","
|
+ " battgroup2_vol=" + rtdata.m_acdcData.battgroup2_vol + ","
|
+ " battgroup2_curr=" + rtdata.m_acdcData.battgroup2_curr + ","
|
// + " temprature=" + (rtdata.m_acdcData.is_temprature?1:0) + ","
|
+ " temprature=" + (rtdata.m_acdcData.is_temprature?1:-1) + ","
|
+ " m_outputvol=" + rtdata.m_acdcData.m_outputvol + ","
|
|
+ " m1_outCurr=" + rtdata.m_acdcData.m_out_curr[0] + ","
|
+ " m2_outCurr=" + rtdata.m_acdcData.m_out_curr[1] + ","
|
+ " m3_outCurr=" + rtdata.m_acdcData.m_out_curr[2] + ","
|
+ " m4_outCurr=" + rtdata.m_acdcData.m_out_curr[3] + ","
|
+ " m5_outCurr=" + rtdata.m_acdcData.m_out_curr[4] + ","
|
+ " m6_outCurr=" + rtdata.m_acdcData.m_out_curr[5] + ","
|
+ " m7_outCurr=" + rtdata.m_acdcData.m_out_curr[6] + ","
|
+ " m8_outCurr=" + rtdata.m_acdcData.m_out_curr[7] + ","
|
+ " m9_outCurr=" + rtdata.m_acdcData.m_out_curr[8] + ","
|
+ " m10_outCurr=" + rtdata.m_acdcData.m_out_curr[9] + ","
|
+ " m11_outCurr=" + rtdata.m_acdcData.m_out_curr[10] + ","
|
+ " m12_outCurr=" + rtdata.m_acdcData.m_out_curr[11] + ","
|
+ " m13_outCurr=" + rtdata.m_acdcData.m_out_curr[12] + ","
|
+ " m14_outCurr=" + rtdata.m_acdcData.m_out_curr[13] + ","
|
+ " m15_outCurr=" + rtdata.m_acdcData.m_out_curr[14] + ","
|
+ " m16_outCurr=" + rtdata.m_acdcData.m_out_curr[15] + ","
|
|
+ " is_acIn1_over_volA=" + rtdata.m_acdcData.is_acIn1_over_volA + ","
|
+ " is_acIn1_under_volA=" + rtdata.m_acdcData.is_acIn1_under_volA + ","
|
+ " is_acIn1_less_A=" + rtdata.m_acdcData.is_acIn1_less_A + ","
|
+ " is_acIn1_over_volB=" + rtdata.m_acdcData.is_acIn1_over_volB + ","
|
+ " is_acIn1_under_volB=" + rtdata.m_acdcData.is_acIn1_under_volB + ","
|
+ " is_acIn1_less_B=" + rtdata.m_acdcData.is_acIn1_less_B + ","
|
+ " is_acIn1_over_volC=" + rtdata.m_acdcData.is_acIn1_over_volC + ","
|
+ " is_acIn1_under_volC=" + rtdata.m_acdcData.is_acIn1_under_volC + ","
|
+ " is_acIn1_less_C=" + rtdata.m_acdcData.is_acIn1_less_C + ","
|
|
+ " is_acIn1_thunder_err=" + rtdata.m_acdcData.is_acIn1_thunder_err + ","
|
+ " is_acIn1_powerdown=" + rtdata.m_acdcData.is_acIn1_powerdown + ", "
|
+ " is_acIn2_over_volA=" + rtdata.m_acdcData.is_acIn2_over_volA + ", "
|
+ " is_acIn2_under_volA=" + rtdata.m_acdcData.is_acIn2_under_volA + ", "
|
+ " is_acIn2_less_A=" + rtdata.m_acdcData.is_acIn2_less_A + ", "
|
+ " is_acIn2_over_volB=" + rtdata.m_acdcData.is_acIn2_over_volB + ", "
|
+ " is_acIn2_under_volB=" + rtdata.m_acdcData.is_acIn2_under_volB + ", "
|
+ " is_acIn2_less_B=" + rtdata.m_acdcData.is_acIn2_less_B + ", "
|
+ " is_acIn2_over_volC=" + rtdata.m_acdcData.is_acIn2_over_volC + ", "
|
+ " is_acIn2_under_volC=" + rtdata.m_acdcData.is_acIn2_under_volC + ", "
|
+ " is_acIn2_less_C=" + rtdata.m_acdcData.is_acIn2_less_C + ", "
|
+ " is_acIn2_thunder_err=" + rtdata.m_acdcData.is_acIn2_thunder_err + ", "
|
+ " is_acIn2_powerdown=" + rtdata.m_acdcData.is_acIn2_powerdown + ","
|
+ " is_acIn_monitorerr=" + rtdata.m_acdcData.is_acIn_monitorerr + ", "
|
+ " is_dcOut_over_vol=" + rtdata.m_acdcData.is_dcOut_over_vol + ", "
|
+ " is_dcOut_under_vol=" + rtdata.m_acdcData.is_dcOut_under_vol + ", "
|
+ " is_battgroup_down=" + rtdata.m_acdcData.is_battgroup1_down + ", "
|
+ " is_jun_charge=" + rtdata.m_acdcData.is_jun_charge + ", "
|
+ " is_acdcMod1_err=" + rtdata.m_acdcData.is_acdcMod_err[0] + ", "
|
+ " is_acdcMod1_off=" + rtdata.m_acdcData.is_acdcMod_off[0] + ", "
|
+ " is_acdcMod2_err=" + rtdata.m_acdcData.is_acdcMod_err[1] + ", "
|
+ " is_acdcMod2_off=" + rtdata.m_acdcData.is_acdcMod_off[1] + ", "
|
+ " is_acdcMod3_err=" + rtdata.m_acdcData.is_acdcMod_err[2] + ", "
|
+ " is_acdcMod3_off=" + rtdata.m_acdcData.is_acdcMod_off[2] + ", "
|
+ " is_acdcMod4_err=" + rtdata.m_acdcData.is_acdcMod_err[3] + ", "
|
+ " is_acdcMod4_off=" + rtdata.m_acdcData.is_acdcMod_off[3] + ", "
|
+ " is_acdcMod5_err=" + rtdata.m_acdcData.is_acdcMod_err[4] + ", "
|
+ " is_acdcMod5_off=" + rtdata.m_acdcData.is_acdcMod_off[4] + ", "
|
+ " is_acdcMod6_err=" + rtdata.m_acdcData.is_acdcMod_err[5] + ", "
|
+ " is_acdcMod6_off=" + rtdata.m_acdcData.is_acdcMod_off[5] + ", "
|
+ " is_acdcMod7_err=" + rtdata.m_acdcData.is_acdcMod_err[6] + ", "
|
+ " is_acdcMod7_off=" + rtdata.m_acdcData.is_acdcMod_off[6] + ", "
|
+ " is_acdcMod8_err=" + rtdata.m_acdcData.is_acdcMod_err[7] + ", "
|
+ " is_acdcMod8_off=" + rtdata.m_acdcData.is_acdcMod_off[7] + ", "
|
+ " is_acdcMod9_err=" + rtdata.m_acdcData.is_acdcMod_err[8] + ", "
|
+ " is_acdcMod9_off=" + rtdata.m_acdcData.is_acdcMod_off[8] + ", "
|
+ " is_acdcMod10_err=" + rtdata.m_acdcData.is_acdcMod_err[9] + ", "
|
+ " is_acdcMod10_off=" + rtdata.m_acdcData.is_acdcMod_off[9] + ", "
|
+ " is_acdcMod11_err=" + rtdata.m_acdcData.is_acdcMod_err[10] + ", "
|
+ " is_acdcMod11_off=" + rtdata.m_acdcData.is_acdcMod_off[10] + ", "
|
+ " is_acdcMod12_err=" + rtdata.m_acdcData.is_acdcMod_err[11] + ", "
|
+ " is_acdcMod12_off=" + rtdata.m_acdcData.is_acdcMod_off[11] + ", "
|
+ " is_acdcMod13_err=" + rtdata.m_acdcData.is_acdcMod_err[12] + ", "
|
+ " is_acdcMod13_off=" + rtdata.m_acdcData.is_acdcMod_off[12] + ", "
|
+ " is_acdcMod14_err=" + rtdata.m_acdcData.is_acdcMod_err[13] + ", "
|
+ " is_acdcMod14_off=" + rtdata.m_acdcData.is_acdcMod_off[13] + ","
|
+ " is_acdcMod15_err=" + rtdata.m_acdcData.is_acdcMod_err[14] + ", "
|
+ " is_acdcMod15_off=" + rtdata.m_acdcData.is_acdcMod_off[14] + ", "
|
+ " is_acdcMod16_err=" + rtdata.m_acdcData.is_acdcMod_err[15] + ", "
|
+ " is_acdcMod16_off=" + rtdata.m_acdcData.is_acdcMod_off[15] + ", "
|
+ " is_acIn1_trip=" + rtdata.m_acdcData.is_acIn1_trip + ", "
|
+ " is_acIn2_trip=" + rtdata.m_acdcData.is_acIn2_trip + ", "
|
+ " is_loader_fuse=" + rtdata.m_acdcData.is_loader_fuse + ", "
|
+ " is_battgroup1_fuse=" + rtdata.m_acdcData.is_battgroup1_fuse + ", "
|
+ " is_battgroup2_fuse=" + rtdata.m_acdcData.is_battgroup2_fuse + ", "
|
+ " is_total_alarm=" + rtdata.m_acdcData.is_total_alarm + ", "
|
+ " acIn1_currA=" + rtdata.m_acdcData.acIn1_currA + ", "
|
+ " acIn1_currB=" + rtdata.m_acdcData.acIn1_currB + ", "
|
+ " acIn1_currC=" + rtdata.m_acdcData.acIn1_currC + ", "
|
+ " loader_curr=" + rtdata.m_acdcData.loader_curr + ", "
|
+ " battgroup1_ah=" + rtdata.m_acdcData.battgroup1_ah + ", "
|
+ " battgroup1_temp=" + rtdata.m_acdcData.battgroup1_temp + ", "
|
+ " battgroup2_ah=" + rtdata.m_acdcData.battgroup2_ah + ", "
|
+ " battgroup2_temp=" + rtdata.m_acdcData.battgroup2_temp + ", "
|
+ " acdcm_temp=" + rtdata.m_acdcData.acdcm_temp + ", "
|
+ " m1_out_vol=" + rtdata.m_acdcData.m_out_vol[0] + ", "
|
+ " m2_out_vol=" + rtdata.m_acdcData.m_out_vol[1] + ", "
|
+ " m3_out_vol=" + rtdata.m_acdcData.m_out_vol[2] + ", "
|
+ " m4_out_vol=" + rtdata.m_acdcData.m_out_vol[3] + ","
|
+ " m5_out_vol=" + rtdata.m_acdcData.m_out_vol[4] + ", "
|
+ " m6_out_vol=" + rtdata.m_acdcData.m_out_vol[5] + ", "
|
+ " m7_out_vol=" + rtdata.m_acdcData.m_out_vol[6] + ", "
|
+ " m8_out_vol=" + rtdata.m_acdcData.m_out_vol[7] + ", "
|
+ " m9_out_vol=" + rtdata.m_acdcData.m_out_vol[8] + ", "
|
+ " m10_out_vol=" + rtdata.m_acdcData.m_out_vol[9] + ", "
|
+ " m11_out_vol=" + rtdata.m_acdcData.m_out_vol[10] + ", "
|
+ " m12_out_vol=" + rtdata.m_acdcData.m_out_vol[11] + ", "
|
+ " m13_out_vol=" + rtdata.m_acdcData.m_out_vol[12] + ", "
|
+ " m14_out_vol=" + rtdata.m_acdcData.m_out_vol[13] + ", "
|
+ " m15_out_vol=" + rtdata.m_acdcData.m_out_vol[14] + ", "
|
+ " m16_out_vol=" + rtdata.m_acdcData.m_out_vol[15] + ", "
|
+ " is_acb1_over_currA=" + rtdata.m_acdcData.is_acb1_over_currA + ", "
|
+ " is_acb1_over_currB=" + rtdata.m_acdcData.is_acb1_over_currB + ", "
|
+ " is_acb1_over_currC=" + rtdata.m_acdcData.is_acb1_over_currC + ", "
|
+ " is_acIn1_poweron=" + rtdata.m_acdcData.is_acIn1_poweron + ", "
|
+ " is_acIn2_poweron=" + rtdata.m_acdcData.is_acIn2_poweron + ", "
|
+ " is_dcOut_over_curr=" + rtdata.m_acdcData.is_dcOut_over_curr + ", "
|
//+ " is_batt1_under_vol=" + rtdata.m_acdcData.is_batt1_under_vol + ", "
|
//+ " is_batt2_under_vol=" + rtdata.m_acdcData.is_batt2_under_vol + ", "
|
+ " is_battgroup1_state=" + rtdata.m_acdcData.is_battgroup1_state + ", "
|
+ " is_battgroup2_state=" + rtdata.m_acdcData.is_battgroup2_state + ", "
|
+ " is_battgroup2_down=" + rtdata.m_acdcData.is_battgroup2_down + ", "
|
+ " is_battgroup1_overChgCurr=" + rtdata.m_acdcData.is_battgroup1_overChgCurr + ", "
|
+ " is_battgroup2_overChgCurr=" + rtdata.m_acdcData.is_battgroup2_overChgCurr + ", "
|
+ " is_acdcMod1_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[0] + ", "
|
+ " is_acdcMod1_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[0] + ", "
|
+ " is_acdcMod1_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[0] + ", "
|
+ " is_acdcMod1_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[0] + ", "
|
+ " is_acdcMod1_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[0] + ", "
|
+ " is_acdcMod2_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[1] + ", "
|
+ " is_acdcMod2_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[1] + ", "
|
+ " is_acdcMod2_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[1] + ", "
|
+ " is_acdcMod2_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[1] + ", "
|
+ " is_acdcMod2_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[1] + ", "
|
+ " is_acdcMod3_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[2] + ", "
|
+ " is_acdcMod3_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[2] + ", "
|
+ " is_acdcMod3_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[2] + ","
|
+ " is_acdcMod3_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[2] + ", "
|
+ " is_acdcMod3_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[2] + ", "
|
+ " is_acdcMod4_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[3] + ", "
|
+ " is_acdcMod4_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[3] + ", "
|
+ " is_acdcMod4_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[3] + ", "
|
+ " is_acdcMod4_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[3] + ", "
|
+ " is_acdcMod4_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[3] + ", "
|
+ " is_acdcMod5_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[4] + ", "
|
+ " is_acdcMod5_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[4] + ", "
|
+ " is_acdcMod5_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[4] + ", "
|
+ " is_acdcMod5_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[4] + ", "
|
+ " is_acdcMod5_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[4] + ", "
|
+ " is_acdcMod6_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[5] + ", "
|
+ " is_acdcMod6_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[5] + ", "
|
+ " is_acdcMod6_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[5] + ", "
|
+ " is_acdcMod6_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[5] + ", "
|
+ " is_acdcMod6_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[5] + ", "
|
+ " is_acdcMod7_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[6] + ", "
|
+ " is_acdcMod7_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[6] + ", "
|
+ " is_acdcMod7_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[6] + ", "
|
+ " is_acdcMod7_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[6] + ", "
|
+ " is_acdcMod7_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[6] + ", "
|
+ " is_acdcMod8_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[7] + ", "
|
+ " is_acdcMod8_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[7] + ", "
|
+ " is_acdcMod8_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[7] + ", "
|
+ " is_acdcMod8_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[7] + ", "
|
+ " is_acdcMod8_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[7] + ", "
|
+ " is_acdcMod9_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[8] + ", "
|
+ " is_acdcMod9_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[8] + ", "
|
+ " is_acdcMod9_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[8] + ","
|
+ " is_acdcMod9_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[8] + ", "
|
+ " is_acdcMod9_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[8] + ", "
|
+ " is_acdcMod10_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[9] + ", "
|
+ " is_acdcMod10_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[9] + ", "
|
+ " is_acdcMod10_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[9] + ", "
|
+ " is_acdcMod10_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[9] + ", "
|
+ " is_acdcMod10_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[9] + ", "
|
+ " is_acdcMod11_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[10] + ", "
|
+ " is_acdcMod11_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[10] + ", "
|
+ " is_acdcMod11_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[10] + ", "
|
+ " is_acdcMod11_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[10] + ", "
|
+ " is_acdcMod11_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[10] + ", "
|
+ " is_acdcMod12_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[11] + ", "
|
+ " is_acdcMod12_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[11] + ", "
|
+ " is_acdcMod12_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[11] + ", "
|
+ " is_acdcMod12_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[11] + ", "
|
+ " is_acdcMod12_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[11] + ", "
|
+ " is_acdcMod13_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[12] + ", "
|
+ " is_acdcMod13_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[12] + ", "
|
+ " is_acdcMod13_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[12] + ", "
|
+ " is_acdcMod13_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[12] + ", "
|
+ " is_acdcMod13_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[12] + ", "
|
+ " is_acdcMod14_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[13] + ", "
|
+ " is_acdcMod14_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[13] + ", "
|
+ " is_acdcMod14_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[13] + ", "
|
+ " is_acdcMod14_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[13] + ", "
|
+ " is_acdcMod14_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[13] + ", "
|
+ " is_acdcMod15_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[14] + ", "
|
+ " is_acdcMod15_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[14] + ", "
|
+ " is_acdcMod15_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[14] + ", "
|
+ " is_acdcMod15_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[14] + ", "
|
+ " is_acdcMod15_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[14] + ", "
|
+ " is_acdcMod16_overVol=" + rtdata.m_acdcData.is_acdcMod_overVol[15] + ", "
|
+ " is_acdcMod16_underVol=" + rtdata.m_acdcData.is_acdcMod_underVol[15] + ", "
|
+ " is_acdcMod16_overCurr=" + rtdata.m_acdcData.is_acdcMod_overCurr[15] + ", "
|
+ " is_acdcMod16_acErr=" + rtdata.m_acdcData.is_acdcMod_acErr[15] + ", "
|
+ " is_acdcMod16_limitCurr=" + rtdata.m_acdcData.is_acdcMod_limitCurr[15] + ", "
|
+ " is_acIn1_fuse=" + rtdata.m_acdcData.is_acIn1_fuse + ", "
|
+ " is_acIn2_fuse=" + rtdata.m_acdcData.is_acIn2_fuse + ", "
|
+ " is_acIn1_unbanlance=" + rtdata.m_acdcData.is_acIn1_unbanlance + ", "
|
+ " is_acIn2_unbanlance=" + rtdata.m_acdcData.is_acIn2_unbanlance + ", "
|
+ " is_acIn1_freqerr=" + rtdata.m_acdcData.is_acIn1_freqerr + ", "
|
+ " is_acIn2_freqerr=" + rtdata.m_acdcData.is_acIn2_freqerr + ", "
|
+ " is_battgroup1_volLow=" + rtdata.m_acdcData.is_battgroup1_volLow + ", "
|
+ " is_battgroup2_volLow=" + rtdata.m_acdcData.is_battgroup2_volLow + ", "
|
+ " is_dcOut_total_alarm=" + rtdata.m_acdcData.is_dcOut_total_alarm + ", "
|
+ " is_acIn_total_alarm=" + rtdata.m_acdcData.is_acIn_total_alarm + ", "
|
//1++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
+ " is_acdcMod1_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[0] + ", "
|
+ " is_acdcMod2_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[1] + ", "
|
+ " is_acdcMod3_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[2] + ", "
|
+ " is_acdcMod4_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[3] + ", "
|
+ " is_acdcMod5_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[4] + ", "
|
+ " is_acdcMod6_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[5] + ", "
|
+ " is_acdcMod7_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[6] + ", "
|
+ " is_acdcMod8_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[7] + ", "
|
+ " is_acdcMod9_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[8] + ", "
|
+ " is_acdcMod10_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[9] + ", "
|
+ " is_acdcMod11_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[10] + ", "
|
+ " is_acdcMod12_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[11] + ", "
|
+ " is_acdcMod13_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[12] + ", "
|
+ " is_acdcMod14_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[13] + ", "
|
+ " is_acdcMod15_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[14] + ", "
|
+ " is_acdcMod16_junChg=" + rtdata.m_acdcData.is_acdcMod_junchg[15] + ", "
|
+ " is_powerdev_commErr=" + rtdata.m_acdcData.is_comm_err + ", "
|
+ " userAcIn1_volA=" + rtdata.m_EnvData.userAcIn1_volA + ", "
|
+ " userAcIn1_volB=" + rtdata.m_EnvData.userAcIn1_volB + ", "
|
+ " userAcIn1_volC=" + rtdata.m_EnvData.userAcIn1_volC + ", "
|
+ " userAcIn1_currA=" + rtdata.m_EnvData.userAcIn1_currA + ", "
|
+ " userAcIn1_currB=" + rtdata.m_EnvData.userAcIn1_currB + ", "
|
+ " userAcIn1_currC=" + rtdata.m_EnvData.userAcIn1_currC + ", "
|
+ " userAcIn1_freq=" + rtdata.m_EnvData.userAcIn1_freq + ", "
|
+ " userAcIn2_volA=" + rtdata.m_EnvData.userAcIn2_volA + ", "
|
+ " userAcIn2_volB=" + rtdata.m_EnvData.userAcIn2_volB + ", "
|
+ " userAcIn2_volC=" + rtdata.m_EnvData.userAcIn2_volC + ", "
|
+ " userAcIn2_currA=" + rtdata.m_EnvData.userAcIn2_currA + ", "
|
+ " userAcIn2_currB=" + rtdata.m_EnvData.userAcIn2_currB + ", "
|
+ " userAcIn2_currC=" + rtdata.m_EnvData.userAcIn2_currC + ", "
|
+ " userAcIn2_freq=" + rtdata.m_EnvData.userAcIn2_freq + ", "
|
+ " m_temper1=" + rtdata.m_EnvData.m_temper[0] + ", "
|
+ " m_temper2=" + rtdata.m_EnvData.m_temper[1] + ", "
|
+ " m_temper3=" + rtdata.m_EnvData.m_temper[2] + ", "
|
+ " m_humidity1=" + rtdata.m_EnvData.m_humidity[0] + ", "
|
+ " m_humidity2=" + rtdata.m_EnvData.m_humidity[1] + ", "
|
+ " m_humidity3=" + rtdata.m_EnvData.m_humidity[2] + ", "
|
+ " userAcIn1_PowerDown=" + rtdata.m_EnvData.userAcIn1_PowerDown + ", "
|
+ " userAcIn1_CommErr=" + rtdata.m_EnvData.userAcIn1_CommErr + ", "
|
+ " userAcIn2_PowerDown=" + rtdata.m_EnvData.userAcIn2_PowerDown + ", "
|
+ " userAcIn2_CommErr=" + rtdata.m_EnvData.userAcIn2_CommErr + ", "
|
|
//+ " is_TempH_Alarm1=" + rtdata.m_EnvData.is_TempH_Alarm[0] + ", "
|
//+ " is_TempL_Alarm1=" + rtdata.m_EnvData.is_TempL_Alarm[0] + ", "
|
+ " is_Temp_CommErr1=" + rtdata.m_EnvData.is_Temp_CommErr[0] + ", "
|
//+ " is_TempH_Alarm2=" + rtdata.m_EnvData.is_TempH_Alarm[1] + ", "
|
//+ " is_TempL_Alarm2=" + rtdata.m_EnvData.is_TempL_Alarm[1] + ", "
|
+ " is_Temp_CommErr2=" + rtdata.m_EnvData.is_Temp_CommErr[1] + ", "
|
//+ " is_TempH_Alarm3=" + rtdata.m_EnvData.is_TempH_Alarm[2] + ", "
|
//+ " is_TempL_Alarm3=" + rtdata.m_EnvData.is_TempL_Alarm[2] + ", "
|
+ " is_Temp_CommErr3=" + rtdata.m_EnvData.is_Temp_CommErr[2] + ", "
|
//+ " is_HumiH_Alarm1=" + rtdata.m_EnvData.is_HumiH_Alarm[0] + ", "
|
//+ " is_HumiL_Alarm1=" + rtdata.m_EnvData.is_HumiL_Alarm[0] + ", "
|
+ " is_Humi_CommErr1=" + rtdata.m_EnvData.is_Humi_CommErr[0] + ", "
|
//+ " is_HumiH_Alarm2=" + rtdata.m_EnvData.is_HumiH_Alarm[1] + ", "
|
//+ " is_HumiL_Alarm2=" + rtdata.m_EnvData.is_HumiL_Alarm[1] + ", "
|
+ " is_Humi_CommErr2=" + rtdata.m_EnvData.is_Humi_CommErr[1] + ", "
|
//+ " is_HumiH_Alarm3=" + rtdata.m_EnvData.is_HumiH_Alarm[2] + ", "
|
//+ " is_HumiL_Alarm3=" + rtdata.m_EnvData.is_HumiL_Alarm[2] + ", "
|
+ " is_Humi_CommErr3=" + rtdata.m_EnvData.is_Humi_CommErr[2] + ", "
|
+ " is_Smoke_Alarm1=" + rtdata.m_EnvData.is_Smoke_Alarm[0] + ", "
|
+ " is_Smoke_CommErr1=" + rtdata.m_EnvData.is_Smoke_CommErr[0] + ", "
|
+ " is_Smoke_Alarm2=" + rtdata.m_EnvData.is_Smoke_Alarm[1] + ", "
|
+ " is_Smoke_CommErr2=" + rtdata.m_EnvData.is_Smoke_CommErr[1] + ", "
|
+ " is_Smoke_Alarm3=" + rtdata.m_EnvData.is_Smoke_Alarm[2] + ", "
|
+ " is_Smoke_CommErr3=" + rtdata.m_EnvData.is_Smoke_CommErr[2] + ", "
|
|
+ " chargLimitCurr=" + rtdata.m_acdcData.chargLimitCurr + ", "
|
+ " junChargeVol=" + rtdata.m_acdcData.junChargeVol + ", "
|
+ " floatChargeVol=" + rtdata.m_acdcData.floatChargeVol + ", "
|
// + " acVolH_Limit=" + rtdata.m_acdcData.acVolH_Limit + ", "
|
// + " acVolL_Limit=" + rtdata.m_acdcData.acVolL_Limit + ", "
|
+ " acVolH_Limit=" + rtdata.m_acdcData.acVolH_Limit + ", "
|
+ " acVolL_Limit=" + rtdata.m_acdcData.acVolL_Limit + ", "
|
+ " dcOutVolH_Limit=" + rtdata.m_acdcData.dcOutVolH_Limit + ", "
|
+ " dcOutVolL_Limit=" + rtdata.m_acdcData.dcOutVolL_Limit + ", "
|
+ " acInUseCount=" + rtdata.m_acdcData.acInUseCount + " "
|
|
+ " WHERE PowerDeviceId=" + rtdata.PowerDevDeviceId + ";";
|
|
//logger.info(sql_str);
|
sql.sqlMysqlExecute(sql_str);
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
public static void updatePower_AC_Data_RT_Table(MysqlConnPool conn_pool, PowerData_RT rtdata) {
|
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
|
try
|
{
|
String sql_str = "UPDATE " + Sql_Mysql.PWRDEV_ACDATA_TABLE
|
+ " SET "
|
+ " record_datetime='" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "',"
|
+ " acIn1_volA=" + rtdata.m_acData.acIn1_volA + ","
|
+ " acIn1_volB=" + rtdata.m_acData.acIn1_volB + ","
|
+ " acIn1_volC=" + rtdata.m_acData.acIn1_volC + ","
|
+ " acIn1_currA=" + rtdata.m_acData.acIn1_currA + ","
|
+ " acIn1_currB=" + rtdata.m_acData.acIn1_currB + ","
|
+ " acIn1_currC=" + rtdata.m_acData.acIn1_currC + ","
|
+ " acIn2_volA=" + rtdata.m_acData.acIn2_volA + ","
|
+ " acIn2_volB=" + rtdata.m_acData.acIn2_volB + ","
|
+ " acIn2_volC=" + rtdata.m_acData.acIn2_volC + ","
|
+ " acIn2_currA=" + rtdata.m_acData.acIn2_currA + ","
|
+ " acIn2_currB=" + rtdata.m_acData.acIn2_currB + ","
|
+ " acIn2_currC=" + rtdata.m_acData.acIn2_currC + ","
|
+ " temprature=" + rtdata.m_acData.temprature + ","
|
+ " acVolH_Limit=" + rtdata.m_acData.acVolH_Limit + ","
|
+ " acVolL_Limit=" + rtdata.m_acData.acVolL_Limit + ","
|
|
+ " is_acIn1_powerdown=" + rtdata.m_acData.is_acIn1_powerdown + ","
|
+ " is_acIn2_powerdown=" + rtdata.m_acData.is_acIn2_powerdown + ","
|
+ " is_acIn1_thunder_err=" + rtdata.m_acData.is_acIn1_thunder_err + ","
|
+ " is_acIn2_thunder_err=" + rtdata.m_acData.is_acIn2_thunder_err + ","
|
+ " is_acIn1_trip=" + rtdata.m_acData.is_acIn1_trip + ","
|
+ " is_acIn2_trip=" + rtdata.m_acData.is_acIn2_trip + ","
|
+ " is_acIn1_over_volA=" + rtdata.m_acData.is_acIn1_over_volA + ","
|
+ " is_acIn1_under_volA=" + rtdata.m_acData.is_acIn1_under_volA + ","
|
+ " is_acIn1_less_A=" + rtdata.m_acData.is_acIn1_less_A + ","
|
+ " is_acIn1_over_volB=" + rtdata.m_acData.is_acIn1_over_volB + ","
|
+ " is_acIn1_under_volB=" + rtdata.m_acData.is_acIn1_under_volB + ","
|
+ " is_acIn1_less_B=" + rtdata.m_acData.is_acIn1_less_B + ","
|
+ " is_acIn1_over_volC=" + rtdata.m_acData.is_acIn1_over_volC + ","
|
+ " is_acIn1_under_volC=" + rtdata.m_acData.is_acIn1_under_volC + ","
|
+ " is_acIn1_less_C=" + rtdata.m_acData.is_acIn1_less_C + ","
|
+ " is_acIn2_over_volA=" + rtdata.m_acData.is_acIn2_over_volA + ", "
|
+ " is_acIn2_under_volA=" + rtdata.m_acData.is_acIn2_under_volA + ", "
|
+ " is_acIn2_less_A=" + rtdata.m_acData.is_acIn2_less_A + ", "
|
+ " is_acIn2_over_volB=" + rtdata.m_acData.is_acIn2_over_volB + ", "
|
+ " is_acIn2_under_volB=" + rtdata.m_acData.is_acIn2_under_volB + ", "
|
+ " is_acIn2_less_B=" + rtdata.m_acData.is_acIn2_less_B + ", "
|
+ " is_acIn2_over_volC=" + rtdata.m_acData.is_acIn2_over_volC + ", "
|
+ " is_acIn2_under_volC=" + rtdata.m_acData.is_acIn2_under_volC + ", "
|
+ " is_acIn2_less_C=" + rtdata.m_acData.is_acIn2_less_C + ", "
|
+ " is_acIn1_monitorerr=" + rtdata.m_acData.is_ac_monitor_err + ", "
|
+ " is_acIn1_fuse=" + rtdata.m_acData.is_acIn1_fuse + ", "
|
+ " is_acIn2_fuse=" + rtdata.m_acData.is_acIn2_fuse + ", ";
|
|
String acstr;
|
for(int i=0;i<PowerDev_acData.AC_SW_COUNT_AT_FSW;i++)
|
{
|
acstr = " is_fsw1_sw"+(i+1)+"_trip=" + rtdata.m_acData.is_fsw1_Trip_SW[i] + ", ";
|
sql_str += acstr;
|
}
|
for(int i=0;i<PowerDev_acData.AC_SW_COUNT_AT_FSW;i++)
|
{
|
acstr = " is_fsw2_sw"+(i+1)+"_trip=" + rtdata.m_acData.is_fsw2_Trip_SW[i] + ", ";
|
sql_str += acstr;
|
}
|
|
sql_str += " is_total_alarm=" + rtdata.m_acData.is_total_alarm + ", "
|
+ " is_ac_tempAlarm=" + rtdata.m_acData.is_ac_tempAlarm + " "
|
|
+ " WHERE PowerDeviceId=" + rtdata.PowerDevDeviceId + ";";
|
|
//logger.info(sql_str);
|
sql.sqlMysqlExecute(sql_str);
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
public static void updatePower_DC_Data_RT_Table(MysqlConnPool conn_pool, PowerData_RT rtdata) {
|
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
|
try
|
{
|
String sql_str = "UPDATE " + Sql_Mysql.PWRDEV_DCDATA_TABLE
|
+ " SET "
|
+ " record_datetime='" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "',"
|
+ " dcIn1_vol=" + rtdata.m_dcData.dcIn1_vol + ","
|
+ " dcIn2_vol=" + rtdata.m_dcData.dcIn2_vol + ","
|
+ " dcOut1_vol=" + rtdata.m_dcData.dcOut1_vol + ","
|
+ " dcOut1_curr=" + rtdata.m_dcData.dcOut1_curr + ","
|
+ " dcOut2_vol=" + rtdata.m_dcData.dcOut2_vol + ","
|
+ " dcOut2_curr=" + rtdata.m_dcData.dcOut2_curr + ","
|
+ " temprature=" + rtdata.m_dcData.temprature + ","
|
+ " dcVolH_Limit=" + rtdata.m_dcData.dcVolH_Limit + ","
|
+ " dcVolL_Limit=" + rtdata.m_dcData.dcVolL_Limit + ","
|
|
+ " is_dc1_over_vol=" + rtdata.m_dcData.is_dc1_over_vol + ","
|
+ " is_dc1_under_vol=" + rtdata.m_dcData.is_dc1_under_vol + ","
|
+ " is_dc2_over_vol=" + rtdata.m_dcData.is_dc2_over_vol + ","
|
+ " is_dc2_under_vol=" + rtdata.m_dcData.is_dc2_under_vol + ","
|
+ " is_in1_swtrip=" + rtdata.m_dcData.is_in1_swtrip + ","
|
+ " is_in2_swtrip=" + rtdata.m_dcData.is_in2_swtrip + ",";
|
|
String acstr;
|
for(int i=0;i<PowerDev_dcData.DC_SW_COUNT_AT_FSW;i++)
|
{
|
acstr = " is_fsw1_sw"+(i+1)+"_trip=" + rtdata.m_dcData.is_fsw1_Trip_SW[i] + ", ";
|
sql_str += acstr;
|
}
|
for(int i=0;i<PowerDev_dcData.DC_SW_COUNT_AT_FSW;i++)
|
{
|
acstr = " is_fsw2_sw"+(i+1)+"_trip=" + rtdata.m_dcData.is_fsw2_Trip_SW[i] + ", ";
|
sql_str += acstr;
|
}
|
|
sql_str += " is_tempalarm=" + rtdata.m_dcData.is_tempalarm + ", "
|
+ " is_dc_monitorerr=" + rtdata.m_dcData.is_dc_monitorerr + ", "
|
+ " is_total_alarm=" + rtdata.m_dcData.is_total_alarm + " "
|
|
+ " WHERE PowerDeviceId=" + rtdata.PowerDevDeviceId + ";";
|
|
//logger.info(sql_str);
|
sql.sqlMysqlExecute(sql_str);
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
public static void updatePower_INFO_RT_Table(MysqlConnPool conn_pool, PowerData_RT rtdata) {
|
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
|
try
|
{
|
String sql_str = "UPDATE " + Sql_Mysql.PWRDEV_RT_INFO_TABLE
|
+ " SET "
|
+ " record_datetime='" + Com.getDateTimeFormat(rtdata.commRecordTime, Com.DTF_YMDhms) + "'," //new Date(), Com.DTF_YMDhms) + "',"
|
+ " CommTxCount=" + rtdata.CommTxCount + ","
|
+ " CommSuccessCount=" + rtdata.CommSuccessCount + " "
|
+ " WHERE PowerDeviceId=" + rtdata.PowerDevDeviceId + ";";
|
|
//logger.info(sql_str);
|
sql.sqlMysqlExecute(sql_str);
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
public static void make_TimeOutTag(MysqlConnPool conn_pool, int powdevid,int alarmtypeid,int alarmindex,int timeout,Date readdt) {
|
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
|
try
|
{
|
String sql_str_select = " SELECT PowerDeviceId,alarm_typeId,alarm_index"
|
+ " FROM " + Sql_Mysql.PWRDEV_ALARM_TIMEOUT_TABLE
|
+ " WHERE PowerDeviceId = " + powdevid
|
+ " AND alarm_typeId = " + alarmtypeid
|
+ " AND alarm_index = " + alarmindex
|
+ ";";
|
|
String sql_str_insert = "INSERT INTO " + Sql_Mysql.PWRDEV_ALARM_TIMEOUT_TABLE + " "
|
+ " (PowerDeviceId,alarm_typeId,alarm_index,timeout_tag,read_datetime,system_datetime,resume_datetime)"
|
+ " VALUES ("
|
+ powdevid + ","
|
+ alarmtypeid + ","
|
+ alarmindex + ","
|
+ timeout + ","
|
+ "'" + Com.getDateTimeFormat(readdt, Com.DTF_YMDhms) + "'" + ","
|
+ "'" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "'" + ","
|
+ "'" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "'" + " "
|
+ ");";
|
|
|
String sql_str_update = "UPDATE " + Sql_Mysql.PWRDEV_ALARM_TIMEOUT_TABLE
|
+ " SET "
|
+ " timeout_tag=" + timeout + ","
|
+ " resume_datetime=" + "'" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "'" + " "
|
+ " WHERE PowerDeviceId = " + powdevid
|
+ " AND alarm_typeId = " + alarmtypeid
|
+ " AND alarm_index = " + alarmindex
|
+ ";";
|
|
//logger.info(sql_str_select);
|
|
/*
|
ResultSet rs = sql.sqlMysqlQuery(sql_str_select);
|
|
if(rs.next()) {
|
sql.sqlMysqlExecute(sql_str_update);
|
}
|
else {
|
sql.sqlMysqlExecute(sql_str_insert);
|
}
|
|
rs.close();
|
*/
|
|
if(timeout == 0) {
|
ResultSet rs = sql.sqlMysqlQuery(sql_str_select);
|
|
while(rs.next()) {
|
//sql.sqlMysqlExecute(sql_str_update);
|
|
sql.sqlMysqlExecute(sql_str_update);
|
}
|
|
rs.close();
|
}
|
else {
|
sql.sqlMysqlExecute(sql_str_insert);
|
}
|
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
}
|
|
//¸üÐÂÏ̼߳à¿ØµÄÆô¶¯Ê±¼ä
|
public static void updateThread_StartTime(MysqlConnPool conn_pool,double versionnum){
|
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
|
String version = String.format("V%1.3f", versionnum);
|
|
try {
|
sql.sqlMysqlUseDB(Sql_Mysql.WEB_Site);
|
String sql_str = "UPDATE tb_process_survey "
|
+ "SET Process_starttime = '"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"'"
|
+ ",ProcessVersion = 'NARI_"+version+"'"
|
+ " WHERE ProcessId=11016";
|
//System.out.println(sql_str);
|
sql.sqlMysqlExecute(sql_str);
|
} catch (SQLException e) {
|
logger.error(e.toString(), e);
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
//¸üÐÂÏ̵߳Äʱ¼ä´Á
|
public static void updateThread_Time(MysqlConnPool conn_pool){
|
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
|
try {
|
sql.sqlMysqlUseDB(Sql_Mysql.WEB_Site);
|
String sql_str = "UPDATE tb_process_survey SET ProcessTime = '"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)
|
+ "' WHERE ProcessId=11016";
|
//System.out.println(sql_str);
|
sql.sqlMysqlExecute(sql_str);
|
} catch (SQLException e) {
|
logger.error(e.toString(), e);
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
public static int getVersionFromTable(MysqlConnPool conn_pool, String ip) {
|
|
String sqlstr = "SELECT dev_version FROM db_ram_db.tb_fbs9100_state "
|
+ "WHERE dev_ip='"+ip+"' AND dev_id BETWEEN 618500000 AND 618509999;";
|
|
//logger.info(sqlstr);
|
|
Sql_Mysql sql = null;
|
|
String verStr = null;
|
|
int ver = 0;
|
|
try {
|
sql = new Sql_Mysql(conn_pool.getConn());
|
|
ResultSet rs_t = sql.sqlMysqlQuery(sqlstr);
|
|
if(rs_t.next()) {
|
verStr = rs_t.getString("dev_version");
|
|
//logger.info(verStr);
|
|
char fch = verStr.charAt(0);
|
|
if(fch == 'V') {
|
//logger.info("first char is V");
|
|
String substr = verStr.substring(1,6);
|
|
//logger.info(substr);
|
|
float fv = Float.parseFloat(substr);
|
|
ver = (int)(fv*1000);
|
}
|
}
|
}catch (Exception e) {
|
logger.error(e.toString(), e);
|
} finally {
|
try {
|
sql.close_con();
|
} catch (Exception e){
|
logger.error(e.toString(), e);
|
}
|
}
|
|
return ver;
|
}
|
|
}
|
