using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// ʵÌ壺¹¤µ¥ /// [Description("Primary:ID")] [DisplayName("¹¤µ¥")] [Serializable] [SugarTable("BIZ_MES_WO")] public class BIZ_MES_WO : DbEntityWithAuth { #region ¹¹Ô캯Êý /// /// ʵÌ壺¹¤µ¥ /// public BIZ_MES_WO() {} #endregion #region ¹«¹²ÊôÐÔ /// /// ¹¤µ¥ºÅ /// [DisplayName("¹¤µ¥ºÅ")] public string ORDER_NO { get; set; } /// /// ¹¤µ¥ÀàÐÍ(0Plan¼Æ»®|1Standard±ê×¼|2Rework·µ¹¤|3RestructuringÔÚ¿â¸ÄÖÆ|5OutsourcingίÍâ|6RDÑз¢|7ForecastÔ¤²â|8Disassemble²ðж) /// [DisplayName("¹¤µ¥ÀàÐÍ(0Plan¼Æ»®|1Standard±ê×¼|2Rework·µ¹¤|3RestructuringÔÚ¿â¸ÄÖÆ|5OutsourcingίÍâ|6RDÑз¢|7ForecastÔ¤²â|8Disassemble²ðж)")] public int ORDER_TYPE { get; set; } /// /// ¹¤µ¥ÃèÊö /// [DisplayName("¹¤µ¥ÃèÊö")] public string ORDER_DESC { get; set; } /// /// ¸¸¹¤µ¥ /// [DisplayName("¸¸¹¤µ¥")] public string PARENT_ORDER { get; set; } /// /// ״̬(0Init³õʼ»¯|1ImportedÒѵ¼Èë|2ReleaseÒÑÏ·¢|3WorkingÉú²úÖÐ|4PausedÒÑÔÝÍ£|5ClosedÒѹرÕ) /// [DisplayName("״̬(0Init³õʼ»¯|1ImportedÒѵ¼Èë|2ReleaseÒÑÏ·¢|3WorkingÉú²úÖÐ|4PausedÒÑÔÝÍ£|5ClosedÒѹرÕ)")] public int STATUS { get; set; } /// /// ÎïÁϱàÂë /// [DisplayName("ÎïÁϱàÂë")] public string ITEM_CODE { get; set; } /// /// ÎïÁÏÀàÐÍ /// [DisplayName("ÎïÁÏÀàÐÍ")] public string ITEM_TYPE { get; set; } /// /// »úÐÍ /// [DisplayName("»úÐÍ")] public string ITEM_MODEL { get; set; } /// /// ÓÅÏȼ¶ /// [DisplayName("ÓÅÏȼ¶")] public string PRIORITY { get; set; } /// /// ¿Í»§±àÂë /// [DisplayName("¿Í»§±àÂë")] public string CUST_CODE { get; set; } /// /// ·ÓɱàÂë /// [DisplayName("·ÓɱàÂë")] public string ROUTE_CODE { get; set; } /// /// ¹¤ÒÕ״̬(0WaitSet´ýÅäÖÃ|1FinishÒÑÅäÖÃ|2CancelÈ¡Ïû|3Close¹Ø±Õ) /// [DisplayName("¹¤ÒÕ״̬(0WaitSet´ýÅäÖÃ|1FinishÒÑÅäÖÃ|2CancelÈ¡Ïû|3Close¹Ø±Õ)")] public int ROUTE_STATUS { get; set; } /// /// ¹¤³§ /// [DisplayName("¹¤³§")] public string FACTORY { get; set; } /// /// ³µ¼ä±àÂë /// [DisplayName("³µ¼ä±àÂë")] public string WS_CODE { get; set; } /// /// ¼Æ»®ÏßÌå /// [DisplayName("¼Æ»®ÏßÌå")] public string PLAN_LINE { get; set; } /// /// ʵ¼ÊÏßÌå /// [DisplayName("ʵ¼ÊÏßÌå")] public string ACT_LINE { get; set; } /// /// ¼Æ»®¿ªÊ¼Ê±¼ä /// [DisplayName("¼Æ»®¿ªÊ¼Ê±¼ä")] public DateTime PLAN_START_TIME { get; set; } = DateTime.MinValue; /// /// ¼Æ»®½áÊøÊ±¼ä /// [DisplayName("¼Æ»®½áÊøÊ±¼ä")] public DateTime PLAN_END_TIME { get; set; } = DateTime.MinValue; /// /// ʵ¼Ê¿ªÊ¼Ê±¼ä /// [DisplayName("ʵ¼Ê¿ªÊ¼Ê±¼ä")] public DateTime ACT_START_TIME { get; set; } = DateTime.MinValue; /// /// ʵ¼Ê½áÊøÊ±¼ä /// [DisplayName("ʵ¼Ê½áÊøÊ±¼ä")] public DateTime ACT_END_TIME { get; set; } = DateTime.MinValue; /// /// ±ê×¼×÷ÒµÈËÊý /// [DisplayName("±ê×¼×÷ÒµÈËÊý")] public int STD_WORKER_QTY { get; set; } /// /// ʵ¼Ê×÷ÒµÈËÊý /// [DisplayName("ʵ¼Ê×÷ÒµÈËÊý")] public int ACT_WORKER_QTY { get; set; } /// /// µ¼Èëʱ¼ä /// [DisplayName("µ¼Èëʱ¼ä")] public DateTime IMPORT_TIME { get; set; } = DateTime.MinValue; /// /// Ï·¢Ê±¼ä /// [DisplayName("Ï·¢Ê±¼ä")] public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue; /// /// Ï·¢ÈË /// [DisplayName("Ï·¢ÈË")] public string RELEASE_USER { get; set; } /// /// ±ä¸üʱ¼ä /// [DisplayName("±ä¸üʱ¼ä")] public DateTime CHANGE_TIME { get; set; } = DateTime.MinValue; /// /// ±ä¸üÈË /// [DisplayName("±ä¸üÈË")] public string CHANGE_USER { get; set; } /// /// ¼Æ»®ÊýÁ¿ /// [DisplayName("¼Æ»®ÊýÁ¿")] public int PLAN_QTY { get; set; } /// /// ͶÈëÊýÁ¿ /// [DisplayName("ͶÈëÊýÁ¿")] public int INPUT_QTY { get; set; } /// /// Í깤ÊýÁ¿ /// [DisplayName("Í깤ÊýÁ¿")] public int OUTPUT_QTY { get; set; } /// /// ±¨·ÏÊýÁ¿ /// [DisplayName("±¨·ÏÊýÁ¿")] public int SCRAP_QTY { get; set; } /// /// Èë¿âÊýÁ¿ /// [DisplayName("Èë¿âÊýÁ¿")] public int STOCK_IN_QTY { get; set; } /// /// UPH /// [DisplayName("UPH")] public double UPH { get; set; } /// /// UPPH /// [DisplayName("UPPH")] public double UPPH { get; set; } /// /// ×îºóµÄ¹¤µ¥ÀúÊ·ID /// [DisplayName("×îºóµÄ¹¤µ¥ÀúÊ·ID")] public string LAST_HIST_ID { get; set; } /// /// ±¸×¢ /// [DisplayName("±¸×¢")] public string REMARK { get; set; } /// /// ½Ó¿Ú±í¼Ç¼ID /// [DisplayName("½Ó¿Ú±í¼Ç¼ID")] public string FBILLNO_ID { get; set; } /// /// ±¸Áϵ¥·µ»ØÐÅÏ¢ /// [DisplayName("±¸Áϵ¥·µ»ØÐÅÏ¢")] 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 ClassAList { get; set; }//×¢Òâ½ûÖ¹ÊÖ¶¯¸³Öµ£¬Ö»ÄÜÊÇnull //¶à¶Ô¶àÍâ¼üµ¼º½ [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_MES_WOId), nameof(MappingClass.ClassAId))]//×¢Òâ˳Ðò public List ClassAList { get; set; } //×¢Òâ½ûÖ¹ÊÖ¶¯¸³Öµ£¬Ö»ÄÜÊÇnull */ #endregion #region ö¾Ù±äÁ¿ /*Àý×Ó public enum FieldNames { [Description("ö¾ÙÃèÊö0")] Enum0, [Description("ö¾ÙÃèÊö1")] Enum1, } */ /// /// ö¾Ù£º¹¤µ¥ÀàÐÍ(0Plan¼Æ»®|1Standard±ê×¼|2Rework·µ¹¤|3RestructuringÔÚ¿â¸ÄÖÆ|5OutsourcingίÍâ|6RDÑз¢|7ForecastÔ¤²â|8Disassemble²ðж) /// public enum ORDER_TYPEs { [Description("¼Æ»®")] Plan = 0, [Description("±ê×¼")] Standard = 1, [Description("·µ¹¤")] Rework = 2, [Description("ÔÚ¿â¸ÄÖÆ")] Restructuring = 3, [Description("ίÍâ")] Outsourcing = 5, [Description("Ñз¢")] RD = 6, [Description("Ô¤²â")] Forecast = 7, [Description("²ðж")] Disassemble = 8, } /// /// ö¾Ù£º×´Ì¬(0Init³õʼ»¯|1ImportedÒѵ¼Èë|2ReleaseÒÑÏ·¢|3WorkingÉú²úÖÐ|4PausedÒÑÔÝÍ£|5ClosedÒѹرÕ) /// public enum STATUSs { [Description("³õʼ»¯")] Init = 0, [Description("Òѵ¼Èë")] Imported = 1, [Description("ÒÑÏ·¢")] Release = 2, [Description("Éú²úÖÐ")] Working = 3, [Description("ÒÑÔÝÍ£")] Paused = 4, [Description("ÒѹرÕ")] Closed = 5, } /// /// ö¾Ù£º¹¤ÒÕ״̬(0WaitSet´ýÅäÖÃ|1FinishÒÑÅäÖÃ|2CancelÈ¡Ïû|3Close¹Ø±Õ) /// public enum ROUTE_STATUSs { [Description("´ýÅäÖÃ")] WaitSet = 0, [Description("ÒÑÅäÖÃ")] Finish = 1, [Description("È¡Ïû")] Cancel = 2, [Description("¹Ø±Õ")] Close = 3, } #endregion #region ¹«¹²·½·¨ #endregion }//endClass }