增加MES实体

Rodney Chen

2024-05-08 570c0450147ecaabc90035fd3ff4b123171bfc04

增加MES实体

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

@@ -0,0 +1,213 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：工单
    /// </summary>
    [Description("Primary:ID")]
    [Serializable]
    [SugarTable("BIZ_MES_WO")]
    public class BIZ_MES_WO : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：工单
        /// </summary>
        public BIZ_MES_WO() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// å·¥å•å·
        /// </summary>
        public string ORDER_NO { get; set; }
        /// <summary>
        /// å·¥å•ç±»åž‹(0Normal正常|1Rework返工)
        /// </summary>
        public string ORDER_TYPE { get; set; }
        /// <summary>
        /// å·¥å•æè¿°
        /// </summary>
        public string ORDER_DESC { get; set; }
        /// <summary>
        /// çˆ¶å·¥å•
        /// </summary>
        public string PARENT_ORDER { get; set; }
        /// <summary>
        /// çŠ¶æ€(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)
        /// </summary>
        public int STATUS { get; set; }
        /// <summary>
        /// ç‰©æ–™ç¼–码
        /// </summary>
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// ç‰©æ–™ç±»åž‹
        /// </summary>
        public string ITEM_TYPE { get; set; }
        /// <summary>
        /// æœºåž‹
        /// </summary>
        public string ITEM_MODEL { get; set; }
        /// <summary>
        /// ä¼˜å…ˆçº§
        /// </summary>
        public string PRIORITY { get; set; }
        /// <summary>
        /// å®¢æˆ·ç¼–码
        /// </summary>
        public string CUST_CODE { get; set; }
        /// <summary>
        /// è·¯ç”±ç¼–码
        /// </summary>
        public string ROUTE_CODE { get; set; }
        /// <summary>
        /// å·¥è‰ºçŠ¶æ€(0WaitSet待配置|1Finish已配置|2Cancel取消|3Close关闭)
        /// </summary>
        public int ROUTE_STATUS { get; set; }
        /// <summary>
        /// å·¥åŽ‚
        /// </summary>
        public string FACTORY { get; set; }
        /// <summary>
        /// è®¡åˆ’线体
        /// </summary>
        public string PLAN_LINE { get; set; }
        /// <summary>
        /// å®žé™…线体
        /// </summary>
        public string ACT_LINE { get; set; }
        /// <summary>
        /// è®¡åˆ’开始时间
        /// </summary>
        public DateTime PLAN_START_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// è®¡åˆ’结束时间
        /// </summary>
        public DateTime PLAN_END_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// å®žé™…开始时间
        /// </summary>
        public DateTime ACT_START_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// å®žé™…结束时间
        /// </summary>
        public DateTime ACT_END_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// æ ‡å‡†ä½œä¸šäººæ•°
        /// </summary>
        public int STD_WORKERS_QTY { get; set; }
        /// <summary>
        /// å®žé™…作业人数
        /// </summary>
        public int ACT_WORKER_QTY { get; set; }
        /// <summary>
        /// å¯¼å…¥æ—¶é—´
        /// </summary>
        public DateTime IMPORT_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// ä¸‹å‘时间
        /// </summary>
        public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// ä¸‹å‘人
        /// </summary>
        public string RELEASE_USER { get; set; }
        /// <summary>
        /// å˜æ›´æ—¶é—´
        /// </summary>
        public DateTime CHANGE_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// å˜æ›´äºº
        /// </summary>
        public string CHANGE_USER { get; set; }
        /// <summary>
        /// è®¡åˆ’数量
        /// </summary>
        public int PLAN_QTY { get; set; }
        /// <summary>
        /// æŠ•å…¥æ•°é‡
        /// </summary>
        public int INPUT_QTY { get; set; }
        /// <summary>
        /// å®Œå·¥æ•°é‡
        /// </summary>
        public int OUTPUT_QTY { get; set; }
        /// <summary>
        /// æŠ¥åºŸæ•°é‡
        /// </summary>
        public int SCRAP_QTY { get; set; }
        /// <summary>
        /// å…¥åº“数量
        /// </summary>
        public int STOCK_IN_QTY { get; set; }
        /// <summary>
        /// UPH
        /// </summary>
        public double UPH { get; set; }
        /// <summary>
        /// UPPH
        /// </summary>
        public double UPPH { get; set; }
        /// <summary>
        /// æœ€åŽçš„工单历史ID
        /// </summary>
        public string LAST_HIST_ID { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        public string REMARK { get; set; }
        /// <summary>
        /// æŽ¥å£è¡¨è®°å½•ID
        /// </summary>
        public string FBILLNO_ID { get; set; }
        /// <summary>
        /// å¤‡æ–™å•è¿”回信息
        /// </summary>
        public string PREP_MSG { get; set; }
        #endregion

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

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

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

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

        #endregion

    }//endClass
}

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

