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