From 1ab89ba15fd521d83e809f52d6e50133814c042a Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 15 三月 2024 15:25:41 +0800
Subject: [PATCH] 1.订单、工单增加字段(销售业务员) 2.优化生产进度报表查询语句
---
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