出入库功能

zs

2025-05-11 3322dfd299755416176cd946265577e176cae795

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
using CMS.Plugin.HIAWms.Domain;
using CMS.Plugin.HIAWms.Domain.WmsInOutStockOrder;
using CMS.Plugin.HIAWms.Domain.WmsInOutStockOrderDetail;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Volo.Abp;
using Volo.Abp.EntityFrameworkCore.Modeling;
 
namespace CMS.Plugin.HIAWms.EntityFrameworkCore.Extensions
{
    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<WmsInOutStockOrderDetail> IncludeDetails(this IQueryable<WmsInOutStockOrderDetail> queryable, bool include = true)
        {
            if (!include)
            {
                return queryable;
            }
 
            return queryable;
        }
 
        /// <summary>
        /// Configure  WmsInOutStockOrderDetail
        /// </summary>
        /// <param name="builder"></param>
        public static void ConfigureWmsInOutStockOrderDetail(this ModelBuilder builder)
        {
            Check.NotNull(builder, nameof(builder));
 
            builder.Entity<WmsInOutStockOrderDetail>(b =>
            {
                b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WmsInOutStockOrderDetail").ToLower(),
                         CMSPluginDbProperties.DbSchema)
                 .HasComment("出入库单据明细表");
 
                // 主键配置
                b.HasKey(x => x.Id);
                //// 复合主键配置（根据业务需求调整）
                //b.HasKey(x => new { x.OrderNo, x.MaterialId });
 
                // 字段配置
                b.Property(x => x.OrderNo)
                    .HasMaxLength(50)
                    .IsRequired()
                    .HasComment("单据编号");
 
                b.Property(x => x.OrderType)
                    .IsRequired()
                    .HasComment("单据类型（枚举值）");
 
                b.Property(x => x.MaterialNo)
                    .HasMaxLength(50)
                    .IsRequired()
                    .HasComment("物料件号");
 
                b.Property(x => x.MaterialName)
                    .HasMaxLength(100)
                    .HasComment("物料名称");
 
                b.Property(x => x.MaterialId)
                    .HasMaxLength(64)
                    .IsRequired()
                    .HasComment("物料唯一码");
 
                b.Property(x => x.ContainerNo)
                    .HasMaxLength(50)
                    .HasComment("容器编号");
 
                b.Property(x => x.MaterialModel)
                    .HasMaxLength(50)
                    .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); // 物料查询
                b.HasIndex(x => x.MaterialId); // 唯一码查询
                b.HasIndex(x => x.ContainerNo); // 容器查询
                b.HasIndex(x => new { x.OrderNo, x.OrderType }); // 联合查询
 
                // ABP框架配置
                b.ConfigureByConvention();
                b.ApplyObjectExtensionMappings();
            });
        }
    }
}