From 11a0ed37d6fb4650d616cc94b11f07d283ea1e97 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周六, 31 8月 2024 16:09:29 +0800 Subject: [PATCH] 1 --- iWara.SCADA.Code/iWare.Wms.Database.Migrations/Migrations/20240830014836_v1.0.2.Designer.cs | 401 +++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 389 insertions(+), 12 deletions(-) diff --git a/iWara.SCADA.Code/iWare.Wms.Database.Migrations/Migrations/20240112013535_v1.0.1.Designer.cs b/iWara.SCADA.Code/iWare.Wms.Database.Migrations/Migrations/20240830014836_v1.0.2.Designer.cs similarity index 97% rename from iWara.SCADA.Code/iWare.Wms.Database.Migrations/Migrations/20240112013535_v1.0.1.Designer.cs rename to iWara.SCADA.Code/iWare.Wms.Database.Migrations/Migrations/20240830014836_v1.0.2.Designer.cs index d5a9b46..a413f30 100644 --- a/iWara.SCADA.Code/iWare.Wms.Database.Migrations/Migrations/20240112013535_v1.0.1.Designer.cs +++ b/iWara.SCADA.Code/iWare.Wms.Database.Migrations/Migrations/20240830014836_v1.0.2.Designer.cs @@ -12,8 +12,8 @@ namespace iWare.Wms.Database.Migrations.Migrations { [DbContext(typeof(DefaultDbContext))] - [Migration("20240112013535_v1.0.1")] - partial class v101 + [Migration("20240830014836_v1.0.2")] + partial class v102 { protected override void BuildTargetModel(ModelBuilder modelBuilder) { @@ -683,6 +683,10 @@ .HasColumnType("nvarchar(50)") .HasComment("鍒涘缓鑰呭悕绉�"); + b.Property<DateTime?>("CuttingFluidAddTime") + .HasColumnType("datetime2") + .HasComment("鍒囧墛娑叉坊鍔犳椂闂�"); + b.Property<int>("CuttingFluidChangeAlertThreshold") .HasColumnType("int") .HasComment("鍒囧墛娑查璀﹂槇鍊�"); @@ -690,6 +694,10 @@ b.Property<DateTime?>("CuttingFluidChangeTime") .HasColumnType("datetime2") .HasComment("鍒囧墛娑叉洿鎹㈡椂闂�"); + + b.Property<DateTime?>("DetergentAddtime") + .HasColumnType("datetime2") + .HasComment("娓呮礂娑叉坊鍔犳椂闂�"); b.Property<int>("DetergentChangeAlertThreshold") .HasColumnType("int") @@ -783,6 +791,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("鍒涘缓鑰匢d"); + + 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("淇敼鑰匢d"); + + 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 => @@ -2252,6 +2332,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("璐ㄩ噺鎺ユ敹鏃堕棿"); @@ -2577,6 +2702,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") @@ -13372,6 +13542,10 @@ .HasColumnType("bit") .HasComment("杞垹闄ゆ爣璁�"); + b.Property<bool?>("IsOut") + .HasColumnType("bit") + .HasComment("鏄惁鍑哄簱"); + b.Property<string>("LogAddRemark") .HasMaxLength(255) .HasColumnType("nvarchar(255)") @@ -13387,10 +13561,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") @@ -13404,6 +13590,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") @@ -13427,6 +13619,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") @@ -13498,6 +13698,19 @@ b.Property<int?>("WorkPieceState") .HasColumnType("int") .HasComment("宸ヤ欢鐘舵��"); + + b.Property<DateTime?>("WorkPieceUnLineTime") + .HasColumnType("datetime2") + .HasComment("涓嬬嚎鏃堕棿"); + + b.Property<long?>("WorkPieceUnLineUserId") + .HasColumnType("bigint") + .HasComment("涓嬬嚎浜篒d"); + + b.Property<string>("WorkPieceUnLineUserName") + .HasMaxLength(32) + .HasColumnType("nvarchar(32)") + .HasComment("涓嬬嚎浜哄悕绉�"); b.Property<DateTime?>("WorkPieceinitOnlineTime") .HasColumnType("datetime2") @@ -13940,6 +14153,11 @@ .HasColumnType("bigint") .HasComment("Id涓婚敭"); + b.Property<string>("CarNo") + .HasMaxLength(32) + .HasColumnType("nvarchar(32)") + .HasComment("灏忚溅鐮�"); + b.Property<DateTimeOffset?>("CreatedTime") .HasColumnType("datetimeoffset") .HasComment("鍒涘缓鏃堕棿"); @@ -13963,6 +14181,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("鏇存柊鏃堕棿"); @@ -13977,33 +14208,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("鍑哄簱浜篒d"); 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("涓嬬嚎浜篒d"); + + 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("鍒涘缓鑰匢d"); + + 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("淇敼鑰匢d"); + + 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 => @@ -14047,6 +14354,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("璐ㄩ噺鐘舵��"); @@ -14090,6 +14403,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("鍒涘缓鑰匢d"); + + 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("淇敼鑰匢d"); + + 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") -- Gitblit v1.9.3