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; }
|
/// <summary>
|
/// 排产推送标识
|
///</summary>
|
[SugarColumn(ColumnName = "PRODTS")]
|
public decimal? Prodts { get; set; }
|
/// <summary>
|
/// 预计备料时间
|
///</summary>
|
[SugarColumn(ColumnName = "PREPARE_TIME")]
|
public DateTime? PrepareTime { get; set; }
|
/// <summary>
|
/// 插件投入人数
|
///</summary>
|
[SugarColumn(ColumnName = "CJ_WORKER")]
|
public decimal? CjWorker { get; set; }
|
/// <summary>
|
/// 插件计划投入人数
|
///</summary>
|
[SugarColumn(ColumnName = "P_CJ_WORKER")]
|
public decimal? PCjWorker { get; set; }
|
/// <summary>
|
/// 插件日产量
|
///</summary>
|
[SugarColumn(ColumnName = "CJ_DAILY_OUT")]
|
public decimal? CjDailyOut { get; set; }
|
/// <summary>
|
/// 插件标准工时
|
///</summary>
|
[SugarColumn(ColumnName = "CJ_STD_HOUR")]
|
public decimal? CjStdHour { get; set; }
|
/// <summary>
|
/// 锡焊投入人数
|
///</summary>
|
[SugarColumn(ColumnName = "HX_WORKER")]
|
public decimal? HxWorker { get; set; }
|
/// <summary>
|
/// 锡焊计划投入人数
|
///</summary>
|
[SugarColumn(ColumnName = "P_HX_WORKER")]
|
public decimal? PHxWorker { get; set; }
|
/// <summary>
|
/// 锡焊日产量
|
///</summary>
|
[SugarColumn(ColumnName = "HX_DAILY_OUT")]
|
public decimal? HxDailyOut { get; set; }
|
/// <summary>
|
/// 锡焊标准工时
|
///</summary>
|
[SugarColumn(ColumnName = "HX_STD_HOUR")]
|
public decimal? HxStdHour { get; set; }
|
/// <summary>
|
/// 插件数量
|
///</summary>
|
[SugarColumn(ColumnName = "CJ_NUM")]
|
public decimal? CjNum { get; set; }
|
/// <summary>
|
/// 客户
|
///</summary>
|
[SugarColumn(ColumnName = "CUST")]
|
public string Cust { get; set; }
|
/// <summary>
|
/// 总装工序 1打标 4加工 2组装 3包装
|
///</summary>
|
[SugarColumn(ColumnName = "ZZ_GX")]
|
public decimal? ZzGx { get; set; }
|
/// <summary>
|
/// 通知备料时间
|
///</summary>
|
[SugarColumn(ColumnName = "DAA029")]
|
public DateTime? Daa029 { get; set; }
|
/// <summary>
|
/// 销售订单号（目前三楼增补使用）
|
///</summary>
|
[SugarColumn(ColumnName = "XSDDH")]
|
public string Xsddh { get; set; }
|
/// <summary>
|
///
|
///</summary>
|
[SugarColumn(ColumnName = "TEST")]
|
public decimal? Test { get; set; }
|
|
}
|
