From 1a10d546c76f474d33e23c5958c08aa0afcdae67 Mon Sep 17 00:00:00 2001
From: sujinwen <sujinwen@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期一, 24 七月 2017 11:46:45 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CompanyDao.java | 41 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 41 insertions(+), 0 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
new file mode 100644
index 0000000..8f7d9dd
--- /dev/null
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CompanyDao.java
@@ -0,0 +1,41 @@
+package cn.com.basic.face.service.sqlite;
+
+import android.database.Cursor;
+
+import java.util.ArrayList;
+import java.util.List;
+
+import cn.com.basic.face.base.MainActivity;
+import cn.com.basic.face.discern.entity.Company;
+
+/**
+ * Created by SJW on 2017/7/24 0024.
+ */
+
+public class CompanyDao extends BaseDao {
+
+ public static CompanyDao instance=new CompanyDao();
+ public static CompanyDao getInstance(){
+ return instance;
+ }
+
+ 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;
+ Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{});
+ if(c.moveToFirst()){
+ company=new Company();
+ company.setCompanyId(c.getString(c.getColumnIndex("company_id")));
+ company.setCompanyName(c.getString(c.getColumnIndex("company_name")));
+ company.setDeviceCompanyId(c.getString(c.getColumnIndex("device_company_id")));
+ company.setIsSynchron(c.getString(c.getColumnIndex("is_synchron")));
+ company.setUpdateTime(c.getString(c.getColumnIndex("update_time")));
+ result.add(company);
+ }
+ return result;
+
+ }
+
+
+}
--
Gitblit v1.8.0