using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
	/// <summary>
	/// 实体：盘点物品明细
	/// </summary>
	[Description("Primary:ID")]
	[Serializable]
	[SugarTable("V_WMS_COUNT_MDTL")]
	public class V_WMS_COUNT_MDTL : DbEntityWithAuth
	{
		#region 构造函数
		/// <summary>
		/// 实体：盘点物品明细
		/// </summary>
		public V_WMS_COUNT_MDTL() {}
		#endregion

		#region 公共属性
		/// <summary>
		/// 盘点单号
		/// </summary>
		public string COUNT_NO { get; set; }
		/// <summary>
		/// 条码
		/// </summary>
		public string SN { get; set; }
		/// <summary>
		/// 条码类型(规则编码)
		/// </summary>
		public string SN_TYPE { get; set; }
		/// <summary>
		/// 盘点状态(0WaitCount待盘点|1Counted已盘点)
		/// </summary>
		public int STATUS { get; set; }
		/// <summary>
		/// 盘点结果(0NotFound未核实|1Founded已核实|2NewFound新找到)
		/// </summary>
		public int RESULT { get; set; }
		/// <summary>
		/// 物料编码
		/// </summary>
		public string ITEM_CODE { get; set; }
		/// <summary>
		/// 单位
		/// </summary>
		public string UNIT { get; set; }
		/// <summary>
		/// WMS数量
		/// </summary>
		public double QTY { get; set; }
		/// <summary>
		/// 实际数量
		/// </summary>
		public double ACT_QTY { get; set; }
		/// <summary>
		/// 生产日期
		/// </summary>
		public DateTime PROD_DATE { get; set; } = DateTime.MinValue;
		/// <summary>
		/// 首次入库日期
		/// </summary>
		public DateTime FIRST_IN_DATE { get; set; } = DateTime.MinValue;
		/// <summary>
		/// 供应商代码
		/// </summary>
		public string SUPP_CODE { get; set; }
		/// <summary>
		/// 供应商批次号
		/// </summary>
		public string SUPP_LOTNO { get; set; }
        /// <summary>
        /// 仓库ID
        /// </summary>
        public string WH_ID { get; set; }
        /// <summary>
        /// 储区ID
        /// </summary>
        public string REGION_ID { get; set; }
        /// <summary>
        /// 储位ID
        /// </summary>
        public string LOCATION_ID { get; set; }
        /// <summary>
        /// 货架/料车ID
        /// </summary>
        public string SHELF_ID { get; set; }
        /// <summary>
        /// 储位CODE
        /// </summary>
        public string LOCATION_CODE { get; set; }
        /// <summary>
        /// ERP库位代码
        /// </summary>
        public string ERP_WH { get; set; }
        /// <summary>
        /// 处理方式(0NoAdjust无需处理|1InWarehouse入库上架|2ExWarehouse丢失下架)
        /// </summary>
        public int ACTION { get; set; }
        /// <summary>
        /// 审核人
        /// </summary>
        public string REVIEWER { get; set; }
        /// <summary>
        /// 审核日期
        /// </summary>
        public DateTime REVIEW_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// 备注
        /// </summary>
        public string REMARK { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        public string ITEM_NAME { get; set; }
        /// <summary>
        /// 未盘点数量
        /// </summary>
        public double NOT_QTY { get; set; }
        #endregion

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

        #region 外键属性
        /*例子
		//一对一外键导航
		[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_COUNT_MDTL类里面的外键ID字段
		public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
		//一对多外键导航
		[Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_COUNT_MDTLId))]//ClassA表中的WMS_COUNT_MDTLId
		public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
		//多对多外键导航
		[Navigate(typeof(MappingClass), nameof(MappingClass.WMS_COUNT_MDTLId), nameof(MappingClass.ClassAId))]//注意顺序
		public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
		*/
        [Navigate(NavigateType.OneToOne, nameof(WH_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
        public WMS_WAREHOUSE Warehouse { get; set; } //注意禁止手动赋值，只能是null
        [Navigate(NavigateType.OneToOne, nameof(REGION_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
        public WMS_REGION Region { get; set; } //注意禁止手动赋值，只能是null
        [Navigate(NavigateType.OneToOne, nameof(SHELF_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
        public WMS_SHELF Shelf { get; set; } //注意禁止手动赋值，只能是null
        [Navigate(NavigateType.OneToOne, nameof(LOCATION_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
        public WMS_LOCATION Location { get; set; } //注意禁止手动赋值，只能是null
        #endregion

        #region 枚举变量
        /*例子
		public enum FieldNames
		{
			[Description("枚举描述0")]
			Enum0,
			[Description("枚举描述1")]
			Enum1,
		}
		*/
        /// <summary>
        /// 盘点状态(0WaitCount待盘点|1Counted已盘点)a
        /// </summary>
        public enum STATUSs
        {
            [Description("待盘点")]
            WaitCount,
            [Description("已盘点")]
            Counted,
        }
        /// <summary>
        /// 盘点结果(0NoResult无结果|1Balance平帐|2Profit盘盈|3Losses盘亏)
        /// </summary>
        public enum RESULTs
        {
            [Description("无结果")]
            NoResult,
            [Description("平帐")]
            Balance,
            [Description("盘盈")]
            Profit,
            [Description("盘亏")]
            Losses,
        }
        /// <summary>
        /// 处理方式(0NoAdjust无需处理|1InWarehouse入库上架|2ExWarehouse丢失下架)
        /// </summary>
        public enum ACTIONs
        {
            [Description("无需处理")]
            NoAdjust,
            [Description("入库上架")]
            InWarehouse,
            [Description("丢失下架")]
            ExWarehouse,
        }
        #endregion

        #region 公共方法

        #endregion

    }//endClass
}