package com.power.data;
|
|
import java.sql.Connection;
|
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.main.main_PowerDev_IEC61850;
|
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_ACDC_Data_RT_Table(MysqlConnPool conn_pool, int dev_id) {
|
|
String sqlstr = "SELECT 1 FROM " + Sql_Mysql.PWRDEV_ACDCDATA_TABLE
|
+ " WHERE PowerDeviceId="+dev_id + " limit 1;";
|
|
String sqlstr1 = "INSERT INTO " + Sql_Mysql.PWRDEV_ACDCDATA_TABLE + " "
|
+ " (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 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.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){
|
|
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 = 'GW_"+version+"'"
|
+ " WHERE ProcessId=11015";
|
//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=11015";
|
//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;
|
}
|
|
/**
|
* ²åÈëÉ豸Çл»ÐÅÏ¢
|
* @param conn_pool
|
* @param ip
|
*/
|
public static void insertPWRDEV_EVENT_TABLE(MysqlConnPool conn_pool, PowerDev_Event event) {
|
String sql_str = "INSERT INTO " + Sql_Mysql.PWRDEV_EVENT_TABLE +
|
"(power_device_id,record_time,now_state,last_state,event_type,event_txt) VALUES("
|
+ "" + event.power_device_id + ","
|
+ "'" + Com.getDateTimeFormat(event.record_time, Com.DTF_YMDhms) + "',"
|
+ "" + event.now_state + ","
|
+ "" + event.last_state + ","
|
+ "" + event.event_type + ","
|
+ "'" + event.event_txt + "'"
|
+ ")";
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
try {
|
sql.sqlMysqlExecute(sql_str);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ²éѯͨÐŶϿªÇ°µÄ·ÖºÏբ״̬
|
* @param conn_pool
|
* @param acdcdata
|
*/
|
public static void queryPWRDEV_ACDCDATA_TABLE(MysqlConnPool conn_pool, PowerDev_acdcData acdcdata,int PowerDeviceId) {
|
String sql_str = " SELECT * FROM " + Sql_Mysql.PWRDEV_ACDCDATA_TABLE +
|
" WHERE PowerDeviceId = " + PowerDeviceId;
|
ResultSet res = null;
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
res = sql.sqlMysqlQuery(sql_str);
|
try {
|
if(res.next()) {
|
acdcdata.acIn1_switch_st = res.getInt("acIn1_switch_st");
|
acdcdata.acIn2_switch_st = res.getInt("acIn2_switch_st");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ²éѯͨÐŶϿªÇ°µÄ·ÖºÏբ״̬
|
* @param conn_pool
|
* @param acdcdata
|
*/
|
public static void queryPWRDEV_ACDCDATA_TABLEHistory(MysqlConnPool conn_pool, PowerDev_acdcData acdcdata,int PowerDeviceId) {
|
String sql_str1 = " SELECT * FROM " + Sql_Mysql.PWRDEV_EVENT_TABLE +
|
" WHERE power_device_id = " + + PowerDeviceId + " AND event_type = " +PowerDev_Event.EVENT_TYPE_ACIN1_SWITCH_ST +
|
" ORDER BY record_time DESC " +
|
" LIMIT 1";
|
|
String sql_str2 = " SELECT * FROM " + Sql_Mysql.PWRDEV_EVENT_TABLE +
|
" WHERE power_device_id = " + + PowerDeviceId + " AND event_type = " +PowerDev_Event.EVENT_TYPE_ACIN2_SWITCH_ST +
|
" ORDER BY record_time DESC " +
|
" LIMIT 1";
|
ResultSet res = null;
|
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
|
try {
|
res = sql.sqlMysqlQuery(sql_str1);
|
if(res.next()) {
|
acdcdata.acIn1_switch_st = res.getInt("now_state");
|
//System.out.println("acIn1_switch_st:"+acdcdata.acIn1_switch_st);
|
}
|
res = null;
|
res = sql.sqlMysqlQuery(sql_str2);
|
if(res.next()) {
|
acdcdata.acIn2_switch_st = res.getInt("now_state");
|
//System.out.println("acIn2_switch_st:"+acdcdata.acIn2_switch_st);
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
|
/**
|
* ´´½¨ tb_pwrdev_acdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Acdata_Table(Connection conn, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Acdata_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Acdata_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `acIn1_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volC` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currA` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currC` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volC` float NOT NULL DEFAULT '0'," +
|
" `acIn2_currA` float NOT NULL DEFAULT '0'," +
|
" `acIn2_currB` float NOT NULL DEFAULT '0'," +
|
" `acIn2_currC` float NOT NULL DEFAULT '0'," +
|
" `temprature` float NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_monitorerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(conn);
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
|
|
//Ìí¼ÓacIn2_currA×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='acIn2_currA'");
|
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `acIn2_currA` float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼ÓacIn2_currB×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='acIn2_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `acIn2_currB` float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼ÓacIn2_currC×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='acIn2_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `acIn2_currC` float NOT NULL DEFAULT '0';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
//³õʼ»¯¹«ÓÃÒ»¸öÊý¾Ý¿âÁ¬½Ó
|
//sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_dcdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Dcdata_Table(Connection conn, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Dcdata_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Dcdata_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `dcIn1_vol` float NOT NULL DEFAULT '0'," +
|
" `dcIn2_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut1_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut1_curr` float NOT NULL DEFAULT '0'," +
|
" `dcOut2_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut2_curr` float NOT NULL DEFAULT '0'," +
|
" `temprature` float NOT NULL DEFAULT '0'," +
|
" `is_dc1_over_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc1_under_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc2_over_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc2_under_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc_monitorerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_tempalarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(conn);
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
//³õʼ»¯¹«ÓÃÒ»¸öÊý¾Ý¿âÁ¬½Ó
|
sql.close_con();
|
}
|
}
|
|
|
/**
|
* ´´½¨ tb_pwrdev_acdcdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Acdcdata_Table(Connection conn, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Acdcdata_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Acdcdata_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `acIn1_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volC` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volC` float NOT NULL DEFAULT '0'," +
|
" `acOut_volA` float NOT NULL DEFAULT '0'," +
|
" `acOut_volB` float NOT NULL DEFAULT '0'," +
|
" `acOut_volC` float NOT NULL DEFAULT '0'," +
|
" `acOut_currA` float NOT NULL DEFAULT '0'," +
|
" `acOut_currB` float NOT NULL DEFAULT '0'," +
|
" `acOut_currC` float NOT NULL DEFAULT '0'," +
|
" `dcOut_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut_curr` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_vol` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_curr` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_vol` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_curr` float NOT NULL DEFAULT '0'," +
|
" `temprature` float NOT NULL DEFAULT '0'," +
|
" `m_outputvol` float NOT NULL DEFAULT '0'," +
|
" `m1_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m2_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m3_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m4_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m5_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m6_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m7_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m8_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m9_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m10_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m11_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m12_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m13_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m14_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m15_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m16_outCurr` float NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn_monitorerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_over_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_under_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup_down` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_jun_charge` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_off` float NOT NULL DEFAULT '0'," +
|
" `is_acIn1_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_loader_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup1_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `acIn1_currA` float NOT NULL DEFAULT '0'," + //2021-5-6 µçÔ´ÐÅÏ¢ÐÂÔö×Ö¶Î
|
" `acIn1_currB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currC` float NOT NULL DEFAULT '0'," +
|
" `loader_curr` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_ah` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_temp` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_ah` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_temp` float NOT NULL DEFAULT '0'," +
|
" `acdcm_temp` float NOT NULL DEFAULT '0'," +
|
" `m1_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m2_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m3_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m4_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m5_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m6_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m7_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m8_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m9_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m10_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m11_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m12_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m13_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m14_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m15_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m16_out_vol` float NOT NULL DEFAULT '0'," +
|
" `is_acb1_over_currA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acb1_over_currB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acb1_over_currC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_poweron` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_poweron` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_over_curr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup1_state` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_state` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_down` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup1_overChgCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_overChgCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_unbanlance` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_unbanlance` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_freqerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_freqerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup1_volLow` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_volLow` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_powerdev_commErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `userAcIn1_volA` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_volB` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_volC` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_currA` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_currB` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_currC` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_freq` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_volA` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_volB` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_volC` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_currA` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_currB` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_currC` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_freq` float NOT NULL DEFAULT '0'," +
|
" `m_temper1` float NOT NULL DEFAULT '0'," +
|
" `m_temper2` float NOT NULL DEFAULT '0'," +
|
" `m_temper3` float NOT NULL DEFAULT '0'," +
|
" `m_humidity1` float NOT NULL DEFAULT '0'," +
|
" `m_humidity2` float NOT NULL DEFAULT '0'," +
|
" `m_humidity3` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_PowerDown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `userAcIn1_CommErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `userAcIn2_PowerDown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `userAcIn2_CommErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Temp_CommErr1` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Temp_CommErr2` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Temp_CommErr3` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Humi_CommErr1` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Humi_CommErr2` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Humi_CommErr3` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_Alarm1` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_CommErr1` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_Alarm2` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_CommErr2` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_Alarm3` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_CommErr3` tinyint(1) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(conn);
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
//Ìí¼ÓacIn1_currA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn1_currA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn1_currA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷AÏàÊäÈëµçÁ÷';");
|
}
|
|
//Ìí¼ÓacIn1_currB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn1_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn1_currB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷BÏàÊäÈëµçÁ÷';");
|
}
|
|
//Ìí¼ÓacIn1_currC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn1_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn1_currC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷CÏàÊäÈëµçÁ÷';");
|
}
|
|
//Ìí¼Óloader_curr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='loader_curr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `loader_curr` float NOT NULL DEFAULT '0' COMMENT '¸ºÔصçÁ÷';");
|
}
|
|
//Ìí¼Óbattgroup1_ah
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='battgroup1_ah'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `battgroup1_ah` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é1ÈÝÁ¿';");
|
}
|
|
//Ìí¼Óbattgroup1_temp
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='battgroup1_temp'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `battgroup1_temp` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é1ζÈ';");
|
}
|
|
//Ìí¼Óbattgroup2_ah
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='battgroup2_ah'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `battgroup2_ah` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2ÈÝÁ¿';");
|
}
|
|
//Ìí¼Óbattgroup2_temp
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='battgroup2_temp'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `battgroup2_temp` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2ζÈ';");
|
}
|
|
//Ìí¼Óacdcm_temp
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acdcm_temp'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acdcm_temp` float NOT NULL DEFAULT '0' COMMENT '¿ª¹Ø¹ñζÈ';");
|
}
|
|
//Ìí¼Óm1_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m1_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m1_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1Êä³öµçѹ';");
|
}
|
|
//Ìí¼Óm2_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m2_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m2_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2Êä³öµçѹ';");
|
}
|
|
//Ìí¼Óm3_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m3_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m3_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3Êä³öµçѹ';");
|
}
|
|
//Ìí¼Óm4_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m4_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m4_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4Êä³öµçѹ';");
|
}
|
//Ìí¼Óm5_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m5_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m5_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5Êä³öµçѹ';");
|
}
|
//Ìí¼Óm6_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m6_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m6_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6Êä³öµçѹ';");
|
}
|
//Ìí¼Óm7_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m7_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m7_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7Êä³öµçѹ';");
|
}
|
//Ìí¼Óm8_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m8_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m8_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8Êä³öµçѹ';");
|
}
|
//Ìí¼Óm9_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m9_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m9_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9Êä³öµçѹ';");
|
}
|
//Ìí¼Óm10_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m10_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m10_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10Êä³öµçѹ';");
|
}
|
//Ìí¼Óm11_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m11_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m11_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11Êä³öµçѹ';");
|
}
|
//Ìí¼Óm12_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m12_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m12_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12Êä³öµçѹ';");
|
}
|
//Ìí¼Óm13_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m13_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m13_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13Êä³öµçѹ';");
|
}
|
//Ìí¼Óm14_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m14_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m14_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14Êä³öµçѹ';");
|
}
|
//Ìí¼Óm15_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m15_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m15_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15Êä³öµçѹ';");
|
}
|
//Ìí¼Óm16_out_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m16_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m16_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16Êä³öµçѹ';");
|
}
|
|
//Ìí¼Óis_acb1_over_currA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acb1_over_currA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acb1_over_currA` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷AÏà¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acb1_over_currB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acb1_over_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acb1_over_currB` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷BÏà¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acb1_over_currC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acb1_over_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acb1_over_currC` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷CÏà¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acIn1_poweron
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn1_poweron'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn1_poweron` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷1·Óеç';");
|
}
|
|
|
//Ìí¼Óis_acIn2_poweron
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn2_poweron'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn2_poweron` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷2·Óеç';");
|
}
|
|
|
//Ìí¼Óis_dcOut_over_curr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_dcOut_over_curr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_dcOut_over_curr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_battgroup1_state
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup1_state'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup1_state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø1³ä·Å״̬';");
|
}
|
|
//Ìí¼Óis_battgroup2_state
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup2_state'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup2_state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø2³ä·Å״̬';");
|
}
|
|
//Ìí¼Óis_battgroup2_down
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup2_down'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup2_down` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2ϵç';");
|
}
|
|
//Ìí¼Óis_battgroup1_overChgCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup1_overChgCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup1_overChgCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é1³äµç¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_battgroup2_overChgCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup2_overChgCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup2_overChgCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2³äµç¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod1_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod1_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1Ƿѹ';");
|
}
|
//Ìí¼Óis_acdcMod1_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod1_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod1_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod2_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod2_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod2_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod2_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod2_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod3_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod3_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod3_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod3_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod3_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod4_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod4_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod4_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod4_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod4_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod5_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod5_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod5_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod5_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod5_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod6_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod6_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod6_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod6_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod6_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod7_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod7_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod7_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod7_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod7_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod8_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod8_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod8_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod8_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod8_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod9_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod9_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod9_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod9_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod9_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod10_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod10_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod10_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod10_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod10_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod11_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod11_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod11_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod11_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod11_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod12_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod12_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod12_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod12_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod12_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod13_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod13_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod13_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod13_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod13_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod14_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod14_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod14_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod14_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod14_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod15_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod15_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod15_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod15_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod15_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod16_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod16_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod16_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod16_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod16_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acIn1_fuse
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn1_fuse'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn1_fuse` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1ÈÛË¿¸æ¾¯';");
|
}
|
|
|
//Ìí¼Óis_acIn2_fuse
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn2_fuse'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn2_fuse` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2ÈÛË¿¸æ¾¯';");
|
}
|
|
//Ìí¼Óis_acIn1_unbanlance
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn1_unbanlance'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn1_unbanlance` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1ÈýÏ಻ƽºâ';");
|
}
|
|
//Ìí¼Óis_acIn2_unbanlance
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn2_unbanlance'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn2_unbanlance` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2ÈýÏ಻ƽºâ';");
|
}
|
|
//Ìí¼Óis_acIn1_freqerr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn1_freqerr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn1_freqerr` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1ƵÂÊÒì³£';");
|
}
|
|
//Ìí¼Óis_acIn2_freqerr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn2_freqerr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn2_freqerr` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2ƵÂÊÒì³£';");
|
}
|
|
//Ìí¼Óis_battgroup1_volLow
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup1_volLow'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup1_volLow` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é1µçѹµÍ';");
|
}
|
|
//Ìí¼Óis_battgroup2_volLow
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup2_volLow'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup2_volLow` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2µçѹµÍ';");
|
}
|
|
//Ìí¼Óis_dcOut_total_alarm
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_dcOut_total_alarm'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_dcOut_total_alarm` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷×ܹÊÕÏ';");
|
}
|
|
//Ìí¼Óis_acIn_total_alarm
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn_total_alarm'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn_total_alarm` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷×ܹÊÕÏ';");
|
}
|
|
//Ìí¼Óis_acdcMod1_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod2_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod3_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod4_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod5_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod6_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod7_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod8_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod9_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod10_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod11_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod12_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod13_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod14_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod15_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod16_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16¾ù³ä';");
|
}
|
|
//Ìí¼Óis_powerdev_commErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_powerdev_commErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_powerdev_commErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µçԴͨÐŹÊÕÏ';");
|
}
|
|
//Ìí¼ÓuserAcIn1_volA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_volA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_volA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1AÏàµçѹ';");
|
}
|
|
//Ìí¼ÓuserAcIn1_volB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_volB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_volB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1BÏàµçѹ';");
|
}
|
|
//Ìí¼ÓuserAcIn1_volC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_volC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_volC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1CÏàµçѹ';");
|
}
|
|
//Ìí¼ÓuserAcIn1_currA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_currA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_currA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1AÏàµçÁ÷';");
|
}
|
|
//Ìí¼ÓuserAcIn1_currB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_currB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1BÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn1_currC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_currC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1CÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn1_freq
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_freq'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_freq` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1ƵÂÊ';");
|
}
|
//Ìí¼ÓuserAcIn2_volA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_volA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_volA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2AÏàµçѹ';");
|
}
|
//Ìí¼ÓuserAcIn2_volB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_volB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_volB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2BÏàµçѹ';");
|
}
|
//Ìí¼ÓuserAcIn2_volC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_volC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_volC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2CÏàµçѹ';");
|
}
|
//Ìí¼ÓuserAcIn2_currA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_currA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_currA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2AÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn2_currB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_currB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2BÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn2_currC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_currC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2CÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn2_freq
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_freq'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_freq` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2ƵÂÊ';");
|
}
|
//Ìí¼Óm_temper1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_temper1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_temper1` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È1';");
|
}
|
//Ìí¼Óm_temper2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_temper2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_temper2` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È2';");
|
}
|
//Ìí¼Óm_temper3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_temper3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_temper3` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È3';");
|
}
|
//Ìí¼Óm_humidity1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_humidity1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_humidity1` float NOT NULL DEFAULT '0' COMMENT '»·¾³Êª¶È1';");
|
}
|
//Ìí¼Óm_humidity2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_humidity2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_humidity2` float NOT NULL DEFAULT '0' COMMENT '»·¾³Êª¶È2';");
|
}
|
//Ìí¼Óm_humidity3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_humidity3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_humidity3` float NOT NULL DEFAULT '0' COMMENT '»·¾³Êª¶È3';");
|
}
|
//Ìí¼ÓuserAcIn1_PowerDown
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_PowerDown'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_PowerDown` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1Í£µç';");
|
}
|
//Ìí¼ÓuserAcIn1_CommErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_CommErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_CommErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷1²É¼¯Í¨ÐŹÊÕÏ';");
|
}
|
//Ìí¼ÓuserAcIn2_PowerDown
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_PowerDown'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_PowerDown` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2Í£µç';");
|
}
|
//Ìí¼ÓuserAcIn2_CommErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_CommErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_CommErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷2²É¼¯Í¨ÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Temp_CommErr1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Temp_CommErr1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Temp_CommErr1` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'θÐ1ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Temp_CommErr2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Temp_CommErr2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Temp_CommErr2` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'θÐ2ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Temp_CommErr3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Temp_CommErr3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Temp_CommErr3` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'θÐ3ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Humi_CommErr1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Humi_CommErr1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Humi_CommErr1` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ʪ¸Ð1ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Humi_CommErr2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Humi_CommErr2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Humi_CommErr2` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ʪ¸Ð2ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Humi_CommErr3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Humi_CommErr3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Humi_CommErr3` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ʪ¸Ð3ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Smoke_Alarm1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_Alarm1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_Alarm1` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð1±¨¾¯';");
|
}
|
//Ìí¼Óis_Smoke_CommErr1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_CommErr1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_CommErr1` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð1ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Smoke_Alarm2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_Alarm2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_Alarm2` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð1ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Smoke_CommErr2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_CommErr2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_CommErr2` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð2ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Smoke_Alarm3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_Alarm3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_Alarm3` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð3±¨¾¯';");
|
}
|
//Ìí¼Óis_Smoke_CommErr3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_CommErr3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_CommErr3` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð3ͨÐŹÊÕÏ';");
|
}
|
|
|
//Ìí¼ÓacIn2_currA×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn2_currA'");
|
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn2_currA` float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼ÓacIn2_currB×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn2_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn2_currB` float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼ÓacIn2_currC×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn2_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn2_currC` float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼ÓacIn1_switch_st×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn1_switch_st'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn1_switch_st` int(11) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1·ÖºÏբ״̬:0---δ֪(ÓÃÓÚ¼æÈÝÒÔÇ°µÄ)£¬1-·ÖÕ¢£¬2-ºÏÕ¢£¬3-ÍÑ¿Û';");
|
}
|
|
//Ìí¼ÓacIn2_switch_st×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn2_switch_st'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn2_switch_st` int(11) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2·ÖºÏբ״̬ :0---δ֪(ÓÃÓÚ¼æÈÝÒÔÇ°µÄ)£¬1-·ÖÕ¢£¬2-ºÏÕ¢£¬3-ÍÑ¿Û';");
|
}
|
|
|
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
//³õʼ»¯¹«ÓÃÒ»¸öÊý¾Ý¿âÁ¬½Ó
|
//sql.close_con();
|
}
|
}
|
|
}
|
