我有非常大的xml数据集。因此,在该"SECTION"
包含"Piece"
节点,并且它们对"SECTION name="RF1WB-1"
、SECTION name="RF1WB-2"
、SECTION name="RF1WB-3"
具有相等的值。因此,如果标签包含与第二个 XML 中显示的值相同"Piece"
我想将"Parent"
作为父节点添加到它们中。
如果子节点元素包含相同的值,如何添加父节点?
XmlDocument doc = new XmlDocument();
doc.Load("..\MFAB1.xml");
XmlNodeList xnList = doc.SelectNodes("MFAB.ini/SECTION");
foreach (XmlNode xn in xnList)
{
if (xn.HasChildNodes)
{
foreach (XmlNode item in xn.SelectNodes("Piece"))
{
if (xn.ChildNodes[0].InnerText.ToString().Contains(s3))
{
d1.Piece = xn.ChildNodes[0].InnerText.ToString();
}
______________
______________
______________
}
}
}
输入文件:
<?xml version="1.0" encoding="UTF-8"?>
<MFAB.ini>
<SECTION name="RF1WB-1">
<Piece>
RF1-1
</Piece>
</SECTION>
<SECTION name="RF1WB-2">
<Piece>
RF1-1
</Piece>
</SECTION>
<SECTION name="RF1WB-3">
<Piece>
RF1-1
</Piece>
</SECTION>
<SECTION name="RF1-2WB-1">
<Piece>
RF1-2
</Piece>
</SECTION>
<SECTION name="RF1-2WB-2">
<Piece>
RF1-2
</Piece>
</SECTION>
</MFAB.ini>
预期输出文件:
我需要的是:
<?xml version="1.0" encoding="UTF-8"?>
<MFAB.ini>
<Parent name = "RF1-1">
<SECTION name="RF1-1WB-1">
<Piece>
RF1-1
</Piece>
</SECTION>
<SECTION name="RF1-1WB-2">
<Piece>
RF1-1
</Piece>
</SECTION>
<SECTION name="RF1-1WB-3">
<Piece>
RF1-1
</Piece>
</SECTION>
</Parent>
<Parent name = "RF1-2">
<SECTION name="RF1-2WB-1">
<Piece>
RF1-2
</Piece>
</SECTION>
<SECTION name="RF1-2WB-2">
<Piece>
RF1-2
</Piece>
</SECTION>
</Parent>
</MFAB.ini>
按<Piece>
标签对元素进行分组,然后通过以下方式将它们作为<Parent>
标签的子元素:
var xml = XDocument.Load(@"input file");
var result = new XElement(xml.Root.Name, xml.Root.Attributes().ToArray(),
xml.Root.Elements().GroupBy(x => x.Element("Piece").Value.Trim()).Select(x =>
new XElement("Parent", new XAttribute("name", x.Key), x))
);
result.Save(@"output file");
为了方便自己,您可以使用XmlSerializer
来读取数据,并且可以像这样为Xml定义dto。
[XmlRoot("MFAB.ini")]
public class Mfab {
[XmlElement("SECTION")]
public Section[] Sections { get; set; }
}
public class Section {
[XmlAttribute("name")]
public string Name { get; set; }
[XmlElement("Piece")]
[XmlText]
public string Piece { get; set; }
}
这将按原样读取您的文档,将所有部分作为 Mfab 类的一部分(抱歉,我不知道类;)更好的名称)
这个 Xml,然后你可以这样读
private static T GetXmlFromFile<T>(string filename) {
XmlSerializer xs = new XmlSerializer(typeof(T));
using (var fs = new FileStream(filename, FileMode.Open, FileAccess.Read))
{
return (T)xs.Deserialize(fs);
}
}
这将为您提供一个包含所有部分的类。现在,由于您要重新格式化数据,因此您应该创建一个新类来保存父部分,然后创建一个新的 xml 根来保存这些
[XmlRoot("MFAB.ini")]
public class MfabWithParents {
[XmlElement("PARENT")]
public ParentSection[] Parents { get; set; }
}
public class ParentSection {
[XmlAttribute("name")]
public string Name { get; set; }
[XmlElement("SECTION")]
public Section[] Sections { get; set; }
}
ParentSection
仍然重用之前创建的Section
类。
现在要进行转换,我们可以实现以下步骤
// get the xml from a file
var source = GetXmlFromFile<Mfab>(Path.Combine(Environment.CurrentDirectory, "data.xml"));
// group all the sections by it's Piece
var groupedSections = source.Sections.GroupBy(section => section.Piece);
// convert the sections from the Grouped section to a parent section with name as attribute
var parentSections = groupedSections.Select(grp => new ParentSection
{
Name = grp.Key,
Sections = grp.ToArray()
}).ToArray();
// save the xml to a new file (which could now be read with the MfabWithParents class)
SaveToXml(new MfabWithParents { Parents = parentSections }, Path.Combine(Environment.CurrentDirectory, "data2.xml"));
保存方法看起来像这样
private static void SaveToXml(object data, string filename) {
XmlSerializer xs = new XmlSerializer(data.GetType());
using (var fs = new FileStream(filename, FileMode.Create, FileAccess.Write)) {
xs.Serialize(fs, data);
}
}