增加生产不良记录实体

Rodney Chen

2024-07-24 5d38a48ce0778208a5455cd046c45f2233c507a1

增加生产不良记录实体

 Tiger.Model.Net/Entitys/MES/MES_WIP_DATA.cs

@@ -239,13 +239,13 @@
        [Navigate(NavigateType.OneToMany, nameof(MES_WIP_HIS.SN), nameof(SN), "GHOST_ROW = 0")]//ClassA表中的MES_WIP_DATAId
        public List<MES_WIP_HIS> _History { get; set; }//注意禁止手动赋值，只能是null
        public List<MES_WIP_HIS> History => _History ?? new List<MES_WIP_HIS>();
        //[Navigate(NavigateType.OneToMany, nameof(MES_WIP_DFT.SN), nameof(SN), "GHOST_ROW = 0")]//ClassA表中的MES_WIP_DATAId
        //public List<MES_WIP_DFT> _Defects { get; set; }//注意禁止手动赋值，只能是null
        //public List<MES_WIP_DFT> Defects => _Defects ?? new List<MES_WIP_DFT>();
        #endregion
        [Navigate(NavigateType.OneToMany, nameof(MES_WIP_DFT.SN), nameof(SN), "GHOST_ROW = 0")]//ClassA表中的MES_WIP_DATAId
        public List<MES_WIP_DFT> _Defects { get; set; }//注意禁止手动赋值，只能是null
        public List<MES_WIP_DFT> Defects => _Defects ?? new List<MES_WIP_DFT>();
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
@@ -255,10 +255,10 @@
        }
        */

        /// <summary>
        /// æžšä¸¾ï¼šçŠ¶æ€(0Init初始化|1Input已投入|2OK良品过站|3NG不良过站|4Repair维修中|5Finished已完工|6Scrap已报废|7InStorage已入库|8Reject已拒收|9Shipped已出货)
        /// </summary>
        public enum STATUSs
        /// <summary>
        /// æžšä¸¾ï¼šçŠ¶æ€(0Init初始化|1Input已投入|2OK良品过站|3NG不良过站|4Repair维修中|5Finished已完工|6Scrap已报废|7InStorage已入库|8Reject已拒收|9Shipped已出货)
        /// </summary>
        public enum STATUSs
        {
            [Description("初始化")]
            Init = 0,

 Tiger.Model.Net/Entitys/MES/MES_WIP_DFT.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,297 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：生产不良记录
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("生产不良记录")]
    [Serializable]
    [SugarTable("MES_WIP_DFT")]
    public class MES_WIP_DFT : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：生产不良记录
        /// </summary>
        public MES_WIP_DFT() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// è¿‡ç«™æ¡ç 
        /// </summary>
        [DisplayName("过站条码")]
        public string SN { get; set; }
        /// <summary>
        /// çŠ¶æ€(0WaitHandle待处理|1Repairing维修中|2Resolved已处理)
        /// </summary>
        [DisplayName("状态(0WaitHandle待处理|1Repairing维修中|2Resolved已处理)")]
        public int STATUS { get; set; }
        /// <summary>
        /// ç‰©æ–™ç¼–码
        /// </summary>
        [DisplayName("物料编码")]
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// å·¥å•å·
        /// </summary>
        [DisplayName("工单号")]
        public string WORK_ORDER { get; set; }
        /// <summary>
        /// å·¥å•æ‰¹æ¬¡å·
        /// </summary>
        [DisplayName("工单批次号")]
        public string BATCH_NO { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿ç¼–码
        /// </summary>
        [DisplayName("工艺路线编码")]
        public string ROT_CODE { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿èŠ‚点ID
        /// </summary>
        [DisplayName("工艺路线节点ID")]
        public string NODE_ID { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿èŠ‚点名称
        /// </summary>
        [DisplayName("工艺路线节点名称")]
        public string NODE_NAME { get; set; }
        /// <summary>
        /// å·¥åŽ‚编码
        /// </summary>
        [DisplayName("工厂编码")]
        public string FTY_CODE { get; set; }
        /// <summary>
        /// è½¦é—´ç¼–码
        /// </summary>
        [DisplayName("车间编码")]
        public string WS_CODE { get; set; }
        /// <summary>
        /// äº§çº¿ç¼–码
        /// </summary>
        [DisplayName("产线编码")]
        public string LINE_CODE { get; set; }
        /// <summary>
        /// å²—位编码
        /// </summary>
        [DisplayName("岗位编码")]
        public string POST_CODE { get; set; }
        /// <summary>
        /// å·¥åºç¼–码
        /// </summary>
        [DisplayName("工序编码")]
        public string OPER_CODE { get; set; }
        /// <summary>
        /// åŠ å·¥æ®µ
        /// </summary>
        [DisplayName("加工段")]
        public string SEGMENT { get; set; }
        /// <summary>
        /// æ˜¯å¦ä¸è‰¯
        /// </summary>
        [DisplayName("是否不良")]
        public string DFT_FLAG { get; set; }
        /// <summary>
        /// ä¸è‰¯è®¡æ•°
        /// </summary>
        [DisplayName("不良计数")]
        public int DFT_COUNT { get; set; }
        /// <summary>
        /// ä¸è‰¯ä»£ç ç¼–码
        /// </summary>
        [DisplayName("不良代码编码")]
        public string DFT_CODE { get; set; }
        /// <summary>
        /// ä¸è‰¯ä»£ç åç§°
        /// </summary>
        [DisplayName("不良代码名称")]
        public string DFT_NAME { get; set; }
        /// <summary>
        /// ç¼ºé™·ç­‰çº§(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷)
        /// </summary>
        [DisplayName("缺陷等级(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷)")]
        public int DFT_LEVEL { get; set; }
        /// <summary>
        /// æ‰˜ç›˜/载具条码
        /// </summary>
        [DisplayName("托盘/载具条码")]
        public string TRAY_SN { get; set; }
        /// <summary>
        /// å®¹å™¨/内包装条码
        /// </summary>
        [DisplayName("容器/内包装条码")]
        public string CONTAINER_SN { get; set; }
        /// <summary>
        /// å¤–箱条码
        /// </summary>
        [DisplayName("外箱条码")]
        public string CARTON_SN { get; set; }
        /// <summary>
        /// æ ˆæ¿æ¡ç 
        /// </summary>
        [DisplayName("栈板条码")]
        public string PALLET_SN { get; set; }
        /// <summary>
        /// æ˜¯å¦å…¥åº“
        /// </summary>
        [DisplayName("是否入库")]
        public string INV_FLAG { get; set; }
        /// <summary>
        /// å½“前操作时间
        /// </summary>
        [DisplayName("当前操作时间")]
        public DateTime OPERATION_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// ç­åˆ¶ç¼–码
        /// </summary>
        [DisplayName("班制编码")]
        public string SFTS_CODE { get; set; }
        /// <summary>
        /// ç­æ¬¡ç¼–码
        /// </summary>
        [DisplayName("班次编码")]
        public string SFT_CODE { get; set; }
        /// <summary>
        /// æ—¶æ®µç¼–码
        /// </summary>
        [DisplayName("时段编码")]
        public string PRD_CODE { get; set; }
        /// <summary>
        /// æŠ½æ£€æ‰¹æ¬¡å·
        /// </summary>
        [DisplayName("抽检批次号")]
        public string OBA_BATCH { get; set; }
        /// <summary>
        /// é”å®šæ‰¹æ¬¡å·
        /// </summary>
        [DisplayName("锁定批次号")]
        public string LOCK_BATCH { get; set; }
        /// <summary>
        /// ä¸è‰¯åŽŸå› ç¼–码
        /// </summary>
        [DisplayName("不良原因编码")]
        public string RSN_CODE { get; set; }
        /// <summary>
        /// ä¸è‰¯åŽŸå› åç§°
        /// </summary>
        [DisplayName("不良原因名称")]
        public string RSN_NAME { get; set; }
        /// <summary>
        /// æ˜¯å¦å¿…须更换零件(Y/N)
        /// </summary>
        [DisplayName("是否必须更换零件(Y/N)")]
        public string NEED_REPLACE { get; set; }
        /// <summary>
        /// ä¸è‰¯è´£ä»»ç¼–码
        /// </summary>
        [DisplayName("不良责任编码")]
        public string DUTY_CODE { get; set; }
        /// <summary>
        /// ä¸è‰¯è´£ä»»åç§°
        /// </summary>
        [DisplayName("不良责任名称")]
        public string DUTY_NAME { get; set; }
        /// <summary>
        /// ç¼ºé™·ä½ç½®ç¼–码
        /// </summary>
        [DisplayName("缺陷位置编码")]
        public string LOC_CODE { get; set; }
        /// <summary>
        /// ç¼ºé™·ä½ç½®åç§°
        /// </summary>
        [DisplayName("缺陷位置名称")]
        public string LOC_NAME { get; set; }
        /// <summary>
        /// ä¸è‰¯è§£å†³æ–¹æ¡ˆç¼–码
        /// </summary>
        [DisplayName("不良解决方案编码")]
        public string SOL_CODE { get; set; }
        /// <summary>
        /// ä¸è‰¯è§£å†³æ–¹æ¡ˆåç§°
        /// </summary>
        [DisplayName("不良解决方案名称")]
        public string SOL_NAME { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        [DisplayName("备注")]
        public string REMARK { get; set; }
        /// <summary>
        /// è¿½æº¯ä¿¡æ¯
        /// </summary>
        [DisplayName("追溯信息")]
        public string TRACE_INFO { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion

        #region å¤–键属性
        /*例子
        //一对一外键导航
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_WIP_DFT类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_WIP_DFTId))]//ClassA表中的MES_WIP_DFTId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.MES_WIP_DFTId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */

        /// <summary>
        /// æžšä¸¾ï¼šçŠ¶æ€(0WaitHandle待处理|1Repairing维修中|2Resolved已处理)
        /// </summary>
        public enum STATUSs
        {
            [Description("待处理")]
            WaitHandle = 0,
            [Description("维修中")]
            Repairing = 1,
            [Description("已处理")]
            Resolved = 2,
        }

        /// <summary>
        /// æžšä¸¾ï¼šç¼ºé™·ç­‰çº§(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷)
        /// </summary>
        public enum DFT_LEVELs
        {
            [Description("轻微缺陷")]
            MI = 0,
            [Description("严重缺陷")]
            MA = 1,
            [Description("致命缺陷")]
            CR = 2,
        }
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}

 Tiger.Model.Net/Tiger.Model.Net.csproj

@@ -12,10 +12,14 @@
    <TargetFrameworkVersion>v4.8</TargetFrameworkVersion>
    <FileAlignment>512</FileAlignment>
    <Deterministic>true</Deterministic>
    <SccProjectName></SccProjectName>
    <SccLocalPath></SccLocalPath>
    <SccAuxPath></SccAuxPath>
    <SccProvider></SccProvider>
    <SccProjectName>
    </SccProjectName>
    <SccLocalPath>
    </SccLocalPath>
    <SccAuxPath>
    </SccAuxPath>
    <SccProvider>
    </SccProvider>
    <TargetFrameworkProfile />
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
@@ -134,6 +138,7 @@
    <Compile Include="Entitys\MES\MES_SHIFT_SYS.cs" />
    <Compile Include="Entitys\MES\MES_WIP_ACT.cs" />
    <Compile Include="Entitys\MES\MES_WIP_DATA.cs" />
    <Compile Include="Entitys\MES\MES_WIP_DFT.cs" />
    <Compile Include="Entitys\MES\MES_WIP_EXT.cs" />
    <Compile Include="Entitys\MES\MES_WIP_HIS.cs" />
    <Compile Include="Entitys\MES\MES_WO_ACTION.cs" />