Csharp C#LINQ多行条件

你可以使用混合方法，在使用记录集之前添加过滤器.对于simple where，使用方法语法更简单:

public List<VehicleOnTaskDetailDto> GetVehicleOnTaskDetailFinished(VotFilterRequest filterRequest)
{
    using var context = new VehicleDeliveryContext();

    var vehiclesOnTask = context.VehiclesOnTask.AsQueryable();

    if (filterRequest.DateType == "GivenDate")
    {
        vehiclesOnTask = vehiclesOnTask.Where(v => filterRequest.FirstDate <= v.GivenDate && filterRequest.LastDate >= v.GivenDate)
    }
    else
    {
        vehiclesOnTask = vehiclesOnTask.Where(v => filterRequest.FirstDate <= v.ReturnDate && filterRequest.LastDate >= v.ReturnDate)
    }   

    var result = (from v in vehiclesOnTask
        join d in context.Departments on v.DepartmentId equals d.Id 
        join dr in context.Drivers on v.DriverId equals dr.Id
        join vehicle in context.Vehicles on v.VehicleId equals vehicle.Id 
        where v.IsDeleted != true
        where v.IsFinished == true
        orderby v.GivenDate descending 
        select new VehicleOnTaskDetailDto{
            VehicleOnTaskId = v.Id,
            VehiclePlate = vehicle.Plate,
            VehicleId = v.VehicleId,
            DriverName = $"{dr.Name} {dr.Surname} - {dr.Mission}",
            DepartmentName = d.Name,
            TaskDefinition = v.TaskDefinition,
            AuthorizedPerson = v.AuthorizedPerson,
            Address = v.Address,
            GivenDate = v.GivenDate,
            ReturnDate = v.ReturnDate
        }).ToList();
    return result;
}