• .NET JSON扩展


    在南京工作时,自己写了个将常用数据转换成json的扩展。今天查找文件时找到了,就把它放上来,免得以后用着时找不到。

    毕竟很久之前写的,当时水平所限,漏洞肯定不少。但最近忙,没空改它,就先放着,博客园上的东西应该不会丢^_^

    namespace JavenSoft.Extension
    {
    using System;
    using System.Collections.Generic;
    using System.Text;
    using System.Reflection;
    using System.Collections;
    using System.Data;
    using System.Data.Common;

    ///<summary>
    /// 常用数据类型Json扩展
    /// 用于将常用的数据类型转换为Json对象
    ///</summary>
    public staticclass JsonExtension
    {
    ///<summary>
    /// 把指定的对象转换为Json字符串
    ///</summary>
    ///<param name="source">要转换的对象</param>
    ///<returns>Json字符串</returns>
    public staticstring ToJson(thisobject source)
    {
    StringBuilder jsonBuilder
    =new StringBuilder();
    jsonBuilder.Append(
    "{");

    PropertyInfo[] propertyInfo
    = source.GetType().GetProperties();

    for (int i =0; i < propertyInfo.Length; i++)
    {
    object objectValue = propertyInfo[i].GetGetMethod().Invoke(source, null);

    jsonBuilder.Append(
    "\"");
    jsonBuilder.Append(propertyInfo[i].Name);
    jsonBuilder.Append(
    "\":");

    string value =string.Empty;
    if (objectValue is DateTime || objectValue isstring|| objectValue is Guid || objectValue is TimeSpan)
    {
    jsonBuilder.Append(
    "'");
    jsonBuilder.Append(objectValue);
    jsonBuilder.Append(
    "'");
    }
    elseif (objectValue is IEnumerable)
    {
    jsonBuilder.Append((objectValue
    as IEnumerable).ToJson());
    }
    else
    {
    jsonBuilder.Append(objectValue.ToJson());
    }

    jsonBuilder.Append(value);
    jsonBuilder.Append(
    ",");
    }

    jsonBuilder.RemoveLast();
    jsonBuilder.Append(
    "}");
    return jsonBuilder.ToString();
    }
    ///<summary>
    /// 对象集合转换Json
    ///</summary>
    ///<param name="source">集合对象</param>
    ///<returns>Json字符串</returns>
    public staticstring ToJson<T>(this IEnumerable<T> source) where T : class
    {
    StringBuilder jsonBuilder
    =new StringBuilder();
    jsonBuilder.Append(
    "[");

    foreach (object item in source)
    {
    jsonBuilder.Append(item.ToJson());
    jsonBuilder.Append(
    ",");
    }
    jsonBuilder.RemoveLast();
    jsonBuilder.Append(
    "]");

    return jsonBuilder.ToString();
    }
    ///<summary>
    /// Datatable转换为Json
    ///</summary>
    ///<param name="table">Datatable对象</param>
    ///<returns>Json字符串</returns>
    public staticstring ToJson(this DataTable table)
    {
    StringBuilder jsonBuilder
    =new StringBuilder();
    jsonBuilder.Append(
    "[");

    DataRowCollection drc
    = table.Rows;
    for (int i =0; i < drc.Count; i++)
    {
    jsonBuilder.Append(
    "{");
    foreach (DataColumn column in table.Columns)
    {
    jsonBuilder.Append(
    "\"");
    jsonBuilder.Append(column.ColumnName);
    jsonBuilder.Append(
    "\":");

    if (column.DataType ==typeof(DateTime) || column.DataType ==typeof(string))
    {
    jsonBuilder.Append(
    "\"");
    jsonBuilder.Append(drc[i][column.ColumnName]);
    jsonBuilder.Append(
    "\",");
    }
    else
    {
    jsonBuilder.Append(drc[i][column.ColumnName]);
    jsonBuilder.Append(
    ",");
    }
    }
    jsonBuilder.RemoveLast();
    jsonBuilder.Append(
    "},");
    }

    jsonBuilder.RemoveLast();

    jsonBuilder.Append(
    "]");
    return jsonBuilder.ToString();
    }
    ///<summary>
    /// DataReader转换为Json
    ///</summary>
    ///<param name="dataReader">DataReader对象</param>
    ///<returns>Json字符串</returns>
    public staticstring ToJson(this DbDataReader dataReader)
    {
    StringBuilder jsonBuilder
    =new StringBuilder();
    jsonBuilder.Append(
    "[");

    while (dataReader.Read())
    {
    jsonBuilder.Append(
    "{");

    for (int i =0; i < dataReader.FieldCount; i++)
    {
    jsonBuilder.Append(
    "\"");
    jsonBuilder.Append(dataReader.GetName(i));
    jsonBuilder.Append(
    "\":");

    if (dataReader.GetFieldType(i) ==typeof(DateTime) || dataReader.GetFieldType(i) ==typeof(string))
    {
    jsonBuilder.Append(
    "\"");
    jsonBuilder.Append(dataReader[i]);
    jsonBuilder.Append(
    "\",");
    }
    else
    {
    jsonBuilder.Append(dataReader[i]);
    jsonBuilder.Append(
    ",");
    }
    }
    jsonBuilder.RemoveLast();
    jsonBuilder.Append(
    "}");
    }
    dataReader.Close();
    jsonBuilder.RemoveLast();
    jsonBuilder.Append(
    "]");

    return jsonBuilder.ToString();
    }
    ///<summary>
    /// DataSet转换为Json
    ///</summary>
    ///<param name="dataSet">DataSet对象</param>
    ///<returns>Json字符串</returns>
    public staticstring ToString(this DataSet dataSet)
    {
    StringBuilder jsonBuilder
    =new StringBuilder();
    jsonBuilder.Append(
    "{");

    foreach (DataTable table in dataSet.Tables)
    {
    jsonBuilder.Append(
    "\"");
    jsonBuilder.Append(table.TableName);
    jsonBuilder.Append(
    "\":");
    jsonBuilder.Append(table.ToJson());
    jsonBuilder.Append(
    ",");
    }

    jsonBuilder.RemoveLast();
    jsonBuilder.Append(
    "}");

    return jsonBuilder.ToString();
    }
    }
    }

    这里面还用到了另一个扩展,因为都是使用频率特别高的方法,所以做成扩展也不错

    namespace JavenSoft.Extension
    {
    using System.Text;
    publicstaticclass StringBuilderExtension
    {
    ///<summary>
    /// 删除结尾字符
    ///</summary>
    ///<param name="source">需要删除的字符</param>
    ///<returns>完成后的StringBuilder对象</returns>
    public static StringBuilder RemoveLast(this StringBuilder source)
    {
    return source.RemoveLast(1);
    }
    ///<summary>
    /// 删除结尾字符
    ///</summary>
    ///<param name="source">需要删除的字符</param>
    ///<param name="length">要删除的长度</param>
    ///<returns>完成后的StringBuilder对象</returns>
    public static StringBuilder RemoveLast(this StringBuilder source, int length)
    {
    if (source.Length >= length)
    {
    return source.Remove(source.Length - length, length);
    }
    return source;
    }
    }
    }

      

  • 相关阅读:
    Nginx安装部署手册
    5种mysql日志分析工具比拼
    分析诊断工具之一:MYSQL性能查看(多指标)
    mysqlsla安装和使用介绍
    Linux下MySQL慢查询分析mysqlsla安装使用
    mysql 开启慢查询及其用mysqldumpslow做日志分析
    MySQL性能诊断与调优
    MySQL慢日志查询分析方法与工具
    MySQL 慢日志分析
    MySQL 慢查询日志(Slow Query Log)
  • 原文地址:https://www.cnblogs.com/javennie/p/JsonExtension.html
Copyright © 2020-2023  润新知