From f1b2ef9600a038008e11b151a5cb7cffab336be5 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 28 二月 2025 09:26:26 +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