From 72cfaf9fb66ae83059382723698de1233496bd28 Mon Sep 17 00:00:00 2001 From: CB2-20200827ONU\Administrator <liaoxujun@qq.com> Date: 星期六, 09 十月 2021 16:52:27 +0800 Subject: [PATCH] 修改定时提醒任务的BUG 增加合同多页面浏览 --- 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