工單狀態變更

{
  "CompanyId": "COMP01",
  "lang": "zh_TW",
  "wo_no": "5101-20260319001",
  "status": "1"  // 刪除
}

{
  "CompanyId": "COMP01",
  "lang": "zh_TW",
  "wo_no": "5101-20260319001",
  "status": "2"  // 結案
}

{
  "CompanyId": "COMP01",
  "lang": "zh_TW",
  "wo_no": "5101-20260319001",
  "status": "3"  // 取消結案
}

{
  "code": "200",
  "msg": "success"
}

{
  "code": "500",
  "msg": "JS_0126_00062"
}

{
  "code": "500",
  "msg": "JS_0115_00014"
}

{
  "code": "500",
  "msg": "JS_0126_00059"
}

-- 檢查是否已發放（已發放則不可刪除）
SELECT COUNT(*) FROM SFT_WS_RUN WITH (NOLOCK)
WHERE ID = N'{wo_no}'
  AND EXECUTETYPE = 'release'
  AND PLUSINDEX = '0'
-- 若 COUNT > 0，拋出 JS_0126_00062

-- 檢查是否有拆批記錄
SELECT COUNT(*) FROM SFT_BATCH_REC WHERE BR001 = N'{wo_no}'
-- 若 COUNT > 0，拋出 remind_004

-- 刪除相關資料（依序執行）
DELETE FROM SFT_OP_REALRUN WHERE ID = :CMOID
DELETE FROM LOT WHERE MOID = :CMOID
DELETE FROM MODETAIL WHERE CMOID = :CMOID
DELETE FROM SFT_SPEC_MODIREC WHERE MD001 = :CMOID
DELETE FROM SFT_BATCH_REC WHERE BR002 = :CMOID
DELETE FROM EQUIPMENT_RUN WHERE LOTID = :CMOID
DELETE FROM SFT_WS_RUN WHERE ID = :CMOID
DELETE FROM SFT_SPLITOUT_REC WHERE SSR001 = :CMOID
DELETE FROM SFT_ASSEMBLY_REC WHERE SAR001 = :CMOID
DELETE FROM SFT_HOLD_REC WHERE HR001 = :CMOID
DELETE FROM SFT_MO_MODI WHERE MODI002 = :CMOID

-- 檢查製令是否暫停中
jsonQueryFactory.sqlQuery_checkMoidIsHold(dataObject)
-- 若暫停中，拋出 JS_0115_00014

-- 檢查是否有未完工製程
jsonQueryFactory.checkHaveUndoneOp(dataObject)
-- 若有未完工製程，拋出 JS_0115_00017

-- 執行結案流程（由 JsonQueryFactory 處理）
-- 更新 MODETAIL.STATUS = 99
UPDATE MODETAIL SET
    STATUS = 99,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{當前時間}'
WHERE CMOID = :CMOID

-- 檢查製令是否已結案
SELECT COUNT(*) FROM MODETAIL WITH (NOLOCK)
WHERE CMOID = N'{wo_no}'
  AND STATUS NOT IN ('99', '100')
-- 若 COUNT > 0，表示未結案，拋出 JS_0126_00059

-- 還原結案狀態（由結案流程反向執行）
-- 根據 SFT_WS_RUN 進站記錄判斷還原狀態
UPDATE MODETAIL SET
    STATUS = CASE
        WHEN (SELECT COUNT(1) FROM SFT_WS_RUN WITH (NOLOCK)
              WHERE ID = N'{wo_no}' AND EXECUTETYPE = 'checkIn') > 0
        THEN 2  -- 有進站記錄 → 生產中
        ELSE 1  -- 無進站記錄 → 未生產
    END,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{當前時間}'
WHERE CMOID = :CMOID