asp.net&&JSON

来源:互联网 发布:java 架构师证书 编辑:程序博客网 时间:2024/05/16 12:03

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Web.Script.Serialization;
using System.Collections.Generic;

/// <summary>
///HelpJson 的摘要说明
/// </summary>
public class HelpJson
{
    public HelpJson()
    {
        //
        //TODO: 在此处添加构造函数逻辑
        //
    }
    /// <summary>
    /// 将对象转换为Json
    /// </summary>
    /// <param name="obj">对象</param>
    /// <returns>Json格式字符串</returns>
    public static string ObjectToJson(object obj)
    {
        JavaScriptSerializer jss = new JavaScriptSerializer();
        try
        {
            return jss.Serialize(obj);
        }
        catch(Exception ex)
        {
            throw new Exception("JSonHelp.objectToJson();" + ex.Message);
        }
    }
    /// <summary>
    /// 数据表转键值对集合
    /// 将DataTable转成List集合,存每一行
    /// </summary>
    /// <param name="dt">数据表</param>
    /// <returns>哈希表数组</returns>
    public static List<Dictionary<string, object>> DataTableToList(DataTable dt)
    {
        List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
        foreach (DataRow dr in dt.Rows)
        {
            Dictionary<string, object> dic = new Dictionary<string, object>();
            foreach (DataColumn dc in dt.Columns)
            {
                dic.Add(dc.ColumnName, dr[dc.ColumnName]);
            }
            list.Add(dic);
        }
        return list;
    }
    /// <summary>
    /// 数据集转键值对数组字典
    /// </summary>
    /// <param name="ds">数据集</param>
    /// <returns>键值对数组字典</returns>
    public static Dictionary<string, List<Dictionary<string, object>>> DataSetToDic(DataSet ds)
    {
        Dictionary<string, List<Dictionary<string, object>>> result = new Dictionary<string, List<Dictionary<string, object>>>();
        foreach (DataTable dt in ds.Tables)
        {
            result.Add(dt.TableName, DataTableToList(dt));
           
        }
        return result;
    }
    /// <summary>
    /// 数据表转JSON
    /// </summary>
    /// <param name="dt">数据表</param>
    /// <returns>JSON字符串</returns>
    public static string DataTableToJson(DataTable dt)
    {
        return ObjectToJson(DataTableToList(dt));
    }
    /// <summary>
    /// 将Json字符串转换为对象泛型方法
    /// </summary>
    /// <typeparam name="T">类型</typeparam>
    /// <param name="JsonText">Json字符串</param>
    /// <returns>制定类型对象</returns>
    public static T JsonToObject<T>(string JsonText)
    {
        JavaScriptSerializer jss = new JavaScriptSerializer();
        try
        {
            return jss.Deserialize<T>(JsonText);
        }
        catch (Exception ex)
        {
            throw new Exception("JsonHelp.JsonToObject():" + ex.Message);
        }
    }
    /// <summary>
    /// 将Json字符串转换为数据表数据
    /// </summary>
    /// <param name="JsonText">Json文本</param>
    /// <returns>数据表字典</returns>
    public static Dictionary<string, List<Dictionary<string, object>>> TablesDataFormJson(string JsonText)
    {
        return  JsonToObject<Dictionary<string, List<Dictionary<string, object>>>>(JsonText);
    }
    /// <summary>
    /// 将json文本转换成数据行
    /// </summary>
    /// <param name="JsonText">Json文本</param>
    /// <returns>数据行的字典</returns>
    public static Dictionary<string, object> DataRowFormJson(string JsonText)
    {
        return JsonToObject<Dictionary<string, object>>(JsonText);
    }
}

原创粉丝点击