using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;
using Tiger.Model.Minsun;
using Tiger.Model.Extensions;
using Microsoft.SqlServer.Server;

namespace Tiger.Model
{
    /// <summary>
    /// 实体：库存信息
    /// </summary>
    [Description("Primary:ID")]
    [Serializable]
    [SugarTable("WMS_ITEM")]
    public class WMS_ITEM : DbEntityWithAuth
    {
        #region 构造函数

        /// <summary>
        /// 实体：库存信息
        /// </summary>
        public WMS_ITEM()
        { }

        #endregion 构造函数

        #region 公共属性

        /// <summary>
        /// 条码
        /// </summary>
        public string SN { get; set; }

        /// <summary>
        /// 物料编码
        /// </summary>
        public string ITEM_CODE { get; set; }

        /// <summary>
        /// 条码类型(规则编码)
        /// </summary>
        public string SN_TYPE { get; set; }

        /// <summary>
        /// 储存状态(0NotExists不存在|10Incoming送货中|20WaitTest待检验|21Rejected需退货|30WaitIn待入库|40InStore在库|50OffShelf已下架|60Sended已发料|65Received被接收|70Loaded已上料|80UseUp已耗尽|90Returned已退料|100Shipped已出货)
        /// </summary>
        public int STATUS { get; set; }

