using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; using Tiger.Model.Base; namespace Tiger.Model { /// /// 实体:送货单(U9) /// [Description("Primary:ID")] [DisplayName("送货单(U9)")] [Serializable] [SugarTable("BIZ_U9_ASN")] public class BIZ_U9_ASN : DbEntityWithAuth, iBizOrder { #region 构造函数 /// /// 实体:送货单(U9) /// public BIZ_U9_ASN() {} #endregion #region 公共属性 /// /// 单据号 /// [DisplayName("单据号")] public string ORDER_NO { get; set; } /// /// 状态(0Init初始化|1Imported已导入|2Arrived已送达|3Counting清点中|4Finished已完成|5Cancel已作废) /// [DisplayName("状态(0Init初始化|1Imported已导入|2Arrived已送达|3Counting清点中|4Finished已完成|5Cancel已作废)")] 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 DateTime DELIVERY_DATE { get; set; } = DateTime.MinValue; /// /// 预计送达日期 /// [DisplayName("预计送达日期")] public DateTime PLANARRIVED_DATE { get; set; } = DateTime.MinValue; /// /// 采购单ID /// [DisplayName("采购单ID")] public string PO_ID { get; set; } /// /// 采购单号 /// [DisplayName("采购单号")] public string PO_NO { get; set; } /// /// 收货单ID /// [DisplayName("收货单ID")] public string RECEIVER_ID { get; set; } /// /// 收货单号 /// [DisplayName("收货单号")] public string RECEIVER_NO { get; set; } /// /// 收货人 /// [DisplayName("收货人")] public string RECEIVER { get; set; } /// /// 收货日期 /// [DisplayName("收货日期")] public DateTime RECEIVE_DATE { get; set; } = DateTime.MinValue; /// /// 备注 /// [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; } */ [SugarColumn(IsIgnore = true)] public bool IsFinished { get; set; } #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_U9_ASN类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_ASNId))]//ClassA表中的BIZ_U9_ASNId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_ASNId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToMany, nameof(BIZ_U9_ASN_DTL.ORDER_NO), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_U9_ASN类里面的外键ID字段 public List Details { get; set; } //注意禁止手动赋值,只能是null [Navigate(NavigateType.OneToMany, nameof(BIZ_U9_ASN_SN.ORDER_NO), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_U9_ASN类里面的外键ID字段 public List SnList { get; set; } //注意禁止手动赋值,只能是null #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ /// /// 枚举:状态(0Init初始化|1Imported已导入|2Arrived已送达|3Counting清点中|4Finished已完成|5Cancel已作废) /// public enum STATUSs { [Description("初始化")] Init = 0, [Description("已导入")] Imported = 1, [Description("已送达")] Arrived = 2, [Description("清点中")] Counting = 3, [Description("已完成")] Finished = 4, [Description("已作废")] Cancel = 5, } #endregion #region 公共方法 #endregion }//endClass }