@@ -7,89 +7,93 @@
namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：产线
    /// å®žä½“：产线
    /// </summary>
    [Description("Primary:ID")]
    [Serializable]
    [SugarTable("MES_LINE")]
    public class MES_LINE : DbEntityWithAuth
    {
        #region æž„造函数
        #region æž„造函数
        /// <summary>
        /// å®žä½“：产线
        /// å®žä½“：产线
        /// </summary>
        public MES_LINE() {}
        #endregion

        #region å…¬å…±å±žæ€§
        #region å…¬å…±å±žæ€§
        /// <summary>
        /// äº§çº¿ç¼–码
        /// äº§çº¿ç¼–码
        /// </summary>
        public string LINE_CODE { get; set; }
        /// <summary>
        /// äº§çº¿åç§°
        /// äº§çº¿åç§°
        /// </summary>
        public string LINE_NAME { get; set; }
        /// <summary>
        /// äº§çº¿ç®€ç§°
        /// äº§çº¿ç®€ç§°
        /// </summary>
        public string SHORT_NAME { get; set; }
        /// <summary>
        /// äº§çº¿ç±»åž‹
        /// äº§çº¿ç±»åž‹
        /// </summary>
        public string LINE_TYPE { get; set; }
        /// <summary>
        /// è½¦é—´ç¼–码
        /// è½¦é—´ç¼–码
        /// </summary>
        public string WS_CODE { get; set; }
        /// <summary>
        /// ç»„织编码
        /// ç»„织编码
        /// </summary>
        public string ORG_CODE { get; set; }
        /// <summary>
        /// ç­åˆ¶ç¼–码
        /// </summary>
        public string SFTS_CODE { get; set; }
        /// <summary>
        /// æ˜¯å¦å¯ç”¨(Y/N)
        /// </summary>
        public string IS_ACTIVE { get; set; }
        /// <summary>
        /// æ˜¯å¦å¯ç”¨(Y/N)
        /// </summary>
        public string IS_ACTIVE { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// å¤‡æ³¨
        /// </summary>
        public string REMARK { get; set; }
        #endregion

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

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

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

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

        #endregion


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

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

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：产品工序行为
    /// </summary>
    [Description("Primary:ID")]
    [Serializable]
    [SugarTable("MES_PROD_NODE_ACT")]
    public class MES_PROD_NODE_ACT : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：产品工序行为
        /// </summary>
        public MES_PROD_NODE_ACT() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// äº§å“ç¼–码
        /// </summary>
        public string PROD_CODE { get; set; }
        /// <summary>
        /// å·¥åºè¡Œä¸ºID
        /// </summary>
        public string ACT_ID { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿ID
        /// </summary>
        public string ROT_ID { get; set; }
        /// <summary>
        /// å·¥åºèŠ‚点ID
        /// </summary>
        public string NODE_ID { get; set; }
        /// <summary>
        /// è¡Œä¸ºç±»åž‹(0Normal默认行为|1Scan扫码验证|2Assy组装上料|3Test产品测试|4Audit产品抽检|5Print标签打印)
        /// </summary>
        public int ACT_TYPE { get; set; }
        /// <summary>
        /// æ‰«ç éªŒè¯ï¼šæ¡ç è§„则
        /// </summary>
        public string RULE_CODE { get; set; }
        /// <summary>
        /// ç»„装上料：物料料号
        /// </summary>
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// äº§å“æµ‹è¯•ï¼šæ£€éªŒé¡¹ç›®ç¼–码
        /// </summary>
        public string TEST_CODE { get; set; }
        /// <summary>
        /// äº§å“æŠ½æ£€ï¼šæŠ½æ ·è§„则编码
        /// </summary>
        public string SAPL_CODE { get; set; }
        /// <summary>
        /// æ ‡ç­¾æ‰“印：标签模板编码
        /// </summary>
        public string LABEL_CODE { get; set; }
        /// <summary>
        /// è®¾ç½®å€¼1
        /// </summary>
        public string OPTION_1 { get; set; }
        /// <summary>
        /// è®¾ç½®å€¼2
        /// </summary>
        public string OPTION_2 { get; set; }
        /// <summary>
        /// è®¾ç½®å€¼3
        /// </summary>
        public string OPTION_3 { get; set; }
        /// <summary>
        /// è®¾ç½®å€¼4
        /// </summary>
        public string OPTION_4 { get; set; }
        /// <summary>
        /// è®¾ç½®å€¼5
        /// </summary>
        public string OPTION_5 { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        public string REMARK { get; set; }
        #endregion

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

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

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

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

        #endregion

    }//endClass
}

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

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

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：工序节点与岗位关系
    /// </summary>
    [Description("Primary:NODE_ID,POST_CODE")]
    [Serializable]
    [SugarTable("MES_ROUTE_NODE_POST")]
    public class MES_ROUTE_NODE_POST : iDBEntity
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：工序节点与岗位关系
        /// </summary>
        public MES_ROUTE_NODE_POST() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// ä¸»é”® å·¥åºèŠ‚点ID
        /// </summary>
        [SugarColumn(IsPrimaryKey = true)]
        public string NODE_ID { get; set; }
        /// <summary>
        /// ä¸»é”® å²—位编码
        /// </summary>
        public string POST_CODE { get; set; }
        #endregion

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

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

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

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

        #endregion

    }//endClass
}

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

