读取pdm格式的文件生成json数据对象,拼接字符串的笨方法[实质是读取xml文件生成json数据对象]...

最新推荐文章于 2024-07-20 13:49:19 发布

weixin_30532837

最新推荐文章于 2024-07-20 13:49:19 发布

阅读量420

点赞数

文章标签： json c# 数据库

原文链接：http://www.cnblogs.com/LpRightNow/archive/2012/12/17/2821257.html

版权

1.首先从这个pdm文件文件中抽出xml的"一张表"：

<?xml version="1.0" encoding="gb2312"?>

<Model xmlns:a="attribute" xmlns:c="collection" xmlns:o="object">
<o:Table Id="o6">
    <a:ObjectID>4305BC1B-3526-4E12-8C6C-C1BF0F5C59D2</a:ObjectID>
    <a:Name>模板</a:Name>
    <a:Code>CMS_TEMP</a:Code>
    <a:CreationDate>1332832430</a:CreationDate>
    <a:Creator>Administrator</a:Creator>
    <a:ModificationDate>1348554434</a:ModificationDate>
    <a:Modifier>Administrator</a:Modifier>
    <a:TotalSavingCurrency/>
    <c:Columns>

      <o:Column Id="o33">
        <a:ObjectID>F38BE5C1-7917-46CE-8FD6-33E625869DAA</a:ObjectID>
        <a:Name>内码</a:Name>
        <a:Code>PK_ID</a:Code>
        <a:CreationDate>1332832430</a:CreationDate>
        <a:Creator>Administrator</a:Creator>
        <a:ModificationDate>1332837878</a:ModificationDate>
        <a:Modifier>Administrator</a:Modifier>
        <a:DataType>panint</a:DataType>
        <a:Mandatory>1</a:Mandatory>
      </o:Column>
      <o:Column Id="o34">
        <a:ObjectID>E4999851-9628-4317-A740-74BA62CE8788</a:ObjectID>
        <a:Name>编号</a:Name>
        <a:Code>TEMP_NO</a:Code>
        <a:CreationDate>1332832430</a:CreationDate>
        <a:Creator>Administrator</a:Creator>
        <a:ModificationDate>1332837334</a:ModificationDate>
        <a:Modifier>Administrator</a:Modifier>
        <a:DataType>panvarchar(50)</a:DataType>
        <a:Length>50</a:Length>
      </o:Column>
      <o:Column Id="o35">
        <a:ObjectID>58139FAE-C9F1-477C-B261-2B8D53EAF1DF</a:ObjectID>
        <a:Name>名称</a:Name>
        <a:Code>TEMP_NAME</a:Code>
        <a:CreationDate>1332832430</a:CreationDate>
        <a:Creator>Administrator</a:Creator>
        <a:ModificationDate>1332837334</a:ModificationDate>
        <a:Modifier>Administrator</a:Modifier>
        <a:DataType>panvarchar(50)</a:DataType>
        <a:Length>50</a:Length>
      </o:Column>
      <o:Column Id="o36">
        <a:ObjectID>0FD8A3F9-A5C5-4794-B1EB-2DF835BA4C51</a:ObjectID>
        <a:Name>类型</a:Name>
        <a:Code>FK_TEMP_TYPE</a:Code>
        <a:CreationDate>1332832430</a:CreationDate>
        <a:Creator>Administrator</a:Creator>
        <a:ModificationDate>1332837878</a:ModificationDate>
        <a:Modifier>Administrator</a:Modifier>
        <a:DataType>panint</a:DataType>
      </o:Column>
      <o:Column Id="o37">
        <a:ObjectID>AEF02063-FBBB-4E24-A9C1-DE92DB7C9FB2</a:ObjectID>
        <a:Name>内容</a:Name>
        <a:Code>TEMP_CONTENT</a:Code>
        <a:CreationDate>1332832430</a:CreationDate>
        <a:Creator>Administrator</a:Creator>
        <a:ModificationDate>1332833706</a:ModificationDate>
        <a:Modifier>Administrator</a:Modifier>
        <a:DataType>pantext</a:DataType>
      </o:Column>
      <o:Column Id="o38">
        <a:ObjectID>1398C477-2E7A-4793-BAB9-6B907462FD08</a:ObjectID>
        <a:Name>日期</a:Name>
        <a:Code>TEMP_TIME</a:Code>
        <a:CreationDate>1332832430</a:CreationDate>
        <a:Creator>Administrator</a:Creator>
        <a:ModificationDate>1332833706</a:ModificationDate>
        <a:Modifier>Administrator</a:Modifier>
        <a:DataType>pandate</a:DataType>
      </o:Column>
      <o:Column Id="o39">
        <a:ObjectID>F31AD368-FF19-42A3-A668-EF14CBBCF38C</a:ObjectID>
        <a:Name>备注</a:Name>
        <a:Code>TEMP_NOTE</a:Code>
        <a:CreationDate>1348554342</a:CreationDate>
        <a:Creator>Administrator</a:Creator>
        <a:ModificationDate>1348554434</a:ModificationDate>
        <a:Modifier>Administrator</a:Modifier>
        <a:DataType>panvarchar(100)</a:DataType>
        <a:Length>100</a:Length>
      </o:Column>

    </c:Columns>
    <c:Keys>
      <o:Key Id="o40">
        <a:ObjectID>5C4F7786-029E-41E7-842A-64DDA2BA8CA9</a:ObjectID>
        <a:Name>PK_CMS_TEMP</a:Name>
        <a:Code>PK_CMS_TEMP</a:Code>
        <a:CreationDate>1332832430</a:CreationDate>
        <a:Creator>Administrator</a:Creator>
        <a:ModificationDate>1332836773</a:ModificationDate>
        <a:Modifier>Administrator</a:Modifier>
        <c:Key.Columns>
          <o:Column Ref="o33"/>
        </c:Key.Columns>
      </o:Key>
    </c:Keys>
    <c:PrimaryKey>
      <o:Key Ref="o40"/>
    </c:PrimaryKey>
    <c:ClusterObject>
      <o:Key Ref="o40"/>
    </c:ClusterObject>
