| | |
| | | String headPicture = "";
|
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
| | | String createTime = sdf.format(new Date());
|
| | | String surveillanceId = UUID.randomUUID().toString();
|
| | | String deviceId = BaseApplication.getInstance().getAndroidDevice().getDeviceId();
|
| | | MainActivity.getInstance().db.execSQL(
|
| | | "insert into offline_surveillance(raw_data_path, camera_in_or_out, create_time) values('" +
|
| | | "insert into offline_surveillance(surveillance_id,device_id,raw_data_path, camera_in_or_out, create_time,device_company_id) values('" +
|
| | | surveillanceId + "','" +
|
| | | deviceId + "','" +
|
| | | rawDataFileName + "','" +
|
| | | cameraInOrOut + "','" +
|
| | | createTime + "'" +")"
|
| | | createTime + "','" +
|
| | | BaseApplication.getInstance().getAndroidDevice().getCompanyId() + "'" +")"
|
| | | );
|
| | |
|
| | | } catch (Exception e) {
|
| | |
| | | result=new OfflineSurveillance();
|
| | | result.setDeviceCompanyId(deviceCompanyId);
|
| | | result.setDeviceId(deviceId);
|
| | | result.setCamera_in_or_out(c.getString(c.getColumnIndex("camera_in_or_out")));
|
| | | result.setCreate_time(c.getString(c.getColumnIndex("create_time")));
|
| | | result.setCameraInOrOut(c.getString(c.getColumnIndex("camera_in_or_out")));
|
| | | result.setCreateTime(c.getString(c.getColumnIndex("create_time")));
|
| | | result.setRawDataPath(c.getString(c.getColumnIndex("raw_data_path")));
|
| | | result.setSurveillanceId(c.getString(c.getColumnIndex("surveillance_id")));
|
| | | list.add(result);
|