예제 #1
0
  // 删除测量单的所有测量数据
  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)});
  }
예제 #2
0
 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);
   }
 }
예제 #3
0
  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()));
  }