sujinwen

2017-07-24 1a10d546c76f474d33e23c5958c08aa0afcdae67

git-svn-id: http://192.168.1.226/svn/proxy@845 454eff88-639b-444f-9e54-f578c98de674

 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CompanyDao.java

New file
@@ -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;



    }





}