From 413f167eacffa8958341bcdcf7bc97d547664868 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周二, 13 5月 2025 06:13:02 +0800
Subject: [PATCH] 高级查询初步
---
PipeLineLems/server/src/CMS.Plugin.PipeLineLems.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs | 591 ++++++++++++++++++++++++++++++++++++++++++----------------
1 files changed, 426 insertions(+), 165 deletions(-)
diff --git a/PipeLineLems/server/src/CMS.Plugin.PipeLineLems.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs b/PipeLineLems/server/src/CMS.Plugin.PipeLineLems.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs
index f5e4f02..4c19fa8 100644
--- a/PipeLineLems/server/src/CMS.Plugin.PipeLineLems.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs
+++ b/PipeLineLems/server/src/CMS.Plugin.PipeLineLems.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs
@@ -21,6 +21,279 @@
.HasAnnotation("ProductVersion", "6.0.16")
.HasAnnotation("Relational:MaxIdentifierLength", 64);
+ modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.CallMaterialOrder.CallMaterialOrder", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("char(36)");
+
+ b.Property<int>("CallMaterialStatus")
+ .HasColumnType("int")
+ .HasComment("鍙枡鐘舵��");
+
+ b.Property<string>("ConcurrencyStamp")
+ .IsConcurrencyToken()
+ .HasMaxLength(40)
+ .HasColumnType("varchar(40)")
+ .HasColumnName("ConcurrencyStamp")
+ .HasComment("骞跺彂鎴�");
+
+ b.Property<DateTime>("CreationTime")
+ .HasColumnType("datetime(6)")
+ .HasColumnName("CreationTime")
+ .HasComment("鍒涘缓鏃堕棿");
+
+ b.Property<Guid?>("CreatorId")
+ .HasMaxLength(36)
+ .HasColumnType("char(36)")
+ .HasColumnName("CreatorId")
+ .HasComment("鍒涘缓浜篒D");
+
+ b.Property<string>("CreatorName")
+ .HasMaxLength(64)
+ .HasColumnType("varchar(64)")
+ .HasComment("鍒涘缓浜�");
+
+ b.Property<string>("DataIdentifier")
+ .IsRequired()
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鍘熸枡鏍囪瘑");
+
+ b.Property<string>("DeleteRemark")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鍒犻櫎澶囨敞");
+
+ b.Property<Guid?>("DeleterId")
+ .HasMaxLength(36)
+ .HasColumnType("char(36)")
+ .HasColumnName("DeleterId")
+ .HasComment("鍒犻櫎浜篒D");
+
+ b.Property<DateTime?>("DeletionTime")
+ .HasColumnType("datetime(6)")
+ .HasColumnName("DeletionTime")
+ .HasComment("鍒犻櫎鏃堕棿");
+
+ b.Property<string>("ExtraField1")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎵╁睍瀛楁1");
+
+ b.Property<string>("ExtraField2")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎵╁睍瀛楁2");
+
+ b.Property<string>("ExtraField3")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎵╁睍瀛楁3");
+
+ b.Property<string>("ExtraProperties")
+ .HasColumnType("longtext")
+ .HasColumnName("ExtraProperties")
+ .HasComment("鎵╁睍灞炴��");
+
+ b.Property<bool>("IsDeleted")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("tinyint(1)")
+ .HasDefaultValue(false)
+ .HasColumnName("IsDeleted")
+ .HasComment("鏄惁鍒犻櫎");
+
+ b.Property<bool?>("IsDisabled")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("tinyint(1)")
+ .HasDefaultValue(false)
+ .HasComment("鏄惁绂佺敤");
+
+ b.Property<DateTime?>("LastModificationTime")
+ .HasColumnType("datetime(6)")
+ .HasColumnName("LastModificationTime")
+ .HasComment("淇敼鏃堕棿");
+
+ b.Property<Guid?>("LastModifierId")
+ .HasMaxLength(36)
+ .HasColumnType("char(36)")
+ .HasColumnName("LastModifierId")
+ .HasComment("淇敼浜篒D");
+
+ b.Property<string>("LastModifierName")
+ .HasMaxLength(64)
+ .HasColumnType("varchar(64)")
+ .HasComment("淇敼浜�");
+
+ b.Property<string>("MaterialMode")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鍘熸枡鍨嬪彿");
+
+ b.Property<string>("OperationRemark")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎿嶄綔澶囨敞");
+
+ b.Property<int>("Quantity")
+ .HasColumnType("int")
+ .HasComment("鍙枡鏁伴噺");
+
+ b.Property<string>("Remark")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("澶囨敞");
+
+ b.Property<int>("Sort")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("int")
+ .HasDefaultValue(0)
+ .HasComment("鎺掑簭");
+
+ b.Property<string>("WmsRetResult")
+ .HasColumnType("longtext")
+ .HasComment("WMS杩斿洖缁撴灉");
+
+ b.Property<string>("WmsTaskNo")
+ .HasColumnType("longtext")
+ .HasComment("WMS浠诲姟鍙�");
+
+ b.HasKey("Id");
+
+ b.HasIndex("DataIdentifier")
+ .IsUnique();
+
+ b.ToTable("scms_callmaterialorders", (string)null);
+
+ b.HasComment("鍙枡鍗曡〃");
+ });
+
+ modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.CallMaterialOrderRecord.CallMaterialOrderRecord", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("char(36)");
+
+ b.Property<int>("CallMaterialStatus")
+ .HasColumnType("int")
+ .HasComment("鍙枡鐘舵��");
+
+ b.Property<string>("ConcurrencyStamp")
+ .IsConcurrencyToken()
+ .HasMaxLength(40)
+ .HasColumnType("varchar(40)")
+ .HasColumnName("ConcurrencyStamp")
+ .HasComment("骞跺彂鎴�");
+
+ b.Property<DateTime>("CreationTime")
+ .HasColumnType("datetime(6)")
+ .HasColumnName("CreationTime")
+ .HasComment("鍒涘缓鏃堕棿");
+
+ b.Property<Guid?>("CreatorId")
+ .HasMaxLength(36)
+ .HasColumnType("char(36)")
+ .HasColumnName("CreatorId")
+ .HasComment("鍒涘缓浜篒D");
+
+ b.Property<string>("CreatorName")
+ .HasMaxLength(64)
+ .HasColumnType("varchar(64)")
+ .HasComment("鍒涘缓浜�");
+
+ b.Property<string>("DataIdentifier")
+ .IsRequired()
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鍘熸枡鏍囪瘑");
+
+ b.Property<Guid?>("DeleterId")
+ .HasMaxLength(36)
+ .HasColumnType("char(36)")
+ .HasColumnName("DeleterId")
+ .HasComment("鍒犻櫎浜篒D");
+
+ b.Property<DateTime?>("DeletionTime")
+ .HasColumnType("datetime(6)")
+ .HasColumnName("DeletionTime")
+ .HasComment("鍒犻櫎鏃堕棿");
+
+ b.Property<string>("ExtraField1")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎵╁睍瀛楁1");
+
+ b.Property<string>("ExtraField2")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎵╁睍瀛楁2");
+
+ b.Property<string>("ExtraField3")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎵╁睍瀛楁3");
+
+ b.Property<string>("ExtraProperties")
+ .HasColumnType("longtext")
+ .HasColumnName("ExtraProperties")
+ .HasComment("鎵╁睍灞炴��");
+
+ b.Property<bool>("IsDeleted")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("tinyint(1)")
+ .HasDefaultValue(false)
+ .HasColumnName("IsDeleted")
+ .HasComment("鏄惁鍒犻櫎");
+
+ b.Property<DateTime?>("LastModificationTime")
+ .HasColumnType("datetime(6)")
+ .HasColumnName("LastModificationTime")
+ .HasComment("淇敼鏃堕棿");
+
+ b.Property<Guid?>("LastModifierId")
+ .HasMaxLength(36)
+ .HasColumnType("char(36)")
+ .HasColumnName("LastModifierId")
+ .HasComment("淇敼浜篒D");
+
+ b.Property<string>("MaterialMode")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鍘熸枡鍨嬪彿");
+
+ b.Property<int>("Quantity")
+ .HasColumnType("int")
+ .HasComment("鍙枡鏁伴噺");
+
+ b.Property<string>("Remark")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("澶囨敞");
+
+ b.Property<int>("Sort")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("int")
+ .HasDefaultValue(0)
+ .HasComment("鎺掑簭");
+
+ b.Property<string>("WmsRetResult")
+ .HasColumnType("longtext")
+ .HasComment("WMS杩斿洖缁撴灉");
+
+ b.Property<string>("WmsTaskNo")
+ .HasColumnType("longtext")
+ .HasComment("WMS浠诲姟鍙�");
+
+ b.HasKey("Id");
+
+ b.HasIndex("DataIdentifier")
+ .IsUnique();
+
+ b.ToTable("scms_callmaterialorderrecords", (string)null);
+
+ b.HasComment("鍙枡璁板綍琛�");
+ });
+
modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.MyTestEntityNames.MyTestEntityName", b =>
{
b.Property<Guid>("Id")
@@ -101,210 +374,190 @@
b.HasComment("MyTestEntityName");
});
- modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.WmsAreas.WorkPlan", b =>
+ modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.WorkPlan.WorkPlan", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
- b.Property<string>("Bevel")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鍧″彛");
-
- b.Property<string>("BranchMaterial")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鏀鏉愯川");
-
- b.Property<string>("BranchOuterDiameter")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鏀寰�");
-
- b.Property<string>("BranchPortAngle")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鏀绔彛瑙掑害");
-
- b.Property<string>("BranchPortRadius")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鏀绔彛鏇茬巼鍗婂緞");
-
- b.Property<string>("BranchPortRequirement")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鏀绔彛瑕佹眰");
-
- b.Property<string>("BranchWallThickness")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鏀澹佸帤");
+ b.Property<int>("CallMaterialStatus")
+ .HasColumnType("int")
+ .HasComment("鍙枡鐘舵��");
b.Property<string>("ConcurrencyStamp")
.IsConcurrencyToken()
.HasMaxLength(40)
.HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
+ .HasColumnName("ConcurrencyStamp")
+ .HasComment("骞跺彂鎴�");
b.Property<DateTime>("CreationTime")
.HasColumnType("datetime(6)")
- .HasColumnName("CreationTime");
+ .HasColumnName("CreationTime")
+ .HasComment("鍒涘缓鏃堕棿");
b.Property<Guid?>("CreatorId")
+ .HasMaxLength(36)
.HasColumnType("char(36)")
- .HasColumnName("CreatorId");
+ .HasColumnName("CreatorId")
+ .HasComment("鍒涘缓浜篒D");
- b.Property<string>("CuttingFile")
+ b.Property<string>("CreatorName")
.HasMaxLength(64)
.HasColumnType("varchar(64)")
- .HasComment("鍒囧壊鏂囦欢");
+ .HasComment("鍒涘缓浜�");
+
+ b.Property<decimal>("CuttingPosition")
+ .HasColumnType("decimal(18,2)")
+ .HasComment("鍒囧壊浣嶇疆");
b.Property<string>("DataIdentifier")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("鍘熸枡鏍囪瘑");
+ b.Property<string>("DeleteRemark")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鍒犻櫎澶囨敞");
+
b.Property<Guid?>("DeleterId")
+ .HasMaxLength(36)
.HasColumnType("char(36)")
- .HasColumnName("DeleterId");
+ .HasColumnName("DeleterId")
+ .HasComment("鍒犻櫎浜篒D");
b.Property<DateTime?>("DeletionTime")
.HasColumnType("datetime(6)")
- .HasColumnName("DeletionTime");
-
- b.Property<string>("DrillingPosition")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鎵撳瓟浣�");
+ .HasColumnName("DeletionTime")
+ .HasComment("鍒犻櫎鏃堕棿");
b.Property<string>("EquipmentCode")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("璁惧浠ｇ爜");
+
+ b.Property<string>("ExtraField1")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎵╁睍瀛楁1");
+
+ b.Property<string>("ExtraField2")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎵╁睍瀛楁2");
+
+ b.Property<string>("ExtraField3")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎵╁睍瀛楁3");
b.Property<string>("ExtraProperties")
.HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
+ .HasColumnName("ExtraProperties")
+ .HasComment("鎵╁睍灞炴��");
b.Property<string>("FactoryCode")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("宸ュ巶浠ｇ爜");
- b.Property<string>("FinishedProductScale")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鎴愬搧鍥惧箙");
+ b.Property<decimal>("FlangeInnerDiameter")
+ .HasColumnType("decimal(18,2)")
+ .HasComment("娉曞叞鐩村緞(mm)");
- b.Property<string>("FlangeInnerDiameter")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("娉曞叞鍐呭緞");
-
- b.Property<string>("FlangeThickness")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("娉曞叞鍘氬害");
-
- b.Property<bool>("HasMainSignature")
- .HasColumnType("tinyint(1)")
- .HasComment("鏄惁鏈変富绛�");
-
- b.Property<string>("InterfaceRequirement")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鎺ュ彛瑕佹眰");
-
- b.Property<string>("Intersecting")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鐩歌疮");
-
- b.Property<string>("IntersectingLineCategory")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鐩歌疮绾跨被鍒�");
-
- b.Property<string>("IntersectingLineType")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鐩歌疮绾跨被鍨�");
+ b.Property<decimal>("FlangeThickness")
+ .HasColumnType("decimal(18,2)")
+ .HasComment("娉曞叞鍘氬害(mm)");
b.Property<bool>("IsDeleted")
.ValueGeneratedOnAdd()
.HasColumnType("tinyint(1)")
.HasDefaultValue(false)
- .HasColumnName("IsDeleted");
+ .HasColumnName("IsDeleted")
+ .HasComment("鏄惁鍒犻櫎");
b.Property<bool?>("IsDisabled")
+ .ValueGeneratedOnAdd()
.HasColumnType("tinyint(1)")
+ .HasDefaultValue(false)
.HasComment("鏄惁绂佺敤");
b.Property<DateTime?>("LastModificationTime")
.HasColumnType("datetime(6)")
- .HasColumnName("LastModificationTime");
+ .HasColumnName("LastModificationTime")
+ .HasComment("淇敼鏃堕棿");
b.Property<Guid?>("LastModifierId")
+ .HasMaxLength(36)
.HasColumnType("char(36)")
- .HasColumnName("LastModifierId");
+ .HasColumnName("LastModifierId")
+ .HasComment("淇敼浜篒D");
- b.Property<string>("Length")
+ b.Property<string>("LastModifierName")
.HasMaxLength(64)
.HasColumnType("varchar(64)")
- .HasComment("闀垮害");
+ .HasComment("淇敼浜�");
+
+ b.Property<decimal>("Length")
+ .HasColumnType("decimal(18,2)")
+ .HasComment("闀垮害(mm)");
b.Property<string>("MarkingContent")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(1024)
+ .HasColumnType("varchar(1024)")
.HasComment("鎵撶爜鍐呭");
+ b.Property<decimal>("MarkingPosition")
+ .HasColumnType("decimal(18,2)")
+ .HasComment("鎵撶爜浣嶇疆");
+
b.Property<string>("Material")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("鏉愯川");
- b.Property<string>("OrgMaterialCode")
- .IsRequired()
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鍘熸枡缂栧彿");
+ b.Property<string>("MaterialMode")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鍘熸枡鍨嬪彿");
- b.Property<string>("OuterDiameter")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("澶栧緞");
+ b.Property<string>("OperationRemark")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鎿嶄綔澶囨敞");
+
+ b.Property<decimal>("OuterDiameter")
+ .HasColumnType("decimal(18,2)")
+ .HasComment("澶栧緞(mm)");
b.Property<string>("PipeAllowableStress")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("绠￠亾鍏佽搴斿姏");
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("娉曞叞鍐茬爜鍐呭");
- b.Property<string>("PipeDiameter")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("绠″緞");
+ b.Property<decimal>("PipeDiameter")
+ .HasColumnType("decimal(18,2)")
+ .HasComment("濂楃闀垮害(mm)");
b.Property<string>("PipeFittingCode")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("绠′欢缂栫爜");
b.Property<string>("PipeSectionName")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("绠℃鍚嶇О");
b.Property<string>("PipeSpecCode")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("绠¤鏍肩爜");
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("绠℃缂栫爜");
- b.Property<string>("PipeWallThickness")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("绠￠亾澹佸帤");
+ b.Property<decimal>("PipeWallThickness")
+ .HasColumnType("decimal(18,2)")
+ .HasComment("濂楃鐩村緞(mm)");
b.Property<DateTime?>("PlannedEndTime")
.HasColumnType("datetime(6)")
@@ -315,37 +568,28 @@
.HasComment("璁″垝寮�濮嬫椂闂�");
b.Property<string>("PreSerialNumber")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("椤哄簭鍙�");
b.Property<string>("ProcessName")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("宸ュ簭鍚嶇О");
b.Property<string>("ProcessRouteNumber")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("宸ヨ壓璺嚎缂栧彿");
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("宸ヨ壓娴佸悜缂栧彿");
b.Property<string>("ProductCode")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("浜у搧浠ｇ爜");
b.Property<int>("Quantity")
.HasColumnType("int")
- .HasComment("鍖呮嫭鏁伴噺");
-
- b.Property<string>("RedundantField1")
- .HasColumnType("longtext");
-
- b.Property<string>("RedundantField2")
- .HasColumnType("longtext");
-
- b.Property<string>("RedundantField3")
- .HasColumnType("longtext");
+ .HasComment("绠℃鏁伴噺");
b.Property<string>("Remark")
.HasMaxLength(256)
@@ -353,47 +597,64 @@
.HasComment("澶囨敞");
b.Property<int>("Sort")
+ .ValueGeneratedOnAdd()
.HasColumnType("int")
+ .HasDefaultValue(0)
.HasComment("鎺掑簭");
b.Property<string>("TaskCode")
.IsRequired()
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("浠诲姟缂栫爜");
- b.Property<string>("TimeInfo")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鏃堕棿淇℃伅");
+ b.Property<string>("TeamInfo")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鐝粍淇℃伅");
- b.Property<string>("VRData")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("VR鏁版嵁");
+ b.Property<decimal>("Thickness")
+ .HasColumnType("decimal(18,2)")
+ .HasComment("澹佸帤(mm)");
+
+ b.Property<string>("Timestamp")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("鏃堕棿鎴�");
b.Property<string>("WeldingHeatInput")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
- .HasComment("鐒婃帴鐑緭鍏�");
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
+ .HasComment("娉曞叞鍏О鍘嬪姏");
+
+ b.Property<int>("WorkPlanStatus")
+ .HasColumnType("int")
+ .HasComment("璁″垝鐘舵��");
b.Property<string>("WorkpieceName")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("宸ヤ欢鍚嶇О");
b.Property<string>("WorkstationCode")
- .HasMaxLength(64)
- .HasColumnType("varchar(64)")
+ .HasMaxLength(256)
+ .HasColumnType("varchar(256)")
.HasComment("宸ヤ綅浠ｇ爜");
b.HasKey("Id");
- b.HasIndex("TaskCode");
+ b.HasIndex("DataIdentifier");
+
+ b.HasIndex("PlannedEndTime");
+
+ b.HasIndex("PlannedStartTime");
+
+ b.HasIndex("TaskCode")
+ .IsUnique();
b.ToTable("scms_workplans", (string)null);
- b.HasComment("WorkPlan");
+ b.HasComment("浣滀笟璁″垝琛�");
});
#pragma warning restore 612, 618
}
--
Gitblit v1.9.3