1

schangxiang@126.com

2024-08-31 11a0ed37d6fb4650d616cc94b11f07d283ea1e97

 iWara.SCADA.Code/iWare.Wms.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs

@@ -681,6 +681,10 @@
                        .HasColumnType("nvarchar(50)")
                        .HasComment("创建者名称");

                    b.Property<DateTime?>("CuttingFluidAddTime")
                        .HasColumnType("datetime2")
                        .HasComment("切削液添加时间");

                    b.Property<int>("CuttingFluidChangeAlertThreshold")
                        .HasColumnType("int")
                        .HasComment("切削液预警阈值");
@@ -688,6 +692,10 @@
                    b.Property<DateTime?>("CuttingFluidChangeTime")
                        .HasColumnType("datetime2")
                        .HasComment("切削液更换时间");

                    b.Property<DateTime?>("DetergentAddtime")
                        .HasColumnType("datetime2")
                        .HasComment("清洗液添加时间");

                    b.Property<int>("DetergentChangeAlertThreshold")
                        .HasColumnType("int")
@@ -781,6 +789,78 @@
                    b.ToTable("EquipmentBaseInfo");

                    b.HasComment("设备基础信息表");
                });

            modelBuilder.Entity("iWare.Wms.Core.Equipmentbaseinfolog", b =>
                {
                    b.Property<long>("Id")
                        .HasColumnType("bigint")
                        .HasComment("Id主键");

                    b.Property<DateTimeOffset?>("CreatedTime")
                        .HasColumnType("datetimeoffset")
                        .HasComment("创建时间");

                    b.Property<long?>("CreatedUserId")
                        .HasColumnType("bigint")
                        .HasComment("创建者Id");

                    b.Property<string>("CreatedUserName")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)")
                        .HasComment("创建者名称");

                    b.Property<long>("EquipmentBaseInfoId")
                        .HasColumnType("bigint")
                        .HasComment("设备ID");

                    b.Property<string>("EquipmentID")
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("设备编号");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("软删除标记");

                    b.Property<string>("OperatorContent")
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("操作内容");

                    b.Property<int>("OperatorType")
                        .HasColumnType("int")
                        .HasComment("操作类型ID");

                    b.Property<string>("OperatorTypeName")
                        .IsRequired()
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("操作类型");

                    b.Property<string>("Remark")
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("备注");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset")
                        .HasComment("更新时间");

                    b.Property<long?>("UpdatedUserId")
                        .HasColumnType("bigint")
                        .HasComment("修改者Id");

                    b.Property<string>("UpdatedUserName")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)")
                        .HasComment("修改者名称");

                    b.HasKey("Id");

                    b.ToTable("equipmentbaseinfolog");

                    b.HasComment("设备维护记录");
                });

            modelBuilder.Entity("iWare.Wms.Core.EquipmentCurrentMonitor", b =>
@@ -2250,6 +2330,51 @@
                        .HasColumnType("nvarchar(32)")
                        .HasComment("重量组别;OP80");

                    b.Property<string>("QualityOP80_DTKYZD")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_S_X")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_S_Y")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_TKZJ")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_X_X")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_X_Y")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_Houdu")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_XTSMYD")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_XTXMYD")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_S_X")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_S_Y")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_TKZJ")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_X_X")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_X_Y")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_ZXJ")
                        .HasColumnType("nvarchar(max)");

                    b.Property<DateTime>("QualityReceiveTime")
                        .HasColumnType("datetime2")
                        .HasComment("质量接收时间");
@@ -2575,6 +2700,51 @@
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("重量组别;OP80");

                    b.Property<string>("QualityOP80_DTKYZD")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_S_X")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_S_Y")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_TKZJ")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_X_X")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_D_X_Y")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_Houdu")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_XTSMYD")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_XTXMYD")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_S_X")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_S_Y")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_TKZJ")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_X_X")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_X_X_Y")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("QualityOP80_ZXJ")
                        .HasColumnType("nvarchar(max)");

                    b.Property<DateTime>("QualityReceiveTime")
                        .HasColumnType("datetime2")
@@ -13370,6 +13540,10 @@
                        .HasColumnType("bit")
                        .HasComment("软删除标记");

                    b.Property<bool?>("IsOut")
                        .HasColumnType("bit")
                        .HasComment("是否出库");

                    b.Property<string>("LogAddRemark")
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
@@ -13385,10 +13559,22 @@
                        .HasComment("数量");

                    b.Property<string>("OP80NewCode")
                        .IsRequired()
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("工件OP80码");

                    b.Property<string>("OutPerson")
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("出库人");

                    b.Property<string>("OutRemark")
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("出库备注");

                    b.Property<DateTime?>("OutTime")
                        .HasColumnType("datetime2")
                        .HasComment("出库时间");

                    b.Property<int?>("ProcessingDurationForCurrent")
                        .HasColumnType("int")
@@ -13402,6 +13588,12 @@
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("质量不合格原因");

                    b.Property<int?>("QualityNoOk")
                        .HasColumnType("int");

                    b.Property<string>("QualityNoOkReason")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int?>("QualityState")
                        .HasColumnType("int")
@@ -13425,6 +13617,14 @@
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("备注");

                    b.Property<int?>("UnLineStage")
                        .HasColumnType("int")
                        .HasComment("下线阶段");

                    b.Property<string>("UnLineStageName")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("下线阶段名称");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset")
