WEBUI/WMS.BZModels/Dto/CP/ReportDtos/ReportDto.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Diagnostics.Contracts;
using System.Linq;
using System.Runtime.InteropServices;
using System.Text;

namespace WMS.BZModels.Dto.CP.ReportDtos
{
    public class ReportDto
    {
        /// <summary> 
        /// Id
        /// </summary> 
        public string Id { get; set; }
        /// <summary>
        /// 任务号
        /// </summary>
        public int TaskNo { get; set; }
        /// <summary> 
        /// 仓库id
        /// </summary> 
        public string WarehouseName { get; set; }
        /// <summary> 
        /// 组盘组id
        /// </summary> 
        public string ContGrpId { get; set; }

        /// <summary> 
        /// 载具编号
        /// </summary> 
        public string ContGrpBarCode { get; set; }

        /// <summary> 
        /// 库存类型(1物料盘2空盘)
        /// </summary> 
        public int ContGrpType { get; set; }

        /// <summary> 
        /// 箱条码
        /// </summary> 
        public string BoxBarCode { get; set; }

        /// <summary> 
        /// bom单号
        /// </summary> 
        public string BomDocsNo { get; set; }

        /// <summary> 
        /// bom物料id
        /// </summary> 
        public string BomMatId { get; set; }

        /// <summary> 
        /// bom物料编码
        /// </summary> 
        public string BomMatCode { get; set; }

        /// <summary> 
        /// bom物料名称
        /// </summary> 
        public string BomMatName { get; set; }

        /// <summary> 
        /// 垛型id
        /// </summary> 
        public string BomSetId { get; set; }

        /// <summary> 
        /// 库存执行状态
        /// </summary> 
        public string ExecStateCode { get; set; }

        /// <summary> 
        /// 执行单号
        /// </summary> 
        public string ExecDocsNo { get; set; }

        /// <summary> 
        /// 执行单行号
        /// </summary> 
        public string ExecDocsRowNo { get; set; }

        /// <summary> 
        /// 执行单类型
        /// </summary> 
        public string ExecDocsTypeCode { get; set; }

        /// <summary> 
        /// 出入类型
        /// </summary> 
        public int InvInOut { get; set; }

        /// <summary> 
        /// 执行人
        /// </summary> 
        public string ExecWho { get; set; }

        /// <summary> 
        /// 执行时间
        /// </summary> 
        public DateTime ExecTime { get; set; }

        /// <summary> 
        /// 行
        /// </summary> 
        public int PutRow { get; set; }

        /// <summary> 
        /// 列
        /// </summary> 
        public int PutCol { get; set; }

        /// <summary> 
        /// 层
        /// </summary> 
        public int PutLayer { get; set; }

        /// <summary> 
        /// 材料号
        /// </summary> 
        public string InvBarCode { get; set; }

        /// <summary> 
        /// 库存状态
        /// </summary> 
        public string InvStateCode { get; set; }

        public string InvStateName
        {
            get
            {
                if (Enum.TryParse(typeof(InvState), InvStateCode, out var result))
                {
                    return ((InvState)result).GetDescription();
                }
                return "";

            }
        }
        /// <summary> 
        /// 入库单号
        /// </summary> 
        public string InDocsNo { get; set; }

        /// <summary> 
        /// 入库单行号
        /// </summary> 
        public string InDocsRowNo { get; set; }

        /// <summary> 
        /// 供应商编码
        /// </summary> 
        public string SuppCode { get; set; }

        /// <summary> 
        /// 供应商名称
        /// </summary> 
        public string SuppName { get; set; }

        /// <summary> 
        /// 客户
        /// </summary> 
        public string CustCode { get; set; }

        /// <summary> 
        /// 客户名称
        /// </summary> 
        public string CustName { get; set; }

        /// <summary> 
        /// 物料id
        /// </summary> 
        public long MatId { get; set; }

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

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

        /// <summary> 
        /// 总重量
        /// </summary> 
        public decimal TolWQty { get; set; }

        /// <summary> 
        /// 净重
        /// </summary> 
        public decimal NetWQty { get; set; }

        /// <summary> 
        /// 皮重
        /// </summary> 
        public decimal TareWQty { get; set; }

        /// <summary> 
        /// 长度
        /// </summary> 
        public decimal LengthQty { get; set; }

        /// <summary> 
        /// 碳当量
        /// </summary> 
        public decimal CaQty { get; set; }

        /// <summary> 
        /// 焊点数量
        /// </summary> 
        public decimal SolderQty { get; set; }

        /// <summary> 
        /// ContUsageQty
        /// </summary> 
        public int ContUsageQty { get; set; }

        /// <summary> 
        /// 批号
        /// </summary> 
        public string BatchNo { get; set; }

        /// <summary> 
        /// 生产时间
        /// </summary> 
        public DateTime ProductTime { get; set; }

        /// <summary> 
        /// 首次入库时间
        /// </summary> 
        public DateTime OneInTime { get; set; }

        /// <summary> 
        /// 盘条条码
        /// </summary> 
        public string RodBarCode { get; set; }

