using JNPF.Common.Contracts;
using JNPF.Common.Security;
using NPOI.OpenXmlFormats.Dml;
using SqlSugar;

namespace Tnb.WarehouseMgr.Entities;

/// <summary>
/// 载具库存集合
/// </summary>
public partial class WmsCarryStockReport
{
    public int index { get; set; }
    ///// <summary>
    ///// 所属组织
    ///// </summary>
    //public string? 组织 { get; set; }

    /// <summary>
    /// 载具ID
    /// </summary>
    public string? carry_id { get; set; }

    /// <summary>
    /// 载具编码
    /// </summary>
    public string? carry_code { get; set; }

    /// <summary>
    /// 载具名称
    /// </summary>
    public string? carry_name { get; set; }

    /// <summary>
    /// 子载具编码
    /// </summary>
    public string? membercarry_code { get; set; }

    /// <summary>
    /// 子载具名称
    /// </summary>
    public string? membercarry_name { get; set; }

    /// <summary>
    /// 物料ID
    /// </summary>
    public string? material_id { get; set; }

    /// <summary>
    /// 物料编码
    /// </summary>
    public string? material_code { get; set; }

    /// <summary>
    /// 物料名称
    /// </summary>
    public string? material_name { get; set; }

    /// <summary>
    /// 仓库名称
    /// </summary>
    public string? warehouse_name { get; set; }

    /// <summary>
    /// 库位编码
    /// </summary>
    public string? location_code { get; set; }

    /// <summary>
    /// 库位名称
    /// </summary>
    public string? location_name { get; set; }

    /// <summary>
    /// 载具状态
    /// </summary>
    public string? carry_status { get; set; }

    /// <summary>
    /// 库位状态
    /// </summary>
    public string? location_status { get; set; }

    /// <summary>
    /// 载具类型
    /// </summary>
    public string? carry_type { get; set; }

    /// <summary>
    /// 入库时间
    /// </summary>
    public string? instock_time { get; set; }

    /// <summary>
    /// 条码
    /// </summary>
    public string? barcode { get; set; }

    /// <summary>
    /// 批次
    /// </summary>
    public string? code_batch { get; set; }

    /// <summary>
    /// 
    /// </summary>
    public string? material_specification { get; set; }

    /// <summary>
    /// 
    /// </summary>
    public string? container_no { get; set; }

    /// <summary>
    /// 数量
    /// </summary>
    public decimal? qty { get; set; }

    /// <summary>
    /// 单位
    /// </summary>
    public string? unit { get; set; }

    /// <summary>
    /// 操作用户
    /// </summary>
    public string? creator { get; set; }

    /// <summary>
    /// 绑定时间
    /// </summary>
    public string? bind_time { get; set; }
    /// <summary>
    /// 质检结果
    /// </summary>
    public string qc_res { get; set; } = string.Empty;

    /// <summary>
    /// 辅助属性(供应商)
    /// </summary>
    public string? auxprop_gys { get; set; } = string.Empty;

    /// <summary>
    /// 辅助属性(小批号)
    /// </summary>
    public string? auxprop_xph { get; set; } = string.Empty;

}

/// <summary>
/// 载具库存报表
/// </summary>
public partial class WmsCarryStockReportH
{
    public int index { get; set; }
    ///// <summary>
    ///// 所属组织
    ///// </summary>
    //public string? 组织 { get; set; }

    ///// <summary>
    ///// 载具ID
    ///// </summary>
    //public string? carry_id { get; set; }

    /// <summary>
    /// 载具编码
    /// </summary>
    public string? carry_code { get; set; }

    /// <summary>
    /// 载具名称
    /// </summary>
    public string? carry_name { get; set; }

    /// <summary>
    /// 仓库名称
    /// </summary>
    public string? warehouse_name { get; set; }

    /// <summary>
    /// 库位编码
    /// </summary>
    public string? location_code { get; set; }

    /// <summary>
    /// 库位名称
    /// </summary>
    public string? location_name { get; set; }

    /// <summary>
    /// 载具状态
    /// </summary>
    public string? carry_status { get; set; }

    /// <summary>
    /// 库位状态
    /// </summary>
    public string? location_status { get; set; }

    /// <summary>
    /// 载具类型
    /// </summary>
    public string? carry_type { get; set; }

    /// <summary>
    /// 入库时间
    /// </summary>
    public string? instock_time { get; set; }