        /// <summary>
        /// 数量
        /// </summary>
        public double QTY { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        public string UNIT { 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 TRANS_CODE { get; set; }

        /// <summary>
        /// 业务单据号码
        /// </summary>
        public string TRANS_NO { get; set; }

        /// <summary>
        /// 业务单据行号
        /// </summary>
        public string TRANS_LINE { get; set; }

        /// <summary>
        /// 来源单据编码
        /// </summary>
        public string SOURCE_CODE { get; set; }

        /// <summary>
        /// 来源单据号码
        /// </summary>
        public string SOURCE_ORDER { get; set; }

        /// <summary>
        /// 来源单据行号
        /// </summary>
        public string SOURCE_LINE { get; set; }

        /// <summary>
        /// 供应商代码
        /// </summary>
        public string SUPP_CODE { get; set; }

        /// <summary>
        /// 供应商批次号
        /// </summary>
        public string SUPP_LOTNO { get; set; }

        /// <summary>
        /// 批次号
        /// </summary>
        public string LOTNO { get; set; }

        /// <summary>
        /// 箱号
        /// </summary>
        public string CARTON_NO { get; set; }

        /// <summary>
        /// 栈板号
        /// </summary>
        public string PALLET_NO { get; set; }

        /// <summary>
        /// 仓库代码
        /// </summary>
        public string WH_ID { get; set; }

        /// <summary>
        /// 储区代码
        /// </summary>
        public string REGION_ID { get; set; }

        /// <summary>
        /// 货架/料车编码
        /// </summary>
        public string SHELF_ID { get; set; }

        /// <summary>
        /// 储位代码
        /// </summary>
        public string LOCATION_ID { get; set; }

        /// <summary>
        /// ERP库位代码
        /// </summary>
        public string ERP_WH { get; set; }

        /// <summary>
        /// 机型
        /// </summary>
        public string ITEM_MODEL { get; set; }

        /// <summary>
        /// 是否被单据锁定(Y/N)
        /// </summary>
        public string IS_LOCKED { get; set; } = "N";

        /// <summary>
        /// 备注
        /// </summary>
        public string REMARK { get; set; }

        /// <summary>
        /// 是否允许超期
        /// </summary>
        public string IsAllowOverdue { get; set; }

        /// <summary>
        /// 延期时间
        /// </summary>
        //public double PostponeDays { get; set; }

        #endregion 公共属性

        #region 虚拟属性

        /*例子
		[SugarColumn(IsIgnore = true)]
		public string FieldName { get; set; }
		*/

        #endregion 虚拟属性

        #region 外键属性

        /*例子
		//一对一外键导航
		[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_ITEM类里面的外键ID字段
		public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
		//一对多外键导航
		[Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_ITEMId))]//ClassA表中的WMS_ITEMId
		public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
		//多对多外键导航
		[Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEMId), nameof(MappingClass.ClassAId))]//注意顺序
		public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
		*/

        #endregion 外键属性

        #region 枚举变量

        /// <summary>
        /// 储存状态(0NotExists不存在|10Incoming送货中|20WaitTest待检验|21Rejected需退货|30WaitIn待入库|40InStore在库|50OffShelf已下架|60Sended已发料|65Received被接收|70Loaded已上料|80UseUp已耗尽|90Returned已退料|100Shipped已出货)
        /// </summary>
        public enum STATUSs
        {
            [Description("不存在")]
            NotExists = 0,

            [Description("送货中")]
            Incoming = 10,

            [Description("已清点")]
            Counted = 15,

            [Description("待检验")]
            WaitTest = 20,

            [Description("需退货")]
            Rejected = 22,

            [Description("待入库")]
            WaitIn = 30,

            [Description("在库中")]
            InStore = 40,

            [Description("已下架")]
            OffShelf = 50,

            [Description("已发料")]
            Sended = 60,

            [Description("被接收")]
            Received = 65,

            [Description("已上料")]
            Loaded = 70,

            [Description("已耗尽")]
            UseUp = 80,

            [Description("已退料")]
            Returned = 90,

            [Description("已出货")]
            Shipped = 100,

            [Description("已重工")]
            Rework = 110,
        }

        #endregion 枚举变量
    }//endClass

    /// <summary>
    /// 上架执行信息
    /// </summary>
    public class PutOnInfo
    {
        public WMS_WAREHOUSE Warehouse { get; set; }
        public WMS_REGION Region { get; set; }
        public WMS_SHELF Shelf { get; set; }
        public WMS_LOCATION Location { get; set; }
        public List<WMS_ITEM_PKG> Packages { get; set; } = new List<WMS_ITEM_PKG>();
        public List<WMS_ITEM> Items { get; set; } = new List<WMS_ITEM>();
        public List<WMS_ITEM_HIS> History { get; set; } = new List<WMS_ITEM_HIS>();
        public List<WMS_ITEM_EXT> ItemsExt { get; set; } = new List<WMS_ITEM_EXT>();
    }

    /// <summary>
    /// 下架执行信息
    /// </summary>
    public class TakeDownInfo
    {
        public List<WMS_ITEM_PKG> Packages { get; set; } = new List<WMS_ITEM_PKG>();
        public List<WMS_ITEM> Items { get; set; } = new List<WMS_ITEM>();
        public List<WMS_ITEM_HIS> History { get; set; } = new List<WMS_ITEM_HIS>();
    }

    /// <summary>
    /// 下架推荐策略实体
    /// </summary>
    public class SuggestStrategy
    {
        public bool isFIFO { get; set; } = true;
        public WMS_WAREHOUSE Warehouse { get; set; }
        public WMS_REGION Region { get; set; }
        public WMS_SHELF Shelf { get; set; }
        public WMS_LOCATION Location { get; set; }
        public List<WMS_ITEM_PKG> Packages { get; set; } = new List<WMS_ITEM_PKG>();
        public List<WMS_ITEM> Items { get; set; } = new List<WMS_ITEM>();
        public List<WMS_ITEM_HIS> History { get; set; } = new List<WMS_ITEM_HIS>();
    }

    /// <summary>
    /// 下架推荐策略实体
    /// </summary>
    public class SuggestItem
    {
        public WMS_ITEM Item { get; set; }
        public WMS_ITEM_POOL poolItem { get; set; }
        public WMS_WAREHOUSE Warehouse { get; set; }
        public WMS_REGION Region { get; set; }
        public WMS_SHELF Shelf { get; set; }
        public WMS_LOCATION Location { get; set; }
    }

    public class QueryItemInputDtl : BasePageInput
    {
        public bool? IsK { get; set; }
    }

    public class QueryItemInput : BaseInput
    {
        public bool? IsK { get; set; }
    }

    public class QueryItemView
    {
        public string ItemCode { get; set; }
        public string ItemName { get; set; }
        public string SumInfo { get; set; }
    }
}