From 4bf2b5d9caa83082f690a84c4518f3ad6ad6d599 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 29 七月 2025 12:28:08 +0800 Subject: [PATCH] 20250722 通讯录账号密码显示查看权限,根据查看权限查询 完成 --- CY_ECommercePlatform/CY.BLL/OA/Adm_zhanghaomimaBLL.cs | 15 ++++++++++++++- 1 files changed, 14 insertions(+), 1 deletions(-) diff --git a/CY_ECommercePlatform/CY.BLL/OA/Adm_zhanghaomimaBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/Adm_zhanghaomimaBLL.cs index 617dfda..efcb2de 100644 --- a/CY_ECommercePlatform/CY.BLL/OA/Adm_zhanghaomimaBLL.cs +++ b/CY_ECommercePlatform/CY.BLL/OA/Adm_zhanghaomimaBLL.cs @@ -150,7 +150,7 @@ /// </summary> /// <param name="pa"></param> /// <returns></returns> - public IEnumerable<Adm_zhanghaomima> SelectModelPage(Pagination pa, Guid FirmId, string type_id, string chanpinxiangmu, bool IsChangyongziliao, int? staffid) + public IEnumerable<Adm_zhanghaomima> SelectModelPage(Pagination pa, Guid FirmId, string type_id, string chanpinxiangmu, bool IsChangyongziliao, int? staffid, string selquanxin) { string Condition = " and ok.FirmId ='" + FirmId + "' and ok.rec_status = 'A' "; @@ -160,6 +160,19 @@ Condition += " and ok.type_id = " + type_id + ""; } + if (!string.IsNullOrEmpty(selquanxin)) + { + if (selquanxin == "1") + { + Condition += " and ( ok.[Jusequanxian] = '' or ok.[Jusequanxian] = ',,' )"; + } + else if (selquanxin == "2") + { + Condition += " and (ok.[Jusequanxian] != '' and ok.[Jusequanxian] != ',,' )"; + } + + } + if (!string.IsNullOrEmpty(chanpinxiangmu)) { Condition += " and ok.chanpinxiangmu like '%" + chanpinxiangmu + "%'"; -- Gitblit v1.9.1