/** * 查询 本次测量(MEASNo)及之后的所有相同断面和相同测点类型的测点信息 * * @param chainageId 断面里程ID * @param pntType 测点类型 * @param MEASNo 本次测量是第几次测量 * @return 查询到的测点信息List */ public List<SubsidenceTotalData> queryInfoAfterMEASNo( String chainageId, String pntType, int MEASNo) { final IAccessDatabase mDatabase = getCurrentDb(); if (mDatabase == null) { return null; } String sql = "select * from SubsidenceTotalData where" + " chainageId=\'" + chainageId + "\'" + " AND pntType=\'" + pntType + "\'" + " AND MEASNo >= " + String.valueOf(MEASNo) + " AND DataStatus != " + String.valueOf(AlertUtils.POINT_DATASTATUS_DISCARD) + " order by MEASNo ASC"; return mDatabase.queryObjects(sql, SubsidenceTotalData.class); }
// 是否存在测量数据 public boolean checkRawSheetIndexHasData(int sheetId) { final IAccessDatabase mDatabase = getCurrentDb(); if (mDatabase == null) { return false; } String sql = "select * from SubsidenceTotalData where SheetId = ?"; String[] args = SQLiteParamUtils.toParamemter(sheetId); List<SubsidenceTotalData> list = mDatabase.queryObjects(sql, args, SubsidenceTotalData.class); if (list == null || list.isEmpty()) { return false; } for (SubsidenceTotalData data : list) { if (!StringUtils.isEmpty(data.getCoordinate())) { return true; } } return false; }
public SubsidenceTotalData queryOneByGuid(String guid) { final IAccessDatabase mDatabase = getCurrentDb(); if (mDatabase == null) { return null; } String sql = "select * from SubsidenceTotalData where Guid = ?"; return mDatabase.queryObject(sql, new String[] {guid}, SubsidenceTotalData.class); }
public SubsidenceTotalData queryOneById(int id) { final IAccessDatabase mDatabase = getCurrentDb(); if (mDatabase == null) { return null; } String sql = "select * from SubsidenceTotalData where ID = ?"; return mDatabase.queryObject(sql, new String[] {String.valueOf(id)}, SubsidenceTotalData.class); }
// 删除测量单的所有测量数据 public void removeSubsidenceTotalDataBySheetId(int sheetid) { final IAccessDatabase mDatabase = getCurrentDb(); if (mDatabase == null) { return; } String sql = "delete from SubsidenceTotalData where SheetId = ?"; mDatabase.execute(sql, new String[] {String.valueOf(sheetid)}); }
public List<SubsidenceTotalData> queryAllOrderByMEASNoDesc(String pntType) { final IAccessDatabase mDatabase = getCurrentDb(); if (mDatabase == null) { return null; } String sql = "select * from SubsidenceTotalData where PntType=? ORDER BY MEASNo DESC"; String[] args = new String[] {pntType}; return mDatabase.queryObjects(sql, args, SubsidenceTotalData.class); }
public void updateDataStatus(String guid, int dataStatus, float correction) { IAccessDatabase db = getCurrentDb(); if (db != null) { String sql = "UPDATE SubsidenceTotalData" + " SET DataStatus=dataStatus" + ", DataCorrection=" + ((dataStatus == AlertUtils.POINT_DATASTATUS_CORRECTION) ? correction : 0f) + " WHERE Guid=?"; String[] args = new String[] {guid}; db.execute(sql, args); } }
public boolean checkSectionTestData(String guid) { final IAccessDatabase mDatabase = getCurrentDb(); if (mDatabase == null) { return false; } String sql = "select * from SubsidenceTotalData where ChainageId = ? limit 0,1"; SubsidenceTotalData data = mDatabase.queryObject(sql, new String[] {String.valueOf(guid)}, SubsidenceTotalData.class); return data != null; }
// 记录单下,该断面的测量数据 public List<SubsidenceTotalData> querySubsidenceTotalDatas(String sheetId, String chainageId) { final IAccessDatabase mDatabase = getCurrentDb(); if (mDatabase == null) { return null; } String sql = "select * from SubsidenceTotalData where SheetId = ? and ChainageId = ? order by MEASNo asc"; return mDatabase.queryObjects( sql, new String[] {String.valueOf(sheetId), String.valueOf(chainageId)}, SubsidenceTotalData.class); }
public void reset(SubsidenceTotalData bean) { if (bean == null) { return; } final IAccessDatabase mDatabase = getCurrentDb(); if (mDatabase == null) { return; } String sql = "update SubsidenceTotalData set Coordinate = \"\", SurveyTime = \"\" ,DataStatus = 0 ,MEASNo = 0 ,Info = \"\" where ID = ? "; mDatabase.execute(sql, SQLiteParamUtils.toParamemter(bean.getID())); }