| | |
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | /***
|
|---|
| | | * 清空数据
|
|---|
| | | * @param conn_pool
|
|---|
| | | * @param rtdata
|
|---|
| | | */
|
|---|
| | | public static void clearPower_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=NOW(),"
|
|---|
| | | //+ " 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.temprature + ","
|
|---|
| | | + " 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 + ", "
|
|---|
| | | |
|---|
| | | /**
|
|---|
| | | * 2022-08-05 lijun 新增交流输入状态
|
|---|
| | | */
|
|---|
| | | + " acIn1_switch_st=" + rtdata.m_acdcData.acIn1_switch_st + ", "
|
|---|
| | | + " acIn2_switch_st=" + rtdata.m_acdcData.acIn2_switch_st + ", "
|
|---|
| | | |
|---|
| | | + " 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] + " "
|
|---|
| | | |
|---|
| | | + " 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 updateThread_StartTime(MysqlConnPool conn_pool,double versionnum){
|
|---|
| | |
|
|---|
