c# - 如何在上午/下午 24 小时之间设置日期

Question

我有2个参数。一个是 defaultFromD，另一个是 defaultFromD。如果我为此提供 2 个日期范围 x.CreatedOn >= defaultFromD && x.CreatedOn <= defaultToD

x.CreatedOn >= '2021-10-17' && x.CreatedOn <= '2021-10-20'

它的工作。但是如果我为这两个参数提供相同的日期，则此条件不起作用。

x.CreatedOn >= '2021-10-20' && x.CreatedOn <= '2021-10-20'

我想知道如何在一种情况下通过这两个逻辑。请帮我解决这个问题。

谢谢...

  public ResponseDTO<IQueryable<LabRequestForLabOrderDTO>> GetApprovedLabRequestsQueryable(DateTime defaultFromD, DateTime defaultToD)
    {
        var resp = ResponseBuilder.Build<IQueryable<LabRequestForLabOrderDTO>>();
        var reqs = this.labRequestRepository.GetAllActive().Where(x => x.IsActive && x.TrxStatus == 1 && x.InvoiceStatus == "Approved"
                        && x.CreatedOn >= defaultFromD && x.CreatedOn <= defaultToD)
                .Select(x => new LabRequestForLabOrderDTO
                {
                    Clinic = x.Clinic,
                    LabOrderCreated = x.LabOrderCreated,
                    InvoiceStatus = x.InvoiceStatus,
                    CreatedOn = x.CreatedOn
                }).AsQueryable();

        resp.AddSuccessResult(reqs);
        return resp;
    }

标签： c#asp.net.netasp.net-mvcmodel-view-controller

Answer 1

尝试这个

x.CreatedOn.AddDays(-1) > defaultFromD && x.CreatedOn.AddDays(1) < defaultToD