using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:调拨单(WMS) /// [Description("Primary:ID")] [DisplayName("调拨单(WMS)")] [Serializable] [SugarTable("BIZ_WMS_TRANSFER")] public class BIZ_WMS_TRANSFER : DbEntityWithAuth { #region 构造函数 /// /// 实体:调拨单(WMS) /// public BIZ_WMS_TRANSFER() {} #endregion #region 公共属性 /// /// 调拨单号 /// [DisplayName("调拨单号")] public string ORDER_NO { get; set; } /// /// 单据日期 /// [DisplayName("单据日期")] public DateTime ORDER_DATE { get; set; } = DateTime.MinValue; /// /// 状态(0Init新创建|1Imported已导入|2WaitPick待捡料|3Picking捡料中|4Picked已捡完|5Sended已调出|6Arrived已送达|7Counting清点中|8InQC检验中|9Storing上架中|10Finished已完成|11Cancel作废) /// [DisplayName("状态(0Init新创建|1Imported已导入|2WaitPick待捡料|3Picking捡料中|4Picked已捡完|5Sended已调出|6Arrived已送达|7Counting清点中|8InQC检验中|9Storing上架中|10Finished已完成|11Cancel作废)")] public int STATUS { get; set; } /// /// 调出仓库 /// [DisplayName("调出仓库")] public string OUT_WH_CODE { get; set; } /// /// 拨入仓库 /// [DisplayName("拨入仓库")] public string IN_WH_CODE { get; set; } /// /// 来源单据编码,多个用“,”分隔 /// [DisplayName("来源单据编码,多个用“,”分隔")] public string SOURCE_CODE { get; set; } /// /// 来源单号,多个用“,”分隔,跟编码一一对应 /// [DisplayName("来源单号,多个用“,”分隔,跟编码一一对应")] public string SOURCE_ORDER { get; set; } /// /// ERP单据号码 /// [DisplayName("ERP单据号码")] public string ERP_ORDER { get; set; } /// /// 单据类型编码 /// [DisplayName("单据类型编码")] public string TYPE_CODE { get; set; } /// /// 单据类型名称 /// [DisplayName("单据类型名称")] public string TYPE_NAME { 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; } /// /// 最后一次同步处理日期 /// [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_WMS_TRANSFER类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_WMS_TRANSFERId))]//ClassA表中的BIZ_WMS_TRANSFERId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_WMS_TRANSFERId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_TRANSFER_DTL.ORDER_NO), nameof(ORDER_NO))] public List DtlsWithGhost { get; set; }//注意禁止手动赋值,只能是null [SugarColumn(IsIgnore = true)] public List Dtls => DtlsWithGhost?.Where(q => !q.GHOST_ROW).ToList(); [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_TRANSFER_SN.ORDER_NO), nameof(ORDER_NO))] public List SnListWithGhost { get; set; }//注意禁止手动赋值,只能是null [SugarColumn(IsIgnore = true)] public List SnList => SnListWithGhost?.Where(q => !q.GHOST_ROW).ToList(); #endregion 外键属性 #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ /// /// 枚举:状态(0Init新创建|1Imported已导入|2WaitPick待捡料|3Picking捡料中|4Picked已捡完|5Sended已调出|6Arrived已送达|7Counting清点中|8InQC检验中|9Storing上架中|10Finished已完成|11Cancel作废) /// public enum STATUSs { [Description("新创建")] Init = 0, [Description("已导入")] Imported = 1, [Description("待捡料")] WaitPick = 2, [Description("捡料中")] Picking = 3, [Description("已捡完")] Picked = 4, [Description("已调出")] Sended = 5, [Description("已送达")] Arrived = 6, [Description("清点中")] Counting = 7, [Description("检验中")] InQC = 8, [Description("上架中")] Storing = 9, [Description("已完成")] Finished = 10, [Description("作废")] Cancel = 11, } #endregion #region 公共方法 #endregion }//endClass }