Пример #1
0
  /**
   * 查询 本次测量(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);
  }
Пример #2
0
  // 是否存在测量数据
  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;
  }
Пример #3
0
  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);
  }
Пример #4
0
  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);
  }
Пример #5
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)});
  }
Пример #6
0
  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);
  }
Пример #7
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);
   }
 }
Пример #8
0
  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;
  }
Пример #9
0
  // 记录单下,该断面的测量数据
  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);
  }
Пример #10
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()));
  }