如何根据C＃中的条件合并两个具有不同属性的列表

玛格琳

我有两个列表-具有不同属性的计划和部门..示例数据：


    {
        "plans": [
            {
                "planCode": "A",
                "planShortName": "Apple",
                "planType": null,
                "bisPlanCode": "878",

            },
            {
                "planCode": "B",
                "planShortName": "Ball",
                "planType": null,
                "bisPlanCode": "536",

            }
        ],
        "divisions": [
            {
                "planCode": "878",
                "divisions": [
      { divisionCode: "2", divisionName: "test2" }, 
            { divisionCode: "1", divisionName: "test1" }]
            },
            {
                "planCode": "536",
                "divisions": [
      { divisionCode: "3", divisionName: "test3" }, 
            { divisionCode: "1", divisionName: "test1" }
    ]
            }
        ]
    }

如何在C＃中plan.bisPlanCode == divisions.plansCode的条件下，将这些列表计划和分区合并到一个列表计划分区中。所以最终结果应该像


     "planDivisions": [
            {
                "planCode": "A",
                "planShortName": "Apple",
                "planType": null,
                "bisPlanCode": "878",
                "divisions": [ { divisionCode: "2", divisionName: "test2" }, 
            { divisionCode: "1", divisionName: "test1" }]

            },
            {
                "planCode": "B",
                "planShortName": "Ball",
                "planType": null,
                "bisPlanCode": "536",
                "divisions": [
{ divisionCode: "3", divisionName: "test3" }, 
        { divisionCode: "1", divisionName: "test1"

 }]

            }
    ]

我试图做的是：



    List<Data> planDivisions = new List<Data>();

                    Divisions.ForEach(division =>
                    {
                        var plan = Plans.Find(p => p.PlanCode == division.PlanCode);
                        if (plan != null)
                        {
                            Data data = new Data();
                            data.DivisionData = division;
                            data.PlanData = plan;
                            planDivisions.Add(data);
                        }

                    });

有什么有效的方法吗？

克鲁迪兹

您可以使用LINQ来加入两个数据列表。在这里了解更多。

class Plan {
  public int PlanCode { get; set; }
  public string PlanShortName { get; set; }
}

class Division {
  public int DivisionCode { get; set; }
  public string DivisionName { get; set; }
}

class DivisionAssignment {
  public int PlanCode { get; set; }
  public List<Division> Divisions { get; set; }
}

public static void JoinExample() {
  // do your deserialization stuff here
  List<Plan> plans = ...;
  List<DivisionAssignment> assignments = ...;

  // join the data
  var query = from plan in plans
              join assignment in assignments on plan.PlanCode equals assignment.PlanCode
              select new { PlanCode = plan.PlanCode, Divisions = assignment.Divisions };

  // reach the joined data
  foreach (var planDivision in query) {
    ... = planDivision.PlanCode;
    ... = planDivision.Divisions;
    ...
  }
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。