Json反序列化异常

Question

我试图运行以下代码，但得到一个异常:

类型为'Newtonsoft.Json.JsonSerializationException'的异常发生在Newtonsoft.Json.DLL中，但未在用户代码中处理

附加信息:将值"国家"转换为类型错误"LocalGasPrices.Station"。路径"，第一行，位置9.

        var jsonObj = JObject.Parse(URL);
        var results = jsonObj["stations"].Children().Values();
        var details = new List<Station>();
        foreach (JToken result in results)
        {
            var st = result.ToString();
            var searchResult = JsonConvert.DeserializeObject<Station>(st);
            details.Add(searchResult);
        }
        foreach (Station s in details)
        {
            this.txtDebug.Text += s.address;
        }

下面是json反序列化的类:

public class Status
{
    public string error { get; set; }
    public int code { get; set; }
    public string description { get; set; }
    public string message { get; set; }
}
public class GeoLocation
{
    public string city_id { get; set; }
    public string city_long { get; set; }
    public string region_short { get; set; }
    public string region_long { get; set; }
    public string country_long { get; set; }
    public string country_id { get; set; }
    public string region_id { get; set; }
}
public class Station
{
    public string country { get; set; }
    public string price { get; set; }
    public string address { get; set; }
    public string diesel { get; set; }
    public string id { get; set; }
    public string lat { get; set; }
    public string lng { get; set; }
    public string station { get; set; }
    public string region { get; set; }
    public string city { get; set; }
    public string date { get; set; }
    public string distance { get; set; }
}
public class RootObject
{
    public Status status { get; set; }
    public GeoLocation geoLocation { get; set; }
    public List<Station> stations { get; set; }
}

下面是JSON响应的一个例子:

 {
    "status": {
        "error": "NO",
        "code": 200,
        "description": "none",
        "message": "Request ok"
    },
    "geoLocation": {
        "city_id": "147",
        "city_long": "Saint-Laurent",
        "region_short": "QC",
        "region_long": "Quebec",
        "country_long": "Canada",
        "country_id": "43",
        "region_id": "35"
    },
    "stations": [
        {
            "country": "Canada",
            "price": "3.65",
            "address": "3885, Boulevard Saint-Rose",
            "diesel": "0",
            "id": "33862",
            "lat": "45.492367",
            "lng": "-73.710915",
            "station": "Shell",
            "region": "Quebec",
            "city": "Saint-Laurent",
            "date": "3 hours agp",
            "distance": "1.9km"
        }
    ]
}

Answer 1

我相信你不需要。values()在结果中，. values()选择了站点的属性。

var results = jsonObj["stations"].Children();

Answer 2

使用如下:

var details = jsonObj["stations"].Select(t => t.ToObject<Station>()).ToList();

Answer 3

将您的类名更改为JSON中的"stations"。

Answer 4

试试这样:

public class JsonData
{
  [JsonProperty("status")]
  public JObject Status{get;set;}
  [JsonProperty("geoLocation")]
  public JObject Location{get;set;}

  [JsonProperty("stations")]
  public List<JObject> Stations{get;set;}
}
public class FinalData
{
  public Status StatusField{get;set;}
  public GeoLocation LocationField{get;set;}
  public List<Station> StationsList{get;set;}
}

}

然后

JsonSerializer serializer = new JsonSerializer();
JsonReader reader = new JsonTextReader(new StringReader(your_json));
var jObj = serializer.Deserialize<JsonData>(reader);
var result = new FinalData();
result.StatusField = new Status{ message = jObj.Status["message"].ToString();};
result.LocationField = new GeoLocation{jObj.location["city_id"].ToString();};
result.StationsList = new List<Station>();
foreach(var row = jObj.Stations)
{
  result.StationsList.Add(new Station{country = row["country"].ToString(), address = row["address"].ToString()};
}

Answer 5

尝试以下操作。

首先创建一个RootObject

public class RootObject
{
public RootObject(){}
public Status status {get;set;}
public GeoLocation GeoLocation {get;set;}
public List<Stations> Stations {get;set;}
}
public class Status
{
public Status(){}
[JsonProperty("error")]
public string Error {get;set;}
//all properties
}
public class GeoLocation
{
public GeoLocation{get;set;}
[JsonProperty("city_id")]
public int CityId {get;set;}
//all properties
}
public class Station
{
public Station(){}
// all properties just like previous classes
}

:

var result = serializer.DeserializeObject<RootObject>(jsonInput);

这应该给你一个RootObject的状态，地理位置和站点列表。