From 1280aa7ceaeffcdcd52e3c0fd45c86f608f9f0cf Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 05 八月 2025 09:02:10 +0800
Subject: [PATCH] 20250804 供应商，新增采购，过滤供应商
---
CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs | 15 ++++++++++++++-
1 files changed, 14 insertions(+), 1 deletions(-)
diff --git a/CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs
index 37a38ed..c7d8954 100644
--- a/CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs
+++ b/CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs
@@ -152,7 +152,7 @@
/// </summary>
/// <param name="pa"></param>
/// <returns></returns>
- public IEnumerable<Adm_tongxunlu> SelectModelPage(Pagination pa, Guid FirmId, string type_id, string danwei_name,bool IsChangyongziliao,int? staffid)
+ public IEnumerable<Adm_tongxunlu> SelectModelPage(Pagination pa, Guid FirmId, string type_id, string danwei_name,bool IsChangyongziliao,int? staffid, string selquanxin)
{
string Condition = " and ok.FirmId ='" + FirmId + "' and ok.rec_status = 'A' ";
@@ -162,6 +162,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(danwei_name))
{
Condition += " and ok.danwei_name like '%" + danwei_name + "%'";
--
Gitblit v1.9.1