From 2d4577f9997ce981ebd548ff6986f6839ba14429 Mon Sep 17 00:00:00 2001 From: zs <zhousong@weben-smart.com> Date: 周二, 06 5月 2025 13:33:55 +0800 Subject: [PATCH] 添加基础表 --- HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsContainer.cs | 69 ++++++++++++++++++++++++++++++++-- 1 files changed, 64 insertions(+), 5 deletions(-) diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsContainer.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsContainer.cs index 914c0a2..289cef0 100644 --- a/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsContainer.cs +++ b/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsContainer.cs @@ -38,19 +38,78 @@ builder.Entity<WmsContainer>(b => { - //Configure table & schema name - b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WmsContainers").ToLower(), CMSPluginDbProperties.DbSchema).HasComment("WmsContainer"); + b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WmsContainers").ToLower(), CMSPluginDbProperties.DbSchema) + .HasComment("鎵樼洏淇℃伅琛�"); b.ConfigureByConvention(); //Properties - b.Property(x => x.Code).HasMaxLength(WmsContainerConsts.MaxCodeLength).IsRequired().HasComment("缂栫爜"); - b.Property(x => x.Name).HasMaxLength(WmsContainerConsts.MaxNameLength).IsRequired().HasComment("鍚嶇О"); + b.Property(x => x.ContainerNo) + .HasMaxLength(50) + .IsRequired() + .HasComment("鎵樼洏缂栧彿"); + + b.Property(x => x.ContainerType) + .IsRequired() + .HasComment("鎵樼洏绫诲瀷"); + + b.Property(x => x.ContainerStatus) + .IsRequired() + .HasComment("鎵樼洏鐘舵��"); + + b.Property(x => x.SpecLength) + .HasPrecision(18, 2) + .HasComment("闀垮害"); + + b.Property(x => x.SpecWidth) + .HasPrecision(18, 2) + .HasComment("瀹藉害"); + + b.Property(x => x.SpecHeight) + .HasPrecision(18, 2) + .HasComment("楂樺害"); + + b.Property(x => x.LimitLength) + .HasPrecision(18, 2) + .HasComment("闄愰暱"); + + b.Property(x => x.LimitWidth) + .HasPrecision(18, 2) + .HasComment("闄愬"); + + b.Property(x => x.LimitHeight) + .HasPrecision(18, 2) + .HasComment("闄愰珮"); + + b.Property(x => x.MaxWeight) + .HasPrecision(18, 2) + .HasComment("杞介噸涓婇檺"); + + b.Property(x => x.ExceptionNumber) + .HasComment("寮傚父鏁伴噺"); + + b.Property(x => x.MaterialNumber) + .HasComment("鐗╂枡鏁伴噺"); + + b.Property(x => x.RedundantField1) + .HasMaxLength(200) + .HasComment("鍐椾綑瀛楁1 - 棰勭暀鎵╁睍鐢ㄩ��"); + + b.Property(x => x.RedundantField2) + .HasMaxLength(200) + .HasComment("鍐椾綑瀛楁2 - 棰勭暀鎵╁睍鐢ㄩ��"); + + b.Property(x => x.RedundantField3) + .HasMaxLength(200) + .HasComment("鍐椾綑瀛楁3 - 棰勭暀鎵╁睍鐢ㄩ��"); + b.Property(x => x.Sort).HasComment("鎺掑簭"); b.Property(x => x.IsDisabled).IsRequired(false).HasComment("鏄惁绂佺敤"); b.Property(x => x.Remark).HasMaxLength(WmsContainerConsts.MaxRemarkLength).IsRequired(false).HasComment("澶囨敞"); - b.HasIndex(u => u.Name); + b.HasIndex(u => u.ContainerNo).IsUnique(); + b.HasIndex(u => u.ContainerType); + b.HasIndex(u => u.ContainerStatus); b.ApplyObjectExtensionMappings(); }); -- Gitblit v1.9.3