2.重庆电源历史实时表中添加负载电流字段记录-2024-11-05

DELL

2024-11-05 49f3732824c18cba23fee6aba7aebabbc4173b6d

2.重庆电源历史实时表中添加负载电流字段记录-2024-11-05

 IEC61850_ForPowerSupply/src/com/power/datasave/PowerDataSave_SQL.java

@@ -84,6 +84,7 @@
                "  `useracin2_curra` float NOT NULL DEFAULT '0' COMMENT '采集2路交流输入A相电流'," + 

                "  `useracin2_currb` float NOT NULL DEFAULT '0' COMMENT '采集2路交流输入B相电流'," + 

                "  `useracin2_currc` float NOT NULL DEFAULT '0' COMMENT '采集2路交流输入C相电流'," + 

                "  `load_curr` float NOT NULL DEFAULT '0' COMMENT '负载电流'," + 
                "  PRIMARY KEY (`num`)," + 

                "  KEY `index_powerdeviceid` (`powerdeviceid`) USING BTREE," + 

                "  KEY `index_record_time` (`record_time`) USING BTREE" + 

@@ -146,7 +147,7 @@
                    

        String sql_str = " INSERT INTO " + Sql_Mysql.Pwrdev_Historydata_GW_Table + rtdata.PowerDevDeviceId + "_" + Com.getDateTimeFormat(time, Com.DTF_YM) + " ";

        

        String sql_str_target = " (powerdeviceid,record_time,acin1_vola,acin1_volb,acin1_volc,acin2_vola,acin2_volb,acin2_volc,acin1_curra,acin1_currb,acin1_currc,acin2_curra,acin2_currb,acin2_currc,dcout_vol,dcout_curr,battgroup1_vol,battgroup1_curr,battgroup2_vol,battgroup2_curr,m1_out_vol,m2_out_vol,m3_out_vol,m4_out_vol,m5_out_vol,m6_out_vol,m7_out_vol,m8_out_vol,m9_out_vol,m10_out_vol,m11_out_vol,m12_out_vol,m13_out_vol,m14_out_vol,m15_out_vol,m16_out_vol,m1_outcurr,m2_outcurr,m3_outcurr,m4_outcurr,m5_outcurr,m6_outcurr,m7_outcurr,m8_outcurr,m9_outcurr,m10_outcurr,m11_outcurr,m12_outcurr,m13_outcurr,m14_outcurr,m15_outcurr,m16_outcurr,m_temper1,m_temper2,m_humidity1,m_humidity2,useracin1_vola,useracin1_volb,useracin1_volc,useracin1_curra,useracin1_currb,useracin1_currc,useracin2_vola,useracin2_volb,useracin2_volc,useracin2_curra,useracin2_currb,useracin2_currc)  VALUES " ;

        String sql_str_target = " (powerdeviceid,record_time,acin1_vola,acin1_volb,acin1_volc,acin2_vola,acin2_volb,acin2_volc,acin1_curra,acin1_currb,acin1_currc,acin2_curra,acin2_currb,acin2_currc,dcout_vol,dcout_curr,battgroup1_vol,battgroup1_curr,battgroup2_vol,battgroup2_curr,m1_out_vol,m2_out_vol,m3_out_vol,m4_out_vol,m5_out_vol,m6_out_vol,m7_out_vol,m8_out_vol,m9_out_vol,m10_out_vol,m11_out_vol,m12_out_vol,m13_out_vol,m14_out_vol,m15_out_vol,m16_out_vol,m1_outcurr,m2_outcurr,m3_outcurr,m4_outcurr,m5_outcurr,m6_outcurr,m7_outcurr,m8_outcurr,m9_outcurr,m10_outcurr,m11_outcurr,m12_outcurr,m13_outcurr,m14_outcurr,m15_outcurr,m16_outcurr,m_temper1,m_temper2,m_humidity1,m_humidity2,useracin1_vola,useracin1_volb,useracin1_volc,useracin1_curra,useracin1_currb,useracin1_currc,useracin2_vola,useracin2_volb,useracin2_volc,useracin2_curra,useracin2_currb,useracin2_currc,load_curr)  VALUES " ;

        

        String sql_values = "(" + rtdata.PowerDevDeviceId +"," + "'" + Com.getDateTimeFormat(new Date(),Com.DTF_YMDhms ) + "',";

        

@@ -217,6 +218,8 @@
                + "," + rtdata.m_EnvData.userAcIn2_currA

                + "," + rtdata.m_EnvData.userAcIn2_currB

                + "," + rtdata.m_EnvData.userAcIn2_currC



                + "," + rtdata.m_acdcData.loader_curr

                        

                + ")";

        


 IEC61850_ForPowerSupply/src/com/version_inf/version_inf.txt

@@ -6,6 +6,7 @@


V1.009    2023-08-21

    1.电源告警新增告警配置读取，用以判别电源告警是否需要手动确认以及能否自动消失

    2.重庆电源历史实时表中添加负载电流字段记录-2024-11-05



V1.008    2023-07-31

    1.新增电源告警类型以及对应判断条件