VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/DeviceDao.java
@@ -1,15 +1,12 @@ package cn.com.basic.face.service.sqlite; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import java.util.ArrayList; import java.util.List; import cn.com.basic.face.base.Config; import cn.com.basic.face.base.MainActivity; import cn.com.basic.face.discern.entity.Device; import cn.com.basic.face.discern.entity.Dictionary; /** * 设备Dao @@ -137,4 +134,51 @@ return list; } public List<Device> getDeviceList(String deviceCompanyId){ String sql="select * from device WHERE is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId); Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{}); List<Device> result=new ArrayList<Device>(); Device device=null; if(c.moveToFirst()){ device=new Device(); device.setUpdateTime(c.getString(c.getColumnIndex("update_time"))); device.setIsSynchron(c.getString(c.getColumnIndex("is_synchron"))); device.setDeviceCompanyId(c.getString(c.getColumnIndex("device_company_id"))); device.setBelongId(c.getString(c.getColumnIndex("belong_id"))); device.setBrandId(c.getString(c.getColumnIndex("brand_id"))); device.setCompanyId(c.getString(c.getColumnIndex("company_id"))); device.setDeviceName(c.getString(c.getColumnIndex("device_name"))); device.setDeviceId(c.getString(c.getColumnIndex("device_id"))); device.setInstallAddress(c.getString(c.getColumnIndex("install_address"))); device.setInstallCompany(c.getString(c.getColumnIndex("install_company"))); device.setInstallTime(c.getString(c.getColumnIndex("install_time"))); device.setIp(c.getString(c.getColumnIndex("ip"))); device.setManufacturer(c.getString(c.getColumnIndex("manufacturer"))); device.setPassword(c.getString(c.getColumnIndex("password"))); device.setPort(c.getString(c.getColumnIndex("port"))); device.setPrincipal(c.getString(c.getColumnIndex("principal"))); device.setRemark(c.getString(c.getColumnIndex("remark"))); device.setResolutionId(c.getString(c.getColumnIndex("resolution_id"))); device.setProductionDate(c.getString(c.getColumnIndex("production_date"))); device.setProtocolId(c.getString(c.getColumnIndex("protocol_id"))); device.setUsername(c.getString(c.getColumnIndex("username"))); device.setSn(c.getString(c.getColumnIndex("sn"))); device.setType(c.getString(c.getColumnIndex("type"))); device.setSchoolName(c.getString(c.getColumnIndex("school_name"))); device.setScrappedDate(c.getString(c.getColumnIndex("scrapped_date"))); result.add(device); } return result; } //删除已经上传到服务器的同步数据 public void delDevice(String deviceCompanyId){ String sql="delete from device 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/DictionaryDao.java
@@ -1,15 +1,10 @@ package cn.com.basic.face.service.sqlite; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import cn.com.basic.face.base.BaseApplication; import cn.com.basic.face.base.Config; import cn.com.basic.face.base.MainActivity; import cn.com.basic.face.discern.common.CommonVariables; import cn.com.basic.face.discern.entity.Dictionary; @@ -147,4 +142,37 @@ return list; } } //加载需要同步的数据 public List<Dictionary> getDictionayList(String deviceCompanyId){ String sql="select * from dictionary WHERE is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId); Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{}); List<Dictionary> result=new ArrayList<Dictionary>(); Dictionary dic=null; if(c.moveToFirst()){ dic=new Dictionary(); dic.setSn(c.getString(c.getColumnIndex("sn"))); dic.setType(c.getString(c.getColumnIndex("type"))); dic.setCompnayId(c.getString(c.getColumnIndex("compnay_id"))); dic.setDeviceCompanyId(c.getString(c.getColumnIndex("device_company_id"))); dic.setDictId(c.getString(c.getColumnIndex("dict_id"))); dic.setIsSynchron(c.getString(c.getColumnIndex("is_synchron"))); dic.setUpdateTime(c.getString(c.getColumnIndex("update_time"))); dic.setName(c.getString(c.getColumnIndex("name"))); dic.setOrderBy(c.getString(c.getColumnIndex("order_by"))); dic.setPid(c.getString(c.getColumnIndex("pid"))); dic.setRemark(c.getString(c.getColumnIndex("remark"))); result.add(dic); } return result; } //删除已经上传到服务器的数据 public void delDictionary(String deviceCompanyId){ String sql="delete from dictionary where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId); MainActivity.getInstance().db.execSQL(sql); } }
New file @@ -0,0 +1,46 @@ package cn.com.basic.face.service.sqlite; import android.database.Cursor; import java.util.ArrayList; import java.util.List; import cn.com.basic.face.base.MainActivity; import cn.com.basic.face.discern.entity.Employee; /** * Created by SJW on 2017/7/24 0024. */ public class EmployeeDao { public static EmployeeDao instance=new EmployeeDao(); public static EmployeeDao getInstance(){ return instance; } //加载需要同步的数据 public List<Employee> getEmployeeList(String deviceCompanyId){ String sql="select * from employee where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId); Cursor c = MainActivity.getInstance().db.rawQuery(sql,new String[]{}); List<Employee> result=new ArrayList<Employee>(); Employee emp=null; if(c.moveToFirst()){ emp=new Employee(); emp.setIsSynchron(c.getString(c.getColumnIndex("is_synchron"))); emp.setUpdateTime(c.getString(c.getColumnIndex("update_time"))); emp.setDeviceCompanyId(c.getString(c.getColumnIndex("device_company_id"))); emp.setRegisterId(c.getString(c.getColumnIndex("register_id"))); result.add(emp); } return result; } //删除已经上传到服务器的数据 public void delEmployee(String deviceCompanyId){ String sql="delete from employee where is_synchron='N' and device_company_id="+Integer.parseInt(deviceCompanyId); MainActivity.getInstance().db.execSQL(sql); } }