ÎļþÒÑɾ³ý

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

@@ -12,7 +12,7 @@
    [Description("Primary:ID")]
    [Serializable]
    [SugarTable("MES_SHIFT_PRD")]
    public class MES_SHIFT_PRD : DbEntity
    public class MES_SHIFT_PRD : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
@@ -23,7 +23,7 @@

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// æ—¶æ®µä»£ç 
        /// æ—¶æ®µç¼–码
        /// </summary>
        public string PRD_CODE { get; set; }
        /// <summary>
@@ -31,17 +31,17 @@
        /// </summary>
        public string PRD_NAME { get; set; }
        /// <summary>
        /// ç­æ¬¡ä»£ç 
        /// ç­æ¬¡ç¼–码
        /// </summary>
        public string SFT_CODE { get; set; }
        /// <summary>
        /// æ—¶æ®µå¼€å§‹æ—¶é—´
        /// </summary>
        public int SFT_BEGIN { get; set; }
        public int PRD_BEGIN { get; set; }
        /// <summary>
        /// æ—¶æ®µç»“束时间
        /// </summary>
        public int SFT_END { get; set; }
        public int PRD_END { get; set; }
        /// <summary>
        /// æ—¶æ®µæŽ’序
        /// </summary>
@@ -49,7 +49,11 @@
        /// <summary>
        /// æ˜¯å¦è·¨å¤©(Y/N)
        /// </summary>
        public string IS_ACROSS_DAY { get; set; }
        public string IS_ACROSS { get; set; }
        /// <summary>
        /// æ˜¯å¦ä¼‘息时段(Y/N)
        /// </summary>
        public string IS_REST { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
@@ -63,6 +67,20 @@
        */
        #endregion

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

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames

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

ÎļþÒÑɾ³ý

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

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

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

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// ç”Ÿäº§è¿‡ç¨‹è®°å½•ID
        /// </summary>
        public string HIS_ID { get; set; }
        /// <summary>
        /// è¿‡ç«™æ¡ç 
        /// </summary>
        public string SN { get; set; }
        /// <summary>
        /// çŠ¶æ€(0Init初始化|1Input已投入|2OK良品过站|3NG不良过站|4Repair维修中|5Finished已完工|6Scrap已报废|7InStorage已入库|8Reject已拒收|9Shipped已出货)
        /// </summary>
        public int STATUS { get; set; }
        /// <summary>
        /// ç‰©æ–™ç¼–码
        /// </summary>
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// å·¥å•å·
        /// </summary>
        public string WORK_ORDER { get; set; }
        /// <summary>
        /// åŠ å·¥æ®µ
        /// </summary>
        public string SEGMENT { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿ID
        /// </summary>
        public string ROT_ID { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿èŠ‚点ID
        /// </summary>
        public string NODE_ID { get; set; }
        /// <summary>
        /// å·¥åºè¡Œä¸ºID
        /// </summary>
        public string ACT_ID { get; set; }
        /// <summary>
        /// å·¥åŽ‚编码
        /// </summary>
        public string FTY_CODE { get; set; }
        /// <summary>
        /// è½¦é—´ç¼–码
        /// </summary>
        public string WS_CODE { get; set; }
        /// <summary>
        /// äº§çº¿ç¼–码
        /// </summary>
        public string LINE_CODE { get; set; }
        /// <summary>
        /// å²—位编码
        /// </summary>
        public string POST_CODE { get; set; }
        /// <summary>
        /// å·¥åºç¼–码
        /// </summary>
        public string OPER_CODE { get; set; }
        /// <summary>
        /// æ‰˜ç›˜/载具条码
        /// </summary>
        public string TRAY_SN { get; set; }
        /// <summary>
        /// å½“前操作时间
        /// </summary>
        public DateTime OPERATION_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// ç­åˆ¶ç¼–码
        /// </summary>
        public string SFTS_CODE { get; set; }
        /// <summary>
        /// ç­æ¬¡ç¼–码
        /// </summary>
        public string SFT_CODE { get; set; }
        /// <summary>
        /// æ—¶æ®µç¼–码
        /// </summary>
        public string PRD_CODE { get; set; }
        /// <summary>
        /// è¡Œä¸ºç±»åž‹(0Normal默认行为|1Scan扫码验证|2Assy组装上料|3Test产品测试|4Audit产品抽检|5Print标签打印)
        /// </summary>
        public int ACT_TYPE { get; set; }
        /// <summary>
        /// è¡Œä¸ºæ‰«ç 
        /// </summary>
        public string ACT_SN { get; set; }
        /// <summary>
        /// è¡Œä¸ºæ“ä½œå€¼1
        /// </summary>
        public string ACT_VALUE_1 { get; set; }
        /// <summary>
        /// è¡Œä¸ºæ“ä½œå€¼2
        /// </summary>
        public string ACT_VALUE_2 { get; set; }
        /// <summary>
        /// è¡Œä¸ºæ“ä½œå€¼3
        /// </summary>
        public string ACT_VALUE_3 { get; set; }
        /// <summary>
        /// è¡Œä¸ºæ“ä½œå€¼4
        /// </summary>
        public string ACT_VALUE_4 { get; set; }
        /// <summary>
        /// è¡Œä¸ºæ“ä½œå€¼5
        /// </summary>
        public string ACT_VALUE_5 { get; set; }
        /// <summary>
        /// è¡Œä¸ºæ˜¯å¦æˆåŠŸ(Y/N)
        /// </summary>
        public string ACT_RESULT { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        public string REMARK { get; set; }
        /// <summary>
        /// è¿½æº¯ä¿¡æ¯
        /// </summary>
        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_ACT类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_WIP_ACTId))]//ClassA表中的MES_WIP_ACTId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.MES_WIP_ACTId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

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

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

        #endregion

    }//endClass
}

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

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

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：在制品信息表
    /// </summary>
    [Description("Primary:ID")]
    [Serializable]
    [SugarTable("MES_WIP_DATA")]
    public class MES_WIP_DATA : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：在制品信息表
        /// </summary>
        public MES_WIP_DATA() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// è¿‡ç«™æ¡ç 
        /// </summary>
        public string SN { get; set; }
        /// <summary>
        /// çŠ¶æ€(0Init初始化|1Input已投入|2OK良品过站|3NG不良过站|4Repair维修中|5Finished已完工|6Scrap已报废|7InStorage已入库|8Reject已拒收|9Shipped已出货)
        /// </summary>
        public int STATUS { get; set; }
        /// <summary>
        /// ç‰©æ–™ç¼–码
        /// </summary>
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// å·¥å•å·
        /// </summary>
        public string WORK_ORDER { get; set; }
        /// <summary>
        /// åŠ å·¥æ®µ
        /// </summary>
        public string SEGMENT { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿ID
        /// </summary>
        public string ROT_ID { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿èŠ‚点ID
        /// </summary>
        public string NODE_ID { get; set; }
        /// <summary>
        /// å·¥åºç¼–码
        /// </summary>
        public string OPER_CODE { get; set; }
        /// <summary>
        /// å·¥åŽ‚编码
        /// </summary>
        public string FTY_CODE { get; set; }
        /// <summary>
        /// è½¦é—´ç¼–码
        /// </summary>
        public string WS_CODE { get; set; }
        /// <summary>
        /// äº§çº¿ç¼–码
        /// </summary>
        public string LINE_CODE { get; set; }
        /// <summary>
        /// å²—位编码
        /// </summary>
        public string POST_CODE { get; set; }
        /// <summary>
        /// é”å®šæ ‡è®°
        /// </summary>
        public string HOLD_FLAG { get; set; }
        /// <summary>
        /// è¿”工标记
        /// </summary>
        public string REWORK_FLAG { get; set; }
        /// <summary>
        /// æ˜¯å¦å®Œå·¥
        /// </summary>
        public string FINISHED_FLAG { get; set; }
        /// <summary>
        /// æ‰˜ç›˜/载具条码
        /// </summary>
        public string TRAY_SN { get; set; }
        /// <summary>
        /// å®¹å™¨/内包装条码
        /// </summary>
        public string CONTAINER_SN { get; set; }
        /// <summary>
        /// å¤–箱条码
        /// </summary>
        public string CARTON_SN { get; set; }
        /// <summary>
        /// æ ˆæ¿æ¡ç 
        /// </summary>
        public string PALLET_SN { get; set; }
        /// <summary>
        /// æ˜¯å¦å…¥åº“
        /// </summary>
        public string INV_FLAG { get; set; }
        /// <summary>
        /// å…¥åº“日期
        /// </summary>
        public DateTime INV_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// æŠ•å…¥æ—¶é—´
        /// </summary>
        public DateTime INLINE_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// äº§å‡ºæ—¶é—´
        /// </summary>
        public DateTime OUTLINE_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// å½“前操作时间
        /// </summary>
        public DateTime OPERATION_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// ç­åˆ¶ç¼–码
        /// </summary>
        public string SFTS_CODE { get; set; }
        /// <summary>
        /// ç­æ¬¡ç¼–码
        /// </summary>
        public string SFT_CODE { get; set; }
        /// <summary>
        /// æ—¶æ®µç¼–码
        /// </summary>
        public string PRD_CODE { get; set; }
        /// <summary>
        /// æŠ½æ£€çŠ¶æ€(0Unsampled未抽检|1NoSampling不抽检|2WaitCheck待检验|3Checking检验中|4Completed检验完|5Locked已锁定)
        /// </summary>
        public int OBA_STATUS { get; set; }
        /// <summary>
        /// æŠ½æ£€æ‰¹æ¬¡å·
        /// </summary>
        public string OBA_BATCH { get; set; }
        /// <summary>
        /// é”å®šæ‰¹æ¬¡å·
        /// </summary>
        public string LOCK_BATCH { get; set; }
        /// <summary>
        /// å‡ºè´§æ—¶é—´
        /// </summary>
        public DateTime SHIPPING_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// å‡ºè´§å•å·
        /// </summary>
        public string SHIPPING_ORDER { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        public string REMARK { get; set; }
        #endregion

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

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

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

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

        #endregion

    }//endClass
}

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

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

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

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// è¿‡ç«™æ¡ç 
        /// </summary>
        public string SN { get; set; }
        /// <summary>
        /// çŠ¶æ€(0Init初始化|1Input已投入|2OK良品过站|3NG不良过站|4Repair维修中|5Finished已完工|6Scrap已报废|7InStorage已入库|8Reject已拒收|9Shipped已出货)
        /// </summary>
        public int STATUS { get; set; }
        /// <summary>
        /// ç‰©æ–™ç¼–码
        /// </summary>
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// å·¥å•å·
        /// </summary>
        public string WORK_ORDER { get; set; }
        /// <summary>
        /// åŠ å·¥æ®µ
        /// </summary>
        public string SEGMENT { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿ID
        /// </summary>
        public string ROT_ID { get; set; }
        /// <summary>
        /// å·¥è‰ºè·¯çº¿èŠ‚点ID
        /// </summary>
        public string NODE_ID { get; set; }
        /// <summary>
        /// å·¥åŽ‚编码
        /// </summary>
        public string FTY_CODE { get; set; }
        /// <summary>
        /// è½¦é—´ç¼–码
        /// </summary>
        public string WS_CODE { get; set; }
        /// <summary>
        /// äº§çº¿ç¼–码
        /// </summary>
        public string LINE_CODE { get; set; }
        /// <summary>
        /// å²—位编码
        /// </summary>
        public string POST_CODE { get; set; }
        /// <summary>
        /// å·¥åºç¼–码
        /// </summary>
        public string OPER_CODE { get; set; }
        /// <summary>
        /// é”å®šæ ‡è®°
        /// </summary>
        public string HOLD_FLAG { get; set; }
        /// <summary>
        /// è¿”工标记
        /// </summary>
        public string REWORK_FLAG { get; set; }
        /// <summary>
        /// æ˜¯å¦å®Œå·¥
        /// </summary>
        public string FINISHED_FLAG { get; set; }
        /// <summary>
        /// æ‰˜ç›˜/载具条码
        /// </summary>
        public string TRAY_SN { get; set; }
        /// <summary>
        /// å®¹å™¨/内包装条码
        /// </summary>
        public string CONTAINER_SN { get; set; }
        /// <summary>
        /// å¤–箱条码
        /// </summary>
        public string CARTON_SN { get; set; }
        /// <summary>
        /// æ ˆæ¿æ¡ç 
        /// </summary>
        public string PALLET_SN { get; set; }
        /// <summary>
        /// æ˜¯å¦å…¥åº“
        /// </summary>
        public string INV_FLAG { get; set; }
        /// <summary>
        /// å…¥åº“日期
        /// </summary>
        public DateTime INV_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// æŠ•å…¥æ—¶é—´
        /// </summary>
        public DateTime INLINE_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// äº§å‡ºæ—¶é—´
        /// </summary>
        public DateTime OUTLINE_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// å½“前操作时间
        /// </summary>
        public DateTime OPERATION_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// ç­åˆ¶ç¼–码
        /// </summary>
        public string SFTS_CODE { get; set; }
        /// <summary>
        /// ç­æ¬¡ç¼–码
        /// </summary>
        public string SFT_CODE { get; set; }
        /// <summary>
        /// æ—¶æ®µç¼–码
        /// </summary>
        public string PRD_CODE { get; set; }
        /// <summary>
        /// æŠ½æ£€çŠ¶æ€(0Unsampled未抽检|1NoSampling不抽检|2WaitCheck待检验|3Checking检验中|4Completed检验完|5Locked已锁定)
        /// </summary>
        public int OBA_STATUS { get; set; }
        /// <summary>
        /// æŠ½æ£€æ‰¹æ¬¡å·
        /// </summary>
        public string OBA_BATCH { get; set; }
        /// <summary>
        /// é”å®šæ‰¹æ¬¡å·
        /// </summary>
        public string LOCK_BATCH { get; set; }
        /// <summary>
        /// å‡ºè´§æ—¶é—´
        /// </summary>
        public DateTime SHIPPING_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// å‡ºè´§å•å·
        /// </summary>
        public string SHIPPING_ORDER { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        public string REMARK { get; set; }
        /// <summary>
        /// è¿½æº¯ä¿¡æ¯
        /// </summary>
        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_HIS类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_WIP_HISId))]//ClassA表中的MES_WIP_HISId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.MES_WIP_HISId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

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

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

        #endregion

    }//endClass
}

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

