using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:送货单(SRM) /// [Description("Primary:ID")] [Serializable] [SugarTable("BIZ_SRM_DLVY")] public class BIZ_SRM_DLVY : DbEntityWithAuth { #region 构造函数 /// /// 实体:送货单(SRM) /// public BIZ_SRM_DLVY() {} #endregion #region 公共属性 /// /// 送货单号 /// public string DELIVERY_NO { get; set; } /// /// 企企通状态(0: 新建; 1: 待签收;2: 签收中;3: 已完成;4: 作废;) 携客云状态(1: 待签收;2: 签收中;3: 已完成;4: 撤回;8: 已作废;版本2.0新增5:申请中,7:同意,9:部分同意 10: 已冻结 11: 申请撤回) /// public int STATUS { get; set; } /// /// 供应商代码 /// public string SUPP_CODE { get; set; } /// /// 供应商名称 /// public string SUPP_NAME { get; set; } /// /// 收货人 /// public string RECEIVER { get; set; } /// /// 收货日期 /// public DateTime RECEIVE_DATE { get; set; } = DateTime.MinValue; /// /// 送货类型 ,1 :普通(正常出货) 2:补货(先入库,后补出货单) 3: 备品 4:样品 5:VMI /// public int DELIVERY_TYPE { get; set; } /// /// 采购类型,1:一般采购 2:委外采购 /// public int PURCHASE_TYPE { get; set; } /// /// 物流状态 0:未发出;1:已发货;2:已到货 /// public int LOGISTICS_STATUS { get; set; } /// /// 送货日期 /// public DateTime DELIVERY_DATE { get; set; } = DateTime.MinValue; /// /// 预计送达日期 /// public DateTime PLANARRIVED_DATE { get; set; } = DateTime.MinValue; /// /// 送货联系人 /// public string CONTACT_PERSON { get; set; } /// /// 送货人联系电话 /// public string CONTACT_MOBILE { get; set; } /// /// 收货明细地址 /// public string ADDRESS { get; set; } /// /// 送货车牌号 /// public string CAR_NO { get; set; } /// /// 备注 /// public string REMARK { get; set; } /// /// 送货标识 /// public int DELIVERY_FLAG { get; set; } /// /// 毛重 /// public double GROSS_WEIGHT { get; set; } /// /// 净重 /// public double NET_WEIGHT { get; set; } /// /// 重量单位 /// public string UNIT_WEIGHTCODE { get; set; } /// /// 重量单位名称 /// public string UNIT_WEIGHTNAME { get; set; } /// /// 总包装数量 /// public string TOTAL_PACKING_QTY { get; set; } /// /// -1:未处理,0:同步处理完,>0:同步处理失败次数 /// public int HANDLED { get; set; } /// /// 最后一次同步处理日期 /// public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue; /// /// 过账提交的JSON /// public string COMMIT_JSON { get; set; } /// /// 过账提交的返回信息 /// 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_SRM_DLVY类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_SRM_DLVYId))]//ClassA表中的BIZ_SRM_DLVYId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_SRM_DLVYId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToMany, nameof(BIZ_SRM_DLVY_DTL.DELIVERY_NO), nameof(DELIVERY_NO))] public List DtlsWithGhost { get; set; }//注意禁止手动赋值,只能是null [SugarColumn(IsIgnore = true)] public List Dtls => DtlsWithGhost?.Where(q => !q.GHOST_ROW).ToList(); [Navigate(NavigateType.OneToMany, nameof(V_SRM_ITEM.DELIVERY_NO), nameof(DELIVERY_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, } */ public enum STATUSs { [Description("新建")] Init, [Description("待签收")] Waiting, [Description("签收中")] Receiving, [Description("已完成")] Finish, [Description("作废")] Cancel } public enum DELIVERY_TYPEs { [Description("普通")] General = 1, [Description("补货")] Replenishment = 2, [Description("备品")] Spares = 3, [Description("样品")] Sample = 4, [Description("VMI")] VMI = 5 } public enum PURCHASE_TYPEs { [Description("一般采购")] General, [Description("委外采购")] Outsourcing, } public enum LOGISTICS_STATUSs { [Description("未发货")] Unshipped, [Description("已发货")] Shipped, [Description("已到货")] Received, } #endregion #region 公共方法 #endregion }//endClass }