From b6349cb2b3a868c8c917ca221bb7eaf6f272bdd2 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 22 八月 2022 10:59:55 +0800
Subject: [PATCH] 功能模块添加过滤器
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 84404ba..619afec 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -232,7 +232,7 @@
var dynamicParams = new DynamicParameters();
try
{
- sql = @"select * from TOrganization where parent_id=@orgid";
+ sql = @"select * from TOrganization where parent_id=@orgid and is_delete<>'1'";
dynamicParams.Add(@"orgid", orgid);
cont = DapperHelper.selectcount(sql, dynamicParams);
if (cont>0)
--
Gitblit v1.9.3