ASP.NET DataSet查询结果转换为JSON格式数据

欢迎大家进QQ群来讨论：84479667
方法如下:
public static string nulldata = "{\"result\":\"true\",\"msg\":\"没有相关数据\"}";
        #region 查询结果转为json
        /// <summary>
        /// 查询结果转为json
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="count"></param>
        /// <returns></returns>
        public static string GetDataToJSON(DataTable dt, int count = 0)
        {
            JavaScriptSerializer jss = new JavaScriptSerializer();
            System.Collections.ArrayList dic = new System.Collections.ArrayList();
            if (dt != null && dt.Rows.Count > 0)
            {
                if (count == 0)
                {
                    count = dt.Rows.Count;
                }
                foreach (DataRow dr in dt.Rows)
                {
                    System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();
                    foreach (DataColumn dc in dt.Columns)
                    {
                        //string dcvalue = Common.PageBase.delhtml(dr[dc.ColumnName].ToString());
                        drow.Add(dc.ColumnName, dr[dc.ColumnName]);
                    }
                    dic.Add(drow);
                }
                //bool result = true;
                string JsonString = jss.Serialize(dic);
                string p = @"\\/Date\((\d+)\)\\/";
                MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertJsonDateToDateString);
                //MatchEvaluator img_urlEvaluator = new MatchEvaluator(GetImgUrl);
                Regex reg = new Regex(p);
                //Regex img_url = new Regex("src=\\\\\"(.*?)\"");
                //Regex img_url = new Regex("src=\"(.*?)\"");
                JsonString = reg.Replace(JsonString, matchEvaluator);
                //JsonString = img_url.Replace(JsonString, img_urlEvaluator);
                return "{\"result\": \"true\"" + "," + "\"rows\":" + count + "," + "\"msg\":" + JsonString + "}";
            }
            else
            {
                return nulldata;
            }
        }
        #endregion
        /// <summary>
        /// 将Json序列化的时间由/Date(1294499956278+0800)转为字符串
        /// </summary>
        /// <param name="m"></param>
        /// <returns></returns>
        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;
        }
        public string CreateJsonParameters(DataTable dt, int count = 0)
        {
            if (dt == null || dt.Rows.Count == 0)
            {
                return nulldata;
            }
            if (count == 0)
            {
                count = dt.Rows.Count;
            }
            bool result = true;
            StringBuilder JsonString = new StringBuilder();
            //Exception Handling          
            if (dt != null && dt.Rows.Count > 0)
            {
                JsonString.Append("{ ");
                JsonString.Append("\"result\":" + result + "," + "rows:" + count + "," + "msg:[ ");
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    JsonString.Append("{ ");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        if (j < dt.Columns.Count - 1)
                        {
                            JsonString.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + "\"" + dt.Rows[i][j].ToString() + "\",");
                        }
                        else if (j == dt.Columns.Count - 1)
                        {
                            JsonString.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + "\"" + dt.Rows[i][j].ToString() + "\"");
                        }
                    }
                    /*end Of String*/
                    if (i == dt.Rows.Count - 1)
                    {
                        JsonString.Append("} ");
                    }
                    else
                    {
                        JsonString.Append("}, ");
                    }
                }
                JsonString.Append("]}");
                return JsonString.ToString();
            }
            else
            {
                return null;
            }
        }