From 6356d547e2058a7ab12e384330155dd95bc5928d Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 18 八月 2022 09:39:05 +0800
Subject: [PATCH] 设备点检标准(关联设备查询、提交)接口开发 设备保养标准(查询、新增、编辑、删除、查看、关联设备查询、关联设备提交)接口开发

---
 VueWebApi/DLL/DAL/SystemSettingDAL.cs |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/VueWebApi/DLL/DAL/SystemSettingDAL.cs b/VueWebApi/DLL/DAL/SystemSettingDAL.cs
index 2bb643f..b9dfafc 100644
--- a/VueWebApi/DLL/DAL/SystemSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/SystemSettingDAL.cs
@@ -45,7 +45,7 @@
                 var total = 0; //鎬绘潯鏁�
                 var sql = @"select A.right_code,A.right_name,B.prefix,B.filingdate,B.incbit  from TRight A
 							left join T_CodeRules B on A.right_code=B.rightcode
-							where A.Type='PC' and A.parent_id<>'0' " + search + "";
+							where A.Type='PC' and A.parent_id<>'0' and A.is_delete<>'1' " + search + "";
                 var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                 mes.code = "200";
                 mes.Message = "鏌ヨ鎴愬姛!";

--
Gitblit v1.9.3