22

schangxiang@126.com

2025-05-15 9a83dbb67b223e94a946e1bf7db59336e7fb2f28

 PipeLineLems/server/src/CMS.Plugin.PipeLineLems.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WorkPlan.cs

@@ -1,4 +1,6 @@
using CMS.Plugin.MyExtension.Domain;
using CMS.Plugin.PipeLineLems.Domain;
using CMS.Plugin.PipeLineLems.Domain.Shared.MyTestEntityNames;
using CMS.Plugin.PipeLineLems.Domain.WorkPlan;
using Microsoft.EntityFrameworkCore;
using Volo.Abp;
@@ -9,7 +11,7 @@
/// <summary>
/// EfCore扩展
/// </summary>
public  static partial class CMSPluginEfCoreExtensions
public static partial class CMSPluginEfCoreExtensions
{
    /// <summary>
    /// Includes the details.
@@ -38,62 +40,60 @@
        builder.Entity<WorkPlan>(b =>
        {
            //Configure table & schema name
            b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WorkPlans").ToLower(), CMSPluginDbProperties.DbSchema).HasComment("WorkPlan");
            b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WorkPlans").ToLower(), CMSPluginDbProperties.DbSchema).HasComment("作业计划表");

            b.ConfigureByConvention();

            //Properties
            b.Property(x => x.TaskCode).HasMaxLength(64).IsRequired().HasComment("任务编码");
            b.Property(x => x.OrgMaterialCode).HasMaxLength(64).IsRequired().HasComment("原料编号");
            b.Property(x => x.Sort).HasComment("排序");
            b.Property(x => x.IsDisabled).IsRequired(false).HasComment("是否禁用");
            b.Property(x => x.Remark).HasMaxLength(256).IsRequired(false).HasComment("备注");
            // Configure properties
            b.Property(x => x.TaskCode).HasMaxLength(256).IsRequired().HasComment("任务编码");
            b.Property(x => x.WorkPlanStatus).IsRequired().HasComment("计划状态");
            b.Property(x => x.CallMaterialStatus).IsRequired().HasComment("叫料状态");
            b.Property(x => x.DataIdentifier).HasMaxLength(256).HasComment("原料标识");
            b.Property(x => x.MaterialMode).HasMaxLength(256).HasComment("原料型号");
            b.Property(x => x.Length).HasColumnType("decimal(18,2)").HasComment("长度(mm)");
            b.Property(x => x.MarkingContent).HasMaxLength(1024).HasComment("打码内容");

            b.Property(x => x.OrgMaterialCode).HasMaxLength(64).HasComment("原料编号");
            b.Property(x => x.FactoryCode).HasMaxLength(64).HasComment("工厂代码");
            b.Property(x => x.ProductCode).HasMaxLength(64).HasComment("产品代码");
            b.Property(x => x.WorkstationCode).HasMaxLength(64).HasComment("工位代码");
            b.Property(x => x.EquipmentCode).HasMaxLength(64).HasComment("设备代码");
            b.Property(x => x.WorkpieceName).HasMaxLength(64).HasComment("工件名称");
            b.Property(x => x.ProcessName).HasMaxLength(64).HasComment("工序名称");
            b.Property(x => x.PipeFittingCode).HasMaxLength(64).HasComment("管件编码");
            b.Property(x => x.PreSerialNumber).HasMaxLength(64).HasComment("顺序号");
            b.Property(x => x.DataIdentifier).HasMaxLength(64).HasComment("原料标识");
            b.Property(x => x.PipeSpecCode).HasMaxLength(64).HasComment("管规格码");
            b.Property(x => x.PipeSectionName).HasMaxLength(64).HasComment("管段名称");
            b.Property(x => x.OuterDiameter).HasMaxLength(64).HasComment("外径");
            b.Property(x => x.Bevel).HasMaxLength(64).HasComment("坡口");
            b.Property(x => x.Material).HasMaxLength(64).HasComment("材质");
            b.Property(x => x.Length).HasMaxLength(64).HasComment("长度");
            b.Property(x => x.DrillingPosition).HasMaxLength(64).HasComment("打孔位");
            b.Property(x => x.Intersecting).HasMaxLength(64).HasComment("相贯");
            b.Property(x => x.InterfaceRequirement).HasMaxLength(64).HasComment("接口要求");
            b.Property(x => x.HasMainSignature).HasComment("是否有主签");
            b.Property(x => x.Quantity).HasComment("包括数量");
            b.Property(x => x.MarkingContent).HasMaxLength(64).HasComment("打码内容");
            b.Property(x => x.CuttingFile).HasMaxLength(64).HasComment("切割文件");
            b.Property(x => x.BranchOuterDiameter).HasMaxLength(64).HasComment("支外径");
            b.Property(x => x.BranchWallThickness).HasMaxLength(64).HasComment("支管壁厚");
            b.Property(x => x.BranchMaterial).HasMaxLength(64).HasComment("支管材质");
            b.Property(x => x.BranchPortRadius).HasMaxLength(64).HasComment("支管端口曲率半径");
            b.Property(x => x.BranchPortAngle).HasMaxLength(64).HasComment("支管端口角度");
            b.Property(x => x.BranchPortRequirement).HasMaxLength(64).HasComment("支管端口要求");
            b.Property(x => x.IntersectingLineType).HasMaxLength(64).HasComment("相贯线类型");
            b.Property(x => x.IntersectingLineCategory).HasMaxLength(64).HasComment("相贯线类别");
            b.Property(x => x.FinishedProductScale).HasMaxLength(64).HasComment("成品图幅");
            b.Property(x => x.FlangeThickness).HasMaxLength(64).HasComment("法兰厚度");
            b.Property(x => x.FlangeInnerDiameter).HasMaxLength(64).HasComment("法兰内径");
            b.Property(x => x.WeldingHeatInput).HasMaxLength(64).HasComment("焊接热输入");
            b.Property(x => x.PipeAllowableStress).HasMaxLength(64).HasComment("管道允许应力");
            b.Property(x => x.PipeDiameter).HasMaxLength(64).HasComment("管径");
            b.Property(x => x.PipeWallThickness).HasMaxLength(64).HasComment("管道壁厚");
            b.Property(x => x.VRData).HasMaxLength(64).HasComment("VR数据");
            b.Property(x => x.ProcessRouteNumber).HasMaxLength(64).HasComment("工艺路线编号");
            b.Property(x => x.Quantity).HasComment("管段数量");
            b.Property(x => x.FlangeThickness).HasColumnType("decimal(18,2)").HasComment("法兰厚度(mm)");
            b.Property(x => x.FlangeInnerDiameter).HasColumnType("decimal(18,2)").HasComment("法兰直径(mm)");
            b.Property(x => x.WeldingHeatInput).HasMaxLength(256).HasComment("法兰公称压力");
            b.Property(x => x.PipeAllowableStress).HasMaxLength(256).HasComment("法兰冲码内容");
            b.Property(x => x.PipeDiameter).HasColumnType("decimal(18,2)").HasComment("套管长度(mm)");
            b.Property(x => x.PipeWallThickness).HasColumnType("decimal(18,2)").HasComment("套管直径(mm)");
            b.Property(x => x.FactoryCode).HasMaxLength(256).HasComment("工厂代码");
            b.Property(x => x.ProductCode).HasMaxLength(256).HasComment("产品代码");
            b.Property(x => x.WorkstationCode).HasMaxLength(256).HasComment("工位代码");
            b.Property(x => x.EquipmentCode).HasMaxLength(256).HasComment("设备代码");
            b.Property(x => x.ProdLineCode).HasMaxLength(256).HasComment("产线编码");
            b.Property(x => x.ShipNumber).HasMaxLength(256).HasComment("船号");
            b.Property(x => x.ProjectNumber).HasMaxLength(256).HasComment("项目号");

            b.Property(x => x.ProcessName).HasMaxLength(256).HasComment("工序名称");
            b.Property(x => x.PipeFittingCode).HasMaxLength(256).HasComment("管件编码");
            b.Property(x => x.PreSerialNumber).HasMaxLength(256).HasComment("顺序号");
            b.Property(x => x.PipeSpecCode).HasMaxLength(256).HasComment("管段编码");
            b.Property(x => x.PipeSectionName).HasMaxLength(256).HasComment("管段名称");
            b.Property(x => x.OuterDiameter).HasColumnType("decimal(18,2)").HasComment("外径(mm)");
            b.Property(x => x.Thickness).HasColumnType("decimal(18,2)").HasComment("壁厚(mm)");
            b.Property(x => x.Material).HasMaxLength(256).HasComment("材质");


            b.Property(x => x.MarkingPosition).HasColumnType("decimal(18,2)").HasComment("打码位置");
            b.Property(x => x.CuttingPosition).HasColumnType("decimal(18,2)").HasComment("切割位置");

            b.Property(x => x.ProcessRouteNumber).HasMaxLength(256).HasComment("工艺流向编号");
            b.Property(x => x.PlannedStartTime).HasComment("计划开始时间");
            b.Property(x => x.PlannedEndTime).HasComment("计划完成时间");
            b.Property(x => x.TimeInfo).HasMaxLength(64).HasComment("时间信息");
            b.Property(x => x.TeamInfo).HasMaxLength(256).HasComment("班组信息");
            b.Property(x => x.Timestamp).HasMaxLength(256).HasComment("时间戳");

            b.HasIndex(u => u.TaskCode);
            b.ConfigureMyCmsEntity();

            // Configure indexes
            b.HasIndex(u => u.TaskCode).IsUnique();
            b.HasIndex(u => u.DataIdentifier);
            b.HasIndex(u => u.PlannedStartTime);
            b.HasIndex(u => u.PlannedEndTime);

            b.ApplyObjectExtensionMappings();
        });