        /// <summary> 
        /// 工字轮条码
        /// </summary> 
        public string HWBarCode { get; set; }

        /// <summary> 
        /// RFID编号
        /// </summary> 
        public string RFIDBarCode { get; set; }

        /// <summary> 
        /// CLBarCode
        /// </summary> 
        public string CLBarCode { get; set; }

        /// <summary> 
        /// 工字轮类型
        /// </summary> 
        public string HWTypeCode { get; set; }

        /// <summary> 
        /// 炉号
        /// </summary> 
        public string BoilerNo { get; set; }

        /// <summary> 
        /// 包号
        /// </summary> 
        public string PackNo { get; set; }

        /// <summary> 
        /// 牌号
        /// </summary> 
        public string BrandNo { get; set; }

        /// <summary> 
        /// 执行标准
        /// </summary> 
        public string ExecStd { get; set; }

        /// <summary> 
        /// 许可证号
        /// </summary> 
        public string LicenceCode { get; set; }

        /// <summary> 
        /// 改手盘标记
        /// </summary> 
        public bool IsSurplus { get; set; }

        /// <summary> 
        /// 返工标记
        /// </summary> 
        public bool IsRework { get; set; }

        /// <summary> 
        /// 是否黑盘
        /// </summary> 
        public bool IsBlack { get; set; }

        /// <summary> 
        /// 是否芯股
        /// </summary> 
        public bool IsCore { get; set; }

        /// <summary> 
        /// 快投标记
        /// </summary> 
        public bool IsFast { get; set; }

        /// <summary> 
        /// 是否异常
        /// </summary> 
        public bool IsFail { get; set; }

        /// <summary> 
        /// 异常原因
        /// </summary> 
        public string FailReason { get; set; }

        /// <summary> 
        /// 钢丝类型编码
        /// </summary> 
        public string SilkTypeCode { get; set; }

        /// <summary> 
        /// 等级
        /// </summary> 
        public string Grade { get; set; }

        /// <summary> 
        /// 是否退料
        /// </summary> 
        public bool IsBack { get; set; }

        /// <summary> 
        /// 退料原因
        /// </summary> 
        public string BackReason { get; set; }

        /// <summary> 
        /// 是否扭转检测
        /// </summary> 
        public bool IsTorsChk { get; set; }

        /// <summary> 
        /// 扭转次数
        /// </summary> 
        public int TorsChkQty { get; set; }

        /// <summary> 
        /// 扭转检测时间
        /// </summary> 
        public DateTime TorsChkTime { get; set; }

        /// <summary> 
        /// 扭转检测结果值
        /// </summary> 
        public decimal? TorsChkValue { get; set; }

        /// <summary> 
        /// 扭转检测设备号
        /// </summary> 
        public string TorsChkMachCode { get; set; }

        /// <summary> 
        /// 工序订单号
        /// </summary> 
        public string ProcessDocsCode { get; set; }

        /// <summary> 
        /// 生产机台号
        /// </summary> 
        public string ProductMachCode { get; set; }

        /// <summary> 
        /// ProductLineNo
        /// </summary> 
        public string ProductLineNo { get; set; }

        /// <summary> 
        /// Remark
        /// </summary> 
        public string Remark { get; set; }

        /// <summary> 
        /// Default1
        /// </summary> 
        public string Default1 { get; set; }

        /// <summary> 
        /// Default2
        /// </summary> 
        public string Default2 { get; set; }

        /// <summary> 
        /// Default3
        /// </summary> 
        public string Default3 { get; set; }

        /// <summary> 
        /// AddWho
        /// </summary> 
        public string AddWho { get; set; }

        /// <summary> 
        /// AddTime
        /// </summary> 
        public DateTime AddTime { get; set; }

        /// <summary> 
        /// EditWho
        /// </summary> 
        public string EditWho { get; set; }

        /// <summary> 
        /// EditTime
        /// </summary> 
        public DateTime EditTime { get; set; }

        /// <summary> 
        /// 尺寸
        /// </summary> 
        public int Size { get; set; }

        /// <summary> 
        /// Memo
        /// </summary> 
        public string Memo { get; set; }
        /// <summary>
        /// 巷道
        /// </summary>
        public int Tunnel { get; set; }
        /// <summary>
        /// 货位号
        /// </summary>
        public string Code { get; set; }
        /// <summary> 
        /// 开始时间
        /// </summary> 
        public DateTime? StartTime { get; set; }

        /// <summary> 
        /// 结束时间
        /// </summary> 
        public DateTime? EndTime { get; set; }
        public string HuTotalWt { get; set; }
    }
    public class ReportQueryDto : PagerInfo
    {
        /// <summary> 
        /// RFID条码
        /// </summary> 
        public string RFIDBarCode { get; set; }

        /// <summary> 
        /// 载具编号
        /// </summary> 
        public string ContGrpBarCode { get; set; }

        /// <summary> 
        /// 库存类型(1物料盘2空盘)
        /// </summary> 
        public int ContGrpType { get; set; }

