From d343b71cd89f59a87e85c46ce7a04d47c357462d Mon Sep 17 00:00:00 2001 From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674> Date: 星期二, 25 七月 2017 15:46:45 +0800 Subject: [PATCH] --- VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CompanyDao.java | 13 +++++++++++-- 1 files changed, 11 insertions(+), 2 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 79b3b2b..fbc9005 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 @@ -39,8 +39,17 @@ } //鍒犻櫎宸蹭笂浼犵粰浣犳湇鍔″櫒鐨勬暟鎹� - public void delCompanyList(String deviceCompanyId){ - String sql="delete from company where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId); + public void delCompanyList(){ + String sql="delete from company where is_synchron='N'"; MainActivity.getInstance().db.execSQL(sql); } + + //鑾峰彇鏈悓姝ユ暟鎹�绘暟 + public int getSynDataCount(){ + String sql="select count(*) from company where is_synchron='N' "; + Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{}); + c.moveToFirst(); + return c.getInt(0); + } + } -- Gitblit v1.8.0