C# 程序使用 LINQ 根据薪水对部门为 ABC 的员工列表进行排序

WBOY

发布时间：2023-09-02 10:21:02

855人浏览过

来源于tutorialspoint

转载

c# 程序使用 linq 根据薪水对部门为 abc 的员工列表进行排序

在C#中，LINQ（Language Integrated Query）是一个强大的工具，可以轻松地对数据进行排序、过滤和操作。在本文中，我们将演示如何使用LINQ根据员工的薪水和部门对员工列表进行排序。

使用LINQ根据工资和部门对员工列表进行排序

To sort a list of employees based on their salary and department using LINQ, you can follow the steps below −

1. Create a Class to Represent an Employee

public class Employee {
   public string Name { get; set; }
   public int Salary { get; set; }
   public string Department { get; set; }
}

2. Create a List of Employees

List employees = new List {
   new Employee { Name = "John", Salary = 50000, Department = "ABC" },
   new Employee { Name = "Mary", Salary = 60000, Department = "DEF" },
   new Employee { Name = "Bob", Salary = 40000, Department = "ABC" },
   new Employee { Name = "Alice", Salary = 70000, Department = "XYZ" }
};

3. Use LINQ to Sort the List of Employees by Salary and Department

var sortedEmployees = employees
   .Where(e => e.Department == "ABC")
   .OrderByDescending(e => e.Salary)
   .ThenBy(e => e.Name);

4. Iterate through the Sorted List and Print out each Employee's Name and Salary

foreach (var employee in sortedEmployees) {
   Console.WriteLine($"{employee.Name}: {employee.Salary}");
}

Explanation

的中文翻译为：

解释

Step 1 - 我们定义一个名为Employee的类来表示一个员工。这个类有三个属性：Name（姓名），Salary（薪水）和Department（部门）。

Step 2 - We create a list of employees and initialize it with some sample data.

MCP Market

MCP Servers集合平台，帮你找到最好的MCP服务器

下载

步骤 3 - 我们使用 LINQ 对员工列表按照薪水和部门进行排序。我们首先筛选出部门为“ABC”的员工，然后按照薪水降序和姓名升序对筛选后的列表进行排序。结果是一个满足筛选条件的员工排序列表。

第四步 - 我们遍历已排序的员工列表，并使用字符串插值打印出每个员工的姓名和薪水。

示例

using System;
using System.Collections.Generic;
using System.Linq;

public class Employee {
   public string Name { get; set; }
   public int Salary { get; set; }
   public string Department { get; set; }
}

class Program {
   static void Main(string[] args) {
      List employees = new List {
         new Employee { Name = "John", Salary = 50000, Department = "ABC" },
         new Employee { Name = "Mary", Salary = 60000, Department = "DEF" },
         new Employee { Name = "Bob", Salary = 40000, Department = "ABC" },
         new Employee { Name = "Alice", Salary = 70000, Department = "XYZ" }
      };
   
      var sortedEmployees = employees
         .Where(e => e.Department == "ABC")
         .OrderByDescending(e => e.Salary)
         .ThenBy(e => e.Name);
   
      foreach (var employee in sortedEmployees) {
         Console.WriteLine($"{employee.Name}: {employee.Salary}");
      }
   }
}