qinchulong
2024-10-12 7281004dc3854ed59e9164dcd27a59c8c2cf6667
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
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
 
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
using WIDESEA_Core.DB.Models;
namespace WIDESEA_Model.Models
{
 
    /// <summary>
    /// 组盘表(库存)主表
    ///</summary>
    [SugarTable("Dt_BillGroupStock")]
    public class Dt_BillGroupStock:BaseEntity
    {
        /// <summary>
        /// 备  注:库存ID
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "GroupId", IsPrimaryKey = true, IsIdentity = true)]
        public int GroupId { get; set; }
 
        /// <summary>
        /// 备  注:托盘条码
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "PalletCode")]
        public string? PalletCode { get; set; }
 
        /// <summary>
        /// 备  注:单据编号(关联inbound_order)
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "OrderNo")]
        public string? OrderNo { get; set; }
 
        /// <summary>
        /// 备  注:1,入库 2,出库
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "OrderType")]
        public int OrderType { get; set; }
 
 
        /// <summary>
        /// 备  注:物料编号
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "MaterialNo")]
        public string? MaterialNo { get; set; }
 
        /// <summary>
        /// 备  注:批次号
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "BatchNo")]
        public string? BatchNo { get; set; }
 
        /// <summary>
        /// 备  注:组盘类型  1,一次组盘  2,二次组盘(上架前,空托组过盘)
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "GroupType")]
        public int? GroupType { get; set; }
 
        /// <summary>
        /// 备  注:组盘方式(1,内码 2,外码 3,内外码  4,空托盘)
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "GroupWay")]
        public int GroupWay { get; set; }
 
        /// <summary>
        /// 备  注:是否满盘(如果已满盘不可二次组盘,人工确定是否满盘)
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "IsFull")]
        public bool IsFull { get; set; }
 
        /// <summary>
        /// 备  注:库位
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "LocationCode")]
        public string? LocationCode { get; set; }
 
        /// <summary>
        /// 备  注:库存状态:1,组盘暂存  2,组盘撤销  3,入库确认  4,已入库  5,已出库
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "State")]
        public int? State { get; set; }
 
        /// <summary>
        /// 备  注:备注
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Remark")]
        public string? Remark { get; set; }
 
      
 
        /// <summary>
        /// 备  注:
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Spare1")]
        public string? Spare1 { get; set; }
 
        /// <summary>
        /// 备  注:
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Spare2")]
        public string? Spare2 { get; set; }
 
        /// <summary>
        /// 备  注:
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Spare3")]
        public string? Spare3 { get; set; }
 
        /// <summary>
        /// 备  注:
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Spare4")]
        public string? Spare4 { get; set; }
 
        /// <summary>
        /// 备  注:
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Spare5")]
        public string? Spare5 { get; set; }
 
        /// <summary>
        /// 库存明细
        /// </summary>
        [SugarColumn(ColumnName = "Dt_BillGroupStockDetailList")]
        [Navigate(NavigateType.OneToMany, nameof(Dt_BillGroupStockDetail.GroupId))]
        public List<Dt_BillGroupStockDetail>? Dt_BillGroupStockDetailList { get; set; }
 
        /// <summary>
        /// 货位详情
        /// </summary>
        [SugarColumn(IsIgnore = true,ColumnName = "LocationInfo")]
        [Navigate(NavigateType.OneToOne, nameof(LocationCode), nameof(Dt_LocationInfo.LocationCode))]
        public Dt_LocationInfo? LocationInfo { get; set; }
    }
}