时间戳

首页 > 解决方案 > 将 XmlDocument 转换为对象列表

c# - 将 XmlDocument 转换为对象列表

问题描述

目前我将 XmlDocument 转换为字符串 List 但这不是一个好的解决方案，因为如果我在 ListBox 中显示它，这会接收我所有参数的内联字符串，我只需要显示表然后当它被检查时发送它 Sql Server

我无法创建具有属性的辅助类，因为可以动态添加/删除参数。我不知道文件中的确切参数是什么

这是示例 XML

<TechnologyTables>
   <Tables>
      <TA_ID>3102</TA_ID>
      <TA_Name>AL000-01.50M-N2-S0</TA_Name>
      <TA_MaterialID>1</TA_MaterialID>
      <TA_ThicknessID>4</TA_ThicknessID>
      <TA_IsActive>1</TA_IsActive>
      <TA_ArchiveID>100</TA_ArchiveID>
      <TA_IsArchive>0</TA_IsArchive>
      <CL_IsActive>1</CL_IsActive>
      <MP_Lens>200</MP_Lens>
      <MP_Nozzle>4.0</MP_Nozzle>
      <MP_Focal>-0.6</MP_Focal>
      <MP_NozzleDist>1.5000000e+000</MP_NozzleDist>
      <MP_GasStabilization>1</MP_GasStabilization>
      <MP_SensitiveSensor>1</MP_SensitiveSensor>
      <MP_SensitiveArea>2.5000000e+001</MP_SensitiveArea>
      <GA_ID>1</GA_ID>
      <GP_ID>0</GP_ID>
      <GP_FlushOn>1</GP_FlushOn>
      <GP_FlushTime>2000</GP_FlushTime>
      <GP_FlushPressure>1.0000000e+001</GP_FlushPressure>
      <GP_FeedbackOn>1</GP_FeedbackOn>
      <GP_FeedbackTime>0</GP_FeedbackTime>
      <GP_FeedbackPressure>1.0000000e-001</GP_FeedbackPressure>
      <GP_MaxPressure>1.0000000e+001</GP_MaxPressure>
      <GP_ContinueOn>0</GP_ContinueOn>
      <GP_ContinueTime>0</GP_ContinueTime>
      <TA_Jerk>100</TA_Jerk>
      <TA_Acceleration>100</TA_Acceleration>
      <TA_CuttingTechID>3</TA_CuttingTechID>
      <TA_FlyCut>1</TA_FlyCut>
      <TA_HeadID>1</TA_HeadID>
      <TA_MachineID>3</TA_MachineID>
      <TA_TypeID>1</TA_TypeID>
      <TT_HeadPowerID>7</TT_HeadPowerID>
      <TA_CreateDate>2019-08-26T17:10:59.810</TA_CreateDate>
      <Description>AL1.5 CATLINE</Description>
      <TA_HeadTypeID>2</TA_HeadTypeID>
      <CatlineFolder>1</CatlineFolder>
      <NozzleNameID>10</NozzleNameID>
      <LaserTypeID>1</LaserTypeID>
   </Tables>
</TechnologyTables>

导入文件时的一些代码

private async void _ImportTechTables()
{
    var open = new OpenFileDialog();
    var TableXml = new XmlDocument();
    open.Filter = "xml files |*.xml";
    if (open.ShowDialog() == DialogResult.OK)
    {
        TableXml.Load(open.FileName);
    }
    RSA rsaKey = GetKey();
    DecryptXML(TableXml, rsaKey, "XmlKey");

    if (TableXml != null)
    {
        var import = new TechnologyTableImportViewModel();
        List<string> xmlNodeLists = new List<string>();
        XmlNodeList node = TableXml.SelectNodes("TechnologyTables/Tables");
        foreach (XmlNode nodes in node)
        {
            xmlNodeLists.Add(nodes.InnerXml);
        }
        import.List = xmlNodeLists;

列表中的元素如下所示：

<Tables><TA_ID><Tables><TA_ID>3102</TA_ID><TA_Name>AL000-01.50M-N2<TA_Name>

标签： c#xml

解决方案

我喜欢使用字典并使用 xml linq 创建字典：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
using System.Xml.Linq;


namespace ConsoleApplication137
{
    class Program
    {
        const string FILENAME = @"c:\temp\test.xml";
        static void Main(string[] args)
        {
            XDocument doc = XDocument.Load(FILENAME);

            Dictionary<string, string> dict = doc.Descendants("Tables").FirstOrDefault().Elements()
                .GroupBy(x => x.Name.LocalName, y => (string)y)
                .ToDictionary(x => x.Key, y => y.FirstOrDefault());
        }
    }
}

如果您有多个表，请使用以下内容：

            List<Dictionary<string, string>> dict = doc.Descendants("Tables").Select(t => t.Elements()
                .GroupBy(x => x.Name.LocalName, y => (string)y)
                .ToDictionary(x => x.Key, y => y.FirstOrDefault())
                ).ToList();

推荐阅读