using Admin.NET.Core;
|
using System.Security.AccessControl;
|
namespace Admin.NET.Application.Entity;
|
|
/// <summary>
|
///所有状态库存信息-实时库存报表用
|
///总库存、锁定库存、库位、库区、物料、跟踪码等【add by liuwq, 2024/06/11】
|
/// </summary>
|
[MySugarTableViewAttribute("v_wms_stock_quan", "所有状态库存信息")]
|
public class v_wms_stock_quan : EntityBase
|
{
|
#region 是否可用库存
|
|
/// <summary>
|
/// 不可用原因
|
/// </summary>
|
|
public string? DisabledReason { get; set; }
|
/// <summary>
|
/// 可用/不可用
|
/// </summary>
|
|
public string? UsableFlagStr { get; set; }
|
|
/// <summary>
|
/// 可用/不可用标记
|
/// </summary>
|
|
public UsableFlagEnum UsableFlag { get; set; }
|
|
|
#endregion
|
|
|
#region 锁定
|
|
/// <summary>
|
/// 锁定状态
|
/// </summary>
|
[SugarColumn(ColumnName = "LockStatus", ColumnDescription = "锁定状态")]
|
public LockStatusEnum LockStatus { get; set; }
|
|
|
/// <summary>
|
/// 锁定原因
|
/// </summary>
|
[SugarColumn(ColumnName = "LockReason", ColumnDescription = "锁定原因", Length = 255)]
|
|
public string? LockReason { get; set; }
|
|
|
/// <summary>
|
/// 锁定人
|
/// </summary>
|
[SugarColumn(ColumnName = "LockUser", ColumnDescription = "锁定人", Length = 50)]
|
|
public string? LockUser { get; set; }
|
|
|
/// <summary>
|
/// 锁定时间
|
/// </summary>
|
|
[SugarColumn(ColumnName = "LockTime", ColumnDescription = "锁定时间")]
|
public DateTime? LockTime { get; set; }
|
|
#endregion
|
|
#region 操作有关
|
|
|
/// <summary>
|
/// 操作原因
|
/// </summary>
|
|
public string? OperReason { get; set; }
|
|
|
/// <summary>
|
/// 操作人
|
/// </summary>
|
|
public string? OperUser { get; set; }
|
|
|
/// <summary>
|
/// 操作时间
|
/// </summary>
|
public DateTime? OperTime { get; set; }
|
#endregion
|
|
/// <summary>
|
/// 关联单号
|
/// </summary>
|
|
public string? RelationNo { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[Required]
|
[SugarColumn(ColumnName = "MaterialCode", ColumnDescription = "物料编码", Length = 50)]
|
|
public string MaterialCode { get; set; }
|
|
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
[SugarColumn(ColumnName = "MaterialName", ColumnDescription = "物料名称", Length = 50)]
|
|
public string? MaterialName { get; set; }
|
|
|
/// <summary>
|
/// 库存数量
|
/// </summary>
|
[Required]
|
[SugarColumn(ColumnName = "Quantity", ColumnDescription = "库存数量", Length = 10, DecimalDigits = 3)]
|
public decimal Quantity { get; set; }
|
|
|
/// <summary>
|
/// 库存锁定数量
|
/// </summary>
|
[Required]
|
[SugarColumn(ColumnName = "LockedQty", ColumnDescription = "库存锁定数量", Length = 10, DecimalDigits = 3)]
|
public decimal LockedQty { get; set; }
|
|
|
/// <summary>
|
/// 容器编码
|
/// </summary>
|
[Required]
|
[SugarColumn(ColumnName = "ContainerCode", ColumnDescription = "容器编码", Length = 50)]
|
|
public string ContainerCode { get; set; }
|
|
|
/// <summary>
|
/// 容器类型编号
|
/// </summary>
|
|
public string ContainerTypeCode { get; set; }
|
|
|
/// <summary>
|
/// 容器类型名称
|
/// </summary>
|
|
public string ContainerTypeName { get; set; }
|
|
|
/// <summary>
|
/// 物料类型编号
|
/// </summary>
|
|
public string MaterialTypeCode { get; set; }
|
|
/// <summary>
|
/// 物料类型名称
|
/// </summary>
|
|
public string MaterialTypeName { get; set; }
|
|
/// <summary>
|
/// 容器名称
|
/// </summary>
|
[SugarColumn(ColumnName = "ContainerName", ColumnDescription = "容器名称")]
|
public string ContainerName { get; set; }
|
|
|
|
/// <summary>
|
/// 所属库位编号
|
/// </summary>
|
[SugarColumn(ColumnName = "PlaceCode", ColumnDescription = "所属库位编号")]
|
public string PlaceCode { get; set; }
|
|
/// <summary>
|
/// 所属库位名称
|
/// </summary>
|
[SugarColumn(ColumnName = "PlaceName", ColumnDescription = "所属库位名称")]
|
public string PlaceName { get; set; }
|
/// <summary>
|
/// 库位属性
|
/// </summary>
|
[SugarColumn(ColumnName = "PlaceStatus", ColumnDescription = "库位属性")]
|
public PlaceStatusEnum PlaceStatus { get; set; }
|
|
/// <summary>
|
/// 是否虚拟库区
|
/// </summary>
|
[SugarColumn(ColumnName = "IsVirtuallyArea", ColumnDescription = "是否虚拟库区")]
|
public bool? IsVirtuallyArea { get; set; }
|
|
/// <summary>
|
/// 是否虚拟库位
|
/// </summary>
|
[SugarColumn(ColumnName = "IsVirtuallyPlace", ColumnDescription = "是否虚拟库位")]
|
public bool? IsVirtuallyPlace { get; set; }
|
|
|
/// <summary>
|
/// 是否禁用库位
|
/// </summary>
|
[SugarColumn(ColumnName = "IsDisabledPlace", ColumnDescription = "是否禁用库位")]
|
public bool? IsDisabledPlace { get; set; }
|
|
/// <summary>
|
/// 是否禁用库区
|
/// </summary>
|
[SugarColumn(ColumnName = "IsDisabledPlace", ColumnDescription = "是否禁用库区")]
|
public bool? IsDisabledArea { get; set; }
|
|
|
/// <summary>
|
/// 所属库区编号
|
/// </summary>
|
[SugarColumn(ColumnName = "AreaCode", ColumnDescription = "所属库区编号")]
|
public string AreaCode { get; set; }
|
|
/// <summary>
|
/// 所属库区名称
|
/// </summary>
|
[SugarColumn(ColumnName = "AreaName", ColumnDescription = "所属库区名称")]
|
public string AreaName { get; set; }
|
|
/// <summary>
|
/// 所属库区类型
|
/// </summary>
|
[SugarColumn(ColumnName = "AreaType", ColumnDescription = "所属库区类型")]
|
public AreaTypeEnum AreaType { get; set; }
|
|
|
|
|
|
|
/// <summary>
|
/// 所属仓库编号
|
/// </summary>
|
[SugarColumn(ColumnName = "WarehouseCode", ColumnDescription = "所属仓库编号", Length = 50)]
|
|
public string? WarehouseCode { get; set; }
|
|
|
/// <summary>
|
/// 所属仓库名称
|
/// </summary>
|
[SugarColumn(ColumnName = "WarehouseName", ColumnDescription = "所属仓库名称", Length = 50)]
|
|
public string? WarehouseName { get; set; }
|
|
|
|
|
|
|
/// <summary>
|
/// 收货时间
|
/// </summary>
|
|
[SugarColumn(ColumnName = "RecordInsertTime", ColumnDescription = "收货时间")]
|
public DateTime RecordInsertTime { get; set; }
|
|
|
/// <summary>
|
/// 供应商编号
|
/// </summary>
|
[SugarColumn(ColumnName = "SupplierCode", ColumnDescription = "供应商编号", Length = 50)]
|
|
public string? SupplierCode { get; set; }
|
|
|
/// <summary>
|
/// 供应商名称
|
/// </summary>
|
[SugarColumn(ColumnName = "SupplierName", ColumnDescription = "供应商名称", Length = 50)]
|
|
public string? SupplierName { get; set; }
|
|
|
/// <summary>
|
/// 操作备注
|
/// </summary>
|
[SugarColumn(ColumnName = "ActionRemark", ColumnDescription = "操作备注", Length = 255)]
|
|
public string? ActionRemark { get; set; }
|
|
|
/// <summary>
|
/// 操作时间
|
/// </summary>
|
|
[SugarColumn(ColumnName = "ActionTime", ColumnDescription = "操作时间")]
|
public DateTime? ActionTime { get; set; }
|
|
|
|
|
|
|
|
/// <summary>
|
/// 库存状态
|
/// </summary>
|
[Required]
|
|
[SugarColumn(ColumnName = "StockStatus", ColumnDescription = "库存状态")]
|
public StockStatusEnum StockStatus { get; set; }
|
|
|
/// <summary>
|
/// 库存状态名称
|
/// </summary>
|
[Required]
|
[SugarColumn(ColumnName = "StockStatusName", ColumnDescription = "库存状态名称", Length = 50)]
|
|
public string StockStatusName { get; set; }
|
|
|
|
/// <summary>
|
/// 一维条码
|
/// </summary>
|
[SugarColumn(ColumnName = "SN_1d", ColumnDescription = "一维条码", Length = 255)]
|
|
public string? SN_1d { get; set; }
|
|
|
/// <summary>
|
/// 二维条码
|
/// </summary>
|
[SugarColumn(ColumnName = "SN_2d", ColumnDescription = "二维条码", Length = 255)]
|
|
public string? SN_2d { get; set; }
|
|
|
/// <summary>
|
/// 跟踪码
|
/// </summary>
|
[Required]
|
[SugarColumn(ColumnName = "SNCode", ColumnDescription = "跟踪码", Length = 255)]
|
|
public string SNCode { get; set; }
|
|
/// <summary>
|
/// 源跟踪码
|
/// </summary>
|
|
[SugarColumn(ColumnName = "SourceSNCode", ColumnDescription = "源跟踪码", Length = 255)]
|
|
public string? SourceSNCode { get; set; }
|
|
/// <summary>
|
/// ERP凭证
|
/// </summary>
|
[SugarColumn(ColumnName = "ErpVoucher", ColumnDescription = "ERP凭证", Length = 255)]
|
|
public string? ErpVoucher { get; set; }
|
|
|
/// <summary>
|
/// ERP单号
|
/// </summary>
|
[SugarColumn(ColumnName = "ErpOrderNo", ColumnDescription = "ERP单号", Length = 50)]
|
|
public string? ErpOrderNo { get; set; }
|
|
|
/// <summary>
|
/// ERP库存地
|
/// </summary>
|
[SugarColumn(ColumnName = "ErpCode", ColumnDescription = "ERP库存地", Length = 50)]
|
|
public string? ErpCode { get; set; }
|
|
|
|
/// <summary>
|
/// 供应商批次
|
/// </summary>
|
[SugarColumn(ColumnName = "SupplierBatch", ColumnDescription = "供应商批次", Length = 50)]
|
|
public string? SupplierBatch { get; set; }
|
|
|
/// <summary>
|
/// 批次
|
/// </summary>
|
[SugarColumn(ColumnName = "Batch", ColumnDescription = "批次", Length = 255)]
|
|
public string? Batch { get; set; }
|
|
|
|
|
|
|
|
|
|
/// <summary>
|
/// 质检状态
|
/// </summary>
|
|
[SugarColumn(ColumnName = "QCStatus", ColumnDescription = "质检状态")]
|
public StockQcStatusEnum QCStatus { get; set; }
|
|
|
/// <summary>
|
/// 质检状态名称
|
/// </summary>
|
[SugarColumn(ColumnName = "QCStatusName", ColumnDescription = "质检状态名称", Length = 50)]
|
|
public string? QCStatusName { get; set; }
|
|
/// <summary>
|
/// 容器是否禁用
|
/// </summary>
|
public bool? ContainerIsDisabled { get; set; }
|
|
/// <summary>
|
/// 库存单位
|
/// </summary>
|
public string? MaterialUnit { get; set; }
|
|
/// <summary>
|
/// 采购单位
|
/// </summary>
|
public string? POUnit { get; set; }
|
|
/// <summary>
|
/// 跟踪码最大索引
|
/// </summary>
|
public int? MaxIndex { get; set; }
|
}
|
