using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：在制品信息表
|
/// </summary>
|
[Description("Primary:ID")]
|
[DisplayName("在制品信息表")]
|
[Serializable]
|
[SugarTable("MES_WIP_DATA")]
|
public class MES_WIP_DATA : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：在制品信息表
|
/// </summary>
|
public MES_WIP_DATA() { }
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 过站条码
|
/// </summary>
|
[DisplayName("过站条码")]
|
public string SN { get; set; }
|
/// <summary>
|
/// 状态(0Init初始化|10Input已投入|20OK良品过站|30NG不良过站|40Repair维修中|50Output已产出|51WaitStorage待入库|52WaitShipment待出货|60InStorage已入库|61Reject已拒收|80Shipped已出货|90Scrap已报废|91Offline异常下线)
|
/// </summary>
|
[DisplayName("状态(0Init初始化|10Input已投入|20OK良品过站|30NG不良过站|40Repair维修中|50Output已产出|51WaitStorage待入库|52WaitShipment待出货|60InStorage已入库|61Reject已拒收|80Shipped已出货|90Scrap已报废|91Offline异常下线))")]
|
public int STATUS { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[DisplayName("物料编码")]
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 数量
|
/// </summary>
|
[DisplayName("数量")]
|
public double QTY { get; set; } = 1;
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
[DisplayName("工单号")]
|
public string WORK_ORDER { get; set; }
|
/// <summary>
|
/// 工单批次号
|
/// </summary>
|
[DisplayName("工单批次号")]
|
public string BATCH_NO { get; set; }
|
/// <summary>
|
/// 工艺路线编码
|
/// </summary>
|
[DisplayName("工艺路线编码")]
|
public string ROT_CODE { get; set; }
|
/// <summary>
|
/// 工艺路线节点ID
|
/// </summary>
|
[DisplayName("工艺路线节点ID")]
|
public string NODE_ID { get; set; }
|
/// <summary>
|
/// 工艺路线节点名称
|
/// </summary>
|
[DisplayName("工艺路线节点名称")]
|
public string NODE_NAME { get; set; }
|
/// <summary>
|
/// 工厂编码
|
/// </summary>
|
[DisplayName("工厂编码")]
|
public string FTY_CODE { get; set; }
|
/// <summary>
|
/// 车间编码
|
/// </summary>
|
[DisplayName("车间编码")]
|
public string WS_CODE { get; set; }
|
/// <summary>
|
/// 产线编码
|
/// </summary>
|
[DisplayName("产线编码")]
|
public string LINE_CODE { get; set; }
|
/// <summary>
|
/// 岗位编码
|
/// </summary>
|
[DisplayName("岗位编码")]
|
public string POST_CODE { get; set; }
|
/// <summary>
|
/// 工序编码
|
/// </summary>
|
[DisplayName("工序编码")]
|
public string OPER_CODE { get; set; }
|
/// <summary>
|
/// 加工段
|
/// </summary>
|
[DisplayName("加工段")]
|
public string SEGMENT { get; set; }
|
/// <summary>
|
/// 锁定标记
|
/// </summary>
|
[DisplayName("锁定标记")]
|
public string HOLD_FLAG { get; set; }
|
/// <summary>
|
/// 返工标记
|
/// </summary>
|
[DisplayName("返工标记")]
|
public string REWORK_FLAG { get; set; }
|
/// <summary>
|
/// 解绑标记(因异常下线导致当前记录从工单生产数据中移除，不参与工艺流程计算和数据统计)
|
/// </summary>
|
[DisplayName("解绑标记(因异常下线导致当前记录从工单生产数据中移除，不参与工艺流程计算和数据统计)")]
|
public string UNBIND_FLAG { get; set; }
|
/// <summary>
|
/// 是否完工
|
/// </summary>
|
[DisplayName("是否完工")]
|
public string FINISHED_FLAG { get; set; }
|
/// <summary>
|
/// 是否不良
|
/// </summary>
|
[DisplayName("是否不良")]
|
public string DFT_FLAG { get; set; }
|
/// <summary>
|
/// 不良计数
|
/// </summary>
|
[DisplayName("不良计数")]
|
public int DFT_COUNT { get; set; }
|
/// <summary>
|
/// 不良代码编码
|
/// </summary>
|
[DisplayName("不良代码编码")]
|
public string DFT_CODE { get; set; }
|
/// <summary>
|
/// 维修回流工序名称(为空则不指定回流工序)
|
/// </summary>
|
[DisplayName("维修回流工序名称(为空则不指定回流工序)")]
|
public string REFLOW_NODE { get; set; }
|
/// <summary>
|
/// 厂内流转条码
|
/// </summary>
|
[DisplayName("厂内流转条码")]
|
public string FLOW_SN { get; set; }
|
/// <summary>
|
/// 托盘/载具条码
|
/// </summary>
|
[DisplayName("托盘/载具条码")]
|
public string TRAY_SN { get; set; }
|
/// <summary>
|
/// 内包装条码
|
/// </summary>
|
[DisplayName("内包装条码")]
|
public string INNER_SN { get; set; }
|
/// <summary>
|
/// 外箱条码
|
/// </summary>
|
[DisplayName("外箱条码")]
|
public string CARTON_SN { get; set; }
|
/// <summary>
|
/// 栈板条码
|
/// </summary>
|
[DisplayName("栈板条码")]
|
public string PALLET_SN { get; set; }
|
/// <summary>
|
/// 是否入库
|
/// </summary>
|
[DisplayName("是否入库")]
|
public string INV_FLAG { get; set; }
|
/// <summary>
|
/// 入库日期
|
/// </summary>
|
[DisplayName("入库日期")]
|
public DateTime INV_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 投入时间
|
/// </summary>
|
[DisplayName("投入时间")]
|
public DateTime INLINE_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 产出时间
|
/// </summary>
|
[DisplayName("产出时间")]
|
public DateTime OUTLINE_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 当前操作时间
|
/// </summary>
|
[DisplayName("当前操作时间")]
|
public DateTime OPERATION_TIME { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 操作完成时间
|
/// </summary>
|
[DisplayName("操作完成时间")]
|
public DateTime OPERATION_END { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 不良数量
|
/// </summary>
|
[DisplayName("不良数量")]
|
public int DFT_QTY { get; set; } = 0;
|
/// <summary>
|
/// 报废数量
|
/// </summary>
|
[DisplayName("报废数量")]
|
public int SCRAP_QTY { get; set; } = 0;
|
/// <summary>
|
/// 班制编码
|
/// </summary>
|
[DisplayName("班制编码")]
|
public string SFTS_CODE { get; set; }
|
/// <summary>
|
/// 班次编码
|
/// </summary>
|
[DisplayName("班次编码")]
|
public string SFT_CODE { get; set; }
|
/// <summary>
|
/// 时段编码
|
/// </summary>
|
[DisplayName("时段编码")]
|
public string PRD_CODE { get; set; }
|
/// <summary>
|
/// 抽检状态(0Unsampled未抽检|1NoSampling不抽检|2WaitCheck待检验|3Checking检验中|4Completed检验完|5Locked已锁定)
|
/// </summary>
|
[DisplayName("抽检状态(0Unsampled未抽检|1NoSampling不抽检|2WaitCheck待检验|3Checking检验中|4Completed检验完|5Locked已锁定)")]
|
public int OBA_STATUS { get; set; }
|
/// <summary>
|
/// 抽检批次号
|
/// </summary>
|
[DisplayName("抽检批次号")]
|
public string OBA_BATCH { get; set; }
|
/// <summary>
|
/// 锁定批次号
|
/// </summary>
|
[DisplayName("锁定批次号")]
|
public string LOCK_BATCH { get; set; }
|
/// <summary>
|
/// 出货时间
|
/// </summary>
|
[DisplayName("出货时间")]
|
public DateTime SHIPPING_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 出货单号
|
/// </summary>
|
[DisplayName("出货单号")]
|
public string SHIPPING_ORDER { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[DisplayName("备注")]
|
public string REMARK { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_WIP_DATA类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.MES_WIP_DATAId))]//ClassA表中的MES_WIP_DATAId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.MES_WIP_DATAId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
//[Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是MES_WIP_DATA类里面的外键ID字段
|
//public BAS_ITEM ItemInfo { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是MES_WIP_DATA类里面的外键ID字段
|
public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值，只能是null
|
[SugarColumn(IsIgnore = true)]
|
public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG);
|
[Navigate(NavigateType.OneToMany, nameof(MES_WIP_HIS.WIP_ID), nameof(ID), "GHOST_ROW = 0")]//ClassA表中的MES_WIP_DATAId
|
public List<MES_WIP_HIS> _History { get; set; }//注意禁止手动赋值，只能是null
|
[SugarColumn(IsIgnore = true)]
|
public List<MES_WIP_HIS> History => _History?.Any(q => q.UNBIND_FLAG == "Y") == true ? (_History = _History?.Where(q => q.UNBIND_FLAG != "Y").ToList()) : (_History ?? new List<MES_WIP_HIS>());
|
[Navigate(NavigateType.OneToMany, nameof(MES_WIP_DFT.WIP_ID), nameof(ID), "GHOST_ROW = 0")]//ClassA表中的MES_WIP_DATAId
|
public List<MES_WIP_DFT> _Defects { get; set; }//注意禁止手动赋值，只能是null
|
[SugarColumn(IsIgnore = true)]
|
public List<MES_WIP_DFT> Defects => _Defects ?? new List<MES_WIP_DFT>();
|
#endregion
|
|
#region 枚举变量
|
/*例子
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
|
/// <summary>
|
/// 枚举：状态(0Init初始化|10Input已投入|20OK良品过站|30NG不良过站|40Repair维修中|50Output已产出|51WaitStorage待入库|52WaitShipment待出货|60InStorage已入库|61Reject已拒收|80Shipped已出货|90Scrap已报废|91Offline异常下线)
|
/// </summary>
|
public enum STATUSs
|
{
|
[Description("初始化")]
|
Init = 0,
|
[Description("已投入")]
|
Input = 10,
|
[Description("良品过站")]
|
OK = 20,
|
[Description("不良过站")]
|
NG = 30,
|
[Description("维修中")]
|
Repair = 40,
|
[Description("已产出")]
|
Output = 50,
|
[Description("待入库")]
|
WaitStorage = 51,
|
[Description("待出货")]
|
WaitShipment = 52,
|
[Description("已入库")]
|
InStorage = 60,
|
[Description("已拒收")]
|
Reject = 61,
|
[Description("已出货")]
|
Shipped = 80,
|
[Description("已报废")]
|
Scrap = 90,
|
[Description("异常下线")]
|
Offline = 91,
|
}
|
|
/// <summary>
|
/// 枚举：抽检状态(0Unsampled未抽检|1NoSampling不抽检|2WaitCheck待检验|3Checking检验中|4Completed检验完|5Locked已锁定)
|
/// </summary>
|
public enum OBA_STATUSs
|
{
|
[Description("未抽检")]
|
Unsampled = 0,
|
[Description("不抽检")]
|
NoSampling = 1,
|
[Description("待检验")]
|
WaitCheck = 2,
|
[Description("检验中")]
|
Checking = 3,
|
[Description("检验完")]
|
Completed = 4,
|
[Description("已锁定")]
|
Locked = 5,
|
}
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|
