using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;
namespace Tiger.Model
{
///
/// 实体:工单批次
///
[Description("Primary:ID")]
[DisplayName("工单批次")]
[Serializable]
[SugarTable("BIZ_MES_WO_BATCH")]
public class BIZ_MES_WO_BATCH : DbEntityWithAuth
{
#region 构造函数
///
/// 实体:工单批次
///
public BIZ_MES_WO_BATCH() { }
#endregion
#region 公共属性
///
/// 工单号
///
[DisplayName("工单号")]
public string ORDER_NO { get; set; }
///
/// 工单批次号
///
[DisplayName("工单批次号")]
public string BATCH_NO { get; set; }
///
/// 状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)
///
[DisplayName("状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)")]
public int STATUS { get; set; }
///
/// 是否准备完成(Y/N)
///
[DisplayName("是否准备完成(Y/N)")]
public string IS_READY { get; set; }
///
/// 物料编码
///
[DisplayName("物料编码")]
public string ITEM_CODE { get; set; }
///
/// 客户编码
///
[DisplayName("客户编码")]
public string CUST_CODE { get; set; }
///
/// 工厂
///
[DisplayName("工厂")]
public string FACTORY { get; set; }
///
/// 车间编码
///
[DisplayName("车间编码")]
public string WS_CODE { get; set; }
///
/// 实际线体
///
[DisplayName("实际线体")]
public string ACT_LINE { get; set; }
///
/// 实际开始时间
///
[DisplayName("实际开始时间")]
public DateTime ACT_START_TIME { get; set; } = DateTime.MinValue;
///
/// 实际结束时间
///
[DisplayName("实际结束时间")]
public DateTime ACT_END_TIME { get; set; } = DateTime.MinValue;
///
/// 标准作业人数
///
[DisplayName("标准作业人数")]
public int STD_WORKER_QTY { get; set; }
///
/// 实际作业人数
///
[DisplayName("实际作业人数")]
public int ACT_WORKER_QTY { get; set; }
///
/// 下发时间
///
[DisplayName("下发时间")]
public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue;
///
/// 下发人
///
[DisplayName("下发人")]
public string RELEASE_USER { get; set; }
///
/// 变更时间
///
[DisplayName("变更时间")]
public DateTime CHANGE_TIME { get; set; } = DateTime.MinValue;
///
/// 变更人
///
[DisplayName("变更人")]
public string CHANGE_USER { get; set; }
///
/// 计划数量
///
[DisplayName("计划数量")]
public int PLAN_QTY { get; set; }
///
/// 投入数量
///
[DisplayName("投入数量")]
public int INPUT_QTY { get; set; }
///
/// 完工数量
///
[DisplayName("完工数量")]
public int OUTPUT_QTY { get; set; }
///
/// 报废数量
///
[DisplayName("报废数量")]
public int SCRAP_QTY { get; set; }
///
/// 入库数量
///
[DisplayName("入库数量")]
public int STOCK_IN_QTY { get; set; }
///
/// 首件确认数量
///
[DisplayName("首件确认数量")]
public int FIRST_IN_QTY { get; set; }
///
/// UPH
///
[DisplayName("UPH")]
public double UPH { get; set; }
///
/// UPPH
///
[DisplayName("UPPH")]
public double UPPH { get; set; }
///
/// 备注
///
[DisplayName("备注")]
public string REMARK { get; set; }
#endregion
#region 虚拟属性
/*例子
[SugarColumn(IsIgnore = true)]
public string FieldName { get; set; }
*/
[SugarColumn(IsIgnore = true)]
public string VALIDATION_TYPE { get; set; }
[SugarColumn(IsIgnore = true)]
public string VALIDATION_RESULT { 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 ClassAList { get; set; }//注意禁止手动赋值,只能是null
//多对多外键导航
[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_MES_WO_BATCHId), nameof(MappingClass.ClassAId))]//注意顺序
public List 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 _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,
}
*/
///
/// 枚举:状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)
///
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
}