LINQ to XML查询中的格式错误

本文关键字：格式 错误 查询 to XML LINQ | 更新日期: 2023-09-27 18:21:28

我正试图解决通过yql从雅虎金融返回的股票市场数据的LINQ到XML查询的问题。其中一些字段要么带有错误格式的数据，要么带有空值。我当前的错误是：

输入字符串的格式不正确。

我为我感兴趣的每个元素添加了一个检查null，但错误仍然存在。

如果有帮助的话，突出显示的引发异常的代码部分是包含我的数据点对象的"新"初始化的块。如果XML通过了查询中的检查，那么在初始化DailyPricingVolDP时将null传递给构造函数时，它将引发错误。

Func<string, DateTime?> tryToGetDate =
    value =>
    {
        DateTime dateValue;
        return DateTime.TryParse(value, out dateValue)
            ? (DateTime?)dateValue
            : null;
    };
XDocument doc = XDocument.Load(addressString);
XElement results = doc.Root.Element("results");
CultureInfo enUS = new CultureInfo("en-US");
DateTime targetDate = new DateTime(2012, 1, 25);
var makeInfo =
    from s in doc.Descendants("quote")
    where s.Element("LastTradeDate") != null
       && s.Attribute("symbol") != null
    let dateStr = s.Element("LastTradeDate").Value
    let dateValue = tryToGetDate(dateStr)
    where dateValue != null && (DateTime)dateValue == targetDate
       && s.Element("Open") != null && s.Element("DaysHigh") != null
       && s.Element("DaysLow") != null && s.Element("LastTradePriceOnly") != null
       && s.Element("Volume") != null
    select new DailyPricingVolDP(
        (string)s.Attribute("symbol"),
        (DateTime)s.Element("LastTradeDate"),
        (double)s.Element("Open"),
        (double)s.Element("DaysHigh"),
        (double)s.Element("DaysLow"),
        (double)s.Element("LastTradePriceOnly"),
        (long)s.Element("Volume"));

