WEP_V2.1.3/SourceCode/We.Platform/WePlatform.Application/WeLib/Knowledge/KnowledgeApplicationService.cs

using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Threading.Tasks;
using System.Web.Mvc;
using Abp.Application.Services.Dto;
using Abp.Auditing;
using Abp.Authorization;
using Abp.Domain.Repositories;
using Abp.Runtime.Caching;
using IwbZero.Auditing;
using IwbZero.AppServiceBase;
using IwbZero.ToolCommon.Lambda;
using IwbZero.ToolCommon.StringModel;
using WePlatform.Authorization;
using WePlatform.WeLib.Knowledge.Dto;
namespace WePlatform.WeLib.Knowledge
{
    [AbpAuthorize, AuditLog("知识信息引导库管理")]
    public class KnowledgeAppService : IwbAsyncCrudAppService<KnowledgeInfo, KnowledgeDto, string, IwbPagedRequestDto, KnowledgeCreateDto, KnowledgeUpdateDto >, IKnowledgeAppService
    {
        public KnowledgeAppService(
			ICacheManager cacheManager,
			IRepository<KnowledgeInfo, string> repository, IRepository<KnowledgeRelatePlanInfo> krpRepository) : base(repository, "Id")
        {
            KrpRepository = krpRepository;
            CacheManager = cacheManager;
        }

        protected override bool KeyIsAuto { get; set; } = false;
        protected IRepository<KnowledgeRelatePlanInfo> KrpRepository { get; } 

        #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. });
            }
            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.}</option>";
            }
            return str;
        }

        #endregion

        #region CURD

        [AbpAuthorize(PermissionNames.PagesResourceMgGuideMgKnowledgeMgCreate)]
        public override async Task Create(KnowledgeCreateDto input)
        {
            input.Id = await AppGuidManager.GetNextRecordIdAsync(DataLibType.KnowledgeInfo);
            //添加预案信息
            if (input.Plans != null && input.Plans.Any())
            {
                foreach (var no in input.Plans)
                {
                    if (no.IsEmpty())
                    {
                        continue;
                    }
                    await KrpRepository.InsertAsync(new KnowledgeRelatePlanInfo()
                    {
                        KnowledgeNo = input.Id,
                        PlanNo = no
                    });
                }
            }
            await CreateEntity(input);
        }

        [AbpAuthorize(PermissionNames.PagesResourceMgGuideMgKnowledgeMgUpdate)]
        public override async Task Update(KnowledgeUpdateDto input)
        {
           var dto = await UpdateEntity(input);
            //更新行为预案
            {
                var relateNos = await KrpRepository.GetAll().Where(a => a.KnowledgeNo == dto.Id).Select(a => a.PlanNo).ToListAsync();
                if (input.Plans != null && input.Plans.Any())
                {
                    foreach (var no in input.Plans)
                    {
                        if (no.IsEmpty())
                        {
                            continue;
                        }
                        if (!relateNos.Contains(no))
                        {
                            //新增原集合中不存在的预案
                            await KrpRepository.InsertAsync(new KnowledgeRelatePlanInfo()
                            {
                                KnowledgeNo = input.Id,
                                PlanNo = no
                            });
                        }
                        else
                        {
                            //移除原集合中已存在的预案（剩余不在新增集合中的需删除）
                            relateNos.Remove(no);
                        }
                    }
                }
                if (relateNos.Any())
                {
                    //删除多余的预案
                    await KrpRepository.DeleteAsync(a => a.KnowledgeNo == dto.Id && relateNos.Contains(a.PlanNo));
                   
                }
            }
        }

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

        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesResourceMgGuideMgKnowledgeMgQuery)]
        public override async Task<PagedResultDto<KnowledgeDto>> 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<KnowledgeDto>(totalCount, entities.Select(MapToEntityDto).ToList());
            return dtoList;
        }

        protected override KnowledgeDto MapToEntityDto(KnowledgeInfo entity)
        {
            var dto = base.MapToEntityDto(entity);
            var plans= KrpRepository.GetAll().Where(a => a.KnowledgeNo == dto.Id).Select(a => a.PlanNo).ToList();
            dto.Plans = plans;
            return dto;

        }

        #region GetEntity/Dto

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

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

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

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

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

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

        #endregion

		#region Hide
       
		///// <summary>
        ///// 根据给定的<see cref="IwbPagedRequestDto"/>创建 <see cref="IQueryable{KnowledgeInfo}"/>过滤查询.
        ///// </summary>
        ///// <param name="input">The input.</param>
        //protected override IQueryable<KnowledgeInfo> 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<KnowledgeInfo>();
        //        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<KnowledgeInfo>();
        //        query = exp != null ? query.Where(exp) : query;
        //    }
        //    return query;
        //}



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

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

        #endregion

        #endregion

    }
}