using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
using WIDESEA_Core.DB.Models;
namespace WIDESEA_Model.Models
{

    /// <summary>
    /// 组盘表（库存）主表
    ///</summary>
    [SugarTable("Dt_BillGroupStock")]
    public class Dt_BillGroupStock:BaseEntity
    {
        /// <summary>
        /// 备  注:库存ID
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "GroupId", IsPrimaryKey = true, IsIdentity = true)]
        public int GroupId { get; set; }

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

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

        /// <summary>
        /// 备  注:1,入库 2,出库
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "OrderType")]
        public int OrderType { get; set; }


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

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

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

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

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

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

        /// <summary>
        /// 备  注:库存状态：1，组盘暂存  2，组盘撤销  3，入库确认  4，已入库  5，已出库
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "State")]
        public int? State { get; set; }

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

      

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

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

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

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

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

        /// <summary>
        /// 库存明细
        /// </summary>
        [SugarColumn(ColumnName = "Dt_BillGroupStockDetailList")]
        [Navigate(NavigateType.OneToMany, nameof(Dt_BillGroupStockDetail.GroupId))]
        public List<Dt_BillGroupStockDetail>? Dt_BillGroupStockDetailList { get; set; }

        /// <summary>
        /// 货位详情
        /// </summary>
        [SugarColumn(IsIgnore = true,ColumnName = "LocationInfo")]
        [Navigate(NavigateType.OneToOne, nameof(LocationCode), nameof(Dt_LocationInfo.LocationCode))]
        public Dt_LocationInfo? LocationInfo { get; set; }
    }
}