放电计划临时表字段更新

Administrator

2023-03-27 892edbb24686203df88fbf3d93d0c24f35c4868a

放电计划临时表字段更新

 BattMonitor_DB_Builder/config.xml

@@ -2,7 +2,7 @@

<root>
  <mysql_ramdb_recreate_en>false</mysql_ramdb_recreate_en>
  <mysql_server_ip>127.0.0.1</mysql_server_ip>
  <mysql_server_ip>192.168.10.79</mysql_server_ip>
  <!--SOURCE_BATTDATA_TYPE_FBSDEV = 0-->
  <!--SOURCE_BATTDATA_TYPE_SQLSERVER = 1-->
  <!--SOURCE_BATTDATA_TYPE_C_INTERFACE = 2-->

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java

@@ -346,7 +346,7 @@
                //交流B相欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流B相欠压告警",2,pool);
                //交流B相缺相告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流C相缺相告警",2,pool);
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流B相缺相告警",2,pool);
                //交流C相过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流C相过压告警",1,pool);
                //交流C相欠压告警

 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -4671,18 +4671,23 @@
        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table;
        String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table + " (" + 
                "  `id` int(11) NOT NULL AUTO_INCREMENT," + 
                "  `station_id` varchar(20) DEFAULT NULL COMMENT '机房id'," + 
                "  `station_name` varchar(100) DEFAULT NULL COMMENT '机房名称'," + 
                "  `batt_group_id` int(11) DEFAULT NULL  COMMENT '包机组id'," + 
                "  `batt_group_name` varchar(100) DEFAULT NULL  COMMENT '电池组名称'," + 
                "  `station_id` varchar(20) DEFAULT NULL," + 
                "  `station_name` varchar(100) DEFAULT NULL," + 
                "  `batt_group_id` int(11) DEFAULT NULL," + 
                "  `batt_group_name` varchar(100) DEFAULT NULL," + 
                "  `group_id` bigint(20) DEFAULT NULL COMMENT '班组id,与包机组一致'," + 
                "  `group_name` varchar(200) DEFAULT NULL COMMENT '班组名称,与包机组一致'," + 
                "  `node_station` tinyint(1) DEFAULT NULL COMMENT '是否节点站'," + 
                "  `mon_cap_std` float DEFAULT NULL  COMMENT '标称容量'," + 
                "  `mon_vol_std` float DEFAULT NULL  COMMENT '标称单体电压'," + 
                "  `mon_cap_std` float DEFAULT NULL," + 
                "  `mon_vol_std` float DEFAULT NULL," + 
                "  `cap_percent` float DEFAULT NULL COMMENT '放电容量百分比'," + 
                "  `discharge_start_time` datetime DEFAULT NULL  COMMENT '放电开始时间'," + 
                "  `create_time` datetime DEFAULT NULL  COMMENT '创建时间'," + 
                "  `discharge_start_time` datetime DEFAULT NULL," + 
                "  `create_time` datetime DEFAULT NULL," + 
                "  `create_user_id` int(11) DEFAULT NULL," + 
                "  `submit_status` tinyint(1) DEFAULT NULL COMMENT '0:未提交,1:已提交'," + 
                "  `approve_status` tinyint(1) DEFAULT NULL COMMENT '0:待审核,1:审核通过,2:审核拒绝'," + 
                "  `approve_time` datetime DEFAULT NULL," + 
                "  `approve_user_id` int(11) DEFAULT NULL," + 
                "  PRIMARY KEY (`id`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='放电计划临时表';"; 
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());