~whychwj/haha.git

			@@ -13,6 +13,7 @@
			import com.fgkj.dao.UinfDaoFactory;
			import com.fgkj.db.DBUtil;
			import com.fgkj.dto.BattInf;
			import com.fgkj.dto.BattMap_information;
			import com.fgkj.dto.Page;
			import com.fgkj.dto.User_inf;
			import com.fgkj.dto.ram.Bts_station_state;
			@@ -209,6 +210,35 @@
			}
			return nums;
			}
			//查询当前机房停电数(根据station_id )
			public int serchByStationId(Object obj) {
			BattMap_information binformation=(BattMap_information) obj;
			String sql="select count(num) as nums from db_ram_db.tb_bts_station_state " +
			" where station_stat&2>1 " +
			" and station_id=? " +
			" limit 1 ";
			//System.out.println(sql);
			List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binformation.getStationId()}, new CallBack() {

			public List getResults(ResultSet rs) {
			List list=new ArrayList();
			try {
			while(rs.next()){
			int nums=rs.getInt("nums");
			list.add(nums);
			}
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return list;
			}
			});
			int nums=0;//最后的结果
			if(list!=null&&list.size()>0){
			nums=(Integer) list.get(list.size()-1);
			}
			return nums;
			}
			public List serchByInfo(Object obj) {
			// TODO Auto-generated method stub
			return null;
			@@ -233,8 +263,11 @@
			//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(nums);*/
			/int nums=bimpl.serchByState(uinf);/
			BattMap_information bm=new BattMap_information();
			bm.setStationId("42000570");
			int nums=bimpl.serchByStationId(bm);
			System.out.println(nums);
			}

			@@ -14,6 +14,7 @@
			import com.fgkj.dao.impl.BattMap_informationImpl;
			import com.fgkj.dao.impl.Batt_rtstateDAOImpl;
			import com.fgkj.dao.impl.Battalarm_dataDAOImpl;
			import com.fgkj.dao.impl.ram.Bts_station_stateImpl;
			import com.fgkj.dao.impl.ram.Fbs9100_stateImpl;
			import com.fgkj.db.DBUtil;
			import com.fgkj.dto.BattInf;
			@@ -107,6 +108,7 @@
			int numBadBatt=0;
			int numAlarm=0;
			int numPlan=0;
			int numPoff=0;
			if(list!=null&&list.size()>0){
			for(int i=0;i<list.size();i++){
			state="item-normal";
			@@ -117,25 +119,32 @@
			binf.setFBSDeviceId(binformation.getFBSDeviceId());
			state=(new Fbs9100_stateImpl().seachDevNow(binf));
			}else{
			numPoff=(new Bts_station_stateImpl()).serchByStationId(binformation); //停电数
			numBadBatt=(new BadBatt_monImpl()).serchByStationId(binformation); //落后总数
			numAlarm=(new Battalarm_dataDAOImpl()).serchByStationId(binformation); //告警总数
			numPlan=(new BattDischarge_planImpl()).serchByStationId(binformation); //延迟总数
			if(numBadBatt>0){
			state="item-behind"; //落后机房
			if(numPoff>0){
			state="item-poff"; //停电
			}else{
			if(numAlarm > 0){
			state="item-warn"; //告警机房
			if(numBadBatt>0){
			state="item-behind"; //落后机房
			}else{
			if(numPlan > 0){
			state="item-timeout"; //延迟机房
			if(numAlarm > 0){
			state="item-warn"; //告警机房
			}else{
			if(numPlan > 0){
			state="item-timeout"; //延迟机房
			}
			}
			}
			}

			}
			if("0".equals(list.get(i).getInformation())){
			state=""; //若机房未安装将指定的机房设置成灰色的
			state="item-install"; //若机房未安装将指定的机房设置成灰色的
			}
			model.setData(list.get(i));
			model.setData(list.get(i));
			model.setMsgO(String.valueOf(numPoff)); //停电数
			model.setCode(numAlarm); //告警总数
			model.setSum(numBadBatt); //落后总数
			model.setNewsum(numPlan); //延时总数

	gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java	37 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	gx_tieta/src/com/fgkj/services/BattMap_informationService.java	25 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史