From a247547df86f0fad8f03aebb91de68d3f2bc7918 Mon Sep 17 00:00:00 2001
From: 移动系统liao <liaoxujun@qq.com>
Date: 星期四, 01 五月 2025 10:16:52 +0800
Subject: [PATCH] 修正sugsql导航更新加配置的bug

---
 cylsg/ECTESTOA/OAServices.cs |   12 +++++++-----
 1 files changed, 7 insertions(+), 5 deletions(-)

diff --git a/cylsg/ECTESTOA/OAServices.cs b/cylsg/ECTESTOA/OAServices.cs
index 0f8cc41..747edf4 100644
--- a/cylsg/ECTESTOA/OAServices.cs
+++ b/cylsg/ECTESTOA/OAServices.cs
@@ -56,9 +56,9 @@
             else
             {
                 string CaiwuKey = App.Configuration["EcTestOAMenuName:CaiWu"] ?? "娌℃湁";
+               
 
-
-               var CaiWUMenuiId= await  _OAsqlSugarClient.Queryable<Sys_Permissions_Menu>().Where(x => x.IsUsed == true && x.MenuName == CaiwuKey).Select(x=>x.Keyid).WithCache(600).FirstAsync();
+                var CaiWUMenuiId= await  _OAsqlSugarClient.Queryable<Sys_Permissions_Menu>().Where(x => x.IsUsed == true && x.MenuName == CaiwuKey).Select(x=>x.Keyid).WithCache(600).FirstAsync();
                 int id = UserID?.toInt() ?? 0;
                 if (id == 0)
                     throw Oops.Oh("鐧诲綍淇℃伅閿欒");
@@ -68,10 +68,12 @@
                     throw Oops.Oh("鐧诲綍淇℃伅閿欒,涓嶆槸鏈夋晥鐢ㄦ埛");
                 }
                 //閲嶆柊鑾峰彇鏉冮檺
-                ret = await _OAsqlSugarClient.Queryable<OaStaff>().Includes(x => x.Department).Where(x => x.MobieNum == user.ItCode && x.FirmId == firmId).Select(x => new ECTESTOAPermissions
+                ret = await _OAsqlSugarClient.Queryable<OaStaff>().Includes(x => x.Department).Where(x => x.MobieNum == user.ItCode && x.FirmId == firmId&&x.Status=="鍦ㄨ亴").Select(x => new ECTESTOAPermissions
                 {
                     DepartmentName = x.Department.Name,
-                     DepartId=x.DepartmentId,
+                     DepartId=x.DepartmentId
+                
+                    
 
                 },true
                 ).FirstAsync();
@@ -97,7 +99,7 @@
                     }
                 }
 
-                _redisService.Add(ECTESTOAPermissionsKey + UserID, ret, 180);
+                _redisService.Add(ECTESTOAPermissionsKey + UserID, ret, 60);
                 
 
             }

--
Gitblit v1.9.1