using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:送货单(SRM)明细 /// [Description("Primary:ID")] [Serializable] [SugarTable("V_BIZ_SRM_DLVY_DTL")] public class V_BIZ_SRM_DLVY_DTL : DbEntityWithAuth { #region 构造函数 /// /// 实体:送货单(SRM)明细 /// public V_BIZ_SRM_DLVY_DTL() {} #endregion #region 公共属性 /// /// 送货单号 /// public string DELIVERY_NO { get; set; } /// /// 采购单项次 /// public int LINE_NO { get; set; } = 0; /// /// ERP采购单号 /// public string ERP_PO_NO { get; set; } /// /// 送货单项次 /// public int PO_LINE_NO { get; set; } = 0; /// /// 采购单类型 1:一般采购;2:委外采购 /// public int PO_TYPE { get; set; } = 1; /// /// 物料编码 /// public string ITEM_CODE { get; set; } /// /// 物料名称 /// public string ITEM_NAME { get; set; } /// /// 规格 /// public string SPECIFICATION { get; set; } /// /// 数量 /// public double QTY { get; set; } = 0; /// /// 单位 /// public string UNIT { get; set; } /// /// 计价数量 /// public int VALUATION_QTY { get; set; } = 0; /// /// 单价 /// public double PRICE { get; set; } = 0; /// /// 含税单价 /// public double TAX_PRICE { get; set; } = 0; /// /// 状态(1:待签收;2:签收中;3: 已完成;) /// public int STATUS { get; set; } = 1; /// /// 收货状态(0-未收货;1-部分收货;2-全部收货) /// public int RECEIVE_STATUS { get; set; } = 0; /// /// 采购员 /// public string BUYER { get; set; } /// /// 订单交期 /// public DateTime EXPECTED_DATE { get; set; } = DateTime.MinValue; /// /// 排定交期(回复交期) /// public DateTime ANSWER_DATE { get; set; } = DateTime.MinValue; /// /// 币别编码 /// public string CURRENCY_CODE { get; set; } /// /// 币别名称 /// public string CURRENCY_NAME { get; set; } /// /// 送检状态(0:未送检;1:部分送检;2:全部送检 3免检) /// public int VERIFY_STATUS { get; set; } = 0; /// /// 检验结果标识(0:免检 1:全部合格;2:部分合格;3:拒收) /// public int VERIFY_RESULT { get; set; } = 0; /// /// 备注 /// public string REMARK { get; set; } /// /// 品牌 /// public string BRAND_NAME { get; set; } /// /// 批次 /// public string BATCH_NUMBER { get; set; } /// /// 单位名称 /// public string UNIT_NAME { get; set; } /// /// 包装数量 /// public double PACKING_QTY { get; set; } = 0; /// /// 申请数量 /// public int APPLY_DELIVERY_QTY { get; set; } = 0; /// /// 毛重 /// 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 int URGENT_FLAG { get; set; } = 0; /// /// 标识是否签收 /// //public string SOURCECODE { get; set; } /// /// 标识是否签收 /// #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_SRM_DLVY_DTL类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_SRM_DLVY_DTLId))]//ClassA表中的BIZ_SRM_DLVY_DTLId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_SRM_DLVY_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ public enum STATUSs { [Description("待签收")] INVENTORY=1, [Description("签收中")] WORKING=2, [Description("已完成")] EXCEED=3, } public enum RECEIVE_STATUSs { [Description("待签收")] INVENTORY, [Description("签收中")] WORKING, [Description("已完成")] EXCEED, } public enum VERIFY_STATUSs { [Description("未送检")] NOTSUBMISSION, [Description("部分送检")] PARTSUBMISSION, [Description("全部送检")] ALLSUBMISSION, [Description("免检")] NOTINSPECT, } public enum VERIFY_RESULTs { [Description("免检")] NOTINSPECT, [Description("全部合格")] ALLQUALIFIED, [Description("部分合格")] PARTQUALIFIED, [Description("拒收")] REJECTION, } #endregion #region 公共方法 #endregion }//endClass }