From 426ae9a57c515b37b0996f62bdf10079110ce488 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.32>
Date: 星期四, 15 十一月 2018 09:27:57 +0800
Subject: [PATCH] 升级界面进入时查询正在升级的设备

---
 gx_tieta/src/com/fgkj/services/ram/Fbs9100s_dfu_stateService.java |   13 +++++++++++++
 gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl.java    |   40 +++++++++++++++++++++++++++++++++++-----
 gx_tieta/src/com/fgkj/actions/ram/Fbs9100s_dfu_stateAction.java   |    7 ++++++-
 3 files changed, 54 insertions(+), 6 deletions(-)

diff --git a/gx_tieta/src/com/fgkj/actions/ram/Fbs9100s_dfu_stateAction.java b/gx_tieta/src/com/fgkj/actions/ram/Fbs9100s_dfu_stateAction.java
index 6dd943d..44e86e0 100644
--- a/gx_tieta/src/com/fgkj/actions/ram/Fbs9100s_dfu_stateAction.java
+++ b/gx_tieta/src/com/fgkj/actions/ram/Fbs9100s_dfu_stateAction.java
@@ -66,7 +66,12 @@
 		result=tojson(model);
 		return SUCCESS;
 	}
-	
+	//鍗囩骇鐣岄潰瀹炴椂鍒锋柊
+	public String searchAll(){
+		ServiceModel model=service.searchAll();
+		result=tojson(model);
+		return SUCCESS;
+	}
 	public String getResult() {
 		return result;
 	}
diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl.java
index 8a918d8..fc17d26 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl.java
@@ -187,10 +187,36 @@
 		// TODO Auto-generated method stub
 		return false;
 	}
-
+    //鏌ヨ鍑烘墍鏈夊浜庡崌绾х殑璁惧
 	public List searchAll() {
-		// TODO Auto-generated method stub
-		return null;
+		String sql=" select * from  db_ram_db.tb_fbs9100s_dfu_state where dfu_en=1";
+		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null , new CallBack() {
+			
+			public List getResults(ResultSet rs) {
+				List list=new ArrayList();
+				try {
+					while(rs.next()){
+						Fbs9100s_dfu_state dfu=new Fbs9100s_dfu_state();
+						dfu.setDev_id(rs.getInt("dev_id"));
+						dfu.setSysVersion_new(rs.getInt("sysVersion_new"));
+						dfu.setSoftVersion_new(rs.getInt("softVersion_new"));
+						dfu.setSysVersion_dev(rs.getInt("sysVersion_dev"));
+						dfu.setSoftVersion_dev(rs.getInt("softVersion_dev"));
+						dfu.setDfu_file(rs.getString("dfu_file"));
+						dfu.setDfu_en(rs.getInt("dfu_en"));
+						dfu.setDfu_wr_stat(rs.getInt("dfu_wr_stat"));
+						dfu.setDfu_data_blocknum(rs.getInt("dfu_data_blocknum"));
+						dfu.setDfu_data_blocklen(rs.getInt("dfu_data_blocklen"));
+						list.add(dfu);
+					}
+				} catch (SQLException e) {
+					// TODO Auto-generated catch block
+					e.printStackTrace();
+				}
+				return list;
+			}
+		});
+		return list;
 	}
     //鍗囩骇鐣岄潰瀹炴椂鍒锋柊
 	public List serchByCondition(Object obj) {
@@ -242,7 +268,7 @@
 		});
 		return listAll;
 	}
-
+   
 	public List serchByInfo(Object obj) {
 		// TODO Auto-generated method stub
 		return null;
@@ -268,9 +294,13 @@
 	/*
 	boolean bl=fimpl.addPro(binf);
 	System.out.println(bl);*/
-	List<BattInf> listAll=fimpl.serchInserStation(binf);
+	/*List<BattInf> listAll=fimpl.serchInserStation(binf);
 	for (BattInf b : listAll) {
 		System.out.println(b.getStationName3()+" "+b.getFBSDeviceId());
+	}*/
+	List<Fbs9100s_dfu_state> listAll=fimpl.searchAll();
+	for (Fbs9100s_dfu_state dfu : listAll) {
+		System.out.println(dfu);
 	}
 }
 }
diff --git a/gx_tieta/src/com/fgkj/services/ram/Fbs9100s_dfu_stateService.java b/gx_tieta/src/com/fgkj/services/ram/Fbs9100s_dfu_stateService.java
index 8f5070c..fd7bb9b 100644
--- a/gx_tieta/src/com/fgkj/services/ram/Fbs9100s_dfu_stateService.java
+++ b/gx_tieta/src/com/fgkj/services/ram/Fbs9100s_dfu_stateService.java
@@ -104,4 +104,17 @@
 		}
 		return model;
 	}
+	//鏌ヨ鍑烘墍鏈夊浜庡崌绾х殑璁惧
+	public ServiceModel searchAll() {
+		List list=dao.searchAll();
+		if(list!=null&&list.size()>0){
+			model.setCode(1);
+			model.setData(list);
+			model.setMsg("鏌ヨ鎴愬姛!");
+		}else{
+			model.setCode(0);
+			model.setMsg("鏌ヨ澶辫触!");
+		}
+		return model;
+	}
 }

--
Gitblit v1.9.1