From 2cc036e7b5ca7ba242b1296d946f8d563f3cf4c2 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期日, 16 十月 2022 01:34:22 +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