</o:Table>
</Model>

2.下面是读取这张xml格式"表格"的方法:

/// <summary>

/// From A Table Generate JSON Objects

/// </summary>

/// <returns></returns>

public string GenerateJSON(XmlNode ATable, XmlNamespaceManager xmlnsManager)

{

XmlNode name = ATable.SelectSingleNode("a:Name", xmlnsManager);

XmlNode TrueName = ATable.SelectSingleNode("a:Code", xmlnsManager);

string TName = string.Empty;

if (name != null)

{

TName += "{Name:\"" + TrueName.InnerText + "\",";//表名称

TName += "Title:\"" + name.InnerText + "\",";

//Response.Write(TName);

}

//XmlNodeList columns = ATable.SelectSingleNode("c:Columns", xmlnsManager).ChildNodes;//1

XmlNodeList columns = ATable.SelectNodes("c:Columns/o:Column", xmlnsManager);//1

StringBuilder builder = new StringBuilder();

builder.Append("[");

//循环多列

foreach (XmlNode nodeColumn in columns)

{

//Response.Write("<script>alert('" + + "')</script>");

string nodeColumnName = nodeColumn.SelectSingleNode("a:Name", xmlnsManager).InnerText;

string TrueNodeColumnName = nodeColumn.SelectSingleNode("a:Code", xmlnsManager).InnerText;

string nodeColumnType = nodeColumn.SelectSingleNode("a:DataType", xmlnsManager).InnerText;

XmlNode nodeLength = nodeColumn.SelectSingleNode("a:Length", xmlnsManager);

string nodeColumnlength = string.Empty;

int ZERO = 0;

if (nodeLength != null)

{

nodeColumnlength = nodeColumn.SelectSingleNode("a:Length", xmlnsManager).InnerText;

}

else

{

nodeColumnlength = ZERO.ToString();

}

//convert the builder.ToString(); 为ajson

builder.Append("{Name:\"" + TrueNodeColumnName + "\",Title:\"" + nodeColumnName + "\",Type:\"" + nodeColumnType + "\",Length:" + nodeColumnlength + "},");

}

builder.Append("]");

string resStr = "Column:" + builder.ToString().Remove(builder.Length - 2, 1);

resStr += ",";//生成队列信息

#region 下面是找主键信息

XmlNode PrimaryKeyNode = ATable.SelectSingleNode("//c:PrimaryKey/o:Key", xmlnsManager);//2

string PrimaryKeyID = string.Empty;

if (PrimaryKeyNode != null)

PrimaryKeyID = PrimaryKeyNode.Attributes["Ref"].Value;

else return "";//未能找到xml的主键信息列

// Response.Write(PrimaryKeyID);

XmlNode nodeAtt = ATable.SelectSingleNode("//c:Keys/o:Key[@Id='" + PrimaryKeyID + "']", xmlnsManager);//3

string primaryName = nodeAtt.SelectSingleNode("a:Name", xmlnsManager).InnerText;//主键信息

//Response.Write(primaryName);

XmlNode xmlAttID = nodeAtt.SelectSingleNode("c:Key.Columns/o:Column", xmlnsManager);//主键信息

string xmlPrimaryId = xmlAttID.Attributes["Ref"].Value;//主键信息

//Response.Write(xmlPrimaryId);

XmlNode xmlNodePrimary = ATable.SelectSingleNode("//c:Columns/o:Column[@Id='" + xmlPrimaryId + "']", xmlnsManager);//4

string xmlNodePrimaryName = xmlNodePrimary.SelectSingleNode("a:Code", xmlnsManager).InnerText;主键信息名字

string xmlPrimaryNameMain = "PrimaryKey:\"" + xmlNodePrimaryName + "\",";//string:primaryString json格式对象

//Response.Write(xmlPrimaryNameMain);

string xmlIdx = "idx:\"" + xmlNodePrimaryName + "\"}";

return TName + resStr + xmlPrimaryNameMain + xmlIdx;

#endregion

}

