如何在元素中更新xml文件元素值?
本文关键字:元素 文件 xml 更新 | 更新日期: 2023-09-27 18:16:56
我有以下XML文件:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<masterController> <uuid>bcbd01ac-78ff-4656-997b-d4ccc72882d1</uuid>
<channels>
<channel>
<nodeGroups>
<nodeGroup>
<analogNode>
<typeCode>8</typeCode>
<id>1</id>
<sdos>
<sdo>
<description>Host ID</description>
<compareLevel>Ignore</compareLevel>
<datafield>
<description>Host ID</description>
<compareLevel>Ignore</compareLevel>
<offset>2</offset>
<size>1</size>
<readonly>true</readonly>
<isMappedToPdo>false</isMappedToPdo>
<ownerNodeSerial>12102904</ownerNodeSerial>
<ownerSdoIndex>3</ownerSdoIndex>
<data>
<value>2</value>
<unit></unit>
<min>1</min>
<max>15</max>
</data>
<intValue>2</intValue>
</datafield>
<index>3</index>
<totalbytes>3</totalbytes>
</sdo>
<sdo>
<description>Host ID</description>
<compareLevel>Ignore</compareLevel>
<datafield>
<description>Host ID</description>
<compareLevel>Ignore</compareLevel>
<offset>2</offset>
<size>1</size>
<readonly>true</readonly>
<isMappedToPdo>false</isMappedToPdo>
<ownerNodeSerial>12102905</ownerNodeSerial>
<ownerSdoIndex>4</ownerSdoIndex>
<data>
<value>16</value>
<unit></unit>
<min>1</min>
<max>15</max>
</data>
<intValue>2</intValue>
</datafield>
<index>3</index>
<totalbytes>3</totalbytes>
</sdo>
</sdos>
<sdos>
<sdo>
<description>Host ID</description>
<compareLevel>Ignore</compareLevel>
<datafield>
<description>Host ID</description>
<compareLevel>Ignore</compareLevel>
<offset>2</offset>
<size>1</size>
<readonly>true</readonly>
<isMappedToPdo>false</isMappedToPdo>
<ownerNodeSerial>12102907</ownerNodeSerial>
<ownerSdoIndex>3</ownerSdoIndex>
<data>
<value>ty</value>
<unit></unit>
<min>1</min>
<max>15</max>
</data>
<intValue>2</intValue>
</datafield>
<index>3</index>
<totalbytes>3</totalbytes>
</sdo>
<sdo>
<description>Host ID</description>
<compareLevel>Ignore</compareLevel>
<datafield>
<description>Host ID</description>
<compareLevel>Ignore</compareLevel>
<offset>2</offset>
<size>1</size>
<readonly>true</readonly>
<isMappedToPdo>false</isMappedToPdo>
<ownerNodeSerial>12102906</ownerNodeSerial>
<ownerSdoIndex>4</ownerSdoIndex>
<data>
<value>1.2</value>
<unit></unit>
<min>1</min>
<max>15</max>
</data>
<intValue>2</intValue>
</datafield>
<index>3</index>
<totalbytes>3</totalbytes>
</sdo>
</sdos>
</analogNode>
</nodeGroup>
</nodeGroups>
</channel> </channels> </masterController>
我创建了下面的代码来更新上面XML文件中的值。然而,我的代码不工作。谁能告诉我我的代码有什么问题吗?
public void updateXml()
{
XElement root = XElement.Load(Server.MapPath("Sample.xml"));
var value = root.Descendants("datafield")
.Where(x => (string)x.Element("ownerNodeSerial") == TextBox1.Text.ToString() &&
(string)x.Element("ownerSdoIndex") == TextBox2.Text.ToString())
.Select(x => (string)x.Element("data").Element("value")).FirstOrDefault();
root.SetElementValue(value, "505");
root.Save("Sample.xml");
Process.Start("Sample.xml");
}
void UpdateBcName(XElement query, object newValue)
{
query.Element("value").SetValue(newValue);
}
IEnumerable<XElement> LoadElementWhereReqNameEquals(XElement root, string reqName)
{
IEnumerable<XElement> queries = from el in root.Descendants("sdo")
where (from add in el.Elements("datafield")
where
(string)add.Element("ownerNodeSerial") == TextBox1.Text &&
(string)add.Element("ownerSdoIndex") == TextBox2.Text
select add).Any()
select el;
return queries;
}
您对XElement.SetElementValue
的使用并不是您真正想要的。您已经找到了第一个value
元素的字符串值(例如:"2"),然后使用它作为要更新的元素的名称。我怀疑你实际上想要:
var valueElement = root.Descendants("datafield")
.Where(x => (string)x.Element("ownerNodeSerial") == TextBox1.Text &&
(string)x.Element("ownerSdoIndex") == TextBox2.Text)
.Select(x => x.Element("data").Element("value"))
.FirstOrDefault();
valueElement.Value = 505;
请注意,我已经将其设置为int
而不是字符串,因为我强烈怀疑它在逻辑上是一个整数-让LINQ to XML将其转换为字符串表示。同样,我从TextBox1.Text
和TextBox2.Text
中删除了ToString
调用。实际上,我建议将TextBox1.Text
和TextBox2.Text
解析为int
值(或long
或其他),然后比较它们:
// TODO: Use int.TryParse instead, to handle invalid input cleanly
int ownerNodeSerial = int.Parse(TextBox1.Text);
int ownerSdoIndex = int.Parse(TextBox2.Text);
var valueElement = root.Descendants("datafield")
.Where(x => (int)x.Element("ownerNodeSerial") == ownerSdoIndex &&
(int)x.Element("ownerSdoIndex") == ownerNodeSerial)
.Select(x => x.Element("data").Element("value"))
.FirstOrDefault();
...