/******************************************************************************* * Copyright © 2020 HT.Cloud.Framework 版权所有 * Author: HT.Cloud * Description: WaterCloud快速开发平台 * Website: *********************************************************************************/ using SqlSugar; using System; using System.Collections.Generic; using System.Threading.Tasks; using HT.Cloud.Code; using HT.Cloud.Domain.SystemManage; using HT.Cloud.Domain.SystemOrganize; namespace HT.Cloud.Service.SystemManage { public class ModuleButtonService : BaseService, IDenpendency { private string authorizecacheKey = GlobalContext.SystemConfig.ProjectPrefix + "_authorizeurldata_";// +权限 public ModuleButtonService(ISqlSugarClient context) : base(context) { } public async Task> GetList(string moduleId = "") { var list = repository.IQueryable(); if (!string.IsNullOrEmpty(moduleId)) { list = list.Where(a => a.F_ModuleId == moduleId); } return await list.Where(a => a.F_DeleteMark == false).OrderBy(a => a.F_SortCode).ToListAsync(); } public async Task> GetLookList(string moduleId = "", string keyword = "") { var query = repository.IQueryable().Where(a => a.F_DeleteMark == false); if (!string.IsNullOrEmpty(moduleId)) { query = query.Where(a => a.F_ModuleId == moduleId); } if (!string.IsNullOrEmpty(keyword)) { //此处需修改 query = query.Where(a => a.F_FullName.Contains(keyword) || a.F_EnCode.Contains(keyword)); } query = GetDataPrivilege("a", "", query); return await query.OrderBy(a => a.F_SortCode).ToListAsync(); } public async Task GetLookForm(string keyValue) { var data = await repository.FindEntity(keyValue); return GetFieldsFilterData(data); } public async Task GetForm(string keyValue) { var data = await repository.FindEntity(keyValue); return data; } public async Task DeleteForm(string keyValue) { if (await repository.IQueryable(a => a.F_ParentId.Equals(keyValue)).AnyAsync()) { throw new Exception("删除失败!操作的对象包含了下级数据。"); } else { await repository.Delete(a => a.F_Id == keyValue); } await CacheHelper.RemoveAsync(authorizecacheKey + repository.Db.CurrentConnectionConfig.ConfigId + "_list"); } public async Task> GetListByRole(string roleid) { var moduleList = repository.Db.Queryable().Where(a => a.F_ObjectId == roleid && a.F_ItemType == 2).Select(a => a.F_ItemId).ToList(); var query = repository.IQueryable().Where(a => (moduleList.Contains(a.F_Id) || a.F_IsPublic == true) && a.F_DeleteMark == false && a.F_EnabledMark == true); return await query.OrderBy(a => a.F_SortCode).ToListAsync(); } public async Task SubmitForm(ModuleButtonEntity moduleButtonEntity, string keyValue) { if (!string.IsNullOrEmpty(moduleButtonEntity.F_Authorize)) { moduleButtonEntity.F_Authorize = moduleButtonEntity.F_Authorize.ToLower(); } if (!string.IsNullOrEmpty(keyValue)) { moduleButtonEntity.Modify(keyValue); await repository.Update(moduleButtonEntity); } else { moduleButtonEntity.F_DeleteMark = false; moduleButtonEntity.F_AllowEdit = false; moduleButtonEntity.F_AllowDelete = false; var module = await repository.Db.Queryable().Where(a => a.F_Id == moduleButtonEntity.F_ModuleId).FirstAsync(); if (module.F_Target != "iframe" && module.F_Target != "expand") { throw new Exception("菜单不能创建按钮"); } moduleButtonEntity.Create(); await repository.Insert(moduleButtonEntity); } await CacheHelper.RemoveAsync(authorizecacheKey + repository.Db.CurrentConnectionConfig.ConfigId + "_list"); } public async Task SubmitCloneButton(string moduleId, string Ids) { string[] ArrayId = Ids.Split(','); var data = await this.GetList(); List entitys = new List(); var module = await repository.Db.Queryable().Where(a => a.F_Id == moduleId).FirstAsync(); if (module.F_Target != "iframe" && module.F_Target != "expand") { throw new Exception("菜单不能创建按钮"); } foreach (string item in ArrayId) { ModuleButtonEntity moduleButtonEntity = data.Find(a => a.F_Id == item); moduleButtonEntity.Create(); moduleButtonEntity.F_ModuleId = moduleId; entitys.Add(moduleButtonEntity); } await repository.Insert(entitys); await CacheHelper.RemoveAsync(authorizecacheKey + repository.Db.CurrentConnectionConfig.ConfigId + "_list"); } public async Task> GetListNew(string moduleId = "") { var query = repository.Db.Queryable((a, b) => new JoinQueryInfos( JoinType.Inner, a.F_ModuleId == b.F_Id && b.F_EnabledMark == true && b.F_DeleteMark == false )).Where(a => a.F_EnabledMark == true && a.F_DeleteMark == false) .Select((a, b) => new ModuleButtonEntity { F_Id = a.F_Id, F_AllowDelete = a.F_AllowDelete, F_AllowEdit = a.F_AllowEdit, F_UrlAddress = a.F_UrlAddress, F_CreatorTime = a.F_CreatorTime, F_CreatorUserId = a.F_CreatorUserId, F_DeleteMark = a.F_DeleteMark, F_DeleteTime = a.F_DeleteTime, F_DeleteUserId = a.F_DeleteUserId, F_Description = a.F_Description, F_EnabledMark = a.F_EnabledMark, F_EnCode = a.F_EnCode, F_FullName = a.F_FullName, F_Icon = a.F_Icon, F_IsPublic = a.F_IsPublic, F_JsEvent = a.F_JsEvent, F_LastModifyTime = a.F_LastModifyTime, F_LastModifyUserId = a.F_LastModifyUserId, F_Layers = a.F_Layers, F_Location = a.F_Location, F_ModuleId = b.F_UrlAddress, F_ParentId = a.F_ParentId, F_SortCode = a.F_SortCode, F_Split = a.F_Split, }).MergeTable(); if (!string.IsNullOrEmpty(moduleId)) { query = query.Where(a => a.F_ModuleId == moduleId); } return await query.OrderBy(a => a.F_SortCode).ToListAsync(); } } }