From 4ca768a6e07bf7e776625bc148a0fc61d00b05b1 Mon Sep 17 00:00:00 2001 From: sujinwen <sujinwen@454eff88-639b-444f-9e54-f578c98de674> Date: 星期二, 25 七月 2017 16:30:56 +0800 Subject: [PATCH] Failed commit: Default --- VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DeviceDao.java | 12 +++++++++--- 1 files changed, 9 insertions(+), 3 deletions(-) diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DeviceDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DeviceDao.java index 3da35d0..02660dd 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DeviceDao.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DeviceDao.java @@ -173,12 +173,18 @@ //鍒犻櫎宸茬粡涓婁紶鍒版湇鍔″櫒鐨勫悓姝ユ暟鎹� - public void delDevice(String deviceCompanyId){ - String sql="delete from device where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId); + public void delDevice(){ + String sql="delete from device where is_synchron='N'"; MainActivity.getInstance().db.execSQL(sql); } - + //鑾峰彇鏈悓姝ユ暟鎹�绘暟 + public int getSynDataCount(){ + String sql="select count(*) from device where is_synchron='N' "; + Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{}); + c.moveToFirst(); + return c.getInt(0); + } } -- Gitblit v1.8.0