追加放电计划临时表后期新增字段

Administrator

2023-03-31 c504baf0a2e4e6932d952690a88d3c0c2d23c360

追加放电计划临时表后期新增字段

 BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java

@@ -663,6 +663,15 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table 
                        + " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4815_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重新FBO4815线程加载机房信息';");
            }
            //添加fbo4831重载数据
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_app_sys'"
                    + " AND table_name='tb_app_sys'"
                    + " AND column_name='AppServer_Reinit_BattGroupData_FBO4831_EN'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table 
                        + " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4831_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重新FBO4831线程加载机房信息';");
            }
            
        } catch (SQLException e) {
            e.printStackTrace();

 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -4684,16 +4684,16 @@
                "  `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," + 
                "  `mon_vol_std` float DEFAULT NULL," + 
                "  `mon_cap_std` float DEFAULT NULL COMMENT '标称容量'," + 
                "  `mon_vol_std` float DEFAULT NULL COMMENT '标称单体电压'," + 
                "  `cap_percent` float DEFAULT NULL COMMENT '放电容量百分比'," + 
                "  `discharge_start_time` datetime DEFAULT NULL," + 
                "  `create_time` datetime DEFAULT NULL," + 
                "  `create_user_id` int(11) DEFAULT NULL," + 
                "  `discharge_start_time` datetime DEFAULT NULL COMMENT '计划启动时间'," + 
                "  `create_time` datetime DEFAULT NULL COMMENT '创建时间'," + 
                "  `create_user_id` int(11) DEFAULT NULL COMMENT '创建用户id'," + 
                "  `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," + 
                "  `approve_time` datetime DEFAULT NULL COMMENT '审核时间'," + 
                "  `approve_user_id` int(11) DEFAULT NULL COMMENT '审核用户id'," + 
                "  `approve_reason` varchar(255) DEFAULT NULL COMMENT '审核原因'," + 
                "  PRIMARY KEY (`id`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='放电计划临时表';"; 
@@ -4717,6 +4717,57 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table 
                        + " ADD COLUMN `approve_reason` varchar(255) DEFAULT NULL COMMENT '审核原因';");
            }
            res = null;
            //添加create_user_id 创建用户id
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='web_site'"
                    + " AND table_name='tb_battdischarge_plan_temp'"
                    + " AND column_name='create_user_id'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table 
                        + " ADD COLUMN `create_user_id` int(11) DEFAULT NULL COMMENT '创建用户id';");
            }
            res = null;
            //添加submit_status 提交状态
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='web_site'"
                    + " AND table_name='tb_battdischarge_plan_temp'"
                    + " AND column_name='submit_status'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table 
                        + " ADD COLUMN `submit_status` tinyint(1) DEFAULT NULL COMMENT '0:未提交,1:已提交';");
            }
            res = null;
            //添加approve_status 审核状态
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='web_site'"
                    + " AND table_name='tb_battdischarge_plan_temp'"
                    + " AND column_name='approve_status'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table 
                        + " ADD COLUMN `approve_status` tinyint(1) DEFAULT NULL COMMENT '0:待审核,1:审核通过,2:审核拒绝';");
            }
            res = null;
            //添加approve_time 审核时间
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='web_site'"
                    + " AND table_name='tb_battdischarge_plan_temp'"
                    + " AND column_name='approve_time'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table 
                        + " ADD COLUMN `approve_time` datetime DEFAULT NULL COMMENT '审核时间';");
            }
            res = null;
            //添加approve_user_id 审核用户id
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='web_site'"
                    + " AND table_name='tb_battdischarge_plan_temp'"
                    + " AND column_name='approve_user_id'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table 
                        + " ADD COLUMN `approve_user_id` int(11) DEFAULT NULL COMMENT '审核用户id';");
            }
			
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {