BaseTableAttribute获得构建的XML

2017-10-15 10:25:42  访问(1591) 赞(0) 踩(0)

输出XML

<?xml version="1.0" encoding="gb2312"?>
<BaseTableAttributes>
    <BaseTableAttribute customizeTableId="0" emBaseEntityModeValue="9" emPrimaryKeyCreateValue="1" IDFieldName="ID" IDFieldParameterType="System.Int64" TableComment="修改密码日志" TableName="UTB_SLOWX_LOG_CHANGEPWD">
        <DataColumnAttributeInfo Name="ID" AllowDBNull="0" Comment="修改密码日志" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="2" IsPrimaryKey="1" />
        <DataColumnAttributeInfo Name="UserId" AllowDBNull="0" Comment="所属用户" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="2" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="UserName" AllowDBNull="0" Comment="用户帐号" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="1" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="curPwd" AllowDBNull="1" Comment="用户密码" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="1" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="newPwd" AllowDBNull="1" Comment="用户新密码" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="1" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="IsAdmin" AllowDBNull="0" Comment="是否管理员操作" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="7" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="ExcuteUserId" AllowDBNull="0" Comment="执行操作的用户" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="2" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="ExcuteUserName" AllowDBNull="0" Comment="执行操作的用户" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="1" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="VisitWeb" AllowDBNull="1" Comment="当前页面" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="1" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="UrlReferrer" AllowDBNull="1" Comment="上次请求页面" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="1" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="FromIP" AllowDBNull="1" Comment="来源IP" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="1" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="IPAddress" AllowDBNull="1" Comment="IP地址" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="1" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="CreateTime" AllowDBNull="0" Comment="创建时间" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="6" IsPrimaryKey="0" />
        <DataColumnAttributeInfo Name="UpdateTime" AllowDBNull="0" Comment="修改时间" DataColumnLinkClassName="" DataColumnLinkTextChar="" DataColumnLinkValueChar="" emDataColumnLinkModeValue="2" emDataColumnLinkValue="1" emVarTypeValue="6" IsPrimaryKey="0" />
    </BaseTableAttribute>
</BaseTableAttributes>

调用代码

        SlowX.User_Table.TableAttribute.UTB_SLOWX_LOG_CHANGEPWD
            bta =
            SlowX.User_Table.TableAttribute.UTB_SLOWX_LOG_CHANGEPWD.instance;

        string s = AssistSlowXCoreFunctions.GetBaseTableAttributeXML(bta);

        TextBox1.Text = s; 

逻辑代码

        /// <summary>
        /// 获得构建的XML
        /// </summary>
        /// <param name="baseTableAttributeValue"></param>
        /// <returns></returns>
        public static string GetBaseTableAttributeXML
            (
                BaseTableAttribute baseTableAttributeValue
            )
        {
            XmlDocument xmlDoc = new XmlDocument();

            xmlDoc.LoadXml("<?xml version='1.0' encoding='GB2312'?><BaseTableAttributes></BaseTableAttributes>");

            XmlElement root = xmlDoc.DocumentElement;

            XmlElement xmlNode = xmlDoc.CreateElement("BaseTableAttribute");
            XmlElement xmlNodeItem = null;

            xmlNode.SetAttribute("customizeTableId", baseTableAttributeValue.customizeTableId.ToString());
            xmlNode.SetAttribute("emBaseEntityModeValue", ((int)baseTableAttributeValue.EmBaseEntityModeV).ToString());
            xmlNode.SetAttribute("emPrimaryKeyCreateValue", ((int)baseTableAttributeValue.EmPrimaryKeyCreateV).ToString());
            xmlNode.SetAttribute("IDFieldName", baseTableAttributeValue.IDFieldName);
            

            if (baseTableAttributeValue.IDFieldParameterType == null)
                xmlNode.SetAttribute("IDFieldParameterType", "");
            else
                xmlNode.SetAttribute("IDFieldParameterType", baseTableAttributeValue.IDFieldParameterType.FullName);

            // xmlNode.SetAttribute("ShowSeqDataColumnName", baseTableAttributeValue.ShowSeqDataColumnName);
            xmlNode.SetAttribute("TableComment", baseTableAttributeValue.TableComment);
            xmlNode.SetAttribute("TableName", baseTableAttributeValue.TableName);
            

            List<DataColumnAttributeInfo>
                listDataColumnAttributeInfoValue = baseTableAttributeValue.listDataColumnAttributeInfoValue;

            // 字段名 //
            foreach (DataColumnAttributeInfo dataColumnAttributeInfoValue in listDataColumnAttributeInfoValue)
            {
                xmlNodeItem = xmlDoc.CreateElement("DataColumnAttributeInfo");

                xmlNodeItem.SetAttribute("Name", dataColumnAttributeInfoValue.Name);
                xmlNodeItem.SetAttribute("AllowDBNull", BooleanSlowXCoreFunctions.GetStrByBoolean(dataColumnAttributeInfoValue.AllowDBNull));
                xmlNodeItem.SetAttribute("Comment", dataColumnAttributeInfoValue.Comment);
                xmlNodeItem.SetAttribute("DataColumnLinkClassName", dataColumnAttributeInfoValue.DataColumnLinkClassName);
                xmlNodeItem.SetAttribute("DataColumnLinkTextChar", dataColumnAttributeInfoValue.DataColumnLinkTextChar);
                xmlNodeItem.SetAttribute("DataColumnLinkValueChar", dataColumnAttributeInfoValue.DataColumnLinkValueChar);
                xmlNodeItem.SetAttribute("emDataColumnLinkModeValue", ((int)dataColumnAttributeInfoValue.EmDataColumnLinkModeV).ToString());
                xmlNodeItem.SetAttribute("emDataColumnLinkValue", ((int)dataColumnAttributeInfoValue.EmDataColumnLinkV).ToString());
                xmlNodeItem.SetAttribute("emVarTypeValue", ((int)dataColumnAttributeInfoValue.emVarTypeValue).ToString());
                xmlNodeItem.SetAttribute("IsPrimaryKey", BooleanSlowXCoreFunctions.GetStrByBoolean(dataColumnAttributeInfoValue.IsPrimaryKey));

                xmlNode.AppendChild(xmlNodeItem);
            }

            root.AppendChild(xmlNode);

            // 创建Xml字段 //

            return xmlDoc.InnerXml;
        }

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)