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; }
    }


}