ABP VNext 级联查询

于 2023-05-23 16:27:08 发布
阅读量912 收藏 4
点赞数 2
分类专栏： ABP vNext 文章标签： c# abp vnext
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_37591671/article/details/130829096
版权

ABP VNext 级联查询

1.Domain层新建实体

SiteInspectPlan 包含多个SiteInspectRoute ，SiteInspectRoute 包含多个SiteInspectRouteItem

 public class SiteInspectPlan : AuditedAggregateRoot<Guid>
    {
        private SiteInspectPlan()
        {
            SiteInspectRoutes = new List<SiteInspectRoute>();
        }


        public SiteInspectPlan(
            Guid id,
            string planCode,
            string planName,
            int category,
            string planSummary,
            Guid teamId,
            string teamName,
            int? repeatMode,
            DateTime startTime,
            DateTime? endTime,
            string cycleTag,
            string cycleCron,
            int? warnMode,
            int warnTime,
            int planStatus,
            string description,
            bool isPublic,
            int status,
            string creator,
            string modifier
        ) : base(id)
        {
            SetPlanCode(planCode);
            SetPlanName(planName);
            SetCategory(category);
            SetPlanSummary(planSummary);
            SetTeamId(teamId);
            SetTeamName(teamName);
            SetRepeatMode(repeatMode);
            SetStartTime(startTime);
            SetEndTime(endTime);
            SetCycleTag(cycleTag);
            SetCycleCron(cycleCron);
            SetWarnMode(warnMode);
            SetWarnTime(warnTime);
            SetPlanStatus(planStatus);
            SetDescription(description);
            SetIsPublic(isPublic);
            SetStatus(status);
            SetCreator(creator);
            SetModifier(modifier);
            SiteInspectRoutes = new List<SiteInspectRoute>();
        }

        /// <summary>
        /// 计划流水号
        /// </summary>
        public string PlanCode { get; private set; }
        /// <summary>
        /// 计划名称
        /// </summary>
        public string PlanName { get; private set; }
        /// <summary>
        /// 计划类型 <1=巡检，2=点检>
        /// </summary>
        public int Category { get; private set; }
        /// <summary>
        /// 方案说明
        /// </summary>
        public string PlanSummary { get; private set; }
        /// <summary>
        /// 执行班组
        /// </summary>
        public Guid TeamId { get; private set; }
        /// <summary>
        /// 执行班组名称
        /// </summary>
        public string TeamName { get; private set; }
        /// <summary>
        /// 循环方式
        /// </summary>
        public int? RepeatMode { get; private set; }
        /// <summary>
        /// 方案起始时间
        /// </summary>
        public DateTime StartTime { get; private set; }
        /// <summary>
        /// 方案截止时间
        /// </summary>
        public DateTime? EndTime { get; private set; }
        /// <summary>
        /// 保养周期
        /// </summary>
        public string CycleTag { get; private set; }
        /// <summary>
        /// 保养周期表达式
        /// </summary>
        public string CycleCron { get; private set; }
        /// <summary>
        /// 预警方式
        /// </summary>
        public int? WarnMode { get; private set; }
        /// <summary>
        /// 提前预警时间 默认=1
        /// </summary>
        public int WarnTime { get; private set; }
        /// <summary>
        /// 计划状态
        /// </summary>
        public int PlanStatus { get; private set; }
        /// <summary>
        /// 描述
        /// </summary>
        public string Description { get; private set; }
        /// <summary>
        /// 发布
        /// </summary>
        public bool IsPublic { get; private set; }
        /// <summary>
        /// 状态
        /// </summary>
        public int Status { get; private set; }
        /// <summary>
        /// 创建人
        /// </summary>
        public string Creator { get; private set; }
        /// <summary>
        /// 修改人
        /// </summary>
        public string Modifier { get; private set; }

        public List<SiteInspectRoute> SiteInspectRoutes { get; set; }

        /// <summary>
        /// 设置计划流水号
        /// </summary>        
        private void SetPlanCode(string planCode)
        {
            Check.NotNullOrWhiteSpace(planCode, nameof(planCode), 64, 0);
            PlanCode = planCode;
        }

        /// <summary>
        /// 设置计划名称
        /// </summary>        
        private void SetPlanName(string planName)
        {
            Check.NotNullOrWhiteSpace(planName, nameof(planName), 128, 0);
            PlanName = planName;
        }

        /// <summary>
        /// 设置计划类型 <1=巡检，2=点检>
        /// </summary>        
        private void SetCategory(int category)
        {
            Category = category;
        }

        /// <summary>
        /// 设置方案说明
        /// </summary>        
        private void SetPlanSummary(string planSummary)
        {
            Check.Length(planSummary, nameof(planSummary), 512, 0);
            PlanSummary = planSummary;
        }

        /// <summary>
        /// 设置执行班组
        /// </summary>        
        private void SetTeamId(Guid teamId)
        {
            TeamId = teamId;
        }

        /// <summary>
        /// 设置执行班组名称
        /// </summary>        
        private void SetTeamName(string teamName)
        {
            Check.NotNullOrWhiteSpace(teamName, nameof(teamName), 64, 0);
            TeamName = teamName;
        }

        /// <summary>
        /// 设置循环方式
        /// </summary>        
        private void SetRepeatMode(int? repeatMode)
        {
            RepeatMode = repeatMode;
        }

        /// <summary>
        /// 设置方案起始时间
        /// </summary>        
        private void SetStartTime(DateTime startTime)
        {
            StartTime = startTime;
        }

        /// <summary>
        /// 设置方案截止时间
        /// </summary>        
        private void SetEndTime(DateTime? endTime)
        {
            EndTime = endTime;
        }

        /// <summary>
        /// 设置保养周期
        /// </summary>        
        private void SetCycleTag(string cycleTag)
        {
            Check.Length(cycleTag, nameof(cycleTag), 128, 0);
            CycleTag = cycleTag;
        }

        /// <summary>
        /// 设置保养周期表达式
        /// </summary>        
        private void SetCycleCron(string cycleCron)
        {
            Check.Length(cycleCron, nameof(cycleCron), 64, 0);
            CycleCron = cycleCron;
        }

        /// <summary>
        /// 设置预警方式
        /// </summary>        
        private void SetWarnMode(int? warnMode)
        {
            WarnMode = warnMode;
        }

        /// <summary>
        /// 设置提前预警时间 默认=1
        /// </summary>        
        private void SetWarnTime(int warnTime)
        {
            WarnTime = warnTime;
        }

        /// <summary>
        /// 设置计划状态
        /// </summary>        
        private void SetPlanStatus(int planStatus)
        {
            PlanStatus = planStatus;
        }

        /// <summary>
        /// 设置描述
        /// </summary>        
        private void SetDescription(string description)
        {
            Check.Length(description, nameof(description), 512, 0);
            Description = description;
        }

        /// <summary>
        /// 设置发布
        /// </summary>        
        public  void SetIsPublic(bool isPublic)
        {
            IsPublic = isPublic;
        }

        /// <summary>
        /// 设置状态
        /// </summary>        
        private void SetStatus(int status)
        {
            Status = status;
        }

        /// <summary>
        /// 设置创建人
        /// </summary>        
        private void SetCreator(string creator)
        {
            Check.NotNullOrWhiteSpace(creator, nameof(creator), 64, 0);
            Creator = creator;
        }

        /// <summary>
        /// 设置修改人
        /// </summary>        
        private void SetModifier(string modifier)
        {
            Check.Length(modifier, nameof(modifier), 64, 0);
            Modifier = modifier;
        }

        /// <summary>
        /// 更新巡检计划
        /// </summary> 
        public void Update(
            string planCode,
            string planName,
            int category,
            string planSummary,
            Guid teamId,
            string teamName,
            int? repeatMode,
            DateTime startTime,
            DateTime? endTime,
            string cycleTag,
            string cycleCron,
            int? warnMode,
            int warnTime,
            int planStatus,
            string description,
            bool isPublic,
            int status,
            string creator,
            string modifier
        )
        {
            SetPlanCode(planCode);
            SetPlanName(planName);
            SetCategory(category);
            SetPlanSummary(planSummary);
            SetTeamId(teamId);
            SetTeamName(teamName);
            SetRepeatMode(repeatMode);
            SetStartTime(startTime);
            SetEndTime(endTime);
            SetCycleTag(cycleTag);
            SetCycleCron(cycleCron);
            SetWarnMode(warnMode);
            SetWarnTime(warnTime);
            SetPlanStatus(planStatus);
            SetDescription(description);
            SetIsPublic(isPublic);
            SetStatus(status);
            SetCreator(creator);
            SetModifier(modifier);
        }
    }


 public class SiteInspectRoute : AuditedAggregateRoot<Guid>
    {
        private SiteInspectRoute()
        {
            SiteInspectRouteItems=new List<SiteInspectRouteItem>();
        }


        public SiteInspectRoute(
            Guid id,
            Guid planId,
            Guid equipAssetId,
            int routeNum,
            string description,
            int status,
            string creator,
            string modifier
        ) : base(id)
        {
            SetPlanId(planId);
            SetEquipAssetId(equipAssetId);
            SetRouteNum(routeNum);
            SetDescription(description);
            SetStatus(status);
            SetCreator(creator);
            SetModifier(modifier);
            SiteInspectRouteItems = new List<SiteInspectRouteItem>();
        }

        /// <summary>
        /// 方案外键
        /// </summary>
        public Guid PlanId { get; private set; }
        /// <summary>
        /// 设备外键
        /// </summary>
        public Guid EquipAssetId { get; private set; }
        /// <summary>
        /// 路线序号
        /// </summary>
        public int RouteNum { get; private set; }
        /// <summary>
        /// 描述
        /// </summary>
        public string Description { get; private set; }
        /// <summary>
        /// 状态
        /// </summary>
        public int Status { get; private set; }
        /// <summary>
        /// 创建人
        /// </summary>
        public string Creator { get; private set; }
        /// <summary>
        /// 修改人
        /// </summary>
        public string Modifier { get; private set; }


        public List<SiteInspectRouteItem> SiteInspectRouteItems { get; set; }
        /// <summary>
        /// 设置方案外键
        /// </summary>        
        private void SetPlanId(Guid planId)
        {
            PlanId = planId;
        }

        /// <summary>
        /// 设置设备外键
        /// </summary>        
        private void SetEquipAssetId(Guid equipAssetId)
        {
            EquipAssetId = equipAssetId;
        }

        /// <summary>
        /// 设置路线序号
        /// </summary>        
        private void SetRouteNum(int routeNum)
        {
            RouteNum = routeNum;
        }

        /// <summary>
        /// 设置描述
        /// </summary>        
        private void SetDescription(string description)
        {
            Check.Length(description, nameof(description), 512, 0);
            Description = description;
        }

        /// <summary>
        /// 设置状态
        /// </summary>        
        private void SetStatus(int status)
        {
            Status = status;
        }

        /// <summary>
        /// 设置创建人
        /// </summary>        
        private void SetCreator(string creator)
        {
            Check.NotNullOrWhiteSpace(creator, nameof(creator),  64, 0);
            Creator = creator;
        }

        /// <summary>
        /// 设置修改人
        /// </summary>        
        private void SetModifier(string modifier)
        {
            Check.Length(modifier, nameof(modifier), 64, 0);
            Modifier = modifier;
        }

        /// <summary>
        /// 更新巡检路线
        /// </summary> 
        public void Update(
            Guid planId,
            Guid equipAssetId,
            int routeNum,
            string description,
            int status,
            string creator,
            string modifier
        )
        {
            SetPlanId(planId);
            SetEquipAssetId(equipAssetId);
            SetRouteNum(routeNum);
            SetDescription(description);
            SetStatus(status);
            SetCreator(creator);
            SetModifier(modifier);
        }
    }
