首先,在Controller类中创建一个Get方法:
[HttpGet("employees/ending-leave")]
public IActionResult GetEmployeesEndingLeave()
{
//代码将在此处添加
}
然后,使用Entity Framework创建对Employee模型的数据库上下文,并确保已运行迁移。
接着,使用以下代码获取所有将于当前日期3天后结束休假的员工:
var endDate = DateTime.UtcNow.AddDays(3); // 获取3天后的日期
var employees = _context.Employees.Where(e => e.LeaveEnd <= endDate).ToList();
最后,将得到的员工列表作为ActionResult返回:
return Ok(employees);
最终,完整的代码如下所示:
[ApiController]
[Route("[controller]")]
public class EmployeeController : ControllerBase
{
private readonly MyDbContext _context;
public EmployeeController(MyDbContext context)
{
_context = context;
}
[HttpGet("employees/ending-leave")]
public IActionResult GetEmployeesEndingLeave()
{
var endDate = DateTime.UtcNow.AddDays(3); // 获取3天后的日期
var employees = _context.Employees.Where(e => e.LeaveEnd <= endDate).ToList();
return Ok(employees);
}
}