Newtonsoft.Json.JsonHelper 父子结构数据改成数据平铺

最新推荐文章于 2023-10-17 10:15:02 发布
最新推荐文章于 2023-10-17 10:15:02 发布
阅读量194 收藏
点赞数
文章标签： json typescript webservice gson c#
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hofmann/article/details/122076997
版权 
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System.Collections.Generic;

namespace BLL.Utilities
{
    public class JsonHelper
    {
        public static string SerializeAndFlatten(string prefix, object obj)
        {
            Dictionary<string, object> dict = new Dictionary<string, object>();
            var json = JsonConvert.SerializeObject(obj);
            JToken token = JToken.Parse(json);
            FillDictionaryFromJToken(dict, token, prefix);
            return JsonConvert.SerializeObject(dict);
        }

        private static void FillDictionaryFromJToken(Dictionary<string, object> dict, JToken token, string prefix)
        {
            switch (token.Type)
            {
                case JTokenType.Object:
                    foreach (JProperty prop in token.Children<JProperty>())
                    {
                        FillDictionaryFromJToken(dict, prop.Value, Join(prefix, prop.Name));
                    }
                    break;

                case JTokenType.Array:
                    int index = 0;
                    foreach (JToken value in token.Children())
                    {
                        FillDictionaryFromJToken(dict, value, string.Join("", prefix, index));
                        index++;
                    }
                    break;

                default:
                    dict.Add(prefix, ((JValue)token).Value);
                    break;
            }
        }

        private static string Join(string prefix, string name)
        {
            return (string.IsNullOrEmpty(prefix) ? name : string.Join("_", prefix, name));
        }
    }
}

调用

var result = JsonHelper.SerializeAndFlatten(string.Empty, new { Result = QueryStatus.Success.ToString(), ErrorCode = string.Empty, ErrorMessage = string.Empty, CustomerIndicator = indicator, QueryResult = new QueryResult() });

父子结构属性

    public class QueryResult
    {
        [JsonIgnore]
        public DateTime CreatedTime { get; set; }

        [JsonProperty("reportHeader")]
        public virtual ReportHeader ReportHeader { get; set; }

        [JsonProperty("personalProfile")]
        public virtual PersonalProfile PersonalProfile { get; set; }

        [JsonProperty("homeInfo")]
        public virtual List<HomeInfo> HomeInfo { get; set; }

        [JsonProperty("workInfo")]
        public virtual List<WorkInfo> WorkInfo { get; set; }

        [JsonProperty("nonRevolvingLoan")]
        public virtual NonRevolvingLoan NonRevolvingLoan { get; set; }

        [JsonProperty("revolvingLoan")]
        public virtual RevolvingLoan RevolvingLoan { get; set; }

        [JsonProperty("queryHistory")]
        public virtual List<QueryHistory> QueryHistory { get; set; }
    }

    public class ReportHeader
    {
        [ForeignKey("BhQueryResult")]
        [JsonIgnore]
        public long ReportHeaderId { get; set; }

        [JsonProperty("reportId")]
        [MaxLength(30)]
        public string ReportId { get; set; }

        [JsonProperty("reportTime")]
        public DateTime ReportTime { get; set; }

        [JsonProperty("queryResult")]
        public int QueryResult { get; set; }
    }


    public class PersonalProfile
    {
        [ForeignKey("BhQueryResult")]
        [JsonIgnore]
        public long PersonalProfileId { get; set; }

        [JsonProperty("name")]
        [MaxLength(30)]
        public string Name { get; set; }

        [JsonProperty("pid")]
        [MaxLength(20)]
        public string Pid { get; set; }

        [JsonProperty("mobileCount")]
        public int MobileCount { get; set; }
    }


    public class HomeInfo
    {
        [JsonIgnore]
        public long HomeInfoId { get; set; }

        [JsonProperty("homeAddress")]
        [MaxLength(200)]
        public string HomeAddress { get; set; }

        [JsonProperty("date")]
        public DateTime Date { get; set; }
    }

    public class WorkInfo
    {
        [JsonIgnore]
        public long WorkInfoId { get; set; }

        [JsonProperty("workName")]
        [MaxLength(100)]
        public string WorkName { get; set; }

        [JsonProperty("workAddress")]
        [MaxLength(200)]
        public string WorkAddress { get; set; }

        [JsonProperty("date")]
        public DateTime Date { get; set; }
    }


    public class NonRevolvingLoan
    {
        [ForeignKey("BhQueryResult")]
        [JsonIgnore]
        public long NonRevolvingLoanId { get; set; }

        [JsonProperty("summary")]
        public virtual NonRevolvingLoanSummary Summary { get; set; }

        [JsonProperty("D30")]
        public virtual NonRevolvingLoanDetail D30 { get; set; }

        [JsonProperty("D90")]
        public virtual NonRevolvingLoanDetail D90 { get; set; }

        [JsonProperty("D180")]
        public virtual NonRevolvingLoanDetail D180 { get; set; }

        [JsonProperty("D360")]
        public virtual NonRevolvingLoanDetail D360 { get; set; }
    }


    public class RevolvingLoan
    {
        [ForeignKey("BhQueryResult")]
        [JsonIgnore]
        public long RevolvingLoanId { get; set; }

        [JsonProperty("summary")]
        public virtual RevolvingLoanSummary Summary { get; set; }

        [JsonProperty("D30")]
        public virtual RevolvingLoanDetail D30 { get; set; }

        [JsonProperty("D90")]
        public virtual RevolvingLoanDetail D90 { get; set; }

        [JsonProperty("D180")]
        public virtual RevolvingLoanDetail D180 { get; set; }

        [JsonProperty("D360")]
        public virtual RevolvingLoanDetail D360 { get; set; }
    }


    public class QueryHistory
    {
        [Key]
        [JsonIgnore]
        public long QueryHistoryId { get; set; }

        [JsonProperty("tenantType")]
        [MaxLength(30)]
        public string TenantType { get; set; }

        [JsonProperty("tenantName")]
        [MaxLength(50)]
        public string TenantName { get; set; }

        [JsonProperty("userId")]
        [MaxLength(30)]
        public string UserId { get; set; }

        [JsonProperty("date")]
        public DateTime Date { get; set; }

        [JsonProperty("reason")]
        public int Reason { get; set; }
    }

