xuxiuxi
2017-08-01 e09e9f8a34cbc99a33dfa9ef1792b0025575c3a8
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
55
56
57
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")));
            company.setIsValid(c.getString(c.getColumnIndex("is_valid")));
            company.setCreateTime(c.getString(c.getColumnIndex("create_time")));
            result.add(company);
        }
        return result;
 
    }
 
    //删除已上传给你服务器的数据
    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);
    }
 
}