JSON 列转行的一小段无用代码

json:

[{"iTagID":9,"cTag":"Liuxx测试-标签-1","cUnit":"TT","values":[{"serial_number":1,"cDate":"2012-11-05","fValue":30},{"serial_number":2,"cDate":"2013-01-10","fValue":400},{"serial_number":3,"cDate":"2013-01-13","fValue":200},{"serial_number":4,"cDate":"2013-01-16","fValue":200},{"serial_number":5,"cDate":"2013-01-16","fValue":290},{"serial_number":6,"cDate":"2013-01-16","fValue":350},{"serial_number":7,"cDate":"2013-01-16","fValue":310},{"serial_number":8,"cDate":"2013-01-17","fValue":200},{"serial_number":9,"cDate":"2013-01-17","fValue":15},{"serial_number":10,"cDate":"2013-01-17","fValue":20},{"serial_number":11,"cDate":"2013-05-17","fValue":30}]},{"iTagID":10,"cTag":"Liuxx测试-标签-2","cUnit":"VAR","values":[{"serial_number":1,"cDate":"2012-11-05","fValue":60},{"serial_number":2,"cDate":"2013-01-10","fValue":100},{"serial_number":3,"cDate":"2013-01-13","fValue":50},{"serial_number":4,"cDate":"2013-01-16","fValue":100},{"serial_number":5,"cDate":"2013-01-16","fValue":109},{"serial_number":6,"cDate":"2013-01-16","fValue":200},{"serial_number":7,"cDate":"2013-01-16","fValue":300},{"serial_number":8,"cDate":"2013-01-17","fValue":50},{"serial_number":9,"cDate":"2013-01-17","fValue":16},{"serial_number":10,"cDate":"2013-01-17","fValue":30},{"serial_number":11,"cDate":"2013-05-17","fValue":60}]},{"iTagID":11,"cTag":"Liuxx测试-标签-3","cUnit":"VARh","values":[{"serial_number":1,"cDate":"2013-01-16","fValue":1630}]},{"iTagID":12,"cTag":"Liuxx测试-标签-4","cUnit":"W","values":[{"serial_number":1,"cDate":"2013-01-09","fValue":3},{"serial_number":2,"cDate":"2013-01-13","fValue":5},{"serial_number":3,"cDate":"2013-01-14","fValue":6},{"serial_number":4,"cDate":"2013-01-16","fValue":9}]}]

NSMutableArray *tempSection = [NSMutableArray arrayWithCapacity:10];
             
             NSMutableArray *headArray = nil;
             for (id ele in json)
             {
                 NSDictionary *dict = @{
                 @"tag" : [NSString stringWithFormat:@"%@", [ele objectForKey:@"cTag"]],
                 @"unit": [NSString stringWithFormat:@"%@", [ele objectForKey:@"cUnit"]]
                 };
                 if(headArray == nil)
                 {
                     headArray = [NSMutableArray arrayWithObject:dict];
                 }
                 else
                 {                     
                     [headArray addObject:dict];
                 }
             }
             int iColumnCount =0;
             for(int i=0; i<[json count]; i++)
             {
                 iColumnCount = MAX(iColumnCount, [[json[i] objectForKey:@"values"] count]);
                 for(int j=0;j<iColumnCount;j++)
                 {
                     if([tempSection count] == j) //在数据行数组中再加一行
                     {
                         NSMutableArray *rowArray = [NSMutableArray arrayWithCapacity:10];
                         [tempSection addObject:rowArray];
                     }
                     if(j >= [[json[i] objectForKey:@"values"] count]) //放空占位符
                     {
                         [tempSection[j] addObject:[NSNull null]];
                         continue;
                     }
                     id colValue1 = [[json[i] objectForKey:@"values"][j] objectForKey:@"serial_number"];
                     id colValue2 = [[json[i] objectForKey:@"values"][j] objectForKey:@"cDate"] == nil ? @"" : [[json[i] objectForKey:@"values"][j] objectForKey:@"cDate"] ;
                     id colValue3 = [[json[i] objectForKey:@"values"][j] objectForKey:@"fValue"];                    
                                         
                     [tempSection[j] addObject:@{@"serial_number":colValue1, @"date":colValue2, @"value":colValue3}];
                 }
             }

             [tempSection insertObject:headArray atIndex:0];

效果图：