From 72bf018e4a2b8dc2bd99a0bb9a43bc9621edfdfe Mon Sep 17 00:00:00 2001 From: 81041 <81041@192.168.10.23> Date: 星期二, 27 十一月 2018 14:20:31 +0800 Subject: [PATCH] 续航不足3小时的机房个数 --- gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java | 10 ++++++++-- 1 files changed, 8 insertions(+), 2 deletions(-) diff --git a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java index 7f0ac77..b5ff2d0 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java @@ -139,7 +139,13 @@ boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, null); return bl; } - + //璁剧疆鐢垫睜缁勫厖鐢电數娴侀槇鍊� + public boolean update_charge(Object obj){ + BattInf binf=(BattInf) obj; + String sql = "update db_battinf.tb_battinf set charge_curr_max=? where BattGroupId=?"; + boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{binf.getCharge_curr_max(),binf.getBattGroupId()}); + return bl; + } //鍒犻櫎鐢垫睜缁�(澶氫釜) public boolean del(Object obj) { List<BattInf> list=(List<BattInf>) obj; @@ -3351,7 +3357,7 @@ " where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " + " and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " + " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " + - " and db_user.tb_user_inf.uid=?" + + " and db_user.tb_user_inf.uid=? and db_battinf.tb_battinf.Station_install=1 " + " limit 1"; List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() { -- Gitblit v1.9.1