From 176106cf1be8bb0dfd9921180b26d7cc9efb7a3d Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期一, 16 十二月 2024 08:52:39 +0800 Subject: [PATCH] 外协付款申请功能 --- CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs | 14 ++++++++++++-- 1 files changed, 12 insertions(+), 2 deletions(-) diff --git a/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs index 21b3821..6db6161 100644 --- a/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs +++ b/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs @@ -158,8 +158,18 @@ { string Condition = " and od.FirmId ='" + FirmId + "' and od.shifouDelivery = 1 "; - if (!string.IsNullOrEmpty(DeliveredTime)) - Condition += " and DATEDIFF(day,od.[DeliverTime],'" + DeliveredTime + "')=0 "; + if (!string.IsNullOrEmpty(DeliveredTime) ) + { + if(DeliveredTime != "閫炬湡") + { + Condition += " and DATEDIFF(day,od.[DeliverTime],'" + DeliveredTime + "')=0 "; + } + else + { + Condition += " and DATEDIFF(day,GETDATE(),od.[DeliverTime])<=0 "; + } + } + if (!string.IsNullOrEmpty(CarId)) Condition += " and od.CarId = '" + CarId + "'"; -- Gitblit v1.9.1