HIA24016N_PipeLineDemo.git

2025-05-06 d954f779d250b9a8ba3226e27ce42ec362ae3199

添加生成器数据库配置

已添加2个文件

已修改6个文件

	HIAWms/server/src/CMS.Plugin.HIAWms.Domain/WmsContainerPlaces/WmsContainerPlace.cs	3 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	HIAWms/server/src/CMS.Plugin.HIAWms.Domain/WmsInOutStockRecords/WmsInOutStockRecord.cs	3 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsIContainerPlace.cs	3 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsInOutStockRecord.cs	3 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250506054001_InitialCreate7.Designer.cs	1197 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250506054001_InitialCreate7.cs	150 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs	197 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Weben_CMS专用代码生成器/Code/App.config	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 HIAWms/server/src/CMS.Plugin.HIAWms.Domain/WmsContainerPlaces/WmsContainerPlace.cs

@@ -5,13 +5,14 @@
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Volo.Abp.Domain.Entities.Auditing;

namespace CMS.Plugin.HIAWms.Domain.WmsContainerPlaces
{
    /// <summary>
    /// åºä½å®¹å¨å³ç³»
    /// </summary>
    public class WmsContainerPlace
    public class WmsContainerPlace : FullAuditedAggregateRoot<Guid>
    {
        /// <summary>
        /// åºä½ç¼ç 

 HIAWms/server/src/CMS.Plugin.HIAWms.Domain/WmsInOutStockRecords/WmsInOutStockRecord.cs

@@ -4,13 +4,14 @@
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Volo.Abp.Domain.Entities.Auditing;

namespace CMS.Plugin.HIAWms.Domain.WmsInOutStockRecords
{
    /// <summary>
    /// åºå¥åºè®°å½.
    /// </summary>
    public class WmsInOutStockRecord
    public class WmsInOutStockRecord : FullAuditedAggregateRoot<Guid>
    {
        /// <summary>
        /// åæ®ç¼å·

 HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsIContainerPlace.cs

@@ -46,7 +46,8 @@
                    .HasComment("å®¹å¨åºä½å³ç³»è¡¨");

                b.ConfigureByConvention();

                // ä¸»é®éç½®
                b.HasKey(x => x.Id);
                // Properties
                b.Property(x => x.PlaceNo)
                    .HasMaxLength(50)

 HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsInOutStockRecord.cs

@@ -47,7 +47,8 @@
                    .HasComment("åºå¥åºè®°å½è¡¨");

                b.ConfigureByConvention();

                // ä¸»é®éç½®
                b.HasKey(x => x.Id);
                // Properties
                b.Property(x => x.OrderNo)
                    .HasMaxLength(50)

 HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250506054001_InitialCreate7.Designer.cs

¶Ô±ÈÐÂÎÄ¼þ
@@ -0,0 +1,1197 @@
ï»¿// <auto-generated />
using System;
using CMS.Plugin.HIAWms.MySQL;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using Volo.Abp.EntityFrameworkCore;

#nullable disable

namespace CMS.Plugin.HIAWms.MySQL.Migrations
{
    [DbContext(typeof(CMSPluginDbContext))]
    [Migration("20250506054001_InitialCreate7")]
    partial class InitialCreate7
    {
        protected override void BuildTargetModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            modelBuilder
                .HasAnnotation("_Abp_DatabaseProvider", EfCoreDatabaseProvider.MySql)
                .HasAnnotation("ProductVersion", "6.0.16")
                .HasAnnotation("Relational:MaxIdentifierLength", 64);

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsAreas.WmsArea", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("char(36)");

                    b.Property<string>("AreaDesc")
                        .HasMaxLength(200)
                        .HasColumnType("varchar(200)")
                        .HasComment("æè¿°");

                    b.Property<string>("AreaName")
                        .IsRequired()
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åºåºåç§°");

                    b.Property<string>("AreaNo")
                        .IsRequired()
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("åºåºç¼å·");

                    b.Property<int>("AreaStatus")
                        .HasColumnType("int")
                        .HasComment("åºåºç¶æ");

                    b.Property<int>("AreaType")
                        .HasColumnType("int")
                        .HasComment("åºåºç±»å");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    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")
                        .HasColumnType("tinyint(1)")
                        .HasComment("æ¯å¦ç¦ç¨");

                    b.Property<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.Property<string>("RedundantField1")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åä½åæ®µ1 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField2")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åä½åæ®µ2 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField3")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åä½åæ®µ3 - é¢çæ©å±ç¨é");

                    b.Property<string>("Remark")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("å¤æ³¨");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
                        .HasComment("æåº");

                    b.Property<string>("StoreCode")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ä»åºä»£ç ");

                    b.Property<string>("StoreName")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("ä»åºåç§°");

                    b.HasKey("Id");

                    b.HasIndex("AreaName");

                    b.ToTable("scms_wmsareas", (string)null);

