| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101 |
- namespace Admin.NET.Plugin.AiDOP.MaterialWarehouse.Dto;
- /// <summary>
- /// S5 暂收在检列表 查询入参(只读)。
- ///
- /// 数据源:aidopdev.MissedPrint(Status='I' 暂收待检、Qty>0、Location 空),按存储过程
- /// pr_WMS_GetMissedTempQty 口径 join qms 检验单 / ItemMaster / SuppMaster 聚合。
- /// MissedPrint 无 tenant_id 列;Domain 由 GeneralizedCodeMaster(SystemConfig/CompanyCode) 解析,
- /// TenantId 仅为前端 withAidopTenantParams 注入的透传参数,本查询不据其过滤。
- /// </summary>
- public class PendingInspectionListInput
- {
- /// <summary>页码(从 1 开始)</summary>
- public int Page { get; set; } = 1;
- /// <summary>每页条数</summary>
- public int PageSize { get; set; } = 10;
- /// <summary>要货令单号(MissedPrint.PurOrd,模糊匹配)</summary>
- public string? DemandNo { get; set; }
- /// <summary>货架(MissedPrint.Shelf,模糊匹配)</summary>
- public string? Shelf { get; set; }
- /// <summary>批次号(MissedPrint.LotSerial,模糊匹配)</summary>
- public string? BatchNo { get; set; }
- /// <summary>物料编码(MissedPrint.ItemNum,模糊匹配)</summary>
- public string? MaterialCode { get; set; }
- /// <summary>检验状态(qms_qcp_insappnentry.FINSPECTSTATUS,精确匹配,下拉选择)</summary>
- public string? InspectStatus { get; set; }
- /// <summary>供应商(MissedPrint.Supply,精确匹配,下拉选择)</summary>
- public string? Supplier { get; set; }
- /// <summary>租户 ID(前端 withAidopTenantParams 注入;MissedPrint 无租户列,本查询忽略)</summary>
- public long? TenantId { get; set; }
- }
- /// <summary>
- /// S5 暂收在检列表 行(只读)。字段对齐前端列 prop(camelCase),源列见注释(存储过程 pr_WMS_GetMissedTempQty)。
- /// </summary>
- public class PendingInspectionListRow
- {
- /// <summary>要货令单号(MissedPrint.PurOrd)</summary>
- public string? DemandNo { get; set; }
- /// <summary>要货令行号(MissedPrint.PurLine)</summary>
- public int? DemandLineNo { get; set; }
- /// <summary>物料编码(MissedPrint.ItemNum)</summary>
- public string? MaterialCode { get; set; }
- /// <summary>物料名称(ItemMaster.Descr)</summary>
- public string? MaterialName { get; set; }
- /// <summary>批次号(MissedPrint.LotSerial)</summary>
- public string? BatchNo { get; set; }
- /// <summary>数量(SUM(MissedPrint.Qty))</summary>
- public decimal? Qty { get; set; }
- /// <summary>单位(ItemMaster.UM)</summary>
- public string? Unit { get; set; }
- /// <summary>待检货架(MAX(MissedPrint.Shelf))</summary>
- public string? PendingShelf { get; set; }
- /// <summary>送货单号(MissedPrint.ShipperNbr)</summary>
- public string? DeliveryNo { get; set; }
- /// <summary>检验单号(MAX(MissedPrint.CheckNo))</summary>
- public string? InspectNo { get; set; }
- /// <summary>检验状态(MAX(qms_qcp_insappnentry.FINSPECTSTATUS),clfs='3' 时追加 -挑选使用)</summary>
- public string? InspectStatus { get; set; }
- /// <summary>供应商(MissedPrint.Supply)</summary>
- public string? Supplier { get; set; }
- /// <summary>供应商简称(SuppMaster.SortName)</summary>
- public string? SupplierShortName { get; set; }
- }
- /// <summary>检验状态下拉选项(qms_qcp_insappnentry.FINSPECTSTATUS distinct)。</summary>
- public class PendingInspectionStatusOption
- {
- /// <summary>检验状态值</summary>
- public string? Val { get; set; }
- }
- /// <summary>供应商下拉选项(暂收在检集合内 distinct Supply + SuppMaster.SortName)。</summary>
- public class PendingInspectionSupplierOption
- {
- /// <summary>供应商编码(MissedPrint.Supply)</summary>
- public string? Val { get; set; }
- /// <summary>供应商简称(SuppMaster.SortName)</summary>
- public string? Label { get; set; }
- }
|