App_V2.3/SourceCode/WeApp.Application/BasicInfo/TrainingRoleGroup/TrainingRoleGroupApplicationService.cs

using Abp.Application.Services.Dto;
using Abp.Auditing;
using Abp.Authorization;
using Abp.Domain.Repositories;
using Abp.Runtime.Caching;

using IwbZero.AppServiceBase;
using IwbZero.Auditing;

using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Threading.Tasks;
using System.Web.Mvc;

using WeApp.Authorization;
using WeApp.BasicInfo.TrainingRole.Dto;
using WeApp.BasicInfo.TrainingRoleGroup.Dto;

namespace WeApp.BasicInfo.TrainingRoleGroup
{
    [AbpAuthorize, AuditLog("演练角色组维护")]
    public class TrainingRoleGroupAppService : IwbAsyncCrudAppService<TrainingRoleGroupInfo, TrainingRoleGroupDto, string, IwbPagedRequestDto, TrainingRoleGroupCreateDto, TrainingRoleGroupUpdateDto>, ITrainingRoleGroupAppService
    {
        public TrainingRoleGroupAppService(
            ICacheManager cacheManager,
            IRepository<TrainingRoleGroupInfo, string> repository, IRepository<TrainingRoleInfo, string> roleRepository, IRepository<TrainingGroupRelateRoleInfo> grrRepository) : base(repository, "Id")
        {
            RoleRepository = roleRepository;
            GrrRepository = grrRepository;
            CacheManager = cacheManager;
        }

        protected IRepository<TrainingRoleInfo, string> RoleRepository { get; }
        protected IRepository<TrainingGroupRelateRoleInfo> GrrRepository { get; }

        protected override bool KeyIsAuto { get; set; } = false;

        #region GetSelect

        [DisableAuditing]
        public override async Task<List<SelectListItem>> GetSelectList()
        {
            var list = await Repository.GetAllListAsync();
            var sList = new List<SelectListItem> { new SelectListItem { Text = @"请选择...", Value = "", Selected = true } };
            foreach (var l in list)
            {
                sList.Add(new SelectListItem { Value = l.Id, Text = l.RoleGroupName });
            }
            return sList;
        }

        [DisableAuditing]
        public override async Task<string> GetSelectStr()
        {
            var list = await Repository.GetAllListAsync();
            string str = "<option value=\"\" selected>请选择...</option>";
            foreach (var l in list)
            {
                str += $"<option value=\"{l.Id}\">{l.RoleGroupName}</option>";
            }
            return str;
        }

        #endregion GetSelect

