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_PickingRecord), "拣选记录表")]
|
|
public class Dt_PickingRecord : BaseEntity
|
{
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
|
public int Id { get; set; }
|
|
public int TaskNo { get; set; }
|
public string OrderNo { get; set; }
|
public int OrderDetailId { get; set; }
|
|
public string PalletCode { get; set; }
|
|
public int OutStockLockId { get; set; }
|
public string MaterielCode { get; set; }
|
|
[SugarColumn(Length = 100)]
|
public string Barcode { get; set; }
|
|
public decimal PickQuantity { get; set; }
|
|
public DateTime PickTime { get; set; } = DateTime.Now;
|
|
[SugarColumn(Length = 50)]
|
public string Operator { get; set; }
|
|
[SugarColumn(Length = 50)]
|
public string LocationCode { get; set; }
|
|
public int StockId { get; set; }
|
|
public string BatchNo { get; set; }
|
|
public bool IsCancelled { get; set; }
|
|
public DateTime? CancelTime { get; set; }
|
|
public string CancelOperator { get; set; }
|
public string FactoryArea { get; set; }
|
|
/// <summary>
|
/// 仓库
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "warehouseCode", ColumnDescription = "仓库")]
|
public string? WarehouseCode { get; set; }
|
/// <summary>
|
/// 行号
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "lineNo", ColumnDescription = "行号")]
|
public string? lineNo { get; set; }
|
/// <summary>
|
/// 供应商编号
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "supplyCode", ColumnDescription = "供应商编号")]
|
public string? SupplyCode { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "barcodeQty", ColumnDescription = "数量")]
|
public decimal BarcodeQty { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "barcodeUnit", ColumnDescription = "单位")]
|
public string BarcodeUnit { get; set; } = null!;
|
/// <summary>
|
///
|
/// 默认值:
|
///</summary>
|
[SugarColumn(ColumnName = "barcodemoveQty", ColumnDescription = "数量")]
|
public decimal BarcodeMoveQty { 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
|
{
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
|
public int Id { get; set; }
|
public string OrderNo { get; set; }
|
public int? TaskNum { get; set; }
|
public string PalletCode { get; set; }
|
public int StockId { get; set; }
|
public bool IsReverted { get; set; } = false;
|
|
public bool IsAutoSplit { get; set; } = false;
|
public int OutStockLockInfoId { get; set; } // 关联的出库锁定信息
|
public string OriginalBarcode { get; set; } // 原条码
|
public string NewBarcode { get; set; } // 新条码
|
|
public string FactoryArea { get; set; }
|
/// <summary>
|
/// 拆分数量（新条码数量）
|
/// </summary>
|
public decimal SplitQty { get; set; }
|
|
public decimal RemainQuantity { get; set; }
|
|
public string MaterielCode { get; set; } // 物料编码
|
public DateTime SplitTime { get; set; } = DateTime.Now;
|
public string Operator { get; set; } // 操作人
|
public int Status { get; set; } // 状态：1-已拆包 2-已拣选 3-已回库
|
|
public DateTime RevertTime { get; set; }
|
|
public string RevertOperator { get; set; }
|
public int PreviousSplitRecordId { get; set; }
|
|
[SugarColumn(IsNullable = true)]
|
public decimal? OriginalStockQuantity { get; set; }
|
|
public decimal StockBeforeSplit { get; set; }
|
public decimal AssignBeforeSplit { 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; }
|
}
|
|
|
}
|
