using SqlSugar;
using WIDESEA_Core.DB.Models;

namespace WIDESEA_Model.Models
{
    /// <summary>
    /// 库存组盘头表
    ///</summary>
    [SugarTable("Dt_BillGroupStock_Hty", "库存组盘头表")]
    public class Dt_BillGroupStock_Hty : BaseEntity
    {
        /// <summary>
        /// 备  注:主键ID
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "GroupId", IsPrimaryKey = true, ColumnDescription = "主键ID", IsIdentity = true)]
        public int GroupId { get; set; }

        /// <summary>
        /// 备  注:托盘条码
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "PalletCode", ColumnDescription = "托盘条码")]
        public string? PalletCode { get; set; }

        /// <summary>
        /// 备  注:单据编号（关联inbound_order）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "InboundNo", ColumnDescription = "单据编号（关联inbound_order）")]
        public string? InboundNo { get; set; }

        /// <summary>
        /// 备  注:物料编号
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "MaterialNo", ColumnDescription = "物料编号")]
        public string? MaterialNo { get; set; }

        /// <summary>
        /// 备  注:批次号
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "BatchNo", ColumnDescription = "批次号")]
        public string? BatchNo { get; set; }

        /// <summary>
        /// 备  注:组盘类型  1,一次组盘  2,二次组盘(上架前，空托组过盘)
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "GroupType", ColumnDescription = "组盘类型  1,一次组盘  2,二次组盘(上架前，空托组过盘)")]
        public string? GroupType { get; set; }

        /// <summary>
        /// 备  注:组盘方式（1,内码 2,外码 3，内外码  4,空托盘）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "GroupWay", ColumnDescription = "组盘方式（1,内码 2,外码 3，内外码  4,空托盘）")]
        public string? GroupWay { get; set; }

        /// <summary>
        /// 备  注:组盘次数
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Times", ColumnDescription = "组盘次数")]
        public int? Times { get; set; }

        /// <summary>
        /// 备  注:是否满盘（如果已满盘不可二次组盘，人工确定是否满盘）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "IsFull", ColumnDescription = "是否满盘（如果已满盘不可二次组盘，人工确定是否满盘）")]
        public bool? IsFull { get; set; }

        /// <summary>
        /// 备  注:库位
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "LocationCode", ColumnDescription = "库位")]
        public string? LocationCode { get; set; }

        /// <summary>
        /// 备  注:库存状态：1，组盘暂存  2，存储库存
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "State", ColumnDescription = "库存状态：1，组盘暂存  2，存储库存")]
        public string? State { get; set; }

        /// <summary>
        /// 备  注:备注
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Remark", ColumnDescription = "备注")]
        public string? Remark { get; set; }

        /// <summary>
        /// 备  注: 预留1
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Spare1", ColumnDescription = "预留1", IsNullable = true)]
        public string? Spare1 { get; set; }

        /// <summary>
        /// 备  注:预留2
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Spare2", ColumnDescription = "预留2", IsNullable = true)]
        public string? Spare2 { get; set; }

        /// <summary>
        /// 备  注:预留3
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Spare3", ColumnDescription = "预留3", IsNullable = true)]
        public string? Spare3 { get; set; }

        /// <summary>
        /// 备  注:预留4
        /// 默认值:
        ///</summary>
        [SugarColumn(IsNullable = true, ColumnName = "Spare4", ColumnDescription = "预留4")]
        public string? Spare4 { get; set; }

        /// <summary>
        /// 备  注:预留5
        /// 默认值:
        ///</summary>
        [SugarColumn(IsNullable = true, ColumnName = "Spare5", ColumnDescription = "预留5")]
        public string? Spare5 { get; set; }

        /// <summary>
        /// 货位明细数据
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(LocationCode), nameof(Dt_LocationInfo.LocationID))]
        public Dt_LocationInfo? LocationInfo { get; set; }

        /// <summary>
        /// 库存明细数据
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(GroupId), nameof(Dt_BillGroupStockDetail.GroupId))]
        public Dt_BillGroupStockDetail? StockDetailList { get; set; }

        /// <summary>
        /// 备  注: 完成时间
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "FinishTime", ColumnDescription = "完成时间")]
        public DateTime FinishTime { get; set; }

        /// <summary>
        /// 备  注: 操作类型
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "OperateType", ColumnDescription = "操作类型")]
        public string OperateType { get; set; } = null!;

        /// <summary>
        /// 备  注: 源单ID
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "SourceId", ColumnDescription = "源单ID")]
        public int SourceId { get; set; }
    }
}