From 8e83181db5ff4463949c8a15e56a2163a5616845 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周四, 08 5月 2025 16:40:29 +0800
Subject: [PATCH] 第一版提交
---
Weben_CMS专用代码生成器/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250508083921_InitialCreate4.cs | 224 ++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 210 insertions(+), 14 deletions(-)
diff --git "a/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250429025531_InitialCreate.cs" "b/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250508083921_InitialCreate4.cs"
similarity index 64%
rename from "Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250429025531_InitialCreate.cs"
rename to "Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250508083921_InitialCreate4.cs"
index 60b9400..b17a88f 100644
--- "a/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250429025531_InitialCreate.cs"
+++ "b/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250508083921_InitialCreate4.cs"
@@ -5,7 +5,7 @@
namespace CMS.Plugin.HIAWms.MySQL.Migrations
{
- public partial class InitialCreate : Migration
+ public partial class InitialCreate4 : Migration
{
protected override void Up(MigrationBuilder migrationBuilder)
{
@@ -106,6 +106,54 @@
.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"),
+ 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_wmsinoutstockrecords", x => x.Id);
+ },
+ comment: "鍑哄叆搴撹褰曡〃")
+ .Annotation("MySql:CharSet", "utf8mb4");
+
+ migrationBuilder.CreateTable(
name: "scms_wmsmaterials",
columns: table => new
{
@@ -125,7 +173,7 @@
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: "鏄惁涓轰富鏀"),
+ IsMainBranch = table.Column<int>(type: "int", nullable: false, defaultValue: 2, 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: "璇佷功缂栧彿")
@@ -136,21 +184,25 @@
.Annotation("MySql:CharSet", "utf8mb4"),
RedundantField3 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "鍐椾綑瀛楁3 - 棰勭暀鎵╁睍鐢ㄩ��")
.Annotation("MySql:CharSet", "utf8mb4"),
+ ExtraProperties = table.Column<string>(type: "longtext", nullable: true, comment: "鎵╁睍灞炴��")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true, comment: "骞跺彂鎴�")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false, comment: "鍒涘缓鏃堕棿"),
+ CreatorId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "鍒涘缓浜篒D", collation: "ascii_general_ci"),
+ LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "淇敼鏃堕棿"),
+ LastModifierId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "淇敼浜篒D", collation: "ascii_general_ci"),
+ IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false, comment: "鏄惁鍒犻櫎"),
+ DeleterId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "鍒犻櫎浜篒D", collation: "ascii_general_ci"),
+ DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "鍒犻櫎鏃堕棿"),
+ CreatorName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "鍒涘缓浜�")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ LastModifierName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "淇敼浜�")
+ .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)
+ IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, defaultValue: false, comment: "鏄惁绂佺敤")
},
constraints: table =>
{
@@ -243,6 +295,58 @@
comment: "浠撳簱淇℃伅琛�")
.Annotation("MySql:CharSet", "utf8mb4");
+ migrationBuilder.CreateTable(
+ name: "scms_wmstasks",
+ columns: table => new
+ {
+ Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
+ TaskNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "浠诲姟鍙�")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ TaskType = table.Column<int>(type: "int", nullable: false, comment: "浠诲姟绫诲瀷"),
+ TaskLevel = table.Column<int>(type: "int", nullable: false, comment: "浠诲姟绛夌骇"),
+ TaskStatus = table.Column<int>(type: "int", nullable: false, comment: "浠诲姟鐘舵��"),
+ ContainerNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, 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"),
+ Aisle = table.Column<int>(type: "int", nullable: true, comment: "宸烽亾"),
+ DodeviceId = table.Column<int>(type: "int", nullable: true, comment: "鍫嗗灈鏈篒D"),
+ Dodevicetype = table.Column<int>(type: "int", nullable: false, comment: "璁惧绫诲瀷"),
+ TaskDodeviceStatus = table.Column<int>(type: "int", nullable: false, comment: "璁惧浠诲姟鐘舵��"),
+ IsRead = table.Column<bool>(type: "tinyint(1)", nullable: false, comment: "WCS鏄惁鍙互璇诲彇"),
+ SonTaskType = table.Column<int>(type: "int", nullable: true, comment: "瀛愪换鍔＄被鍨�"),
+ SourceOrderNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "鏉ユ簮鍗曟嵁鍙�")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ IsNextTask = table.Column<int>(type: "int", nullable: true, comment: "涓嬩釜浠诲姟鏄惁鐢熸垚鎴愬姛"),
+ MutableParam1 = table.Column<string>(type: "varchar(200)", maxLength: 200, nullable: true, comment: "鍙彉鍙橀噺1")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ MutableParam2 = table.Column<string>(type: "varchar(200)", maxLength: 200, nullable: true, comment: "鍙彉鍙橀噺2")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ MutableParam3 = table.Column<string>(type: "varchar(200)", maxLength: 200, nullable: true, comment: "鍙彉鍙橀噺3")
+ .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_wmstasks", x => x.Id);
+ },
+ comment: "浠诲姟琛�")
+ .Annotation("MySql:CharSet", "utf8mb4");
+
migrationBuilder.CreateIndex(
name: "IX_scms_wmsareas_AreaName",
table: "scms_wmsareas",
@@ -263,6 +367,41 @@
name: "IX_scms_wmscontainers_ContainerType",
table: "scms_wmscontainers",
column: "ContainerType");
+
+ 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");
migrationBuilder.CreateIndex(
name: "IX_scms_wmsmaterials_MaterialCode",
@@ -310,6 +449,57 @@
name: "IX_scms_wmsstores_StoreName",
table: "scms_wmsstores",
column: "StoreName");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_ContainerNo",
+ table: "scms_wmstasks",
+ column: "ContainerNo");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_DodeviceId",
+ table: "scms_wmstasks",
+ column: "DodeviceId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_IsRead",
+ table: "scms_wmstasks",
+ column: "IsRead");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_Sort",
+ table: "scms_wmstasks",
+ column: "Sort");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_SourceOrderNo",
+ table: "scms_wmstasks",
+ column: "SourceOrderNo");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_SourcePlace",
+ table: "scms_wmstasks",
+ column: "SourcePlace");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_TaskNo",
+ table: "scms_wmstasks",
+ column: "TaskNo",
+ unique: true);
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_TaskStatus",
+ table: "scms_wmstasks",
+ column: "TaskStatus");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_TaskType",
+ table: "scms_wmstasks",
+ column: "TaskType");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmstasks_ToPlace",
+ table: "scms_wmstasks",
+ column: "ToPlace");
}
protected override void Down(MigrationBuilder migrationBuilder)
@@ -321,6 +511,9 @@
name: "scms_wmscontainers");
migrationBuilder.DropTable(
+ name: "scms_wmsinoutstockrecords");
+
+ migrationBuilder.DropTable(
name: "scms_wmsmaterials");
migrationBuilder.DropTable(
@@ -328,6 +521,9 @@
migrationBuilder.DropTable(
name: "scms_wmsstores");
+
+ migrationBuilder.DropTable(
+ name: "scms_wmstasks");
}
}
}
--
Gitblit v1.9.3