using SqlSugar; namespace MES.Service.Modes; /// /// 工单指令表 /// [SugarTable("WOMDAA")] public class Womdaa { /// /// 自增列 /// [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal? Id { get; set; } /// /// 排产ID /// [SugarColumn(ColumnName = "PID")] public decimal? Pid { get; set; } /// /// 单号 /// [SugarColumn(ColumnName = "DAA001")] public string Daa001 { get; set; } /// /// 产品ID /// [SugarColumn(ColumnName = "DAA002")] public string Daa002 { get; set; } /// /// 产品名称 /// [SugarColumn(ColumnName = "DAA003")] public string Daa003 { get; set; } /// /// 产品规格 /// [SugarColumn(ColumnName = "DAA004")] public string Daa004 { get; set; } /// /// 单位 /// [SugarColumn(ColumnName = "DAA005")] public string Daa005 { get; set; } /// /// ERP预计开工时间 /// [SugarColumn(ColumnName = "DAA006")] public DateTime? Daa006 { get; set; } /// /// ERP预计完工时间 /// [SugarColumn(ColumnName = "DAA007")] public DateTime? Daa007 { get; set; } /// /// 工单数量 /// [SugarColumn(ColumnName = "DAA008")] public decimal? Daa008 { get; set; } /// /// 备注 /// [SugarColumn(ColumnName = "DAA009")] public string Daa009 { get; set; } /// /// 入库数量 /// [SugarColumn(ColumnName = "DAA010")] public decimal? Daa010 { get; set; } /// /// 已生产量 /// [SugarColumn(ColumnName = "DAA011")] public decimal? Daa011 { get; set; } /// /// 报废数量 /// [SugarColumn(ColumnName = "DAA012")] public decimal? Daa012 { get; set; } /// /// 工作车间 /// [SugarColumn(ColumnName = "DAA013")] public string Daa013 { get; set; } /// /// 投料单单号 /// [SugarColumn(ColumnName = "DAA014")] public string Daa014 { get; set; } /// /// 生产线别 /// [SugarColumn(ColumnName = "DAA015")] public string Daa015 { get; set; } /// /// 实际开工日 /// [SugarColumn(ColumnName = "DAA016")] public DateTime? Daa016 { get; set; } /// /// 实际完工日 /// [SugarColumn(ColumnName = "DAA017")] public DateTime? Daa017 { get; set; } /// /// 工单状态 /// [SugarColumn(ColumnName = "DAA018")] public string Daa018 { get; set; } /// /// 齐套状态 /// [SugarColumn(ColumnName = "DAA019")] public string Daa019 { get; set; } /// /// 审核码 /// [SugarColumn(ColumnName = "FSTATUS")] public decimal? Fstatus { get; set; } /// /// 审核日期 /// [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// /// 审核人 /// [SugarColumn(ColumnName = "CHECK_USER")] public string CheckUser { get; set; } /// /// 线别编码 /// [SugarColumn(ColumnName = "DAA020")] public string Daa020 { get; set; } /// /// 任务单单号 /// [SugarColumn(ColumnName = "DAA021")] public string Daa021 { get; set; } /// /// 通知备料,0-未通知,1-通知 /// [SugarColumn(ColumnName = "DAA022")] public decimal? Daa022 { get; set; } /// /// 生产序号 /// [SugarColumn(ColumnName = "DAA023")] public decimal? Daa023 { get; set; } /// /// 排产日期 /// [SugarColumn(ColumnName = "DAA024")] public string Daa024 { get; set; } /// /// 首件是否检验1-检验,0未检验 /// [SugarColumn(ColumnName = "DAA025")] public string Daa025 { get; set; } /// /// 首件检验结果 /// [SugarColumn(ColumnName = "DAA026")] public string Daa026 { get; set; } /// /// 已报检,0-未报检,1-已报检 /// [SugarColumn(ColumnName = "IS_REPORTCHECK")] public decimal? IsReportcheck { get; set; } /// /// 报检人 /// [SugarColumn(ColumnName = "USNAME")] public string Usname { get; set; } /// /// 报检时间 /// [SugarColumn(ColumnName = "REPORTTIME")] public DateTime? Reporttime { get; set; } /// /// 机台编号 /// [SugarColumn(ColumnName = "MACHINE_NO")] public string MachineNo { get; set; } /// /// 备料完成1-完成,0未完成 /// [SugarColumn(ColumnName = "DAA027")] public decimal? Daa027 { get; set; } /// /// 备料完成时间 /// [SugarColumn(ColumnName = "DAA028")] public string Daa028 { get; set; } /// /// 标准工时 /// [SugarColumn(ColumnName = "PROD_HOUR")] public decimal? ProdHour { get; set; } /// /// 单人小时产能 /// [SugarColumn(ColumnName = "PERSON_HOUR_CAPACITY")] public decimal? PersonHourCapacity { get; set; } /// /// 理论标产 /// [SugarColumn(ColumnName = "THE_CAPACITY")] public decimal? TheCapacity { get; set; } /// /// 计划用人数 /// [SugarColumn(ColumnName = "PLAN_PERSONNEL")] public decimal? PlanPersonnel { get; set; } /// /// 计划标准产能 /// [SugarColumn(ColumnName = "PLAN_CAPACITY")] public decimal? PlanCapacity { get; set; } /// /// 理论用时/M /// [SugarColumn(ColumnName = "THE_MIN")] public decimal? TheMin { get; set; } /// /// 理论用时/H /// [SugarColumn(ColumnName = "THE_HOUR")] public decimal? TheHour { get; set; } /// /// 线体类别 /// [SugarColumn(ColumnName = "LINE_TYPE")] public string LineType { get; set; } /// /// 标准人数 /// [SugarColumn(ColumnName = "PERSONNEL")] public decimal? Personnel { get; set; } /// /// 换线时间 /// [SugarColumn(ColumnName = "CHANGE_LINE_TIME")] public decimal? ChangeLineTime { get; set; } /// /// 休息时间 /// [SugarColumn(ColumnName = "REST_TIME")] public decimal? RestTime { get; set; } /// /// 排产序号 /// [SugarColumn(ColumnName = "SCHEDULE_ORDER")] public decimal? ScheduleOrder { get; set; } /// /// MES预计开工时间 /// [SugarColumn(ColumnName = "MES_START_PROD")] public DateTime? MesStartProd { get; set; } /// /// MES预计完工时间 /// [SugarColumn(ColumnName = "MES_END_PROD")] public DateTime? MesEndProd { get; set; } /// /// 排产推送标识 /// [SugarColumn(ColumnName = "PRODTS")] public decimal? Prodts { get; set; } /// /// 预计备料时间 /// [SugarColumn(ColumnName = "PREPARE_TIME")] public DateTime? PrepareTime { get; set; } /// /// 插件投入人数 /// [SugarColumn(ColumnName = "CJ_WORKER")] public decimal? CjWorker { get; set; } /// /// 插件计划投入人数 /// [SugarColumn(ColumnName = "P_CJ_WORKER")] public decimal? PCjWorker { get; set; } /// /// 插件日产量 /// [SugarColumn(ColumnName = "CJ_DAILY_OUT")] public decimal? CjDailyOut { get; set; } /// /// 插件标准工时 /// [SugarColumn(ColumnName = "CJ_STD_HOUR")] public decimal? CjStdHour { get; set; } /// /// 锡焊投入人数 /// [SugarColumn(ColumnName = "HX_WORKER")] public decimal? HxWorker { get; set; } /// /// 锡焊计划投入人数 /// [SugarColumn(ColumnName = "P_HX_WORKER")] public decimal? PHxWorker { get; set; } /// /// 锡焊日产量 /// [SugarColumn(ColumnName = "HX_DAILY_OUT")] public decimal? HxDailyOut { get; set; } /// /// 锡焊标准工时 /// [SugarColumn(ColumnName = "HX_STD_HOUR")] public decimal? HxStdHour { get; set; } /// /// 插件数量 /// [SugarColumn(ColumnName = "CJ_NUM")] public decimal? CjNum { get; set; } /// /// 客户 /// [SugarColumn(ColumnName = "CUST")] public string Cust { get; set; } /// /// 总装工序 1打标 4加工 2组装 3包装 /// [SugarColumn(ColumnName = "ZZ_GX")] public decimal? ZzGx { get; set; } /// /// 通知备料时间 /// [SugarColumn(ColumnName = "DAA029")] public DateTime? Daa029 { get; set; } /// /// 销售订单号(目前三楼增补使用) /// [SugarColumn(ColumnName = "XSDDH")] public string Xsddh { get; set; } /// /// /// [SugarColumn(ColumnName = "TEST")] public decimal? Test { get; set; } }