using SqlSugar;
|
|
namespace PadApplication.Entites.DbModels;
|
|
/// <summary>
|
/// 机台报工记录
|
/// </summary>
|
[SugarTable("MES_REPORTING")]
|
public class MesReporting
|
{
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_JTBG",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 工单
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string? BillNo { get; set; }
|
|
/// <summary>
|
/// 产品编码
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 已产数量
|
/// </summary>
|
[SugarColumn(ColumnName = "OK_QTY")]
|
public decimal? OkQty { get; set; }
|
|
/// <summary>
|
/// 报废数量
|
/// </summary>
|
[SugarColumn(ColumnName = "BF_QTY")]
|
public decimal? BfQty { get; set; }
|
|
/// <summary>
|
/// 机台编号
|
/// </summary>
|
[SugarColumn(ColumnName = "MACHINE_NO")]
|
public string? MachineNo { get; set; }
|
|
/// <summary>
|
/// 据点
|
/// </summary>
|
[SugarColumn(ColumnName = "ADDRESS_CODE")]
|
public string? AddressCode { get; set; }
|
|
/// <summary>
|
/// 报工人
|
/// </summary>
|
[SugarColumn(ColumnName = "BG_PERSON")]
|
public string? BgPerson { get; set; }
|
|
/// <summary>
|
/// 报工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "BG_DATE")]
|
public DateTime? BgDate { get; set; }
|
|
/// <summary>
|
/// 最后修改人
|
/// </summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
|
public string? LastupdateBy { get; set; }
|
|
/// <summary>
|
/// 最后修改时间
|
/// </summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_DATE")]
|
public DateTime? LastupdateDate { get; set; }
|
|
/// <summary>
|
/// 产品条码
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO_CADE")]
|
public string? ItemNoCade { get; set; }
|
|
/// <summary>
|
/// 料头克重
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_HEAD_WEIGHT")]
|
public decimal? ItemHeadWeight { get; set; }
|
|
/// <summary>
|
/// 不良名称
|
/// </summary>
|
[SugarColumn(ColumnName = "BF_ITEM_NAME")]
|
public string? BfItemName { get; set; }
|
|
/// <summary>
|
/// 部门ID
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPARTMENT_ID")]
|
public string? DepartmentId { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_BY")]
|
public string? CheckBy { get; set; }
|
|
/// <summary>
|
/// 审核时间
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_DATE")]
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 审核状态: 0 未审核，1审核
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_TYPE")]
|
public decimal? CheckType { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATE_BY")]
|
public string? CreateBy { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK")]
|
public string? Remark { get; set; }
|
|
/// <summary>
|
/// 累计采集数
|
/// </summary>
|
[SugarColumn(ColumnName = "CJ_QTY")]
|
public string? CjQty { get; set; }
|
|
/// <summary>
|
/// 累计打印数
|
/// </summary>
|
[SugarColumn(ColumnName = "DY_QTY")]
|
public string? DyQty { get; set; }
|
|
/// <summary>
|
/// 累计不良数
|
/// </summary>
|
[SugarColumn(ColumnName = "BL_QTY")]
|
public string? BlQty { get; set; }
|
|
/// <summary>
|
/// 机台面板数
|
/// </summary>
|
[SugarColumn(ColumnName = "JT_QTY")]
|
public decimal? JtQty { get; set; }
|
|
/// <summary>
|
/// 初始值
|
/// </summary>
|
[SugarColumn(ColumnName = "CS_QTY")]
|
public decimal? CsQty { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? StaffName { get; set; }
|
}
|
