如何在json联接中过滤布尔字段

Question

很抱歉这么快就回来了。我已经尝试了很多方法，但我无法编译代码，因为我所尝试的一切都告诉我不能用布尔字段来编译代码。我搜索的每个例子都有例子？x==1。但我正在尝试筛选一个具有布尔值的字段？x==true。

我尝试过在foreach循环中进行过滤，改为for循环，在where中添加一个条件，并在join中添加RemoveAll。我想不出其他办法了。缺乏经验正在折磨我。

我需要过滤catObj。["IncludeCategory"]==true。

感谢您的帮助。

using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Data;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
class TestClass
{
public static void Test()
{
// Load categories.json
JObject catObj = JObject.Load(new JsonTextReader(File.OpenText("D:/Code/Tests/categories.json")));
// Load techtypes.json
JObject ttObj = JObject.Load(new JsonTextReader(File.OpenText("D:/Code/Tests/techtypes.json")));
foreach (var categoriesJson in catObj)
//foreach (var categoriesJson in GetCategoriesJson())
foreach (var itemsJson in ttObj)
{
// Filter variables
var gameVersions = new HashSet<string> { "A", "2" };
var categoryIDs = new HashSet<string> { "outcrop" };
// Left outer join on ttObj.  Select all Items[*] array items
var query = from i in ttObj.SelectTokens("TechType[*]").OfType<JObject>()
// Filter on the game version and category ID
let categoryId = (string)i["CategoryID"]
let gameVersion = (string)i["GameVersion"]
where
categoryIDs.Count() > 0 ? 
categoryIDs.Contains(categoryId) && gameVersions.Contains(gameVersion) && gameVersions.Contains(gameVersion)  : gameVersions.Contains(gameVersion) && gameVersions.Contains(gameVersion)
// Join with "Categories[*]" on category ID
join c in catObj.SelectTokens("Categories[*]") on categoryId equals (string)c["CategoryID"] into joined
// DefaultIfEmpty makes this a left join
from cat in joined.DefaultIfEmpty()
// Select all records of i and add the CategoryDescription from cat.
select new JObject(i.Properties()) { new JProperty("CategoryDescription", cat?["CategoryDescription"]) };
var results = query.ToList(); // Materialize the query into a list of results.
Console.WriteLine(JsonConvert.SerializeObject(results, Formatting.Indented));
Console.WriteLine();
}
}
public class TechType
{
public string CategoryID { get; set; }
public string TechName { get; set; }
public string SpawnID { get; set; }
public int TechID { get; set; }
public string GameVersion { get; set; }
}
public class TechTypeRoot
{
public List<TechType> TechType { get; set; }
}
public class Categories
{
public string CategoryID { get; set; }
public string CategoryDescription { get; set; }
public bool IncludeCategory { get; set; }
public string GameVersion { get; set; }
}
public class CategoriesRoot
{
public List<Categories> Categories { get; set; }
}
}
public class Program
{
public static void Main()
{
try
{
TestClass.Test();
}
catch (Exception ex)
{
Console.WriteLine("Failed with unhandled exception: ");
Console.WriteLine(ex);
throw;
}
}
}

catObj json

{
"Categories": [
{
"CategoryID": "baseupgrades",
"CategoryDescription": "Base Upgrades",
"IncludeCategory": true,
"GameVersion": "A"
},
{
"CategoryID": "batteries",
"CategoryDescription": "Batteries",
"IncludeCategory": true,
"GameVersion": "A"
},
{
"CategoryID": "blueprint",
"CategoryDescription": "Blueprint",
"IncludeCategory": false,
"GameVersion": "A"
},

ttObj json

{
"TechType": [
{
"CategoryID": "crystalline",
"TechName": "Quartz",
"SpawnID": "quartz",
"TechID": 1,
"GameVersion": "A"
},
{
"CategoryID": "metals",
"TechName": "Metal Salvage",
"SpawnID": "scrapmetal",
"TechID": 2,
"GameVersion": "A"
},
{
"CategoryID": "outcrop",
"TechName": "Limestone Outcrop",
"SpawnID": "limestonechunk",
"TechID": 4,
"GameVersion": "A"
},

Answer 1

好吧，正如我在第一篇文章中所说，我不得不将联接更改为右联接。现在我可以访问where子句中的所有字段。

using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Data;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
class TestClass
{
public static void Test()
{
// Load categories.json
JObject catObj = JObject.Load(new JsonTextReader(File.OpenText("D:/Code/Tests/categories.json")));
// Load techtypes.json
JObject ttObj = JObject.Load(new JsonTextReader(File.OpenText("D:/Code/Tests/techtypes.json")));
foreach (var categoriesJson in catObj)
{
// Filter variables
var gameVersions = new HashSet<string> { "A", "1" };
var categoryIDs = new HashSet<string> { "metals", "tablets" };
var usedInMod = new HashSet<bool> { true };
// Right outer join on catObj.  Select all Items[*] array items
var query = from c in catObj.SelectTokens("Categories[*]").OfType<JObject>()
let categoryId = (string)c["CategoryID"]
// Join catObj with ttObj on CategoryID
join t in ttObj.SelectTokens("TechType[*]") on categoryId equals (string)t["CategoryID"]
let gameVersionC = (string)c["GameVersion"]
let gameVersionT = (string)t["GameVersion"]
// Process the filters
where categoryIDs.Count() > 0 ?
usedInMod.Contains((bool)c["UsedInMod"]) && gameVersions.Contains(gameVersionC) && gameVersions.Contains(gameVersionT) && categoryIDs.Contains(categoryId) :
usedInMod.Contains((bool)c["UsedInMod"]) && gameVersions.Contains(gameVersionC) && gameVersions.Contains(gameVersionT)
select new
{
CategoryDescription = c["CategoryDescription"],
CategoryID = c["CategoryID"],
TechName = t["TechName"],
SpawnID = t["SpawnID"],
TechID = t["TechID"],
GameVersion = t["GameVersion"]
};
var results = query.ToList(); // Materialize the query into a list of results.
Console.WriteLine(JsonConvert.SerializeObject(results, Formatting.Indented));
Console.WriteLine();
}
}
}
public class Program
{
public static void Main()
{
try
{
TestClass.Test();
}
catch (Exception ex)
{
Console.WriteLine("Failed with unhandled exception: ");
Console.WriteLine(ex);
throw;
}
}
}