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