using SqlSugar;
|
|
namespace NewPdaSqlServer.entity;
|
|
/// <summary>
|
/// 报工主表
|
/// </summary>
|
[SugarTable("MES_WORK_PROD")]
|
public class MesWorkProd
|
{
|
/// <summary>
|
/// 唯一标识符
|
/// 默认值: (newid())
|
/// </summary>
|
[SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
|
public Guid Id { get; set; }
|
|
/// <summary>
|
/// 报工单号
|
/// </summary>
|
[SugarColumn(ColumnName = "bill_no")]
|
public string BillNo { get; set; }
|
|
/// <summary>
|
/// 生产线
|
/// </summary>
|
[SugarColumn(ColumnName = "line_no")]
|
public string LineNo { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "company")]
|
public string Company { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "factory")]
|
public string Factory { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "create_by")]
|
public string CreateBy { get; set; }
|
|
/// <summary>
|
/// 创建日期
|
/// 默认值: (getdate())
|
/// </summary>
|
[SugarColumn(ColumnName = "create_date")]
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "lastupdate_by")]
|
public string LastupdateBy { get; set; }
|
|
/// <summary>
|
/// 默认值: (getdate())
|
/// </summary>
|
[SugarColumn(ColumnName = "lastupdate_date")]
|
public DateTime? LastupdateDate { get; set; }
|
|
/// <summary>
|
/// 班次
|
/// </summary>
|
[SugarColumn(ColumnName = "class_no")]
|
public string ClassNo { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "check_user")]
|
public string CheckUser { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "check_date")]
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "status")]
|
public int? Status { get; set; }
|
|
/// <summary>
|
/// 派工单号
|
/// </summary>
|
[SugarColumn(ColumnName = "pbill_no")]
|
public string PbillNo { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "bill_type_id")]
|
public decimal? BillTypeId { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "transaction_no")]
|
public decimal? TransactionNo { get; set; }
|
|
/// <summary>
|
/// 任务单号
|
/// </summary>
|
[SugarColumn(ColumnName = "task_no")]
|
public string TaskNo { get; set; }
|
|
/// <summary>
|
/// 卡板数量
|
/// </summary>
|
[SugarColumn(ColumnName = "kb_qty")]
|
public decimal? KbQty { get; set; }
|
|
/// <summary>
|
/// 每箱数量
|
/// </summary>
|
[SugarColumn(ColumnName = "box_qty")]
|
public decimal? BoxQty { get; set; }
|
|
/// <summary>
|
/// 报工人员
|
/// </summary>
|
[SugarColumn(ColumnName = "report_by")]
|
public string? ReportBy { get; set; }
|
/// <summary>
|
/// 报工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "report_date")]
|
public DateTime? ReportDate { get; set; }
|
}
|
