sujinwen

2017-07-24 1a10d546c76f474d33e23c5958c08aa0afcdae67

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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; 
 
    } 
 
 
}