using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 工单指令表
|
/// </summary>
|
[SugarTable("WOMDAA")]
|
public class Womdaa
|
{
|
/// <summary>
|
/// 自增列
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
|
public decimal? Id { get; set; }
|
|
/// <summary>
|
/// 排产ID
|
/// </summary>
|
[SugarColumn(ColumnName = "PID")]
|
public decimal? Pid { get; set; }
|
|
/// <summary>
|
/// 单号
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA001")]
|
public string? Daa001 { get; set; }
|
|
/// <summary>
|
/// 产品ID
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA002")]
|
public string? Daa002 { get; set; }
|
|
/// <summary>
|
/// 产品名称
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA003")]
|
public string? Daa003 { get; set; }
|
|
/// <summary>
|
/// 产品规格
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA004")]
|
public string? Daa004 { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA005")]
|
public string? Daa005 { get; set; }
|
|
/// <summary>
|
/// ERP预计开工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA006")]
|
public DateTime? Daa006 { get; set; }
|
|
/// <summary>
|
/// ERP预计完工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA007")]
|
public DateTime? Daa007 { get; set; }
|
|
/// <summary>
|
/// 工单数量
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA008")]
|
public decimal? Daa008 { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA009")]
|
public string? Daa009 { get; set; }
|
|
/// <summary>
|
/// 入库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA010")]
|
public decimal? Daa010 { get; set; }
|
|
/// <summary>
|
/// 已生产量
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA011")]
|
public decimal? Daa011 { get; set; }
|
|
/// <summary>
|
/// 报废数量
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA012")]
|
public decimal? Daa012 { get; set; }
|
|
/// <summary>
|
/// 工作车间
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA013")]
|
public string? Daa013 { get; set; }
|
|
/// <summary>
|
/// 投料单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA014")]
|
public string? Daa014 { get; set; }
|
|
/// <summary>
|
/// 生产线别
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA015")]
|
public string? Daa015 { get; set; }
|
|
/// <summary>
|
/// 实际开工日
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA016")]
|
public DateTime? Daa016 { get; set; }
|
|
/// <summary>
|
/// 实际完工日
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA017")]
|
public DateTime? Daa017 { get; set; }
|
|
/// <summary>
|
/// 工单状态
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA018")]
|
public string? Daa018 { get; set; }
|
|
/// <summary>
|
/// 齐套状态
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA019")]
|
public string? Daa019 { get; set; }
|
|
/// <summary>
|
/// 审核码
|
/// </summary>
|
[SugarColumn(ColumnName = "FSTATUS")]
|
public decimal? Fstatus { get; set; }
|
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_DATE")]
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_USER")]
|
public string? CheckUser { get; set; }
|
|
/// <summary>
|
/// 线别编码
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA020")]
|
public string? Daa020 { get; set; }
|
|
/// <summary>
|
/// 任务单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA021")]
|
public string? Daa021 { get; set; }
|
|
/// <summary>
|
/// 通知备料，0-未通知，1-通知
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA022")]
|
public decimal? Daa022 { get; set; }
|
|
/// <summary>
|
/// 生产序号
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA023")]
|
public decimal? Daa023 { get; set; }
|
|
/// <summary>
|
/// 排产日期
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA024")]
|
public string? Daa024 { get; set; }
|
|
/// <summary>
|
/// 首件是否检验1-检验，0未检验
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA025")]
|
public string? Daa025 { get; set; }
|
|
/// <summary>
|
/// 首件检验结果
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA026")]
|
public string? Daa026 { get; set; }
|
|
/// <summary>
|
/// 已报检，0-未报检，1-已报检
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_REPORTCHECK")]
|
public decimal? IsReportcheck { get; set; }
|
|
/// <summary>
|
/// 报检人
|
/// </summary>
|
[SugarColumn(ColumnName = "USNAME")]
|
public string? Usname { get; set; }
|
|
/// <summary>
|
/// 报检时间
|
/// </summary>
|
[SugarColumn(ColumnName = "REPORTTIME")]
|
public DateTime? Reporttime { get; set; }
|
|
/// <summary>
|
/// 机台编号
|
/// </summary>
|
[SugarColumn(ColumnName = "MACHINE_NO")]
|
public string? MachineNo { get; set; }
|
|
/// <summary>
|
/// 备料完成1-完成，0未完成
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA027")]
|
public decimal? Daa027 { get; set; }
|
|
/// <summary>
|
/// 备料完成时间
|
/// </summary>
|
[SugarColumn(ColumnName = "DAA028")]
|
public string? Daa028 { get; set; }
|
|
/// <summary>
|
/// 标准工时
|
/// </summary>
|
[SugarColumn(ColumnName = "PROD_HOUR")]
|
public decimal? ProdHour { get; set; }
|
|
/// <summary>
|
/// 单人小时产能
|
/// </summary>
|
[SugarColumn(ColumnName = "PERSON_HOUR_CAPACITY")]
|
public decimal? PersonHourCapacity { get; set; }
|
|
/// <summary>
|
/// 理论标产
|
/// </summary>
|
[SugarColumn(ColumnName = "THE_CAPACITY")]
|
public decimal? TheCapacity { get; set; }
|
|
/// <summary>
|
/// 计划用人数
|
/// </summary>
|
[SugarColumn(ColumnName = "PLAN_PERSONNEL")]
|
public decimal? PlanPersonnel { get; set; }
|
|
/// <summary>
|
/// 计划标准产能
|
/// </summary>
|
[SugarColumn(ColumnName = "PLAN_CAPACITY")]
|
public decimal? PlanCapacity { get; set; }
|
|
/// <summary>
|
/// 理论用时/M
|
/// </summary>
|
[SugarColumn(ColumnName = "THE_MIN")]
|
public decimal? TheMin { get; set; }
|
|
/// <summary>
|
/// 理论用时/H
|
/// </summary>
|
[SugarColumn(ColumnName = "THE_HOUR")]
|
public decimal? TheHour { get; set; }
|
|
/// <summary>
|
/// 线体类别
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_TYPE")]
|
public string? LineType { get; set; }
|
|
/// <summary>
|
/// 标准人数
|
/// </summary>
|
[SugarColumn(ColumnName = "PERSONNEL")]
|
public decimal? Personnel { get; set; }
|
|
/// <summary>
|
/// 换线时间
|
/// </summary>
|
[SugarColumn(ColumnName = "CHANGE_LINE_TIME")]
|
public decimal? ChangeLineTime { get; set; }
|
|
/// <summary>
|
/// 休息时间
|
/// </summary>
|
[SugarColumn(ColumnName = "REST_TIME")]
|
public decimal? RestTime { get; set; }
|
|
/// <summary>
|
/// 排产序号
|
/// </summary>
|
[SugarColumn(ColumnName = "SCHEDULE_ORDER")]
|
public decimal? ScheduleOrder { get; set; }
|
|
/// <summary>
|
/// MES预计开工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "MES_START_PROD")]
|
public DateTime? MesStartProd { get; set; }
|
|
/// <summary>
|
/// MES预计完工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "MES_END_PROD")]
|
public DateTime? MesEndProd { get; set; }
|
}
|
