using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;
using Tiger.Model.Base;

namespace Tiger.Model
{
	/// <summary>
	/// 实体：调拨单(WMS)明细
	/// </summary>
	[Description("Primary:ID")]
	[DisplayName("调拨单(WMS)明细")]
	[Serializable]
	[SugarTable("BIZ_WMS_TRANSFER_DTL")]
	public class BIZ_WMS_TRANSFER_DTL : DbEntityWithAuth, iPrepPickItem
    {
		#region 构造函数
		/// <summary>
		/// 实体：调拨单(WMS)明细
		/// </summary>
		public BIZ_WMS_TRANSFER_DTL() {}
		#endregion

		#region 公共属性
		/// <summary>
		/// 调拨单号
		/// </summary>
		[DisplayName("调拨单号")]
		public string ORDER_NO { get; set; }
		/// <summary>
		/// 调拨单行号
		/// </summary>
		[DisplayName("调拨单行号")]
		public string ORDER_LINE { get; set; }
		/// <summary>
		/// 单据行状态
		/// </summary>
		[DisplayName("单据行状态")]
		public int STATUS { get; set; }
		/// <summary>
		/// 物料编码
		/// </summary>
		[DisplayName("物料编码")]
		public string ITEM_CODE { get; set; }
		/// <summary>
		/// 单位
		/// </summary>
		[DisplayName("单位")]
		public string UNIT { get; set; }
		/// <summary>
		/// 需求数量
		/// </summary>
		[DisplayName("需求数量")]
		public double QTY_REQ { get; set; }
		/// <summary>
		/// 调出数量
		/// </summary>
		[DisplayName("调出数量")]
		public double QTY_OUT { get; set; }
		/// <summary>
		/// 拨入数量
		/// </summary>
		[DisplayName("拨入数量")]
		public double QTY_IN { get; set; }
		/// <summary>
		/// 调出仓库
		/// </summary>
		[DisplayName("调出仓库")]
		public string OUT_WH_CODE { get; set; }
		/// <summary>
		/// 拨入仓库
		/// </summary>
		[DisplayName("拨入仓库")]
		public string IN_WH_CODE { get; set; }
        /// <summary>
		/// 调出储位
		/// </summary>
		[DisplayName("调出储位")]
        public string OUT_LOCATION_CODE { get; set; }
        /// <summary>
        /// 拨入储位
        /// </summary>
        [DisplayName("拨入储位")]
        public string IN_LOCATION_CODE { get; set; }
        /// <summary>
        /// 拨出批号
        /// </summary>
        [DisplayName("拨出批号")]
		public string OUT_LOTNO { get; set; }
		/// <summary>
		/// 拨入批号
		/// </summary>
		[DisplayName("拨入批号")]
		public string IN_LOTNO { get; set; }
		/// <summary>
		/// 来源单据编码，多个用“,”分隔
		/// </summary>
		[DisplayName("来源单据编码，多个用“,”分隔")]
		public string SOURCE_CODE { get; set; }
		/// <summary>
		/// 来源单号，多个用“,”分隔，跟编码一一对应
		/// </summary>
		[DisplayName("来源单号，多个用“,”分隔，跟编码一一对应")]
		public string SOURCE_ORDER { get; set; }
		/// <summary>
		/// 来源单行号，多个用“,”分隔，跟编码一一对应
		/// </summary>
		[DisplayName("来源单行号，多个用“,”分隔，跟编码一一对应")]
		public string SOURCE_LINE { get; set; }
		/// <summary>
		/// ERP单据号码
		/// </summary>
		[DisplayName("ERP单据号码")]
		public string ERP_ORDER { get; set; }
		/// <summary>
		/// 备注
		/// </summary>
		[DisplayName("备注")]
		public string REMARK { get; set; }
		#endregion

		#region 虚拟属性
		/*例子
		[SugarColumn(IsIgnore = true)]
		public string FieldName { get; set; }
		*/
		#endregion

		#region 外键属性
		/*例子
		//一对一外键导航
		[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_WMS_TRANSFER_DTL类里面的外键ID字段
		public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
		//一对多外键导航
		[Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_WMS_TRANSFER_DTLId))]//ClassA表中的BIZ_WMS_TRANSFER_DTLId
		public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
		//多对多外键导航
		[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_WMS_TRANSFER_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 公共方法
        public BIZ_WMS_PREP_SRC_DTL GetPickItem()
        {
            return new BIZ_WMS_PREP_SRC_DTL()
            {
                Source = this,
                AUTH_ORG = AUTH_ORG,
                ITEM_CODE = ITEM_CODE,
                UNIT = UNIT,
                SOURCE_CODE = nameof(BIZ_WMS_TRANSFER),
                SOURCE_ORDER = ORDER_NO,
                SOURCE_LINE = ORDER_LINE,
                QTY_REQ = QTY_REQ,
                QTY_ACT_REQ = QTY_REQ - QTY_OUT,
            };
        }
        #endregion

    }//endClass
}