| | |
| | | package cn.com.basic.face.service.sqlite;
|
| | |
|
| | | import android.content.ContentValues;
|
| | | import android.database.Cursor;
|
| | |
|
| | | import java.util.ArrayList;
|
| | |
| | | //获取未同步数据总数
|
| | | public int getSynDataCount(){
|
| | | String sql="select count(*) from device where is_synchron='N' ";
|
| | | Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{});
|
| | | Cursor c = MainActivity.getInstance().db.rawQuery(sql,new String[]{});
|
| | | c.moveToFirst();
|
| | | return c.getInt(0);
|
| | | }
|
| | |
|
| | | public void updateCamera(Device camera) {
|
| | | String strFilter = "device_id=" + camera.getDeviceId();
|
| | | ContentValues args = new ContentValues();
|
| | | args.put("brand", camera.getBrand());
|
| | | args.put("brand_id", camera.getBrandId());
|
| | | args.put("ip", camera.getIp());
|
| | | args.put("port", camera.getPort());
|
| | | args.put("resolution", camera.getResolution());
|
| | | args.put("resolutionId", camera.getResolutionId());
|
| | | args.put("username", camera.getUsername());
|
| | | args.put("password", camera.getPassword());
|
| | | MainActivity.getInstance().db.update("device", args, strFilter, null);
|
| | | }
|
| | |
|
| | | public void updateAndroidDevice(Device androidDevice) {
|
| | | String strFilter = "device_id=" + androidDevice.getDeviceId();
|
| | | ContentValues args = new ContentValues();
|
| | | args.put("school_name", androidDevice.getSchoolName());
|
| | | args.put("sn", androidDevice.getSn());
|
| | | args.put("install_address", androidDevice.getInstallAddress());
|
| | | MainActivity.getInstance().db.update("device", args, strFilter, null);
|
| | | }
|
| | |
|
| | | }
|