    public List<WmsCarryStockReportCode> Details { get; set; }
}


/// <summary>
/// 载具库存报表条码表
/// </summary>
public partial class WmsCarryStockReportCode
{
    public int index { get; set; }
    ///// <summary>
    ///// 载具ID
    ///// </summary>
    //public string? carry_id { get; set; }

    /// <summary>
    /// 载具编码
    /// </summary>
    public string? carry_code { get; set; }

    /// <summary>
    /// 载具名称
    /// </summary>
    public string? carry_name { get; set; }

    ///// <summary>
    ///// 物料ID
    ///// </summary>
    //public string? material_id { get; set; }

    /// <summary>
    /// 物料编号
    /// </summary>
    public string? material_code { get; set; }

    /// <summary>
    /// 物料名称
    /// </summary>
    public string? material_name { get; set; }

    /// <summary>
    /// 
    /// </summary>
    public string? material_specification { get; set; }

    /// <summary>
    /// 
    /// </summary>
    public string? container_no { get; set; }

    /// <summary>
    /// 条码编号
    /// </summary>
    public string? barcode { get; set; }

    /// <summary>
    /// 批次
    /// </summary>
    public string? code_batch { get; set; }

    /// <summary>
    /// 条码数量
    /// </summary>
    public decimal? qty { get; set; }

    /// <summary>
    /// 单位
    /// </summary>
    public string? unit { get; set; }

    ///// <summary>
    ///// 操作用户
    ///// </summary>
    //public string? 创建用户 { get; set; }

    /// <summary>
    /// 绑定时间
    /// </summary>
    public string? bind_time { get; set; }

    /// <summary>
    /// 辅助属性(供应商)
    /// </summary>
    public string? auxprop_gys { get; set; }

    /// <summary>
    /// 辅助属性(小批号)
    /// </summary>
    public string? auxprop_xph { get; set; }

    /// <summary>
    /// 质检结果
    /// </summary>
    public string? qc_res { get; set; }

}




/// <summary>
/// 载具库存报表
/// </summary>
public partial class WmsCarryStockReportExcel
{
    public int index { get; set; }
    ///// <summary>
    ///// 所属组织
    ///// </summary>
    //public string? 组织 { get; set; }

    ///// <summary>
    ///// 载具ID
    ///// </summary>
    //public string? carry_id { get; set; }

    /// <summary>
    /// 载具编码
    /// </summary>
    public string? carry_code { get; set; }

    /// <summary>
    /// 载具名称
    /// </summary>
    public string? carry_name { get; set; }

    /// <summary>
    /// 仓库名称
    /// </summary>
    public string? warehouse_name { get; set; }

    /// <summary>
    /// 库位编码
    /// </summary>
    public string? location_code { get; set; }

    /// <summary>
    /// 库位名称
    /// </summary>
    public string? location_name { get; set; }

    /// <summary>
    /// 载具状态
    /// </summary>
    public string? carry_status { get; set; }

    /// <summary>
    /// 库位状态
    /// </summary>
    public string? location_status { get; set; }

    /// <summary>
    /// 载具类型
    /// </summary>
    public string? carry_type { get; set; }

    /// <summary>
    /// 入库时间
    /// </summary>
    public string? instock_time { get; set; }

    ///// <summary>
    ///// 物料ID
    ///// </summary>
    //public string? material_id { get; set; }

    /// <summary>
    /// 物料编号
    /// </summary>
    public string? material_code { get; set; }

    /// <summary>
    /// 物料名称
    /// </summary>
    public string? material_name { get; set; }

    /// <summary>
    /// 条码编号
    /// </summary>
    public string? barcode { get; set; }

    /// <summary>
    /// 批次
    /// </summary>
    public string? code_batch { get; set; }

    /// <summary>
    /// 条码数量
    /// </summary>
    public decimal? qty { get; set; }

    /// <summary>
    /// 单位
    /// </summary>
    public string? unit { get; set; }

    ///// <summary>
    ///// 操作用户
    ///// </summary>
    //public string? 创建用户 { get; set; }

    /// <summary>
    /// 绑定时间
    /// </summary>
    public string? bind_time { get; set; }
    /// <summary>
    /// 物料规格
    /// </summary>
    public string? material_specification { get; set; }
    /// <summary>
    /// 物料型号
    /// </summary>
    public string? container_no { get;set; }
}