PendingInspectionDto.cs 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101
  1. namespace Admin.NET.Plugin.AiDOP.MaterialWarehouse.Dto;
  2. /// <summary>
  3. /// S5 暂收在检列表 查询入参(只读)。
  4. ///
  5. /// 数据源:aidopdev.MissedPrint(Status='I' 暂收待检、Qty>0、Location 空),按存储过程
  6. /// pr_WMS_GetMissedTempQty 口径 join qms 检验单 / ItemMaster / SuppMaster 聚合。
  7. /// MissedPrint 无 tenant_id 列;Domain 由 GeneralizedCodeMaster(SystemConfig/CompanyCode) 解析,
  8. /// TenantId 仅为前端 withAidopTenantParams 注入的透传参数,本查询不据其过滤。
  9. /// </summary>
  10. public class PendingInspectionListInput
  11. {
  12. /// <summary>页码(从 1 开始)</summary>
  13. public int Page { get; set; } = 1;
  14. /// <summary>每页条数</summary>
  15. public int PageSize { get; set; } = 10;
  16. /// <summary>要货令单号(MissedPrint.PurOrd,模糊匹配)</summary>
  17. public string? DemandNo { get; set; }
  18. /// <summary>货架(MissedPrint.Shelf,模糊匹配)</summary>
  19. public string? Shelf { get; set; }
  20. /// <summary>批次号(MissedPrint.LotSerial,模糊匹配)</summary>
  21. public string? BatchNo { get; set; }
  22. /// <summary>物料编码(MissedPrint.ItemNum,模糊匹配)</summary>
  23. public string? MaterialCode { get; set; }
  24. /// <summary>检验状态(qms_qcp_insappnentry.FINSPECTSTATUS,精确匹配,下拉选择)</summary>
  25. public string? InspectStatus { get; set; }
  26. /// <summary>供应商(MissedPrint.Supply,精确匹配,下拉选择)</summary>
  27. public string? Supplier { get; set; }
  28. /// <summary>租户 ID(前端 withAidopTenantParams 注入;MissedPrint 无租户列,本查询忽略)</summary>
  29. public long? TenantId { get; set; }
  30. }
  31. /// <summary>
  32. /// S5 暂收在检列表 行(只读)。字段对齐前端列 prop(camelCase),源列见注释(存储过程 pr_WMS_GetMissedTempQty)。
  33. /// </summary>
  34. public class PendingInspectionListRow
  35. {
  36. /// <summary>要货令单号(MissedPrint.PurOrd)</summary>
  37. public string? DemandNo { get; set; }
  38. /// <summary>要货令行号(MissedPrint.PurLine)</summary>
  39. public int? DemandLineNo { get; set; }
  40. /// <summary>物料编码(MissedPrint.ItemNum)</summary>
  41. public string? MaterialCode { get; set; }
  42. /// <summary>物料名称(ItemMaster.Descr)</summary>
  43. public string? MaterialName { get; set; }
  44. /// <summary>批次号(MissedPrint.LotSerial)</summary>
  45. public string? BatchNo { get; set; }
  46. /// <summary>数量(SUM(MissedPrint.Qty))</summary>
  47. public decimal? Qty { get; set; }
  48. /// <summary>单位(ItemMaster.UM)</summary>
  49. public string? Unit { get; set; }
  50. /// <summary>待检货架(MAX(MissedPrint.Shelf))</summary>
  51. public string? PendingShelf { get; set; }
  52. /// <summary>送货单号(MissedPrint.ShipperNbr)</summary>
  53. public string? DeliveryNo { get; set; }
  54. /// <summary>检验单号(MAX(MissedPrint.CheckNo))</summary>
  55. public string? InspectNo { get; set; }
  56. /// <summary>检验状态(MAX(qms_qcp_insappnentry.FINSPECTSTATUS),clfs='3' 时追加 -挑选使用)</summary>
  57. public string? InspectStatus { get; set; }
  58. /// <summary>供应商(MissedPrint.Supply)</summary>
  59. public string? Supplier { get; set; }
  60. /// <summary>供应商简称(SuppMaster.SortName)</summary>
  61. public string? SupplierShortName { get; set; }
  62. }
  63. /// <summary>检验状态下拉选项(qms_qcp_insappnentry.FINSPECTSTATUS distinct)。</summary>
  64. public class PendingInspectionStatusOption
  65. {
  66. /// <summary>检验状态值</summary>
  67. public string? Val { get; set; }
  68. }
  69. /// <summary>供应商下拉选项(暂收在检集合内 distinct Supply + SuppMaster.SortName)。</summary>
  70. public class PendingInspectionSupplierOption
  71. {
  72. /// <summary>供应商编码(MissedPrint.Supply)</summary>
  73. public string? Val { get; set; }
  74. /// <summary>供应商简称(SuppMaster.SortName)</summary>
  75. public string? Label { get; set; }
  76. }