@@ -13496,6 +13696,19 @@
                    b.Property<int?>("WorkPieceState")
                        .HasColumnType("int")
                        .HasComment("工件状态");

                    b.Property<DateTime?>("WorkPieceUnLineTime")
                        .HasColumnType("datetime2")
                        .HasComment("下线时间");

                    b.Property<long?>("WorkPieceUnLineUserId")
                        .HasColumnType("bigint")
                        .HasComment("下线人Id");

                    b.Property<string>("WorkPieceUnLineUserName")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("下线人名称");

                    b.Property<DateTime?>("WorkPieceinitOnlineTime")
                        .HasColumnType("datetime2")
@@ -13938,6 +14151,11 @@
                        .HasColumnType("bigint")
                        .HasComment("Id主键");

                    b.Property<string>("CarNo")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("小车码");

                    b.Property<DateTimeOffset?>("CreatedTime")
                        .HasColumnType("datetimeoffset")
                        .HasComment("创建时间");
@@ -13961,6 +14179,19 @@
                        .HasColumnType("nvarchar(255)")
                        .HasComment("OP80打码");

                    b.Property<string>("Remark")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)")
                        .HasComment("备注");

                    b.Property<int?>("UnLineStage")
                        .HasColumnType("int")
                        .HasComment("阶段");

                    b.Property<string>("UnLineStageName")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("阶段名称");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset")
                        .HasComment("更新时间");
@@ -13975,33 +14206,109 @@
                        .HasComment("修改者名称");

                    b.Property<string>("WorkPieceID")
                        .IsRequired()
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("工件号");

                    b.Property<DateTime?>("WorkPieceOutboundTime")
                        .IsRequired()
                        .HasColumnType("datetime2")
                        .HasComment("出库时间");

                    b.Property<long?>("WorkPieceOutboundUserId")
                        .IsRequired()
                        .HasMaxLength(32)
                        .HasColumnType("bigint")
                        .HasComment("出库人Id");

                    b.Property<string>("WorkPieceOutboundUserName")
                        .IsRequired()
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("出库人名称");

                    b.Property<DateTime?>("WorkPieceUnLineTime")
                        .HasColumnType("datetime2")
                        .HasComment("下线时间");

                    b.Property<long?>("WorkPieceUnLineUserId")
                        .HasColumnType("bigint")
                        .HasComment("下线人Id");

                    b.Property<string>("WorkPieceUnLineUserName")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("下线人名称");

                    b.HasKey("Id");

                    b.ToTable("WorkPieceOutbound");

                    b.HasComment("工件出库表");
                });

            modelBuilder.Entity("iWare.Wms.Core.WorkPieceOutboundRecord", b =>
                {
                    b.Property<long>("Id")
                        .HasColumnType("bigint")
                        .HasComment("Id主键");

                    b.Property<string>("CarNo")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("小车码");

                    b.Property<DateTimeOffset?>("CreatedTime")
                        .HasColumnType("datetimeoffset")
                        .HasComment("创建时间");

                    b.Property<long?>("CreatedUserId")
                        .HasColumnType("bigint")
                        .HasComment("创建者Id");

                    b.Property<string>("CreatedUserName")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)")
                        .HasComment("创建者名称");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("软删除标记");

                    b.Property<string>("OP80NewCode")
                        .IsRequired()
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("成品码");

                    b.Property<string>("OperationType")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)")
                        .HasComment("操作类型");

                    b.Property<string>("Remark")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)")
                        .HasComment("备注");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset")
                        .HasComment("更新时间");

                    b.Property<long?>("UpdatedUserId")
                        .HasColumnType("bigint")
                        .HasComment("修改者Id");

                    b.Property<string>("UpdatedUserName")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)")
                        .HasComment("修改者名称");

                    b.Property<string>("WorkPieceID")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("工件号");

                    b.HasKey("Id");

                    b.ToTable("WorkPieceOutboundRecord");

                    b.HasComment("工件出库记录表");
                });

            modelBuilder.Entity("iWare.Wms.Core.WorkPieceProcess", b =>
@@ -14045,6 +14352,12 @@
                        .HasColumnType("bigint")
                        .HasComment("质量信息id");

                    b.Property<int?>("QualityNoOk")
                        .HasColumnType("int");

                    b.Property<string>("QualityNoOkReason")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("QualityState")
                        .HasColumnType("int")
                        .HasComment("质量状态");
@@ -14088,6 +14401,70 @@
                    b.HasComment("工件加工履历表");
                });

            modelBuilder.Entity("iWare.Wms.Core.WorkPieceUnLine", b =>
                {
                    b.Property<long>("Id")
                        .HasColumnType("bigint")
                        .HasComment("Id主键");

                    b.Property<string>("CarNo")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("小车码");

                    b.Property<DateTimeOffset?>("CreatedTime")
                        .HasColumnType("datetimeoffset")
                        .HasComment("创建时间");

                    b.Property<long?>("CreatedUserId")
                        .HasColumnType("bigint")
                        .HasComment("创建者Id");

                    b.Property<string>("CreatedUserName")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)")
                        .HasComment("创建者名称");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("软删除标记");

                    b.Property<string>("OP80NewCode")
                        .IsRequired()
                        .HasMaxLength(255)
                        .HasColumnType("nvarchar(255)")
                        .HasComment("成品码");

                    b.Property<string>("Remark")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)")
                        .HasComment("备注");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset")
                        .HasComment("更新时间");

                    b.Property<long?>("UpdatedUserId")
                        .HasColumnType("bigint")
                        .HasComment("修改者Id");

                    b.Property<string>("UpdatedUserName")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)")
                        .HasComment("修改者名称");

                    b.Property<string>("WorkPieceID")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("工件号");

                    b.HasKey("Id");

                    b.ToTable("WorkPieceUnLine");

                    b.HasComment("工件下线表");
                });

            modelBuilder.Entity("iWare.Wms.Core.YieldAnalysis", b =>
                {
                    b.Property<long>("Id")