using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:包装规则定义 /// [Description("Primary:ID")] [Serializable] [SugarTable("BAS_PKG_RULE")] public class BAS_PKG_RULE : DbEntityWithAuth { #region 构造函数 /// /// 实体:包装规则定义 /// public BAS_PKG_RULE() {} #endregion #region 公共属性 /// /// 包装规则编码 /// public string RULE_CODE { get; set; } /// /// 包装规则名称 /// public string RULE_NAME { get; set; } /// /// 是否启用(Y/N) /// public string IS_ACTIVE { get; set; } /// /// 备注 /// public string REMARK { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BAS_PKG_RULE类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BAS_PKG_RULEId))]//ClassA表中的BAS_PKG_RULEId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BAS_PKG_RULEId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToMany, nameof(BAS_PKG_DTL.PKG_RULE_ID), nameof(ID), "GHOST_ROW = 0")]//ClassA表中的BAS_LABEL_TEMPId public List Details { get; set; }//注意禁止手动赋值,只能是null #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ #endregion #region 公共方法 public int GetTotalQty() { int qty = 0; foreach (var dtl in Details.OrderBy(q => q.PKG_LEVEL)) { if (dtl.PKG_LEVEL == 1) { qty = dtl.PKG_QTY; } else { qty *= dtl.PKG_QTY; } } return qty; } #endregion }//endClass }