使用Newtonsoft.Json将属性添加到json的指定位置
谢运良
问题内容：
问题答案：
我有一个追随者JSON。我添加了 2 x双引号，
以便可以string在c#中将其声明为变量，实际上，它包含属性的双引号的一倍。完整的示例代码在这个小提琴中。
我正在使用，Newtonsoft但也可以使用System.Text.Json，因此对于任何一种工作解决方案都将不胜感激。
{
""display"": ""wizard"",
""settings"": {},
""components"": [
{
""title"": ""Activity Information"",
""label"": ""Activity Information"",
""type"": ""Activity"",
""key"": ""ActivityInformation"",
""components"": [
{
""label"": ""Row1Columns"",
""columns"": [
{
""components"": [
{
""label"": ""Activity Date"",
""format"": ""dd/MM/yyyy hh:mm a"",
""tableView"": false,
""datePicker"": {
""disableWeekends"": false,
""disableWeekdays"": false
},
""validate"": {
""unique"": true
},
""key"": ""Activity.ActivityDate"",
""type"": ""datetime"",
""input"": true,
""suffix"": ""<i ref=\""icon\"" class=\""fa fa-calendar\"" style=\""\""></i>"",
""widget"": {
""type"": ""calendar"",
""displayInTimezone"": ""viewer"",
""language"": ""en"",
""useLocaleSettings"": false,
""allowInput"": true,
""mode"": ""single"",
""enableTime"": true,
""noCalendar"": false,
""format"": ""dd/MM/yyyy hh:mm a"",
""hourIncrement"": 1,
""minuteIncrement"": 1,
""time_24hr"": false,
""minDate"": null,
""disableWeekends"": false,
""disableWeekdays"": false,
""maxDate"": null
}
}
],
""width"": 6,
""offset"": 0,
""push"": 0,
""pull"": 0
},
{
""components"": [
{
""label"": ""Duration (minutes)"",
""mask"": false,
""spellcheck"": true,
""tableView"": false,
""delimiter"": false,
""requireDecimal"": false,
""inputFormat"": ""plain"",
""key"": ""Activity.Duration"",
""type"": ""number"",
""input"": true
}
],
""width"": 6,
""offset"": 0,
""push"": 0,
""pull"": 0
}
],
""tableView"": false,
""key"": ""row1Columns"",
""type"": ""columns"",
""input"": false
},
{
""label"": ""Row2Columns"",
""columns"": [
{
""components"": [
{
""label"": ""Activity Category"",
""widget"": ""choicesjs"",
""tableView"": true,
""dataSrc"": ""custom"",
""data"": {
""custom"": ""values = getActivityCategoryValues()""
},
""valueProperty"": ""AgencyActivityCategoryId"",
""template"": ""<span>{{ item.text }}</span>"",
""selectThreshold"": 0.3,
""validate"": {
""required"": true
},
""key"": ""Activity.AgencyActivityCategoryId"",
""type"": ""select"",
""indexeddb"": {
""filter"": {}
},
""input"": true
}
],
""width"": 6,
""offset"": 0,
""push"": 0,
""pull"": 0
},
{
""components"": [
{
""label"": ""Attendance"",
""widget"": ""choicesjs"",
""tableView"": true,
""multiple"": false,
""dataSrc"": ""custom"",
""data"": {
""custom"": ""values = getAttendanceValues()""
},
""valueProperty"": ""AgencyActivityAttendanceId"",
""template"": ""<span>{{ item.text }}</span>"",
""selectThreshold"": 0.3,
""key"": ""Activity.AgencyActivityAttendanceId"",
""type"": ""select"",
""indexeddb"": {
""filter"": {}
},
""input"": true
}
],
""width"": 6,
""offset"": 0,
""push"": 0,
""pull"": 0
}
],
""tableView"": false,
""key"": ""row2Columns"",
""type"": ""columns"",
""input"": false
},
{
""label"": ""Activity Options"",
""widget"": ""choicesjs"",
""tableView"": true,
""multiple"": true,
""dataSrc"": ""custom"",
""data"": {
""custom"": ""values = getActivityManagerValues(data.Activity.AgencyActivityCategoryId)""
},
""template"": ""<span>{{ item.text }}</span>"",
""refreshOn"": ""Activity.AgencyActivityCategoryId"",
""clearOnRefresh"": true,
""selectThreshold"": 0.3,
""calculateServer"": false,
""validate"": {
""required"": true,
""multiple"": true
},
""key"": ""Activity.ActivityDetail"",
""type"": ""select"",
""indexeddb"": {
""filter"": {}
},
""input"": true
}
],
""input"": false,
""tableView"": false,
""breadcrumbClickable"": true,
""buttonSettings"": {
""previous"": true,
""cancel"": true,
""next"": true
},
""collapsible"": false
}
]
}
如果我的密钥JSON与列表中的项目匹配，我想添加验证及其子密钥。我有三种情况，下面的代码按注释对它们进行了解释。
public static void Main()
{
Console.WriteLine("BEFORE MANDATORY");
List<string> mandatoryKeys = new List<string>();
//Scenario 1: Has validate key but not required key in json, so we need to add "required": true
//inside existing "validate"
mandatoryKeys.Add("Activity.ActivityDate");
//Scenario 2: Does not have both validate and required so will need to have both "validate" and its child "required"
mandatoryKeys.Add("Activity.Duration");
//Scenario 3: Has both "validate" and "required" so we should not add it again
mandatoryKeys.Add("Activity.AgencyActivityCategoryId");
//Scenario 2 again for double checking
mandatoryKeys.Add("Activity.AgencyActivityAttendanceId");
var data = JObject.Parse(GetRawJson());
Console.WriteLine(data);
for(int i = 0; i < mandatoryKeys.Count(); i++)
IterateJson(data, mandatoryKeys[i]);
Console.WriteLine("AFTER MANDATORY");
Console.WriteLine("XXXXXXXXXXXXXXX");
Console.WriteLine(data);
Console.ReadLine();
}
该JSON迭代函数显示如下。
static void IterateJson(JToken value, string mandatoryFieldKey)
{
//if more than 0 - so value is object or array and we have to call this method for each property
if (value.Values().Count() != 0)
{
foreach (var item in value.Values().ToList())
{
IterateJson(item, mandatoryFieldKey);
}
}
else if (value.ToString() == mandatoryFieldKey)
{
Console.WriteLine("HELLO");
//check if above "required" property exists
if (value.Parent.Parent is JObject jObject && jObject["validate"] == null)
{
Console.WriteLine(value);
jObject.Add("validate", JObject.FromObject(new { required = true })); //add required property
}
}
}
我的决赛JSON应该如下图所示。
{
""display"": ""wizard"",
""settings"": {},
""components"": [
{
""title"": ""Activity Information"",
""label"": ""Event Information"",
""type"": ""Activity"",
""key"": ""ActivityInformation"",
""components"": [
{
""label"": ""Row1Columns"",
""columns"": [
{
""components"": [
{
""label"": ""Activity Date"",
""format"": ""dd/MM/yyyy hh:mm a"",
""tableView"": false,
""datePicker"": {
""disableWeekends"": false,
""disableWeekdays"": false
},
""validate"": {
""required"": true,
""unique"": true
},
""key"": ""Activity.ActivityDate"",
""type"": ""datetime"",
""input"": true,
""suffix"": ""<i ref=\""icon\"" class=\""fa fa-calendar\"" style=\""\""></i>"",
""widget"": {
""type"": ""calendar"",
""displayInTimezone"": ""viewer"",
""language"": ""en"",
""useLocaleSettings"": false,
""allowInput"": true,
""mode"": ""single"",
""enableTime"": true,
""noCalendar"": false,
""format"": ""dd/MM/yyyy hh:mm a"",
""hourIncrement"": 1,
""minuteIncrement"": 1,
""time_24hr"": false,
""minDate"": null,
""disableWeekends"": false,
""disableWeekdays"": false,
""maxDate"": null
}
}
],
""width"": 6,
""offset"": 0,
""push"": 0,
""pull"": 0
},
{
""components"": [
{
""label"": ""Duration (minutes)"",
""mask"": false,
""spellcheck"": true,
""tableView"": false,
""delimiter"": false,
""requireDecimal"": false,
""inputFormat"": ""plain"",
""validate"": {
""required"": true
},
""key"": ""Activity.Duration"",
""type"": ""number"",
""input"": true
}
],
""width"": 6,
""offset"": 0,
""push"": 0,
""pull"": 0
}
],
""tableView"": false,
""key"": ""row1Columns"",
""type"": ""columns"",
""input"": false
},
{
""label"": ""Row2Columns"",
""columns"": [
{
""components"": [
{
""label"": ""Activity Category"",
""widget"": ""choicesjs"",
""tableView"": true,
""dataSrc"": ""custom"",
""data"": {
""custom"": ""values = getActivityCategoryValues()""
},
""valueProperty"": ""AgencyActivityCategoryId"",
""template"": ""<span>{{ item.text }}</span>"",
""selectThreshold"": 0.3,
""validate"": {
""required"": true
},
""key"": ""Activity.AgencyActivityCategoryId"",
""type"": ""select"",
""indexeddb"": {
""filter"": {}
},
""input"": true
}
],
""width"": 6,
""offset"": 0,
""push"": 0,
""pull"": 0
},
{
""components"": [
{
""label"": ""Attendance"",
""widget"": ""choicesjs"",
""tableView"": true,
""multiple"": false,
""dataSrc"": ""custom"",
""data"": {
""custom"": ""values = getAttendanceValues()""
},
""valueProperty"": ""AgencyActivityAttendanceId"",
""template"": ""<span>{{ item.text }}</span>"",
""selectThreshold"": 0.3,
""validate"": {
""required"": true
},
""key"": ""Activity.AgencyActivityAttendanceId"",
""type"": ""select"",
""indexeddb"": {
""filter"": {}
},
""input"": true
}
],
""width"": 6,
""offset"": 0,
""push"": 0,
""pull"": 0
}
],
""tableView"": false,
""key"": ""row2Columns"",
""type"": ""columns"",
""input"": false
},
{
""label"": ""Activity Options"",
""widget"": ""choicesjs"",
""tableView"": true,
""multiple"": true,
""dataSrc"": ""custom"",
""data"": {
""custom"": ""values = getActivityManagerValues(data.Activity.AgencyActivityCategoryId)""
},
""template"": ""<span>{{ item.text }}</span>"",
""refreshOn"": ""Activity.AgencyActivityCategoryId"",
""clearOnRefresh"": true,
""selectThreshold"": 0.3,
""calculateServer"": false,
""validate"": {
""required"": true,
""multiple"": true
},
""key"": ""Activity.ActivityDetail"",
""type"": ""select"",
""indexeddb"": {
""filter"": {}
},
""input"": true
}
],
""input"": false,
""tableView"": false,
""breadcrumbClickable"": true,
""buttonSettings"": {
""previous"": true,
""cancel"": true,
""next"": true
},
""collapsible"": false
}
]
}
我无法实现所有三种情况。有人可以看看并提供解决方案吗？另外，如果有更好的方法可以解决此问题，请提供该方法的解决方案。
我制造了一个小提琴，以轻松地帮助我。
问题答案：
我设法解决了这个问题，在这里发布了一个解决方案，以防它可以帮助其他人。我已经意识到json中的所有控件都是组件对象/数组的一部分，因此我们可以使用JSONPath，请参阅链接以获取更多详细信息。以下代码可以解决问题：
public void IterateJson(JObject obj, string mandatoryFieldKey)
{
JToken jTokenFoundForMandatoryField = obj.SelectToken
("$..components[?(@.key == '" + mandatoryFieldKey + "')]");
//Now we convert this oken into an object so that we can add properties/objects in it
if (jTokenFoundForMandatoryField is JObject jObjectForMandatoryField)
{
//We check if validate already exists for this field, if it does not
//exists then we add validate and required property inside the if condition
if (jObjectForMandatoryField["validate"] == null)
jObjectForMandatoryField.Add("validate",
JObject.FromObject(new { required = true })); //add validate and required property
else
{
//If validate does not exists then code comes here and
//we convert the validate into a JObject using is JObject statement
if (jObjectForMandatoryField["validate"] is JObject validateObject)
{
//We need to check if required property already exists,
//if it does not exists then we add it inside the if condition.
if (validateObject["required"] == null)
{
validateObject.Add("required", true); //add required property
}
}
}
}
}
类似资料：
-
我知道如何使用使用jackson添加属性，但是有没有方法在特定位置插入属性呢？例如，如果我有这个jsonNode： 我怎么能和杰克逊一起做到这一点呢？
-
问题内容： 假设我有一个处理待办事项清单的应用程序。清单中已完成和未完成的项目。现在，我想向列表对象添加两个虚拟属性。列表中已完成和未完成项目的计数。我还需要将这些显示在json输出中。 我的模型中有两种方法可以提取未完成/已完成的项目： 那么，如何在json输出中获得这两种方法的计数？ 我正在使用Rails 3.1 问题答案： Rails中对象的序列化包括两个步骤： 首先，调用将对象转换为简化的
-
问题内容： 我将json字符串存储到mysql中的文本字段中。插入后，我想更新我的json字符串，并使用jackson json将mysql行ID添加到其中。 我有一个Json格式的Java字符串 我希望添加另一个K / V，而无需编写代码行。 终于有了这个： 我可以将String转换为JsonNode： 想要做这样的事情 然后在mysql中使用新的json字符串在我的文本字段中更新 我做不到 我
-
我将json字符串存储到MySQL中的文本字段中。插入之后，我希望更新我的json字符串，并使用jackson json将mysql行id添加到其中。 我有一个Json格式的java字符串
-
我想在gradle.properties文件中添加ndk.abifilters属性。现在我有了这栋楼里的房子。这是我建筑的一部分 这是我的gradle.properties文件的一部分
-
问题内容： 如何添加到特定内容？不起作用。 问题答案： jQuery <1.9 jQuery 1.9以上