学步园

DataTableToJson：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.Serialization.Json;
using System.Runtime.Serialization;
using System.IO;
using System.Web.Script.Serialization;
using MicroBlog.Common.APIHelper;
using System.Web;

namespace MicroBlog.Common.APIHelper
{
    public class Resolve
    {
        /// <summary>
        /// JSON文本转对象,泛型方法
        /// </summary>
        /// <typeparam name="T">类型</typeparam>
        /// <param name="jsonText">JSON文本</param>
        /// <returns>指定类型的对象</returns>
        public static T JSONToObject<T>(string jsonText, HttpContext context)
        {
            JavaScriptSerializer jss = new JavaScriptSerializer();
            try
            {
                return jss.Deserialize<T>(jsonText);
            }
            catch (Exception ex)
            {
                return default(T);
            }
        }

        /// <summary>
        /// 将JSON文本转换成数据行
        /// </summary>
        /// <param name="jsonText">JSON文本</param>
        /// <returns>数据行的字典</returns>
        public static Dictionary<string, object> DataRowFromJSON(string jsonText, HttpContext context)
        {
            return JSONToObject<Dictionary<string, object>>(jsonText, context);
        }
    }
}

调用的话：Dictionary<string, object> dt = Resolve.DataRowFromJSON(requestbuffer, context);

DatasetToJson：

public class DataSetConverter : JsonConverter
{
    public override bool CanConvert(Type objectType)
    {
        return typeof(DataSet).IsAssignableFrom(objectType);
    }

    public override void WriteJson(JsonWriter writer, object value)
    {
        DataSet ds = (DataSet)value;
        writer.WriteStartObject();
        foreach (DataTable dt in ds.Tables)
        {
            writer.WritePropertyName(dt.TableName);
            writer.WriteStartArray();
            foreach (DataRow dr in dt.Rows)
            {
                writer.WriteStartObject();
                foreach (DataColumn dc in dt.Columns)
                {
                    writer.WritePropertyName(dc.ColumnName);
                    writer.WriteValue(dr[dc].ToString());
                }
                writer.WriteEndObject();
            }
            writer.WriteEndArray();
        }
        writer.WriteEndObject();
    }
}

调用的话：JavaScriptConvert.SerializeObject(GetTestDataSet(), new DataSetConverter());

DataTableToJson2：

public class DataTableConverter : JsonConverter
    {
        public override void WriteJson(JsonWriter writer, object value)
        {
            DataTable dt = (DataTable)value;

            writer.WriteStartArray();
            foreach (DataRow dr in dt.Rows)
            {
                writer.WriteStartObject();
                foreach (DataColumn dc in dt.Columns)
                {
                    writer.WritePropertyName(dc.ColumnName);
                    writer.WriteValue(dr[dc].ToString());
                }
                writer.WriteEndObject();
            }
            writer.WriteEndArray();


        }

        public override bool CanConvert(Type objectType)
        {
            return typeof(DataTable).IsAssignableFrom(objectType);
        }
    }

调用的话：JavaScriptConvert.SerializeObject(GetTestDataTable(), new DataTableConverter());