From 59d429fd2caa1ecb879abfd21e9be17d42a39ee0 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 22 九月 2022 17:38:22 +0800
Subject: [PATCH] 点检记录导出接口报错优化、不良明细查询接口优化 安灯系统PC端接口开发
---
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