主表字段
|
测试时间(年、月、日),测试时间(时、分、秒),测试结果(固定为三种:0:0:1;0:测试为OK,0;0;0:1:测试为Fail,T面(分Top(上)面/Bottom(下)面),测试点数,实际不良,设备型号,批次工单,机种名,条码,SMT组别,线别
|
|
子表字段
|
偏位,缺件,反向,翘起,浮高,立碑,翻转,错件,翘脚,虚焊,空焊,少锡,多锡,连锡,漏铜,拉尖,异物,溢胶,引脚偏位,生产线名称,机器名称,投入板数,OK板数,通过板数,合格率,不良板数,不良率,不良率(PPM),不良点数,实测点数,待测点数
|
|
执行目标
|
- 将 `MES.Service/service/QC/SPIAOI.txt`:1-7 中的 SPI/AOI 检测字段转化为一个可调用的 REST API，并补充数据库建表与持久化逻辑。
|
- 目标覆盖请求契约、数据校验、主从表建模、存储过程/服务保存流程以及异常与日志处理。
|
|
数据结构拆解
|
- `主表字段` → 记录单次 SPI/AOI 检测的头信息。建议字段/类型：
|
测试日期(`TestDate`/DATE)、测试时间(`TestTime`/VARCHAR2(8 CHAR))、测试结果(`TestResult`/VARCHAR2(12 CHAR)，值域：`0:0:1;0`、`0;0;0:1`、`Fail`)、面别(`Surface`/CHAR(1)，值域 `T`/`B`)、测试点数(`TotalPoints`/NUMBER(6))、实际不良点数(`ActualDefects`/NUMBER(6))、设备型号(`EquipmentModel`/VARCHAR2(64 CHAR))、批次工单(`WorkOrder`/VARCHAR2(64 CHAR))、机种名(`ProductModel`/VARCHAR2(64 CHAR))、条码(`BoardBarcode`/VARCHAR2(128 CHAR))、SMT 组别(`SmtGroup`/VARCHAR2(32 CHAR))、线别(`LineName`/VARCHAR2(32 CHAR))。
|
- `子表字段` → 记录单次检测的缺陷统计。建议字段/类型：
|
偏位(`OffsetCount`/NUMBER(6))、缺件(`MissingCount`/NUMBER(6))、反向(`ReverseCount`/NUMBER(6))、翘起(`LiftedCount`/NUMBER(6))、浮高(`FloatHighCount`/NUMBER(6))、立碑(`TombstoneCount`/NUMBER(6))、翻转(`FlipCount`/NUMBER(6))、错件(`WrongPartCount`/NUMBER(6))、翘脚(`LeadLiftCount`/NUMBER(6))、虚焊(`ColdJointCount`/NUMBER(6))、空焊(`NoSolderCount`/NUMBER(6))、少锡(`InsufficientSolderCount`/NUMBER(6))、多锡(`ExcessSolderCount`/NUMBER(6))、连锡(`BridgeCount`/NUMBER(6))、漏铜(`CopperExposureCount`/NUMBER(6))、拉尖(`SpikeCount`/NUMBER(6))、异物(`ForeignMatterCount`/NUMBER(6))、溢胶(`GlueOverflowCount`/NUMBER(6))、引脚偏位(`PinOffsetCount`/NUMBER(6))、生产线名称(`LineDisplayName`/VARCHAR2(64 CHAR))、机器名称(`MachineName`/VARCHAR2(64 CHAR))、投入板数(`InputBoards`/NUMBER(6))、OK板数(`OkBoards`/NUMBER(6))、通过板数(`PassBoards`/NUMBER(6))、合格率(`PassRate`/NUMBER(5,2))、不良板数(`DefectBoards`/NUMBER(6))、不良率(`DefectRate`/NUMBER(5,2))、不良率PPM(`DefectPpm`/NUMBER(9))、不良点数(`DefectPoints`/NUMBER(6))、实测点数(`MeasuredPoints`/NUMBER(6))、待测点数(`PendingPoints`/NUMBER(6))。所有“率”字段以百分比存储，入库前转为数值型。
|
|
数据库设计
|
- 目标库为 Oracle 11g（11.2），本项目使用 `SqlSugar` 并通过 `[SugarColumn(OracleSequenceName = "...")]` 自动取号，因此只需声明主键和序列，无需触发器。示例 DDL：
|
```
|
-- 主表：记录每块电路板的 SPI/AOI 批次检测摘要数据
|
-- SPI/AOI 主表，记录单板批次检测摘要
|
CREATE TABLE MES_SPI_AOI_HEADER (
|
ID NUMBER(19) NOT NULL,
|
TEST_DATE DATE NOT NULL,
|
TEST_TIME VARCHAR2(8 CHAR) NOT NULL,
|
TEST_RESULT VARCHAR2(12 CHAR) NOT NULL,
|
SURFACE CHAR(1) NOT NULL CHECK (SURFACE IN ('T','B')),
|
TOTAL_POINTS NUMBER(6),
|
ACTUAL_DEFECTS NUMBER(6),
|
EQUIPMENT_MODEL VARCHAR2(64 CHAR),
|
WORK_ORDER VARCHAR2(64 CHAR),
|
PRODUCT_MODEL VARCHAR2(64 CHAR),
|
BOARD_BARCODE VARCHAR2(128 CHAR) NOT NULL,
|
SMT_GROUP VARCHAR2(32 CHAR),
|
LINE_NAME VARCHAR2(32 CHAR),
|
CREATED_AT TIMESTAMP DEFAULT SYSTIMESTAMP,
|
UPDATED_AT TIMESTAMP DEFAULT SYSTIMESTAMP
|
);
|
ALTER TABLE MES_SPI_AOI_HEADER
|
ADD CONSTRAINT PK_SPI_AOI_HEADER PRIMARY KEY (ID);
|
CREATE UNIQUE INDEX IDX_SPI_AOI_BARCODE ON MES_SPI_AOI_HEADER (BOARD_BARCODE);
|
|
COMMENT ON TABLE MES_SPI_AOI_HEADER IS 'SPI/AOI 主表，记录单板检测摘要数据';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.ID IS '主键ID，由序列 SEQ_SPI_AOI_HEADER 生成';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.TEST_DATE IS '测试日期，沿用设备上传的年月日';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.TEST_TIME IS '测试时间，沿用设备上传的 HH:mm:ss';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.TEST_RESULT IS '测试结果原始字符串，例如 0:0:1;0、0;0;0:1、Fail';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.SURFACE IS '检测面，T=Top 顶面，B=Bottom 底面';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.TOTAL_POINTS IS '计划检测点数';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.ACTUAL_DEFECTS IS '实际不良点数';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.EQUIPMENT_MODEL IS '设备型号';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.WORK_ORDER IS '对应工单或批次号';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.PRODUCT_MODEL IS '机种名称';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.BOARD_BARCODE IS '板件条码，整单唯一';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.SMT_GROUP IS 'SMT 组别';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.LINE_NAME IS '线别名称';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.CREATED_AT IS '创建时间，默认写入数据库时间戳';
|
COMMENT ON COLUMN MES_SPI_AOI_HEADER.UPDATED_AT IS '更新时间，默认写入数据库时间戳';
|
|
CREATE SEQUENCE SEQ_SPI_AOI_HEADER START WITH 1 INCREMENT BY 1 NOCACHE;
|
|
-- SPI/AOI 明细表，拆分缺陷统计与产能指标
|
CREATE TABLE MES_SPI_AOI_DETAIL (
|
ID NUMBER(19) NOT NULL,
|
HEADER_ID NUMBER(19) NOT NULL,
|
OFFSET_COUNT NUMBER(6) DEFAULT 0,
|
MISSING_COUNT NUMBER(6) DEFAULT 0,
|
REVERSE_COUNT NUMBER(6) DEFAULT 0,
|
LIFTED_COUNT NUMBER(6) DEFAULT 0,
|
FLOAT_HIGH_COUNT NUMBER(6) DEFAULT 0,
|
TOMBSTONE_COUNT NUMBER(6) DEFAULT 0,
|
FLIP_COUNT NUMBER(6) DEFAULT 0,
|
WRONG_PART_COUNT NUMBER(6) DEFAULT 0,
|
LEAD_LIFT_COUNT NUMBER(6) DEFAULT 0,
|
COLD_JOINT_COUNT NUMBER(6) DEFAULT 0,
|
NO_SOLDER_COUNT NUMBER(6) DEFAULT 0,
|
INSUFFICIENT_SOLDER_COUNT NUMBER(6) DEFAULT 0,
|
EXCESS_SOLDER_COUNT NUMBER(6) DEFAULT 0,
|
BRIDGE_COUNT NUMBER(6) DEFAULT 0,
|
COPPER_EXPOSURE_COUNT NUMBER(6) DEFAULT 0,
|
SPIKE_COUNT NUMBER(6) DEFAULT 0,
|
FOREIGN_MATTER_COUNT NUMBER(6) DEFAULT 0,
|
GLUE_OVERFLOW_COUNT NUMBER(6) DEFAULT 0,
|
PIN_OFFSET_COUNT NUMBER(6) DEFAULT 0,
|
LINE_DISPLAY_NAME VARCHAR2(64 CHAR),
|
MACHINE_NAME VARCHAR2(64 CHAR),
|
INPUT_BOARDS NUMBER(6) DEFAULT 0,
|
OK_BOARDS NUMBER(6) DEFAULT 0,
|
PASS_BOARDS NUMBER(6) DEFAULT 0,
|
PASS_RATE NUMBER(5,2),
|
DEFECT_BOARDS NUMBER(6) DEFAULT 0,
|
DEFECT_RATE NUMBER(5,2),
|
DEFECT_PPM NUMBER(9),
|
DEFECT_POINTS NUMBER(6) DEFAULT 0,
|
MEASURED_POINTS NUMBER(6) DEFAULT 0,
|
PENDING_POINTS NUMBER(6) DEFAULT 0,
|
CREATED_AT TIMESTAMP DEFAULT SYSTIMESTAMP,
|
UPDATED_AT TIMESTAMP DEFAULT SYSTIMESTAMP
|
);
|
ALTER TABLE MES_SPI_AOI_DETAIL
|
ADD CONSTRAINT PK_SPI_AOI_DETAIL PRIMARY KEY (ID);
|
ALTER TABLE MES_SPI_AOI_DETAIL
|
ADD CONSTRAINT FK_SPI_AOI_DETAIL_HEADER FOREIGN KEY (HEADER_ID)
|
REFERENCES MES_SPI_AOI_HEADER(ID);
|
|
CREATE INDEX IDX_SPI_AOI_DETAIL_HEADER ON MES_SPI_AOI_DETAIL (HEADER_ID);
|
|
COMMENT ON TABLE MES_SPI_AOI_DETAIL IS 'SPI/AOI 明细表，记录缺陷分类统计与产线效率数据';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.ID IS '主键ID，由序列 SEQ_SPI_AOI_DETAIL 生成';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.HEADER_ID IS '主表外键，指向 MES_SPI_AOI_HEADER.ID';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.OFFSET_COUNT IS '偏位数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.MISSING_COUNT IS '缺件数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.REVERSE_COUNT IS '反向安装数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.LIFTED_COUNT IS '翘起数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.FLOAT_HIGH_COUNT IS '浮高数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.TOMBSTONE_COUNT IS '立碑数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.FLIP_COUNT IS '翻转数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.WRONG_PART_COUNT IS '错件数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.LEAD_LIFT_COUNT IS '翘脚数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.COLD_JOINT_COUNT IS '虚焊数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.NO_SOLDER_COUNT IS '空焊数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.INSUFFICIENT_SOLDER_COUNT IS '少锡数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.EXCESS_SOLDER_COUNT IS '多锡数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.BRIDGE_COUNT IS '连锡数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.COPPER_EXPOSURE_COUNT IS '漏铜数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.SPIKE_COUNT IS '拉尖数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.FOREIGN_MATTER_COUNT IS '异物残留数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.GLUE_OVERFLOW_COUNT IS '溢胶数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.PIN_OFFSET_COUNT IS '引脚偏位数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.LINE_DISPLAY_NAME IS '产线显示名称';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.MACHINE_NAME IS '检测机台名称';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.INPUT_BOARDS IS '投入板数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.OK_BOARDS IS 'OK 板数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.PASS_BOARDS IS '通过板数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.PASS_RATE IS '合格率（%）';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.DEFECT_BOARDS IS '不良板数量';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.DEFECT_RATE IS '不良率（%）';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.DEFECT_PPM IS '不良数（PPM）';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.DEFECT_POINTS IS '不良点数';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.MEASURED_POINTS IS '实测点数';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.PENDING_POINTS IS '待测点数';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.CREATED_AT IS '创建时间，默认写入数据库时间戳';
|
COMMENT ON COLUMN MES_SPI_AOI_DETAIL.UPDATED_AT IS '更新时间，默认写入数据库时间戳';
|
|
CREATE SEQUENCE SEQ_SPI_AOI_DETAIL START WITH 1 INCREMENT BY 1 NOCACHE;
|
|
测试结果说明
|
- `TestResult` 字段直接接收原始字符串，不做枚举校验
|
- 常见值参考：
|
- "0:0:1;0" (通常表示测试通过)
|
- "0;0;0:1" (通常表示测试失败)
|
- "Fail" (通常表示测试异常)
|
- 数据库存储原始值，由业务层根据需要解析
|
|
接口设计
|
- URL：`POST /api/QC/SpiAoi/Upload`（位于 `MESApplication.Controllers.QC` 命名空间，沿用 `ResponseResult` 返回格式）。
|
- 请求体结构：
|
```
|
{
|
"header": {
|
"testDate": "2025-10-10",
|
"testTime": "14:33:21",
|
"testResult": "0;0;0:1",
|
"surface": "T",
|
"totalPoints": 500,
|
"actualDefects": 3,
|
"equipmentModel": "SPI-9000",
|
"workOrder": "WO20251010-01",
|
"productModel": "MODEL-ABC",
|
"boardBarcode": "BC123456789",
|
"smtGroup": "A1",
|
"lineName": "SMT-01"
|
},
|
"details": [
|
{
|
"machineName": "AOI-01",
|
"lineDisplayName": "SMT-01",
|
"offsetCount": 1,
|
"missingCount": 0,
|
"reverseCount": 0,
|
"liftedCount": 0,
|
"floatHighCount": 0,
|
"tombstoneCount": 0,
|
"flipCount": 0,
|
"wrongPartCount": 0,
|
"leadLiftCount": 0,
|
"coldJointCount": 0,
|
"noSolderCount": 0,
|
"insufficientSolderCount": 1,
|
"excessSolderCount": 0,
|
"bridgeCount": 1,
|
"copperExposureCount": 0,
|
"spikeCount": 0,
|
"foreignMatterCount": 0,
|
"glueOverflowCount": 0,
|
"pinOffsetCount": 0,
|
"inputBoards": 120,
|
"okBoards": 117,
|
"passBoards": 117,
|
"passRate": 97.5,
|
"defectBoards": 3,
|
"defectRate": 2.5,
|
"defectPpm": 25000,
|
"defectPoints": 3,
|
"measuredPoints": 500,
|
"pendingPoints": 0
|
}
|
]
|
}
|
```
|
- 响应示例：
|
```
|
{
|
"status": 0,
|
"message": "OK",
|
"data": { "headerId": 12345 }
|
}
|
```
|
|
业务处理流程
|
- 入口控制器负责模型绑定与基本校验：
|
- 必填字段：testDate、testTime、testResult、boardBarcode、surface
|
- 枚举合法性：surface 必须为 "T" 或 "B"
|
- testResult：不做枚举校验，直接接收原始字符串
|
- 数值非负：所有计数字段必须 >= 0
|
- **details 不能为空或 null**
|
- 将请求委托给 `SpiAoiService`（位于 `MES.Service.service.QC`），该服务使用 `SqlSugarClient` 启动事务：
|
1. **条码唯一性检测**：若 `BOARD_BARCODE` 已存在，直接返回错误 `status=1, message="条码已存在，不允许重复上传"`（保持唯一索引约束）。
|
2. 插入头表记录，返回 `HEADER_ID`（实体通过 `[SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_SPI_AOI_HEADER")]` 自动获取序列值）。
|
3. 遍历 `details`，为每条填充 `HEADER_ID` 并插入子表。
|
4. **衍生字段校验**（记录日志但不阻断）：
|
- `passBoards <= inputBoards`
|
- `defectBoards = inputBoards - passBoards`
|
- `passRate` 与计算值 `(passBoards / inputBoards * 100)` 的偏差在 ±1.0 以内
|
- 若校验失败，记录警告日志但不回滚事务
|
5. 提交事务；异常则回滚并记录日志。
|
- 成功后返回 `headerId`；失败返回 `status=1` 与错误信息。
|
|
验证与错误处理
|
- **输入校验失败**：返回 `status=1`，`message` 指明字段及原因（如："boardBarcode 不能为空"、"surface 必须为 T 或 B"）。
|
- **条码重复**：返回 `status=1, message="条码 {boardBarcode} 已存在，不允许重复上传"`。
|
- **details 为空**：返回 `status=1, message="details 不能为空"`。
|
- **数据库异常**：捕获 `SqlSugar`/Oracle 异常，记录到现有日志（如 `LogUtil`），同时写入消息中心（若需 ERP 同步）或自定义错误队列。
|
|
实体定义示例
|
```csharp
|
[SugarTable("MES_SPI_AOI_HEADER")]
|
public class SpiAoiHeader
|
{
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_SPI_AOI_HEADER")]
|
public long Id { get; set; }
|
|
[SugarColumn(ColumnName = "TEST_DATE")]
|
public DateTime TestDate { get; set; }
|
|
[SugarColumn(ColumnName = "TEST_TIME")]
|
public string TestTime { get; set; }
|
|
[SugarColumn(ColumnName = "TEST_RESULT")]
|
public string TestResult { get; set; }
|
|
[SugarColumn(ColumnName = "SURFACE")]
|
public string Surface { get; set; }
|
|
[SugarColumn(ColumnName = "TOTAL_POINTS")]
|
public int? TotalPoints { get; set; }
|
|
[SugarColumn(ColumnName = "ACTUAL_DEFECTS")]
|
public int? ActualDefects { get; set; }
|
|
[SugarColumn(ColumnName = "EQUIPMENT_MODEL")]
|
public string EquipmentModel { get; set; }
|
|
[SugarColumn(ColumnName = "WORK_ORDER")]
|
public string WorkOrder { get; set; }
|
|
[SugarColumn(ColumnName = "PRODUCT_MODEL")]
|
public string ProductModel { get; set; }
|
|
[SugarColumn(ColumnName = "BOARD_BARCODE")]
|
public string BoardBarcode { get; set; }
|
|
[SugarColumn(ColumnName = "SMT_GROUP")]
|
public string SmtGroup { get; set; }
|
|
[SugarColumn(ColumnName = "LINE_NAME")]
|
public string LineName { get; set; }
|
|
[SugarColumn(ColumnName = "CREATED_AT")]
|
public DateTime CreatedAt { get; set; }
|
|
[SugarColumn(ColumnName = "UPDATED_AT")]
|
public DateTime UpdatedAt { get; set; }
|
}
|
|
[SugarTable("MES_SPI_AOI_DETAIL")]
|
public class SpiAoiDetail
|
{
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_SPI_AOI_DETAIL")]
|
public long Id { get; set; }
|
|
[SugarColumn(ColumnName = "HEADER_ID")]
|
public long HeaderId { get; set; }
|
|
[SugarColumn(ColumnName = "OFFSET_COUNT")]
|
public int OffsetCount { get; set; }
|
|
[SugarColumn(ColumnName = "MISSING_COUNT")]
|
public int MissingCount { get; set; }
|
|
[SugarColumn(ColumnName = "REVERSE_COUNT")]
|
public int ReverseCount { get; set; }
|
|
[SugarColumn(ColumnName = "LIFTED_COUNT")]
|
public int LiftedCount { get; set; }
|
|
[SugarColumn(ColumnName = "FLOAT_HIGH_COUNT")]
|
public int FloatHighCount { get; set; }
|
|
[SugarColumn(ColumnName = "TOMBSTONE_COUNT")]
|
public int TombstoneCount { get; set; }
|
|
[SugarColumn(ColumnName = "FLIP_COUNT")]
|
public int FlipCount { get; set; }
|
|
[SugarColumn(ColumnName = "WRONG_PART_COUNT")]
|
public int WrongPartCount { get; set; }
|
|
[SugarColumn(ColumnName = "LEAD_LIFT_COUNT")]
|
public int LeadLiftCount { get; set; }
|
|
[SugarColumn(ColumnName = "COLD_JOINT_COUNT")]
|
public int ColdJointCount { get; set; }
|
|
[SugarColumn(ColumnName = "NO_SOLDER_COUNT")]
|
public int NoSolderCount { get; set; }
|
|
[SugarColumn(ColumnName = "INSUFFICIENT_SOLDER_COUNT")]
|
public int InsufficientSolderCount { get; set; }
|
|
[SugarColumn(ColumnName = "EXCESS_SOLDER_COUNT")]
|
public int ExcessSolderCount { get; set; }
|
|
[SugarColumn(ColumnName = "BRIDGE_COUNT")]
|
public int BridgeCount { get; set; }
|
|
[SugarColumn(ColumnName = "COPPER_EXPOSURE_COUNT")]
|
public int CopperExposureCount { get; set; }
|
|
[SugarColumn(ColumnName = "SPIKE_COUNT")]
|
public int SpikeCount { get; set; }
|
|
[SugarColumn(ColumnName = "FOREIGN_MATTER_COUNT")]
|
public int ForeignMatterCount { get; set; }
|
|
[SugarColumn(ColumnName = "GLUE_OVERFLOW_COUNT")]
|
public int GlueOverflowCount { get; set; }
|
|
[SugarColumn(ColumnName = "PIN_OFFSET_COUNT")]
|
public int PinOffsetCount { get; set; }
|
|
[SugarColumn(ColumnName = "LINE_DISPLAY_NAME")]
|
public string LineDisplayName { get; set; }
|
|
[SugarColumn(ColumnName = "MACHINE_NAME")]
|
public string MachineName { get; set; }
|
|
[SugarColumn(ColumnName = "INPUT_BOARDS")]
|
public int InputBoards { get; set; }
|
|
[SugarColumn(ColumnName = "OK_BOARDS")]
|
public int OkBoards { get; set; }
|
|
[SugarColumn(ColumnName = "PASS_BOARDS")]
|
public int PassBoards { get; set; }
|
|
[SugarColumn(ColumnName = "PASS_RATE")]
|
public decimal? PassRate { get; set; }
|
|
[SugarColumn(ColumnName = "DEFECT_BOARDS")]
|
public int DefectBoards { get; set; }
|
|
[SugarColumn(ColumnName = "DEFECT_RATE")]
|
public decimal? DefectRate { get; set; }
|
|
[SugarColumn(ColumnName = "DEFECT_PPM")]
|
public int? DefectPpm { get; set; }
|
|
[SugarColumn(ColumnName = "DEFECT_POINTS")]
|
public int DefectPoints { get; set; }
|
|
[SugarColumn(ColumnName = "MEASURED_POINTS")]
|
public int MeasuredPoints { get; set; }
|
|
[SugarColumn(ColumnName = "PENDING_POINTS")]
|
public int PendingPoints { get; set; }
|
|
[SugarColumn(ColumnName = "CREATED_AT")]
|
public DateTime CreatedAt { get; set; }
|
|
[SugarColumn(ColumnName = "UPDATED_AT")]
|
public DateTime UpdatedAt { get; set; }
|
}
|
```
|
|
实现步骤建议
|
1. **创建数据库表**：执行上述 DDL，创建 `MES_SPI_AOI_HEADER`、`MES_SPI_AOI_DETAIL` 表及序列。
|
2. **定义实体模型**：在 `MES.Service.Modes` 下创建 `SpiAoiHeader.cs` 和 `SpiAoiDetail.cs`（参考上述实体定义示例）。
|
3. **创建 DTO**：
|
- `SpiAoiHeaderDto.cs`（用于请求体 header 部分）
|
- `SpiAoiDetailDto.cs`（用于请求体 details 数组元素）
|
- `SpiAoiUploadRequest.cs`（包含 Header 和 Details 列表）
|
- `SpiAoiUploadResponse.cs`（包含 headerId）
|
4. **实现服务层**：
|
- 在 `MES.Service.service.QC` 下创建 `SpiAoiService.cs`
|
- 实现条码唯一性检查、事务插入、数据校验等业务逻辑
|
5. **实现控制器**：
|
- 在 `MESApplication.Controllers.QC` 下创建 `SpiAoiController.cs`
|
- 添加 `[HttpPost("Upload")]` 方法，调用服务层并返回 `ResponseResult`
|
6. **添加单元测试**（可选）：验证成功插入、非法枚举、条码重复、details 为空、事务回滚等场景。
|
|
注意事项
|
- 所有字符串字段需检查长度是否超过数据库定义（如 `BOARD_BARCODE` 最大 128 字符）。
|
- `TestDate` 和 `TestTime` 分开存储，前端需分别传入日期和时间字符串。
|
- `TestResult` 不做枚举校验，接收任意字符串值（最大 12 字符），原样存储到数据库。
|
- 对于 `CREATED_AT` 和 `UPDATED_AT`，建议在代码中显式赋值 `DateTime.Now`，而非依赖数据库默认值。
|
- Oracle 11g 需确保 SqlSugar 版本兼容（推荐 5.x 或更高版本）。
|
- 条码唯一索引 `IDX_SPI_AOI_BARCODE` 会自动阻止重复插入，但建议在代码中提前检查并返回友好错误信息。
|
