using SqlSugar;
|
using System;
|
using System.Linq;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：采购单(ERP)
|
/// </summary>
|
[Description("Primary:ID")]
|
[Serializable]
|
[SugarTable("BIZ_ERP_PO")]
|
public class BIZ_ERP_PO : DbEntityWithAuth
|
{
|
#region 构造函数
|
|
/// <summary>
|
/// 实体：采购单(ERP)
|
/// </summary>
|
public BIZ_ERP_PO()
|
{ }
|
|
#endregion 构造函数
|
|
#region 公共属性
|
|
/// <summary>
|
/// 单据号码
|
/// </summary>
|
public string BILLCODE { get; set; }
|
|
/// <summary>
|
/// 单据时间
|
/// </summary>
|
public DateTime BILLDATE { get; set; } = DateTime.MinValue;
|
|
/// <summary>
|
/// 单据类型
|
/// </summary>
|
public int BILLTYPE { get; set; }
|
|
/// <summary>
|
/// 单据状态
|
/// </summary>
|
public int STATUS { get; set; }
|
|
/// <summary>
|
/// 币种
|
/// </summary>
|
public string CURRENCY { get; set; }
|
|
/// <summary>
|
/// 汇率
|
/// </summary>
|
public double EXCHANGERATE { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string PURDEPTCODE { get; set; }
|
|
/// <summary>
|
/// 采购员代码
|
/// </summary>
|
public string PUREMPLOYEECODE { get; set; }
|
|
/// <summary>
|
/// 供应商代码
|
/// </summary>
|
public string SUPPLIERCODE { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string REMARK { get; set; }
|
|
/// <summary>
|
/// -1:未处理，0:同步处理完，>0:同步处理失败次数
|
/// </summary>
|
public int HANDLED { get; set; }
|
|
/// <summary>
|
/// 最后一次同步处理日期
|
/// </summary>
|
public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 过账提交的JSON
|
/// </summary>
|
public string COMMIT_JSON { get; set; }
|
/// <summary>
|
/// 过账提交的返回信息
|
/// </summary>
|
public string COMMIT_MSG { get; set; }
|
|
#endregion 公共属性
|
|
#region 虚拟属性
|
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
|
#endregion 虚拟属性
|
|
#region 外键属性
|
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_PO类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_POId))]//ClassA表中的BIZ_ERP_POId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_POId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
[Navigate(NavigateType.OneToMany, nameof(BILLCODE), nameof(BIZ_ERP_PO_DTL.BILLCODE))]
|
public List<BIZ_ERP_PO_DTL> DetailsWithGhost { get; set; }//注意禁止手动赋值，只能是null
|
[SugarColumn(IsIgnore = true)]
|
public List<BIZ_ERP_PO_DTL> Details => DetailsWithGhost?.Where(q => !q.GHOST_ROW).ToList();
|
#endregion 外键属性
|
|
#region 枚举变量
|
/*例子
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
|
public enum STATUSs
|
{
|
[Description("新建\\开立")]
|
INIT = 1,
|
|
[Description("作业中")]
|
WORKING = 2,
|
|
[Description("完成")]
|
COMPLETE = 9
|
}
|
#endregion
|
}//endClass
|
}
|
