From 27f0636da2b4b22a16404a3dbea4b3d3d477a65e Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 15 三月 2024 15:19:28 +0800
Subject: [PATCH] 生产进度报表优化查询语句
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 7ecfbc5..2a2127d 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -330,7 +330,7 @@
}
if (UserName != "" && UserName != null)
{
- search += " and S.username like '%'+@UserName+'%' ";
+ search += " and u.username like '%'+@UserName+'%' ";
dynamicParams.Add("@UserName", UserName);
}
if (wagetype != "" && wagetype != null)
--
Gitblit v1.9.3