From 4d4e3ad417beccd49f1fe61a158bb1bc3a3537c2 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 27 十二月 2022 15:18:17 +0800
Subject: [PATCH] 采购订单,erp同步接口开发
---
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