From dfa28b7d5089acd327ed81e4d311310ec195185f Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 26 十一月 2024 08:35:36 +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