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; }
  }