using SqlSugar;
|
|
namespace NewPdaSqlServer.entity;
|
|
/// <summary>
|
/// </summary>
|
[SugarTable("WOMDAA")]
|
public class Womdaa
|
{
|
/// <summary>
|
/// 默认值: (newid())
|
/// </summary>
|
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "pbaGuid")]
|
public Guid? PbaGuid { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "caaGuid")]
|
public Guid? CaaGuid { get; set; }
|
|
///// <summary>
|
///// 自增列
|
///// </summary>
|
//[SugarColumn(ColumnName = "id")]
|
//public int? Id { get; set; }
|
|
///// <summary>
|
///// 排产ID
|
///// </summary>
|
//[SugarColumn(ColumnName = "pid")]
|
//public int? 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 int? Daa008 { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "daa009")]
|
public string? Daa009 { get; set; }
|
|
/// <summary>
|
/// 入库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "daa010")]
|
public int? Daa010 { get; set; }
|
|
/// <summary>
|
/// 已生产量
|
/// </summary>
|
[SugarColumn(ColumnName = "daa011")]
|
public int? Daa011 { get; set; }
|
|
/// <summary>
|
/// 报废数量
|
/// </summary>
|
[SugarColumn(ColumnName = "daa012")]
|
public int? 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 int? 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-通知
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "daa022")]
|
public int? Daa022 { get; set; }
|
|
/// <summary>
|
/// 生产序号
|
/// </summary>
|
[SugarColumn(ColumnName = "daa023")]
|
public int? 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 int? 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 int? Daa027 { get; set; }
|
|
/// <summary>
|
/// 备料完成时间
|
/// </summary>
|
[SugarColumn(ColumnName = "daa028")]
|
public string? Daa028 { get; set; }
|
|
/// <summary>
|
/// 标准工时
|
/// </summary>
|
[SugarColumn(ColumnName = "prod_hour")]
|
public int? ProdHour { get; set; }
|
|
/// <summary>
|
/// 单人小时产能
|
/// </summary>
|
[SugarColumn(ColumnName = "person_hour_capacity")]
|
public int? PersonHourCapacity { get; set; }
|
|
/// <summary>
|
/// 理论标产
|
/// </summary>
|
[SugarColumn(ColumnName = "the_capacity")]
|
public int? TheCapacity { get; set; }
|
|
/// <summary>
|
/// 计划用人数
|
/// </summary>
|
[SugarColumn(ColumnName = "plan_personnel")]
|
public int? PlanPersonnel { get; set; }
|
|
/// <summary>
|
/// 计划标准产能
|
/// </summary>
|
[SugarColumn(ColumnName = "plan_capacity")]
|
public int? PlanCapacity { get; set; }
|
|
/// <summary>
|
/// 理论用时/M
|
/// </summary>
|
[SugarColumn(ColumnName = "the_min")]
|
public int? TheMin { get; set; }
|
|
/// <summary>
|
/// 理论用时/H
|
/// </summary>
|
[SugarColumn(ColumnName = "the_hour")]
|
public int? TheHour { get; set; }
|
|
/// <summary>
|
/// 线体类别
|
/// </summary>
|
[SugarColumn(ColumnName = "line_type")]
|
public string? LineType { get; set; }
|
|
/// <summary>
|
/// 标准人数
|
/// </summary>
|
[SugarColumn(ColumnName = "personnel")]
|
public int? Personnel { get; set; }
|
|
/// <summary>
|
/// 换线时间
|
/// </summary>
|
[SugarColumn(ColumnName = "change_line_time")]
|
public int? ChangeLineTime { get; set; }
|
|
/// <summary>
|
/// 休息时间
|
/// </summary>
|
[SugarColumn(ColumnName = "rest_time")]
|
public int? RestTime { get; set; }
|
|
/// <summary>
|
/// 排产序号
|
/// </summary>
|
[SugarColumn(ColumnName = "schedule_order")]
|
public int? 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 int? Prodts { get; set; }
|
|
/// <summary>
|
/// 预计备料时间
|
/// </summary>
|
[SugarColumn(ColumnName = "prepare_time")]
|
public DateTime? PrepareTime { get; set; }
|
|
/// <summary>
|
/// 插件投入人数
|
/// </summary>
|
[SugarColumn(ColumnName = "cj_worker")]
|
public int? CjWorker { get; set; }
|
|
/// <summary>
|
/// 插件计划投入人数
|
/// </summary>
|
[SugarColumn(ColumnName = "p_cj_worker")]
|
public int? PCjWorker { get; set; }
|
|
/// <summary>
|
/// 插件日产量
|
/// </summary>
|
[SugarColumn(ColumnName = "cj_daily_out")]
|
public int? CjDailyOut { get; set; }
|
|
/// <summary>
|
/// 插件标准工时
|
/// </summary>
|
[SugarColumn(ColumnName = "cj_std_hour")]
|
public int? CjStdHour { get; set; }
|
|
/// <summary>
|
/// 锡焊投入人数
|
/// </summary>
|
[SugarColumn(ColumnName = "hx_worker")]
|
public int? HxWorker { get; set; }
|
|
/// <summary>
|
/// 锡焊计划投入人数
|
/// </summary>
|
[SugarColumn(ColumnName = "p_hx_worker")]
|
public int? PHxWorker { get; set; }
|
|
/// <summary>
|
/// 锡焊日产量
|
/// </summary>
|
[SugarColumn(ColumnName = "hx_daily_out")]
|
public int? HxDailyOut { get; set; }
|
|
/// <summary>
|
/// 锡焊标准工时
|
/// </summary>
|
[SugarColumn(ColumnName = "hx_std_hour")]
|
public int? HxStdHour { get; set; }
|
|
/// <summary>
|
/// 插件数量
|
/// </summary>
|
[SugarColumn(ColumnName = "cj_num")]
|
public int? CjNum { get; set; }
|
|
/// <summary>
|
/// 客户
|
/// </summary>
|
[SugarColumn(ColumnName = "cust")]
|
public string? Cust { get; set; }
|
|
/// <summary>
|
/// 是否首检
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_SJ")]
|
public int? IsSj { get; set; }
|
|
/// <summary>
|
/// 产品编码
|
/// </summary>
|
[SugarColumn(ColumnName = "daa029")]
|
public string? Daa029 { get; set; }
|
|
/// <summary>
|
/// 实际线体编码
|
/// </summary>
|
[SugarColumn(ColumnName = "sj_xt")]
|
public string? SjXt { get; set; }
|
}
|
