/**
* 查询 本次测量(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()));
}