using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace Gs.Entity.Sys;
|
|
/// <summary>
|
/// 工序信息表 (SQLServer 版本)
|
/// </summary>
|
[SugarTable("MES_PROC_INFO")]
|
public class MesProcInfo
|
{
|
/// <summary>
|
/// 主键ID (GUID 类型)
|
/// </summary>
|
[SugarColumn(ColumnName = "GUID", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// 工序号
|
/// </summary>
|
[SugarColumn(ColumnName = "PROC_NO")]
|
public string ProcNo { get; set; }
|
|
/// <summary>
|
/// 工序名称
|
/// </summary>
|
[SugarColumn(ColumnName = "PROC_NAME")]
|
public string ProcName { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "MEMO")]
|
public string Memo { get; set; }
|
|
/// <summary>
|
/// 是否主工序(0否1是，为是则在单板基础信息中自动生成工艺路径)
|
/// </summary>
|
[SugarColumn(ColumnName = "PRIMARY_PROC")]
|
public int PrimaryProc { get; set; }
|
|
/// <summary>
|
/// 如果是双面板,是否两面都要加工(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "TWICE_SIDE")]
|
public int TwiceSide { get; set; }
|
|
/// <summary>
|
/// 默认首检标准数(自动生成单板工艺路径信息使用)
|
/// </summary>
|
[SugarColumn(ColumnName = "FIRST_QC_QTY")]
|
public decimal? FirstQcQty { get; set; }
|
|
/// <summary>
|
/// 默认首检严重缺陷数(自动生成单板工艺路径信息使用)
|
/// </summary>
|
[SugarColumn(ColumnName = "FQQ_AB_QTY")]
|
public decimal? FqqAbQty { get; set; }
|
|
/// <summary>
|
/// 默认首检轻微缺陷数(自动生成单板工艺路径信息使用)
|
/// </summary>
|
[SugarColumn(ColumnName = "FQQ_C_QTY")]
|
public decimal? FqqCQty { get; set; }
|
|
/// <summary>
|
/// 工序顺序号
|
/// </summary>
|
[SugarColumn(ColumnName = "PROC_ORDER")]
|
public int? ProcOrder { get; set; }
|
|
/// <summary>
|
/// MRPII转移属性(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "MRP_ATTR")]
|
public int MrpAttr { get; set; }
|
|
/// <summary>
|
/// 工序转移属性(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "TRANSFER_ATTR")]
|
public int TransferAttr { get; set; }
|
|
/// <summary>
|
/// 首检属性(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "FIRST_CHK_ATTR")]
|
public int FirstChkAttr { get; set; }
|
|
/// <summary>
|
/// 过程属性(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "JOB_ATTR")]
|
public int JobAttr { get; set; }
|
|
/// <summary>
|
/// 质量属性(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "QUA_ATTR")]
|
public int QuaAttr { get; set; }
|
|
/// <summary>
|
/// 过程采集工序号
|
/// </summary>
|
[SugarColumn(ColumnName = "COLLECTION_PROC")]
|
public string CollectionProc { get; set; }
|
|
/// <summary>
|
/// 首检方式(缺陷数、品数)
|
/// </summary>
|
[SugarColumn(ColumnName = "FIRST_CHK_TYPE")]
|
public string FirstChkType { get; set; }
|
|
/// <summary>
|
/// MRPII工序转移顺序号
|
/// </summary>
|
[SugarColumn(ColumnName = "MRP_ORDER")]
|
public string MrpOrder { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATE_BY")]
|
public string CreateBy { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATE_DATE")]
|
public DateTime? CreateDate { 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>
|
/// 是否参与DPMO统计(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "DPMO_ATTR")]
|
public int DpmoAttr { get; set; }
|
|
/// <summary>
|
/// 是否预警(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "PRECAUTION_ATTR")]
|
public int PrecautionAttr { get; set; }
|
|
/// <summary>
|
/// 标准工序号
|
/// </summary>
|
[SugarColumn(ColumnName = "STANDARD_PROC_NO")]
|
public string StandardProcNo { get; set; }
|
|
/// <summary>
|
/// 工段编码
|
/// </summary>
|
[SugarColumn(ColumnName = "WORKSHOP_SECTION_CODE")]
|
public string WorkshopSectionCode { get; set; }
|
|
/// <summary>
|
/// 本机种当前工序直通率预警值（小数代表百分比）黄牌
|
/// </summary>
|
[SugarColumn(ColumnName = "ALARM_PASS_PERCENT")]
|
public decimal? AlarmPassPercent { get; set; }
|
|
/// <summary>
|
/// 本机种当前工序直通率停机预警值（小数代表百分比）红牌
|
/// </summary>
|
[SugarColumn(ColumnName = "STOP_PASS_PERCENT")]
|
public decimal? StopPassPercent { get; set; }
|
|
/// <summary>
|
/// 后继工序是否受此工序的加工数量限制(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "QTY_ATTR")]
|
public int QtyAttr { get; set; }
|
|
/// <summary>
|
/// 双面板在当前工序是否可以随意先加工B面或T面(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "AS_ORDER_FLAG")]
|
public int AsOrderFlag { get; set; }
|
|
/// <summary>
|
/// 报废标示(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "WS_OS_FLAG")]
|
public int WsOsFlag { get; set; }
|
|
/// <summary>
|
/// 报工标示(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "WS_CP_FLAG")]
|
public int WsCpFlag { get; set; }
|
|
/// <summary>
|
/// 记录工序属于哪个QC工段
|
/// </summary>
|
[SugarColumn(ColumnName = "QC_SECTION_NO")]
|
public string QcSectionNo { get; set; }
|
|
/// <summary>
|
/// 排产方式(标准节拍,加工节拍)
|
/// </summary>
|
[SugarColumn(ColumnName = "SCHEME_TYPE")]
|
public string SchemeType { get; set; }
|
|
/// <summary>
|
/// 排产标识(0否1是，排产工序，工段停留时间使用)
|
/// </summary>
|
[SugarColumn(ColumnName = "SCHEME_FLAG")]
|
public int SchemeFlag { get; set; }
|
|
/// <summary>
|
/// 排产是否区分班次(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "SCHEME_CLASS_FLAG")]
|
public int SchemeClassFlag { get; set; }
|
|
/// <summary>
|
/// 对应属性
|
/// </summary>
|
[SugarColumn(ColumnName = "COP_ATTR")]
|
public string CopAttr { get; set; }
|
|
/// <summary>
|
/// 工作中心编码
|
/// </summary>
|
[SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
|
public string WorkshopCenterCode { get; set; }
|
|
/// <summary>
|
/// 虚拟条码采集(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "VIRTUAL_BARCODE_FLAG")]
|
public int VirtualBarcodeFlag { get; set; }
|
|
/// <summary>
|
/// 参数范围1
|
/// </summary>
|
[SugarColumn(ColumnName = "PR_1")]
|
public string Pr1 { get; set; }
|
|
/// <summary>
|
/// 参数范围2
|
/// </summary>
|
[SugarColumn(ColumnName = "PR_2")]
|
public string Pr2 { get; set; }
|
|
/// <summary>
|
/// 参数范围3
|
/// </summary>
|
[SugarColumn(ColumnName = "PR_3")]
|
public string Pr3 { get; set; }
|
|
/// <summary>
|
/// 参数范围4
|
/// </summary>
|
[SugarColumn(ColumnName = "PR_4")]
|
public string Pr4 { get; set; }
|
|
/// <summary>
|
/// 正负极
|
/// </summary>
|
[SugarColumn(ColumnName = "FPM_MARK")]
|
public string FpmMark { get; set; }
|
|
/// <summary>
|
/// 是否允许重复投料(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "SFCFTL")]
|
public int Sfcftl { get; set; }
|
|
/// <summary>
|
/// 是否按照工单投料(0否1是)
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_TASK_FALAG")]
|
public int IsTaskFalag { get; set; }
|
|
/// <summary>
|
/// 工厂
|
/// </summary>
|
[SugarColumn(ColumnName = "FACTORY")]
|
public string Factory { get; set; }
|
|
/// <summary>
|
/// 公司
|
/// </summary>
|
[SugarColumn(ColumnName = "COMPANY")]
|
public string Company { get; set; }
|
|
/// <summary>
|
/// 计件方式
|
/// </summary>
|
[SugarColumn(ColumnName = "SALARY_TYPE")]
|
public string SalaryType { get; set; }
|
}
|
