From 819289e1cfaa581fd6aafe9e43f5450d2860ba56 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 08 三月 2023 12:48:44 +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