From 6e8866830ef12fc7ae99d8f160cbb37c0f08c3bd Mon Sep 17 00:00:00 2001 From: dengjunjie <dengjunjie@hnkhzn.com> Date: 星期六, 11 一月 2025 11:38:24 +0800 Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/MeiRuiAn/HuaiAn --- 代码管理/WMS/WIDESEA_WMSServer/WIDESEA_Core/HostedService/PermissionDataHostService.cs | 45 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 45 insertions(+), 0 deletions(-) diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_Core/HostedService/PermissionDataHostService.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_Core/HostedService/PermissionDataHostService.cs" index 1656f81..0ff7fb6 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_Core/HostedService/PermissionDataHostService.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_Core/HostedService/PermissionDataHostService.cs" @@ -87,6 +87,51 @@ return userRoles; } + public static List<UserRole> GetUserRoles(ISqlSugarClient db, int userId) + { + List<ExpandoObject> roles = db.Queryable("Sys_Role", "x").Select(RoleSelectModes).ToList(); + List<dynamic> roleDynamics = new List<dynamic>(); + foreach (var item in roles) + { + roleDynamics.Add(item); + } + + List<dynamic> roleDataDynamics = new List<dynamic>(); + List<ExpandoObject> roleDatas = db.Queryable("Sys_RoleDataPermission", "x").Select(RoleDataSelectModes).ToList(); + foreach (var item in roleDatas) + { + roleDataDynamics.Add(item); + } + + List<ExpandoObject> users = db.Queryable("Sys_User", "x").Where($"UserId={userId}").Select(UserSelectModes).ToList(); + + List<UserRole> userRoles = new List<UserRole>(); + foreach (var item in users) + { + dynamic user = item; + dynamic? role = roleDynamics.FirstOrDefault(x => x.RoleId == user.RoleId); + List<object> warehouseIds = roleDataDynamics.Where(x => x.RoleId == user.RoleId).Select(x => x.WarehouseId).ToList(); + List<int> ids = new List<int>(); + for (int i = 0; i < warehouseIds.Count; i++) + { + ids.Add(Convert.ToInt32(warehouseIds[i])); + } + if (role != null) + { + userRoles.Add(new UserRole + { + RoleId = role.RoleId, + RoleName = role.RoleName, + ParentId = role.ParentId, + UserId = user.UserId, + UserName = user.UserName, + WarehouseIds = ids + }); + } + } + return userRoles; + } + static List<SelectModel> RoleSelectModes = new List<SelectModel>() { new SelectModel() -- Gitblit v1.9.3