JSON序列化和反序列化日期时间的处理（.NET）

JSON格式不直接支持日期和时间。DateTime值值显示为“/Date(700000+0500)/”形式的JSON字符串，其中第一个数字 （在提供的示例中为 700000）是 GMT 时区中自 1970 年 1 月 1 日午夜以来按正常时间（非夏令时）经过的毫秒数。该数字可以是负数，以表示之前的时间。示例中包括“+0500”的部分可选，它指示该时间属于Local 类型，即它在反序列化时应转换为本地时区。如果没有该部分，则会将时间反序列化为Utc。

     修改Person类，添加LastLoginTime：

   1: public class Person

   2: {

   3:     public string Name { get; set; }

   4:     public int Age { get; set; }

   5:     public DateTime LastLoginTime { get; set; }

   6: }

   1: Person p = new Person();

   2: p.Name = "张三";

   3: p.Age = 28;

   4: p.LastLoginTime = DateTime.Now;

   5:  

   6: string jsonString = JsonHelper.JsonSerializer<Person>(p);

     序列化结果：

{"Age":28,"LastLoginTime":"\/Date(1294499956278+0800)\/","Name":"张三"}

     1 、在后台使用正则表达式对其替换处理。修改JsonHelper：

   1: using System;

   2: using System.Collections.Generic;

   3: using System.Linq;

   4: using System.Web;

   5: using System.Runtime.Serialization.Json;

   6: using System.IO;

   7: using System.Text;

   8: using System.Text.RegularExpressions;

   9:  

  10: /// <summary>

  11: /// JSON序列化和反序列化辅助类

  12: /// </summary>

  13: public class JsonHelper

  14: {

  15:     /// <summary>

  16:     /// JSON序列化

  17:     /// </summary>

  18:     public static string JsonSerializer<T>(T t)

  19:     {

  20:         DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(T));

  21:         MemoryStream ms = new MemoryStream();

  22:         ser.WriteObject(ms, t);

  23:         string jsonString = Encoding.UTF8.GetString(ms.ToArray());

  24:         ms.Close();

  25:         //替换Json的Date字符串

  26:         string p = @"\\/Date\((\d+)\+\d+\)\\/";

  27:         MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertJsonDateToDateString);

  28:          Regex reg = new Regex(p);

  29:         jsonString = reg.Replace(jsonString, matchEvaluator);

  30:         return jsonString;

  31:     }

  32:  

  33:     /// <summary>

  34:     /// JSON反序列化

  35:     /// </summary>

  36:     public static T JsonDeserialize<T>(string jsonString)

  37:     {

  38:         //将"yyyy-MM-dd HH:mm:ss"格式的字符串转为"\/Date(1294499956278+0800)\/"格式

  39:         string p = @"\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}";

  40:         MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertDateStringToJsonDate);

  41:         Regex reg = new Regex(p);

  42:         jsonString = reg.Replace(jsonString, matchEvaluator);

  43:         DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(T));

  44:         MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(jsonString));

  45:         T obj = (T)ser.ReadObject(ms);

  46:         return obj;

  47:     }

  48:  

  49:     /// <summary>

  50:     /// 将Json序列化的时间由/Date(1294499956278+0800)转为字符串

  51:     /// </summary>

  52:     private static string ConvertJsonDateToDateString(Match m)

  53:     {

  54:         string result = string.Empty;

  55:         DateTime dt = new DateTime(1970,1,1);

  56:         dt = dt.AddMilliseconds(long.Parse(m.Groups[1].Value));

  57:         dt = dt.ToLocalTime();

  58:         result = dt.ToString("yyyy-MM-dd HH:mm:ss");

  59:         return result;

  60:     }

  61:  

  62:     /// <summary>

  63:     /// 将时间字符串转为Json时间

  64:     /// </summary>

  65:     private static string ConvertDateStringToJsonDate(Match m)

  66:     {

  67:         string result = string.Empty;

  68:         DateTime dt = DateTime.Parse(m.Groups[0].Value);

  69:         dt = dt.ToUniversalTime();

  70:         TimeSpan ts = dt - DateTime.Parse("1970-01-01");

  71:         result = string.Format("\\/Date({0}+0800)\\/",ts.TotalMilliseconds);

  72:         return result;

  73:     }

  74: }

       序列化Demo：

   1: Person p = new Person();

   2: p.Name = "张三";

   3: p.Age = 28;

   4: p.LastLoginTime = DateTime.Now;

   5:  

   6: string jsonString = JsonHelper.JsonSerializer<Person>(p);

       运行结果：

{"Age":28,"LastLoginTime":"2011-01-09 01:00:56","Name":"张三"}

       反序列化Demo：

string json = "{\"Age\":28,\"LastLoginTime\":\"2011-01-09 00:30:00\",\"Name\":\"张三\"}";

p=JsonHelper.JsonDeserialize<Person>(json);

        运行结果：

     在后台替换字符串适用范围比较窄，如果考虑到全球化的有多种语言还会更麻烦。

     2、利用JavaScript处理

   1: function ChangeDateFormat(jsondate) {

   2:     jsondate = jsondate.replace("/Date(", "").replace(")/", "");

   3:     if (jsondate.indexOf("+") > 0) {

   4:         jsondate = jsondate.substring(0, jsondate.indexOf("+"));

   5:     }

   6:     else if (jsondate.indexOf("-") > 0) {

   7:         jsondate = jsondate.substring(0, jsondate.indexOf("-"));

   8:     }

   9:  

  10:     var date = new Date(parseInt(jsondate, 10));

  11:     var month = date.getMonth() + 1 < 10 ? "0" + (date.getMonth() + 1) : date.getMonth() + 1;

  12:     var currentDate = date.getDate() < 10 ? "0" + date.getDate() : date.getDate();

  13:     return date.getFullYear() + "-" + month + "-" + currentDate;

  14: }

    简单Demo ：

　　ChangeDateFormat("\/Date(1294499956278+0800)\/");

     结果：

2011-1-8 

原文地址：

http://www.cnblogs.com/zhaozhan/archive/2011/01/09/1931340.html

转载于:https://www.cnblogs.com/jeriffe/articles/2084271.html