op.get - 製程基本資料 | eMES API 規格書

基本資訊

API 名稱

op.get

方法名稱

upOperationCROSS

目標資料表

OPERATION

JSON 節點

op_data

主鍵

ERP_OPID + ERP_WSID（複合）

程式位置

RegularESB.java:2230

回應欄位

ERP 欄位	MES 欄位	說明
`op_no`	ERP_OPID	製程編號
`workstation_no`	ERP_WSID	工作站編號
`op_no + "---" + workstation_no`	ID	複合 ID
`op_name`	NAME	製程名稱
`description`	DESCRIPTION	製程描述
`outsourcing_type`	COMPLEXION	Y→2(委外), N→1(內製)
`tran_status`	TRAN_STATUS	交易狀態

回應範例

{
  "op_data": [
    {
      "op_no": "OP001",
      "workstation_no": "WS001",
      "op_name": "組裝作業",
      "description": "主板組裝",
      "outsourcing_type": "N",
      "modify_no": "USER001",
      "tran_status": "AU"
    }
  ]
}

處理邏輯

ID 組合規則

OPERATION.ID = op_no + "---" + workstation_no
例如：OP001---WS001

委外標記轉換

outsourcing_type = "Y" → COMPLEXION = 2（委外製程）
outsourcing_type = "N" → COMPLEXION = 1（內製製程）

資料庫更新 SQL

判斷新增或修改

SELECT COUNT(1) FROM OPERATION
WHERE ERP_OPID = N'{op_no}' AND ERP_WSID = N'{workstation_no}'
-- count > 0 → UPDATE, count = 0 → INSERT

INSERT（新增製程）

INSERT INTO OPERATION (
    ID, NAME, DESCRIPTION, COMPLEXION,
    ERP_OPID, WORKSTATIONID, ERP_WSID,
    LASTMAINTAINUSER, LASTMAINTAINDATETIME, FLAG
) VALUES (
    :Opid---:Wsid,          -- 複合 ID
    :Opname,
    :Opdescription,
    :Opcomplexion,          -- 1=內製, 2=委外
    :Opid,
    :Wsid,
    :Wsid,
    :userid,
    N'{當前時間}',
    0
)

UPDATE（修改製程）

UPDATE OPERATION SET
    ID = :newid,
    NAME = :Opname,
    DESCRIPTION = :Opdescription,
    COMPLEXION = :Opcomplexion,
    ERP_OPID = :Opid,
    WORKSTATIONID = :Wsid,
    ERP_WSID = :Wsid,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{當前時間}',
    FLAG = (SELECT MAX(FLAG)+1 FROM OPERATION
            WHERE ERP_OPID = :Opid AND ERP_WSID = :Wsid)
WHERE ID IN (:id)