351 lines
11 KiB
C#
351 lines
11 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Text;
|
|
using System.Data;
|
|
using System.Collections;
|
|
using System.Reflection;
|
|
using System.IO;
|
|
using System.Web.Script.Serialization;
|
|
|
|
namespace SuperMap.RealEstate.HighWay.Compents.ExpenseBill
|
|
{
|
|
public class JsonHelper
|
|
{
|
|
|
|
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(new char[] { ',' }) + "}");
|
|
}
|
|
return "";
|
|
}
|
|
|
|
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("\",");
|
|
}
|
|
return (sb.ToString().TrimEnd(new char[] { ',' }) + "]}]");
|
|
}
|
|
return "";
|
|
}
|
|
|
|
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();
|
|
}
|
|
|
|
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].ToString().Replace("\"", "'").Replace("'", "“")).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());
|
|
}
|
|
|
|
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(string.Concat(new object[] { "\"", p.Name.ToString(), "\":\"", p.GetValue(o, null), "\"" }));
|
|
}
|
|
return propertyslist;
|
|
}
|
|
|
|
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());
|
|
}
|
|
|
|
public static string IListToJson<T>(IList<T> list, bool FlagBool = false)
|
|
{
|
|
StringBuilder sb = new StringBuilder();
|
|
sb.Append("[");
|
|
foreach (T t in list)
|
|
{
|
|
sb.Append(ObjectToJson<T>(t, FlagBool) + ",");
|
|
}
|
|
return (sb.ToString().TrimEnd(new char[] { ',' }) + "]");
|
|
}
|
|
|
|
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>(t) + ",");
|
|
}
|
|
return (sb.ToString().TrimEnd(new char[] { ',' }) + "]}");
|
|
}
|
|
|
|
private static string JsonCharFilter(string sourceStr)
|
|
{
|
|
return sourceStr;
|
|
}
|
|
|
|
|
|
public static string ListToJson<T>(List<T> objlist, string jsonName,bool ObjectName = true)
|
|
{
|
|
string result = string.Empty;
|
|
if (ObjectName)
|
|
{
|
|
result += "{";
|
|
if (jsonName.Equals(string.Empty))
|
|
{
|
|
object o = objlist[0];
|
|
jsonName = o.GetType().ToString();
|
|
result = result + "\"" + jsonName + "\":[";
|
|
}
|
|
else
|
|
{
|
|
result = result + "\"" + jsonName + "\":[";
|
|
}
|
|
}
|
|
else
|
|
{
|
|
result = "[";
|
|
}
|
|
|
|
bool firstline = true;
|
|
foreach (object oo in objlist)
|
|
{
|
|
if (!firstline)
|
|
{
|
|
result = result + "," + ObjectToJson(oo);
|
|
}
|
|
else
|
|
{
|
|
result = result + ObjectToJson(oo);
|
|
firstline = false;
|
|
}
|
|
}
|
|
if (ObjectName)
|
|
{
|
|
return (result + "]}");
|
|
}
|
|
else
|
|
{
|
|
return (result + "]");
|
|
}
|
|
}
|
|
|
|
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 + "}");
|
|
}
|
|
|
|
public static string ObjectToJson<T>(T t,bool FlagBool = false)
|
|
{
|
|
FlagBool = false;
|
|
StringBuilder sb = new StringBuilder();
|
|
string json = "";
|
|
if (t == null)
|
|
{
|
|
return json;
|
|
}
|
|
sb.Append("{");
|
|
PropertyInfo[] properties = t.GetType().GetProperties();
|
|
foreach (PropertyInfo pi in properties)
|
|
{
|
|
sb.Append("\"" + pi.Name.ToString() + "\"");
|
|
sb.Append(":");
|
|
if (FlagBool == true && pi.PropertyType.ToString() == "System.Boolean")
|
|
{
|
|
sb.Append( pi.GetValue(t, null) );
|
|
}
|
|
else
|
|
{
|
|
sb.Append("\"" + pi.GetValue(t, null) + "\"");
|
|
}
|
|
sb.Append(",");
|
|
}
|
|
return (sb.ToString().TrimEnd(new char[] { ',' }) + "}");
|
|
}
|
|
|
|
public static string ObjectToJson<T>(T t, string ClassName)
|
|
{
|
|
StringBuilder sb = new StringBuilder();
|
|
sb.Append("{\"" + ClassName + "\":[");
|
|
string json = "";
|
|
if (t == null)
|
|
{
|
|
return json;
|
|
}
|
|
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(",");
|
|
}
|
|
return (sb.ToString().TrimEnd(new char[] { ',' }) + "}]}");
|
|
}
|
|
|
|
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++)
|
|
{
|
|
PropertyInfo[] pis = Activator.CreateInstance<T>().GetType().GetProperties();
|
|
Json.Append("{");
|
|
for (int j = 0; j < pis.Length; j++)
|
|
{
|
|
Json.Append(string.Concat(new object[] { "\"", 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格式数组转化为对应的List<T>
|
|
/// </summary>
|
|
/// <typeparam name="T"></typeparam>
|
|
/// <param name="JsonStr">JSON格式数组</param>
|
|
/// <returns></returns>
|
|
public static List<T> JSONStringToList<T>(string JsonStr)
|
|
{
|
|
JavaScriptSerializer Serializer = new JavaScriptSerializer();
|
|
//设置转化JSON格式时字段长度
|
|
List<T> objs = Serializer.Deserialize<List<T>>(JsonStr);
|
|
return objs;
|
|
}
|
|
|
|
|
|
public static Object Json2Obj(String json, Type t)
|
|
{
|
|
|
|
try
|
|
{
|
|
System.Runtime.Serialization.Json.DataContractJsonSerializer serializer = new System.Runtime.Serialization.Json.DataContractJsonSerializer(t);
|
|
using (MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(json)))
|
|
{
|
|
return serializer.ReadObject(ms);
|
|
}
|
|
}
|
|
catch
|
|
{
|
|
return null;
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
}
|