using iWare.Wms.Core.Enum; using Microsoft.EntityFrameworkCore; using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations.Schema; using System.Linq; using System.Text; using System.Threading.Tasks; namespace iWare.Wms.Core { /// /// 按容器分组查询库存 /// [Table("v_ware_inventory_by_container")] [Comment("按容器分组查询库存")] public class v_ware_inventory_by_container : DEntityBase { ///// ///// 库区ID ///// //[Comment("库区ID")] //public long? LocTypeId { get; set; } /// /// 库区名称 /// [Comment("库区名称")] public string LocTypeName { get; set; } /// /// 库位Code /// [Comment("库位Code")] public string WareLocationCode { get; set; } /// /// 容器Code /// [Comment("容器Code")] public string WareContainerCode { get; set; } /// /// 排 /// [Comment("排")] public int? Row { get; set; } /// /// 巷道 /// public int? Lane { get; set; } /// /// 容器Code /// [Comment("物料Code")] public string WareMaterialCode { get; set; } /// /// 容器Code /// [Comment("物料Name")] public string WareMaterialName { get; set; } /// /// 入库单 /// [Comment("入库单")] public string OrdersNo { get; set; } /// /// 单据类型 /// [Comment("单据类型")] public string OrderType { get; set; } /// /// 采购单号(PO) /// [Comment("采购单号(PO)")] public string PurchaseNo { get; set; } /// /// 送货单号 /// [Comment("送货单号")] public string DeliveryNo { get; set; } /// /// 收货单 /// [Comment("收货单")] public string CollectNo { get; set; } /// /// 物料数量 /// [Comment("物料数量")] public decimal? Quantity { get; set; } /// /// 物料单位 /// [Comment("物料单位")] public string Unit { get; set; } /// /// 项目批次号 /// [Comment("项目批次号")] public string ItemBatchNo { get; set; } /// /// 备注 /// [Comment("备注")] public string Remarks { get; set; } /// /// 是否锁定 /// [Comment("是否锁定")] public bool? IsLocked { get; set; } /// /// 批次号 /// [Comment("批次号")] public string BatchNo { get; set; } /// /// 托盘类型编码 /// [Comment("托盘类型编码")] public string ContainerType { get; set; } /// /// 库存状态 /// [Comment("库存状态")] public StockStatusEnum? StockStatus { get; set; } /// /// 是否空托 /// [Comment("是否空托")] public bool? IsEmptyContainer { get; set; } /// /// 伸位 /// [Comment("伸位")] public DeepcellNoEnum? DeepcellNo { get; set; } /// /// 伸位号 /// [Comment("伸位号")] public string UnionCode { get; set; } /// /// 零件号 /// [Comment("零件号")] public string PartCode { get; set; } /// /// 零件名称 /// [Comment("零件名称")] public string PartName { get; set; } /// /// 绑定库位 /// [Comment("绑定库位")] public string RealLocationCode { get; set; } /// /// 生产线 /// [Comment("生产线")] public LineTypeEnum? LineType { get; set; } /// /// 车型 /// public string CarType { get; set; } } }