From a50eeca38aac03ba7a4fb9f27f73133936b8597a Mon Sep 17 00:00:00 2001 From: hdw <496960745@qq.com> Date: 星期三, 05 十二月 2018 17:38:10 +0800 Subject: [PATCH] Merge branch 'dev_lxw' of https://whychdw@gitlab.com/whyclxw1/gx_tieta.git into dev_lxw --- gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java | 15 +++++++++------ 1 files changed, 9 insertions(+), 6 deletions(-) diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java index f9bc254..dff7238 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java @@ -51,7 +51,7 @@ Connection conn=DBUtil.getConn(); String numberSql="SELECT FOUND_ROWS() number";//瀛樻斁鎬绘暟 String sql="select SQL_CALC_FOUND_ROWS distinct station_id,dev_id,record_datetime,station_stat,station_poff_start_time,station_fadian_start_time" + - " ,station_diaozhan_start_time,station_temp,station_damp,station_dooropen_start_time,station_xuhang_start_time" + + " ,station_diaozhan_start_time,station_temp,station_damp,station_dooropen_start_time,station_xuhang_start_time,station_xuhang_end_time" + " ,tb_battinf.stationname,tb_battinf.stationname1,tb_battinf.stationname2,tb_battinf.stationname3,tb_battinf.stationname5 " + " from db_ram_db.tb_bts_station_state,db_battinf.tb_battinf " + " where tb_bts_station_state.dev_id=db_battinf.tb_battinf.FBSDeviceId " + @@ -154,6 +154,7 @@ b.setStation_damp(rs.getFloat("station_damp")); b.setStation_dooropen_start_time(rs.getTimestamp("station_dooropen_start_time")); b.setStation_xuhang_start_time(rs.getTimestamp("station_xuhang_start_time")); + b.setStation_xuhang_end_time(rs.getTimestamp("station_xuhang_end_time")); b.setStationName(rs.getString("stationName")); b.setStationName1(rs.getString("stationName1")); b.setStationName2(rs.getString("stationName2")); @@ -303,29 +304,31 @@ binf.setStationName1(""); binf.setStationName2(""); binf.setStationName3(""); + binf.setStationName5(""); binf.setStationId(""); - binf.setBattGroupNum(36); + binf.setBattGroupNum(62); User_inf uinf=new User_inf(); uinf.setUId(1002); Page p=new Page(); p.setPageCurr(1); p.setPageSize(10); binf.setPage(p); - /*List<Bts_station_state> list=bimpl.serchByCondition(binf); + List<Bts_station_state> list=bimpl.serchByCondition(binf); for (Bts_station_state bs : list) { //System.out.println(bs.getStation_stat_diaozhan()+" "+bs.getStation_stat_dooropen()+" "+bs.getStation_stat_fadian()+" "+bs.getStation_stat_xuhang()+" "+bs.getStation_stat_poff()); System.out.println(bs); } - int nums=bimpl.serchByState(uinf);*/ + //System.out.println(list.size()); + //int nums=bimpl.serchByState(uinf); /*BattMap_information bm=new BattMap_information(); bm.setStationId("42000570"); int nums=bimpl.serchByStationId(bm);*/ //int nums=bimpl.serchByState_diaozhan(uinf); - BattMap_information bm=new BattMap_information(); + /*BattMap_information bm=new BattMap_information(); bm.setStationId("42000366"); int nums=bimpl.serchByStationId_diaozhan(bm); - System.out.println(nums); + System.out.println(nums);*/ } -- Gitblit v1.9.1