public class SiteInspectRouteItem : AuditedAggregateRoot<Guid>
    {
        private SiteInspectRouteItem()
        {
        }


        public SiteInspectRouteItem(
            Guid id,
            Guid routeId,
            int itemIndex,
            string itemName,
            string groupCode,
            string groupName,
            string itemContent,
            string attachFile,
            string description,
            int status,
            string creator,
            string modifier
        ) : base(id)
        {
            SetRouteId(routeId);
            SetItemIndex(itemIndex);
            SetItemName(itemName);
            SetGroupCode(groupCode);
            SetGroupName(groupName);
            SetItemContent(itemContent);
            SetAttachFile(attachFile);
            SetDescription(description);
            SetStatus(status);
            SetCreator(creator);
            SetModifier(modifier);
        }

        /// <summary>
        /// 路线外键
        /// </summary>
        public Guid RouteId { get; private set; }
        /// <summary>
        /// 行号
        /// </summary>
        public int ItemIndex { get; private set; }
        /// <summary>
        /// 项目名称
        /// </summary>
        public string ItemName { get; private set; }
        /// <summary>
        /// 分组编码
        /// </summary>
        public string GroupCode { get; private set; }
        /// <summary>
        /// 分组名称
        /// </summary>
        public string GroupName { get; private set; }
        /// <summary>
        /// 巡检内容
        /// </summary>
        public string ItemContent { get; private set; }
        /// <summary>
        /// 附件
        /// </summary>
        public string AttachFile { get; private set; }
        /// <summary>
        /// 描述
        /// </summary>
        public string Description { get; private set; }
        /// <summary>
        /// 状态
        /// </summary>
        public int Status { get; private set; }
        /// <summary>
        /// 创建人
        /// </summary>
        public string Creator { get; private set; }
        /// <summary>
        /// 修改人
        /// </summary>
        public string Modifier { get; private set; }



        /// <summary>
        /// 设置路线外键
        /// </summary>        
        private void SetRouteId(Guid routeId)
        {
            RouteId = routeId;
        }

        /// <summary>
        /// 设置行号
        /// </summary>        
        private void SetItemIndex(int itemIndex)
        {
            ItemIndex = itemIndex;
        }

        /// <summary>
        /// 设置项目名称
        /// </summary>        
        private void SetItemName(string itemName)
        {
            Check.NotNullOrWhiteSpace(itemName, nameof(itemName),  512, 0);
            ItemName = itemName;
        }

        /// <summary>
        /// 设置分组编码
        /// </summary>        
        private void SetGroupCode(string groupCode)
        {
            Check.NotNullOrWhiteSpace(groupCode, nameof(groupCode), 64, 0);
            GroupCode = groupCode;
        }

        /// <summary>
        /// 设置分组名称
        /// </summary>        
        private void SetGroupName(string groupName)
        {
            Check.NotNullOrWhiteSpace(groupName, nameof(groupName),  256, 0);
            GroupName = groupName;
        }

        /// <summary>
        /// 设置巡检内容
        /// </summary>        
        private void SetItemContent(string itemContent)
        {
            Check.Length(itemContent, nameof(itemContent), 2048, 0);
            ItemContent = itemContent;
        }

        /// <summary>
        /// 设置附件
        /// </summary>        
        private void SetAttachFile(string attachFile)
        {
            Check.Length(attachFile, nameof(attachFile), 1024, 0);
            AttachFile = attachFile;
        }

        /// <summary>
        /// 设置描述
        /// </summary>        
        private void SetDescription(string description)
        {
            Check.Length(description, nameof(description), 512, 0);
            Description = description;
        }

        /// <summary>
        /// 设置状态
        /// </summary>        
        private void SetStatus(int status)
        {
            Status = status;
        }

        /// <summary>
        /// 设置创建人
        /// </summary>        
        private void SetCreator(string creator)
        {
            Check.NotNullOrWhiteSpace(creator, nameof(creator), 64, 0);
            Creator = creator;
        }

        /// <summary>
        /// 设置修改人
        /// </summary>        
        private void SetModifier(string modifier)
        {
            Check.Length(modifier, nameof(modifier), 64, 0);
            Modifier = modifier;
        }

        /// <summary>
        /// 更新巡检路线项目列表
        /// </summary> 
        public void Update(
            Guid routeId,
            int itemIndex,
            string itemName,
            string groupCode,
            string groupName,
            string itemContent,
            string attachFile,
            string description,
            int status,
            string creator,
            string modifier
        )
        {
            SetRouteId(routeId);
            SetItemIndex(itemIndex);
            SetItemName(itemName);
            SetGroupCode(groupCode);
            SetGroupName(groupName);
            SetItemContent(itemContent);
            SetAttachFile(attachFile);
            SetDescription(description);
            SetStatus(status);
            SetCreator(creator);
            SetModifier(modifier);
        }
    }

