From e110200c2e32a0f82f474fa38b315ae6360f2dc4 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 04 三月 2025 08:39:38 +0800 Subject: [PATCH] 在订单列表 送货安排 点击打印送货单 选择送货日期 默认最晚的送货日期,默认当天,可以修改 完成 司机查询 拥有司机小程序权限的人员 完成 新增送货 可以选择客户,也可以 填写临时客户 完成 --- CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs index 17e5c72..8231c31 100644 --- a/CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs +++ b/CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs @@ -314,11 +314,11 @@ { if (selHetongshangchuan == "1") { - Condition += string.Format(" and EXISTS ( select CorporateClientsid from [dbo].[OA_CorporateClientContract] where CorporateClientsid=a.Keyid ) "); + Condition += string.Format(" and a.Keyid in ( select CorporateClientsid from [dbo].[OA_CorporateClientContract] ) "); } else { - Condition += string.Format(" and NOT EXISTS ( select CorporateClientsid from [dbo].[OA_CorporateClientContract] where CorporateClientsid=a.Keyid ) "); + Condition += string.Format(" and a.Keyid not in ( select CorporateClientsid from [dbo].[OA_CorporateClientContract] ) "); } } -- Gitblit v1.9.1