将这段代码改为按照收缩压和舒张压的分级范围查询,分别取数据中的收缩压和舒张压和分级规则中的收缩压取值范围和舒张压取值范围比较,要有是否需要同时满足舒张压和收缩压范围的选项,不再按照value值查询,不修改原有其他的逻辑。- (NSMutableArray *)getBloodPresureDataField:(NSString *)field value:(NSInteger)value startTime:(NSTimeInterval)startTime endTime:(NSTimeInterval)endTime { __block NSMutableArray *array = [NSMutableArray array]; [[HWFitnessMgr sharedInstance] excuteInTransaction:^(FMDatabase *db ,BOOL * rollBack) { NSMutableString *rs = [NSMutableString string]; [rs appendString:@" where"]; //此处逻辑:若搜索字段不为COLUMN_SYNC_CLOUD_STATUS去掉本地已删除未上云的数据 if ([field isEqualToString:COLUMN_SYNC_CLOUD_STATUS]) { [rs appendFormat:@" %@ >= %.0lf and %@ <= %.0lf and %@ = %ld", Column_TimeStamp, startTime, Column_TimeStamp, endTime, field, (long)value]; } else { [rs appendFormat:@" %@ >= %.0lf and %@ <= %.0lf and %@ = %ld and %@ != %ld", Column_TimeStamp, startTime, Column_TimeStamp, endTime, field, (long)value, COLUMN_SYNC_CLOUD_STATUS, (long)HWHealthDataSyncCloudStatusDeleteNotSync]; } [rs appendFormat:@" order by %@ desc", Column_TimeStamp]; NSString *strSql = [@"select * from '%@'" stringByAppendingString:rs]; NSString *bloodPressureTable = [self getTableName:FitnessSamplePointBloodPressureTable]; FMResultSet * detailRs = [[HWFitnessMgr sharedInstance] selectBy:strSql andTable:bloodPressureTable inDatabase:db]; if (detailRs) { while ([detailRs next]) { [array addObject:[self fetchBloodPressureDataWithDetailRs:detailRs]]; } [detailRs close]; } }]; return array; }
时间: 2023-06-20 21:06:18 浏览: 45
首先,将代码中的 value 参数改为一个字典,其中包含收缩压和舒张压的值,例如:
```
- (NSMutableArray *)getBloodPresureDataField:(NSString *)field range:(NSDictionary *)range startTime:(NSTimeInterval)startTime endTime:(NSTimeInterval)endTime requireBoth:(BOOL)requireBoth {
__block NSMutableArray *array = [NSMutableArray array];
[[HWFitnessMgr sharedInstance] excuteInTransaction:^(FMDatabase *db ,BOOL * rollBack) {
NSMutableString *rs = [NSMutableString string];
[rs appendString:@" where"];
//此处逻辑:若搜索字段不为COLUMN_SYNC_CLOUD_STATUS去掉本地已删除未上云的数据
if ([field isEqualToString:COLUMN_SYNC_CLOUD_STATUS]) {
[rs appendFormat:@" %@ >= %.0lf and %@ <= %.0lf and %@ >= %ld and %@ <= %ld", Column_TimeStamp, startTime, Column_TimeStamp, endTime, Column_BloodPressureSystolic, [range[@"systolicMin"] integerValue], Column_BloodPressureSystolic, [range[@"systolicMax"] integerValue]];
if (requireBoth) {
[rs appendFormat:@" and %@ >= %ld and %@ <= %ld", Column_BloodPressureDiastolic, [range[@"diastolicMin"] integerValue], Column_BloodPressureDiastolic, [range[@"diastolicMax"] integerValue]];
} else {
[rs appendFormat:@" or (%@ >= %ld and %@ <= %ld)", Column_BloodPressureDiastolic, [range[@"diastolicMin"] integerValue], Column_BloodPressureDiastolic, [range[@"diastolicMax"] integerValue]];
}
} else {
[rs appendFormat:@" %@ >= %.0lf and %@ <= %.0lf and %@ = %ld and %@ != %ld and %@ >= %ld and %@ <= %ld", Column_TimeStamp, startTime, Column_TimeStamp, endTime, field, (long)HWHealthDataCategoryBloodPressure, COLUMN_SYNC_CLOUD_STATUS, (long)HWHealthDataSyncCloudStatusDeleteNotSync, Column_BloodPressureSystolic, [range[@"systolicMin"] integerValue], Column_BloodPressureSystolic, [range[@"systolicMax"] integerValue]];
if (requireBoth) {
[rs appendFormat:@" and %@ >= %ld and %@ <= %ld", Column_BloodPressureDiastolic, [range[@"diastolicMin"] integerValue], Column_BloodPressureDiastolic, [range[@"diastolicMax"] integerValue]];
} else {
[rs appendFormat:@" or (%@ >= %ld and %@ <= %ld)", Column_BloodPressureDiastolic, [range[@"diastolicMin"] integerValue], Column_BloodPressureDiastolic, [range[@"diastolicMax"] integerValue]];
}
}
[rs appendFormat:@" order by %@ desc", Column_TimeStamp];
NSString *strSql = [NSString stringWithFormat:@"select * from '%@'%@", [self getTableName:FitnessSamplePointBloodPressureTable], rs];
FMResultSet * detailRs = [[HWFitnessMgr sharedInstance] selectBy:strSql andTable:[self getTableName:FitnessSamplePointBloodPressureTable] inDatabase:db];
if (detailRs) {
while ([detailRs next]) {
[array addObject:[self fetchBloodPressureDataWithDetailRs:detailRs]];
}
[detailRs close];
}
}];
return array;
}
```
然后,根据参数 `range` 中的收缩压和舒张压的取值范围,以及参数 `requireBoth` 是否需要同时满足收缩压和舒张压的范围,生成 SQL 查询语句。具体地:
- 如果搜索字段为 `COLUMN_SYNC_CLOUD_STATUS`,则生成的查询语句为:
```
Column_TimeStamp >= startTime and Column_TimeStamp <= endTime and Column_BloodPressureSystolic >= systolicMin and Column_BloodPressureSystolic <= systolicMax
```
如果需要同时满足舒张压的范围,查询语句为:
```
Column_TimeStamp >= startTime and Column_TimeStamp <= endTime and Column_BloodPressureSystolic >= systolicMin and Column_BloodPressureSystolic <= systolicMax and Column_BloodPressureDiastolic >= diastolicMin and Column_BloodPressureDiastolic <= diastolicMax
```
如果不需要同时满足舒张压的范围,查询语句为:
```
Column_TimeStamp >= startTime and Column_TimeStamp <= endTime and Column_BloodPressureSystolic >= systolicMin and Column_BloodPressureSystolic <= systolicMax and (Column_BloodPressureDiastolic >= diastolicMin or Column_BloodPressureDiastolic <= diastolicMax)
```
- 如果搜索字段不为 `COLUMN_SYNC_CLOUD_STATUS`,则生成的查询语句为:
```
Column_TimeStamp >= startTime and Column_TimeStamp <= endTime and %@ = %ld and %@ != %ld and Column_BloodPressureSystolic >= systolicMin and Column_BloodPressureSystolic <= systolicMax
```
如果需要同时满足舒张压的范围,查询语句为:
```
Column_TimeStamp >= startTime and Column_TimeStamp <= endTime and %@ = %ld and %@ != %ld and Column_BloodPressureSystolic >= systolicMin and Column_BloodPressureSystolic <= systolicMax and Column_BloodPressureDiastolic >= diastolicMin and Column_BloodPressureDiastolic <= diastolicMax
```
如果不需要同时满足舒张压的范围,查询语句为:
```
Column_TimeStamp >= startTime and Column_TimeStamp <= endTime and %@ = %ld and %@ != %ld and Column_BloodPressureSystolic >= systolicMin and Column_BloodPressureSystolic <= systolicMax and (Column_BloodPressureDiastolic >= diastolicMin or Column_BloodPressureDiastolic <= diastolicMax)
```
其中,`%@` 分别表示搜索字段的占位符,需要根据实际情况进行替换。