2.EntityFrameworkCore层

2.1 DbContext

  public DbSet<SiteInspectPlan> SiteInspectPlans { get; set; }

2.2 IDbContext

  DbSet<SiteInspectPlan> SiteInspectPlans { get; set; }

2.3 DbContextModelCreatingExtensions

     builder.Entity<SiteInspectPlan>(b =>
            {
                b.ToTable(EquipDbProperties.DbTableV2Prefix + typeof(SiteInspectPlan).Pluralize(), EquipDbProperties.DbSchema);
                b.Property(e => e.PlanCode).IsRequired().HasMaxLength(64).HasComment("计划流水号");
                b.Property(e => e.PlanName).IsRequired().HasMaxLength(128).HasComment("计划名称");
                b.Property(e => e.Category).HasComment("计划类型 <1=巡检，2=点检>");
                b.Property(e => e.PlanSummary).HasComment("方案说明");
                b.Property(e => e.TeamId).HasComment("执行班组");
                b.Property(e => e.TeamName).IsRequired().HasMaxLength(64).HasComment("执行班组名称");
                b.Property(e => e.RepeatMode).HasComment("循环方式");
                b.Property(e => e.StartTime).HasComment("方案起始时间");
                b.Property(e => e.EndTime).HasComment("方案截止时间");
                b.Property(e => e.CycleTag).HasComment("保养周期");
                b.Property(e => e.CycleCron).HasComment("保养周期表达式");
                b.Property(e => e.WarnMode).HasComment("预警方式");
                b.Property(e => e.WarnTime).HasComment("提前预警时间 默认=1");
                b.Property(e => e.PlanStatus).HasComment("计划状态");
                b.Property(e => e.Description).HasComment("描述");
                b.Property(e => e.IsPublic).HasComment("发布");
                b.Property(e => e.Status).HasComment("状态");
                b.Property(e => e.Creator).IsRequired().HasMaxLength(64).HasComment("创建人");
                b.Property(e => e.Modifier).HasComment("修改人");
                b.HasMany(e => e.SiteInspectRoutes).WithOne().HasForeignKey(ur => ur.PlanId).HasPrincipalKey(u => u.Id).IsRequired();
                b.ConfigureByConvention();
            });
            builder.Entity<SiteInspectRoute>(b =>
            {
                b.ToTable(EquipDbProperties.DbTableV2Prefix + typeof(SiteInspectRoute).Pluralize(), EquipDbProperties.DbSchema);
                b.Property(e => e.PlanId).HasComment("方案外键");
                b.Property(e => e.EquipAssetId).HasComment("设备外键");
                b.Property(e => e.RouteNum).HasComment("路线序号");
                b.Property(e => e.Description).HasComment("描述");
                b.Property(e => e.Status).HasComment("状态");
                b.Property(e => e.Creator).IsRequired().HasMaxLength(64).HasComment("创建人");
                b.Property(e => e.Modifier).HasComment("修改人");
                b.HasMany(e => e.SiteInspectRouteItems).WithOne().HasForeignKey(ur => ur.RouteId).HasPrincipalKey(u => u.Id).IsRequired();
                b.ConfigureByConvention();
            });
            builder.Entity<SiteInspectRouteItem>(b =>
            {
                b.ToTable(EquipDbProperties.DbTableV2Prefix + typeof(SiteInspectRouteItem).Pluralize(), EquipDbProperties.DbSchema);
                b.Property(e => e.RouteId).HasComment("路线外键");
                b.Property(e => e.ItemIndex).HasComment("行号");
                b.Property(e => e.ItemName).IsRequired().HasMaxLength(512).HasComment("项目名称");
                b.Property(e => e.GroupCode).IsRequired().HasMaxLength(64).HasComment("分组编码");
                b.Property(e => e.GroupName).IsRequired().HasMaxLength(256).HasComment("分组名称");
                b.Property(e => e.ItemContent).HasComment("巡检内容");
                b.Property(e => e.AttachFile).HasComment("附件");
                b.Property(e => e.Description).HasComment("描述");
                b.Property(e => e.Status).HasComment("状态");
                b.Property(e => e.Creator).IsRequired().HasMaxLength(64).HasComment("创建人");
                b.Property(e => e.Modifier).HasComment("修改人");
                b.ConfigureByConvention();
            });

