From ba120c368480d2c5c5f31eee26ec954e332afd71 Mon Sep 17 00:00:00 2001
From: sujinwen <sujinwen@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期一, 24 七月 2017 15:30:32 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CompanyDao.java | 4 ++--
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java | 37 +++++++++++++++++++++++++++++--------
2 files changed, 31 insertions(+), 10 deletions(-)
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CompanyDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CompanyDao.java
index 0bcde76..79b3b2b 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CompanyDao.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CompanyDao.java
@@ -23,7 +23,7 @@
public List<Company> getCompanyList( String deviceCompanyId){
List<Company> result=new ArrayList<Company>();
Company company=null;
- String sql="select * from company where is_synchron='N' and device_company_id="+deviceCompanyId;
+ String sql="select * from company where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId);
Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{});
if(c.moveToFirst()){
company=new Company();
@@ -40,7 +40,7 @@
//鍒犻櫎宸蹭笂浼犵粰浣犳湇鍔″櫒鐨勬暟鎹�
public void delCompanyList(String deviceCompanyId){
- String sql="delete from company where is_synchron='N' and device_company_id="+deviceCompanyId;
+ String sql="delete from company where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId);
MainActivity.getInstance().db.execSQL(sql);
}
}
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java
index 4308951..fa03d4f 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DataSynchronDao.java
@@ -4,7 +4,6 @@
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
-import cn.com.basic.face.base.Config;
import cn.com.basic.face.base.MainActivity;
/**
@@ -149,9 +148,6 @@
}
-
-
-
//#######################浠ヤ笂涓哄鍒犳敼鏌EMO#################################
@@ -168,16 +164,41 @@
/**
* 鍗曞悜鍚屾锛屼粠瀹㈡埛绔悓姝ュ埌鏈嶅姟鍣ㄧ
* @param clientTable
- * @param serviceTable
*/
- public static void clientToService(String clientTable,String serviceTable){
-
+ public static void clientToService(String clientTable){
+ //public Cursor query(String table,String[] columns,String selection,String[] selectionArgs,String groupBy,String having,String orderBy,String limit);
SQLiteDatabase db = MainActivity.getInstance().db;
+
+ db.execSQL("");
+ db.endTransaction();
+ //1.鏍规嵁涓婃鍚屾鏃堕棿鎵惧嚭闇�瑕佷笂浼犵殑鏁版嵁
+
db.execSQL("");
//1.鏍规嵁涓婃鍚屾鏃堕棿鎵惧嚭闇�瑕佷笂浼犵殑鏁版嵁
- //2.鍙戦�佹暟鎹粰鏈嶅姟鍣ㄧ
+
+ String selection="is_synchron=?";
+ String[] selectionArgs=new String[]{"N"};
+ String orderBy="update_time desc";
+ Cursor cursor = db.query(clientTable,null,selection,selectionArgs,null,null,orderBy,null);
+
+ while (cursor.moveToNext())
+ {
+ int useid = cursor.getInt(cursor.getColumnIndex("useid"));
+ String date = cursor.getString(cursor.getColumnIndex("date"));
+ String content = cursor.getString(cursor.getColumnIndex("content"));
+ int fangxiang =cursor.getShort(cursor.getColumnIndex("dirr"));
+ boolean dirr;
+ }
+
+ cursor.close();
+ db.close();
+
}
+
+
+
+
/**
* 鍗曞悜鍚屾锛屼粠鏈嶅姟绔悓姝ュ埌瀹㈡埛绔�
* @param clientTable
--
Gitblit v1.8.0