using SqlSugar;
|
using WIDESEA_Core.DB.Models;
|
|
namespace WIDESEA_Model.Models;
|
|
/// <summary>
|
/// 出库订单库存数据明细表
|
///</summary>
|
[SugarTable("Dt_OutOrderAndStock", "出库订单库存数据明细表")]
|
public class Dt_OutOrderAndStock : 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（外键）", IsNullable = false)]
|
public int OutOrderId { get; set; }
|
|
/// <summary>
|
/// 备 注:库存头ID（外键）
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "GroupId", ColumnDescription = "库存头ID（外键）", IsNullable = false)]
|
public int GroupId { get; set; }
|
|
/// <summary>
|
/// 备 注:货位编号（外键）
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "LocationCode", ColumnDescription = "货位编号（外键）", IsNullable = false)]
|
public string LocationCode { get; set; } = null!;
|
|
/// <summary>
|
/// 备 注:订单编号
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "OrderNumber", ColumnDescription = "订单编号", IsNullable = false)]
|
public string OrderNumber { get; set; } = null!;
|
|
/// <summary>
|
/// 备 注:批次号
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "BatchNumber", ColumnDescription = "批次号", IsNullable = false)]
|
public string BatchNumber { get; set; } = null!;
|
|
/// <summary>
|
/// 备 注:出库数量
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "OutboundQuantity", ColumnDescription = "出库数量", IsNullable = false)]
|
public decimal OutboundQuantity { get; set; }
|
|
/// <summary>
|
/// 备 注:分配数量
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "AllocatedQuantity", ColumnDescription = "分配数量", IsNullable = false)]
|
public decimal AllocatedQuantity { get; set; }
|
|
/// <summary>
|
/// 备 注:完成数量
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "CompletedQuantity", ColumnDescription = "完成数量", IsNullable = false)]
|
public decimal CompletedQuantity { get; set; }
|
|
/// <summary>
|
/// 备 注:托盘号
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "PalletCode", ColumnDescription = "托盘号", IsNullable = false)]
|
public string PalletCode { get; set; } = null!;
|
|
/// <summary>
|
/// 备 注:物料编号
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "MaterialNo", ColumnDescription = "物料编号", IsNullable = false)]
|
public string MaterialNo { get; set; } = null!;
|
|
/// <summary>
|
/// 备 注:物料名称
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "MaterialName", ColumnDescription = "物料名称", IsNullable = false)]
|
public string MaterialName { get; set; } = null!;
|
|
/// <summary>
|
/// 备 注:库存状态
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "State", ColumnDescription = "库存状态", IsNullable = false)]
|
public int? State { get; set; }
|
|
/// <summary>
|
/// 备 注:库存数量
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "palletQuantity", ColumnDescription = "库存数量", IsNullable = false)]
|
public decimal? PalletQuantity { get; set; }
|
|
///// <summary>
|
///// 货位明细数据
|
///// </summary>
|
//[SugarColumn(IsIgnore = true)]
|
//[Navigate(NavigateType.OneToOne, nameof(LocationCode), nameof(Dt_LocationInfo.LocationID))]
|
//public Dt_LocationInfo? LocationList { get; set; }
|
|
///// <summary>
|
///// 库存头明细数据
|
///// </summary>
|
//[SugarColumn(IsIgnore = true)]
|
//[Navigate(NavigateType.OneToOne, nameof(GroupId), nameof(Dt_BillGroupStock.GroupId))]
|
//public Dt_BillGroupStock? StockList { get; set; }
|
|
/// <summary>
|
/// 订单头明细数据
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToOne, nameof(OutOrderId), nameof(Dt_OutOrder.Id))]
|
public Dt_OutOrder? OrderList { get; set; }
|
}
|