2.4 EntityFrameworkCoreModule

  //默认的级联查询配置
        Configure<AbpEntityOptions>(options =>
        {
            options.Entity<SiteInspectPlan>(DemandOrderOptions =>
            {
                DemandOrderOptions.DefaultWithDetailsFunc = query => query.Include(o => o.SiteInspectRoutes).ThenInclude(s=>s.SiteInspectRouteItems);
            });
        });

3.Application服务层

如果SiteInspectPlan下面只有平级的SiteInspectRoutes，SiteInspectRouteItem的集合，那么不需要在EntityFrameworkCoreModule配置级联查询，只需要像下面调用
eg：

==如果SiteInspectRoutes和SiteInspectRouteItem都是SiteInspectPlan的子集合==
siteInspectPlanRepository.WithDetailsAsync(s => s.SiteInspectRoutes, s => s.SiteInspectRouteItem)

 public class SiteInspectPlanService : EquipAppService, ISiteInspectPlanService
    {
        private readonly IRepository<SiteInspectPlan, Guid> _siteInspectPlanRepository;

        public SiteInspectPlanService(IRepository<SiteInspectPlan, Guid> siteInspectPlanRepository)
        {
            _siteInspectPlanRepository = siteInspectPlanRepository;
        }


        /// <summary>
        /// 查询单条
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public async Task<SiteInspectPlanInfoRes> GetAsync(Guid id)
        {
            var siteInspectPlan = (await _siteInspectPlanRepository.WithDetailsAsync()).FirstOrDefault(s=>s.Id==id) ?? throw new UserFriendlyException("巡检计划不存在!");
            return ObjectMapper.Map<SiteInspectPlan, SiteInspectPlanInfoRes>(siteInspectPlan);
        }


        /// <summary>
        /// 分页查询巡检项目
        /// </summary>
        /// <returns></returns>
        public async Task<SiteInspectPlanRes> GetListAsync(PagingSiteInspectPlanReq input)
        {
            var dyParams = HttpContext.Request.Query.GetDynamicParams();
            var query = (await _siteInspectPlanRepository.WithDetailsAsync()).Where(dyParams.QueryKeys, dyParams.QueryValues.ToArray());
            var queryList = query.Skip(input.SkipCount).Take(input.PageSize).ToList();
            return new SiteInspectPlanRes(query.ToList().Count, ObjectMapper.Map<List<SiteInspectPlan>, List<SiteInspectPlanInfoRes>>(queryList));
        }


        /// <summary>
        /// 创建巡检计划
        /// </summary>
        public async Task CreateAsync(CreateSiteInspectPlanReq input)
        {
            //判断该巡检计划是否重复
            var exist = (await _siteInspectPlanRepository.GetListAsync(s => s.PlanName == input.PlanName)).Any();
            if (exist) throw new UserFriendlyException("该巡检计划已经存在!");
            //巡检计划编码
            string codeName = "SiteInspectPlanCode";
            var planCode = await BillNumberGenerator.GetByNameAsync(codeName);
            var siteInspectPlanExist = await _siteInspectPlanRepository.FindAsync(a => a.PlanCode == planCode);
            if (siteInspectPlanExist is not null) throw new UserFriendlyException("相同编号不能重复添加");

            SiteInspectPlan siteInspectPlan = new (GuidGenerator.Create(), planCode, input.PlanName,input.Category,input.PlanSummary, input.TeamId,input.TeamName,input.RepeatMode,input.StartTime,input.EndTime,input.CycleTag,input.CycleCron,input.WarnMode,input.WarnTime,1,input.Description,false,1, CurrentUser.Name, "");
            foreach (var s in input.SiteInspectRoutes)
            {
                SiteInspectRoute siteInspectRoute = new(GuidGenerator.Create(), siteInspectPlan.Id, s.EquipAssetId, s.RouteNum, s.Description, 1, CurrentUser.Name, "");
                foreach (var item in s.SiteInspectRouteItems)
                {
                    siteInspectRoute.SiteInspectRouteItems.Add(new SiteInspectRouteItem (GuidGenerator.Create(), siteInspectRoute.Id, item.ItemIndex, item.ItemName,item.GroupCode, item.GroupName, item.ItemContent,item.AttachFile,item.Description,1, CurrentUser.Name,""));
                }
                siteInspectPlan.SiteInspectRoutes.Add(siteInspectRoute);
            }
            await _siteInspectPlanRepository.InsertAsync(siteInspectPlan);
        }

        /// <summary>
        /// 编辑巡检计划
        /// </summary>
        public async Task UpdateAsync(UpdateSiteInspectPlanReq input)
        {
            var siteInspectPlan = (await _siteInspectPlanRepository.WithDetailsAsync(s => s.SiteInspectRoutes)).FirstOrDefault(s=>s.Id==input.Id) ?? throw new UserFriendlyException("巡检计划不存在!");
            siteInspectPlan.SiteInspectRoutes.Clear();
            foreach (var s in input.SiteInspectRoutes)
            {
                SiteInspectRoute siteInspectRoute = new(GuidGenerator.Create(), siteInspectPlan.Id, s.EquipAssetId, s.RouteNum, s.Description, 1, CurrentUser.Name, "");
                foreach (var item in s.SiteInspectRouteItems)
                {
                    siteInspectRoute.SiteInspectRouteItems.Add(new SiteInspectRouteItem(GuidGenerator.Create(), siteInspectRoute.Id, item.ItemIndex, item.ItemName, item.GroupCode, item.GroupName, item.ItemContent, item.AttachFile, item.Description, 1, CurrentUser.Name, ""));
                }
                siteInspectPlan.SiteInspectRoutes.Add(siteInspectRoute);
            }
            await _siteInspectPlanRepository.UpdateAsync(siteInspectPlan);
        }

    }