3.循环pdm文件中的多个xml"表格",动态代码如下：

/// <summary>

/// 多张表生成json格式对象

/// </summary>

/// <returns></returns>

public string ForeachTable()

{

string resJSON = string.Empty;

XmlDocument xmldoc = new XmlDocument();

XmlNamespaceManager xmlnsManager = new XmlNamespaceManager(xmldoc.NameTable);

xmlnsManager.AddNamespace("a", "attribute");

xmlnsManager.AddNamespace("c", "collection");

xmlnsManager.AddNamespace("o", "object");

xmldoc.Load(Server.MapPath("~/bin/cms.pdm"));

XmlElement root = xmldoc.DocumentElement;

if (root == null)

return "";

//对个节点集合

XmlNodeList MultipleTable = root.SelectNodes("//Model/o:RootObject/c:Children/o:Model/c:Tables/o:Table", xmlnsManager);

resJSON += "[";

foreach (XmlNode table in MultipleTable)

{

resJSON += GenerateJSON(table, xmlnsManager) + ",";

}

resJSON += "]";

resJSON.Remove(resJSON.Length - 2, 1);

return resJSON;

}

4.拼接字符串是一种方法，但是比较麻烦，所以还可以用到Dictionary和List泛型集合集成数据，既可以序列化成json格式数据的对象！

下面是用一般处理程序下的泛型集合改的：

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Collections;
using System.Web.Script.Serialization;
using System.IO;
using Microsoft.SqlServer;
using System.Collections.Generic;
using System.Xml;

