sujinwen

2017-07-24 8c1533ecbf59fc04d684bf610e978bb4165db6d5

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
42
43
44
45
46
47
48
49
50
51
52
53
54
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="+Integer.parseInt(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; 
 
    } 
 
    //删除已上传给你服务器的数据 
    public void delCompanyList(String deviceCompanyId){ 
        String sql="delete from company where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId); 
        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[]{}); 
         return c.getCount(); 
    } 
 
}