3.1 ApplicationAutoMapperProfile

   CreateMap<SiteInspectPlan, SiteInspectPlanInfoRes>();
   CreateMap<SiteInspectRoute, SiteInspectRouteInfoRes>();
   CreateMap<SiteInspectRouteItem, SiteInspectRouteItemInfoRes>();

4.Application.Contracts层

public class SiteInspectPlanRes
    {
        public int TotalNumber { get; set; }

        public IEnumerable<SiteInspectPlanInfoRes> Rows { get; set; }

        public SiteInspectPlanRes(int totalNumber, List<SiteInspectPlanInfoRes> repairJobs)
        {
            this.TotalNumber = totalNumber;
            this.Rows = repairJobs;
        }
    }

    public class SiteInspectPlanInfoRes
    {
        /// <summary>
        /// 主键Id
        /// </summary>
        public Guid Id { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime CreationTime { get; set; }

        /// <summary>
        /// 计划流水号
        /// </summary>
        public string PlanCode { get; set; }
        /// <summary>
        /// 计划名称
        /// </summary>
        public string PlanName { get; set; }
        /// <summary>
        /// 计划类型 (1=巡检，2=点检)
        /// </summary>
        public int Category { get; set; }
        /// <summary>
        /// 方案说明
        /// </summary>
        public string PlanSummary { get; set; }
        /// <summary>
        /// 执行班组
        /// </summary>
        public Guid TeamId { get; set; }
        /// <summary>
        /// 执行班组名称
        /// </summary>
        public string TeamName { get; set; }
        /// <summary>
        /// 循环方式
        /// </summary>
        public int? RepeatMode { get; set; }
        /// <summary>
        /// 方案起始时间
        /// </summary>
        public DateTime StartTime { get; set; }
        /// <summary>
        /// 方案截止时间
        /// </summary>
        public DateTime? EndTime { get; set; }
        /// <summary>
        /// 保养周期
        /// </summary>
        public string CycleTag { get; set; }
        /// <summary>
        /// 保养周期表达式
        /// </summary>
        public string CycleCron { get; set; }
        /// <summary>
        /// 预警方式
        /// </summary>
        public int? WarnMode { get; set; }
        /// <summary>
        /// 提前预警时间 默认=1
        /// </summary>
        public int WarnTime { get; set; }
        /// <summary>
        /// 计划状态
        /// </summary>
        public int PlanStatus { get; set; }
        /// <summary>
        /// 描述
        /// </summary>
        public string Description { get; set; }
        /// <summary>
        /// 发布
        /// </summary>
        public bool IsPublic { get; set; }
        /// <summary>
        /// 状态
        /// </summary>
        public int Status { get; set; }
        /// <summary>
        /// 创建人
        /// </summary>
        public string Creator { get; set; }
        /// <summary>
        /// 修改人
        /// </summary>
        public string Modifier { get; set; }

        public List<SiteInspectRouteInfoRes> SiteInspectRoutes { get; set; }
    }

    public class SiteInspectRouteInfoRes {

        /// <summary>
        /// 主键Id
        /// </summary>
        public Guid Id { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime CreationTime { get; set; }

        /// <summary>
        /// 方案外键
        /// </summary>
        public Guid PlanId { get; set; }
        /// <summary>
        /// 设备外键
        /// </summary>
        public Guid EquipAssetId { get; set; }
        /// <summary>
        /// 路线序号
        /// </summary>
        public int RouteNum { get; set; }
        /// <summary>
        /// 描述
        /// </summary>
        public string Description { get; set; }
        /// <summary>
        /// 状态
        /// </summary>
        public int Status { get; set; }
        /// <summary>
        /// 创建人
        /// </summary>
        public string Creator { get; set; }
        /// <summary>
        /// 修改人
        /// </summary>
        public string Modifier { get; set; }

        public List<SiteInspectRouteItemInfoRes> SiteInspectRouteItems { get; set; }
    }

    public class SiteInspectRouteItemInfoRes
    {
        /// <summary>
        /// 主键Id
        /// </summary>
        public Guid Id { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime CreationTime { get; set; }

        /// <summary>
        /// 路线外键
        /// </summary>
        public Guid RouteId { get; set; }
        /// <summary>
        /// 行号
        /// </summary>
        public int ItemIndex { get; set; }
        /// <summary>
        /// 项目名称
        /// </summary>
        public string ItemName { get; set; }
        /// <summary>
        /// 分组编码
        /// </summary>
        public string GroupCode { get; set; }
        /// <summary>
        /// 分组名称
        /// </summary>
        public string GroupName { get; set; }
        /// <summary>
        /// 巡检内容
        /// </summary>
        public string ItemContent { get; set; }
        /// <summary>
        /// 附件
        /// </summary>
        public string AttachFile { get; set; }
        /// <summary>
        /// 描述
        /// </summary>
        public string Description { get; set; }
        /// <summary>
        /// 状态
        /// </summary>
        public int Status { get; set; }
        /// <summary>
        /// 创建人
        /// </summary>
        public string Creator { get; set; }
        /// <summary>
        /// 修改人
        /// </summary>
        public string Modifier { get; set; }
    }
杰锅就是爱情
关注
  • 2
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
六、Abp Vnext 中Efcore的多模块关联查询
沝林的专栏
12-16 3199
abp框架提供了非常棒的模块开发体验，这些模块是可复用的，并且也适用于开发微服务；既然模块可以独立发布，那么它的数据库配置也是独立的，对于使用efcore的模块，每个模块中都包含一个不同的Dbcontext； 在Efcore中，同一个Dbcontext下，多个实体集合间是可以使用linq进行任意关联查询的，而对于多个不同Dbcontext下的关联查询，即时在同一数据库下，也是不能通过linq查询的。下面通过示例验证以下，框架代码还是使用上一章文件管理模块的代码吧，假设我们需要关联文件模块和Abp内置Abp
ABP-多表连接查询
wangwengrui40的博客
02-18 7834
前言：什么是多表连接查询   一：编写多表查询语句--内连接 对应SQL语句： select * from Person  join Telephone on Person.Id = Telephone.PersonId   第一种方式：LINQ语法 public List&lt;Twotable&gt; GetTwo() { var ...
ABP，一张表的多个外键引用的是同一张表，生成迁移更新数据库提示“可能会导致循环或多重级联路径。请指定 ON DELETE NO ACTION 或 ON UPDATE NO ACTION，或修改其他
菜鸟不被菜
04-10 472
解决办法是： 更改生成迁移文件内，级联更新或删除的配置 table.ForeignKey( name: "FK_PSProcessRelations_Processes_StartProcessID", column: x => x.StartProcessID, principalTable: "Processes
ABP 可能会导致循环或多重级联路径。请指定 ON DELETE NO ACTION 或 ON UPDATE NO ACT
Martin 的博客
12-07 1545
将 FOREIGN KEY 约束 'FK_SubProjects_DataDictionaryItems_SubProjectTypeId' 引入表 'SubProjects' 可能会导致循环或多重级联路径。请指定 ON DELETE NO ACTION 或 ON UPDATE NO ACTION，或修改其他 FOREIGN KEY 约束。
ABP 多模块关联查询、分组统计、列转行、Vue 复合表头动态列
kalvin_y_liu的博客
04-20 1943
ABP 重写主键ID [Column(“你那表的源主键名”)] public override leixing Id{ get; set; } 1.重写ID [Column(“数据库指定的ID”)] [Column(“CarTypeID”)] public override int Id { get; set; } 2.映射中指定 这里用的是AutoMapper 第一个UserID是Dto模型里面的 第二个Id是实体类中我们重写的那个Id 1 var carTypeDtoMapper = mapperCon
ABP vNext 商业版
01-24
ABP，全称为“Application Builder Platform”，是一个开源、模块化、高性能、基于DDD（领域驱动设计）和CQRS（命令查询职责分离）原则的.NET开发框架。它大大简化了.NET应用的构建过程，提供了丰富的功能和最佳实践...
ABP VNext种子数据按顺序生成
05-26
ABP VNext是一款基于.NET Core的开源框架，专为构建企业级应用程序设计。它集成了许多现代开发工具和技术，如Entity Framework Core、Docker、Angular或Blazor等，提供了强大的模块化、分层架构，使得开发过程更加...
ABP VNext 集成JwtBearer（JWT）JwtDemo.Api
07-22
ABP VNext 集成JwtBearer DEMO 简单版本安装依赖包 Microsoft.AspNetCore.Authentication.JwtBearer，亲测可以使用。最后在对应控制器或者方法加上加特性Authorize，然后可以通过postman调用，401即验证成功
Abp.Captcha:基于ABP vNext的人机验证模块
03-27
`Abp.Captcha` 是一个专为 ABP vNext 框架设计的验证码模块，旨在增强应用程序的安全性，防止自动化脚本或恶意机器人进行非法操作。该模块提供了两种不同的验证码类型：滑杆验证和竖锯验证，这两种方式都是为了测试...
HelloAbp:ABP vNext + vue-element-admin入门级项目实战
04-13
HelloAbpABP vNext + vue-element-admin入门级项目实战运行环境：.netcore 3.1、sqlserver、nodejs、npm修改Xhznl.HelloAbp.HttpApi.Host、Xhznl....欢迎关注我的微信公众号：“小黑在哪里” 查看abp vnext相关文章。
AspnetBoilerplate (ABP) Organization Units 组织结构管理
dianjiong1915的博客
12-25 1293
ABP是一个成熟的.NET框架，功能完善。目前由于项目需要正在自学中。 ABP对于组织节点管理这一基本上每个项目都要反复重复开发的内容，进行了自己的实现。 主要包括这些常用功能： 多租户 树结构管理的实体 与用户系统集成的查询 下面我们根据官方文档以及DEMO去学习这个功能。 不过需要注意的是，ABP默认没有提供展示层的实现，这一块就需要自己实现了。 官方文档理解...
ABP基础实践训练，一个简易的博客（增删改查）等功能 一：
Lethe星空的博客
11-27 8871
ABP博客系统，ABP实战训练，ABP基础实践 这里有几个选择，首先我们这次使用的是MVC5.x，然后下面选择经典多页程序，填写项目的名称和验证码，点击下方创建按钮即可！二：初始化你的程序； 1：打开之后能够看到ABP的架构，按我的理解大概就是分这几个层！看看有没有缺少没
多表查询
热门推荐
wmz545546的博客
09-10 1万+
一、介绍 首先先准备表 员工表和部门表 #建表 create table department( id int, name varchar(20) ); create table employee1( id int primary key auto_increment, name varchar(20), sex enum('male','female') not
ABP 多模块关联查询、分组统计、行专列、Vue 复合表头动态列之二 组件间传值
kalvin_y_liu的博客
07-16 495
接上篇， 完成报表统计后，需要再开发出时间控件， 主要用在报表模块统计业务， 选择日期使用场景， 因为几乎所有报表都会用到日期选择，所有直接做成控件方便使用， 这里也会集成单位选择功能， 根据选择的单位权限进行统计。......
EF 联合查询
张峰的博客
11-01 4300
  其实不用include，  var productList = productCategoryMappingRepository.FindQueryable(a =&gt; a.ProductCategoryID == CategoryID).Select(b =&gt; b.Product).ToList();
ABP入门系列（5）——展现层实现增删改查
圣杰
02-07 6481
ABP入门系列目录——学习Abp框架之实操演练 这一章节将通过完善Controller、View、ViewModel，来实现展现层的增删改查。最终实现效果如下图： 一、定义Controller ABP对ASP.NET MVC Controllers进行了集成，通过引入Abp.Web.Mvc命名空间，创建Controller继承自AbpController， 我们即可使用ABP附加给我们的以下强大
在Abp中执行sql语句
killcwd的专栏
06-28 3424
目录 前言 最近使用ABP(ASP.NET Boilerplate)做项目，有些查询(或存储过程)直接使用sql语句会更方便一点。 定义一个接口 在Core项目中定义一个接口，如：ISqlExecuter public interface ISqlExecuter { /// /// 执行给定的命令 ///
abp vnext 和volo abp vnext 有区别吗
最新发布
06-10
ABP vNext是一款开源的ASP.NET Core开发框架，提供了一系列基础设施和模块，帮助开发者快速构建企业级应用程序。而Volo.Abp是基于ABP vNext的一款快速开发框架，提供了一些预置的功能和模块，帮助开发者更快速地创建应用程序。 虽然Volo.Abp是基于ABP vNext的，但它们之间还是有一些区别的。Volo.Abp在ABP vNext的基础上，增加了更多的功能和模块，同时还提供了一些新的特性，例如更加简化的项目创建过程、更加精简的代码结构、更加易用的插件机制等等。此外，Volo.Abp也提供了更加详细的文档和示例，帮助开发者更好地了解和使用框架。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值