From 6be4dc69a73560ab2e08e68d5dbfdf95ae62d5b4 Mon Sep 17 00:00:00 2001
From: zs <zhousong@weben-smart.com>
Date: 周三, 14 5月 2025 15:14:37 +0800
Subject: [PATCH] 托盘高级查询
---
HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs | 206 +++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 172 insertions(+), 34 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 a335516..16a5127 100644
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs
+++ b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs
@@ -139,7 +139,7 @@
b.HasComment("搴撳尯琛�");
});
- modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainerPlaces.WmsContainerPlace", b =>
+ modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainerPlace.WmsContainerPlace", b =>
{
b.Property<string>("PlaceNo")
.HasMaxLength(50)
@@ -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");
@@ -510,24 +568,71 @@
modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsInOutStockOrderDetail.WmsInOutStockOrderDetail", b =>
{
- b.Property<string>("OrderNo")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("鍗曟嵁缂栧彿");
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("char(36)");
- b.Property<string>("MaterialId")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鐗╂枡鍞竴鐮�");
+ b.Property<string>("ConcurrencyStamp")
+ .IsConcurrencyToken()
+ .HasMaxLength(40)
+ .HasColumnType("varchar(40)")
+ .HasColumnName("ConcurrencyStamp");
b.Property<string>("ContainerNo")
.HasMaxLength(50)
.HasColumnType("varchar(50)")
.HasComment("瀹瑰櫒缂栧彿");
- b.Property<int?>("MaterialBatch")
- .HasColumnType("int")
+ b.Property<DateTime>("CreationTime")
+ .HasColumnType("datetime(6)")
+ .HasColumnName("CreationTime");
+
+ b.Property<Guid?>("CreatorId")
+ .HasColumnType("char(36)")
+ .HasColumnName("CreatorId");
+
+ b.Property<Guid?>("DeleterId")
+ .HasColumnType("char(36)")
+ .HasColumnName("DeleterId");
+
+ b.Property<DateTime?>("DeletionTime")
+ .HasColumnType("datetime(6)")
+ .HasColumnName("DeletionTime");
+
+ b.Property<string>("ExtraProperties")
+ .HasColumnType("longtext")
+ .HasColumnName("ExtraProperties");
+
+ b.Property<bool>("IsDeleted")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("tinyint(1)")
+ .HasDefaultValue(false)
+ .HasColumnName("IsDeleted");
+
+ b.Property<bool?>("IsDisabled")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("tinyint(1)")
+ .HasDefaultValue(false)
+ .HasComment("鏄惁绂佺敤");
+
+ b.Property<DateTime?>("LastModificationTime")
+ .HasColumnType("datetime(6)")
+ .HasColumnName("LastModificationTime");
+
+ b.Property<Guid?>("LastModifierId")
+ .HasColumnType("char(36)")
+ .HasColumnName("LastModifierId");
+
+ b.Property<string>("MaterialBatch")
+ .HasMaxLength(50)
+ .HasColumnType("varchar(50)")
.HasComment("鐗╂枡鎵规");
+
+ b.Property<string>("MaterialId")
+ .IsRequired()
+ .HasMaxLength(64)
+ .HasColumnType("varchar(64)")
+ .HasComment("鐗╂枡鍞竴鐮�");
b.Property<string>("MaterialModel")
.HasMaxLength(50)
@@ -545,11 +650,28 @@
.HasColumnType("varchar(50)")
.HasComment("鐗╂枡浠跺彿");
+ b.Property<string>("OrderNo")
+ .IsRequired()
+ .HasMaxLength(50)
+ .HasColumnType("varchar(50)")
+ .HasComment("鍗曟嵁缂栧彿");
+
b.Property<int>("OrderType")
.HasColumnType("int")
.HasComment("鍗曟嵁绫诲瀷锛堟灇涓惧�硷級");
- b.HasKey("OrderNo", "MaterialId");
+ b.Property<string>("Remark")
+ .HasMaxLength(500)
+ .HasColumnType("varchar(500)")
+ .HasComment("澶囨敞");
+
+ b.Property<int>("Sort")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("int")
+ .HasDefaultValue(0)
+ .HasComment("鎺掑簭");
+
+ b.HasKey("Id");
b.HasIndex("ContainerNo");
@@ -621,6 +743,11 @@
.HasColumnType("char(36)")
.HasColumnName("LastModifierId");
+ b.Property<string>("MaterialBatch")
+ .HasMaxLength(64)
+ .HasColumnType("varchar(64)")
+ .HasComment("鐗╂枡鎵规");
+
b.Property<string>("MaterialId")
.IsRequired()
.HasMaxLength(50)
@@ -648,7 +775,6 @@
.HasComment("鎿嶄綔鏃堕棿");
b.Property<string>("OrderNo")
- .IsRequired()
.HasMaxLength(50)
.HasColumnType("varchar(50)")
.HasComment("鍗曟嵁缂栧彿");
@@ -985,12 +1111,6 @@
.HasColumnType("decimal(18,2)")
.HasComment("闀垮害锛堝崟浣嶏細m锛�");
- b.Property<string>("MaterialCode")
- .IsRequired()
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鐗╂枡缂栫爜锛堝敮涓�鏍囪瘑锛�");
-
b.Property<string>("MaterialModel")
.HasMaxLength(128)
.HasColumnType("varchar(128)")
@@ -1001,6 +1121,12 @@
.HasMaxLength(128)
.HasColumnType("varchar(128)")
.HasComment("鐗╂枡鍚嶇О");
+
+ b.Property<string>("MaterialNo")
+ .IsRequired()
+ .HasMaxLength(64)
+ .HasColumnType("varchar(64)")
+ .HasComment("鐗╂枡缂栫爜锛堝敮涓�鏍囪瘑锛�");
b.Property<string>("MaterialQuality")
.HasMaxLength(64)
@@ -1061,10 +1187,10 @@
b.HasKey("Id");
- b.HasIndex("MaterialCode")
- .IsUnique();
-
b.HasIndex("MaterialName");
+
+ b.HasIndex("MaterialNo")
+ .IsUnique();
b.HasIndex("MaterialType");
@@ -1315,8 +1441,10 @@
.HasDefaultValue(false)
.HasColumnName("IsDeleted");
- b.Property<bool?>("IsDisabled")
+ b.Property<bool>("IsDisabled")
+ .ValueGeneratedOnAdd()
.HasColumnType("tinyint(1)")
+ .HasDefaultValue(false)
.HasComment("鏄惁绂佺敤");
b.Property<int>("Islock")
@@ -1334,6 +1462,10 @@
b.Property<int>("LayerNo")
.HasColumnType("int")
.HasComment("灞�");
+
+ b.Property<int>("MaxStockNumber")
+ .HasColumnType("int")
+ .HasComment("鏈�澶у簱瀛橀噺");
b.Property<string>("PlaceNo")
.IsRequired()
@@ -1576,6 +1708,12 @@
.HasColumnType("varchar(200)")
.HasComment("鍙彉鍙橀噺3");
+ b.Property<int>("PlcTaskId")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("int")
+ .HasDefaultValue(0)
+ .HasComment("浠诲姟鐘舵��");
+
b.Property<int?>("SonTaskType")
.HasColumnType("int")
.HasComment("瀛愪换鍔＄被鍨�");
--
Gitblit v1.9.3