/*------------------------------------------------------------------
|
-- COPYRIGHT (C) 2011-2020 hanhe
|
-- ALL RIGHTS RESERVED.
|
-- han he
|
-- CREATE DATE: 2014/06/27
|
-- CREATE MAN: 姜新军
|
-- 对象与JSON字符串互相转化类
|
-- MODIFY HISTORY:
|
-- MODIFY DATE:
|
-- MODIFY MAN:
|
-- MODIFY DESC:
|
-- MODIFY DATE:
|
-- MODIFY MAN:
|
-- MODIFY DESC:
|
---------------------------------------------------------------------*/
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
using System.IO;
|
using System.Text;
|
using System.ServiceModel.Web;
|
using System.Runtime.Serialization.Json;
|
using System.Reflection;
|
using System.Data;
|
using System.Text.RegularExpressions;
|
using System.Web.Script.Serialization;
|
using System.Collections;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;///记得引用这个命名空间
|
|
|
namespace HH.WMS.Common
|
{
|
/// <summary>
|
/// json类库
|
/// </summary>
|
public class JsonHelper
|
{
|
/// <summary>
|
/// 实例化
|
/// </summary>
|
public JsonHelper()
|
{
|
}
|
|
#region 把DataTable数据,转化成JSON字符串
|
/// <summary>
|
/// 把DataTable数据,转化成JSON字符串
|
/// </summary>
|
/// <param name="jsonName">对象名称</param>
|
/// <param name="dt">DataTable数据集</param>
|
/// <returns>JSON数组字符串</returns>
|
public static string DataTableToJson(string jsonName, DataTable dt, int total)
|
{
|
StringBuilder Json = new StringBuilder();
|
|
if (!string.IsNullOrEmpty(jsonName))
|
{
|
Json.Append("{\"" + jsonName + "\":[");
|
}
|
else
|
{
|
if (total > 0)
|
{
|
Json.Append("[");
|
}
|
}
|
|
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++)
|
{
|
string key = dt.Columns[j].ColumnName.ToString();
|
string value = dt.Rows[i][j].ToString().Trim();
|
//DateTime dts = DateTime.Now;
|
if (Util.IsTDateTime(value))
|
{
|
value = DateTime.Parse(value).ToString("yyyy-MM-dd");
|
}
|
Json.Append("\"" + key + "\":\"" + value.Replace("\"","”") + "\"");
|
if (j < dt.Columns.Count - 1)
|
{
|
Json.Append(",");
|
}
|
}
|
Json.Append("}");
|
if (i < dt.Rows.Count - 1)
|
{
|
Json.Append(",");
|
}
|
}
|
}
|
|
if (!string.IsNullOrEmpty(jsonName))
|
{
|
Json.Append("],");
|
Json.Append("\"total\":" + total + "");
|
Json.Append("}");
|
}
|
else
|
{
|
if (total > 0)
|
{
|
Json.Append("]");
|
}
|
}
|
return Json.ToString();
|
}
|
|
|
|
/// <summary>
|
/// 把DataTable数据,转化成JSON字符串
|
/// </summary>
|
/// <param name="jsonName">对象名称</param>
|
/// <param name="dt">DataTable数据集</param>
|
/// <param name="pageCount">总页数</param>
|
/// <param name="totalRecord">总记录数</param>
|
/// <returns>JSON数组字符串</returns>
|
public static string DataTableToJson(string jsonName, DataTable dt, int pageCount, int totalRecord)
|
{
|
StringBuilder Json = new StringBuilder();
|
|
if (!string.IsNullOrEmpty(jsonName))
|
{
|
Json.Append("{\"" + jsonName + "\":[");
|
}
|
else
|
{
|
if (totalRecord > 0)
|
{
|
Json.Append("[");
|
}
|
}
|
|
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++)
|
{
|
string key = dt.Columns[j].ColumnName.ToString();
|
string value = dt.Rows[i][j].ToString().Trim();
|
//DateTime dts = DateTime.Now;
|
if (Util.IsTDateTime(value))
|
{
|
value = DateTime.Parse(value).ToString("yyyy-MM-dd");
|
}
|
Json.Append("\"" + key + "\":\"" + value + "\"");
|
if (j < dt.Columns.Count - 1)
|
{
|
Json.Append(",");
|
}
|
}
|
Json.Append("}");
|
if (i < dt.Rows.Count - 1)
|
{
|
Json.Append(",");
|
}
|
}
|
}
|
|
if (!string.IsNullOrEmpty(jsonName))
|
{
|
Json.Append("],");
|
Json.Append("\"total\":" + totalRecord + ",\"pagecount\":" + pageCount + "");
|
Json.Append("}");
|
}
|
else
|
{
|
if (totalRecord > 0)
|
{
|
Json.Append("]");
|
}
|
}
|
return Json.ToString();
|
}
|
#endregion
|
|
#region 把JSON字符串转化为DataTable
|
/// <summary>
|
/// Json 字符串 转换为 DataTable数据集合
|
/// </summary>
|
/// <param name="json"></param>
|
/// <returns></returns>
|
public static DataTable JsonToDataTable(string jsonString)
|
{
|
DataTable dataTable = new DataTable(); //实例化
|
try
|
{
|
ArrayList arrayList = JsonConvert.DeserializeObject<ArrayList>(jsonString);
|
if (arrayList.Count > 0)
|
{
|
foreach (Dictionary<string, object> dictionary in arrayList)
|
{
|
if (dictionary.Keys.Count<string>() == 0)
|
{
|
return dataTable;
|
}
|
//Columns
|
if (dataTable.Columns.Count == 0)
|
{
|
foreach (string current in dictionary.Keys)
|
{
|
dataTable.Columns.Add(current, dictionary[current].GetType());
|
}
|
}
|
//Rows
|
DataRow dataRow = dataTable.NewRow();
|
foreach (string current in dictionary.Keys)
|
{
|
dataRow[current] = dictionary[current];
|
}
|
dataTable.Rows.Add(dataRow); //循环添加行到DataTable中
|
}
|
}
|
}
|
catch
|
{
|
}
|
return dataTable;
|
}
|
#endregion
|
|
#region 把LIST数据对象，转化成JSON数组字符串
|
/// <summary>
|
/// 把LIST数据对象，转化成JSON数组字符串
|
/// </summary>
|
/// <typeparam name="IL">对象集合</typeparam>
|
/// <param name="jsonName">JSON名称</param>
|
/// <returns>JSON数组字符串</returns>
|
public static string IListToJson<T>(string jsonName, IList<T> IL, long totalRows)
|
{
|
StringBuilder Json = new StringBuilder();
|
if (!string.IsNullOrEmpty(jsonName))
|
{
|
Json.Append("{\"" + jsonName + "\":[");
|
}
|
else
|
{
|
Json.Append("[");
|
}
|
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++)
|
{
|
object value = pis[j].GetValue(IL[i], null);
|
//处理日期类型
|
if (Util.IsTDateTime(value))
|
{
|
//格式化日期
|
value = Util.ToString(Convert.ToDateTime(value), "yyyy-MM-dd HH:mm:ss");
|
//格式化成JSON日期。
|
string pattern = @"\\/Date\((\d+)\+\d+\)\\/";
|
MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertJsonDateToDateString);
|
Regex reg = new Regex(pattern);
|
value = reg.Replace(value.ToString(), matchEvaluator);
|
}
|
Json.Append("\"" + pis[j].Name.ToString() + "\":\"" + value + "\"");
|
if (j < pis.Length - 1)
|
{
|
Json.Append(",");
|
}
|
}
|
Json.Append("}");
|
if (i < IL.Count - 1)
|
{
|
Json.Append(",");
|
}
|
}
|
}
|
|
if (!string.IsNullOrEmpty(jsonName))
|
{
|
if (totalRows >= 0)
|
{
|
Json.Append("],\"total\":\"" + totalRows + "\"}");
|
}
|
else
|
{
|
Json.Append("]}");
|
|
}
|
}
|
else
|
{
|
Json.Append("]");
|
}
|
|
return Json.ToString();
|
}
|
|
/// <summary>
|
/// 把LIST数据对象，转化成JSON数组字符串
|
/// </summary>
|
/// <typeparam name="IL">对象集合</typeparam>
|
/// <param name="jsonName">JSON名称</param>
|
/// <param name="totalRows">总记录数</param>
|
/// <param name="pageCount">总页数</param>
|
/// <returns>JSON数组字符串</returns>
|
public static string IListToJson<T>(string jsonName, IList<T> IL, long totalRows, long pageCount)
|
{
|
StringBuilder Json = new StringBuilder();
|
if (!string.IsNullOrEmpty(jsonName))
|
{
|
Json.Append("{\"" + jsonName + "\":[");
|
}
|
else
|
{
|
Json.Append("[");
|
}
|
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++)
|
{
|
object value = pis[j].GetValue(IL[i], null);
|
//处理日期类型
|
if (Util.IsTDateTime(value))
|
{
|
//格式化日期
|
value = Util.ToString(Convert.ToDateTime(value), "yyyy-MM-dd HH:mm:ss");
|
//格式化成JSON日期。
|
string pattern = @"\\/Date\((\d+)\+\d+\)\\/";
|
MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertJsonDateToDateString);
|
Regex reg = new Regex(pattern);
|
value = reg.Replace(value.ToString(), matchEvaluator);
|
}
|
Json.Append("\"" + pis[j].Name.ToString() + "\":\"" + value + "\"");
|
if (j < pis.Length - 1)
|
{
|
Json.Append(",");
|
}
|
}
|
Json.Append("}");
|
if (i < IL.Count - 1)
|
{
|
Json.Append(",");
|
}
|
}
|
}
|
|
if (!string.IsNullOrEmpty(jsonName))
|
{
|
if (totalRows >= 0)
|
{
|
Json.Append("],\"total\":\"" + totalRows + "\",\"pagecount\":\"" + pageCount + "\"}");
|
}
|
else
|
{
|
Json.Append("]}");
|
|
}
|
}
|
else
|
{
|
Json.Append("]");
|
}
|
|
return Json.ToString();
|
}
|
#endregion
|
|
#region 把对象序列化 JSON 字符串
|
/// <summary>
|
/// 把对象序列化 JSON 字符串
|
/// </summary>
|
/// <typeparam name="T">对象类型</typeparam>
|
/// <param name="obj">对象实体</param>
|
/// <returns>JSON字符串</returns>
|
public static string GetJson<T>(T obj)
|
{
|
//记住 添加引用 System.ServiceModel.Web
|
/**
|
* 如果不添加上面的引用,System.Runtime.Serialization.Json; Json是出不来的哦
|
* */
|
DataContractJsonSerializer json = new DataContractJsonSerializer(typeof(T));
|
using (MemoryStream ms = new MemoryStream())
|
{
|
json.WriteObject(ms, obj);
|
string szJson = Encoding.UTF8.GetString(ms.ToArray());
|
|
return szJson;
|
}
|
}
|
#endregion
|
|
#region 把JSON字符串还原为对象
|
/// <summary>
|
/// 把JSON字符串还原为对象
|
/// </summary>
|
/// <typeparam name="T">对象类型</typeparam>
|
/// <param name="szJson">JSON字符串</param>
|
/// <returns>对象实体</returns>
|
public static T ParseFormJson<T>(string szJson)
|
{
|
T obj = Activator.CreateInstance<T>();
|
using (MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(szJson)))
|
{
|
|
DataContractJsonSerializer dcj = new DataContractJsonSerializer(typeof(T));
|
|
return (T)dcj.ReadObject(ms);
|
|
|
}
|
}
|
#endregion
|
|
#region 将JSON字符串转换成对象集合
|
/// <summary>
|
/// 将JSON字符串转换成对象集合
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="JsonStr"></param>
|
/// <returns></returns>
|
public static List<T> JSONStringToList<T>(string JsonStr)
|
{
|
JavaScriptSerializer Serializer = new JavaScriptSerializer();
|
Serializer.MaxJsonLength = Int32.MaxValue;
|
List<T> objs = Serializer.Deserialize<List<T>>(JsonStr);
|
return objs;
|
}
|
#endregion
|
|
#region 将Model对象转换成JsonString
|
public static string ModelToJsonString<T>(T model)
|
{
|
|
JavaScriptSerializer serializer = new JavaScriptSerializer();
|
serializer.MaxJsonLength = int.MaxValue;
|
return serializer.Serialize(model);
|
}
|
#endregion
|
|
#region 将json字符串转换为DataTable
|
/// <summary>
|
/// 将json转换为DataTable
|
/// </summary>
|
/// <param name="strJson">得到的json</param>
|
/// <returns>返回datatable</returns>
|
/// <history>[HanHe(ZMM)] CREATED 2017/10/12</history>
|
public static DataTable JsonToDT(string strJson)
|
{
|
try
|
{
|
if (string.IsNullOrEmpty(strJson))
|
{
|
return null;
|
}
|
//转换json格式
|
strJson = strJson.Replace(",\"", "$$$\"").Replace("\":", "\"&&&").ToString();
|
//取出表名
|
var rg = new Regex(@"(?<={)[^:]+(?=:\[)", RegexOptions.IgnoreCase);
|
string strName = "test";// rg.Match(strJson).Value;
|
DataTable tb = null;
|
if (strJson.IndexOf("[") > -1)
|
{
|
//去除表名
|
strJson = strJson.Substring(strJson.IndexOf("[") + 1);
|
}
|
if (strJson.IndexOf("]") > -1)
|
{
|
strJson = strJson.Substring(0, strJson.IndexOf("]"));
|
}
|
|
//获取数据
|
rg = new Regex(@"(?<={)[^}]+(?=})");
|
MatchCollection mc = rg.Matches(strJson);
|
for (int i = 0; i < mc.Count; i++)
|
{
|
string strRow = mc[i].Value;
|
//string[] strRows = strRow.Split('*');
|
string[] strRows = strRow.Split(new string[] { "$$$" }, StringSplitOptions.RemoveEmptyEntries);
|
//创建表
|
if (tb == null)
|
{
|
tb = new DataTable();
|
tb.TableName = strName;
|
foreach (string str in strRows)
|
{
|
var dc = new DataColumn();
|
//string[] strCell = str.Split('#');
|
string[] strCell = str.Split(new string[] { "&&&" }, StringSplitOptions.RemoveEmptyEntries);
|
if (strCell[0].Substring(0, 1) == "\"")
|
{
|
int a = strCell[0].Length;
|
dc.ColumnName = strCell[0].Substring(1, a - 2);
|
}
|
else
|
{
|
dc.ColumnName = strCell[0];
|
}
|
tb.Columns.Add(dc);
|
}
|
tb.AcceptChanges();
|
}
|
|
//增加内容
|
DataRow dr = tb.NewRow();
|
for (int r = 0; r < strRows.Length; r++)
|
{
|
//dr[r] = strRows[r].Split('#')[1].Trim().Replace("，", ",").Replace("：", ":").Replace("\"", "");
|
dr[r] = strRows[r].Split(new string[] { "&&&" }, StringSplitOptions.RemoveEmptyEntries)[1].Trim().Replace("，", ",").Replace("：", ":").Replace("\"", "");
|
}
|
tb.Rows.Add(dr);
|
tb.AcceptChanges();
|
}
|
|
return tb;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
#endregion
|
|
/// <summary>
|
/// 将Json序列化的时间由/Date(1294499956278+0800)转为字符串
|
/// </summary>
|
private static string ConvertJsonDateToDateString(Match m)
|
{
|
string result = string.Empty;
|
DateTime dt = new DateTime(1970, 1, 1);
|
dt = dt.AddMilliseconds(long.Parse(m.Groups[1].Value));
|
dt = dt.ToLocalTime();
|
result = dt.ToString("yyyy-MM-dd HH:mm:ss");
|
return result;
|
}
|
|
/// <summary>
|
/// 将时间字符串转为Json时间
|
/// </summary>
|
private static string ConvertDateStringToJsonDate(Match m)
|
{
|
string result = string.Empty;
|
DateTime dt = DateTime.Parse(m.Groups[0].Value);
|
dt = dt.ToUniversalTime();
|
TimeSpan ts = dt - DateTime.Parse("1970-01-01");
|
result = string.Format("/Date({0}+0800)/", ts.TotalMilliseconds);
|
return result;
|
}
|
|
/// <summary>
|
/// 将时间字符串转为Json时间
|
/// </summary>
|
private static string ConvertDateStringToJsonDate(string DateTime)
|
{
|
string result = string.Empty;
|
DateTime dt = Convert.ToDateTime(DateTime);
|
dt = dt.ToUniversalTime();
|
TimeSpan ts = dt - Convert.ToDateTime("1970-01-01");
|
result = string.Format("/Date({0}+0800)/", ts.TotalMilliseconds);
|
return result;
|
}
|
|
/// <summary>
|
/// 是否为日期+时间型字符串
|
/// </summary>
|
/// <param name="source"></param>
|
/// <returns></returns>
|
public static bool IsTDateTime(string StrSource)
|
{
|
return Regex.IsMatch(StrSource, @"^(((((1[6-9]|[2-9]d)d{2})-(0?|1)-(0?[1-9]|d|3))|(((1[6-9]|[2-9]d)d{2})-(0?|1)-(0?[1-9]|d|30))|(((1[6-9]|[2-9]d)d{2})-0?2-(0?[1-9]|1d|2[0-8]))|(((1[6-9]|[2-9]d)(0||)|((16||)00))-0?2-29-)) (20|21|22|23|[0-1]?d):[0-5]?d:[0-5]?d)$ ");
|
}
|
|
|
/// <summary>
|
|
/// Convert a List{T} to a DataTable.
|
|
/// </summary>
|
|
public static DataTable ToDataTable<T>(List<T> items)
|
{
|
|
var tb = new DataTable(typeof(T).Name);
|
PropertyInfo[] props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
|
foreach (PropertyInfo prop in props)
|
{
|
Type t = GetCoreType(prop.PropertyType);
|
tb.Columns.Add(prop.Name, t);
|
}
|
|
foreach (T item in items)
|
{
|
var values = new object[props.Length];
|
for (int i = 0; i < props.Length; i++)
|
{
|
values[i] = props[i].GetValue(item, null);
|
}
|
tb.Rows.Add(values);
|
}
|
return tb;
|
}
|
|
|
|
/// <summary>
|
|
/// Determine of specified type is nullable
|
|
/// </summary>
|
|
public static bool IsNullable(Type t)
|
{
|
return !t.IsValueType || (t.IsGenericType && t.GetGenericTypeDefinition() == typeof(Nullable<>));
|
}
|
|
/// <summary>
|
/// Return underlying type if type is Nullable otherwise return the type
|
/// </summary>
|
public static Type GetCoreType(Type t)
|
{
|
if (t != null && IsNullable(t))
|
{
|
if (!t.IsValueType)
|
{
|
return t;
|
}
|
|
else
|
{
|
return Nullable.GetUnderlyingType(t);
|
}
|
}
|
|
else
|
{
|
return t;
|
}
|
}
|
|
public static string GetValue(string name)
|
{
|
try
|
{
|
var jsonFile = System.AppDomain.CurrentDomain.BaseDirectory + "\\Config.json";
|
using (System.IO.StreamReader file = System.IO.File.OpenText(jsonFile))
|
{
|
using (JsonTextReader reader = new JsonTextReader(file))
|
{
|
JObject o = (JObject)JToken.ReadFrom(reader);
|
var value = o[name].ToString();
|
return value.Replace("\r\n", "");
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
Log.Detail("获取json文件", "值timeSpan失败！原因：" + ex.Message);
|
return "";
|
}
|
|
}
|
}
|
}
|
