C# json Helper

最新推荐文章于 2024-09-14 08:00:12 发布

anshan2269

最新推荐文章于 2024-09-14 08:00:12 发布

阅读量103

点赞数

文章标签： json c#

原文链接：http://www.cnblogs.com/mingxuantongxue/p/3730500.html

版权

C# json Helper

using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace Common
{
    public class JsonHelper
    {

        /// <summary>
        /// DataTable 转 Json
        /// </summary>
        /// <param name="dt">DataTable</param>
        /// <param name="fromCount">来自的行数</param>
        /// <param name="totalCountStr">总行数</param>
        /// <param name="tbname">表名</param>
        /// <returns></returns>
        public static string DT2JSON(DataTable dt, string tbname)
        {
            StringBuilder jsonBuilder = new StringBuilder();
            jsonBuilder.Append("{\"" + tbname + "\":[");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i > 0)
                    jsonBuilder.Append(",");
                jsonBuilder.Append("{");
                jsonBuilder.Append("\"no\":\"" + i + "\",");
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    if (j > 0)
                        jsonBuilder.Append(",");
                    if (dt.Columns[j].DataType.Equals(typeof(DateTime)) && dt.Rows[i][j].ToString() != "")
                        jsonBuilder.Append("\"" + dt.Columns[j].ColumnName.ToLower() + "\": \"" + Convert.ToDateTime(dt.Rows[i][j].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "\"");
                    else if (dt.Columns[j].DataType.Equals(typeof(String)))
                        jsonBuilder.Append("\"" + dt.Columns[j].ColumnName.ToLower() + "\": \"" + dt.Rows[i][j].ToString().Replace("\\", "\\\\").Replace("\'", "\\\'").Replace("\t", " ").Replace("\r", " ").Replace("\n", "<br/>") + "\"");
                    else
                        jsonBuilder.Append("\"" + dt.Columns[j].ColumnName.ToLower() + "\": \"" + dt.Rows[i][j].ToString() + "\"");
                }
                jsonBuilder.Append("}");
            }
            jsonBuilder.Append("]}");
            return jsonBuilder.ToString();

        }
    }
}