From 6a19b4394850d0aac5cf3aab8a0136c77515c41d Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 19 三月 2024 17:16:14 +0800
Subject: [PATCH] 生产进度报表查询条件增减
---
VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
index 8b4db5a..45686f7 100644
--- a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
@@ -1208,7 +1208,8 @@
FROM TUser U
inner join cte on U.storg_code=cte.torg_code
left join TOrganization T on U.storg_code=T.torg_code
- left join TUser S on U.lm_user=S.usercode " + search + "";
+ left join TUser S on U.lm_user=S.usercode
+ where 1=1 " + search + "";
var data = DapperHelper.GetPagedDataWith<object>(withsql, sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
--
Gitblit v1.9.3