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

namespace Tiger.Model
{
	/// <summary>
	/// 实体：完工入库批次表
	/// </summary>
	[Description("Primary:ID")]
	[DisplayName("完工入库批次表")]
	[Serializable]
	[SugarTable("BIZ_ERP_PROD_IN_BTH")]
	public class BIZ_ERP_PROD_IN_BTH : DbEntityWithAuth
	{
		#region 构造函数
		/// <summary>
		/// 实体：完工入库批次表
		/// </summary>
		public BIZ_ERP_PROD_IN_BTH() {}
		#endregion

		#region 公共属性
		/// <summary>
		/// 入库单号
		/// </summary>
		[DisplayName("入库单号")]
		public string ORDER_NO { get; set; }
        /// <summary>
        /// 入库批次号
        /// </summary>
        [DisplayName("入库批次号")]
		public string BATCH_NO { get; set; }
		/// <summary>
		/// 工单号
		/// </summary>
		[DisplayName("工单号")]
		public string WORK_ORDER { get; set; }
		/// <summary>
		/// 物料编码
		/// </summary>
		[DisplayName("物料编码")]
		public string ITEM_CODE { get; set; }
		/// <summary>
		/// 物料名称
		/// </summary>
		[DisplayName("物料名称")]
		public string ITEM_NAME { get; set; }
        /// <summary>
        /// SAP料号
        /// </summary>
        [DisplayName("SAP料号")]
        public string SapCode { get; set; }
        /// <summary>
        /// 销售订单
        /// </summary>
        [DisplayName("销售订单")]
        public string SALES_ORDER { get; set; }
        /// <summary>
        /// 已扫描数量
        /// </summary>
        [DisplayName("已扫描数量")]
		public double SCAN_QTY { get; set; }
		/// <summary>
		/// 是否扫描完成(Y/N)
		/// </summary>
		[DisplayName("是否扫描完成(Y/N)")]
		public string IS_SCANED { get; set; }
		/// <summary>
		/// 扫描完成时间
		/// </summary>
		[DisplayName("扫描完成时间")]
		public DateTime SCANED_DATE { get; set; } = DateTime.MinValue;
		/// <summary>
		/// 是否仓库点收(Y/N)
		/// </summary>
		[DisplayName("是否仓库点收(Y/N)")]
		public string IS_RECEIVED { get; set; }
		/// <summary>
		/// 仓库点收时间
		/// </summary>
		[DisplayName("仓库点收时间")]
		public DateTime RECEIVED_DATE { get; set; } = DateTime.MinValue;
		/// <summary>
		/// 是否上架完成(Y/N)
		/// </summary>
		[DisplayName("是否上架完成(Y/N)")]
		public string IS_IN_STORE { get; set; }
		/// <summary>
		/// 上架完成时间
		/// </summary>
		[DisplayName("上架完成时间")]
		public DateTime IN_STORE_DATE { get; set; } = DateTime.MinValue;
		/// <summary>
		/// 是否已同步ERP(Y/N)
		/// </summary>
		[DisplayName("是否已同步ERP(Y/N)")]
		public string IS_HANDLED { get; set; }
		/// <summary>
		/// 同步ERP时间
		/// </summary>
		[DisplayName("同步ERP时间")]
		public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue;
		/// <summary>
		/// 备注
		/// </summary>
		[DisplayName("备注")]
		public string REMARK { get; set; }
        #endregion

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

        [SugarColumn(IsIgnore = true)]
        public int CartonQty { get; set; }
        #endregion

        #region 外键属性
        /*例子
		//一对一外键导航
		[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_PROD_IN_BTH类里面的外键ID字段
		public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
		//一对多外键导航
		[Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_PROD_IN_BTHId))]//ClassA表中的BIZ_ERP_PROD_IN_BTHId
		public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
		//多对多外键导航
		[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_PROD_IN_BTHId), nameof(MappingClass.ClassAId))]//注意顺序
		public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
		*/
        [Navigate(NavigateType.OneToMany, nameof(BIZ_ERP_PROD_IN_SN.SOURCECODE), nameof(WORK_ORDER), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_MES_WO类里面的外键ID字段
        public List<BIZ_ERP_PROD_IN_SN> ProdInSns { get; set; }
        #endregion

        #region 枚举变量
        /*例子
		public enum FieldNames
		{
			[Description("枚举描述0")]
			Enum0,
			[Description("枚举描述1")]
			Enum1,
		}
		*/
        #endregion

        #region 公共方法

        #endregion

    }//endClass

	public class ProdInBatch
    {
        /// <summary>
		/// 入库单号
		/// </summary>
		[DisplayName("入库单号")]
        public string ORDER_NO { get; set; }
        public string SALES_ORDER { get; set; }
        public string STATUS { get; set; }
        /// <summary>
        /// 工单批次号
        /// </summary>
        [DisplayName("工单批次号")]
        public string BATCH_NO { get; set; }
        /// <summary>
        /// 工单号
        /// </summary>
        [DisplayName("工单号")]
        public string WORK_ORDER { get; set; }
        /// <summary>
        /// 物料编码
        /// </summary>
        [DisplayName("物料编码")]
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        [DisplayName("物料名称")]
        public string ITEM_NAME { get; set; }
        public string SapCode { get; set; }
        /// <summary>
        /// 计划数量
        /// </summary>
        [DisplayName("计划数量")]
        public double PLAN_QTY { get; set; }
        /// <summary>
        /// 已扫描数量
        /// </summary>
        [DisplayName("已扫描数量")]
        public double SCAN_QTY { get; set; }
    }

	public class InStoreScanInfo
    {
        /// <summary>
        /// 条码
        /// </summary>
        [DisplayName("条码")]
        public string SN { get; set; }
        public string SALES_ORDER { get; set; }
        [DisplayName("批次号")]
        public string BATCH_NO { get; set; }
        /// <summary>
        /// 工单号
        /// </summary>
        [DisplayName("工单号")]
        public string WORK_ORDER { get; set; }
        /// <summary>
        /// 已扫描数量
        /// </summary>
        [DisplayName("已扫描数量")]
        public double SCAN_QTY { get; set; }
    }

	public class InStoreInfo { 
		public BIZ_ERP_PROD_IN_BTH ErpProdInBth { get; set; }
        //public ProdInBatch ProdInBatch { get; set; }
        public InStoreScanInfo InStoreScanInfo { get; set; }
    }

    public class InStoreInfos
    {
        public List<BIZ_ERP_PROD_IN_BTH> ErpProdInBths { get; set; }
        public List<InStoreScanInfo> InStoreScanInfos { get; set; }
    }
}