using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:收货单(U9) /// [Description("Primary:ID")] [DisplayName("收货单(U9)")] [Serializable] [SugarTable("BIZ_U9_RECEIPT")] public class BIZ_U9_RECEIPT : DbEntityWithAuth { #region 构造函数 /// /// 实体:收货单(U9) /// public BIZ_U9_RECEIPT() {} #endregion #region 公共属性 /// /// 单据号 /// [DisplayName("单据号")] public string ORDER_NO { get; set; } /// /// 状态(0Init初始化|1Imported已导入|2Arrived已送达|3Counting清点中|4InQC检验中|5Storing上架中|6Review待审核|7Finished已完成|8Cancel已作废) /// [DisplayName("状态(0Init初始化|1Imported已导入|2Arrived已送达|3Counting清点中|4InQC检验中|5Storing上架中|6Review待审核|7Finished已完成|8Cancel已作废)")] public int STATUS { get; set; } /// /// 供应商编码 /// [DisplayName("供应商编码")] public string SUPP_CODE { get; set; } /// /// 供应商名称 /// [DisplayName("供应商名称")] public string SUPP_NAME { get; set; } /// /// 单据日期 /// [DisplayName("单据日期")] public DateTime ORDER_DATE { get; set; } = DateTime.MinValue; /// /// 收货人 /// [DisplayName("收货人")] public string RECEIVER { get; set; } /// /// 收货日期 /// [DisplayName("收货日期")] public DateTime RECEIVE_DATE { get; set; } = DateTime.MinValue; /// /// 送货单ID /// [DisplayName("送货单ID")] public string ASN_ID { get; set; } /// /// 送货单号 /// [DisplayName("送货单号")] public string ASN_NO { get; set; } /// /// ERP单据状态 /// [DisplayName("ERP单据状态")] public string ERP_STATUS_CODE { get; set; } /// /// ERP单据状态名称 /// [DisplayName("ERP单据状态名称")] public string ERP_STATUS_NAME { get; set; } /// /// 备注 /// [DisplayName("备注")] public string REMARK { get; set; } /// /// -1:未处理,0:同步处理完,>0:同步处理失败次数 /// [DisplayName("-1:未处理,0:同步处理完,>0:同步处理失败次数")] public int HANDLED { get; set; } = -1; /// /// 最后一次同步处理日期 /// [DisplayName("最后一次同步处理日期")] public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue; /// /// 过账提交的JSON /// [DisplayName("过账提交的JSON")] public string COMMIT_JSON { get; set; } /// /// 过账提交的返回信息 /// [DisplayName("过账提交的返回信息")] public string COMMIT_MSG { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_U9_RECEIPT类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_RECEIPTId))]//ClassA表中的BIZ_U9_RECEIPTId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_RECEIPTId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToMany, nameof(BIZ_U9_RECEIPT_DTL.ORDER_NO), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_U9_RECEIPT类里面的外键ID字段 public List Details { get; set; } //注意禁止手动赋值,只能是null [Navigate(NavigateType.OneToMany, nameof(BIZ_U9_RECEIPT_SN.ORDER_NO), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_U9_RECEIPT类里面的外键ID字段 public List SnList { get; set; } //注意禁止手动赋值,只能是null #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ /// /// 枚举:状态(0Init初始化|1Imported已导入|2Arrived已送达|3Counting清点中|4InQC检验中|5Storing上架中|6Review待审核|7Finished已完成|8Cancel已作废) /// public enum STATUSs { [Description("初始化")] Init = 0, [Description("已导入")] Imported = 1, [Description("已送达")] Arrived = 2, [Description("清点中")] Counting = 3, [Description("检验中")] InQC = 4, [Description("上架中")] Storing = 5, [Description("待审核")] Review = 6, [Description("已完成")] Finished = 7, [Description("已作废")] Cancel = 8, } #endregion #region 公共方法 #endregion }//endClass }