xuxiuxi

2017-07-23 d9129dafb57f57f629c5d6203eecba67a6c839f4

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

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

@@ -103,7 +103,6 @@
                resultBean.setTotalPages(getTotalPageSize(total));

                resultBean.setPageNum(pageNum);

                resultBean.setData(list);

                c.close();

                return  resultBean;

            } catch (Exception e) {

                e.printStackTrace();

@@ -226,7 +225,6 @@
            resultBean.setTotalPages(getTotalPageSize(total));

            resultBean.setPageNum(1);

            resultBean.setData(list);

            c.close();

            return  resultBean;

        } catch (Exception e) {

            e.printStackTrace();


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

@@ -5,6 +5,7 @@
import android.database.sqlite.SQLiteDatabase;



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

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



/**

 *    数据同步dao层

@@ -171,10 +172,8 @@
     */

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



        SQLiteDatabase db = Config.sqlMap.getDb();

        db.beginTransaction();

        SQLiteDatabase db = MainActivity.getInstance().db;

        db.execSQL("");

        db.endTransaction();

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



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


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

@@ -34,8 +34,6 @@
                aqi.setName(c.getString((c.getColumnIndex("dept_name"))));

                list.add(aqi);

            }

            c.close();



        }catch (Exception e) {

            e.printStackTrace();

        }


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

@@ -72,8 +72,6 @@


                list.add(aqi);

            }

            c.close();



        }catch (Exception e) {

            e.printStackTrace();

        }


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

@@ -69,7 +69,7 @@
            }

            Integer total = null;

            while (c_count.moveToNext()) {

                total = c.getInt(c.getColumnIndex("count"));

                total = c.getInt(0);

            }

            resultBean.setTotalPages(getTotalPageSize(total));

            resultBean.setPageNum(pageNum);


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

@@ -40,8 +40,6 @@
                aqi.setName(c.getString((c.getColumnIndex("post_name"))));

                list.add(aqi);

            }

            c.close();



        }catch (Exception e) {

            e.printStackTrace();

        }


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

@@ -82,13 +82,13 @@
    }



    public boolean hasOfflineVisitorRegisterData() {

        Cursor c = Config.sqlMap.getDb().rawQuery("select count(*) from register", new String[]{});

        Cursor c = MainActivity.getInstance().db.rawQuery("select count(*) from register", new String[]{});

        c.moveToFirst();

        return c.getInt(0) > 0 ? true : false;

    }



    public boolean hasOfflineAttenderRegisterData() {

        Cursor c = Config.sqlMap.getDb().rawQuery("select count(*) from register", new String[]{});

        Cursor c = MainActivity.getInstance().db.rawQuery("select count(*) from register", new String[]{});

        c.moveToFirst();

        return c.getInt(0) > 0 ? true : false;

    }

@@ -164,10 +164,8 @@
    public void removeOfflineVisitorRegister(OfflineVisitorRegisterItem item) {

        try {

            String sql = "delete from register where visitor_id='"+item.getRegisterId()+"' AND a.is_synchron = 'N'";

            SQLiteDatabase db = Config.sqlMap.getDb();

            db.beginTransaction();

            SQLiteDatabase db = MainActivity.getInstance().db;

            db.execSQL(sql);

            db.endTransaction();

            item.deleteFiles();

        }

        catch (Exception e) {