using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Core.DB.Models;
|
|
namespace WIDESEA_Model.Models
|
{
|
/// <summary>
|
/// 出库单明细
|
/// </summary>
|
[SugarTable(nameof(Dt_OutboundOrderDetail), "出库单明细")]
|
public class Dt_OutboundOrderDetail : BaseEntity
|
{
|
/// <summary>
|
/// 主键
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
|
public int Id { get; set; }
|
|
/// <summary>
|
/// 出库单主键
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "出库单主键")]
|
public int OrderId { 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 = true, Length = 50, ColumnDescription = "批次号")]
|
public string BatchNo { get; set; }
|
|
/// <summary>
|
/// 行号
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "行号", DefaultValue = "0")]
|
public int RowNo { get; set; }
|
|
/// <summary>
|
/// 单据数量
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "单据数量")]
|
public decimal OrderQuantity { get; set; }
|
|
/// <summary>
|
/// 锁定数量
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "锁定数量", DefaultValue = "0")]
|
public decimal LockQuantity { get; set; }
|
|
/// <summary>
|
/// 已出数量
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "已出数量", DefaultValue = "0")]
|
public decimal OverOutQuantity { get; set; }
|
|
/// <summary>
|
/// 订单明细状态
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "订单明细状态", DefaultValue = "0")]
|
public int OrderDetailStatus { get; set; }
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[SugarColumn(IsNullable = true, ColumnDescription = "单位")]
|
public string Unit { get; set; }
|
|
/// <summary>
|
/// 行号
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "lineNo", ColumnDescription = "行号", DefaultValue= "0")]
|
public string? lineNo { get; set; }
|
|
/// <summary>
|
/// 挪料数量
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "MoveQty", ColumnDescription = "挪料数量",IsNullable = true)]
|
public decimal MoveQty { get; set; }
|
|
/// <summary>
|
/// 供应商编号
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "supplyCode", ColumnDescription = "供应商编号", IsNullable = true)]
|
public string? SupplyCode { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "barcodeQty", ColumnDescription = "数量", DefaultValue = "0", IsNullable = true)]
|
public decimal BarcodeQty { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "barcodeUnit", ColumnDescription = "单位", IsNullable = true )]
|
public string BarcodeUnit { get; set; } = null!;
|
|
|
/// <summary>
|
///
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "barcodemoveQty", ColumnDescription = "数量" , DefaultValue = "0", IsNullable = true)]
|
public decimal BarcodeMoveQty { get; set; }
|
/// <summary>
|
/// 仓库
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "warehouseCode", ColumnDescription = "仓库", IsNullable = true)]
|
public string? WarehouseCode { get; set; }
|
|
/// <summary>
|
/// 回传MES
|
/// </summary>
|
[SugarColumn(IsNullable = true, ColumnDescription = "回传MES")]
|
public int ReturnToMESStatus { get; set; } = 0;
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(IsNullable = true, ColumnDescription = "备注")]
|
public string Remark { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
public decimal NeedOutQuantity => OrderQuantity - MoveQty;
|
|
[SugarColumn(IsNullable = true, ColumnDescription = "")]
|
public decimal PickedQty { get; set; }
|
|
[SugarColumn(IsNullable = true, ColumnDescription = "")]
|
public string documentsNO { get; set; }
|
|
[SugarColumn(IsNullable = true, ColumnDescription = "")]
|
public decimal AllocatedQuantity { get; set; }
|
|
[SugarColumn(IsNullable = true, ColumnDescription = "")]
|
public int BatchAllocateStatus { get; set; }
|
|
/// <summary>
|
/// 虚拟出入库数量
|
/// </summary>
|
[SugarColumn(IsNullable = true, ColumnDescription = "虚拟出入库数量")]
|
public decimal NoStockOutQty { get; set; }
|
|
}
|
}
|
