SalesDeliveryNoticeDto.cs 3.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. namespace Admin.NET.Plugin.AiDOP.FinishedWarehouse.Dto;
  2. /// <summary>
  3. /// S7 销售发货通知(头列表)查询入参(只读)。
  4. ///
  5. /// 数据源:aidopdev.ASNBOLShipperMaster a LEFT JOIN DepartmentMaster b,忠实复刻证据 sql.txt 口径:
  6. /// 业务过滤 a.ShType='SH' AND a.Typed&lt;&gt;'S' AND a.IsActive=1;join b ON a.Department=b.Department AND a.Domain=b.Domain。
  7. /// 头列表粒度(一行一 ASNBOLShipperMaster)。ASNBOLShipperMaster 有 tenant_id:TenantId&gt;0 时追加 a.tenant_id=@TenantId,
  8. /// TenantId&lt;=0 时不加租户过滤;Domain 仅用于 DepartmentMaster join,不做 Domain 占位过滤。
  9. /// 本查询仅 SELECT:不做明细/详情/发货确认/出库/库存事务/新增编辑删除。
  10. /// </summary>
  11. public class SalesDeliveryNoticeListInput
  12. {
  13. /// <summary>页码(从 1 开始)</summary>
  14. public int Page { get; set; } = 1;
  15. /// <summary>每页条数</summary>
  16. public int PageSize { get; set; } = 10;
  17. /// <summary>货运单号/发货单号(ASNBOLShipperMaster.Id,模糊匹配)</summary>
  18. public string? Id { get; set; }
  19. /// <summary>销售单号(ASNBOLShipperMaster.OrdNbr,模糊匹配)</summary>
  20. public string? OrdNbr { get; set; }
  21. /// <summary>部门(ASNBOLShipperMaster.Department 或 DepartmentMaster.Descr,模糊匹配)</summary>
  22. public string? Department { get; set; }
  23. /// <summary>发货日期起(ASNBOLShipperMaster.ShipDate,含当日,yyyy-MM-dd)</summary>
  24. public string? ShipDateFrom { get; set; }
  25. /// <summary>发货日期止(ASNBOLShipperMaster.ShipDate,含当日,yyyy-MM-dd)</summary>
  26. public string? ShipDateTo { get; set; }
  27. /// <summary>排序字段(白名单:deliveryNo/salesOrderNo/dept/deliveryDate/status/remark)</summary>
  28. public string? OrderBy { get; set; }
  29. /// <summary>排序方向(asc/desc,非法回落 desc)</summary>
  30. public string? OrderDir { get; set; }
  31. /// <summary>租户 ID(前端 withAidopTenantParams 注入;&gt;0 时按 a.tenant_id 过滤,&lt;=0 不过滤)</summary>
  32. public long? TenantId { get; set; }
  33. }
  34. /// <summary>
  35. /// S7 销售发货通知(头列表)行(只读)。字段对齐前端列 prop(camelCase),源列见注释(sql.txt / ASNBOLShipperMaster)。
  36. /// </summary>
  37. public class SalesDeliveryNoticeListRow
  38. {
  39. /// <summary>主键(ASNBOLShipperMaster.RecID)</summary>
  40. public int? RecId { get; set; }
  41. /// <summary>发货单号(ASNBOLShipperMaster.Id)</summary>
  42. public string? DeliveryNo { get; set; }
  43. /// <summary>销售单号(ASNBOLShipperMaster.OrdNbr)</summary>
  44. public string? SalesOrderNo { get; set; }
  45. /// <summary>部门(Department + ' ' + DepartmentMaster.Descr)</summary>
  46. public string? Dept { get; set; }
  47. /// <summary>发货日期(ASNBOLShipperMaster.ShipDate)</summary>
  48. public DateTime? DeliveryDate { get; set; }
  49. /// <summary>状态(ASNBOLShipperMaster.Status,raw 展示)</summary>
  50. public string? Status { get; set; }
  51. /// <summary>备注(ASNBOLShipperMaster.Remark)</summary>
  52. public string? Remark { get; set; }
  53. /// <summary>客户(ASNBOLShipperMaster.SoldTo,DTO 保留,前端不展示)</summary>
  54. public string? SoldTo { get; set; }
  55. /// <summary>公司域(ASNBOLShipperMaster.Domain,DTO 保留,前端不展示)</summary>
  56. public string? Domain { get; set; }
  57. /// <summary>发货确认标志(ASNBOLShipperMaster.IsConfirm,DTO 保留,前端不展示)</summary>
  58. public int? IsConfirm { get; set; }
  59. /// <summary>租户 ID(ASNBOLShipperMaster.tenant_id,DTO 保留,前端不展示)</summary>
  60. public long? TenantId { get; set; }
  61. }