生產線基本資料

基本資訊

回應欄位

回應範例

{
  "workstation_data": [
    {
      "workstation_no": "WS001",
      "workstation_name": "組裝線A",
      "factory_no": "FACTORY01",
      "modify_no": "USER001",
      "tran_status": "AU"
    }
  ]
}

資料庫更新 SQL

判斷新增或修改

SELECT COUNT(1) FROM WORKSTATION WHERE ID = N'{workstation_no}'
-- count > 0 → UPDATE, count = 0 → INSERT

INSERT（新增工作站）

INSERT INTO WORKSTATION (
    ID, NAME, DESCRIPTION, LOCATION,
    LASTMAINTAINUSER, LASTMAINTAINDATETIME,
    WS002, WS003, WS004, WS007, BARCODEUSE, DISPATCHUSE
) VALUES (
    :WSID,
    :WSNAME,
    :WSDESCRIPTION,
    :WSLOCATION,          -- 所屬工廠
    :userid,
    N'{當前時間}',
    'N',                  -- WS002
    'Y',                  -- WS003
    'N',                  -- WS004
    'Y',                  -- WS007
    2,                    -- BARCODEUSE
    2                     -- DISPATCHUSE
)

UPDATE（修改工作站）

UPDATE WORKSTATION SET
    NAME = :WSNAME,
    DESCRIPTION = :WSDESCRIPTION,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{當前時間}'
WHERE ID = :WSID AND LOCATION = :WSLOCATION