        #region CURD

        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgCreate)]
        public override async Task Create(TrainingRoleGroupCreateDto input)
        {
            input.Id = await AppGuidManager.GetNextRecordIdAsync(DataLibType.TrainRoleGroup);

            if (input.RoleNos != null && input.RoleNos.Any())
            {
                input.Roles = string.Join(",", input.RoleNos.ToArray());
                foreach (var roleNo in input.RoleNos)
                {
                    var groupRelate = new TrainingGroupRelateRoleInfo()
                    {
                        RoleGroupNo = input.Id,
                        TrainRoleNo = roleNo
                    };
                    await GrrRepository.InsertAsync(groupRelate);
                }
            }

            await CreateEntity(input);
        }

        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgUpdate)]
        public override async Task Update(TrainingRoleGroupUpdateDto input)
        {
            var entity = await Repository.FirstOrDefaultAsync(a => a.Id == input.Id);

            if (entity == null)
            {
                CheckErrors($"未查询到编号未【{input.Id}】的角色组预案");
                return;
            }

            var oldNos = await GrrRepository.GetAll().Where(a => a.RoleGroupNo == input.Id).Select(a => a.TrainRoleNo)
                .ToListAsync();
            if (input.RoleNos != null && input.RoleNos.Any())
            {
                input.Roles = string.Join(",", input.RoleNos.ToArray());
                foreach (var roleNo in input.RoleNos)
                {
                    if (oldNos.Contains(roleNo))
                    {
                        oldNos.Remove(roleNo);
                    }
                    else
                    {
                        var groupRelate = new TrainingGroupRelateRoleInfo()
                        {
                            RoleGroupNo = input.Id,
                            TrainRoleNo = roleNo
                        };
                        await GrrRepository.InsertAsync(groupRelate);
                    }
                }

                if (oldNos.Any())
                {
                    foreach (var oldNo in oldNos)
                    {
                        await GrrRepository.DeleteAsync(a => a.RoleGroupNo == input.Id && a.TrainRoleNo == oldNo);
                    }
                }
            }
            await UpdateEntity(input, entity);
        }

        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgDelete)]
        public override Task Delete(EntityDto<string> input)
        {
            return base.Delete(input);
        }

        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgQuery)]
        public override async Task<PagedResultDto<TrainingRoleGroupDto>> GetAll(IwbPagedRequestDto input)
        {
            var query = CreateFilteredQuery(input);
            query = ApplyFilter(query, input);
            var totalCount = await AsyncQueryableExecuter.CountAsync(query);
            query = ApplySorting(query, input);
            query = ApplyPaging(query, input);
            var entities = await AsyncQueryableExecuter.ToListAsync(query);
            var dtoList = new PagedResultDto<TrainingRoleGroupDto>(totalCount, entities.Select(Map2Dto).ToList());
            return dtoList;
        }

        private TrainingRoleGroupDto Map2Dto(TrainingRoleGroupInfo entity)
        {
            var dto = MapToEntityDto(entity);
            var roles = GrrRepository.GetAllIncluding(a => a.TrainingRoleInfo).Where(a => a.RoleGroupNo == entity.Id);
            dto.RoleNos = roles.Select(a => a.TrainRoleNo).ToList();
            dto.RoleNames = string.Join(",", roles.Select(a => a.TrainingRoleInfo.RoleName).ToArray());
            return dto;
        }

        #region GetEntity/Dto

        /// <summary>
        ///  查询实体Dto
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgQuery)]
        public override async Task<TrainingRoleGroupDto> GetDto(EntityDto<string> input)
        {
            var entity = await GetEntity(input);
            return MapToEntityDto(entity);
        }

        /// <summary>
        ///  查询实体Dto
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgQuery)]
        public override async Task<TrainingRoleGroupDto> GetDtoById(string id)
        {
            var entity = await GetEntityById(id);
            return MapToEntityDto(entity);
        }

        /// <summary>
        /// 查询实体Dto（需指明自定义字段）
        /// </summary>
        /// <param name="no"></param>
        /// <returns></returns>
        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgQuery)]
        public override async Task<TrainingRoleGroupDto> GetDtoByNo(string no)
        {
            var entity = await GetEntityByNo(no);
            return MapToEntityDto(entity);
        }

        /// <summary>
        /// 查询实体
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgQuery)]
        public override async Task<TrainingRoleGroupInfo> GetEntity(EntityDto<string> input)
        {
            var entity = await GetEntityById(input.Id);
            return entity;
        }

        /// <summary>
        /// 查询实体
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgQuery)]
        public override async Task<TrainingRoleGroupInfo> GetEntityById(string id)
        {
            return await Repository.FirstOrDefaultAsync(a => a.Id == id);
        }

        /// <summary>
        /// 查询实体（需指明自定义字段）
        /// </summary>
        /// <param name="no"></param>
        /// <returns></returns>
        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgQuery)]
        public override async Task<TrainingRoleGroupInfo> GetEntityByNo(string no)
        {
            //CheckGetPermission();
            if (string.IsNullOrEmpty(KeyFiledName))
            {
                ThrowError("NoKeyFieldName");
            }
            return await base.GetEntityByNo(no);
        }

        #endregion GetEntity/Dto

        #region Hide

        ///// <summary>
        ///// 根据给定的<see cref="IwbPagedRequestDto"/>创建 <see cref="IQueryable{TrainingRoleGroupInfo}"/>过滤查询.
        ///// </summary>
        ///// <param name="input">The input.</param>
        //protected override IQueryable<TrainingRoleGroupInfo> CreateFilteredQuery(IwbPagedRequestDto input)
        //{
        //    var query = Repository.GetAll();
        //    var pagedInput = input as IIwbPagedRequest;
        //    if (pagedInput == null)
        //    {
        //        return query;
        //    }
        //    if (!string.IsNullOrEmpty(pagedInput.KeyWords))
        //    {
        //        object keyWords = pagedInput.KeyWords;
        //        LambdaObject obj = new LambdaObject()
        //        {
        //            FieldType = (LambdaFieldType)pagedInput.FieldType,
        //            FieldName = pagedInput.KeyField,
        //            FieldValue = keyWords,
        //            ExpType = (LambdaExpType)pagedInput.ExpType
        //        };
        //        var exp = obj.GetExp<TrainingRoleGroupInfo>();
        //        query = exp != null ? query.Where(exp) : query;
        //    }
        //    if (pagedInput.SearchList != null && pagedInput.SearchList.Count > 0)
        //    {
        //        List<LambdaObject> objList = new List<LambdaObject>();
        //       foreach (var o in pagedInput.SearchList)
        //        {
        //            if (string.IsNullOrEmpty(o.KeyWords))
        //                continue;
        //           object keyWords = o.KeyWords;
        //            objList.Add(new LambdaObject
        //            {
        //                FieldType = (LambdaFieldType)o.FieldType,
        //                FieldName = o.KeyField,
        //                FieldValue = keyWords,
        //                ExpType = (LambdaExpType)o.ExpType
        //            });
        //        }
        //        var exp = objList.GetExp<TrainingRoleGroupInfo>();
        //        query = exp != null ? query.Where(exp) : query;
        //    }
        //    return query;
        //}

        //protected override IQueryable<TrainingRoleGroupInfo> ApplySorting(IQueryable<TrainingRoleGroupInfo> query, IwbPagedRequestDto input)
        //{
        //    return query.OrderBy(a => a.No);
        //}

        //protected override IQueryable<TrainingRoleGroupInfo> ApplyPaging(IQueryable<TrainingRoleGroupInfo> query, IwbPagedRequestDto input)
        //{
        //    if (input is IPagedResultRequest pagedInput)
        //    {
        //        return query.Skip(pagedInput.SkipCount).Take(pagedInput.MaxResultCount);
        //    }
        //    return query;
        //}

        #endregion Hide

        #endregion CURD

        /// <summary>
        /// 获取全部的演练角色
        /// </summary>
        /// <returns></returns>
        [AbpAuthorize(PermissionNames.PagesBasicMgGroupRoleMgQuery), DisableAuditing]
        public async Task<List<TrainingRoleDto>> GetAllRoles()
        {
            var entities = await RoleRepository.GetAllListAsync();
            return entities.Select(ObjectMapper.Map<TrainingRoleDto>).ToList();
        }
    }
}