点检记录导出接口报错优化、不良明细查询接口优化 安灯系统PC端接口开发

yl

2022-09-22 59d429fd2caa1ecb879abfd21e9be17d42a39ee0

 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)