using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体:采购单(ERP)明细
|
/// </summary>
|
[Description("Primary:ID")]
|
[Serializable]
|
[SugarTable("BIZ_ERP_PO_DTL")]
|
public class BIZ_ERP_PO_DTL : DbEntityWithAuth
|
{
|
#region 构造函数
|
|
/// <summary>
|
/// 实体:采购单(ERP)明细
|
/// </summary>
|
public BIZ_ERP_PO_DTL()
|
{ }
|
|
#endregion 构造函数
|
|
#region 公共属性
|
|
/// <summary>
|
/// 单据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 double PRQTY { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public double QTY { get; set; }
|
|
/// <summary>
|
/// 送货数量
|
/// </summary>
|
public double ARRIVALQTY { get; set; }
|
|
/// <summary>
|
/// 入库数量
|
/// </summary>
|
public double INSTOCKQTY { get; set; }
|
|
/// <summary>
|
/// 退货数量
|
/// </summary>
|
public double RETURNQTY { get; set; }
|
|
/// <summary>
|
/// 是否赠品
|
/// </summary>
|
public int ISGIVEAWAY { get; set; }
|
|
/// <summary>
|
/// 税率
|
/// </summary>
|
public double TAXRATE { get; set; }
|
|
/// <summary>
|
/// 价格
|
/// </summary>
|
public double PRICE { get; set; }
|
|
/// <summary>
|
/// 含税价格
|
/// </summary>
|
public double TAXPRICE { get; set; }
|
|
/// <summary>
|
/// 总价
|
/// </summary>
|
public double AMOUNT { get; set; }
|
|
/// <summary>
|
/// 所有总价
|
/// </summary>
|
public double ALLAMOUNT { get; set; }
|
|
/// <summary>
|
/// 含税总价
|
/// </summary>
|
public double TAXAMOUNT { get; set; }
|
|
/// <summary>
|
/// 折扣率
|
/// </summary>
|
public double DISCOUNTRATE { get; set; }
|
|
/// <summary>
|
/// 折扣金额
|
/// </summary>
|
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 公共属性
|
|
#region 虚拟属性
|
/*例子
|
/// <summary>
|
/// 瀹炰綋锛欱IZ_ERP_PO_DTL
|
/// </summary>
|
[Description("Primary:Id")]
|
[Serializable]
|
[SugarTable("BIZ_ERP_PO_DTL")]
|
public class BIZ_ERP_PO_DTL : DbEntityWithAuth
|
{
|
#region 鏋勯€犲嚱鏁?
|
|
/// <summary>
|
/// 瀹炰綋锛欱IZ_ERP_PO_DTL
|
/// </summary>
|
public BIZ_ERP_PO_DTL()
|
{ }
|
|
#endregion 鏋勯€犲嚱鏁?
|
|
#region 鍏叡灞炴€?
|
|
/// <summary>
|
/// 鍗曟嵁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 double PRQTY { get; set; }
|
|
/// <summary>
|
/// 鏁伴噺
|
/// </summary>
|
public double QTY { get; set; }
|
|
/// <summary>
|
/// 閫佽揣鏁伴噺
|
/// </summary>
|
public double? ARRIVALQTY { get; set; }
|
|
/// <summary>
|
/// 鍏ュ簱鏁伴噺
|
/// </summary>
|
public double INSTOCKQTY { get; set; }
|
|
/// <summary>
|
/// 閫€璐ф暟閲?
|
/// </summary>
|
public double RETURNQTY { get; set; }
|
|
/// <summary>
|
/// 鏄惁璧犲搧
|
/// </summary>
|
public bool ISGIVEAWAY { get; set; }
|
|
/// <summary>
|
/// 绋庣巼
|
/// </summary>
|
public double TAXRATE { get; set; }
|
|
/// <summary>
|
/// 浠锋牸
|
/// </summary>
|
public double PRICE { get; set; }
|
|
/// <summary>
|
/// 鍚◣浠锋牸
|
/// </summary>
|
public double TAXPRICE { get; set; }
|
|
/// <summary>
|
/// 鎬讳环
|
/// </summary>
|
public double AMOUNT { get; set; }
|
|
/// <summary>
|
/// 鎵€鏈夋€讳环
|
/// </summary>
|
public double ALLAMOUNT { get; set; }
|
|
/// <summary>
|
/// 鍚◣鎬讳环
|
/// </summary>
|
public double TAXAMOUNT { get; set; }
|
|
/// <summary>
|
/// 鎶樻墸鐜?
|
/// </summary>
|
public double DISCOUNTRATE { get; set; }
|
|
/// <summary>
|
/// 鎶樻墸閲戦
|
/// </summary>
|
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 鍏叡灞炴€?
|
|
#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<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 枚举变量
|
|
#region 鏋氫妇鍙橀噺
|
|
/*渚嬪瓙
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
|
#endregion 鏋氫妇鍙橀噺
|
}//endClass
|
}
|