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("Dt_PickingRecord")]
|
public class Dt_PickingRecord : BaseEntity
|
{
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "")]
|
public int Id { get; set; }
|
|
/// <summary>
|
/// 任务号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "")]
|
public int TaskNo { get; set; }
|
|
/// <summary>
|
/// 物料条码
|
/// </summary>
|
[SugarColumn(ColumnDescription = "物料条码")]
|
public string Barcode { get; set; }
|
|
|
/// <summary>
|
/// 出库详情ID
|
/// </summary>
|
[SugarColumn(ColumnDescription = "出库详情ID")]
|
public int OrderDetailId { get; set; }
|
|
/// <summary>
|
/// 本次拣选数量
|
/// </summary>
|
[SugarColumn(ColumnDescription = "本次拣选数量")]
|
public decimal PickQuantity { get; set; }
|
|
/// <summary>
|
/// 拣选时间
|
/// </summary>
|
[SugarColumn(ColumnDescription = "拣选时间")]
|
public DateTime PickTime { get; set; }
|
|
/// <summary>
|
/// 拣选库位
|
/// </summary>
|
[SugarColumn(ColumnDescription = "拣选库位")]
|
public string LocationCode { get; set; }
|
|
/// <summary>
|
/// 托盘编号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "托盘编号")]
|
public int StockId { get; set; }
|
|
/// <summary>
|
/// 操作类型：0-拣选 1-回库
|
/// </summary>
|
[SugarColumn(ColumnDescription = "操作类型：0-拣选 1-回库")]
|
public string Operator { get; set; }
|
|
/// <summary>
|
/// 订单号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "订单号")]
|
public string OrderNo { get; set; }
|
|
/// <summary>
|
/// 料箱号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "料箱号")]
|
public string PalletCode { get; set; }
|
|
/// <summary>
|
/// 出库锁定ID
|
/// </summary>
|
[SugarColumn(ColumnDescription = "出库锁定ID")]
|
public int? OutStockLockId { get; set; }
|
|
/// <summary>
|
/// 物料编号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "物料编号")]
|
public string MaterielCode { get; set; }
|
|
/// <summary>
|
/// 厂区
|
/// </summary>
|
[SugarColumn(ColumnDescription = "厂区")]
|
public string FactoryArea { get; set; }
|
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "批次号")]
|
public string BatchNo { get; set; }
|
|
/// <summary>
|
/// 是否取消拣选
|
/// </summary>
|
[SugarColumn(ColumnDescription = "是否取消拣选")]
|
public bool IsCancelled { get; set; }
|
|
/// <summary>
|
/// 取消时间
|
/// </summary>
|
[SugarColumn(ColumnDescription = "取消时间")]
|
public DateTime? CancelTime { get; set; }
|
|
/// <summary>
|
/// 取消人
|
/// </summary>
|
[SugarColumn(ColumnDescription = "取消人")]
|
public string CancelOperator { get; set; }
|
|
/// <summary>
|
/// 仓库编号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "仓库编号")]
|
public string WarehouseCode { get; set; }
|
|
/// <summary>
|
/// 行号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "行号")]
|
public string lineNo { get; set; }
|
|
/// <summary>
|
/// 供应商编号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "供应商编号")]
|
public string SupplyCode { get; set; }
|
|
/// <summary>
|
/// 物料数量
|
/// </summary>
|
[SugarColumn(ColumnDescription = "物料数量")]
|
public decimal BarcodeQty { get; set; }
|
|
/// <summary>
|
/// 物料单位
|
/// </summary>
|
[SugarColumn(ColumnDescription = "物料单位")]
|
public string BarcodeUnit { get; set; }
|
|
/// <summary>
|
/// 物料挪料数量
|
/// </summary>
|
[SugarColumn(ColumnDescription = "物料挪料数量")]
|
public decimal BarcodeMoveQty { get; set; }
|
|
/// <summary>
|
/// 回传MES
|
/// </summary>
|
[SugarColumn(ColumnDescription = "回传MES")]
|
public int ReturnToMESStatus { get; set; }
|
|
/// <summary>
|
/// 回传MES唯一号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "回传MES唯一号")]
|
public string FeedBackMesDocumentNo { get; set; }
|
}
|
|
/// <summary>
|
/// 回库记录表
|
/// </summary>
|
[SugarTable("Dt_ReturnStockRecord")]
|
public class Dt_ReturnStockRecord : BaseEntity
|
{
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
|
public long Id { get; set; }
|
|
public string TaskNo { get; set; }
|
public string PalletId { get; set; }
|
public string LocationId { get; set; }
|
public string NewLocationId { get; set; }
|
|
/// <summary>
|
/// 回库数量
|
/// </summary>
|
public decimal ReturnQty { get; set; }
|
|
public DateTime ReturnTime { get; set; }
|
/// <summary>
|
/// 0-待回库 1-已回库
|
/// </summary>
|
public int Status { get; set; }
|
}
|
|
/// <summary>
|
/// 拆包记录表
|
/// </summary>
|
[SugarTable("Dt_SplitPackageRecord")] // 显式指定表名，与数据库一致
|
public class Dt_SplitPackageRecord : BaseEntity
|
{
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "")]
|
public long Id { get; set; }
|
|
/// <summary>
|
/// 原条码
|
/// </summary>
|
[SugarColumn(ColumnDescription = "原条码")]
|
public string OriginalBarcode { get; set; }
|
|
/// <summary>
|
/// 新条码
|
/// </summary>
|
[SugarColumn(ColumnDescription = "新条码")]
|
public string NewBarcode { get; set; }
|
|
/// <summary>
|
/// 原数量
|
/// </summary>
|
[SugarColumn(ColumnDescription = "原数量")]
|
public decimal OriginalQty { get; set; }
|
|
/// <summary>
|
/// 拆分数量（新条码数量）
|
/// </summary>
|
[SugarColumn(ColumnDescription = "拆分数量（新条码数量）")]
|
public decimal SplitQty { get; set; }
|
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "批次号")]
|
public string BatchNo { get; set; }
|
|
/// <summary>
|
/// 库位编号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "库位编号")]
|
public string LocationId { get; set; }
|
|
/// <summary>
|
/// 拆包时间
|
/// </summary>
|
[SugarColumn(ColumnDescription = "拆包时间")]
|
public DateTime SplitTime { get; set; }
|
|
/// <summary>
|
/// 状态：0-已拆分 1-新条码已回传MES
|
/// </summary>
|
[SugarColumn(ColumnDescription = "状态：0-已拆分 1-新条码已回传MES")]
|
public int Status { get; set; }
|
|
|
|
/// <summary>
|
/// 任务号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "任务号")]
|
public int? TaskNum { get; set; }
|
|
/// <summary>
|
/// 剩余数量（原条码剩余）
|
/// </summary>
|
[SugarColumn(ColumnDescription = "剩余数量（原条码剩余）")]
|
public decimal RemainQuantity { get; set; }
|
|
/// <summary>
|
/// 物料编号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "物料编号")]
|
public string MaterielCode { get; set; }
|
|
/// <summary>
|
/// 托盘编号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "托盘编号")]
|
public string PalletCode { get; set; }
|
|
/// <summary>
|
/// 撤销拆包
|
/// </summary>
|
[SugarColumn(ColumnDescription = "撤销拆包")]
|
public bool IsReverted { get; set; }
|
|
/// <summary>
|
/// 锁定记录Id
|
/// </summary>
|
[SugarColumn(ColumnDescription = "锁定记录Id")]
|
public int OutStockLockInfoId { get; set; }
|
|
/// <summary>
|
/// 操作人
|
/// </summary>
|
[SugarColumn(ColumnDescription = "操作人")]
|
public string Operator { get; set; }
|
|
/// <summary>
|
/// 单号
|
/// </summary>
|
[SugarColumn(ColumnDescription = "单号")]
|
public string OrderNo { get; set; }
|
|
/// <summary>
|
/// 库存id
|
/// </summary>
|
[SugarColumn(ColumnDescription = "库存id")]
|
public int StockId { get; set; }
|
|
/// <summary>
|
/// 厂区
|
/// </summary>
|
[SugarColumn(ColumnDescription = "厂区")]
|
public string FactoryArea { get; set; }
|
|
/// <summary>
|
/// 撤销时间
|
/// </summary>
|
[SugarColumn(ColumnDescription = "撤销时间")]
|
public DateTime? RevertTime { get; set; }
|
|
/// <summary>
|
/// 上一条拆分记录ID
|
/// </summary>
|
[SugarColumn(ColumnDescription = "")]
|
public int PreviousSplitRecordId { get; set; }
|
|
/// <summary>
|
/// 库存数
|
/// </summary>
|
[SugarColumn(ColumnDescription = "库存数")]
|
public decimal OriginalStockQuantity { get; set; }
|
|
/// <summary>
|
/// 拆包前的库存数量
|
/// </summary>
|
[SugarColumn(ColumnDescription = "拆包前的库存数量")]
|
public decimal StockBeforeSplit { get; set; }
|
|
/// <summary>
|
/// 拆包前分配数
|
/// </summary>
|
[SugarColumn(ColumnDescription = "拆包前分配数")]
|
public decimal AssignBeforeSplit { get; set; }
|
|
/// <summary>
|
/// 撤销操作人
|
/// </summary>
|
[SugarColumn(ColumnDescription = "")]
|
public string RevertOperator { get; set; }
|
|
/// <summary>
|
/// 是否自动拆包
|
/// </summary>
|
[SugarColumn(ColumnDescription = "是否自动拆包")]
|
public bool IsAutoSplit { get; set; }
|
}
|
|
|
|
/// <summary>
|
/// 空箱取走记录表
|
/// </summary>
|
public class Dt_EmptyPalletRemoval
|
{
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
|
public int Id { get; set; }
|
|
public string OrderNo { get; set; }
|
|
public string PalletCode { get; set; }
|
|
public DateTime RemovalTime { get; set; }
|
|
public string Operator { get; set; }
|
|
public int CompletedItemsCount { get; set; }
|
|
public decimal TotalPickedQuantity { get; set; }
|
}
|
|
|
}
|
