| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182 |
- namespace Admin.NET.Plugin.AiDOP.FinishedWarehouse.Dto;
- /// <summary>
- /// S7 销售发货通知(头列表)查询入参(只读)。
- ///
- /// 数据源:aidopdev.ASNBOLShipperMaster a LEFT JOIN DepartmentMaster b,忠实复刻证据 sql.txt 口径:
- /// 业务过滤 a.ShType='SH' AND a.Typed<>'S' AND a.IsActive=1;join b ON a.Department=b.Department AND a.Domain=b.Domain。
- /// 头列表粒度(一行一 ASNBOLShipperMaster)。ASNBOLShipperMaster 有 tenant_id:TenantId>0 时追加 a.tenant_id=@TenantId,
- /// TenantId<=0 时不加租户过滤;Domain 仅用于 DepartmentMaster join,不做 Domain 占位过滤。
- /// 本查询仅 SELECT:不做明细/详情/发货确认/出库/库存事务/新增编辑删除。
- /// </summary>
- public class SalesDeliveryNoticeListInput
- {
- /// <summary>页码(从 1 开始)</summary>
- public int Page { get; set; } = 1;
- /// <summary>每页条数</summary>
- public int PageSize { get; set; } = 10;
- /// <summary>货运单号/发货单号(ASNBOLShipperMaster.Id,模糊匹配)</summary>
- public string? Id { get; set; }
- /// <summary>销售单号(ASNBOLShipperMaster.OrdNbr,模糊匹配)</summary>
- public string? OrdNbr { get; set; }
- /// <summary>部门(ASNBOLShipperMaster.Department 或 DepartmentMaster.Descr,模糊匹配)</summary>
- public string? Department { get; set; }
- /// <summary>发货日期起(ASNBOLShipperMaster.ShipDate,含当日,yyyy-MM-dd)</summary>
- public string? ShipDateFrom { get; set; }
- /// <summary>发货日期止(ASNBOLShipperMaster.ShipDate,含当日,yyyy-MM-dd)</summary>
- public string? ShipDateTo { get; set; }
- /// <summary>排序字段(白名单:deliveryNo/salesOrderNo/dept/deliveryDate/status/remark)</summary>
- public string? OrderBy { get; set; }
- /// <summary>排序方向(asc/desc,非法回落 desc)</summary>
- public string? OrderDir { get; set; }
- /// <summary>租户 ID(前端 withAidopTenantParams 注入;>0 时按 a.tenant_id 过滤,<=0 不过滤)</summary>
- public long? TenantId { get; set; }
- }
- /// <summary>
- /// S7 销售发货通知(头列表)行(只读)。字段对齐前端列 prop(camelCase),源列见注释(sql.txt / ASNBOLShipperMaster)。
- /// </summary>
- public class SalesDeliveryNoticeListRow
- {
- /// <summary>主键(ASNBOLShipperMaster.RecID)</summary>
- public int? RecId { get; set; }
- /// <summary>发货单号(ASNBOLShipperMaster.Id)</summary>
- public string? DeliveryNo { get; set; }
- /// <summary>销售单号(ASNBOLShipperMaster.OrdNbr)</summary>
- public string? SalesOrderNo { get; set; }
- /// <summary>部门(Department + ' ' + DepartmentMaster.Descr)</summary>
- public string? Dept { get; set; }
- /// <summary>发货日期(ASNBOLShipperMaster.ShipDate)</summary>
- public DateTime? DeliveryDate { get; set; }
- /// <summary>状态(ASNBOLShipperMaster.Status,raw 展示)</summary>
- public string? Status { get; set; }
- /// <summary>备注(ASNBOLShipperMaster.Remark)</summary>
- public string? Remark { get; set; }
- /// <summary>客户(ASNBOLShipperMaster.SoldTo,DTO 保留,前端不展示)</summary>
- public string? SoldTo { get; set; }
- /// <summary>公司域(ASNBOLShipperMaster.Domain,DTO 保留,前端不展示)</summary>
- public string? Domain { get; set; }
- /// <summary>发货确认标志(ASNBOLShipperMaster.IsConfirm,DTO 保留,前端不展示)</summary>
- public int? IsConfirm { get; set; }
- /// <summary>租户 ID(ASNBOLShipperMaster.tenant_id,DTO 保留,前端不展示)</summary>
- public long? TenantId { get; set; }
- }
|