这是我的json字符串.
{
"?xml" : {
"@version" : "1.0","@encoding" : "UTF-8"
},"DataFeed" : {
"@FeedName" : "issuerDetails","SecurityDetails" : {
"Security" : {
"SecurityID" : {
"@idValue" : "AAPL-NSDQ","@fiscalYearEnd" : "2016-12-31T00:00:00.00"
},"FinancialModels" : {
"FinancialModel" : [{
"@id" : "780","@name" : "Estimates - Energy","@clientCode" : "A","Values" : [{
"@name" : "EBITDA","@clientCode" : "EBITDA","@currency" : "C$","Value" : [{
"@year" : "2014","#text" : "555.64"
},{
"@year" : "2015","#text" : "-538.986"
},{
"@year" : "2016","#text" : "554.447"
},{
"@year" : "2017","#text" : "551.091"
},{
"@year" : "2018","#text" : "0"
}
]
},{
"@name" : "EPS","@clientCode" : "EPS","#text" : "0"
},"#text" : "-1.667"
},"#text" : "-1.212"
},"#text" : "0.202"
},{
"@name" : "CFPS","@clientCode" : "CFPS","#text" : "3.196"
},"#text" : "-0.207"
},"#text" : "0.599"
},"#text" : "2.408"
},"#text" : "0"
}
]
}
]
}
]
}
}
}
}
}
如何为2015年,2016年,2017年的EPS选择#text数据？这是我到目前为止的查询：
JObject jsonFeed = JObject.Parse(jsonText); var query = from security in jsonFeed.SelectTokens("DataFeed.SecurityDetails.Security") .SelectMany(i => i.ObjectsOrSelf()) let finModels = security.SelectTokens("FinancialModels.FinancialModel") .SelectMany(s => s.ObjectsOrSelf()).FirstOrDefault() where finModels != null select new { FinModelClientCode = (string)finModels.SelectToken("Values[1].@clientCode"),FinModelYear2015 = (string)finModels.SelectToken("Values[1].Value[1].@year"),FinModelValue2015 = (string)finModels.SelectToken("Values[1].Value[1].#text"),FinModelYear2016 = (string)finModels.SelectToken("Values[1].Value[2].@year"),FinModelValue2016 = (string)finModels.SelectToken("Values[1].Value[2].#text"),FinModelYear2017 = (string)finModels.SelectToken("Values[1].Value[3].@year"),FinModelValue2017 = (string)finModels.SelectToken("Values[1].Value[3].#text"),};
这是我正在使用的jsonExtensions：
public static class JsonExtensions
{
public static IEnumerable<JToken> DescendantsAndSelf(this JToken node)
{
if (node == null)
return Enumerable.Empty<JToken>();
var container = node as JContainer;
if (container != null)
return container.DescendantsAndSelf();
else
return new[] { node };
}
public static IEnumerable<JObject> ObjectsOrSelf(this JToken root)
{
if (root is JObject)
yield return (JObject)root;
else if (root is JContainer)
foreach (var item in ((JContainer)root).Children())
foreach (var child in item.ObjectsOrSelf())
yield return child;
else
yield break;
}
public static IEnumerable<JToken> SingleOrMultiple(this JToken source)
{
IEnumerable<JToken> arr = source as JArray;
return arr ?? new[] { source };
}
}
问题是EPS对于下一家公司并不总是处于同一位置？所以,我希望查询搜索EPS客户端代码&返回上述年份的值,希望使用DRY方法.你能帮我完成我的查询吗？
注意：我实际上是在下载XML字符串,将其转换为JSON然后解析它.
XmlDocument doc = new XmlDocument(); doc.LoadXml(xmlString); jsonText = Newtonsoft.Json.JsonConvert.SerializeXmlNode(doc); JObject jsonFeed = JObject.Parse(jsonText);
解决方法
我认为最简单的方法是将json反序列化为如下所示的具体对象
var root = JsonConvert.DeserializeObject<RootObject>(jsonstring);
你的模型会是
public class SecurityID
{
[JsonProperty("@idValue")]
public string IdValue { get; set; }
[JsonProperty("@iscalYearEnd")]
public string FiscalYearEnd { get; set; }
}
public class Time
{
[JsonProperty("@year")]
public string Year { get; set; }
[JsonProperty("#text")]
public string Text { get; set; }
}
public class FinancialModelItem
{
[JsonProperty("@name")]
public string Name { get; set; }
[JsonProperty("@clientCode")]
public string ClientCode { get; set; }
[JsonProperty("@currency")]
public string Currency { get; set; }
public List<Time> Value { get; set; }
}
public class FinancialModel
{
[JsonProperty("@id")]
public string Id { get; set; }
[JsonProperty("@name")]
public string Name { get; set; }
[JsonProperty("@clientCode")]
public string ClientCode { get; set; }
public List<FinancialModelItem> Values { get; set; }
}
public class FinancialModels
{
public List<FinancialModel> FinancialModel { get; set; }
}
public class Security
{
public SecurityID SecurityID { get; set; }
public FinancialModels FinancialModels { get; set; }
}
public class SecurityDetails
{
public Security Security { get; set; }
}
public class DataFeed
{
[JsonProperty("@FeedName")]
public string FeedName { get; set; }
public SecurityDetails SecurityDetails { get; set; }
}
public class Xml
{
[JsonProperty("@version")]
public string Version { get; set; }
[JsonProperty("@encoding")]
public string Encoding { get; set; }
}
public class RootObject
{
[JsonProperty("?xml")]
public Xml Xml { get; set; }
public DataFeed DataFeed { get; set; }
}
现在你的查询就是
var result = root.DataFeed.SecurityDetails.Security.FinancialModels.FinancialModel .FirstOrDefault()?.Values .FirstOrDefault(x => x.Name == "EPS") .Value .Where(x => new[] { "2015","2016","2017" }.Contains(x.Year)) .Select(x => x.Text) .ToList();
