From 8a15db8b08c70dfd54cc27d78065e08de22d5952 Mon Sep 17 00:00:00 2001 From: whychdw <49690745@qq.com> Date: 星期二, 03 十二月 2019 15:13:08 +0800 Subject: [PATCH] Merge branch 'FBS9600' of http://whychdw@118.89.139.230:10101/r/FBS9600App.git into FBS9600 --- platforms/android/app/src/main/java/com/fgkj/service/Battalram_dataService.java | 4 ++++ platforms/android/app/src/main/java/com/fgkj/dto/Battalram_data.java | 10 ++++++++++ platforms/android/app/src/main/java/com/fgkj/impl/Battalram_dataImpl.java | 11 +++++++---- platforms/android/app/src/main/java/io/cordova/hellocordova/MainActivity.java | 3 +++ 4 files changed, 24 insertions(+), 4 deletions(-) diff --git a/platforms/android/app/src/main/java/com/fgkj/dto/Battalram_data.java b/platforms/android/app/src/main/java/com/fgkj/dto/Battalram_data.java index 8590c91..628d72e 100644 --- a/platforms/android/app/src/main/java/com/fgkj/dto/Battalram_data.java +++ b/platforms/android/app/src/main/java/com/fgkj/dto/Battalram_data.java @@ -15,6 +15,7 @@ private int alm_is_confirmed; private Date alm_confirmed_time; private int alm_cleared_type; + private String note; private Page page; public int getNum() { @@ -113,6 +114,14 @@ this.page = page; } + public String getNote() { + return note; + } + + public void setNote(String note) { + this.note = note; + } + @Override public String toString() { return "Battalram_data{" + @@ -127,6 +136,7 @@ ", alm_is_confirmed=" + alm_is_confirmed + ", alm_confirmed_time=" + alm_confirmed_time + ", alm_cleared_type=" + alm_cleared_type + + ", note='" + note + '\'' + ", page=" + page + '}'; } diff --git a/platforms/android/app/src/main/java/com/fgkj/impl/Battalram_dataImpl.java b/platforms/android/app/src/main/java/com/fgkj/impl/Battalram_dataImpl.java index c62e088..0c121f1 100644 --- a/platforms/android/app/src/main/java/com/fgkj/impl/Battalram_dataImpl.java +++ b/platforms/android/app/src/main/java/com/fgkj/impl/Battalram_dataImpl.java @@ -36,11 +36,13 @@ @Override public List serchByCondition(SQLiteDatabase db, Object obj) { Battalram_data adata=(Battalram_data)obj; - String numsql = "select count(*) from tb_battalarm_data where "; - String sql=" select * from tb_battalarm_data where "; + String numsql = "select count(*) from tb_battalarm_data,tb_battinf where tb_battinf.BattGroupId=tb_battalarm_data.BattGroupId "; + String sql=" select distinct tb_battalarm_data.num,tb_battalarm_data.BattGroupId,tb_battalarm_data.MonNum,alm_id,alm_signal_id,alm_start_time,alm_end_time,alm_value,alm_is_confirmed,alm_confirmed_time,alm_cleared_type" + + ",tb_battinf.BattGroupName " + + " from tb_battalarm_data,tb_battinf where tb_battinf.BattGroupId=tb_battalarm_data.BattGroupId "; //鍛婅绫诲瀷 - String typeSqlT=" alm_cleared_type!=? "; - String typeSqlF=" alm_cleared_type=? "; + String typeSqlT=" and alm_cleared_type!=? "; + String typeSqlF=" and alm_cleared_type=? "; if(adata.getAlm_cleared_type()==100){ sql+=typeSqlT; numsql+=typeSqlT; @@ -76,6 +78,7 @@ a.setAlm_is_confirmed(rs.getInt(rs.getColumnIndex("alm_is_confirmed"))); a.setAlm_confirmed_time(ActionUtil.sdf.parse(rs.getString(rs.getColumnIndex("alm_confirmed_time")))); a.setAlm_cleared_type(rs.getInt(rs.getColumnIndex("alm_cleared_type"))); + a.setNote(rs.getString(rs.getColumnIndex("BattGroupName"))); Page page=new Page(); page.setPageAll(count); a.setPage(page); diff --git a/platforms/android/app/src/main/java/com/fgkj/service/Battalram_dataService.java b/platforms/android/app/src/main/java/com/fgkj/service/Battalram_dataService.java index 7e2ed50..1b33e5b 100644 --- a/platforms/android/app/src/main/java/com/fgkj/service/Battalram_dataService.java +++ b/platforms/android/app/src/main/java/com/fgkj/service/Battalram_dataService.java @@ -1,6 +1,7 @@ package com.fgkj.service; import android.database.sqlite.SQLiteDatabase; +import android.util.Log; import android.webkit.JavascriptInterface; import android.webkit.WebView; @@ -28,10 +29,13 @@ //鏍规嵁battfroupid鏌ヨ鍘嗗彶鏁版嵁鏌ヨ @JavascriptInterface public void serchByCondition(String obj) { + //Log.e("Battalram_dataService", "serchByCondition: %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%" ); + //Log.e("Battalram_dataService", "serchByCondition: "+obj ); ServiceModel model=new ServiceModel(); SQLiteDatabase db=dbHelper.getWritableDatabase(); Battalram_data adata= ActionUtil.getGson("yyyy-MM-dd HH:mm:ss").fromJson(obj,Battalram_data.class); List list=dao.serchByCondition(db,adata); + //Log.e("Battalram_dataService", "serchByCondition: "+list); if(list!=null&&list.size()>0){ model.code=1; model.cmd_type=adata.getAlm_cleared_type(); diff --git a/platforms/android/app/src/main/java/io/cordova/hellocordova/MainActivity.java b/platforms/android/app/src/main/java/io/cordova/hellocordova/MainActivity.java index c059111..2c91a89 100644 --- a/platforms/android/app/src/main/java/io/cordova/hellocordova/MainActivity.java +++ b/platforms/android/app/src/main/java/io/cordova/hellocordova/MainActivity.java @@ -29,6 +29,7 @@ import com.fgkj.dao.SQLdm; import com.fgkj.dto.Battresdata; import com.fgkj.dto.Batttestdata_inf; +import com.fgkj.service.Battalram_dataService; import com.fgkj.service.BattinfService; import com.fgkj.service.BattresdataService; import com.fgkj.service.Battresdata_infService; @@ -74,6 +75,8 @@ webview.addJavascriptInterface(new BattresdataService(webview, dbHelper),BattresdataService.BATTRESDATASERVICE_NAME); //tb_battresdata_inf琛ㄧ殑鎿嶄綔 webview.addJavascriptInterface(new Battresdata_infService(webview, dbHelper),Battresdata_infService.BATTRESDATA_INFSERVICE_NAME); + //娣诲姞鍛婅鎺ュ彛 + webview.addJavascriptInterface(new Battalram_dataService(webview,dbHelper),Battalram_dataService.BATTALRAM_DATASERVICE_NAME); } @Override -- Gitblit v1.9.1