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/QualityManagementDAL.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/QualityManagementDAL.cs b/VueWebApi/DLL/DAL/QualityManagementDAL.cs
index c654d24..21cec92 100644
--- a/VueWebApi/DLL/DAL/QualityManagementDAL.cs
+++ b/VueWebApi/DLL/DAL/QualityManagementDAL.cs
@@ -652,7 +652,7 @@
}
if (partcode != "" && partcode != null)
{
- search += "and A.partcode like '%'+@stanedname+'%' ";
+ search += "and A.partcode like '%'+@partcode+'%' ";
dynamicParams.Add("@partcode", partcode);
}
if (partname != "" && partname != null)
@@ -698,7 +698,7 @@
left join TMateriel_Info B on A.partcode=B.partcode
left join TStep S on A.step_code=S.stepcode
left join TStepCheckStandard T on A.checkstaned_code=T.code
- left join TUser U on A.lm_user=U.usercode
+ left join TUser U on A.check_user=U.usercode
where " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
--
Gitblit v1.9.3