From 14f9c8378bde7d9a8d8f1fcc393e0e8d49eced82 Mon Sep 17 00:00:00 2001 From: zs <zhousong@weben-smart.com> Date: 周五, 09 5月 2025 17:44:29 +0800 Subject: [PATCH] 查找空库位,查找库存 --- HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs | 88 +++++++++++++++++++++++++++++++++++++------ 1 files changed, 75 insertions(+), 13 deletions(-) diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs index dc97f08..52830b8 100644 --- a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs +++ b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs @@ -155,27 +155,60 @@ .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") - .HasColumnName("ConcurrencyStamp"); + .HasColumnName("ConcurrencyStamp") + .HasComment("骞跺彂鎴�"); b.Property<DateTime>("CreationTime") .HasColumnType("datetime(6)") - .HasColumnName("CreationTime"); + .HasColumnName("CreationTime") + .HasComment("鍒涘缓鏃堕棿"); b.Property<Guid?>("CreatorId") + .HasMaxLength(36) .HasColumnType("char(36)") - .HasColumnName("CreatorId"); + .HasColumnName("CreatorId") + .HasComment("鍒涘缓浜篒D"); + + b.Property<string>("CreatorName") + .HasMaxLength(64) + .HasColumnType("varchar(64)") + .HasComment("鍒涘缓浜�"); + + b.Property<string>("DeleteRemark") + .HasMaxLength(256) + .HasColumnType("varchar(256)") + .HasComment("鍒犻櫎澶囨敞"); b.Property<Guid?>("DeleterId") + .HasMaxLength(36) .HasColumnType("char(36)") - .HasColumnName("DeleterId"); + .HasColumnName("DeleterId") + .HasComment("鍒犻櫎浜篒D"); b.Property<DateTime?>("DeletionTime") .HasColumnType("datetime(6)") - .HasColumnName("DeletionTime"); + .HasColumnName("DeletionTime") + .HasComment("鍒犻櫎鏃堕棿"); + + b.Property<string>("ExtraField1") + .HasMaxLength(256) + .HasColumnType("varchar(256)") + .HasComment("鎵╁睍瀛楁1"); + + b.Property<string>("ExtraField2") + .HasMaxLength(256) + .HasColumnType("varchar(256)") + .HasComment("鎵╁睍瀛楁2"); + + b.Property<string>("ExtraField3") + .HasMaxLength(256) + .HasColumnType("varchar(256)") + .HasComment("鎵╁睍瀛楁3"); b.Property<string>("ExtraProperties") .HasColumnType("longtext") - .HasColumnName("ExtraProperties"); + .HasColumnName("ExtraProperties") + .HasComment("鎵╁睍灞炴��"); b.Property<Guid>("Id") .HasColumnType("char(36)"); @@ -184,21 +217,46 @@ .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) - .HasColumnName("IsDeleted"); + .HasColumnName("IsDeleted") + .HasComment("鏄惁鍒犻櫎"); b.Property<bool?>("IsDisabled") - .HasColumnType("tinyint(1)"); + .ValueGeneratedOnAdd() + .HasColumnType("tinyint(1)") + .HasDefaultValue(false) + .HasComment("鏄惁绂佺敤"); b.Property<DateTime?>("LastModificationTime") .HasColumnType("datetime(6)") - .HasColumnName("LastModificationTime"); + .HasColumnName("LastModificationTime") + .HasComment("淇敼鏃堕棿"); b.Property<Guid?>("LastModifierId") + .HasMaxLength(36) .HasColumnType("char(36)") - .HasColumnName("LastModifierId"); + .HasColumnName("LastModifierId") + .HasComment("淇敼浜篒D"); + + b.Property<string>("LastModifierName") + .HasMaxLength(64) + .HasColumnType("varchar(64)") + .HasComment("淇敼浜�"); + + b.Property<string>("OperationRemark") + .HasMaxLength(256) + .HasColumnType("varchar(256)") + .HasComment("鎿嶄綔澶囨敞"); + + b.Property<string>("Remark") + .HasMaxLength(256) + .HasColumnType("varchar(256)") + .HasComment("澶囨敞"); b.Property<int>("Sort") - .HasColumnType("int"); + .ValueGeneratedOnAdd() + .HasColumnType("int") + .HasDefaultValue(0) + .HasComment("鎺掑簭"); b.HasKey("PlaceNo", "ContainerNo"); @@ -1048,7 +1106,7 @@ .HasColumnType("decimal(18,2)") .HasComment("闀垮害锛堝崟浣嶏細m锛�"); - b.Property<string>("MaterialCode") + b.Property<string>("MaterialNo") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") @@ -1124,7 +1182,7 @@ b.HasKey("Id"); - b.HasIndex("MaterialCode") + b.HasIndex("MaterialNo") .IsUnique(); b.HasIndex("MaterialName"); @@ -1398,6 +1456,10 @@ .HasColumnType("int") .HasComment("灞�"); + b.Property<int>("MaxStockNumber") + .HasColumnType("int") + .HasComment("鏈�澶у簱瀛橀噺"); + b.Property<string>("PlaceNo") .IsRequired() .HasMaxLength(50) -- Gitblit v1.9.3