JavaScriptSerializer中日期序列化问题解决方案

huanShion

于 2017-08-28 15:43:09 发布

阅读量903

点赞数

分类专栏：数据库 C# 文章标签： c#

数据库同时被 2 个专栏收录

15 篇文章 0 订阅

订阅专栏

8 篇文章 0 订阅

订阅专栏

关键码：

            DataTable dt = sc.App_Code.SQLHelper.GetDataTable(sql);

            JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
            javaScriptSerializer.MaxJsonLength = Int32.MaxValue; //取得最大数值
            ArrayList arrayList = new ArrayList();
            foreach (DataRow dataRow in dt.Rows)
            {
                Dictionary<string, object> dictionary = new Dictionary<string, object>(); 
                foreach (DataColumn dataColumn in (dt.Columns))
                {
                    dictionary.Add(dataColumn.ColumnName, dataRow[dataColumn.ColumnName]);
                }
                arrayList.Add(dictionary); //ArrayList集合中添加键值
            }
            var returnList = javaScriptSerializer.Serialize(arrayList);
            returnList = Regex.Replace(returnList, @"\\/Date\((\d+)\)\\/", match =>
                {
                    DateTime dtm = new DateTime(1970, 1, 1);
                    dtm = dtm.AddMilliseconds(long.Parse(match.Groups[1].Value));
                    dtm = dtm.ToLocalTime();
                    return dtm.ToString("yyyy-MM-dd HH:mm:ss");
                });
            context.Response.Write("{\"pn\":\"" + pageNum + "\", \"pgCount\":\"" + pgCount + "\", \"eCount\":\"" + eCount + "\", \"listData\":" + returnList + " }");

参考：http://www.cnblogs.com/songxingzhu/p/3816309.html