<quote symbol="AFFM">
  <Ask>0.89</Ask>
  <AverageDailyVolume>6523</AverageDailyVolume>
  <Bid>0.67</Bid>
  <AskRealtime>0.89</AskRealtime>
  <BidRealtime>0.67</BidRealtime>
  <BookValue>4.804</BookValue>
  <Change_PercentChange>0.00 - 0.00%</Change_PercentChange>
  <Change>0.00</Change>
  <Commission />
  <ChangeRealtime>0.00</ChangeRealtime>
  <AfterHoursChangeRealtime>N/A - N/A</AfterHoursChangeRealtime>
  <DividendShare>0.00</DividendShare>
  <LastTradeDate>1/25/2012</LastTradeDate>
  <TradeDate />
  <EarningsShare>-4.491</EarningsShare>
  <ErrorIndicationreturnedforsymbolchangedinvalid />
  <EPSEstimateCurrentYear>0.00</EPSEstimateCurrentYear>
  <EPSEstimateNextYear>0.00</EPSEstimateNextYear>
  <EPSEstimateNextQuarter>0.00</EPSEstimateNextQuarter>
  <DaysLow />
  <DaysHigh />
  <YearLow>0.42</YearLow>
  <YearHigh>2.95</YearHigh>
  <HoldingsGainPercent>- - -</HoldingsGainPercent>
  <AnnualizedGain />
  <HoldingsGain />
  <HoldingsGainPercentRealtime>N/A - N/A</HoldingsGainPercentRealtime>
  <HoldingsGainRealtime />
  <MoreInfo>cnprmiIed</MoreInfo>
  <OrderBookRealtime />
  <MarketCapitalization>9.2M</MarketCapitalization>
  <MarketCapRealtime />
  <EBITDA>-34.5M</EBITDA>
  <ChangeFromYearLow>+0.18</ChangeFromYearLow>
  <PercentChangeFromYearLow>+42.86%</PercentChangeFromYearLow>
  <LastTradeRealtimeWithTime>N/A - &lt;b&gt;0.60&lt;/b&gt;</LastTradeRealtimeWithTime>
  <ChangePercentRealtime>N/A - 0.00%</ChangePercentRealtime>
  <ChangeFromYearHigh>-2.35</ChangeFromYearHigh>
  <PercebtChangeFromYearHigh>-79.66%</PercebtChangeFromYearHigh>
  <LastTradeWithTime>Jan 25 - &lt;b&gt;0.60&lt;/b&gt;</LastTradeWithTime>
  <LastTradePriceOnly>0.60</LastTradePriceOnly>
  <HighLimit />
  <LowLimit />
  <DaysRange>N/A - N/A</DaysRange>
  <DaysRangeRealtime>N/A - N/A</DaysRangeRealtime>
  <FiftydayMovingAverage>0.5639</FiftydayMovingAverage>
  <TwoHundreddayMovingAverage>1.4051</TwoHundreddayMovingAverage>
  <ChangeFromTwoHundreddayMovingAverage>-0.8051</ChangeFromTwoHundreddayMovingAverage>
  <PercentChangeFromTwoHundreddayMovingAverage>-57.30%</PercentChangeFromTwoHundreddayMovingAverage>
  <ChangeFromFiftydayMovingAverage>+0.0361</ChangeFromFiftydayMovingAverage>
  <PercentChangeFromFiftydayMovingAverage>+6.39%</PercentChangeFromFiftydayMovingAverage>
  <Name>Affirmative Insur</Name>
  <Notes />
  <Open />
  <PreviousClose>0.60</PreviousClose>
  <PricePaid />
  <ChangeinPercent>0.00%</ChangeinPercent>
  <PriceSales>0.03</PriceSales>
  <PriceBook>0.12</PriceBook>
  <ExDividendDate>12-Dec-08</ExDividendDate>
  <PERatio />
  <DividendPayDate>31-Dec-08</DividendPayDate>
  <PERatioRealtime />
  <PEGRatio />
  <PriceEPSEstimateCurrentYear />
  <PriceEPSEstimateNextYear />
  <Symbol>AFFM</Symbol>
  <SharesOwned />
  <ShortRatio>0.20</ShortRatio>
  <LastTradeTime>1:34pm</LastTradeTime>
  <TickerTrend>&amp;nbsp;======&amp;nbsp;</TickerTrend>
  <OneyrTargetPrice>6.00</OneyrTargetPrice>
  <Volume>200</Volume>
  <HoldingsValue />
  <HoldingsValueRealtime />
  <YearRange>0.42 - 2.95</YearRange>
  <DaysValueChange>- - 0.00%</DaysValueChange>
  <DaysValueChangeRealtime>N/A - N/A</DaysValueChangeRealtime>
  <StockExchange>NasdaqNM</StockExchange>
  <DividendYield />
  <PercentChange>0.00%</PercentChange>
</quote>

LINQ to XML查询中的格式错误

您在查询中进行的那些空检查毫无意义，（几乎所有）这些元素都存在于XML中，但其中许多是空的。您正试图解析空字符串，但失败后会出现错误。您应该给我们一个示例XML，它可以代表您实际拥有的内容（即，其中包含值）。如果这就是你所拥有的，那么你正在执行错误的检查。

我已经像这样重新构造了查询，并标记了异常发生的位置：

var query =
    from quote in doc.Descendants("quote")
    let lastTradeDate = (DateTime)quote.Element("LastTradeDate")
    where lastTradeDate == targetDate
    let symbol = (string)quote.Attribute("symbol")
    let open = (double)quote.Element("Open") // EXCEPTION: empty string to a double?
    let daysHigh = (double)quote.Element("DaysHigh") // DITTO
    let daysLow = (double)quote.Element("DaysLow") // DITTO
    let lastTradePriceOnly = (double)quote.Element("LastTradePriceOnly")
    let volume = (long)quote.Element("Volume") // no Volume element exists, null check might be appropriate
    select new DailyPricingVolDP(symbol, lastTradeDate, open, daysHigh, daysLow, lastTradePriceOnly, volume);

此

s.Element("Open") != null

并没有做你认为它会做的事。如果有一个元素Open，即使看起来与您的示例（<Open />）中的相同，该条件也是成立的。元素Open存在，并且它不为空。它只是没有值（或者准确地说，它的值为空字符串，""——这会导致格式异常）。

在where条款中，您应该将条件更改为

s.Element("Volume").Value != ""

以防止解析空值元素的尝试。

快速示例。这个小程序打印什么？

var xDoc = XDocument.Parse("<quote><Open /></quote>");
var open = xDoc.Descendants("quote").First().Element("Open");
Console.WriteLine(open == null);
Console.WriteLine(open);

没错。CCD_ 7之后是CCD_。

相关文章：