将XML转换为实体

需求

将XML文件中的数据经过转换后插入到数据库中。

参考

C#实体类和XML的相互转换

https://blog.csdn.net/pan_junbiao/article/details/82938027

遇到的问题

错误描述

XML反序列化出错，XML 文档(2, 2)中有错误

解决方案

在实体类的字段要加上XmlElement属性

https://www.cnblogs.com/wuyunblog/p/6625747.html

具体实例

实体类和XML转换的帮助类

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Serialization;

namespace conDealXML
{
    public static class XmlSerializeHelper
    {

        /// <summary>
        /// 将实体对象转换成XML
        /// </summary>
        /// <typeparam name="T">实体类型</typeparam>
        /// <param name="obj">实体对象</param>
        public static string XmlSerialize<T>(T obj)
        {
            try
            {
                using (StringWriter sw = new StringWriter())
                {
                    Type t = obj.GetType();
                    XmlSerializer serializer = new XmlSerializer(obj.GetType());
                    serializer.Serialize(sw, obj);
                    sw.Close();
                    return sw.ToString();
                }
            }
            catch (Exception ex)
            {
                throw new Exception("将实体对象转换成XML异常", ex);
            }
        }

        /// <summary>
        /// 将XML转换成实体对象
        /// </summary>
        /// <typeparam name="T">实体类型</typeparam>
        /// <param name="strXML">XML</param>
        public static T DESerializer<T>(string strXML) where T : class
        {
            try
            {
                using (StringReader sr = new StringReader(strXML))
                {
                    XmlSerializer serializer = new XmlSerializer(typeof(T));
                    return serializer.Deserialize(sr) as T;
                }
            }
            catch (Exception ex)
            {
                throw new Exception("将XML转换成实体对象异常", ex);
            }

        }
    }
}

实体类

using System;
using System.Xml.Serialization;
namespace Model
{
    /// <summary>
    /// 功能: 实体类 (权限)
    /// 创建人：CodeSmith     
    /// 创建日期：2019/12/25    
    /// </summary>
    [Serializable]
    [XmlRoot(ElementName = "Action")]
    public partial class Action
    {
       public Action() 
       {    }       
        #region Model
        /// <summary>
        /// 权限ID
        /// </summary>
        public short? ActionID {get; set;}
        /// <summary>
        /// 权限名字
        /// </summary>
        public string Name {get; set;}
        /// <summary>
        /// 权限标志代码(用于功能的判定)
        /// </summary>
        public string Code {get; set;}
        /// <summary>
        /// 权限的路径
        /// </summary>
        public string Url {get; set;}
        /// <summary>
        /// 排序
        /// </summary>
        public short? Sort {get; set;}
        /// <summary>
        /// 权限类型
        /// </summary>
        public int? ActionType {get; set;}
        /// <summary>
        /// 备注
        /// </summary>
        public string Memo {get; set;}
        /// <summary>
        /// 审核状态
        /// </summary>
        public short? Check {get; set;}
        /// <summary>
        /// 添加时间
        /// </summary>
        public DateTime? InsertTime {get; set;}
        /// <summary>
        /// 修改时间
        /// </summary>
        public DateTime? ModifyTime {get; set;}
        #endregion
    }
}

XML文件

<?xml version="1.0" encoding="gb2312"?>
<MyConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <Roles>
        <Role>
            <Actions>
                <Action>
                    <ActionID>133</ActionID>
                    <Name>用户查询</Name>
                    <Code>041303</Code>
                    <Url>/AddValue/addvalue_list</Url>
                    <Sort>4</Sort>
                    <ActionType>0</ActionType>
                    <Check>1</Check>
                    <InsertTime>2019-12-24T11:18:00</InsertTime>
                    <ModifyTime xsi:nil="true" />
                </Action>
            </Actions>
            <Menus>
                <Menu>
                    <MenuID>165</MenuID>
                    <Title>用户管理</Title>
                    <ParentID>160</ParentID>
                    <Layer>4</Layer>
                    <Path>0/1/3/160</Path>
                    <Sort>12</Sort>
                    <Url>http://</Url>
                    <Image>http://</Image>
                    <IsVip>false</IsVip>
                    <MenuType>0</MenuType>
                    <Level>0</Level>
                    <Check>1</Check>
                    <InsertTime>2019-12-21T09:21:00</InsertTime>
                    <ModifyTime>2019-12-21T09:23:00</ModifyTime>
                </Menu>
            </Menus>
            <RoleID></RoleID>
            <Name>超级管理员</Name>
        </Role>
        <Role>
        </Role>
    </Roles>
</MyConfig>

控制台程序，执行转换的过程

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

namespace conDealXML
{
    class Program
    {
        static void Main(string[] args)
        {
            XmlDocument doc = new XmlDocument();
            doc.Load("Roles.Config");

            XmlNode xn_MyConfig = doc.SelectSingleNode("MyConfig");
            XmlNodeList xnl_Roles = xn_MyConfig.ChildNodes;
            XmlNode xn_Roles_Roles = xnl_Roles[0];
            XmlNodeList xnl_Roles_Role = xn_Roles_Roles.ChildNodes;
            XmlNode xn_Role_Admin = xnl_Roles_Role[0];//第一个Role，为超级管理员
            XmlNodeList xnl_Role_Admin = xn_Role_Admin.ChildNodes;
            foreach (XmlNode item in xnl_Role_Admin)
            {
                if (item.Name == "Actions")
                {
                    XmlNodeList xnl_Actions = item.ChildNodes;//获取到所有的Action
                    foreach (XmlNode xn in xnl_Actions)
                    {
                        Model.Action model = XmlSerializeHelper.DESerializer<Model.Action>(xn.OuterXml);
                        new DAL.Action().Add(model);
                    }
                }
                if (item.Name == "Menus")
                {
                    XmlNodeList xnl_Menus = item.ChildNodes;//获取到所有的Action
                    foreach (XmlNode xn in xnl_Menus)
                    {
                        Model.Menu model = XmlSerializeHelper.DESerializer<Model.Menu>(xn.OuterXml);
                        new DAL.Menu().Add(model);
                    }
                }
            }

            Console.ReadKey();
        }
    }
}