• 转换Json格式帮助类


    using System;
    using System.Collections.Generic;
    using System.Text;
    using System.Reflection;
    using System.Data;
    using System.Collections;
    
    namespace AIMSCommon
    {
        /// <summary>
        /// 转换Json格式帮助类
        /// </summary>
        public class JsonHelper
        {
            /// <summary>
            /// 泛型接口转Json
            /// </summary>
            /// <typeparam name="T"></typeparam>
            /// <param name="list"></param>
            /// <returns></returns>
            public static string IListToJson<T>(IList<T> list)
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("[");
                foreach (T t in list)
                {
                    sb.Append(ObjectToJson(t) + ",");
                }
                string _temp = sb.ToString().TrimEnd(',');
                _temp += "]";
                return _temp;
            }
            /// <summary>
            /// 泛型接口转Json
            /// </summary>
            /// <typeparam name="T"></typeparam>
            /// <param name="list"></param>
            /// <param name="ClassName"></param>
            /// <returns>{"rows":[{"c_id":"21bb6911-af52-42a4-9732-24a6e8384411","eav_id":"4a9fe8ca-112a-47c0-b074-229837cfe6e6","e_id":"cfe929e3-accd-4efb-910b-07705077b6d6","ea_id":"","ea_name":"555","eav_value":"555","eav_memo":"","sud":"0"}]}</returns>
            public static string IListToJson<T>(IList<T> list, string ClassName)
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("{"" + ClassName + "":[");
                foreach (T t in list)
                {
                    sb.Append(ObjectToJson(t) + ",");
                }
                string _temp = sb.ToString().TrimEnd(',');
                _temp += "]}";
                return _temp;
            }
            /// <summary>
            /// 对象转Json
            /// </summary>
            /// <typeparam name="T"></typeparam>
            /// <param name="t"></param>
            /// <returns>{"SM_ID":"71","SM_Img":"title.gif","SM_Memo":"当前位置:会所服务 ─ 宾客管理 ─ 宾客列表"}</returns>
            public static string ObjectToJson<T>(T t)
            {
                StringBuilder sb = new StringBuilder();
                string json = "";
                if (t != null)
                {
                    sb.Append("{");
                    PropertyInfo[] properties = t.GetType().GetProperties();
                    foreach (PropertyInfo pi in properties)
                    {
                        sb.Append(""" + pi.Name.ToString() + """);
                        sb.Append(":");
                        sb.Append(""" + pi.GetValue(t, null) + """);
                        sb.Append(",");
                    }
                    json = sb.ToString().TrimEnd(',');
                    json += "}";
                }
                return json;
            }
            /// <summary>
            /// 对象转Json(重载)
            /// </summary>
            /// <typeparam name="T"></typeparam>
            /// <param name="t"></param>
            /// <param name="ClassName"></param>
            /// <returns>{"menu":[{"SM_ID":"71","SM_Img":"title.gif","SM_Memo":"当前位置:会所服务 ─ 宾客管理 ─ 宾客列表"}]}</returns>
            public static string ObjectToJson<T>(T t, string ClassName)
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("{"" + ClassName + "":[");
                string json = "";
                if (t != null)
                {
                    sb.Append("{");
                    PropertyInfo[] properties = t.GetType().GetProperties();
                    foreach (PropertyInfo pi in properties)
                    {
                        sb.Append(""" + pi.Name.ToString() + """);//.ToLower()
                        sb.Append(":");
                        sb.Append(""" + pi.GetValue(t, null) + """);
                        sb.Append(",");
                    }
                    json = sb.ToString().TrimEnd(',');
                    json += "}]}";
                }
                return json;
            }
            /// <summary>
            /// List转成json
            /// </summary>
            /// <typeparam name="T"></typeparam>
            /// <param name="jsonName"></param>
            /// <param name="IL"></param>
            /// <returns></returns>
            public static string ObjectToJson<T>(IList<T> IL, string jsonName)
            {
                StringBuilder Json = new StringBuilder();
                Json.Append("{"" + jsonName + "":[");
                if (IL.Count > 0)
                {
                    for (int i = 0; i < IL.Count; i++)
                    {
                        T obj = Activator.CreateInstance<T>();
                        Type type = obj.GetType();
                        PropertyInfo[] pis = type.GetProperties();
                        Json.Append("{");
                        for (int j = 0; j < pis.Length; j++)
                        {
                            Json.Append(""" + pis[j].Name.ToString() + "":"" + pis[j].GetValue(IL[i], null) + """);
                            if (j < pis.Length - 1)
                            {
                                Json.Append(",");
                            }
                        }
                        Json.Append("}");
                        if (i < IL.Count - 1)
                        {
                            Json.Append(",");
                        }
                    }
                }
                Json.Append("]}");
                return Json.ToString();
            }
    
            /// <summary>
            /// 将数组转换为JSON格式的字符串
            /// </summary>
            /// <typeparam name="T">数据类型,如string,int ...</typeparam>
            /// <param name="list">泛型list</param>
            /// <param name="propertyname">JSON的类名</param>
            /// <returns></returns>
            public static string ArrayToJson<T>(List<T> list, string propertyname)
            {
                StringBuilder sb = new StringBuilder();
                if (list.Count > 0)
                {
                    sb.Append("[{"");
                    sb.Append(propertyname);
                    sb.Append("":[");
                    foreach (T t in list)
                    {
                        sb.Append(""");
                        sb.Append(t.ToString());
                        sb.Append("",");
                    }
                    string _temp = sb.ToString();
                    _temp = _temp.TrimEnd(',');
                    _temp += "]}]";
                    return _temp;
                }
                else
                    return "";
            }
    
            /// <summary>
            /// DataTable转Json
            /// </summary>
            /// <param name="dt">table数据集</param>
            /// <param name="dtName">json名</param>
            /// <returns></returns>
            public static string DataTableToJson(DataTable dt, string dtName)
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("{"");
                sb.Append(dtName);
                sb.Append("":[");
                if (DataTableHelper.IsExistRows(dt))
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        sb.Append("{");
                        foreach (DataColumn dc in dr.Table.Columns)
                        {
                            sb.Append(""");
                            sb.Append(dc.ColumnName);
                            sb.Append("":"");
                            if (dr[dc] != null && dr[dc] != DBNull.Value && dr[dc].ToString() != "")
                                sb.Append(dr[dc]).Replace("\", "/");
                            else
                                sb.Append(" ");
                            sb.Append("",");
                        }
                        sb = sb.Remove(sb.Length - 1, 1);
                        sb.Append("},");
                    }
                    sb = sb.Remove(sb.Length - 1, 1);
                }
                sb.Append("]}");
                return JsonCharFilter(sb.ToString());
            }
    
            /// <summary>
            /// 数据行转Json
            /// </summary>
            /// <param name="dr">数据行</param>
            /// <returns></returns>
            public static string DataRowToJson(DataRow dr)
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("{");
                foreach (DataColumn dc in dr.Table.Columns)
                {
                    sb.Append(""");
                    sb.Append(dc.ColumnName);
                    sb.Append("":"");
                    if (dr[dc] != null && dr[dc] != DBNull.Value && dr[dc].ToString() != "")
                        sb.Append(dr[dc]);
                    else
                        sb.Append(" ");
                    sb.Append("",");
                }
                sb = sb.Remove(0, sb.Length - 1);
                sb.Append("},");
                return sb.ToString();
            }
    
            /// <summary>
            /// 数组转Json
            /// </summary>
            /// <param name="strs"></param>
            /// <returns></returns>
            public static string ArrayToJson(string[] strs)
            {
                StringBuilder sb = new StringBuilder();
                for (int i = 0; i < strs.Length; i++)
                {
                    sb.AppendFormat("'{0}':'{1}',", i + 1, strs[i]);
                }
                if (sb.Length > 0)
                    return "{" + sb.ToString().TrimEnd(',') + "}";
                return "";
            }
    
            #region ListToJson
            /// <summary>
            /// list 转换json格式
            /// </summary>
            /// <param name="jsonName">类名</param>
            /// <param name="objlist">list集合</param>
            /// <returns></returns>
            public static string ListToJson<T>(List<T> objlist, string jsonName)
            {
                string result = "{";
                //如果没有给定类的名称, 指定一个
                if (jsonName.Equals(string.Empty))
                {
                    object o = objlist[0];
                    jsonName = o.GetType().ToString();
                }
                result += """ + jsonName + "":[";
                //处理第一行前面不加","号
                bool firstline = true;
                foreach (object oo in objlist)
                {
                    if (!firstline)
                    {
                        result = result + "," + ObjectToJson(oo);
                    }
                    else
                    {
                        result = result + ObjectToJson(oo) + "";
                        firstline = false;
                    }
                }
                return result + "]}";
            }
            /// <summary>
            /// 单个对象转换json
            /// </summary>
            /// <param name="o">对象</param>
            /// <returns></returns>
            private static string ObjectToJson(object o)
            {
                string result = "{";
                List<string> ls_propertys = new List<string>();
                ls_propertys = GetObjectProperty(o);
                foreach (string str_property in ls_propertys)
                {
                    if (result.Equals("{"))
                    {
                        result = result + str_property;
                    }
                    else
                    {
                        result = result + "," + str_property + "";
                    }
                }
                return result + "}";
            }
            /// <summary>
            /// 获取对象属性
            /// </summary>
            /// <param name="o">对象</param>
            /// <returns></returns>
            private static List<string> GetObjectProperty(object o)
            {
                List<string> propertyslist = new List<string>();
                PropertyInfo[] propertys = o.GetType().GetProperties();
                foreach (PropertyInfo p in propertys)
                {
                    propertyslist.Add(""" + p.Name.ToString() + "":"" + p.GetValue(o, null) + """);
    
                }
                return propertyslist;
            }
    
    
            #endregion
    
            public static string HashtableToJson(Hashtable data, string dtName)
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("{"");
                sb.Append(dtName);
                sb.Append("":[{");
                foreach (object key in data.Keys)
                {
                    object value = data[key];
                    sb.Append(""");
                    sb.Append(key);
                    sb.Append("":"");
                    if (!String.IsNullOrEmpty(value.ToString()) && value != DBNull.Value)
                    {
                        sb.Append(value).Replace("\", "/");
                    }
                    else
                    {
                        sb.Append(" ");
                    }
                    sb.Append("",");
                }
                sb = sb.Remove(sb.Length - 1, 1);
                sb.Append("}]}");
                return JsonCharFilter(sb.ToString());
            }
            /// <summary>  
            /// Json特符字符过滤
            /// </summary>  
            /// <param name="sourceStr">要过滤的源字符串</param>  
            /// <returns>返回过滤的字符串</returns>  
            private static string JsonCharFilter(string sourceStr)
            {
                return sourceStr;
            }
        }
    }
    
  • 相关阅读:
    了解JVM原理
    封装JS
    “==”和Equals的区别
    SpringMVC请求RequestMapping() 请求乱码
    博客25周
    博客24周
    博客23周
    博客22周
    博客第21周
    博客第21周
  • 原文地址:https://www.cnblogs.com/zhangxiaolei521/p/5661002.html
Copyright © 2020-2023  润新知