public class Handler : IHttpHandler
{

public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";

JavaScriptSerializer js = new JavaScriptSerializer();
List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
list = ForeachTable();
string jsonMultipleTable = js.Serialize(list);
context.Response.Write(jsonMultipleTable);
context.Response.Write("<br />");
}
/// <summary>
/// 负责调用该方法，生成json对象
/// </summary>
/// <returns></returns
public List<Dictionary<string, object>> ForeachTable()
{
string resJSON = string.Empty;
List<System.Collections.Generic.Dictionary<string, object>> listMultipleTalbe = new List<Dictionary<string, object>>();
XmlDocument xmldoc = new XmlDocument();
System.Xml.XmlNamespaceManager xmlnsManager = new System.Xml.XmlNamespaceManager(xmldoc.NameTable);
xmlnsManager.AddNamespace("a", "attribute");
xmlnsManager.AddNamespace("c", "collection");
xmlnsManager.AddNamespace("o", "object");
xmldoc.Load(HttpContext.Current.Request.MapPath("~/file/cms.pdm"));
XmlElement root = xmldoc.DocumentElement;
if (root == null)
return null;
//
XmlNodeList MultipleTable = root.SelectNodes("//Model/o:RootObject/c:Children/o:Model/c:Tables/o:Table", xmlnsManager);
foreach (XmlNode table in MultipleTable)
{
listMultipleTalbe.Add(GenerateJSON(table, xmlnsManager));
}
return listMultipleTalbe;
}
/// <summary>
/// From A Table Generate JSON Objects
/// </summary>
/// <returns></returns>
public Dictionary<string, object> GenerateJSON(XmlNode ATable, XmlNamespaceManager xmlnsManager)
{
Dictionary<string, object> DicTable = new Dictionary<string, object>();//a table
List<Dictionary<string, string>> listColumn = new List<Dictionary<string, string>>();//multiple column
Dictionary<string, string> DicMultipleColumn = null;//a column
XmlNode name = ATable.SelectSingleNode("a:Name", xmlnsManager);
XmlNode TrueName = ATable.SelectSingleNode("a:Code", xmlnsManager);
string TName = string.Empty;
if (name != null)
{
DicTable.Add("Name", TrueName.InnerText);
DicTable.Add("Title", name.InnerText);
}
XmlNodeList columns = ATable.SelectNodes("c:Columns/o:Column", xmlnsManager);//1
//循环多列
foreach (XmlNode nodeColumn in columns)
{
string nodeColumnName = nodeColumn.SelectSingleNode("a:Name", xmlnsManager).InnerText;
string TrueNodeColumnName = nodeColumn.SelectSingleNode("a:Code", xmlnsManager).InnerText;
string nodeColumnType = nodeColumn.SelectSingleNode("a:DataType", xmlnsManager).InnerText;
XmlNode nodeLength = nodeColumn.SelectSingleNode("a:Length", xmlnsManager);
string nodeColumnlength = string.Empty;
int ZERO = 0;
if (nodeLength != null)
{
nodeColumnlength = nodeColumn.SelectSingleNode("a:Length", xmlnsManager).InnerText;
}
else
{
nodeColumnlength = ZERO.ToString();
}
// DicMultipleColumn.Clear();
//每一列对应的new一个新dictionary
DicMultipleColumn = new Dictionary<string, string>();
DicMultipleColumn.Add("Name", TrueNodeColumnName);
DicMultipleColumn.Add("Title", nodeColumnName);
DicMultipleColumn.Add("Type", nodeColumnType);
DicMultipleColumn.Add("Length", nodeColumnlength);
listColumn.Add(DicMultipleColumn);
}
DicTable.Add("Column", listColumn);
XmlNode PrimaryKeyNode = ATable.SelectSingleNode("//c:PrimaryKey/o:Key", xmlnsManager);//2
string PrimaryKeyID = string.Empty;//找到主键Ref
if (PrimaryKeyNode != null)
PrimaryKeyID = PrimaryKeyNode.Attributes["Ref"].Value;
else return null;//未能找到PrimaryKey
XmlNode nodeAtt = ATable.SelectSingleNode("//c:Keys/o:Key[@Id='" + PrimaryKeyID + "']", xmlnsManager);//3
string primaryName = nodeAtt.SelectSingleNode("a:Name", xmlnsManager).InnerText;//主键名字；
XmlNode xmlAttID = nodeAtt.SelectSingleNode("c:Key.Columns/o:Column", xmlnsManager);//主键名字
string xmlPrimaryId = xmlAttID.Attributes["Ref"].Value;//主键id
XmlNode xmlNodePrimary = ATable.SelectSingleNode("//c:Columns/o:Column[@Id='" + xmlPrimaryId + "']", xmlnsManager);//4
string xmlNodePrimaryName = xmlNodePrimary.SelectSingleNode("a:Code", xmlnsManager).InnerText;//主键的名字
DicTable.Add("PrimaryKey", xmlNodePrimaryName);
DicTable.Add("idx", xmlNodePrimaryName);
return DicTable;

}
public bool IsReusable
{
get
{
return false;
}
}