workstation.get - Du lieu co ban day chuyen san xuat

Thong tin co ban

Ten API

workstation.get

Ten phuong thuc

upWorkStationCROSS_workstation

Bang du lieu dich

WORKSTATION

Node JSON

workstation_data

Khoa chinh

ID

Vi tri chuong trinh

RegularESB.java:3830

Truong phan hoi

Truong ERP	Truong MES	Mo ta
`workstation_no`	ID	Ma tram lam viec (khoa chinh)
`workstation_name`	NAME	Ten tram lam viec
`factory_no`	FACTORYID	Ma nha may
`modify_no`	-	Nguoi thay doi
`tran_status`	TRAN_STATUS	Trang thai giao dich

Vi du phan hoi

{
  "workstation_data": [
    {
      "workstation_no": "WS001",
      "workstation_name": "Day chuyen lap rap A",
      "factory_no": "FACTORY01",
      "modify_no": "USER001",
      "tran_status": "AU"
    }
  ]
}

SQL cap nhat co so du lieu

Xac dinh them moi hoac cap nhat

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

INSERT (Them moi tram lam viec)

INSERT INTO WORKSTATION (
    ID, NAME, DESCRIPTION, LOCATION,
    LASTMAINTAINUSER, LASTMAINTAINDATETIME,
    WS002, WS003, WS004, WS007, BARCODEUSE, DISPATCHUSE
) VALUES (
    :WSID,
    :WSNAME,
    :WSDESCRIPTION,
    :WSLOCATION,          -- Nha may thuoc ve
    :userid,
    N'{thoi gian hien tai}',
    'N',                  -- WS002
    'Y',                  -- WS003
    'N',                  -- WS004
    'Y',                  -- WS007
    2,                    -- BARCODEUSE
    2                     -- DISPATCHUSE
)

UPDATE (Cap nhat tram lam viec)

UPDATE WORKSTATION SET
    NAME = :WSNAME,
    DESCRIPTION = :WSDESCRIPTION,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{thoi gian hien tai}'
WHERE ID = :WSID AND LOCATION = :WSLOCATION