数据处理 能远程解决下更好 有偿

Question

有偿 请教个问题 这种键值对 我想返回出来

这样的格式 要怎么处理呀 请教了同事 他说可以 List<Dictionary<string,object>> string存list object存lists 不知道咋写 有偿请教

Answer 1

在C#中定义你这种JSON对应的实体类，然后反序列化就好了。

示例代码(.NET 7)：

using System.Text.Json;

var json = """
{
    "code":"0",
    "msg":"",
    "data":[
        {
        "sourceOrderCode":"2022 勿动",
        "buyerNick":"",
        "shipToName":"111",
        "shipToAddress":"",
        "container":[
            {
                "containerCode":"RC11YSBZX",
                "containerName":"RC11 运输包装箱",
                "containerQty": 7
            },
            {
                "containerCode":"RP11/13YSBZX(X)",
                "containerName":"RP11/13 运输包装箱（新）",
                "containerQty": 4
            }
        ]
        }
    ]
}
""";

var model = JsonSerializer.Deserialize<Model>(json, new JsonSerializerOptions { PropertyNamingPolicy = JsonNamingPolicy.CamelCase });

Console.WriteLine(model.Code);

public class Model
{
    public string Code { get; set; }
    public string Msg { get; set; }
    public List<DataItem> Data { get; set; }
}

public class DataItem
{
    public string SourceOrderCode { get; set; }
    public string BuyerNick { get; set; }
    public string ShipToName { get; set; }
    public string ShipToAddress { get; set; }
    public List<Container> Container { get; set; }
}

public class Container
{
    public string ContainerCode { get; set; }
    public string ContainerName { get; set; }
    public int ContainerQty { get; set; }
}