/************************************************** 
* 版權所有: Mr_Sheng 
* 文 件 名: JSONHelper.cs 
* 文件描述: 
* 類型說明: JSONHelper JSON幫助類 
* 授權聲明: 
* 本程序為自由軟件； 
* 您可依據自由軟件基金會所發表的GPL v3授權條款，對本程序再次發布和/或修改； 
* 本程序是基于使用目的而加以發布，然而不負任何擔保責任； 
* 亦無對適售性或特定目的適用性所為的默示性擔保。 
* 詳情請參照GNU通用公共授權 v3（參見license.txt文件）。 
* 版本歷史: 
* v2.0.0 Mr_Sheng 2009-09-09 修改 
***************************************************/ 
using System; 
using System.Collections.Generic; 
using System.Web; 
using System.Web.Script.Serialization; 
using System.Data; 
namespace Sheng.Common 
{ 
/// <summary> 
/// JSON幫助類 
/// </summary> 
public class JSONHelper 
{ 
/// <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("JSONHelper.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="dataSet">數據集</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="dataTable">數據表</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("JSONHelper.JSONToObject(): " + ex.Message); 
} 
} 
/// <summary> 
/// 將JSON文本轉換為數據表數據 
/// </summary> 
/// <param name="jsonText">JSON文本</param> 
/// <returns>數據表字典</returns> 
public static Dictionary<string, List<Dictionary<string, object>>> TablesDataFromJSON(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> DataRowFromJSON(string jsonText) 
{ 
return JSONToObject<Dictionary<string, object>>(jsonText); 
} 
} 
}