                    b.HasComment("åºåºè¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainerPlaces.WmsContainerPlace", b =>
                {
                    b.Property<string>("PlaceNo")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("åºä½ç¼ç ");

                    b.Property<string>("ContainerNo")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("æçç¼å·");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    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<Guid>("Id")
                        .HasColumnType("char(36)");

                    b.Property<bool>("IsDeleted")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("tinyint(1)")
                        .HasDefaultValue(false)
                        .HasColumnName("IsDeleted");

                    b.Property<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.HasKey("PlaceNo", "ContainerNo");

                    b.HasIndex("ContainerNo");

                    b.HasIndex("PlaceNo");

                    b.ToTable("scms_wmscontainerplaces", (string)null);

                    b.HasComment("å®¹å¨åºä½å³ç³»è¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainers.WmsContainer", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("char(36)");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    b.Property<string>("ContainerNo")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("æçç¼å·");

                    b.Property<int>("ContainerStatus")
                        .HasColumnType("int")
                        .HasComment("æçç¶æ");

                    b.Property<int>("ContainerType")
                        .HasColumnType("int")
                        .HasComment("æçç±»å");

                    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<int?>("ExceptionNumber")
                        .HasColumnType("int")
                        .HasComment("å¼å¸¸æ°é");

                    b.Property<string>("ExtraProperties")
                        .HasColumnType("longtext")
                        .HasColumnName("ExtraProperties");

                    b.Property<bool>("IsDeleted")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("tinyint(1)")
                        .HasDefaultValue(false)
                        .HasColumnName("IsDeleted");

                    b.Property<bool?>("IsDisabled")
                        .HasColumnType("tinyint(1)")
                        .HasComment("æ¯å¦ç¦ç¨");

                    b.Property<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.Property<decimal?>("LimitHeight")
                        .HasPrecision(18, 2)
                        .HasColumnType("decimal(18,2)")
                        .HasComment("éé«");

                    b.Property<decimal?>("LimitLength")
                        .HasPrecision(18, 2)
                        .HasColumnType("decimal(18,2)")
                        .HasComment("éé¿");

                    b.Property<decimal?>("LimitWidth")
                        .HasPrecision(18, 2)
                        .HasColumnType("decimal(18,2)")
                        .HasComment("éå®½");

                    b.Property<int?>("MaterialNumber")
                        .HasColumnType("int")
                        .HasComment("ç©ææ°é");

                    b.Property<decimal?>("MaxWeight")
                        .HasPrecision(18, 2)
                        .HasColumnType("decimal(18,2)")
                        .HasComment("è½½éä¸é");

                    b.Property<string>("RedundantField1")
                        .HasMaxLength(200)
                        .HasColumnType("varchar(200)")
                        .HasComment("åä½åæ®µ1 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField2")
                        .HasMaxLength(200)
                        .HasColumnType("varchar(200)")
                        .HasComment("åä½åæ®µ2 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField3")
                        .HasMaxLength(200)
                        .HasColumnType("varchar(200)")
                        .HasComment("åä½åæ®µ3 - é¢çæ©å±ç¨é");

                    b.Property<string>("Remark")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("å¤æ³¨");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
                        .HasComment("æåº");

                    b.Property<decimal?>("SpecHeight")
                        .HasPrecision(18, 2)
                        .HasColumnType("decimal(18,2)")
                        .HasComment("é«åº¦");

                    b.Property<decimal?>("SpecLength")
                        .HasPrecision(18, 2)
                        .HasColumnType("decimal(18,2)")
                        .HasComment("é¿åº¦");

                    b.Property<decimal?>("SpecWidth")
                        .HasPrecision(18, 2)
                        .HasColumnType("decimal(18,2)")
                        .HasComment("å®½åº¦");

                    b.HasKey("Id");

                    b.HasIndex("ContainerNo")
                        .IsUnique();

                    b.HasIndex("ContainerStatus");

                    b.HasIndex("ContainerType");

                    b.ToTable("scms_wmscontainers", (string)null);

                    b.HasComment("æçä¿¡æ¯è¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsInOutStockRecords.WmsInOutStockRecord", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("char(36)");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    b.Property<string>("ContainerNo")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("å®¹å¨ç¼å·");

                    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<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.Property<string>("MaterialId")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ç©æID");

                    b.Property<string>("MaterialModel")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("æºå");

                    b.Property<string>("MaterialName")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("ç©æåç§°");

                    b.Property<string>("MaterialNo")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ç©æä»¶å·");

                    b.Property<DateTime?>("OperateTime")
                        .HasColumnType("datetime(6)")
                        .HasComment("æä½æ¶é´");

                    b.Property<string>("OrderNo")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("åæ®ç¼å·");

                    b.Property<string>("Remark")
                        .HasMaxLength(500)
                        .HasColumnType("varchar(500)")
                        .HasComment("å¤æ³¨");

                    b.Property<string>("SourcePlace")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("èµ·å§åºä½");

                    b.Property<int>("StockType")
                        .HasColumnType("int")
                        .HasComment("æä½ç±»å");

                    b.Property<string>("TaskNo")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ä»»å¡å·");

                    b.Property<string>("ToPlace")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ç®æ åºä½");

                    b.HasKey("Id");

                    b.HasIndex("ContainerNo");

                    b.HasIndex("MaterialId");

                    b.HasIndex("MaterialNo");

                    b.HasIndex("OperateTime");

                    b.HasIndex("OrderNo");

                    b.HasIndex("StockType");

                    b.HasIndex("TaskNo");

                    b.ToTable("scms_wmsinoutstockrecords", (string)null);

                    b.HasComment("åºå¥åºè®°å½è¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialInfos.WmsMaterialInfo", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("char(36)");

                    b.Property<int?>("CheckStatus")
                        .HasColumnType("int")
                        .HasComment("æ£éªç¶æ(0:æªæ£éª,1:æ£éªéè¿,2:æ£éªä¸éè¿)");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    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")
                        .HasColumnType("tinyint(1)")
                        .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)
                        .HasColumnType("varchar(50)")
                        .HasComment("æºå/è§æ ¼");

                    b.Property<string>("MaterialName")
                        .IsRequired()
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("ç©æåç§°");

                    b.Property<string>("MaterialNo")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ç©æä»£å·");

                    b.Property<string>("RedundantField1")
                        .HasMaxLength(255)
                        .HasColumnType("varchar(255)")
                        .HasComment("åä½åæ®µ1");

                    b.Property<string>("RedundantField2")
                        .HasMaxLength(255)
                        .HasColumnType("varchar(255)")
                        .HasComment("åä½åæ®µ2");

                    b.Property<string>("RedundantField3")
                        .HasMaxLength(255)
                        .HasColumnType("varchar(255)")
                        .HasComment("åä½åæ®µ3");

                    b.Property<string>("Remark")
                        .HasMaxLength(500)
                        .HasColumnType("varchar(500)")
                        .HasComment("å¤æ³¨");

                    b.Property<int>("Sort")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasDefaultValue(0)
                        .HasComment("æåº");

                    b.Property<int?>("StockNumber")
                        .HasColumnType("int")
                        .HasComment("åºåæ°é");

                    b.Property<string>("SupplierCode")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ä¾åºåç¼å·");

                    b.HasKey("Id");

                    b.HasIndex("CheckStatus");

                    b.HasIndex("MaterialBatch");

                    b.HasIndex("MaterialId")
                        .IsUnique();

                    b.HasIndex("MaterialName");

                    b.HasIndex("MaterialNo")
                        .IsUnique();

                    b.HasIndex("SupplierCode");

                    b.ToTable("scms_wmsmaterialinfos", (string)null);

                    b.HasComment("WMSç©æä¿¡æ¯è¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterials.WmsMaterial", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("char(36)");

                    b.Property<string>("Certification")
                        .HasMaxLength(128)
                        .HasColumnType("varchar(128)")
                        .HasComment("è¯ä¹¦ç¼å·");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    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<string>("Factory")
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("çäº§å·¥å");

                    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<int>("IsMainBranch")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasDefaultValue(2)
                        .HasComment("æ¯å¦ä¸ºä¸»æ¯ç®¡");

                    b.Property<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.Property<decimal>("Length")
                        .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)")
                        .HasComment("åå·");

                    b.Property<string>("MaterialName")
                        .IsRequired()
                        .HasMaxLength(128)
                        .HasColumnType("varchar(128)")
                        .HasComment("ç©æåç§°");

                    b.Property<string>("MaterialQuality")
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("æè´¨ï¼å¦ï¼304ä¸éé¢ï¼");

                    b.Property<int>("MaterialType")
                        .HasColumnType("int")
                        .HasComment("ç©æç±»åï¼æä¸¾å¼ï¼");

                    b.Property<decimal>("OuterDiameter")
                        .HasColumnType("decimal(18,2)")
                        .HasComment("å¤å¾ï¼åä½ï¼mmï¼");

                    b.Property<string>("PrimaryUnit")
                        .HasMaxLength(20)
                        .HasColumnType("varchar(20)")
                        .HasComment("ä¸»åä½ï¼å¦ï¼kgãmãä¸ªï¼");

                    b.Property<int>("PurchaseType")
                        .HasColumnType("int")
                        .HasComment("éè´ç±»åï¼æä¸¾å¼ï¼");

                    b.Property<string>("RedundantField1")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("åä½åæ®µ1 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField2")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("åä½åæ®µ2 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField3")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("åä½åæ®µ3 - é¢çæ©å±ç¨é");

                    b.Property<string>("Remark")
                        .HasMaxLength(500)
                        .HasColumnType("varchar(500)")
                        .HasComment("å¤æ³¨");

                    b.Property<int>("Sort")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasDefaultValue(0)
                        .HasComment("æåº");

                    b.Property<string>("Standard")
                        .HasMaxLength(128)
                        .HasColumnType("varchar(128)")
                        .HasComment("è§æ ¼/æ åï¼å¦ï¼GB/T 8163-2018ï¼");

                    b.Property<decimal>("WallThickness")
                        .HasColumnType("decimal(18,2)")
                        .HasComment("å£åï¼åä½ï¼mmï¼");

                    b.HasKey("Id");

                    b.HasIndex("MaterialCode")
                        .IsUnique();

                    b.HasIndex("MaterialName");

                    b.HasIndex("MaterialType");

                    b.HasIndex("PurchaseType");

                    b.ToTable("scms_wmsmaterials", (string)null);

                    b.HasComment("ç©æåºç¡ä¿¡æ¯è¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialStocks.WmsMaterialStock", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("char(36)");

                    b.Property<string>("AreaCode")
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("åºåç¼å·");

                    b.Property<string>("AreaName")
                        .HasMaxLength(128)
                        .HasColumnType("varchar(128)")
                        .HasComment("åºåºåç§°");

                    b.Property<int?>("CheckStatus")
                        .HasColumnType("int")
                        .HasComment("æ£éªç¶æ(1:æªæ£éª,2:æ£éªéè¿,3:æ£éªä¸éè¿)");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    b.Property<string>("ContainerNo")
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("å®¹å¨ç¼å·");

                    b.Property<int>("ContainerStatus")
                        .HasColumnType("int")
                        .HasComment("å®¹å¨ç¶æ");

                    b.Property<int>("ContainerType")
                        .HasColumnType("int")
                        .HasComment("å®¹å¨ç±»å");

                    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<int>("EmptyContainer")
                        .HasColumnType("int")
                        .HasComment("æ¯å¦ç©ºæ(2:å¦,1:æ¯)");

                    b.Property<string>("ExtraProperties")
                        .HasColumnType("longtext")
                        .HasColumnName("ExtraProperties");

                    b.Property<DateTime?>("InStockTime")
                        .HasColumnType("datetime(6)")
                        .HasComment("å¥åºæ¶é´");

                    b.Property<bool>("IsDeleted")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("tinyint(1)")
                        .HasDefaultValue(false)
                        .HasColumnName("IsDeleted");

                    b.Property<bool?>("IsDisabled")
                        .HasColumnType("tinyint(1)")
                        .HasComment("æ¯å¦ç¦ç¨");

                    b.Property<int>("IsLock")
                        .HasColumnType("int")
                        .HasComment("æ¯å¦éå®(2:æªéå®,1:å·²éå®)");

                    b.Property<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.Property<string>("MaterialBatch")
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("ç©ææ¹æ¬¡");

                    b.Property<string>("MaterialId")
                        .IsRequired()
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("ç©æID");

                    b.Property<string>("MaterialModel")
                        .HasMaxLength(128)
                        .HasColumnType("varchar(128)")
                        .HasComment("æºå/è§æ ¼");

                    b.Property<string>("MaterialName")
                        .IsRequired()
                        .HasMaxLength(128)
                        .HasColumnType("varchar(128)")
                        .HasComment("ç©æåç§°");

                    b.Property<string>("MaterialNo")
                        .IsRequired()
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("ç©æç¼å·");

                    b.Property<string>("PlaceNo")
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("åºä½ç¼å·");

                    b.Property<int>("PlaceStatus")
                        .HasColumnType("int")
                        .HasComment("åºä½ç¶æ;");

                    b.Property<string>("RedundantField1")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("åä½åæ®µ1 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField2")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("åä½åæ®µ2 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField3")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("åä½åæ®µ3 - é¢çæ©å±ç¨é");

                    b.Property<string>("Remark")
                        .HasMaxLength(500)
                        .HasColumnType("varchar(500)")
                        .HasComment("å¤æ³¨");

                    b.Property<int>("Sort")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasDefaultValue(0)
                        .HasComment("æåº");

                    b.Property<int>("StockNumber")
                        .HasColumnType("int")
                        .HasComment("åºåæ°é");

                    b.Property<int>("StorageTypeNo")
                        .HasColumnType("int")
                        .HasComment("åºä½ç±»å");

                    b.Property<string>("SupplierCode")
                        .HasMaxLength(64)
                        .HasColumnType("varchar(64)")
                        .HasComment("ä¾åºåç¼å·");

                    b.HasKey("Id");

                    b.HasIndex("AreaCode");

                    b.HasIndex("ContainerNo");

                    b.HasIndex("MaterialName");

                    b.HasIndex("MaterialNo");

                    b.HasIndex("PlaceNo");

                    b.HasIndex("MaterialBatch", "SupplierCode");

                    b.ToTable("scms_wmsmaterialstocks", (string)null);

                    b.HasComment("WMSç©æåºåè¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsPlaces.WmsPlace", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("char(36)");

                    b.Property<int>("Aisle")
                        .HasColumnType("int")
                        .HasComment("å··é");

                    b.Property<string>("AreaCode")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("æå¨åºåº");

                    b.Property<int>("ColumnNo")
                        .HasColumnType("int")
                        .HasComment("å");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    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<int>("EmptyContainer")
                        .HasColumnType("int")
                        .HasComment("æ¯å¦ç©ºæ");

                    b.Property<string>("ExtraProperties")
                        .HasColumnType("longtext")
                        .HasColumnName("ExtraProperties");

                    b.Property<bool>("IsDeleted")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("tinyint(1)")
                        .HasDefaultValue(false)
                        .HasColumnName("IsDeleted");

                    b.Property<bool?>("IsDisabled")
                        .HasColumnType("tinyint(1)")
                        .HasComment("æ¯å¦ç¦ç¨");

                    b.Property<int>("Islock")
                        .HasColumnType("int")
                        .HasComment("æ¯å¦éå®");

                    b.Property<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.Property<int>("LayerNo")
                        .HasColumnType("int")
                        .HasComment("å±");

                    b.Property<string>("PlaceNo")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ç¼å·");

                    b.Property<int>("PlaceStatus")
                        .HasColumnType("int")
                        .HasComment("è´§ä½ç¶æ");

                    b.Property<string>("RedundantField1")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åä½åæ®µ1 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField2")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åä½åæ®µ2 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField3")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åä½åæ®µ3 - é¢çæ©å±ç¨é");

                    b.Property<string>("Remark")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("å¤æ³¨");

                    b.Property<int>("RowNo")
                        .HasColumnType("int")
                        .HasComment("æ");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
                        .HasComment("æåº");

                    b.Property<int>("StorageTypeNo")
                        .HasColumnType("int")
                        .HasComment("è´§ä½ç±»å");

                    b.HasKey("Id");

                    b.HasIndex("AreaCode");

                    b.HasIndex("PlaceNo")
                        .IsUnique();

                    b.HasIndex("PlaceStatus");

                    b.HasIndex("StorageTypeNo");

                    b.ToTable("scms_wmsplaces", (string)null);

                    b.HasComment("åºä½è¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsStores.WmsStore", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("char(36)");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    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")
                        .HasColumnType("tinyint(1)")
                        .HasComment("æ¯å¦ç¦ç¨");

                    b.Property<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.Property<string>("RedundantField1")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åä½åæ®µ1 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField2")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åä½åæ®µ2 - é¢çæ©å±ç¨é");

                    b.Property<string>("RedundantField3")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("åä½åæ®µ3 - é¢çæ©å±ç¨é");

                    b.Property<string>("Remark")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("å¤æ³¨");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
                        .HasComment("æåº");

                    b.Property<string>("StoreCode")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ä»åºä»£ç ");

                    b.Property<string>("StoreName")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("ä»åºåç§°");

                    b.HasKey("Id");

                    b.HasIndex("StoreName");

                    b.ToTable("scms_wmsstores", (string)null);

                    b.HasComment("ä»åºä¿¡æ¯è¡¨");
                });
#pragma warning restore 612, 618
        }
    }
}

 HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250506054001_InitialCreate7.cs

¶Ô±ÈÐÂÎÄ¼þ
@@ -0,0 +1,150 @@
ï»¿using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace CMS.Plugin.HIAWms.MySQL.Migrations
{
    public partial class InitialCreate7 : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "scms_wmscontainerplaces",
                columns: table => new
                {
                    PlaceNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "åºä½ç¼ç ")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    ContainerNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "æçç¼å·")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
                    ExtraProperties = table.Column<string>(type: "longtext", nullable: true)
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true)
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false),
                    CreatorId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
                    LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true),
                    LastModifierId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
                    IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false),
                    DeleterId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
                    DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_scms_wmscontainerplaces", x => new { x.PlaceNo, x.ContainerNo });
                },
                comment: "å®¹å¨åºä½å³ç³»è¡¨")
                .Annotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.CreateTable(
                name: "scms_wmsinoutstockrecords",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
                    OrderNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "åæ®ç¼å·")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    MaterialName = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "ç©æåç§°")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    MaterialNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "ç©æä»¶å·")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    StockType = table.Column<int>(type: "int", nullable: false, comment: "æä½ç±»å"),
                    ContainerNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "å®¹å¨ç¼å·")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    MaterialModel = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "æºå")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    OperateTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "æä½æ¶é´"),
                    Remark = table.Column<string>(type: "varchar(500)", maxLength: 500, nullable: true, comment: "å¤æ³¨")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    MaterialId = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "ç©æID")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    TaskNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "ä»»å¡å·")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    SourcePlace = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "èµ·å§åºä½")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    ToPlace = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "ç®æ åºä½")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    ExtraProperties = table.Column<string>(type: "longtext", nullable: true)
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true)
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false),
                    CreatorId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
                    LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true),
                    LastModifierId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
                    IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false),
                    DeleterId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
                    DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_scms_wmsinoutstockrecords", x => x.Id);
                },
                comment: "åºå¥åºè®°å½è¡¨")
                .Annotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmsmaterialstocks_MaterialNo",
                table: "scms_wmsmaterialstocks",
                column: "MaterialNo");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmscontainerplaces_ContainerNo",
                table: "scms_wmscontainerplaces",
                column: "ContainerNo");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmscontainerplaces_PlaceNo",
                table: "scms_wmscontainerplaces",
                column: "PlaceNo");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmsinoutstockrecords_ContainerNo",
                table: "scms_wmsinoutstockrecords",
                column: "ContainerNo");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmsinoutstockrecords_MaterialId",
                table: "scms_wmsinoutstockrecords",
                column: "MaterialId");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmsinoutstockrecords_MaterialNo",
                table: "scms_wmsinoutstockrecords",
                column: "MaterialNo");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmsinoutstockrecords_OperateTime",
                table: "scms_wmsinoutstockrecords",
                column: "OperateTime");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmsinoutstockrecords_OrderNo",
                table: "scms_wmsinoutstockrecords",
                column: "OrderNo");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmsinoutstockrecords_StockType",
                table: "scms_wmsinoutstockrecords",
                column: "StockType");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmsinoutstockrecords_TaskNo",
                table: "scms_wmsinoutstockrecords",
                column: "TaskNo");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "scms_wmscontainerplaces");

            migrationBuilder.DropTable(
                name: "scms_wmsinoutstockrecords");

            migrationBuilder.DropIndex(
                name: "IX_scms_wmsmaterialstocks_MaterialNo",
                table: "scms_wmsmaterialstocks");
        }
    }
}

 HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs

