WPF中如何按关联条件将多模型合并为一个ViewModel

嘿，我来帮你搞定这个需求！要把这三个模型合并成一个能展示员工对应国家和部门名称的ViewModel，其实分几步就能完成，我给你拆解清楚：

第一步：创建EmployeeViewModel #

首先你需要一个专门的ViewModel来承载合并后的数据——它要包含Employee的所有属性，再加上关联的CountryName和DepartmentName。别忘了实现INotifyPropertyChanged接口，这是WPF数据绑定的核心，能保证UI跟着数据变化自动更新。

示例代码：

using System.ComponentModel;
using System.Runtime.CompilerServices;

namespace Company.ViewModel
{
    public class EmployeeViewModel : INotifyPropertyChanged
    {
        // 员工基础属性（以EmployeeId和FirstName为例，其他属性同理）
        private int _employeeId;
        public int EmployeeId
        {
            get => _employeeId;
            set { _employeeId = value; OnPropertyChanged(); }
        }

        private string _employeeFirstName;
        public string EmployeeFirstName
        {
            get => _employeeFirstName;
            set { _employeeFirstName = value; OnPropertyChanged(); }
        }

        // 省略其他Employee属性的实现，都按照上面的模式包装即可

        // 新增关联属性：国家名称和部门名称
        private string _countryName;
        public string CountryName
        {
            get => _countryName;
            set { _countryName = value; OnPropertyChanged(); }
        }

        private string _departmentName;
        public string DepartmentName
        {
            get => _departmentName;
            set { _departmentName = value; OnPropertyChanged(); }
        }

        // INotifyPropertyChanged标准实现
        public event PropertyChangedEventHandler PropertyChanged;
        protected void OnPropertyChanged([CallerMemberName] string propertyName = null)
        {
            PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName));
        }
    }
}

第二步：将原始数据映射到ViewModel #

接下来要把三个模型的数据通过“表连接”的逻辑合并到ViewModel里，分两种常见场景：

场景1：数据在内存集合中（比如已加载好三个List） #

用LINQ的Join方法就能实现类似SQL内连接的效果，如果要处理员工没有关联国家/部门的情况，就用GroupJoin+DefaultIfEmpty做左连接。

内连接示例（只保留有对应国家和部门的员工）：

// 假设你已经有这三个数据集合
List<Country> countries = GetAllCountries();
List<Department> departments = GetAllDepartments();
List<Employee> employees = GetAllEmployees();

// 合并数据到ViewModel
var employeeViewModels = employees
    .Join(countries, 
          emp => emp.CountryId, 
          cntry => cntry.CountryId, 
          (emp, cntry) => new { Employee = emp, Country = cntry })
    .Join(departments, 
          combined => combined.Employee.DepartmentId, 
          dept => dept.DepartmentId, 
          (combined, dept) => new EmployeeViewModel
          {
              // 映射员工属性
              EmployeeId = combined.Employee.EmployeeId,
              EmployeeFirstName = combined.Employee.EmployeeFirstName,
              EmployeeLastName = combined.Employee.EmployeeLastName,
              // ... 把其他Employee属性都映射过来
              // 映射关联属性
              CountryName = combined.Country.CountryName,
              DepartmentName = dept.DepartmentName
          })
    .ToList();

左连接示例（保留所有员工，无对应国家/部门时显示默认值）：

var employeeViewModels = employees
    // 左连接国家表
    .GroupJoin(countries, 
               emp => emp.CountryId, 
               cntry => cntry.CountryId, 
               (emp, cntryGroup) => new { emp, cntryGroup })
    .SelectMany(combo => combo.cntryGroup.DefaultIfEmpty(), 
                (combo, cntry) => new { combo.emp, cntry })
    // 左连接部门表
    .GroupJoin(departments, 
               combined => combined.emp.DepartmentId, 
               dept => dept.DepartmentId, 
               (combined, deptGroup) => new { combined.emp, combined.cntry, deptGroup })
    .SelectMany(combo => combo.deptGroup.DefaultIfEmpty(), 
                (combo, dept) => new EmployeeViewModel
                {
                    EmployeeId = combo.emp.EmployeeId,
                    EmployeeFirstName = combo.emp.EmployeeFirstName,
                    // ... 其他员工属性
                    CountryName = combo.cntry?.CountryName ?? "未指定",
                    DepartmentName = dept?.DepartmentName ?? "未指定"
                })
    .ToList();

场景2：用Entity Framework从数据库获取数据 #

如果你的模型是EF实体，建议先给Employee添加导航属性（这样查询更简洁）：

namespace Company.Model
{
    class Employee
    {
        // 原有属性不变...
        public int? CountryId { get; set; }
        public int? DepartmentId { get; set; }

        // 添加导航属性
        public virtual Country Country { get; set; }
        public virtual Department Department { get; set; }
    }
}

然后直接用EF的Include加载关联数据，再映射到ViewModel：

using (var dbContext = new CompanyDbContext())
{
    var employeeViewModels = dbContext.Employees
        .Include(e => e.Country) // 加载关联的国家数据
        .Include(e => e.Department) // 加载关联的部门数据
        .Select(e => new EmployeeViewModel
        {
            EmployeeId = e.EmployeeId,
            EmployeeFirstName = e.EmployeeFirstName,
            // ... 其他员工属性
            CountryName = e.Country?.CountryName ?? "未指定",
            DepartmentName = e.Department?.DepartmentName ?? "未指定"
        })
        .ToList();
}

第三步：在WPF界面中使用ViewModel #

最后把ViewModel集合绑定到UI控件（比如DataGrid）。先创建一个主ViewModel来管理数据集合：

namespace Company.ViewModel
{
    public class MainViewModel : INotifyPropertyChanged
    {
        private ObservableCollection<EmployeeViewModel> _employeeList;
        public ObservableCollection<EmployeeViewModel> EmployeeList
        {
            get => _employeeList;
            set { _employeeList = value; OnPropertyChanged(); }
        }

        public MainViewModel()
        {
            // 加载数据并填充集合
            LoadEmployeeData();
        }

        private void LoadEmployeeData()
        {
            // 这里调用第二步的代码获取employeeViewModels
            var employeeVMs = /* 你的数据查询逻辑 */;
            EmployeeList = new ObservableCollection<EmployeeViewModel>(employeeVMs);
        }

        // INotifyPropertyChanged实现和之前一致
        public event PropertyChangedEventHandler PropertyChanged;
        protected void OnPropertyChanged([CallerMemberName] string propertyName = null)
        {
            PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName));
        }
    }
}

然后在XAML中绑定：

<Window x:Class="Company.View.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:vm="clr-namespace:Company.ViewModel"
        Title="员工列表" Height="450" Width="800">
    <Window.DataContext>
        <vm:MainViewModel />
    </Window.DataContext>
    <Grid>
        <DataGrid ItemsSource="{Binding EmployeeList}" AutoGenerateColumns="False" CanUserAddRows="False">
            <DataGrid.Columns>
                <DataGridTextColumn Header="员工ID" Binding="{Binding EmployeeId}" />
                <DataGridTextColumn Header="姓名" Binding="{Binding EmployeeFirstName}" />
                <DataGridTextColumn Header="国家" Binding="{Binding CountryName}" />
                <DataGridTextColumn Header="部门" Binding="{Binding DepartmentName}" />
                <!-- 添加其他需要展示的列 -->
            </DataGrid.Columns>
        </DataGrid>
    </Grid>
</Window>

这样就能在WPF界面中看到每位员工对应的国家和部门名称啦！

内容的提问来源于stack exchange，提问作者Karishma