出入库功能

zs

2025-05-11 3322dfd299755416176cd946265577e176cae795

 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)
@@ -80,8 +82,22 @@
                    .HasComment("机型");

                b.Property(x => x.MaterialBatch)
                    .HasMaxLength (50)
                    .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); // 物料查询