C# Datatable转成json串

朱雀 2024-02-19 12:18 54阅读 0赞

#region datatable转换json /ToJsonList(DataTable dt)
            /// <summary>
            /// datatable转换json
            /// </summary>
            /// <param name="dt"></param>
            /// <returns></returns>
            public static string ToJsonList(DataTable dt)
            {
                StringBuilder jsonString = new StringBuilder();
                jsonString.Append("[");
                DataRowCollection drc = dt.Rows;
                for (int i = 0; i < drc.Count; i++)
                {
                    jsonString.Append("{");
                    jsonString.Append("\"xh\":");
                    jsonString.Append((i + 1).ToString() + ",");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        string strKey = dt.Columns[j].ColumnName;
                        string strValue = drc[i][j].ToString();
                        Type type = dt.Columns[j].DataType;
    
    
    
                        jsonString.Append("\"" + strKey + "\":");
                        strValue = StringFormat(strValue, type);
                        if (j < dt.Columns.Count - 1)
                        {
                            jsonString.Append(strValue + ",");
                        }
                        else
                        {
                            jsonString.Append(strValue);
                        }
                    }
                    jsonString.Append("},");
                }
                if (jsonString.Length > 1)
                {
                    jsonString.Remove(jsonString.Length - 1, 1);
                }
                jsonString.Append("]");
    
                string str = jsonString.ToString();
                return jsonString.ToString();
            } 
            #endregion
    
            #region 格式化字符型、日期型、布尔型 /StringFormat(string str, Type type)
            /// <summary>
            /// 格式化字符型、日期型、布尔型
            /// </summary>
            /// <param name="str"></param>
            /// <param name="type"></param>
            /// <returns></returns>
            private static string StringFormat(string str, Type type)
            {
                if (type == typeof(string))
                {
                    str = String2Json(str);
                    str = "\"" + str + "\"";
                }
                else if (type == typeof(DateTime))
                {
                    //str = "\"" + str + "\"";
                    if (string.IsNullOrEmpty(str.Trim()))
                    {
                        str = "\"" + str + "\"";
                    }
                    else
                    {
                        str = "\"" + DateTime.Parse(str.Trim()).ToString("yyyy-MM-dd HH:mm:ss") + "\"";
                    }
                }
                else if (type == typeof(bool))
                {
                    str = str.ToLower();
                }
                else if (type != typeof(string) && string.IsNullOrEmpty(str))
                {
                    str = "\"" + str + "\"";
                }
                return str;
            }
            
            #endregion
    
            #region 过滤特殊字符 /String2Json(String s)
            /// <summary>
            /// 过滤特殊字符
            /// </summary>
            /// <param name="s">字符串</param>
            /// <returns>json字符串</returns>
            private static string String2Json(String s)
            {
                StringBuilder sb = new StringBuilder();
                for (int i = 0; i < s.Length; i++)
                {
                    char c = s.ToCharArray()[i];
                    switch (c)
                    {
                        case '\"':
                            sb.Append("\\\""); break;
                        case '\\':
                            sb.Append("\\\\"); break;
                        case '/':
                            sb.Append("\\/"); break;
                        case '\b':
                            sb.Append("\\b"); break;
                        case '\f':
                            sb.Append("\\f"); break;
                        case '\n':
                            sb.Append("\\n"); break;
                        case '\r':
                            sb.Append("\\r"); break;
                        case '\t':
                            sb.Append("\\t"); break;
                        default:
                            sb.Append(c); break;
                    }
                }
                return sb.ToString();
            } 
            #endregion