using CMS.Plugin.HIAWms.Domain;
|
using CMS.Plugin.HIAWms.Domain.WmsMaterialStocks;
|
using CMS.Plugin.HIAWms.Domain.Shared.WmsMaterialStocks;
|
using Microsoft.EntityFrameworkCore;
|
using Volo.Abp;
|
using Volo.Abp.EntityFrameworkCore.Modeling;
|
|
namespace CMS.Plugin.HIAWms.EntityFrameworkCore.Extensions;
|
|
/// <summary>
|
/// EfCore扩展
|
/// </summary>
|
public static partial class CMSPluginEfCoreExtensions
|
{
|
/// <summary>
|
/// Includes the details.
|
/// </summary>
|
/// <param name="queryable">The queryable.</param>
|
/// <param name="include">if set to <c>true</c> [include].</param>
|
/// <returns></returns>
|
public static IQueryable<WmsMaterialStock> IncludeDetails(this IQueryable<WmsMaterialStock> queryable, bool include = true)
|
{
|
if (!include)
|
{
|
return queryable;
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// Configures the wmsmaterialstock.
|
/// </summary>
|
/// <param name="builder">The builder.</param>
|
public static void ConfigureWmsMaterialStock(this ModelBuilder builder)
|
{
|
Check.NotNull(builder, nameof(builder));
|
|
builder.Entity<WmsMaterialStock>(b =>
|
{
|
// 配置表和架构名称
|
b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WmsMaterialStocks").ToLower(),
|
CMSPluginDbProperties.DbSchema)
|
.HasComment("WMS物料库存表");
|
|
b.ConfigureByConvention();
|
|
// 主键配置
|
b.HasKey(x => x.Id);
|
|
// 属性配置
|
b.Property(x => x.MaterialId)
|
.HasMaxLength(64)
|
.IsRequired()
|
.HasComment("物料ID");
|
|
b.Property(x => x.MaterialName)
|
.HasMaxLength(128)
|
.IsRequired()
|
.HasComment("物料名称");
|
|
b.Property(x => x.ContainerNo)
|
.HasMaxLength(64)
|
.HasComment("容器编号");
|
|
b.Property(x => x.ContainerStatus)
|
.HasComment("容器状态");
|
|
b.Property(x => x.ContainerType)
|
.HasComment("容器类型");
|
|
b.Property(x => x.MaterialNo)
|
.HasMaxLength(64)
|
.IsRequired()
|
.HasComment("物料编号");
|
|
b.Property(x => x.StockNumber)
|
.HasComment("库存数量");
|
|
b.Property(x => x.MaterialBatch)
|
.HasMaxLength(64)
|
.HasComment("物料批次");
|
|
b.Property(x => x.SupplierCode)
|
.HasMaxLength(64)
|
.HasComment("供应商编号");
|
|
b.Property(x => x.MaterialModel)
|
.HasMaxLength(128)
|
.HasComment("机型/规格");
|
|
b.Property(x => x.PlaceNo)
|
.HasMaxLength(64)
|
.HasComment("库位编号");
|
|
b.Property(x => x.PlaceStatus)
|
.HasComment("库位状态;");
|
|
b.Property(x => x.StorageTypeNo)
|
.HasComment("库位类型");
|
|
b.Property(x => x.AreaCode)
|
.HasMaxLength(64)
|
.HasComment("区域编号");
|
|
b.Property(x => x.AreaName)
|
.HasMaxLength(128)
|
.HasComment("库区名称");
|
|
b.Property(x => x.IsLock)
|
.HasComment("是否锁定(2:未锁定,1:已锁定)");
|
b.Property(x => x.EmptyContainer)
|
.HasComment("是否空托(2:否,1:是)");
|
|
b.Property(x => x.InStockTime)
|
.HasComment("入库时间");
|
|
b.Property(x => x.Sort)
|
.HasDefaultValue(0)
|
.HasComment("排序");
|
|
b.Property(x => x.Remark)
|
.HasMaxLength(500)
|
.HasComment("备注");
|
|
b.Property(x => x.CheckStatus)
|
.HasComment("检验状态(1:未检验,2:检验通过,3:检验不通过)");
|
|
// 冗余字段配置
|
b.Property(x => x.RedundantField1)
|
.HasMaxLength(256)
|
.IsRequired(false)
|
.HasComment("冗余字段1 - 预留扩展用途");
|
|
b.Property(x => x.RedundantField2)
|
.HasMaxLength(256)
|
.IsRequired(false)
|
.HasComment("冗余字段2 - 预留扩展用途");
|
|
b.Property(x => x.RedundantField3)
|
.HasMaxLength(256)
|
.IsRequired(false)
|
.HasComment("冗余字段3 - 预留扩展用途");
|
|
b.Property(x => x.IsDisabled)
|
.HasComment("是否禁用");
|
|
// 索引配置
|
b.HasIndex(x => x.MaterialNo);
|
b.HasIndex(x => x.MaterialName);
|
b.HasIndex(x => x.ContainerNo);
|
b.HasIndex(x => x.PlaceNo);
|
b.HasIndex(x => x.AreaCode);
|
b.HasIndex(x => new { x.MaterialBatch, x.SupplierCode });
|
|
// 扩展属性配置
|
b.ApplyObjectExtensionMappings();
|
});
|
}
|
}
|
