From 9e5babf9db52e64bdae60137be7696e56241fca6 Mon Sep 17 00:00:00 2001
From: xingzilong <xingzilong@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期五, 18 八月 2017 18:12:17 +0800
Subject: [PATCH] H264 NALU解析  并在RTSPServer判断

---
 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DictionaryDao.java |   98 ++++++++++++++++++++++++++++++++++++++-----------
 1 files changed, 76 insertions(+), 22 deletions(-)

diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DictionaryDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DictionaryDao.java
index fcfb627..6f7d3d4 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DictionaryDao.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DictionaryDao.java
@@ -1,14 +1,15 @@
 package cn.com.basic.face.service.sqlite;
 
 import android.database.Cursor;
-import android.database.sqlite.SQLiteDatabase;
 
 import java.util.ArrayList;
 import java.util.List;
 
-import cn.com.basic.face.base.Config;
+import cn.com.basic.face.base.MainActivity;
 import cn.com.basic.face.discern.common.CommonVariables;
 import cn.com.basic.face.discern.entity.Dictionary;
+
+import static cn.com.basic.face.discern.entity.Register.FieldNames.company;
 
 /**
  * 鏁版嵁瀛楀吀Dao
@@ -19,34 +20,25 @@
     public static DictionaryDao getInstance() {
         return instance;
     }
-    private  static StringBuffer sb = new StringBuffer("select dict_id, name from dictionary ");
-
-
 
     private  static  List<Dictionary>load(String type){
         List<Dictionary> list = new ArrayList<Dictionary>();
-        SQLiteDatabase db = Config.sqlMap.getDb();
-        db.beginTransaction();
+        StringBuffer sb = new StringBuffer("select dict_id, name from dictionary ");
         try {
             sb.append("where 1 = 1 and type = ");
+            sb.append("'");
             sb.append(type);
+            sb.append("'");
             Dictionary aqi = null;
-            Cursor c = db.rawQuery(sb.toString(), new String[]{});
+            Cursor c = MainActivity.getInstance().db.rawQuery(sb.toString(), new String[]{});
             while (c.moveToNext()) {
                 aqi = new Dictionary();
                 aqi.setDictId(c.getString(c.getColumnIndex("dict_id")));
                 aqi.setName(c.getString((c.getColumnIndex("name"))));
                 list.add(aqi);
             }
-            c.close();
-            db.setTransactionSuccessful();
         }catch (Exception e) {
             e.printStackTrace();
-        }finally {
-            db.endTransaction();
-            if(db!=null){
-                db.close();
-            }
         }
         return list;
     }
@@ -118,17 +110,79 @@
         return   load(CommonVariables.DictionaryType.VISITOR_TYPE);
     }
 
-    public List<Dictionary> addDictionary(String type, String name) {
-        return   load(CommonVariables.DictionaryType.COUNTRY);
-    }
-
-
     /**
      * 鍔犺浇鑰冨嫟绫诲瀷
      * @return
      */
     public List<Dictionary> loadAttenderTypeList() {
-        return   load(CommonVariables.DictionaryType.ATTENDER_TYPE);
+        return load(CommonVariables.DictionaryType.ATTENDER_TYPE);
     }
 
-}
+    public List<Dictionary> addDictionary(String type, String name) {
+        List<Dictionary> list = new ArrayList<Dictionary>();
+        try {
+            StringBuilder sb = new StringBuilder(40);
+
+            sb.append("insert into dictionary ( dict_id, name) values (")
+                    .append("'")
+                    .append(type)
+                    .append("'")
+                    .append(" , ")
+                    .append(")");
+            MainActivity.getInstance().db.rawQuery(sb.toString(), new String[]{});
+            Dictionary aqi = null;
+            Cursor c = MainActivity.getInstance().db.rawQuery("select dict_id,name from dictionary", new String[]{});
+            while (c.moveToNext()) {
+                aqi = new Dictionary();
+                aqi.setDictId(c.getString(c.getColumnIndex("dict_id")));
+                aqi.setName(c.getString((c.getColumnIndex("name"))));
+                list.add(aqi);
+            }
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
+        return  list;
+    }
+
+    //鍔犺浇闇�瑕佸悓姝ョ殑鏁版嵁
+ public List<Dictionary>  getDictionayList(String deviceCompanyId){
+     String sql="select * from dictionary WHERE is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId);
+     Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{});
+     List<Dictionary> result=new ArrayList<Dictionary>();
+     Dictionary dic=null;
+     if(c.moveToFirst()){
+         dic=new Dictionary();
+         dic.setSn(c.getString(c.getColumnIndex("sn")));
+         dic.setType(c.getString(c.getColumnIndex("type")));
+         dic.setCompnayId(c.getString(c.getColumnIndex("compnay_id")));
+         dic.setDeviceCompanyId(c.getString(c.getColumnIndex("device_company_id")));
+         dic.setDictId(c.getString(c.getColumnIndex("dict_id")));
+         dic.setIsSynchron(c.getString(c.getColumnIndex("is_synchron")));
+         dic.setUpdateTime(c.getString(c.getColumnIndex("update_time")));
+         dic.setName(c.getString(c.getColumnIndex("name")));
+         dic.setOrderBy(c.getString(c.getColumnIndex("order_by")));
+         dic.setPid(c.getString(c.getColumnIndex("pid")));
+         dic.setRemark(c.getString(c.getColumnIndex("remark")));
+         dic.setIsValid(c.getString(c.getColumnIndex("is_valid")));
+         dic.setCreateTime(c.getString(c.getColumnIndex("create_time")));
+         result.add(dic);
+     }
+      return result;
+ }
+
+ //鍒犻櫎宸茬粡涓婁紶鍒版湇鍔″櫒鐨勬暟鎹�
+ public  void delDictionary(){
+     String sql="delete from dictionary where is_synchron='N'";
+     MainActivity.getInstance().db.execSQL(sql);
+
+ }
+    //鑾峰彇鏈悓姝ユ暟鎹�绘暟
+    public int  getSynDataCount(){
+        String sql="select count(*) from dictionary where is_synchron='N' ";
+        Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{});
+        c.moveToFirst();
+        return c.getInt(0);
+    }
+
+ }
+

--
Gitblit v1.8.0