@@ -91,8 +91,15 @@
    <Compile Include="Entitys\MES\C_Stock_Info_t.cs" />
    <Compile Include="Entitys\MES\C_Stock_Pallet_T.cs" />
    <Compile Include="Entitys\MES\edge.cs" />
    <Compile Include="Entitys\MES\MES_PROD_NODE_ACT.cs" />
    <Compile Include="Entitys\MES\MES_ROUTE_NODE_ACT.cs" />
    <Compile Include="Entitys\MES\MES_SHIFT_PERIOD.cs" />
    <Compile Include="Entitys\MES\MES_ROUTE_NODE_POST.cs" />
    <Compile Include="Entitys\MES\MES_SHIFT.cs" />
    <Compile Include="Entitys\MES\MES_SHIFT_PRD.cs" />
    <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_HIS.cs" />
    <Compile Include="Entitys\MES\node.cs" />
    <Compile Include="Entitys\MES\R_Wip_Tracking_T.cs" />
    <Compile Include="Entitys\MES\SMT_FEEDER.cs" />
@@ -229,10 +236,6 @@
    <Compile Include="Entitys\MES\MES_ROUTE.cs" />
    <Compile Include="Entitys\MES\MES_ROUTE_EDGE.cs" />
    <Compile Include="Entitys\MES\MES_ROUTE_NODE.cs" />
    <Compile Include="Entitys\MES\MES_SHIFT.cs" />
    <Compile Include="Entitys\MES\MES_SHIFT_PRD.cs" />
    <Compile Include="Entitys\MES\MES_SHIFT_SYS.cs" />
    <Compile Include="Entitys\MES\MES_SMT_TABLE.cs" />
    <Compile Include="Entitys\MES\MES_WORKSHOP.cs" />
    <Compile Include="Entitys\MES\V_PROD_TREE.cs" />
    <Compile Include="Entitys\MES\V_PROD_UNIT.cs" />