ToolingLedgerDto.cs 3.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. namespace Admin.NET.Plugin.AiDOP.Manufacturing.Dto;
  2. /// <summary>
  3. /// S6 模工具台账管理 列表查询入参(只读)。
  4. ///
  5. /// 数据源:aidopdev.MoldToolList(模工具台账,证据 sql.txt: select * from MoldToolList)。
  6. /// 类型(lx) 含 模具 / 工装 / 检具,同表同页同源;类型下拉可筛选。
  7. /// MoldToolList 有 tenant_id 但 sql.txt 无 WHERE 过滤(旧系统全表查询),本查询亦不据 tenant_id 过滤;
  8. /// TenantId 仅为前端 withAidopTenantParams 注入的透传参数。
  9. /// </summary>
  10. public class ToolingLedgerListInput
  11. {
  12. /// <summary>页码(从 1 开始)</summary>
  13. public int Page { get; set; } = 1;
  14. /// <summary>每页条数</summary>
  15. public int PageSize { get; set; } = 10;
  16. /// <summary>名称(MoldToolList.MoldName,模糊匹配)</summary>
  17. public string? Name { get; set; }
  18. /// <summary>工作组(MoldToolList.gnyymc,模糊匹配)</summary>
  19. public string? WorkGroup { get; set; }
  20. /// <summary>使用部门(MoldToolList.MoldUsingDepartment,模糊匹配)</summary>
  21. public string? UsageDept { get; set; }
  22. /// <summary>类型(MoldToolList.lx:模具 / 工装 / 检具,精确匹配,下拉选择)</summary>
  23. public string? Type { get; set; }
  24. /// <summary>模具类型编码(MoldToolList.MoldTypeCode,模糊匹配)</summary>
  25. public string? MoldTypeCode { get; set; }
  26. /// <summary>租户 ID(前端 withAidopTenantParams 注入;本查询不据其过滤)</summary>
  27. public long? TenantId { get; set; }
  28. }
  29. /// <summary>
  30. /// S6 模工具台账管理 列表行(只读)。字段对齐前端列 prop(camelCase),源列见注释(MoldToolList / 字段配置图)。
  31. /// </summary>
  32. public class ToolingLedgerListRow
  33. {
  34. /// <summary>主键 id(MoldToolList.id,子表 id)</summary>
  35. public int Id { get; set; }
  36. /// <summary>类型(MoldToolList.lx:模具 / 工装 / 检具)</summary>
  37. public string? Type { get; set; }
  38. /// <summary>名称(MoldToolList.MoldName)</summary>
  39. public string? Name { get; set; }
  40. /// <summary>供应商名(MoldToolList.gysmc)</summary>
  41. public string? SupplierName { get; set; }
  42. /// <summary>数量(MoldToolList.MoldCount)</summary>
  43. public int? Qty { get; set; }
  44. /// <summary>功能应用名称(MoldToolList.gnyymc)</summary>
  45. public string? FunctionAppName { get; set; }
  46. /// <summary>模具类型编码(MoldToolList.MoldTypeCode)</summary>
  47. public string? MoldTypeCode { get; set; }
  48. /// <summary>对应产品物料编码(MoldToolList.product_material_code)</summary>
  49. public string? ProductMaterialCode { get; set; }
  50. /// <summary>对应产品图纸号(MoldToolList.product_drawing_number)</summary>
  51. public string? ProductDrawingNo { get; set; }
  52. /// <summary>对应产品名称(MoldToolList.product_name)</summary>
  53. public string? ProductName { get; set; }
  54. /// <summary>对应工序(MoldToolList.process)</summary>
  55. public string? Process { get; set; }
  56. }
  57. /// <summary>类型下拉选项(MoldToolList.lx distinct:模具 / 工装 / 检具)。</summary>
  58. public class ToolingLedgerTypeOption
  59. {
  60. /// <summary>类型值(MoldToolList.lx)</summary>
  61. public string? Val { get; set; }
  62. }