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.FJ.ReportDtos { public class ReportDto { /// /// Id /// public string Id { get; set; } /// /// 任务号 /// public int TaskNo { get; set; } /// /// 仓库id /// public string WarehouseName { get; set; } /// /// 组盘组id /// public string ContGrpId { get; set; } /// /// 载具编号 /// public string ContGrpBarCode { get; set; } /// /// 库存类型(1物料盘2空盘) /// public int ContGrpType { get; set; } /// /// 箱条码 /// public string BoxBarCode { get; set; } /// /// bom单号 /// public string BomDocsNo { get; set; } /// /// bom物料id /// public string BomMatId { get; set; } /// /// bom物料编码 /// public string BomMatCode { get; set; } /// /// bom物料名称 /// public string BomMatName { get; set; } /// /// 垛型id /// public string BomSetId { get; set; } /// /// 库存执行状态 /// public string ExecStateCode { get; set; } /// /// 执行单号 /// public string ExecDocsNo { get; set; } /// /// 执行单行号 /// public string ExecDocsRowNo { get; set; } /// /// 执行单类型 /// public string ExecDocsTypeCode { get; set; } /// /// 出入类型 /// public int InvInOut { get; set; } /// /// 执行人 /// public string ExecWho { get; set; } /// /// 执行时间 /// public DateTime ExecTime { get; set; } /// /// 行 /// public int PutRow { get; set; } /// /// 列 /// public int PutCol { get; set; } /// /// 层 /// public int PutLayer { get; set; } /// /// 材料号 /// public string InvBarCode { get; set; } /// /// 库存状态 /// public string InvStateCode { get; set; } public string InvStateName { get { if (Enum.TryParse(typeof(InvState), InvStateCode, out var result)) { return ((InvState)result).GetDescription(); } return ""; } } /// /// 入库单号 /// public string InDocsNo { get; set; } /// /// 入库单行号 /// public string InDocsRowNo { get; set; } /// /// 供应商编码 /// public string SuppCode { get; set; } /// /// 供应商名称 /// public string SuppName { get; set; } /// /// 客户 /// public string CustCode { get; set; } /// /// 客户名称 /// public string CustName { get; set; } /// /// 物料id /// public long MatId { get; set; } /// /// 物料编码 /// public string MatCode { get; set; } /// /// 物料名称 /// public string MatName { get; set; } /// /// 总重量 /// public decimal TolWQty { get; set; } /// /// 净重 /// public decimal NetWQty { get; set; } /// /// 皮重 /// public decimal TareWQty { get; set; } /// /// 长度 /// public decimal LengthQty { get; set; } /// /// 碳当量 /// public decimal CaQty { get; set; } /// /// 焊点数量 /// public decimal SolderQty { get; set; } /// /// ContUsageQty /// public int ContUsageQty { get; set; } /// /// 批号 /// public string BatchNo { get; set; } /// /// 生产时间 /// public DateTime ProductTime { get; set; } /// /// 首次入库时间 /// public DateTime OneInTime { get; set; } /// /// 盘条条码 /// public string RodBarCode { get; set; } /// /// 工字轮条码 /// public string HWBarCode { get; set; } /// /// RFID编号 /// public string RFIDBarCode { get; set; } /// /// CLBarCode /// public string CLBarCode { get; set; } /// /// 工字轮类型 /// public string HWTypeCode { get; set; } /// /// 炉号 /// public string BoilerNo { get; set; } /// /// 包号 /// public string PackNo { get; set; } /// /// 牌号 /// public string BrandNo { get; set; } /// /// 执行标准 /// public string ExecStd { get; set; } /// /// 许可证号 /// public string LicenceCode { get; set; } /// /// 改手盘标记 /// public bool IsSurplus { get; set; } /// /// 返工标记 /// public bool IsRework { get; set; } /// /// 是否黑盘 /// public bool IsBlack { get; set; } /// /// 是否芯股 /// public bool IsCore { get; set; } /// /// 快投标记 /// public bool IsFast { get; set; } /// /// 是否异常 /// public bool IsFail { get; set; } /// /// 异常原因 /// public string FailReason { get; set; } /// /// 钢丝类型编码 /// public string SilkTypeCode { get; set; } /// /// 等级 /// public string Grade { get; set; } /// /// 是否退料 /// public bool IsBack { get; set; } /// /// 退料原因 /// public string BackReason { get; set; } /// /// 是否扭转检测 /// public bool IsTorsChk { get; set; } /// /// 扭转次数 /// public int TorsChkQty { get; set; } /// /// 扭转检测时间 /// public DateTime TorsChkTime { get; set; } /// /// 扭转检测结果值 /// public decimal? TorsChkValue { get; set; } /// /// 扭转检测设备号 /// public string TorsChkMachCode { get; set; } /// /// 工序订单号 /// public string ProcessDocsCode { get; set; } /// /// 生产机台号 /// public string ProductMachCode { get; set; } /// /// ProductLineNo /// public string ProductLineNo { get; set; } /// /// Remark /// public string Remark { get; set; } /// /// Default1 /// public string Default1 { get; set; } /// /// Default2 /// public string Default2 { get; set; } /// /// Default3 /// public string Default3 { get; set; } /// /// AddWho /// public string AddWho { get; set; } /// /// AddTime /// public DateTime AddTime { get; set; } /// /// EditWho /// public string EditWho { get; set; } /// /// EditTime /// public DateTime EditTime { get; set; } /// /// 尺寸 /// public int Size { get; set; } /// /// Memo /// public string Memo { get; set; } /// /// 巷道 /// public int Tunnel { get; set; } /// /// 货位号 /// public string Code { get; set; } /// /// 开始时间 /// public DateTime? StartTime { get; set; } /// /// 结束时间 /// public DateTime? EndTime { get; set; } } public class ReportQueryDto : PagerInfo { public string WarehouseId { get; set; } /// /// RFID条码 /// public string RFIDBarCode { get; set; } /// /// 载具编号 /// public string ContGrpBarCode { get; set; } /// /// 库存类型(1物料盘2空盘) /// public int ContGrpType { get; set; } /// /// 物料名称 /// public string MatName { get; set; } public string MatCode { get; set; } /// /// 库存状态 /// public string InvStateCode { get; set; } /// /// 货位号 /// public string CellCode { get; set; } /// /// 巷道 /// public string Tunnel { get; set; } /// /// 材料号 /// public string InvBarCode { get; set; } /// /// 开始时间, /// public DateTime? StartTimeBegin { get; set; } /// /// 开始时间, /// public DateTime? StartTimeEnd { get; set; } /// /// 结束时间, /// 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; } } /// /// 货位使用率返回结果 /// public class LocationUsageReportViewDto { /// /// 序号:从1开始顺序 /// [Description("序号")] public int Sort { get; set; } /// /// 仓库类型 /// [Description("仓库类型")] public string WarehouseName { get; set; } /// /// 巷道 /// [Description("巷道")] public string Tunnel { get; set; } /// /// 巷道入库状态 /// [Description("巷道入库状态")] public string InStates { get; set; } /// /// 巷道出库状态 /// [Description("巷道出库状态")] public string OutStates { get; set; } /// /// 总货位 /// [Description("总货位")] public int AllLocationTotal { get; set; } /// /// 有效货位 /// [Description("有效货位")] public int CanUseLocation { get; set; } private int _SpareLocation; /// /// 空余货位 /// [Description("空余货位")] public int SpareLocation { get { return CanUseLocation - MaterilLocation - ContainLocation - LockLocation; } set { _SpareLocation = value; } } /// /// 有料货位 /// [Description("有料货位")] public int MaterilLocation { get; set; } /// /// 有容器货位 /// [Description("有容器货位")] public int ContainLocation { get; set; } /// /// 锁定货位 /// [Description("锁定货位")] public int LockLocation { get; set; } /// /// 停用货位 /// [Description("停用货位")] public int StopLocation { get; set; } /// /// 货位使用率 /// [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; } } } /// /// 库龄报表 /// public class StockKeepReportViewDto { /// /// 物料编码 /// [Description("物料编码")] public string MatCode { get; set; } /// /// 存货名称 /// [Description("存货名称")] public string MatName { get; set; } /// /// 规格 /// [Description("规格")] public string Describe { get; set; } /// /// 库龄 /// [Description("库龄")] public double StockKeepTime { get; set; } /// /// 0-7天 /// [Description("0-7天")] public decimal StockKeepTime7 { get; set; } /// /// 7-15天 /// [Description("7-15天")] public decimal StockKeepTime15 { get; set; } /// /// 15-30天 /// [Description("15-30天")] public decimal StockKeepTime30 { get; set; } /// /// 30天以上 /// [Description("30天以上")] public decimal StockKeepTime31 { get; set; } } public class MantuoBarCodeRateDto { public string SetGrpCode { get; set; } public string BomMatCode { get; set; } public string BomMatName { get; set; } public string WarehouseName { get; set; } public int Qty { get; set; } } public class MantuoBarCodeRateQueryDto : PagerInfo { public string BomMatCode { get; set; } public string SetGrpCode { get; set; } public string WarehouseId { 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; } } }