From f7a134dde9670122afc458dc95b5e3ab735d304a Mon Sep 17 00:00:00 2001
From: CJJ <Administrator@USER-20180117QL>
Date: 星期三, 26 十二月 2018 07:31:44 +0800
Subject: [PATCH] xiugai
---
gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java | 35 ++++++++++++++++++++++++++++++++---
1 files changed, 32 insertions(+), 3 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java b/gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java
index a0d5804..bf403a7 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java
@@ -53,7 +53,10 @@
list.add(uchart.getChart_dev_alarm());
list.add(uchart.getChart_pre_charge());
list.add(uchart.getChart_online_charge());
- String sql="insert into web_site.tb_user_Chart(chart_name,chart_file,Chart_logo,Chart_normal,Chart_behind,Chart_warn,Chart_timeout,Chart_nuclear_cap,Chart_dev_alarm,Chart_pre_charge,Chart_online_charge) values(?,?,?,?,?,?,?,?,?,?,?)";
+ list.add(uchart.getChart_poff());
+ list.add(uchart.getChart_install());
+ list.add(uchart.getChart_xuhang());
+ String sql="insert into web_site.tb_user_Chart(chart_name,chart_file,Chart_logo,Chart_normal,Chart_behind,Chart_warn,Chart_timeout,Chart_nuclear_cap,Chart_dev_alarm,Chart_pre_charge,Chart_online_charge,Chart_poff,Chart_install,Chart_xuhang) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
boolean bl=DAOHelper.executeUpdatePicture(DBUtil.getConn(), sql, list);
return bl;
}
@@ -143,11 +146,37 @@
list.add(uchart.getChart_online_charge());
sql+=online_chargeSql;
}
+ //Chart_poff鍥剧墖
+ String poffSql=" Chart_poff=? ";
+ if(uchart.getChart_poff()!=null&&uchart.getChart_poff().length()>0){
+ if(list.size()>0){
+ sql+=",";
+ }
+ list.add(uchart.getChart_poff());
+ sql+=poffSql;
+ }
+ //Chart_install鍥剧墖
+ String installSql=" Chart_install=? ";
+ if(uchart.getChart_install()!=null&&uchart.getChart_install().length()>0){
+ if(list.size()>0){
+ sql+=",";
+ }
+ list.add(uchart.getChart_install());
+ sql+=installSql;
+ }
+ //Chart_xuhang鍥剧墖
+ String xuhangSql=" Chart_xuhang=? ";
+ if(uchart.getChart_xuhang()!=null&&uchart.getChart_xuhang().length()>0){
+ if(list.size()>0){
+ sql+=",";
+ }
+ list.add(uchart.getChart_xuhang());
+ sql+=xuhangSql;
+ }
//endSql
- String endSql=" where chart_file=?";
+ String endSql=" where chart_file=? ";
list.add(uchart.getChart_file());
sql+=endSql;
- //System.out.println(list.size()+" "+sql);
boolean bl=DAOHelper.executeUpdatePicture(DBUtil.getConn(), sql, list);
return bl;
}
--
Gitblit v1.9.1