From fd8ca33bacb87dbe74e0fb9eaa302ff9bd36f523 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 05 一月 2023 10:29:07 +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 ecee0df..32b52e3 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -1839,7 +1839,7 @@
sql = @"select B.id,B.ando_cogfigid,U.usercode,U.username,A.enable from TAnDon_Roul_ConFig A
inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
left join TUser U on B.usercode=U.usercode
- where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode";
+ where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode and U.is_delete=0";
dynamicParams.Add("@wkshopcode", wkshopcode);
dynamicParams.Add("@calltypecode", calltypecode);
var data = DapperHelper.selectdata(sql, dynamicParams);
--
Gitblit v1.9.3