using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:采购单(ERP)明细 /// [Description("Primary:ID")] [Serializable] [SugarTable("BIZ_ERP_PO_DTL")] public class BIZ_ERP_PO_DTL : DbEntityWithAuth { #region 构造函数 /// /// 实体:采购单(ERP)明细 /// public BIZ_ERP_PO_DTL() { } #endregion 构造函数 #region 公共属性 /// /// 单据ID /// public string BILLID { get; set; } /// /// 单据号码 /// public string BILLCODE { get; set; } /// /// 单据行号 /// public string BILLLINE { get; set; } /// /// 物料代码 /// public string MATERIALCODE { get; set; } /// /// 单位代码 /// public string UNITCODE { get; set; } /// /// 行单据状态 /// public int LINESTATUS { get; set; } /// /// 需求数量 /// public double PRQTY { get; set; } /// /// 数量 /// public double QTY { get; set; } /// /// 送货数量 /// public double ARRIVALQTY { get; set; } /// /// 入库数量 /// public double INSTOCKQTY { get; set; } /// /// 退货数量 /// public double RETURNQTY { get; set; } /// /// 是否赠品 /// public int ISGIVEAWAY { get; set; } /// /// 税率 /// public double TAXRATE { get; set; } /// /// 价格 /// public double PRICE { get; set; } /// /// 含税价格 /// public double TAXPRICE { get; set; } /// /// 总价 /// public double AMOUNT { get; set; } /// /// 所有总价 /// public double ALLAMOUNT { get; set; } /// /// 含税总价 /// public double TAXAMOUNT { get; set; } /// /// 折扣率 /// public double DISCOUNTRATE { get; set; } /// /// 折扣金额 /// public double DISCOUNT { get; set; } /// /// 供应商物料编码 /// public string SUPPLIERMATERIALCODE { get; set; } /// /// 送货日期 /// public DateTime DELIVERYDATE { get; set; } = DateTime.MinValue; /// /// 承诺日期 /// public DateTime PROMISEDATE { get; set; } = DateTime.MinValue; /// /// 备注 /// public string REMARK { get; set; } #endregion 公共属性 #region 虚拟属性 /*例子 /// /// 瀹炰綋锛欱IZ_ERP_PO_DTL /// [Description("Primary:Id")] [Serializable] [SugarTable("BIZ_ERP_PO_DTL")] public class BIZ_ERP_PO_DTL : DbEntityWithAuth { #region 鏋勯€犲嚱鏁? /// /// 瀹炰綋锛欱IZ_ERP_PO_DTL /// public BIZ_ERP_PO_DTL() { } #endregion 鏋勯€犲嚱鏁? #region 鍏叡灞炴€? /// /// 鍗曟嵁ID /// public string BILLID { get; set; } /// /// 鍗曟嵁鍙风爜 /// public string BILLCODE { get; set; } /// /// 鍗曟嵁琛屽彿 /// public int BILLLINE { get; set; } /// /// 鐗╂枡浠g爜 /// public string MATERIALCODE { get; set; } /// /// 鍗曚綅浠g爜 /// public string UNITCODE { get; set; } /// /// 琛屽崟鎹姸鎬? /// public int LINESTATUS { get; set; } /// /// 闇€姹傛暟閲? /// public double PRQTY { get; set; } /// /// 鏁伴噺 /// public double QTY { get; set; } /// /// 閫佽揣鏁伴噺 /// public double? ARRIVALQTY { get; set; } /// /// 鍏ュ簱鏁伴噺 /// public double INSTOCKQTY { get; set; } /// /// 閫€璐ф暟閲? /// public double RETURNQTY { get; set; } /// /// 鏄惁璧犲搧 /// public bool ISGIVEAWAY { get; set; } /// /// 绋庣巼 /// public double TAXRATE { get; set; } /// /// 浠锋牸 /// public double PRICE { get; set; } /// /// 鍚◣浠锋牸 /// public double TAXPRICE { get; set; } /// /// 鎬讳环 /// public double AMOUNT { get; set; } /// /// 鎵€鏈夋€讳环 /// public double ALLAMOUNT { get; set; } /// /// 鍚◣鎬讳环 /// public double TAXAMOUNT { get; set; } /// /// 鎶樻墸鐜? /// public double DISCOUNTRATE { get; set; } /// /// 鎶樻墸閲戦 /// public double DISCOUNT { get; set; } /// /// 渚涘簲鍟嗙墿鏂欑紪鐮? /// public string SUPPLIERMATERIALCODE { get; set; } /// /// 閫佽揣鏃ユ湡 /// public DateTime DELIVERYDATE { get; set; } = DateTime.MinValue; /// /// 鎵胯鏃ユ湡 /// public DateTime PROMISEDATE { get; set; } = DateTime.MinValue; /// /// 澶囨敞 /// public string REMARK { get; set; } #endregion 鍏叡灞炴€? #region 铏氭嫙灞炴€? /*渚嬪瓙 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion 铏氭嫙灞炴€? #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_PO_DTL类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_PO_DTLId))]//ClassA表中的BIZ_ERP_PO_DTLId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_PO_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ #endregion 外键属性 #region 枚举变量 /*例子 #endregion 枚举变量 #region 鏋氫妇鍙橀噺 /*渚嬪瓙 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ #endregion 鏋氫妇鍙橀噺 }//endClass }