@@ -139,6 +139,72 @@
                    b.HasComment("åºåºè¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainerPlaces.WmsContainerPlace", b =>
                {
                    b.Property<string>("PlaceNo")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("åºä½ç¼ç ");

                    b.Property<string>("ContainerNo")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("æçç¼å·");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    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<Guid>("Id")
                        .HasColumnType("char(36)");

                    b.Property<bool>("IsDeleted")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("tinyint(1)")
                        .HasDefaultValue(false)
                        .HasColumnName("IsDeleted");

                    b.Property<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.HasKey("PlaceNo", "ContainerNo");

                    b.HasIndex("ContainerNo");

                    b.HasIndex("PlaceNo");

                    b.ToTable("scms_wmscontainerplaces", (string)null);

                    b.HasComment("å®¹å¨åºä½å³ç³»è¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainers.WmsContainer", b =>
                {
                    b.Property<Guid>("Id")
@@ -282,6 +348,135 @@
                    b.ToTable("scms_wmscontainers", (string)null);

                    b.HasComment("æçä¿¡æ¯è¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsInOutStockRecords.WmsInOutStockRecord", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("char(36)");

                    b.Property<string>("ConcurrencyStamp")
                        .IsConcurrencyToken()
                        .HasMaxLength(40)
                        .HasColumnType("varchar(40)")
                        .HasColumnName("ConcurrencyStamp");

                    b.Property<string>("ContainerNo")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("å®¹å¨ç¼å·");

                    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<DateTime?>("LastModificationTime")
                        .HasColumnType("datetime(6)")
                        .HasColumnName("LastModificationTime");

                    b.Property<Guid?>("LastModifierId")
                        .HasColumnType("char(36)")
                        .HasColumnName("LastModifierId");

                    b.Property<string>("MaterialId")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ç©æID");

                    b.Property<string>("MaterialModel")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("æºå");

                    b.Property<string>("MaterialName")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasComment("ç©æåç§°");

                    b.Property<string>("MaterialNo")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ç©æä»¶å·");

                    b.Property<DateTime?>("OperateTime")
                        .HasColumnType("datetime(6)")
                        .HasComment("æä½æ¶é´");

                    b.Property<string>("OrderNo")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("åæ®ç¼å·");

                    b.Property<string>("Remark")
                        .HasMaxLength(500)
                        .HasColumnType("varchar(500)")
                        .HasComment("å¤æ³¨");

                    b.Property<string>("SourcePlace")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("èµ·å§åºä½");

                    b.Property<int>("StockType")
                        .HasColumnType("int")
                        .HasComment("æä½ç±»å");

                    b.Property<string>("TaskNo")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ä»»å¡å·");

                    b.Property<string>("ToPlace")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasComment("ç®æ åºä½");

                    b.HasKey("Id");

                    b.HasIndex("ContainerNo");

                    b.HasIndex("MaterialId");

                    b.HasIndex("MaterialNo");

                    b.HasIndex("OperateTime");

                    b.HasIndex("OrderNo");

                    b.HasIndex("StockType");

                    b.HasIndex("TaskNo");

                    b.ToTable("scms_wmsinoutstockrecords", (string)null);

                    b.HasComment("åºå¥åºè®°å½è¡¨");
                });

            modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialInfos.WmsMaterialInfo", b =>
@@ -757,6 +952,8 @@

                    b.HasIndex("MaterialName");

                    b.HasIndex("MaterialNo");

                    b.HasIndex("PlaceNo");

                    b.HasIndex("MaterialBatch", "SupplierCode");

 Weben_CMS×¨ÓÃ´úÂëÉú³ÉÆ÷/Code/App.config

@@ -12,6 +12,7 @@
    <add name="GSiemens_LES" connectionString="Data Source=localhost;Initial Catalog=GSiemens_LES;Persist Security Info=True;User ID=sa;Password=123abc.com" />
    <add name="GSiemens_WIP" connectionString="Data Source=.;Initial Catalog=GSiemens_WIP;Persist Security Info=True;User ID=sa;Password=123abc.com" />
    <add name="LocalhostConn" connectionString="Data Source=shaocx;Initial Catalog=SOADB;User ID=sa;Password=1111" />
    <add name="WmsMysql" connectionString="Data Source=localhost;Initial Catalog=cms.plugin.hiawms;User ID=sa;Password=123abc.com" />
  </connectionStrings>
<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8" /></startup>
  <runtime>

			@@ -5,13 +5,14 @@
			using System.Linq;
			using System.Text;
			using System.Threading.Tasks;
			using Volo.Abp.Domain.Entities.Auditing;

			namespace CMS.Plugin.HIAWms.Domain.WmsContainerPlaces
			{
			/// <summary>
			/// åºä½å®¹å¨å³ç³»
			/// </summary>
			public class WmsContainerPlace
			public class WmsContainerPlace : FullAuditedAggregateRoot<Guid>
			{
			/// <summary>
			/// åºä½ç¼ç

			@@ -4,13 +4,14 @@
			using System.Linq;
			using System.Text;
			using System.Threading.Tasks;
			using Volo.Abp.Domain.Entities.Auditing;

			namespace CMS.Plugin.HIAWms.Domain.WmsInOutStockRecords
			{
			/// <summary>
			/// åºå¥åºè®°å½.
			/// </summary>
			public class WmsInOutStockRecord
			public class WmsInOutStockRecord : FullAuditedAggregateRoot<Guid>
			{
			/// <summary>
			/// åæ®ç¼å·

			@@ -46,7 +46,8 @@
			.HasComment("å®¹å¨åºä½å³ç³»è¡¨");

			b.ConfigureByConvention();

			// ä¸»é®éç½®
			b.HasKey(x => x.Id);
			// Properties
			b.Property(x => x.PlaceNo)
			.HasMaxLength(50)

			@@ -47,7 +47,8 @@
			.HasComment("åºå¥åºè®°å½è¡¨");

			b.ConfigureByConvention();

			// ä¸»é®éç½®
			b.HasKey(x => x.Id);
			// Properties
			b.Property(x => x.OrderNo)
			.HasMaxLength(50)

¶Ô±ÈÐÂÎÄ¼þ
			@@ -0,0 +1,150 @@
			ï»¿using System;
			using Microsoft.EntityFrameworkCore.Migrations;

			#nullable disable

			namespace CMS.Plugin.HIAWms.MySQL.Migrations
			{
			public partial class InitialCreate7 : Migration
			{
			protected override void Up(MigrationBuilder migrationBuilder)
			{
			migrationBuilder.CreateTable(
			name: "scms_wmscontainerplaces",
			columns: table => new
			{
			PlaceNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "åºä½ç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ContainerNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "æçç¼å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
			ExtraProperties = table.Column<string>(type: "longtext", nullable: true)
			.Annotation("MySql:CharSet", "utf8mb4"),
			ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true)
			.Annotation("MySql:CharSet", "utf8mb4"),
			CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false),
			CreatorId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
			LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true),
			LastModifierId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
			IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false),
			DeleterId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
			DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true)
			},
			constraints: table =>
			{
			table.PrimaryKey("PK_scms_wmscontainerplaces", x => new { x.PlaceNo, x.ContainerNo });
			},
			comment: "å®¹å¨åºä½å³ç³»è¡¨")
			.Annotation("MySql:CharSet", "utf8mb4");

			migrationBuilder.CreateTable(
			name: "scms_wmsinoutstockrecords",
			columns: table => new
			{
			Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
			OrderNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "åæ®ç¼å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			MaterialName = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "ç©æåç§°")
			.Annotation("MySql:CharSet", "utf8mb4"),
			MaterialNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "ç©æä»¶å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			StockType = table.Column<int>(type: "int", nullable: false, comment: "æä½ç±»å"),
			ContainerNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "å®¹å¨ç¼å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			MaterialModel = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "æºå")
			.Annotation("MySql:CharSet", "utf8mb4"),
			OperateTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "æä½æ¶é´"),
			Remark = table.Column<string>(type: "varchar(500)", maxLength: 500, nullable: true, comment: "å¤æ³¨")
			.Annotation("MySql:CharSet", "utf8mb4"),
			MaterialId = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "ç©æID")
			.Annotation("MySql:CharSet", "utf8mb4"),
			TaskNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "ä»»å¡å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			SourcePlace = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "èµ·å§åºä½")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ToPlace = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "ç®æ åºä½")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ExtraProperties = table.Column<string>(type: "longtext", nullable: true)
			.Annotation("MySql:CharSet", "utf8mb4"),
			ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true)
			.Annotation("MySql:CharSet", "utf8mb4"),
			CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false),
			CreatorId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
			LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true),
			LastModifierId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
			IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false),
			DeleterId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
			DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true)
			},
			constraints: table =>
			{
			table.PrimaryKey("PK_scms_wmsinoutstockrecords", x => x.Id);
			},
			comment: "åºå¥åºè®°å½è¡¨")
			.Annotation("MySql:CharSet", "utf8mb4");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmsmaterialstocks_MaterialNo",
			table: "scms_wmsmaterialstocks",
			column: "MaterialNo");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmscontainerplaces_ContainerNo",
			table: "scms_wmscontainerplaces",
			column: "ContainerNo");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmscontainerplaces_PlaceNo",
			table: "scms_wmscontainerplaces",
			column: "PlaceNo");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmsinoutstockrecords_ContainerNo",
			table: "scms_wmsinoutstockrecords",
			column: "ContainerNo");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmsinoutstockrecords_MaterialId",
			table: "scms_wmsinoutstockrecords",
			column: "MaterialId");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmsinoutstockrecords_MaterialNo",
			table: "scms_wmsinoutstockrecords",
			column: "MaterialNo");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmsinoutstockrecords_OperateTime",
			table: "scms_wmsinoutstockrecords",
			column: "OperateTime");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmsinoutstockrecords_OrderNo",
			table: "scms_wmsinoutstockrecords",
			column: "OrderNo");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmsinoutstockrecords_StockType",
			table: "scms_wmsinoutstockrecords",
			column: "StockType");

			migrationBuilder.CreateIndex(
			name: "IX_scms_wmsinoutstockrecords_TaskNo",
			table: "scms_wmsinoutstockrecords",
			column: "TaskNo");
			}

			protected override void Down(MigrationBuilder migrationBuilder)
			{
			migrationBuilder.DropTable(
			name: "scms_wmscontainerplaces");

			migrationBuilder.DropTable(
			name: "scms_wmsinoutstockrecords");

			migrationBuilder.DropIndex(
			name: "IX_scms_wmsmaterialstocks_MaterialNo",
			table: "scms_wmsmaterialstocks");
			}
			}
			}

			@@ -139,6 +139,72 @@
			b.HasComment("åºåºè¡¨");
			});

			modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainerPlaces.WmsContainerPlace", b =>
			{
			b.Property<string>("PlaceNo")
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("åºä½ç¼ç ");

			b.Property<string>("ContainerNo")
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("æçç¼å·");

			b.Property<string>("ConcurrencyStamp")
			.IsConcurrencyToken()
			.HasMaxLength(40)
			.HasColumnType("varchar(40)")
			.HasColumnName("ConcurrencyStamp");

			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<Guid>("Id")
			.HasColumnType("char(36)");

			b.Property<bool>("IsDeleted")
			.ValueGeneratedOnAdd()
			.HasColumnType("tinyint(1)")
			.HasDefaultValue(false)
			.HasColumnName("IsDeleted");

			b.Property<DateTime?>("LastModificationTime")
			.HasColumnType("datetime(6)")
			.HasColumnName("LastModificationTime");

			b.Property<Guid?>("LastModifierId")
			.HasColumnType("char(36)")
			.HasColumnName("LastModifierId");

			b.HasKey("PlaceNo", "ContainerNo");

			b.HasIndex("ContainerNo");

			b.HasIndex("PlaceNo");

			b.ToTable("scms_wmscontainerplaces", (string)null);

			b.HasComment("å®¹å¨åºä½å³ç³»è¡¨");
			});

			modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainers.WmsContainer", b =>
			{
			b.Property<Guid>("Id")
			@@ -282,6 +348,135 @@
			b.ToTable("scms_wmscontainers", (string)null);

			b.HasComment("æçä¿¡æ¯è¡¨");
			});

			modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsInOutStockRecords.WmsInOutStockRecord", b =>
			{
			b.Property<Guid>("Id")
			.ValueGeneratedOnAdd()
			.HasColumnType("char(36)");

			b.Property<string>("ConcurrencyStamp")
			.IsConcurrencyToken()
			.HasMaxLength(40)
			.HasColumnType("varchar(40)")
			.HasColumnName("ConcurrencyStamp");

			b.Property<string>("ContainerNo")
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("å®¹å¨ç¼å·");

			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<DateTime?>("LastModificationTime")
			.HasColumnType("datetime(6)")
			.HasColumnName("LastModificationTime");

			b.Property<Guid?>("LastModifierId")
			.HasColumnType("char(36)")
			.HasColumnName("LastModifierId");

			b.Property<string>("MaterialId")
			.IsRequired()
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("ç©æID");

			b.Property<string>("MaterialModel")
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("æºå");

			b.Property<string>("MaterialName")
			.HasMaxLength(100)
			.HasColumnType("varchar(100)")
			.HasComment("ç©æåç§°");

			b.Property<string>("MaterialNo")
			.IsRequired()
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("ç©æä»¶å·");

			b.Property<DateTime?>("OperateTime")
			.HasColumnType("datetime(6)")
			.HasComment("æä½æ¶é´");

			b.Property<string>("OrderNo")
			.IsRequired()
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("åæ®ç¼å·");

			b.Property<string>("Remark")
			.HasMaxLength(500)
			.HasColumnType("varchar(500)")
			.HasComment("å¤æ³¨");

			b.Property<string>("SourcePlace")
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("èµ·å§åºä½");

			b.Property<int>("StockType")
			.HasColumnType("int")
			.HasComment("æä½ç±»å");

			b.Property<string>("TaskNo")
			.IsRequired()
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("ä»»å¡å·");

			b.Property<string>("ToPlace")
			.HasMaxLength(50)
			.HasColumnType("varchar(50)")
			.HasComment("ç®æ åºä½");

			b.HasKey("Id");

			b.HasIndex("ContainerNo");

			b.HasIndex("MaterialId");

			b.HasIndex("MaterialNo");

			b.HasIndex("OperateTime");

			b.HasIndex("OrderNo");

			b.HasIndex("StockType");

			b.HasIndex("TaskNo");

			b.ToTable("scms_wmsinoutstockrecords", (string)null);

			b.HasComment("åºå¥åºè®°å½è¡¨");
			});

			modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialInfos.WmsMaterialInfo", b =>
			@@ -757,6 +952,8 @@

			b.HasIndex("MaterialName");

			b.HasIndex("MaterialNo");

			b.HasIndex("PlaceNo");

			b.HasIndex("MaterialBatch", "SupplierCode");

			@@ -12,6 +12,7 @@
			<add name="GSiemens_LES" connectionString="Data Source=localhost;Initial Catalog=GSiemens_LES;Persist Security Info=True;User ID=sa;Password=123abc.com" />
			<add name="GSiemens_WIP" connectionString="Data Source=.;Initial Catalog=GSiemens_WIP;Persist Security Info=True;User ID=sa;Password=123abc.com" />
			<add name="LocalhostConn" connectionString="Data Source=shaocx;Initial Catalog=SOADB;User ID=sa;Password=1111" />
			<add name="WmsMysql" connectionString="Data Source=localhost;Initial Catalog=cms.plugin.hiawms;User ID=sa;Password=123abc.com" />
			</connectionStrings>
			<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8" /></startup>
			<runtime>