using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Core.Attributes;
|
using WIDESEA_Core.DB.Models;
|
|
namespace WIDESEA_Model.Models
|
{
|
/// <summary>
|
/// 出库详情
|
/// </summary>
|
[SugarTable(nameof(Dt_OutStockLockInfo), "出库详情")]
|
public class Dt_OutStockLockInfo : BaseEntity
|
{
|
/// <summary>
|
/// 主键
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
|
public int Id { get; set; }
|
|
/// <summary>
|
/// 单据编号
|
/// </summary>
|
[SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "单据编号")]
|
public string OrderNo { get; set; }
|
|
/// <summary>
|
/// 单据明细主键
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "单据明细主键")]
|
public int OrderDetailId { get; set; }
|
|
/// <summary>
|
/// 单据类型
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "单据类型")]
|
public int OrderType { get; set; }
|
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
[SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "批次号")]
|
public string BatchNo { get; set; }
|
|
/// <summary>
|
/// 物料编号
|
/// </summary>
|
[SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "物料编号")]
|
public string MaterielCode { get; set; }
|
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
[SugarColumn(IsNullable = true, Length = 200, ColumnDescription = "物料名称")]
|
public string MaterielName { get; set; }
|
|
/// <summary>
|
/// 库存主键
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "库存主键")]
|
public int StockId { get; set; }
|
|
/// <summary>
|
/// 单据数量
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "单据数量")]
|
public decimal OrderQuantity { get; set; }
|
|
/// <summary>
|
/// 原始库存量
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "原始库存量")]
|
public decimal OriginalQuantity { get; set; }
|
|
/// <summary>
|
/// 分配出库量
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "分配出库量")]
|
public decimal AssignQuantity { get; set; }
|
|
/// <summary>
|
/// 已拣选数量
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "已拣选数量")]
|
public decimal PickedQty { get; set; } //
|
/// <summary>
|
/// 货位编号
|
/// </summary>
|
[SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "货位编号")]
|
public string LocationCode { get; set; }
|
|
/// <summary>
|
/// 托盘编号
|
/// </summary>
|
[SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "托盘编号")]
|
public string PalletCode { get; set; }
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[SugarColumn(IsNullable = true, ColumnDescription = "单位")]
|
public string Unit { get; set; }
|
/// <summary>
|
/// 任务号
|
/// </summary>
|
[SugarColumn(IsNullable = true, ColumnDescription = "任务号")]
|
public int? TaskNum { get; set; }
|
|
public string SupplyCode { get; set; }
|
|
[SugarColumn(ColumnName = "lineNo", ColumnDescription = "行号")]
|
public string lineNo { get; set; }
|
|
public string WarehouseCode { get; set; }
|
/// <summary>
|
/// 状态 状态：0-已分配 1-出库中 2-部分拣选 3已拣选
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "状态")]
|
public int Status { get; set; }
|
|
[SugarColumn(Length = 100, ColumnDescription = "当前条码")]
|
public string CurrentBarcode { get; set; } // 当前条码（拆包后可能变化）
|
|
[SugarColumn(IsNullable = false, ColumnDescription = "原始锁定数量")]
|
public decimal OriginalLockQuantity { get; set; } // 原始锁定数量
|
public int IsSplitted { get; set; } // 是否已拆包 0-否 1-是
|
|
[SugarColumn( ColumnDescription = "拆包父锁定Id")]
|
public int? ParentLockId { get; set; }
|
|
[SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "操作者")]
|
public string Operator { get; set; }
|
|
[SugarColumn( ColumnDescription = "物料条码数量")]
|
public decimal BarcodeQty { get; set; }
|
[SugarColumn(ColumnDescription = "物料单位")]
|
public string BarcodeUnit { get; set; }
|
|
[SugarColumn(ColumnDescription = "分批出库批次号")]
|
public string OutboundBatchNo { get; set; }
|
|
[Navigate(NavigateType.OneToOne, nameof(StockInfo))]//一对一 SchoolId是StudentA类里面的
|
public Dt_StockInfo StockInfo { get; set; } //不能赋值只能是null
|
|
[SugarColumn(ColumnDescription = "是否分配")]
|
public int IsUnallocated { get; set; } = 0;
|
|
[SugarColumn(ColumnDescription = "厂区")]
|
public string FactoryArea { get; set; }
|
|
/// <summary>
|
/// 剩余数量
|
/// </summary>
|
[SqlSugar.SugarColumn(IsIgnore = true)]
|
|
public decimal RemainQuantity => AssignQuantity - PickedQty;
|
|
public int ReturnToMESStatus { get; set; }
|
|
}
|
}
|
