| | |
| | | device.setType(c.getString(c.getColumnIndex("type")));
|
| | | device.setSchoolName(c.getString(c.getColumnIndex("school_name")));
|
| | | device.setScrappedDate(c.getString(c.getColumnIndex("scrapped_date")));
|
| | | device.setIsValid(c.getString(c.getColumnIndex("is_valid")));
|
| | | device.setCreateTime(c.getString(c.getColumnIndex("create_time")));
|
| | | result.add(device);
|
| | | }
|
| | | return result;
|
| | |
| | | public int getSynDataCount(){
|
| | | String sql="select count(*) from device where is_synchron='N' ";
|
| | | Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{});
|
| | | return c.getCount();
|
| | | c.moveToFirst();
|
| | | return c.getInt(0);
|
| | | }
|
| | |
|
| | | }
|