JSONC#解析类.doc

好久没写东西了，又开始写代码。今天写了点东西记下来：现在json因为轻型，越来越流行，部门内部的数据标准趋向于json,所以开始学习。本次工作内容是要将以下数据解析成.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解析的类：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)JsonDatadataSet; Dictionary header = (Dictionary)dataSetheader; Dictionary fieldDefine = (Dictionary)dataSetheader; Dictionary data = (Dictionary)dataSetdata; object rows = (object)datarow; gsr.header.Version = headerversion.ToString(); gsr.header.ErrorInfo = headererrorInfo.ToString(); gsr.header.ReturnCode = headerreturnCode.ToString(); gsr.header.ReturnRows = Convert.ToInt16(headerreturnRows); gsr.header.TotalRows = Convert.ToInt16(headertotalRows); Dictionary dicFieldDefine = (Dictionary)dataSetfieldDefine; 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) drsss.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 returnRo