From 0dd2c49c7123f177338985686fe5a0a00a851fbc Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 23 八月 2022 15:17:43 +0800
Subject: [PATCH] 不良处理接口开发
---
VueWebApi/DLL/DAL/ProductModelDAL.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ProductModelDAL.cs b/VueWebApi/DLL/DAL/ProductModelDAL.cs
index 5166223..4184763 100644
--- a/VueWebApi/DLL/DAL/ProductModelDAL.cs
+++ b/VueWebApi/DLL/DAL/ProductModelDAL.cs
@@ -1188,12 +1188,14 @@
}
}
//褰撳墠宸ュ簭绫诲瀷涓庡叧鑱斿伐浣滅珯涓殑绫诲瀷鏄惁鍖归厤,涓嶅尮閰嶅垯娓呴櫎鍏宠仈宸ヤ綔绔欐暟鎹紝鍚屾椂娓呯悊宸ュ簭鏍�(鍏宠仈宸ヤ綔绔欐爣璇嗗瓧娈典负N)
- var sql_10 = @"select * from TFlw_Rteqp where step_code=@stepcode";
+ var sql_10 = @"select S.flwtype from TFlw_Rteqp A
+ inner join TStep S on A.step_code=S.stepcode
+ where A.step_code=@stepcode";
dynamicParams.Add("@stepcode", stepcode);
var data_10 = DapperHelper.selectdata(sql_10, dynamicParams);
if (data_10.Rows.Count > 0)
{
- if (data_10.Rows[0]["STYLE"].ToString() != "steptypecode")
+ if (data_10.Rows[0]["FLWTYPE"].ToString() != steptypecode)
{
//鍒犻櫎宸ュ簭鍏宠仈宸ヤ綔绔欒〃
sql_1 = @"delete TFlw_Rteqp where step_code=@stepcode";
--
Gitblit v1.9.3