在列表中选择一周内没有休息日的记录<T> - C#

Question

我有一个Employee类，它定义为：

Employee
{
   public int Id { get; set; }
   public string Name { get; set; }
   public DateTime WorkDate { get; set; }
   public bool isOff { get; set; }
}

这是我的类实现和用法：

List<Employee> workers = new List<Employee>()
{
    new Employee { Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/11/2016"), IsOff = false},
    new Employee { Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/12/2016"), IsOff = false},
    new Employee { Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/13/2016"), IsOff = true},
    new Employee { Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/14/2016"), IsOff = false},
    new Employee { Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/15/2016"), IsOff = false},
    new Employee { Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/16/2016"), IsOff = false},
    new Employee { Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/17/2016"), IsOff = false},
    new Employee { Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/11/2016"), IsOff = false},
    new Employee { Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/12/2016"), IsOff = false},
    new Employee { Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/13/2016"), IsOff = false},
    new Employee { Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/14/2016"), IsOff = false},
    new Employee { Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/15/2016"), IsOff = false},
    new Employee { Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/16/2016"), IsOff = false},
    new Employee { Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/17/2016"), IsOff = false},
};

在上面的初始化中，只有一条记录关闭：

Id = 1, Name = "Emp 1" and the WorkDate = 4/13/2016

现在，我如何获得一周（4月11日至17日）没有休息日的员工的id？哪个是Id = 2

LINQ解决方案要好得多，但我不知道怎么做。

更新的

为了避免混淆对象Employee，我将其更改为EmployeeSchedule

class EmployeeSchedule
{
   public int Id { get; set; }
   public string Name { get; set; }
   public DateTime WorkDate { get; set; }
   public bool isOff { get; set; }
}

这就是的实现

List<EmployeeSchedule> workers = new List<EmployeeSchedule>()
{
    new EmployeeSchedule{ Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/11/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/12/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/13/2016"), IsOff = true},
    new EmployeeSchedule{ Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/14/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/15/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/16/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 1, Name = "Emp 1", WorkDate = Convert.ToDateTime("4/17/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/11/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/12/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/13/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/14/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/15/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/16/2016"), IsOff = false},
    new EmployeeSchedule{ Id = 2, Name = "Emp 2", WorkDate = Convert.ToDateTime("4/17/2016"), IsOff = false},
};

所选答案仍然适用。

Answer 1

现在，我如何获取没有休息日的员工的id整个星期（4月11日至17日）？哪个Id=2

您可以使用Linq扩展，并实现这一点。

var empid = workers.GroupBy(g=> g.Id)           
                   .Where(x=>x.All(e=>!e.IsOff))
                   .Select(x=>x.Key)

Answer 2

这意味着你需要一个fromDate，toDate，并且你必须从列表中找到员工，条件是WorkDate应该在fromDate和toDate之间，isOff == false意味着has no day off throughout the week。所以你可以使用以下代码段：

 DateTime fromDate = new DateTime(2016, 04, 11);
 DateTime toDate = new DateTime(2016, 04, 17);
 var noDayOfList = workers.GroupBy(x=> x.Id)
                          .Where(x =>
                                 x.All(y=> 
                                 y.WorkDate >= fromDate && 
                                 y.WorkDate <= toDate && 
                                 !y.isOff))
                          .Select(z=>z.Key).ToList();   

Answer 3

你可以写这样的东西：

var startDate = new DateTime(2016,04,11);
var endDate = new DateTime(2016,04,17);
var ids = workers
    .Where(w => w.WorkDate >= startDate)
    .Where(w => w.WorkDate <= endDate)
    .GroupBy(w => w.Id)
    .Where(g => !g.Any(w => w.IsOff))
    .Select(g => g.Key);

本质上：

1. 筛选所需的行（在此时间范围内）
2. 按员工id分组
3. 确保组中没有行标记为IsOff
4. 选择分组密钥（在这种情况下，它将是员工的Id）

不过，请注意，调用对象Employee有点令人困惑，因为它实际上代表的是员工的日程安排，而不是员工本身

Answer 4

try，这有两个条件id和日期，但您的id足以满足您的需求，

List<string> resEmp = new List<string>();
foreach (var item in workers )
 {
     if (item.Id == 2 and item.IsOff == false)
      {
        resEmp.Add(item);
      }
 }

Answer 5

也看看这些代码。

我已经定义了一个Employee的Model类来获取数据，

也许目前你需要Id，但将来你也可以使用其他属性。

public class Employee
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public DateTime WorkDate { get; set; }
        public bool IsOff { get; set; }
    }

和代码wtih Linq表达式，

 Employee objEmployee = new Employee();
 objEmployee.Id = workers
         .GroupBy(itm => itm.Id)
         .Where(itm => !itm.Any(m => m.IsOff))
         .Select(itm => itm.Key)
         .FirstOrDefault();