using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：备料任务(WMS)物料明细
|
/// </summary>
|
[Description("Primary:ID")]
|
[DisplayName("备料任务(WMS)物料明细")]
|
[Serializable]
|
[SugarTable("BIZ_WMS_PREP_DTL")]
|
public class BIZ_WMS_PREP_DTL : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：备料任务(WMS)物料明细
|
/// </summary>
|
public BIZ_WMS_PREP_DTL() {}
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 备料任务号
|
/// </summary>
|
[DisplayName("备料任务号")]
|
public string ORDER_NO { get; set; }
|
/// <summary>
|
/// 备料任务行号
|
/// </summary>
|
[DisplayName("备料任务行号")]
|
public string ORDER_LINE { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[DisplayName("物料编码")]
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 替代料，多个用“,”分隔
|
/// </summary>
|
[DisplayName("替代料，多个用“,”分隔")]
|
public string SUBITEM_CODE { get; set; }
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[DisplayName("单位")]
|
public string UNIT { get; set; }
|
/// <summary>
|
/// 生产计划损耗比例(%)
|
/// </summary>
|
[DisplayName("生产计划损耗比例(%)")]
|
public double PLAN_LOSS_RATE { get; set; }
|
/// <summary>
|
/// 生产计划损耗数量
|
/// </summary>
|
[DisplayName("生产计划损耗数量")]
|
public double PLAN_LOSS_QTY { get; set; }
|
/// <summary>
|
/// 是否计算损耗(Y/N)
|
/// </summary>
|
[DisplayName("是否计算损耗(Y/N)")]
|
public string IS_CALC_LOSS { get; set; }
|
/// <summary>
|
/// 是否最小包装发料(Y/N)
|
/// </summary>
|
[DisplayName("是否最小包装发料(Y/N)")]
|
public string IS_WHOLE { get; set; }
|
/// <summary>
|
/// 来源单据编码，多个用“,”分隔
|
/// </summary>
|
[DisplayName("来源单据编码，多个用“,”分隔")]
|
public string SOURCE_CODE { get; set; }
|
/// <summary>
|
/// 来源单号，多个用“,”分隔，跟编码一一对应
|
/// </summary>
|
[DisplayName("来源单号，多个用“,”分隔，跟编码一一对应")]
|
public string SOURCE_ORDER { get; set; }
|
/// <summary>
|
/// 来源单行号，多个用“,”分隔，跟编码一一对应
|
/// </summary>
|
[DisplayName("来源单行号，多个用“,”分隔，跟编码一一对应")]
|
public string SOURCE_LINE { get; set; }
|
/// <summary>
|
/// 状态(0UnCalc未计算|1FistrLack首套缺料|2SupplyLack补料缺料|3Enough满足需求|4NoCalc不参与备料计算|5Cancel已作废|6Finish备料完成)
|
/// </summary>
|
[DisplayName("状态(0UnCalc未计算|1FistrLack首套缺料|2SupplyLack补料缺料|3Enough满足需求|4NoCalc不参与备料计算|5Cancel已作废|6Finish备料完成)")]
|
public int STATUS { get; set; }
|
/// <summary>
|
/// 单位用量
|
/// </summary>
|
[DisplayName("单位用量")]
|
public double QTY_UNIT { get; set; }
|
/// <summary>
|
/// 需求数量
|
/// </summary>
|
[DisplayName("需求数量")]
|
public double QTY_REQ { get; set; }
|
/// <summary>
|
/// 已备料数量
|
/// </summary>
|
[DisplayName("已备料数量")]
|
public double QTY_PREP { get; set; }
|
/// <summary>
|
/// 发出数量
|
/// </summary>
|
[DisplayName("发出数量")]
|
public double QTY_DLVY { 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 SMT_NO { get; set; }
|
/// <summary>
|
/// 站位号
|
/// </summary>
|
[DisplayName("站位号")]
|
public string STATION_NO { get; set; }
|
/// <summary>
|
/// 飞达号
|
/// </summary>
|
[DisplayName("飞达号")]
|
public string FEEDER_NO { get; set; }
|
/// <summary>
|
/// 料枪类型
|
/// </summary>
|
[DisplayName("料枪类型")]
|
public string FEEDER_TYPE { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[DisplayName("备注")]
|
public string REMARK { get; set; }
|
/// <summary>
|
/// 计算字段无需更新和显示
|
/// </summary>
|
[DisplayName("计算字段无需更新和显示")]
|
public double TEMP_QTY { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
[SugarColumn(IsIgnore = true)]
|
public string ERP_WH { get; set; }
|
[SugarColumn(IsIgnore = true)]
|
public string WH_ID { get; set; }
|
[SugarColumn(IsIgnore = true)]
|
public string REGION_ID { get; set; }
|
[SugarColumn(IsIgnore = true)]
|
public string SHELF_ID { get; set; }
|
[SugarColumn(IsIgnore = true)]
|
public List<SuggestItem> Suggests { get; set; }
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_WMS_PREP_DTL类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_WMS_PREP_DTLId))]//ClassA表中的BIZ_WMS_PREP_DTLId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_WMS_PREP_DTLId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
#endregion
|
|
#region 枚举变量
|
/*例子
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
|
/// <summary>
|
/// 枚举：状态(0UnCalc未计算|1FistrLack首套缺料|2SupplyLack补料缺料|3Enough满足需求|4NoCalc不参与备料计算|5Cancel已作废|6Finish备料完成)
|
/// </summary>
|
public enum STATUSs
|
{
|
[Description("未计算")]
|
UnCalc = 0,
|
[Description("首套缺料")]
|
FistrLack = 1,
|
[Description("补料缺料")]
|
SupplyLack = 2,
|
[Description("满足需求")]
|
Enough = 3,
|
[Description("不参与备料计算")]
|
NoCalc = 4,
|
[Description("已作废")]
|
Cancel = 5,
|
[Description("备料完成")]
|
Finish = 6,
|
}
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|
