using SqlSugar;
using WIDESEA_Core.DB.Models;

namespace WIDESEA_Model.Models
{
    /// <summary>
    /// 出库订单库存数据明细表
    ///</summary>
    [SugarTable("Dt_OutOrderAndStock_Hty", "出库订单库存数据明细表")]
    public class Dt_OutOrderAndStock_Hty : BaseEntity
    {
        /// <summary>
        /// 备  注:主键ID
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Id", IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键ID")]
        public int Id { get; set; }

        /// <summary>
        /// 备  注:出库订单头ID（外键）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "OutOrderId", ColumnDescription = "出库订单头ID（外键）")]
        public int OutOrderId { get; set; }

        /// <summary>
        /// 备  注:出库订单明细ID（外键）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "OutOrderDetailId", ColumnDescription = "出库订单明细ID（外键）")]
        public int OutOrderDetailId { get; set; }

        /// <summary>
        /// 备  注:库存头ID（外键）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "GroupId", ColumnDescription = "库存头ID（外键）")]
        public int GroupId { get; set; }

        /// <summary>
        /// 备  注:库存明细ID（外键）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "GroupDetailId", ColumnDescription = "库存明细ID（外键）")]
        public int GroupDetailId { get; set; }

        /// <summary>
        /// 备  注:货位编号（外键）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "LocationCode", ColumnDescription = "货位编号（外键）")]
        public string LocationCode { get; set; } = null!;

        /// <summary>
        /// 备  注:订单编号
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "OrderNumber", ColumnDescription = "订单编号")]
        public string OrderNumber { get; set; } = null!;

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

        /// <summary>
        /// 备  注:出库数量
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "OutboundQuantity", ColumnDescription = "出库数量")]
        public decimal OutboundQuantity { get; set; }

        /// <summary>
        /// 备  注:分配数量
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "AllocatedQuantity", ColumnDescription = "分配数量")]
        public decimal AllocatedQuantity { get; set; }

        /// <summary>
        /// 备  注:完成数量
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "CompletedQuantity", ColumnDescription = "完成数量")]
        public decimal CompletedQuantity { get; set; }

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

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

        /// <summary>
        /// 备  注:物料名称
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "MaterialName", ColumnDescription = "物料名称")]
        public string MaterialName { get; set; } = null!;

        /// <summary>
        /// 备  注:库存状态
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "State", ColumnDescription = "库存状态")]
        public string State { get; set; } = null!;

        /// <summary>
        /// 备  注:库存数量
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "palletQuantity", ColumnDescription = "库存数量")]
        public decimal PalletQuantity { 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; }

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

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

        /// <summary>
        /// 订单头明细数据
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(OutOrderId), nameof(Dt_OutOrder_Hty.Id))]
        public Dt_OutOrder_Hty? OrderList { get; set; }

        /// <summary>
        /// 订单体明细数据
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(OutOrderDetailId), nameof(Dt_OutOrderDetail_Hty.Id))]
        public Dt_OutOrderDetail_Hty? OrderDetailList { get; set; }
    }
}