From b18a7c8e54b51a5caa400e55cb8cc428c0301a0c Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 21 一月 2022 17:27:22 +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 72aa483..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) && 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