- (NSMutableArray *)getAllSysMessageBymsgType:(long long)msgType error:(NSError **)error {
{
__block NSMutableArray * resultArray = [NSMutableArray array];
__block SSDAOSysMessage *message = nil;
__weak typeof(self) weakObj = self;
[self.dbPocrchQueue inDatabase:^(FMDatabase *db) {
__strong typeof (weakObj) strongObj = weakObj;
if (!db) {
return;
}
NSString *sql = [NSString stringWithFormat:@"select * from %@ where %@ = %lld ORDER BY %@ DESC", @"SSSysMessage", @"MSG_TYPE", msgType, @"MSGSEQ_ID"];
FMResultSet *result = [db executeQuery:sql];
while (result.next){
message = [strongObj sysMessageFromDatabaseResult:result];
[resultArray addObject:message];
}
[result close];
if ([db hadError] && error) {
*error = [db lastError];
}
}];
return resultArray;
}
}