Hl.Code/JsonHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace Hl.Code
{
    /// <summary>
    /// Json操作[将数据转为json格式]
    /// </summary>
    public class JsonHelper
    {
        #region 将dataTable转换为json 返回行数

        public static string GetJsonFromDataRows(DataColumnCollection cols, DataRow[] rows)
        {
            StringBuilder jsonString = new StringBuilder();
            if (cols != null && rows.Length > 0)
            {
                jsonString.Append("[ ");
                for (int i = 0; i < rows.Length; i++)
                {
                    jsonString.Append("{ ");
                    for (int j = 0; j < cols.Count; j++)
                    {
                        if (j < cols.Count - 1)
                        {
                            jsonString.Append("\"" + cols[j].ColumnName.ToString() + "\":" + "\"" + FilterCharJson(rows[i][j].ToString()) + "\",");
                        }
                        else if (j == cols.Count - 1)
                        {
                            jsonString.Append("\"" + cols[j].ColumnName.ToString() + "\":" + "\"" + FilterCharJson(rows[i][j].ToString()) + "\"");
                        }
                    }
                    if (i == rows.Length - 1)
                    {
                        jsonString.Append("} ");
                    }
                    else
                    {
                        jsonString.Append("}, ");
                    }
                }
                jsonString.Append("]");
                return jsonString.ToString();
            }
            else
            {
                return "[]";
            }
        }

        /// <summary>
        /// 将dataTable转换为json
        /// </summary>
        public static string GetJsonFromDataTable(DataTable dt)
        {
            StringBuilder jsonString = new StringBuilder();