        /// <summary> 
        /// 物料名称
        /// </summary> 
        public string MatName { get; set; }
        public string MatCode { get; set; }
        /// <summary> 
        /// 库存状态
        /// </summary> 
        public string InvStateCode { get; set; }
        /// <summary>
        /// 货位号
        /// </summary>
        public string CellCode { get; set; }
        /// <summary>
        /// 巷道
        /// </summary>
        public string Tunnel { get; set; }
        /// <summary>
        /// 材料号
        /// </summary>
        public string InvBarCode { get; set; }
        /// <summary>
        /// 开始时间, 
        /// </summary>
        public DateTime? StartTimeBegin { get; set; }

        /// <summary>
        /// 开始时间, 
        /// </summary>
        public DateTime? StartTimeEnd { get; set; }
        /// <summary>
        ///  结束时间, 
        /// </summary>
        public DateTime? EndTimeBegin { get; set; }

        public DateTime? EndTimeEnd { get; set; }
        public DateTime? AddTimeFrom { get; set; }

        public DateTime? AddTimeTo { get; set; }

        public string IsSurplus { get; set; }
        public string IsRework { get; set; }
        public string IsFast { get; set; }
        public string IsFail { get; set; }
        public string IsBack { get; set; }
    }


    /// <summary>
    /// 货位使用率返回结果
    /// </summary>
    public class LocationUsageReportViewDto
    {
        /// <summary>
        /// 序号:从1开始顺序
        /// </summary>
        [Description("序号")]
        public int Sort { get; set; }
        /// <summary>
        /// 仓库类型
        /// </summary>
        [Description("仓库类型")]
        public string WarehouseName { get; set; }

        /// <summary>
        /// 巷道
        /// </summary>
        [Description("巷道")]
        public string Tunnel { get; set; }
        /// <summary>
        /// 巷道入库状态
        /// </summary>
        [Description("巷道入库状态")]
        public string InStates { get; set; }
        /// <summary>
        /// 巷道出库状态
        /// </summary>
        [Description("巷道出库状态")]
        public string OutStates { get; set; }
        /// <summary>
        /// 总货位
        /// </summary>
        [Description("总货位")]
        public int AllLocationTotal { get; set; }
        /// <summary>
        /// 有效货位
        /// </summary>
        [Description("有效货位")]
        public int CanUseLocation { get; set; }

        private int _SpareLocation;
        /// <summary>
        /// 空余货位
        /// </summary>
        [Description("空余货位")]
        public int SpareLocation
        {
            get
            {
                return CanUseLocation - MaterilLocation - ContainLocation - LockLocation;
            }
            set { _SpareLocation = value; }
        }
        /// <summary>
        /// 有料货位
        /// </summary>
        [Description("有料货位")]
        public int MaterilLocation { get; set; }
        /// <summary>
        /// 有容器货位
        /// </summary>
        [Description("有容器货位")]
        public int ContainLocation { get; set; }
        /// <summary>
        /// 锁定货位
        /// </summary>
        [Description("锁定货位")]
        public int LockLocation { get; set; }
        /// <summary>
        /// 停用货位
        /// </summary>
        [Description("停用货位")]
        public int StopLocation
        {
            get; set;
        }

        /// <summary>
        /// 货位使用率
        /// </summary>
        [Description("货位使用率")]
        public string MaterialUsage
        {
            get
            {
                string res = "0%";
                //如果有料货位大于0，总货位大于0，则根据有料货位/总货位计算货位使用率
                if (MaterilLocation > 0 && AllLocationTotal > 0)
                {
                    //转为百分比，保留2位
                    res = (MaterilLocation / (AllLocationTotal * 1.0)).ToString("P2");
                }
                return res;
            }

        }


    }

    /// <summary>
    /// 库龄报表
    /// </summary>
    public class StockKeepReportViewDto
    {
        /// <summary>
        /// 物料编码
        /// </summary>
        [Description("物料编码")]
        public string MatCode { get; set; }
        /// <summary>
        /// 存货名称
        /// </summary>
        [Description("存货名称")]
        public string MatName { get; set; }

        /// <summary>
        /// 规格
        /// </summary>
        [Description("规格")]
        public string Describe { get; set; }
        /// <summary>
        /// 库龄
        /// </summary>
        [Description("库龄")]
        public double StockKeepTime { get; set; }


        /// <summary>
        /// 0-7天
        /// </summary>
        [Description("0-7天")]
        public decimal StockKeepTime7 { get; set; }
        /// <summary>
        /// 7-15天
        /// </summary>
        [Description("7-15天")]
        public decimal StockKeepTime15 { get; set; }
        /// <summary>
        /// 15-30天
        /// </summary>
        [Description("15-30天")]
        public decimal StockKeepTime30 { get; set; }
        /// <summary>
        /// 30天以上
        /// </summary>
        [Description("30天以上")]
        public decimal StockKeepTime31 { get; set; }

    }

    public class MatNameNetWeightCategory
    {
        public string MatName { get; set; }
        public string MatCode { get; set; }
        public decimal NetWQty { get; set; }
        public int Qty { get; set; }
    }
}