From 04a14d3a56f9a64668a920e2dfe21d2a7daf89b3 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 06 三月 2023 16:37:42 +0800
Subject: [PATCH] 1.节拍工价新增、编辑加工价类型字段区分自制、外协 2.工序编辑,工序类型切换保存时删除对应节拍工价表 3.工单派发时判断区分自制、外协工序 4.计件工资报表增加剔除工序参数

---
 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