我有一个XML,我想根据日期选择一个元素。因此,Date后代有少于今天的日期列表。
XML的值如下所示
<Dates>
<Department>
<ID>Food</ID>
<Date>25-11-2016</Date>
</Department>
<Department>
<ID>Sport</ID>
<Date>26-10-2016</Date>
</Department>
</Dates>
现在,我只需要选择日期小于今天的元素,下面的查询将选择日期并从xml中删除项。
XDocument newXML = XDocument.Load(new StringReader(xmlValues));
var q = from node in newXML.Descendants("Date")
let attr = node.Value where attr != null && DateTime.ParseExact
(attr, "dd-MM-yyyy", CultureInfo.InvariantCulture) < DateTime.Today
select node.Parent;
q.ToList().ForEach(x => x.Remove());
现在,我怎样才能选择以下的项目,其中有日期少于今天?
<Department>
<ID>Sport</ID>
<Date>26-10-2016</Date>
</Department>
发布于 2016-10-28 16:10:56
尝尝这个
string xml =
"<Dates>" +
"<Department>" +
"<ID>Food</ID>" +
"<Date>25-11-2016</Date>" +
"</Department>" +
"<Department>" +
"<ID>Sport</ID>" +
"<Date>26-10-2016</Date>" +
"</Department>" +
"</Dates>";
XElement dates = XElement.Parse(xml);
List<XElement> departs = dates.Descendants("Department").Where(x => DateTime.ParseExact(x.Element("Date").Value, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture) < DateTime.Now).ToList();
https://stackoverflow.com/questions/40303047
复制相似问题