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("V_BIZ_ERP_SALE_OUT_DTL")]
|
public class V_BIZ_ERP_SALE_OUT_DTL : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：销售出库单(ERP)明细
|
/// </summary>
|
public V_BIZ_ERP_SALE_OUT_DTL() {}
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 单据代码
|
/// </summary>
|
public string BILLCODE { get; set; }
|
/// <summary>
|
/// 单据行号
|
/// </summary>
|
public string BILLLINE { get; set; }
|
/// <summary>
|
/// 单据行状态
|
/// </summary>
|
public int LINESTATUS { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 单位代码
|
/// </summary>
|
public string UNITCODE { get; set; }
|
/// <summary>
|
/// 需求数量
|
/// </summary>
|
public double PRQTY { get; set; }
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public double QTY { get; set; }
|
/// <summary>
|
/// 发货日期
|
/// </summary>
|
public DateTime DELIVERYDATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 仓库代码
|
/// </summary>
|
public string WAREHOUSECODE { get; set; }
|
/// <summary>
|
/// 来源单据类型
|
/// </summary>
|
public int SOURCETYPE { get; set; }
|
/// <summary>
|
/// 来源单据代码
|
/// </summary>
|
public string SOURCECODE { get; set; }
|
/// <summary>
|
/// 来源单据行号
|
/// </summary>
|
public string SOURCELINE { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string REMARK { get; set; }
|
/// <summary>
|
/// 客户代码
|
/// </summary>
|
public string CUST_CODE { get; set; }
|
/// <summary>
|
/// ERP单据代码
|
/// </summary>
|
public string ERP_BILL_CODE { get; set; }
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string ITEM_NAME { get;set; }
|
/// <summary>
|
/// 欠发数量
|
/// </summary>
|
public double OWE_QTY { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_SALE_OUT_DTL类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_SALE_OUT_DTLId))]//ClassA表中的BIZ_ERP_SALE_OUT_DTLId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_SALE_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
[Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")]
|
public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值，只能是null
|
[SugarColumn(IsIgnore = true)]
|
public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG);
|
#endregion
|
|
#region 枚举变量
|
/*例子
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|
