| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182 |
- namespace Admin.NET.Plugin.AiDOP.Manufacturing.Dto;
- /// <summary>
- /// S6 模工具台账管理 列表查询入参(只读)。
- ///
- /// 数据源:aidopdev.MoldToolList(模工具台账,证据 sql.txt: select * from MoldToolList)。
- /// 类型(lx) 含 模具 / 工装 / 检具,同表同页同源;类型下拉可筛选。
- /// MoldToolList 有 tenant_id 但 sql.txt 无 WHERE 过滤(旧系统全表查询),本查询亦不据 tenant_id 过滤;
- /// TenantId 仅为前端 withAidopTenantParams 注入的透传参数。
- /// </summary>
- public class ToolingLedgerListInput
- {
- /// <summary>页码(从 1 开始)</summary>
- public int Page { get; set; } = 1;
- /// <summary>每页条数</summary>
- public int PageSize { get; set; } = 10;
- /// <summary>名称(MoldToolList.MoldName,模糊匹配)</summary>
- public string? Name { get; set; }
- /// <summary>工作组(MoldToolList.gnyymc,模糊匹配)</summary>
- public string? WorkGroup { get; set; }
- /// <summary>使用部门(MoldToolList.MoldUsingDepartment,模糊匹配)</summary>
- public string? UsageDept { get; set; }
- /// <summary>类型(MoldToolList.lx:模具 / 工装 / 检具,精确匹配,下拉选择)</summary>
- public string? Type { get; set; }
- /// <summary>模具类型编码(MoldToolList.MoldTypeCode,模糊匹配)</summary>
- public string? MoldTypeCode { get; set; }
- /// <summary>租户 ID(前端 withAidopTenantParams 注入;本查询不据其过滤)</summary>
- public long? TenantId { get; set; }
- }
- /// <summary>
- /// S6 模工具台账管理 列表行(只读)。字段对齐前端列 prop(camelCase),源列见注释(MoldToolList / 字段配置图)。
- /// </summary>
- public class ToolingLedgerListRow
- {
- /// <summary>主键 id(MoldToolList.id,子表 id)</summary>
- public int Id { get; set; }
- /// <summary>类型(MoldToolList.lx:模具 / 工装 / 检具)</summary>
- public string? Type { get; set; }
- /// <summary>名称(MoldToolList.MoldName)</summary>
- public string? Name { get; set; }
- /// <summary>供应商名(MoldToolList.gysmc)</summary>
- public string? SupplierName { get; set; }
- /// <summary>数量(MoldToolList.MoldCount)</summary>
- public int? Qty { get; set; }
- /// <summary>功能应用名称(MoldToolList.gnyymc)</summary>
- public string? FunctionAppName { get; set; }
- /// <summary>模具类型编码(MoldToolList.MoldTypeCode)</summary>
- public string? MoldTypeCode { get; set; }
- /// <summary>对应产品物料编码(MoldToolList.product_material_code)</summary>
- public string? ProductMaterialCode { get; set; }
- /// <summary>对应产品图纸号(MoldToolList.product_drawing_number)</summary>
- public string? ProductDrawingNo { get; set; }
- /// <summary>对应产品名称(MoldToolList.product_name)</summary>
- public string? ProductName { get; set; }
- /// <summary>对应工序(MoldToolList.process)</summary>
- public string? Process { get; set; }
- }
- /// <summary>类型下拉选项(MoldToolList.lx distinct:模具 / 工装 / 检具)。</summary>
- public class ToolingLedgerTypeOption
- {
- /// <summary>类型值(MoldToolList.lx)</summary>
- public string? Val { get; set; }
- }
|