Json data

{
    "Data": {
        "reportHeader": {
            "reportId": "CS1909291422585066440189",
            "reportTime": "2019-09-29T14:22:58",
            "queryResult": 1
        },
        "personalProfile": {
            "name": "霍测试",
            "pid": "111111198988888888",
            "mobileCount": 1
        },
        "homeInfo": [
            {
                "homeAddress": "联调市测试县**********",
                "date": "2019-08-16T00:00:00"
            },
            {
                "homeAddress": "联调市测试县**********",
                "date": "2019-08-16T00:00:00"
            }
        ],
        "workInfo": [],
        "nonRevolvingLoan": {
            "summary": {
                "loanCount": 1,
                "openLoanCount": 1,
                "remainingAmount": 53000.0,
                "remainingOverdueLoanCount": 0,
                "remainingOverdueAmount": 0.0,
                "remainingMaxOverdueStatus": "N",
                "overdueCount": 0,
                "maxOverdueStatus": "N",
                "lastCompensationDate": null
            },
            "D30": {
                "applyTenantCount": -1,
                "loanCount": 0,
                "loanAmount": 0.0,
                "loanTenantCount": 0,
                "maxLoanAmount": 0.0,
                "averageLoanAmount": 0.0,
                "overdueLoanCount": 0,
                "compensationAmount": 0.0,
                "compensationCount": 0.0,
                "compensationTimes": 0.0
            },
            "D90": {
                "applyTenantCount": -1,
                "loanCount": 1,
                "loanAmount": 53000.0,
                "loanTenantCount": 1,
                "maxLoanAmount": 53000.0,
                "averageLoanAmount": 53000.0,
                "overdueLoanCount": 0,
                "compensationAmount": 0.0,
                "compensationCount": 0.0,
                "compensationTimes": 0.0
            },
            "D180": {
                "applyTenantCount": -1,
                "loanCount": 1,
                "loanAmount": 53000.0,
                "loanTenantCount": 1,
                "maxLoanAmount": 53000.0,
                "averageLoanAmount": 53000.0,
                "overdueLoanCount": 0,
                "compensationAmount": 0.0,
                "compensationCount": 0.0,
                "compensationTimes": 0.0
            },
            "D360": {
                "applyTenantCount": -1,
                "loanCount": 1,
                "loanAmount": 53000.0,
                "loanTenantCount": 1,
                "maxLoanAmount": 53000.0,
                "averageLoanAmount": 53000.0,
                "overdueLoanCount": 0,
                "compensationAmount": 0.0,
                "compensationCount": 0.0,
                "compensationTimes": 0.0
            }
        },
        "revolvingLoan": {
            "summary": {
                "accountCount": 0,
                "validAccountCount": 0,
                "creditLimitSum": 0.0,
                "maxCreditLimitPerTenant": 0.0,
                "remainingAmount": 0.0,
                "remainingOverdueAccountCount": 0,
                "remainingOverdueAmount": 0.0,
                "remainingMaxOverdueStatus": "N",
                "overdueCount": 0,
                "maxOverdueStatus": "N",
                "revolvingLastCompensationDate": null
            },
            "D30": {
                "applyTenantCount": -1,
                "accountCount": 0,
                "creditLimitSum": 0.0,
                "lendingAmount": 0.0,
                "overdueAccountCount": 0,
                "revolvingCompensationAmount": 0.0,
                "revolvingCompensationTimes": 0.0,
                "revolvingCompensationCount": 0.0
            },
            "D90": {
                "applyTenantCount": -1,
                "accountCount": 0,
                "creditLimitSum": 0.0,
                "lendingAmount": 0.0,
                "overdueAccountCount": 0,
                "revolvingCompensationAmount": 0.0,
                "revolvingCompensationTimes": 0.0,
                "revolvingCompensationCount": 0.0
            },
            "D180": {
                "applyTenantCount": -1,
                "accountCount": 0,
                "creditLimitSum": 0.0,
                "lendingAmount": 0.0,
                "overdueAccountCount": 0,
                "revolvingCompensationAmount": 0.0,
                "revolvingCompensationTimes": 0.0,
                "revolvingCompensationCount": 0.0
            },
            "D360": {
                "applyTenantCount": -1,
                "accountCount": 0,
                "creditLimitSum": 0.0,
                "lendingAmount": 0.0,
                "overdueAccountCount": 0,
                "revolvingCompensationAmount": 0.0,
                "revolvingCompensationTimes": 0.0,
                "revolvingCompensationCount": 0.0
            }
        },
        "queryHistory": [
            {
                "tenantType": "-",
                "tenantName": "联调测试(天津)有限公司",
                "userId": "DZQCJRZL_TEST_1",
                "date": "2019-09-29T00:00:00",
                "reason": 1
            },
            {
                "tenantType": "-",
                "tenantName": "联调测试(天津)有限公司",
                "userId": "DZQCJRZL_TEST_1",
                "date": "2019-09-29T00:00:00",
                "reason": 1
            },
            {
                "tenantType": "-",
                "tenantName": "联调测试(天津)有限公司",
                "userId": "DZQCJRZL_TEST_1",
                "date": "2019-09-29T00:00:00",
                "reason": 1
            },
            {
                "tenantType": "-",
                "tenantName": "联调测试(天津)有限公司",
                "userId": "DZQCJRZL_TEST_1",
                "date": "2019-09-29T00:00:00",
                "reason": 1
            },
            {
                "tenantType": "-",
                "tenantName": "联调测试(天津)有限公司",
                "userId": "DZQCJRZL_TEST_1",
                "date": "2019-09-29T00:00:00",
                "reason": 1
            },
            {
                "tenantType": "-",
                "tenantName": "联调测试(天津)有限公司",
                "userId": "DZQCJRZL_TEST_1",
                "date": "2019-09-25T00:00:00",
                "reason": 6
            },
            {
                "tenantType": "-",
                "tenantName": "联调测试(天津)有限公司",
                "userId": "DZQCJRZL_TEST_1",
                "date": "2019-09-25T00:00:00",
                "reason": 1
            }
        ]
    },
    "StatusCode": "200",
    "StatusMessage": "Successful",
    "Success": true
}
霍夫曼
关注
Newtonsoft.Json
06-30
Newtonsoft.Json的.dll文件，亲测可用。~~~~~~~~~~~~~
Newtonsoft.Json.dll
03-11
它在Unity引擎中广泛使用，因为Unity支持C#编程，而`Newtonsoft.Json`库提供了强大的JSON序列化和反序列化功能，使得在Unity项目中处理JSON数据变得简单而高效。 **JSON（JavaScript Object Notation）** JSON是一...
Newtonsoft.Json JsonHelper
weixin_34391445的博客
04-13 244
Json.net 简单封装 1 using System; 2 using System.Linq; 3 using Newtonsoft.Json; 4 using Newtonsoft.Json.Serialization; 5 using System.Collections.Generic; 6 7 namespace TT.Utilit...
NewtonJSONHelper
weixin_30897233的博客
08-15 113
public static class NewtonJSONHelper { public static string SerializeObject(this object obj) { return JsonConvert.SerializeObject(obj, Formatting.Indented, new JsonSeri...
C#JSON转换帮助类---Newtonsoft.Json
茉栀的博客
12-26 837
Newtonsoft.Json，一款.NET中开源的Json序列化和反序列化类库(下载地址http://json.codeplex.com/)。          下面是Json序列化和反序列化的简单封装： /// /// Json帮助类 /// public class JsonHelper { ///
Newtonsoft.Json.dll 4.5.0.0 版本
最新发布
03-11
而Newtonsoft.Json.dll是.NET平台上最流行的JSON库，由James Newton-King 开发，它提供了丰富的API用于JSON序列化和反序列化，极大地简化了开发者处理JSON数据的工作。 Newtonsoft.Json.dll 4.5.0.0版本是该库的一...
Newtonsoft.json.dll v12.0.3
06-23
《Newtonsoft.Json.dll v12.0.3：.NET框架的强大JSON处理库》 在.NET开发领域，处理JSON数据是一项常见的任务。JSON（JavaScript Object Notation）是一种轻量级的数据交换格式，易于人阅读和编写，同时也易于机器...
Newtonsoft.Json-for-Unity.Converters:Newtonsoft.Json的常见Unity类型的转换器。 与jilleJrNewtonsoft.Json-for-Unity携手并进
05-16
Newtonsoft.Json的Unity转换器 该软件包包含往返于常见Unity类型的转换器。 类型，例如Vector2，Vector3，Matrix4x4，四元数，颜色，甚至ScriptableObject等等。 （请参阅的） 依存关系 Newtonsoft.Json软件包 此...
Unity版Newtonsoft.Json
01-19
Unity版的Newtonsoft.Json是Unity开发中常用的JSON序列化与反序列化库，它使得在Unity引擎中处理JSON数据变得更加方便。本教程将详细介绍如何在Unity项目中集成和使用Newtonsoft.Json，以及它的一些核心功能。 首先...
list父子节点转树json
05-31
list父子节点转树json，大家也可以结合我的博客查看，下载以后可以直接应用 博客地址为：https://blog.csdn.net/qq_25814003/article/details/80519421
JsonHelper VS Newtonsoft.Json 不同情况的使用
狗剩的专栏
05-08 1703
// DataTable tableList = GetDt(); //如果对tableList的内容没有转换，直接 JsonHelper.ToJson var Data = JsonHelper.ToJson(tableList, "Data"); return Data; //{"Data":[{"VI_ID":1498
将json字符串从外层到最内层依次连接，平铺成一个List＜String＞
tianyaleixiaowu的专栏
03-09 992
这样能得到整个json的所有key，如果需要排重，可以用Set。就是将json平铺的功能，如。
JSON数据平铺和对象化
s.lm的博客
11-25 1500
JSON层级key平铺
json 平铺处理 支持根据入参数分级
qq_38719003的博客
07-28 506
在项目里 业务要求要把两层的分级 变成一层存入，为此参考了其他博主的代码进行了一点修改，记录在工作笔记中
C# JsonHelper
weixin_42629287的博客
12-24 830
C# Json转换类 话不多说上代码 环境配置：引用nuget包Newtonsoft.Json using Newtonsoft.Json; using Newtonsoft.Json.Converters; using Newtonsoft.Json.Linq; using Newtonsoft.Json.Serialization; using System; using System.Col...
JSON平铺功能的实现(JS操作JSON数据)
weixin_30466039的博客
09-25 1596
一、什么是JSON平铺 JSON平铺分成两种: 平铺的json转树结构的json 例如: { a: 'value', b: 'b1.value' } // 转换成=> { a: 'value', b: { b1: value, } } 树结构转换成平铺的json 例如: { "a": { "a1": 123, ...
父子窗体间传递JSON格式的数据
weixin_30872789的博客
12-25 224
　　在开发的项目中，遇到这样一个例子：当用户选择某一个用户名时，弹出当前用户的评分卷，该评分卷列出了所有一级评分项，让用户进行评分操作。如果某个一级评分项包含评分子项，则点击该评分项时，再弹出一个新窗口，新窗体中列出了当前评分项的所有评分子项列表，供用户进行操作。用户操作完成后，点击“确定”按钮，则返回到父窗体，在子窗体中所有的操作结果，同时要带到父窗体中。同时，如果用户再次点击该评分项，则在弹出...
JsonHelper(C#版)
Major_S的博客
10-17 599
【代码】JsonHelper(C#版)
JSON数据交换利器：Newtonsoft.Json详解
"Newtonsoft.Json是.NET平台上广泛使用的JSON序列化库，用于将.NET对象转换为JSON字符串或从JSON数据反序列化回.NET对象。本文档是关于Newtonsoft.Json的使用总结，涵盖了基本概念、在ASP.NET中的应用、日期处理、...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值