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("BIZ_MES_WO_BATCH")]
|
public class BIZ_MES_WO_BATCH : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：工单批次
|
/// </summary>
|
public BIZ_MES_WO_BATCH() { }
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
[DisplayName("工单号")]
|
public string ORDER_NO { get; set; }
|
/// <summary>
|
/// 工单批次号
|
/// </summary>
|
[DisplayName("工单批次号")]
|
public string BATCH_NO { get; set; }
|
/// <summary>
|
/// 状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)
|
/// </summary>
|
[DisplayName("状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)")]
|
public int STATUS { get; set; }
|
/// <summary>
|
/// 是否准备完成(Y/N)
|
/// </summary>
|
[DisplayName("是否准备完成(Y/N)")]
|
public string IS_READY { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[DisplayName("物料编码")]
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 客户编码
|
/// </summary>
|
[DisplayName("客户编码")]
|
public string CUST_CODE { get; set; }
|
/// <summary>
|
/// 工厂
|
/// </summary>
|
[DisplayName("工厂")]
|
public string FACTORY { get; set; }
|
/// <summary>
|
/// 车间编码
|
/// </summary>
|
[DisplayName("车间编码")]
|
public string WS_CODE { get; set; }
|
/// <summary>
|
/// 实际线体
|
/// </summary>
|
[DisplayName("实际线体")]
|
public string ACT_LINE { get; set; }
|
/// <summary>
|
/// 实际开始时间
|
/// </summary>
|
[DisplayName("实际开始时间")]
|
public DateTime ACT_START_TIME { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 实际结束时间
|
/// </summary>
|
[DisplayName("实际结束时间")]
|
public DateTime ACT_END_TIME { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 标准作业人数
|
/// </summary>
|
[DisplayName("标准作业人数")]
|
public int STD_WORKER_QTY { get; set; }
|
/// <summary>
|
/// 实际作业人数
|
/// </summary>
|
[DisplayName("实际作业人数")]
|
public int ACT_WORKER_QTY { get; set; }
|
/// <summary>
|
/// 下发时间
|
/// </summary>
|
[DisplayName("下发时间")]
|
public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 下发人
|
/// </summary>
|
[DisplayName("下发人")]
|
public string RELEASE_USER { get; set; }
|
/// <summary>
|
/// 计划数量
|
/// </summary>
|
[DisplayName("计划数量")]
|
public int PLAN_QTY { get; set; }
|
/// <summary>
|
/// 投入数量
|
/// </summary>
|
[DisplayName("投入数量")]
|
public int INPUT_QTY { get; set; }
|
/// <summary>
|
/// 完工数量
|
/// </summary>
|
[DisplayName("完工数量")]
|
public int OUTPUT_QTY { get; set; }
|
/// <summary>
|
/// 报废数量
|
/// </summary>
|
[DisplayName("报废数量")]
|
public int SCRAP_QTY { get; set; }
|
/// <summary>
|
/// 入库数量
|
/// </summary>
|
[DisplayName("入库数量")]
|
public int STOCK_IN_QTY { get; set; }
|
/// <summary>
|
/// 首件确认数量
|
/// </summary>
|
[DisplayName("首件确认数量")]
|
public int FIRST_IN_QTY { get; set; }
|
/// <summary>
|
/// UPH
|
/// </summary>
|
[DisplayName("UPH")]
|
public double UPH { get; set; }
|
/// <summary>
|
/// UPPH
|
/// </summary>
|
[DisplayName("UPPH")]
|
public double UPPH { 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是BIZ_MES_WO_BATCH类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_MES_WO_BATCHId))]//ClassA表中的BIZ_MES_WO_BATCHId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_MES_WO_BATCHId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { 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.OneToOne, nameof(CUST_CODE), nameof(BAS_CUSTOMER.CUST_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_MES_WO类里面的外键ID字段
|
public BAS_CUSTOMER Customer { get; set; } //注意禁止手动赋值，只能是null
|
#endregion
|
|
#region 枚举变量
|
/*例子
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
|
/// <summary>
|
/// 枚举：状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)
|
/// </summary>
|
public enum STATUSs
|
{
|
[Description("初始化")]
|
Init = 0,
|
[Description("已导入")]
|
Imported = 1,
|
[Description("已下发")]
|
Release = 2,
|
[Description("生产中")]
|
Working = 3,
|
[Description("已暂停")]
|
Paused = 4,
|
[Description("已关闭")]
|
Closed = 5,
|
}
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|
