From 6818b4c96b7c166ad18a0d7affcf5aca3e40101b Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 18 十月 2022 17:10:52 +0800 Subject: [PATCH] 修改查询的问题 --- CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs b/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs index 163716d..f67c6a7 100644 --- a/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs +++ b/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs @@ -539,6 +539,10 @@ { Condition += " and ( DATEDIFF(DAY,GETDATE(),ob.[DeliveryTime]) >7 or DATEDIFF(DAY,GETDATE(),oe.[DelayTime])>7 )"; } + else if (DeliveryTime == "閫炬湡") + { + Condition += " and ( DATEDIFF(DAY,GETDATE(),ob.[DeliveryTime])<=0 or DATEDIFF(DAY,GETDATE(),oe.[DelayTime])<=0 )"; + } } -- Gitblit v1.9.1