From b7a82bbc4b305f0323be93030842c1b82c824337 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周五, 09 5月 2025 10:06:36 +0800
Subject: [PATCH] 优化查询列
---
HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsInOutStockOrderDetail.cs | 21 ++++++++++++++++++---
1 files changed, 18 insertions(+), 3 deletions(-)
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsInOutStockOrderDetail.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsInOutStockOrderDetail.cs
index 9c7c382..fa74eba 100644
--- a/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsInOutStockOrderDetail.cs
+++ b/HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsInOutStockOrderDetail.cs
@@ -40,12 +40,14 @@
builder.Entity<WmsInOutStockOrderDetail>(b =>
{
- b.ToTable((CMSPluginDbProperties.DbTablePrefix + "WmsInOutStockOrderDetail").ToLower(),
+ b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WmsInOutStockOrderDetail").ToLower(),
CMSPluginDbProperties.DbSchema)
.HasComment("鍑哄叆搴撳崟鎹槑缁嗚〃");
- // 澶嶅悎涓婚敭閰嶇疆锛堟牴鎹笟鍔￠渶姹傝皟鏁达級
- b.HasKey(x => new { x.OrderNo, x.MaterialId });
+ // 涓婚敭閰嶇疆
+ b.HasKey(x => x.Id);
+ //// 澶嶅悎涓婚敭閰嶇疆锛堟牴鎹笟鍔￠渶姹傝皟鏁达級
+ //b.HasKey(x => new { x.OrderNo, x.MaterialId });
// 瀛楁閰嶇疆
b.Property(x => x.OrderNo)
@@ -82,6 +84,19 @@
b.Property(x => x.MaterialBatch)
.HasComment("鐗╂枡鎵规");
+ b.Property(x => x.Remark)
+ .HasMaxLength(500)
+ .HasComment("澶囨敞");
+
+ b.Property(x => x.Sort)
+ .HasDefaultValue(0)
+ .HasComment("鎺掑簭");
+
+ b.Property(x => x.IsDisabled)
+ .HasDefaultValue(false)
+ .HasComment("鏄惁绂佺敤");
+
+
// 绱㈠紩閰嶇疆锛堟牴鎹煡璇㈤渶姹備紭鍖栵級
b.HasIndex(x => x.OrderNo); // 鍗曟嵁鏌ヨ
b.HasIndex(x => x.MaterialNo); // 鐗╂枡鏌ヨ
--
Gitblit v1.9.3