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, IsIdentity = true)]
    public int GroupId { get; set; }

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

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

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

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

    /// <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 = "CreateID")]
    public int? CreateID { get; set; }

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

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

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

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

    /// <summary>
    /// 备  注:
    /// 默认值:
    ///</summary>
    [SugarColumn(ColumnName = "Modifier")]
    public string? Modifier { 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(IsIgnore = true)]
    [Navigate(NavigateType.OneToOne, nameof(LocationCode), nameof(Dt_LocationInfo.LocationID))]
    public Dt_LocationInfo? LocationInfo { get; set; }

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

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

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

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