当前位置: 编程技术>.net/c#/asp.net
asp.net(C#)解析Json类代码
来源: 互联网 发布时间:2014-08-30
本文导语: 要求:将以下数据解析成.Net可以使用的数据,返回的数据除了header,其他的都是可变的,也就是说结构不是固定的。完全由用户选择,所以选择了生成DataTable。 Json数据格式如下: 代码如下: {"dataSet":{ "header":{ "returnCode":"0...
要求:将以下数据解析成.Net可以使用的数据,返回的数据除了header,其他的都是可变的,也就是说结构不是固定的。完全由用户选择,所以选择了生成DataTable。
Json数据格式如下:
代码如下:
{"dataSet":{
"header":{
"returnCode":"0",
"errorInfo":"HTTP请求错误",
"version":"V1.0R010",
"totalRows":"2000",
"returnRows":"20"
},
"fieldDefine":{
"assetId":"string",
"serverIdcId":"int",
"inputTime":"datetime"
},
"data":{"row":[
{
"AssetId":"TCNS2006888",
"ServerIdcId":"1",
"InputTime":"2008-12-12"
},
{
"AssetId":"TCNS2006889",
"ServerIdcId":"2",
"InputTime":"2008-1-1"
}
]}
}
}
"header":{
"returnCode":"0",
"errorInfo":"HTTP请求错误",
"version":"V1.0R010",
"totalRows":"2000",
"returnRows":"20"
},
"fieldDefine":{
"assetId":"string",
"serverIdcId":"int",
"inputTime":"datetime"
},
"data":{"row":[
{
"AssetId":"TCNS2006888",
"ServerIdcId":"1",
"InputTime":"2008-12-12"
},
{
"AssetId":"TCNS2006889",
"ServerIdcId":"2",
"InputTime":"2008-1-1"
}
]}
}
}
json解析类
代码如下:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Web.Script.Serialization;
namespace Tencent.Itil.Cmsi.Common
{
public class GeneralSearchResult
{
public Header header = new Header();
private DataTable fieldDefine = new DataTable();
///
/// 返回的数据结构定义,无数据
///
public DataTable FieldDefine
{
get { return fieldDefine; }
set { fieldDefine = value; }
}
private DataTable retrunData = new DataTable();
///
/// 返回的数据,格式为DataTable,结构和FieldDefine中的结构一样
///
public DataTable RetrunData
{
get { return retrunData; }
set { retrunData = value; }
}
///
/// 将json数据转换为定义好的对象,数据转换为DataTable
///
///
///
public static GeneralSearchResult GetTransformData(string jsonText)
{
GeneralSearchResult gsr = new GeneralSearchResult();
JavaScriptSerializer s = new JavaScriptSerializer();
Dictionary JsonData = (Dictionary)s.DeserializeObject(jsonText);
Dictionary dataSet = (Dictionary)JsonData["dataSet"];
Dictionary header = (Dictionary)dataSet["header"];
Dictionary fieldDefine = (Dictionary)dataSet["header"];
Dictionary data = (Dictionary)dataSet["data"];
object[] rows = (object[])data["row"];
gsr.header.Version = header["version"].ToString();
gsr.header.ErrorInfo = header["errorInfo"].ToString();
gsr.header.ReturnCode = header["returnCode"].ToString();
gsr.header.ReturnRows = Convert.ToInt16(header["returnRows"]);
gsr.header.TotalRows = Convert.ToInt16(header["totalRows"]);
Dictionary dicFieldDefine = (Dictionary)dataSet["fieldDefine"];
foreach (KeyValuePair ss in dicFieldDefine)
{
gsr.FieldDefine.Columns.Add(ss.Key, typeof(string));
}
gsr.RetrunData = gsr.FieldDefine.Clone();
foreach (object ob in rows)
{
Dictionary val = (Dictionary)ob;
DataRow dr = gsr.RetrunData.NewRow();
foreach (KeyValuePair sss in val)
{
dr[sss.Key] = sss.Value;
}
gsr.RetrunData.Rows.Add(dr);
}
return gsr;
}
///
/// 数据文件头定义
///
public class Header
{
private string version;
///
/// 版本
///
public string Version
{
get { return version; }
set { version = value; }
}
private string returnCode;
///
/// 结果码,0为正常,否则为有错误
///
public string ReturnCode
{
get { return returnCode; }
set { returnCode = value; }
}
private string errorInfo;
///
/// 如果ReturnCode为非0时的错误信息
///
public string ErrorInfo
{
get { return errorInfo; }
set { errorInfo = value; }
}
private int totalRows;
///
/// 查询结果总行数
///
public int TotalRows
{
get { return totalRows; }
set { totalRows = value; }
}
private int returnRows;
///
/// 返回的数据行数
///
public int ReturnRows
{
get { return returnRows; }
set { returnRows = value; }
}
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Web.Script.Serialization;
namespace Tencent.Itil.Cmsi.Common
{
public class GeneralSearchResult
{
public Header header = new Header();
private DataTable fieldDefine = new DataTable();
///
/// 返回的数据结构定义,无数据
///
public DataTable FieldDefine
{
get { return fieldDefine; }
set { fieldDefine = value; }
}
private DataTable retrunData = new DataTable();
///
/// 返回的数据,格式为DataTable,结构和FieldDefine中的结构一样
///
public DataTable RetrunData
{
get { return retrunData; }
set { retrunData = value; }
}
///
/// 将json数据转换为定义好的对象,数据转换为DataTable
///
///
///
public static GeneralSearchResult GetTransformData(string jsonText)
{
GeneralSearchResult gsr = new GeneralSearchResult();
JavaScriptSerializer s = new JavaScriptSerializer();
Dictionary JsonData = (Dictionary)s.DeserializeObject(jsonText);
Dictionary dataSet = (Dictionary)JsonData["dataSet"];
Dictionary header = (Dictionary)dataSet["header"];
Dictionary fieldDefine = (Dictionary)dataSet["header"];
Dictionary data = (Dictionary)dataSet["data"];
object[] rows = (object[])data["row"];
gsr.header.Version = header["version"].ToString();
gsr.header.ErrorInfo = header["errorInfo"].ToString();
gsr.header.ReturnCode = header["returnCode"].ToString();
gsr.header.ReturnRows = Convert.ToInt16(header["returnRows"]);
gsr.header.TotalRows = Convert.ToInt16(header["totalRows"]);
Dictionary dicFieldDefine = (Dictionary)dataSet["fieldDefine"];
foreach (KeyValuePair ss in dicFieldDefine)
{
gsr.FieldDefine.Columns.Add(ss.Key, typeof(string));
}
gsr.RetrunData = gsr.FieldDefine.Clone();
foreach (object ob in rows)
{
Dictionary val = (Dictionary)ob;
DataRow dr = gsr.RetrunData.NewRow();
foreach (KeyValuePair sss in val)
{
dr[sss.Key] = sss.Value;
}
gsr.RetrunData.Rows.Add(dr);
}
return gsr;
}
///
/// 数据文件头定义
///
public class Header
{
private string version;
///
/// 版本
///
public string Version
{
get { return version; }
set { version = value; }
}
private string returnCode;
///
/// 结果码,0为正常,否则为有错误
///
public string ReturnCode
{
get { return returnCode; }
set { returnCode = value; }
}
private string errorInfo;
///
/// 如果ReturnCode为非0时的错误信息
///
public string ErrorInfo
{
get { return errorInfo; }
set { errorInfo = value; }
}
private int totalRows;
///
/// 查询结果总行数
///
public int TotalRows
{
get { return totalRows; }
set { totalRows = value; }
}
private int returnRows;
///
/// 返回的数据行数
///
public int ReturnRows
{
get { return returnRows; }
set { returnRows = value; }
}
}
}
}
使用方法:
代码如下:
GeneralSearchResult gsr = new GeneralSearchResult();
gsr = GeneralSearchResult.GetTransformData(text);
gsr = GeneralSearchResult.GetTransformData(text);