base_inventory.cs
4.29 KB
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
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
using System;
using SqlSugar;
using System.ComponentModel.DataAnnotations.Schema;
using Hh.Mes.POJO.EnumEntitys;
namespace Hh.Mes.POJO.Entity
{
public partial class base_inventory : base_Entity
{
/// <summary>
///
/// </summary>
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
public int id { get; set; }
/// <summary>
///
/// </summary>
public string factoryCode { get; set; }
/// <summary>
///
/// </summary>
public string lineCode { get; set; }
/// <summary>
/// 仓库类型
/// </summary>
public string warehouseCode { get; set; }
/// <summary>
/// 区域编码
/// </summary>
public string zoneCode { get; set; }
/// <summary>
/// 库位id
/// </summary>
public int? locationId { get; set; }
/// <summary>
/// 库位编号
/// </summary>
public string locationCode { get; set; }
/// <summary>
/// 容器编码
/// </summary>
public string containerCode { get; set; }
/// <summary>
/// 上游系统单号
/// </summary>
public string sourceCode { get; set; }
/// <summary>
/// 物料类型
/// </summary>
public string materialType { get; set; }
/// <summary>
/// 物料编码
/// </summary>
public string materialCode { get; set; }
/// <summary>
/// 批号
/// </summary>
public string lot { get; set; }
/// <summary>
/// 炉批号
/// </summary>
public string batchNo { get; set; }
/// <summary>
/// 管材或余料的SN码
/// </summary>
public string pipeSN { get; set; }
/// <summary>
/// 余料切割之前的管材SN码
/// </summary>
public string oldSN { get; set; }
/// <summary>
/// 图号
/// </summary>
public string drawingCode { get; set; }
/// <summary>
/// 生产日期
/// </summary>
public DateTime? manufactureDate { get; set; }
/// <summary>
/// 失效日期
/// </summary>
public DateTime? expirationDate { get; set; }
/// <summary>
/// 库存状态
/// </summary>
public string status { get; set; }
/// <summary>
/// 管材长度
/// </summary>
public decimal? pipeLength { get; set; }
/// <summary>
/// 使用状态 和 库存状态区分 ECS操作使用状态
/// </summary>
public int useState { get; set; }
/// <summary>
/// 数量
/// </summary>
public decimal qty { get; set; }
/// <summary>
/// 工单code/生产订单号
/// <see cref="bus_workOrder_head"/>
/// </summary>
public string workOrderCode { get; set; }
/// <summary>
/// 工序code
/// <see cref="bus_workOrder_detail"/>
/// </summary>
public string oprSequenceCode { get; set; }
/// <summary>
/// 物料名称
/// </summary>
[SugarColumn(IsIgnore = true)]
[NotMapped]
public string materialName { get; set; }
/// <summary>
/// 单位名称
/// </summary>
public string whCode { get; set; }
/// <summary>
/// 工序任务头表
/// <see cref="bus_workOrder_head"/>
/// </summary>
public Guid? headKey { get; set; }
/// <summary>
/// 消耗数量
/// </summary>
public int consumedQuantity { get; set; }
/// <summary>
/// 需求数量
/// </summary>
public decimal quantityRequired { get; set; }
/// <summary>
/// 收货数量
/// </summary>
public int quantityReceived { get; set; }
/// <summary>
/// 创建时间
/// </summary>
public DateTime? createTime { get; set; }
/// <summary>
/// 创建用户
/// </summary>
public string createBy { get; set; }
/// <summary>
/// 更新时间
/// </summary>
public DateTime? updateTime { get; set; }
/// <summary>
/// 更新用户
/// </summary>
public string updateBy { get; set; }
}
}