sujinwen

2017-07-24 ba120c368480d2c5c5f31eee26ec954e332afd71

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

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

@@ -23,7 +23,7 @@
    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;

        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();

@@ -40,7 +40,7 @@


    //删除已上传给你服务器的数据

    public void delCompanyList(String deviceCompanyId){

        String sql="delete from company where is_synchron='N' and device_company_id="+deviceCompanyId;

        String sql="delete from company where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId);

        MainActivity.getInstance().db.execSQL(sql);

    }

}


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

@@ -4,7 +4,6 @@
import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;



import cn.com.basic.face.base.Config;

import cn.com.basic.face.base.MainActivity;



/**

@@ -149,9 +148,6 @@
    }











//#######################以上为增删改查DEMO#################################





@@ -168,16 +164,41 @@
    /**

     * 单向同步，从客户端同步到服务器端

     * @param clientTable

     * @param serviceTable

     */

    public static void clientToService(String clientTable,String serviceTable){



    public static void clientToService(String clientTable){

    //public  Cursor query(String table,String[] columns,String selection,String[]  selectionArgs,String groupBy,String having,String orderBy,String limit);

        SQLiteDatabase db = MainActivity.getInstance().db;



        db.execSQL("");

        db.endTransaction();

        //1.根据上次同步时间找出需要上传的数据



        db.execSQL("");

        //1.根据上次同步时间找出需要上传的数据



        //2.发送数据给服务器端



        String selection="is_synchron=?";

        String[] selectionArgs=new String[]{"N"};

        String orderBy="update_time desc";

        Cursor cursor = db.query(clientTable,null,selection,selectionArgs,null,null,orderBy,null);



        while (cursor.moveToNext())

        {

            int useid = cursor.getInt(cursor.getColumnIndex("useid"));

            String date = cursor.getString(cursor.getColumnIndex("date"));

            String content = cursor.getString(cursor.getColumnIndex("content"));

            int  fangxiang =cursor.getShort(cursor.getColumnIndex("dirr"));

            boolean dirr;

    }



        cursor.close();

        db.close();



    }









    /**

     * 单向同步，从服务端同步到客户端

     * @param clientTable