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
}