如何使用 json.net 反序列化复杂的分离("Column"/"Data")json到c#对象

Question

我需要将以下JSON解析为PackageEntity Object的列表。

由于这个json被分为列和数据，我有麻烦这样做在一个智能的方式。

JSON格式如下:

{
  "COLUMNS": ["NSHIPMENTID", "NSHIPPINGCOMPANYID", "NUSERID", "NWEIGHT", "NHEIGHT"],
  "DATA": [
      [7474, null, 12363, "16", "2"],
      [7593, null, 12363, "64", "7"]
  ]
}

我想将它反序列化为以下类的列表:

public class PackageEntity
{
    public int NSHIPMENTID  { get; set; }
    public string NSHIPPINGCOMPANYID  { get; set; }
    public int NUSERID  { get; set; }
    public decimal NWEIGHT  { get; set; }
    public decimal NHEIGHT { get; set; }
} 

到目前为止我做了什么:

JObject JsonDe = JObject.Parse(responseString);
                int length = JsonDe.Property("DATA").Value.ToArray().Count();
                List<PackageEntity> _list = new List<PackageEntity>();
                for (int i = 0; i < length; i++)
                {
                    PackageEntity pD = new PackageEntity();
                    pD.NSHIPMENTID = JsonDe.Property("DATA").Value.ToArray()[i][0].ToString();
                    pD.NSHIPPINGCOMPANYID = JsonDe.Property("DATA").Value.ToArray()[i][1].ToString();
                    pD.NUSERID = JsonDe.Property("DATA").Value.ToArray()[i][2].ToString();
                    pD.NWEIGHT = JsonDe.Property("DATA").Value.ToArray()[i][3].ToString();
                    pD.NHEIGHT = JsonDe.Property("DATA").Value.ToArray()[i][4].ToString();
                    _list.Add(pD);
                }

Answer 1

您可以使用以下通用自定义JsonConverter来反序列化您的数据:

public class ColumnarDataToListConverter<T> : JsonConverter
{
    public override bool CanConvert(Type objectType)
    {
        return objectType == typeof(List<T>);
    }
    public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)
    {
        if (reader.TokenType == JsonToken.Null)
            return null;
        var list = existingValue as List<T> ?? new List<T>();
        var obj = JObject.Load(reader);
        var columns = obj["COLUMNS"] as JArray;
        var data = obj["DATA"] as JArray;
        if (data == null)
            return list;
        list.AddRange(data
            .Select(item => new JObject(columns.Zip(item, (c, v) => new JProperty((string)c, v))))
            .Select(o => o.ToObject<T>(serializer)));
        return list;
    }
    public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
    {
        throw new NotImplementedException();
    }
}

然后按如下方式使用:

var settings = new JsonSerializerSettings { Converters = new[] { new ColumnarDataToListConverter<PackageEntity>() } };
var list = JsonConvert.DeserializeObject<List<PackageEntity>>(responseString, settings);

注意，使用Enumerable.Zip()将列数组中的项与数据数组的每一行中的项配对到一个临时的JObject中用于反序列化。