App_V2.3/SourceCode/WeApp.Application/TrainingCampGroup/CampGroupApplicationService.cs

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

using IwbZero.AppServiceBase;
using IwbZero.Auditing;
using IwbZero.ToolCommon.StringModel;

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

using WeApp.Authorization;
using WeApp.Configuration;
using WeApp.TrainingCamp;
using WeApp.TrainingCampGroup.Dto;

namespace WeApp.TrainingCampGroup
{
    [AbpAuthorize, AuditLog("培训营分组维护")]
    public class CampGroupAppService : IwbAsyncCrudAppService<CampGroupInfo, CampGroupDto, string, IwbPagedRequestDto, CampGroupCreateDto, CampGroupUpdateDto>, ICampGroupAppService
    {
        public CampGroupAppService(
            ICacheManager cacheManager,
            IRepository<CampGroupInfo, string> repository, IRepository<CampInfo, string> campRepository) : base(repository, "Id")
        {
            CampRepository = campRepository;
            CacheManager = cacheManager;
        }

        protected IRepository<CampInfo, string> CampRepository { 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. });
            }
            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 GetSelect

        #region CURD

        [AbpAuthorize(PermissionNames.PagesTrainMgGroupMgCreate)]
        public override async Task Create(CampGroupCreateDto input)
        {
            var camp = await CampRepository.FirstOrDefaultAsync(a => a.Id == input.CampNo);
            if (camp.CampState != CampStateDefinition.New && camp.CampState != CampStateDefinition.Audit)
            {
                CheckErrors("培训营已运行(或结束)，不能再操作！");
            }
            input.Id = await GetGroupNo(input.CampNo);
            input.CampGroupState = CampGroupStateDefinition.New;
            await CreateEntity(input);
        }

        [AbpAuthorize(PermissionNames.PagesTrainMgGroupMgUpdate)]
        public override async Task Update(CampGroupUpdateDto input)
        {
            var camp = await CampRepository.FirstOrDefaultAsync(a => a.Id == input.CampNo);
            if (camp.CampState != CampStateDefinition.New && camp.CampState != CampStateDefinition.Audit)
            {
                CheckErrors("培训营已运行(或结束)，不能再操作！");
            }
            var entity = await Repository.FirstOrDefaultAsync(a => a.Id == input.Id);
            if (entity == null)
            {
                CheckErrors($"未查询编号为【{input.Id}】到分组！");
                return;
            }

            if (entity.CampGroupState != CampGroupStateDefinition.New)
            {
                CheckErrors($"新建状态的培训营才能修改！");
            }
            await UpdateEntity(input);
        }

        [AbpAuthorize(PermissionNames.PagesTrainMgGroupMgDelete)]
        public override async Task Delete(EntityDto<string> input)
        {
            var entity = await Repository.FirstOrDefaultAsync(a => a.Id == input.Id);
            if (entity == null)
            {
                CheckErrors($"未查询编号为【{input.Id}】到分组！");
                return;
            }

            if (entity.CampGroupState != CampGroupStateDefinition.New)
            {
                CheckErrors($"新建状态的培训营才能删除！");
            }

            await base.Delete(input);
        }

        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesTrainMgGroupMgQuery)]
        public override async Task<PagedResultDto<CampGroupDto>> GetAll(IwbPagedRequestDto input)
        {
            var query = Repository.GetAllIncluding(a => a.CampInfo);
            query = ApplyFilter(query, input);
            var totalCount = await AsyncQueryableExecuter.CountAsync(query);
            query = ApplySorting(query, input);
            query = string.IsNullOrEmpty(input.Sorting) ? query.OrderBy(a => a.Id) : ApplyPaging(query, input);
            var entities = await AsyncQueryableExecuter.ToListAsync(query);
            var dtoList = new PagedResultDto<CampGroupDto>(totalCount, entities.Select(MapToEntityDto).ToList());
            return dtoList;
        }

        #region GetEntity/Dto

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

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

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

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

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

        /// <summary>
        /// 查询实体（需指明自定义字段）
        /// </summary>
        /// <param name="no"></param>
        /// <returns></returns>
        [DisableAuditing]
        [AbpAuthorize(PermissionNames.PagesTrainMgGroupMgQuery)]
        public override async Task<CampGroupInfo> 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{CampGroupInfo}"/>过滤查询.
        ///// </summary>
        ///// <param name="input">The input.</param>
        //protected override IQueryable<CampGroupInfo> 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<CampGroupInfo>();
        //        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<CampGroupInfo>();
        //        query = exp != null ? query.Where(exp) : query;
        //    }
        //    return query;
        //}

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

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

        #endregion Hide

        #endregion CURD

        private async Task<string> GetGroupNo(string campNo)
        {
            if (StringExtensions.IsEmpty(campNo))
            {
                CheckErrors("培训营编号不能为空！");
            }
            var no = $"{campNo}_";
            int index = 0;
            using (CurrentUnitOfWork.DisableFilter(AbpDataFilters.SoftDelete))
            {
                var lastEntity = await Repository.GetAll().Where(a => a.CampNo == campNo).OrderByDescending(a => a.Id)
                    .FirstOrDefaultAsync();
                if (lastEntity != null)
                {
                    index = lastEntity.Id.Substring(no.Length).ValI();
                }
            }
            index++;
            return $"{no}{index.LeftPad(3)}";
        }
    }
}