首页 技术 正文
技术 2022年11月13日
0 收藏 579 点赞 2,619 浏览 10677 个字

此文转自:http://bbs.csdn.net/topics/380200497,为了方便自己记忆才以文章形式保存。

using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Reflection;using System.Collections;using System.Data.Common; namespace DotNet.Utilities{    //JSON转换类    public class ConvertJson    {        #region 私有方法        /// <summary>        /// 过滤特殊字符        /// </summary>        private static string String2Json(String s)        {            StringBuilder sb = new StringBuilder();            for (int i = 0; i < s.Length; i++)            {                char c = s.ToCharArray()[i];                switch (c)                {                    case '\"':                        sb.Append("\\\""); break;                    case '\\':                        sb.Append("\\\\"); break;                    case '/':                        sb.Append("\\/"); break;                    case '\b':                        sb.Append("\\b"); break;                    case '\f':                        sb.Append("\\f"); break;                    case '\n':                        sb.Append("\\n"); break;                    case '\r':                        sb.Append("\\r"); break;                    case '\t':                        sb.Append("\\t"); break;                    default:                        sb.Append(c); break;                }            }            return sb.ToString();        }         /// <summary>        /// 格式化字符型、日期型、布尔型        /// </summary>        private static string StringFormat(string str, Type type)        {            if (type == typeof(string))            {                str = String2Json(str);                str = "\"" + str + "\"";            }            else if (type == typeof(DateTime))            {                str = "\"" + str + "\"";            }            else if (type == typeof(bool))            {                str = str.ToLower();            }            else if (type != typeof(string) && string.IsNullOrEmpty(str))            {                str = "\"" + str + "\"";            }            return str;        }        #endregion         #region List转换成Json        /// <summary>        /// List转换成Json        /// </summary>        public static string ListToJson<T>(IList<T> list)        {            object obj = list[0];            return ListToJson<T>(list, obj.GetType().Name);        }         /// <summary>        /// List转换成Json         /// </summary>        public static string ListToJson<T>(IList<T> list, string jsonName)        {            StringBuilder Json = new StringBuilder();            if (string.IsNullOrEmpty(jsonName)) jsonName = list[0].GetType().Name;            Json.Append("{\"" + jsonName + "\":[");            if (list.Count > 0)            {                for (int i = 0; i < list.Count; i++)                {                    T obj = Activator.CreateInstance<T>();                    PropertyInfo[] pi = obj.GetType().GetProperties();                    Json.Append("{");                    for (int j = 0; j < pi.Length; j++)                    {                        Type type = pi[j].GetValue(list[i], null).GetType();                        Json.Append("\"" + pi[j].Name.ToString() + "\":" + StringFormat(pi[j].GetValue(list[i], null).ToString(), type));                         if (j < pi.Length - 1)                        {                            Json.Append(",");                        }                    }                    Json.Append("}");                    if (i < list.Count - 1)                    {                        Json.Append(",");                    }                }            }            Json.Append("]}");            return Json.ToString();        }        #endregion         #region 对象转换为Json        /// <summary>         /// 对象转换为Json         /// </summary>         /// <param name="jsonObject">对象</param>         /// <returns>Json字符串</returns>         public static string ToJson(object jsonObject)        {            string jsonString = "{";            PropertyInfo[] propertyInfo = jsonObject.GetType().GetProperties();            for (int i = 0; i < propertyInfo.Length; i++)            {                object objectValue = propertyInfo[i].GetGetMethod().Invoke(jsonObject, null);                string value = string.Empty;                if (objectValue is DateTime || objectValue is Guid || objectValue is TimeSpan)                {                    value = "'" + objectValue.ToString() + "'";                }                else if (objectValue is string)                {                    value = "'" + ToJson(objectValue.ToString()) + "'";                }                else if (objectValue is IEnumerable)                {                    value = ToJson((IEnumerable)objectValue);                }                else                {                    value = ToJson(objectValue.ToString());                }                jsonString += "\"" + ToJson(propertyInfo[i].Name) + "\":" + value + ",";            }            jsonString.Remove(jsonString.Length - 1, jsonString.Length);            return jsonString + "}";        }        #endregion         #region 对象集合转换Json        /// <summary>         /// 对象集合转换Json         /// </summary>         /// <param name="array">集合对象</param>         /// <returns>Json字符串</returns>         public static string ToJson(IEnumerable array)        {            string jsonString = "[";            foreach (object item in array)            {                jsonString += ToJson(item) + ",";            }            jsonString.Remove(jsonString.Length - 1, jsonString.Length);            return jsonString + "]";        }        #endregion         #region 普通集合转换Json        /// <summary>         /// 普通集合转换Json         /// </summary>         /// <param name="array">集合对象</param>         /// <returns>Json字符串</returns>         public static string ToArrayString(IEnumerable array)        {            string jsonString = "[";            foreach (object item in array)            {                jsonString = ToJson(item.ToString()) + ",";            }            jsonString.Remove(jsonString.Length - 1, jsonString.Length);            return jsonString + "]";        }        #endregion         #region  DataSet转换为Json        /// <summary>         /// DataSet转换为Json         /// </summary>         /// <param name="dataSet">DataSet对象</param>         /// <returns>Json字符串</returns>         public static string ToJson(DataSet dataSet)        {            string jsonString = "{";            foreach (DataTable table in dataSet.Tables)            {                jsonString += "\"" + table.TableName + "\":" + ToJson(table) + ",";            }            jsonString = jsonString.TrimEnd(',');            return jsonString + "}";        }        #endregion#region Datatable转换为Json        /// <summary>         /// Datatable转换为Json         /// </summary>         /// <param name="table">Datatable对象</param>         /// <returns>Json字符串</returns>         public static string ToJson(DataTable dt)        {            StringBuilder jsonString = new StringBuilder();            jsonString.Append("[");            DataRowCollection drc = dt.Rows;            for (int i = 0; i < drc.Count; i++)            {                jsonString.Append("{");                for (int j = 0; j < dt.Columns.Count; j++)                {                    string strKey = dt.Columns[j].ColumnName;                    string strValue = drc[i][j].ToString();                    Type type = dt.Columns[j].DataType;                    jsonString.Append("\"" + strKey + "\":");                    strValue = StringFormat(strValue, type);                    if (j < dt.Columns.Count - 1)                    {                        jsonString.Append(strValue + ",");                    }                    else                    {                        jsonString.Append(strValue);                    }                }                jsonString.Append("},");            }            jsonString.Remove(jsonString.Length - 1, 1);            jsonString.Append("]");            return jsonString.ToString();        }         /// <summary>        /// DataTable转换为Json         /// </summary>        public static string ToJson(DataTable dt, string jsonName)        {            StringBuilder Json = new StringBuilder();            if (string.IsNullOrEmpty(jsonName)) jsonName = dt.TableName;            Json.Append("{\"" + jsonName + "\":[");            if (dt.Rows.Count > 0)            {                for (int i = 0; i < dt.Rows.Count; i++)                {                    Json.Append("{");                    for (int j = 0; j < dt.Columns.Count; j++)                    {                        Type type = dt.Rows[i][j].GetType();                        Json.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + StringFormat(dt.Rows[i][j].ToString(), type));                        if (j < dt.Columns.Count - 1)                        {                            Json.Append(",");                        }                    }                    Json.Append("}");                    if (i < dt.Rows.Count - 1)                    {                        Json.Append(",");                    }                }            }            Json.Append("]}");            return Json.ToString();        }        #endregion         #region DataReader转换为Json        /// <summary>         /// DataReader转换为Json         /// </summary>         /// <param name="dataReader">DataReader对象</param>         /// <returns>Json字符串</returns>         public static string ToJson(DbDataReader dataReader)        {            StringBuilder jsonString = new StringBuilder();            jsonString.Append("[");            while (dataReader.Read())            {                jsonString.Append("{");                for (int i = 0; i < dataReader.FieldCount; i++)                {                    Type type = dataReader.GetFieldType(i);                    string strKey = dataReader.GetName(i);                    string strValue = dataReader[i].ToString();                    jsonString.Append("\"" + strKey + "\":");                    strValue = StringFormat(strValue, type);                    if (i < dataReader.FieldCount - 1)                    {                        jsonString.Append(strValue + ",");                    }                    else                    {                        jsonString.Append(strValue);                    }                }                jsonString.Append("},");            }            dataReader.Close();            jsonString.Remove(jsonString.Length - 1, 1);            jsonString.Append("]");            return jsonString.ToString();        }        #endregion    }} 

相关推荐
python开发_常用的python模块及安装方法
adodb:我们领导推荐的数据库连接组件bsddb3:BerkeleyDB的连接组件Cheetah-1.0:我比较喜欢这个版本的cheeta…
日期:2022-11-24 点赞:878 阅读:8,903
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接:http://www.codeforces.com/contest/660/problem/CDes…
日期:2022-11-24 点赞:807 阅读:5,428
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
日期:2022-11-24 点赞:569 阅读:6,245
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
日期:2022-11-24 点赞:733 阅读:6,057
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式,并且由于涉及到要把拍到的照片显…
日期:2022-11-24 点赞:512 阅读:7,688
Struts的使用
一、Struts2的获取  Struts的官方网站为:http://struts.apache.org/  下载完Struts2的jar包,…
日期:2022-11-24 点赞:671 阅读:4,726