From 3a9f4f83e203e927fa2411d6a29a07ac9abc722c Mon Sep 17 00:00:00 2001
From: zs <zhousong@weben-smart.com>
Date: 周一, 28 4月 2025 17:41:28 +0800
Subject: [PATCH] 数据库连接同步
---
HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/appsettings.json | 2
/dev/null | 528 ----------------------------------------------------
HIAWms/server/src/CMS.Plugin.HIAWms.SqlServer/CMSPluginDbContext.cs | 4
HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMSPluginDbContext.cs | 4
HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMS.Plugin.HIAWms.MySQL.csproj | 4
HIAWms/server/src/CMS.Plugin.HIAWms.PostgreSql/CMSPluginDbContext.cs | 5
6 files changed, 13 insertions(+), 534 deletions(-)
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/appsettings.json b/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/appsettings.json
index 9da12fe..58af186 100644
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/appsettings.json
+++ b/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/appsettings.json
@@ -1,5 +1,5 @@
{
"ConnectionStrings": {
- "Default": "Server=127.0.0.1;Database=CMS.Plugin.HIAWms;User ID=root;Password=123456"
+ "Default": "Server=127.0.0.1;Database=CMS.Plugin.HIAWms;User ID=root;Password=123abc.com"
}
}
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMS.Plugin.HIAWms.MySQL.csproj b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMS.Plugin.HIAWms.MySQL.csproj
index bec4d76..4cf3215 100644
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMS.Plugin.HIAWms.MySQL.csproj
+++ b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMS.Plugin.HIAWms.MySQL.csproj
@@ -23,8 +23,4 @@
<ProjectReference Include="..\CMS.Plugin.HIAWms.EntityFrameworkCore\CMS.Plugin.HIAWms.EntityFrameworkCore.csproj" />
</ItemGroup>
- <ItemGroup>
- <Folder Include="Migrations\" />
- </ItemGroup>
-
</Project>
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMSPluginDbContext.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMSPluginDbContext.cs
index 4791566..6157a9d 100644
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMSPluginDbContext.cs
+++ b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/CMSPluginDbContext.cs
@@ -33,6 +33,10 @@
/* Include modules to your migration db context */
builder.ConfigureWmsContainer();
+ builder.ConfigureWmsStore();
+ builder.ConfigureWmsArea();
+ builder.ConfigureWmsPlace();
+ builder.ConfigureWmsContainer();
/* Configure your own tables/entities inside here */
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250428085640_InitialCreate.Designer.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250428085640_InitialCreate.Designer.cs
deleted file mode 100644
index a8ae96c..0000000
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250428085640_InitialCreate.Designer.cs
+++ /dev/null
@@ -1,530 +0,0 @@
-锘�// <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("20250428085640_InitialCreate")]
- partial class InitialCreate
- {
- 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("Wms_Area");
- });
-
- 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<bool>("IsMainBranch")
- .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<decimal>("Length")
- .HasColumnType("decimal(18,2)")
- .HasComment("闀垮害锛堝崟浣嶏細m锛�");
-
- b.Property<string>("MaterialCode")
- .IsRequired()
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .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銆乵銆佷釜锛�");
-
- 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("瑙勬牸/鏍囧噯锛堝锛欸B/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_wms_materials", (string)null);
-
- b.HasComment("鐗╂枡鍩虹淇℃伅琛�");
- });
-
- 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("Wms_Place");
- });
-
- 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("Wms_Store");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250428085640_InitialCreate.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250428085640_InitialCreate.cs
deleted file mode 100644
index 25b251e..0000000
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250428085640_InitialCreate.cs
+++ /dev/null
@@ -1,267 +0,0 @@
-锘縰sing System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace CMS.Plugin.HIAWms.MySQL.Migrations
-{
- public partial class InitialCreate : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.AlterDatabase()
- .Annotation("MySql:CharSet", "utf8mb4");
-
- migrationBuilder.CreateTable(
- name: "scms_wms_materials",
- columns: table => new
- {
- Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
- MaterialCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "鐗╂枡缂栫爜锛堝敮涓�鏍囪瘑锛�")
- .Annotation("MySql:CharSet", "utf8mb4"),
- MaterialName = table.Column<string>(type: "varchar(128)", maxLength: 128, nullable: false, comment: "鐗╂枡鍚嶇О")
- .Annotation("MySql:CharSet", "utf8mb4"),
- PurchaseType = table.Column<int>(type: "int", nullable: false, comment: "閲囪喘绫诲瀷锛堟灇涓惧�硷級"),
- MaterialType = table.Column<int>(type: "int", nullable: false, comment: "鐗╂枡绫诲瀷锛堟灇涓惧�硷級"),
- PrimaryUnit = table.Column<string>(type: "varchar(20)", maxLength: 20, nullable: true, comment: "涓诲崟浣嶏紙濡傦細kg銆乵銆佷釜锛�")
- .Annotation("MySql:CharSet", "utf8mb4"),
- Standard = table.Column<string>(type: "varchar(128)", maxLength: 128, nullable: true, comment: "瑙勬牸/鏍囧噯锛堝锛欸B/T 8163-2018锛�")
- .Annotation("MySql:CharSet", "utf8mb4"),
- OuterDiameter = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "澶栧緞锛堝崟浣嶏細mm锛�"),
- WallThickness = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "澹佸帤锛堝崟浣嶏細mm锛�"),
- MaterialQuality = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "鏉愯川锛堝锛�304涓嶉攬閽級")
- .Annotation("MySql:CharSet", "utf8mb4"),
- Length = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "闀垮害锛堝崟浣嶏細m锛�"),
- IsMainBranch = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false, comment: "鏄惁涓轰富鏀"),
- Factory = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "鐢熶骇宸ュ巶")
- .Annotation("MySql:CharSet", "utf8mb4"),
- Certification = table.Column<string>(type: "varchar(128)", maxLength: 128, nullable: true, comment: "璇佷功缂栧彿")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField1 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "鍐椾綑瀛楁1 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField2 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "鍐椾綑瀛楁2 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField3 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "鍐椾綑瀛楁3 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- Sort = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "鎺掑簭"),
- Remark = table.Column<string>(type: "varchar(500)", maxLength: 500, nullable: true, comment: "澶囨敞")
- .Annotation("MySql:CharSet", "utf8mb4"),
- IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, defaultValue: false, comment: "鏄惁绂佺敤"),
- 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_wms_materials", x => x.Id);
- },
- comment: "鐗╂枡鍩虹淇℃伅琛�")
- .Annotation("MySql:CharSet", "utf8mb4");
-
- migrationBuilder.CreateTable(
- name: "scms_wmsareas",
- columns: table => new
- {
- Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
- AreaNo = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "搴撳尯缂栧彿")
- .Annotation("MySql:CharSet", "utf8mb4"),
- AreaName = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: false, comment: "搴撳尯鍚嶇О")
- .Annotation("MySql:CharSet", "utf8mb4"),
- AreaDesc = table.Column<string>(type: "varchar(200)", maxLength: 200, nullable: true, comment: "鎻忚堪")
- .Annotation("MySql:CharSet", "utf8mb4"),
- AreaStatus = table.Column<int>(type: "int", nullable: false, comment: "搴撳尯鐘舵��"),
- AreaType = table.Column<int>(type: "int", nullable: false, comment: "搴撳尯绫诲瀷"),
- RedundantField1 = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "鍐椾綑瀛楁1 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField2 = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "鍐椾綑瀛楁2 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField3 = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "鍐椾綑瀛楁3 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- StoreCode = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "浠撳簱浠ｇ爜")
- .Annotation("MySql:CharSet", "utf8mb4"),
- StoreName = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "浠撳簱鍚嶇О")
- .Annotation("MySql:CharSet", "utf8mb4"),
- Sort = table.Column<int>(type: "int", nullable: false, comment: "鎺掑簭"),
- Remark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "澶囨敞")
- .Annotation("MySql:CharSet", "utf8mb4"),
- IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, comment: "鏄惁绂佺敤"),
- 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_wmsareas", x => x.Id);
- },
- comment: "Wms_Area")
- .Annotation("MySql:CharSet", "utf8mb4");
-
- migrationBuilder.CreateTable(
- name: "scms_wmsplaces",
- columns: table => new
- {
- Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
- PlaceNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "缂栧彿")
- .Annotation("MySql:CharSet", "utf8mb4"),
- StorageTypeNo = table.Column<int>(type: "int", nullable: false, comment: "璐т綅绫诲瀷"),
- PlaceStatus = table.Column<int>(type: "int", nullable: false, comment: "璐т綅鐘舵��"),
- AreaCode = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "鎵�鍦ㄥ簱鍖�")
- .Annotation("MySql:CharSet", "utf8mb4"),
- Aisle = table.Column<int>(type: "int", nullable: false, comment: "宸烽亾"),
- RowNo = table.Column<int>(type: "int", nullable: false, comment: "鎺�"),
- ColumnNo = table.Column<int>(type: "int", nullable: false, comment: "鍒�"),
- LayerNo = table.Column<int>(type: "int", nullable: false, comment: "灞�"),
- Islock = table.Column<int>(type: "int", nullable: false, comment: "鏄惁閿佸畾"),
- EmptyContainer = table.Column<int>(type: "int", nullable: false, comment: "鏄惁绌烘墭"),
- RedundantField1 = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "鍐椾綑瀛楁1 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField2 = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "鍐椾綑瀛楁2 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField3 = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "鍐椾綑瀛楁3 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- Sort = table.Column<int>(type: "int", nullable: false, comment: "鎺掑簭"),
- Remark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "澶囨敞")
- .Annotation("MySql:CharSet", "utf8mb4"),
- IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, comment: "鏄惁绂佺敤"),
- 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_wmsplaces", x => x.Id);
- },
- comment: "Wms_Place")
- .Annotation("MySql:CharSet", "utf8mb4");
-
- migrationBuilder.CreateTable(
- name: "scms_wmsstores",
- columns: table => new
- {
- Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
- StoreCode = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "浠撳簱浠ｇ爜")
- .Annotation("MySql:CharSet", "utf8mb4"),
- StoreName = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "浠撳簱鍚嶇О")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField1 = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "鍐椾綑瀛楁1 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField2 = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "鍐椾綑瀛楁2 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- RedundantField3 = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "鍐椾綑瀛楁3 - 棰勭暀鎵╁睍鐢ㄩ��")
- .Annotation("MySql:CharSet", "utf8mb4"),
- Remark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "澶囨敞")
- .Annotation("MySql:CharSet", "utf8mb4"),
- Sort = table.Column<int>(type: "int", nullable: false, comment: "鎺掑簭"),
- IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, comment: "鏄惁绂佺敤"),
- 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_wmsstores", x => x.Id);
- },
- comment: "Wms_Store")
- .Annotation("MySql:CharSet", "utf8mb4");
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wms_materials_MaterialCode",
- table: "scms_wms_materials",
- column: "MaterialCode",
- unique: true);
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wms_materials_MaterialName",
- table: "scms_wms_materials",
- column: "MaterialName");
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wms_materials_MaterialType",
- table: "scms_wms_materials",
- column: "MaterialType");
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wms_materials_PurchaseType",
- table: "scms_wms_materials",
- column: "PurchaseType");
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wmsareas_AreaName",
- table: "scms_wmsareas",
- column: "AreaName");
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wmsplaces_AreaCode",
- table: "scms_wmsplaces",
- column: "AreaCode");
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wmsplaces_PlaceNo",
- table: "scms_wmsplaces",
- column: "PlaceNo",
- unique: true);
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wmsplaces_PlaceStatus",
- table: "scms_wmsplaces",
- column: "PlaceStatus");
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wmsplaces_StorageTypeNo",
- table: "scms_wmsplaces",
- column: "StorageTypeNo");
-
- migrationBuilder.CreateIndex(
- name: "IX_scms_wmsstores_StoreName",
- table: "scms_wmsstores",
- column: "StoreName");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "scms_wms_materials");
-
- migrationBuilder.DropTable(
- name: "scms_wmsareas");
-
- migrationBuilder.DropTable(
- name: "scms_wmsplaces");
-
- migrationBuilder.DropTable(
- name: "scms_wmsstores");
- }
- }
-}
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs
deleted file mode 100644
index 300e55d..0000000
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs
+++ /dev/null
@@ -1,528 +0,0 @@
-锘�// <auto-generated />
-using System;
-using CMS.Plugin.HIAWms.MySQL;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Volo.Abp.EntityFrameworkCore;
-
-#nullable disable
-
-namespace CMS.Plugin.HIAWms.MySQL.Migrations
-{
- [DbContext(typeof(CMSPluginDbContext))]
- partial class CMSPluginDbContextModelSnapshot : ModelSnapshot
- {
- protected override void BuildModel(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("Wms_Area");
- });
-
- 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<bool>("IsMainBranch")
- .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<decimal>("Length")
- .HasColumnType("decimal(18,2)")
- .HasComment("闀垮害锛堝崟浣嶏細m锛�");
-
- b.Property<string>("MaterialCode")
- .IsRequired()
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .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銆乵銆佷釜锛�");
-
- 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("瑙勬牸/鏍囧噯锛堝锛欸B/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_wms_materials", (string)null);
-
- b.HasComment("鐗╂枡鍩虹淇℃伅琛�");
- });
-
- 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("Wms_Place");
- });
-
- 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("Wms_Store");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.PostgreSql/CMSPluginDbContext.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.PostgreSql/CMSPluginDbContext.cs
index e1eed06..96f3122 100644
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.PostgreSql/CMSPluginDbContext.cs
+++ b/HIAWms/server/src/CMS.Plugin.HIAWms.PostgreSql/CMSPluginDbContext.cs
@@ -33,7 +33,10 @@
/* Include modules to your migration db context */
builder.ConfigureWmsContainer();
-
+ builder.ConfigureWmsStore();
+ builder.ConfigureWmsArea();
+ builder.ConfigureWmsPlace();
+ builder.ConfigureWmsContainer();
/* Configure your own tables/entities inside here */
//builder.Entity<YourEntity>(b =>
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.SqlServer/CMSPluginDbContext.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.SqlServer/CMSPluginDbContext.cs
index 33f2cb9..4a1c315 100644
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.SqlServer/CMSPluginDbContext.cs
+++ b/HIAWms/server/src/CMS.Plugin.HIAWms.SqlServer/CMSPluginDbContext.cs
@@ -33,6 +33,10 @@
/* Include modules to your migration db context */
builder.ConfigureWmsContainer();
+ builder.ConfigureWmsStore();
+ builder.ConfigureWmsArea();
+ builder.ConfigureWmsPlace();
+ builder.ConfigureWmsContainer();
/* Configure your own tables/entities inside here */
--
Gitblit v1.9.3