// 删除测量单的所有测量数据
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 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 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()));
}