From c504baf0a2e4e6932d952690a88d3c0c2d23c360 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 31 三月 2023 11:50:10 +0800
Subject: [PATCH] 追加放电计划临时表后期新增字段
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 65 +++++++++++++++++++++++++++++---
1 files changed, 58 insertions(+), 7 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index 379ef24..8e624da 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/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 {
--
Gitblit v1.9.1