From 496dafd14e52483a117b9dbd0a9532b3357aabfc Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 12 十月 2022 10:03:24 +0800
Subject: [PATCH] 生产工单新增修改接口调整
---
VueWebApi/DLL/DAL/ReportManagerDAL.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ReportManagerDAL.cs b/VueWebApi/DLL/DAL/ReportManagerDAL.cs
index 8951924..1ff7101 100644
--- a/VueWebApi/DLL/DAL/ReportManagerDAL.cs
+++ b/VueWebApi/DLL/DAL/ReportManagerDAL.cs
@@ -628,12 +628,12 @@
}
if (defectcode != "" && defectcode != null)
{
- search += "and T.stepcode like '%'+@defectcode+'%' ";
+ search += "and F.code like '%'+@defectcode+'%' ";
dynamicParams.Add("@defectcode", defectcode);
}
if (defectname != "" && defectname != null)
{
- search += "and T.stepname like '%'+@defectname+'%' ";
+ search += "and F.name like '%'+@defectname+'%' ";
dynamicParams.Add("@defectname", defectname);
}
if (reportname != "" && reportname != null)
@@ -715,12 +715,12 @@
}
if (defectcode != "" && defectcode != null)
{
- search += "and T.stepcode like '%'+@defectcode+'%' ";
+ search += "and F.code like '%'+@defectcode+'%' ";
dynamicParams.Add("@defectcode", defectcode);
}
if (defectname != "" && defectname != null)
{
- search += "and T.stepname like '%'+@defectname+'%' ";
+ search += "and F.name like '%'+@defectname+'%' ";
dynamicParams.Add("@defectname", defectname);
}
if (reportname != "" && reportname != null)
--
Gitblit v1.9.3