From eea9ea3094e223d531ec058a1ef6e1656b0a5216 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期一, 10 三月 2025 09:05:22 +0800 Subject: [PATCH] 送货单逾期不要 就是要订单没有送货的逾期 完成 送货管理下 未送货订单 /Pages/business/OrderSonghuoanchiList.aspx 01 --- CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs index 418b40b..0771cec 100644 --- a/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs +++ b/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs @@ -157,7 +157,7 @@ string CarId, string DriverId,string trueMemberId ="", string CustormerName = "", string BusinessManager = "") { string Condition = " and od.FirmId ='" + FirmId + "' and od.shifouDelivery = 1 "; - string sort = " case when Sort is null then 1 else 0 end asc,Sort asc "; + string sort = " Dizhi asc "; if (!string.IsNullOrEmpty(DeliveredTime) ) { if(DeliveredTime != "閫炬湡") @@ -168,7 +168,7 @@ else { Condition += " and DATEDIFF(day,GETDATE(),od.[DeliverTime])<0 and od.[DeliveredTime] is null "; - sort = " DeliverTime desc,Sort asc "; + sort = " DeliverTime desc,Dizhi asc "; } } -- Gitblit v1.9.1