supplier.get - Du lieu co ban nha cung cap

Thong tin co ban

Ten API

supplier.get

Ten phuong thuc

upWorkStationCROSS_supplier

Bang du lieu dich

WORKSTATION

Node JSON

supplier_data

Khoa chinh

ID (supplier_no)

Vi tri chuong trinh

RegularESB.java:3628

Truong phan hoi

Truong ERP	Truong MES	Mo ta
`supplier_no`	ID	Ma nha cung cap (khoa chinh)
`supplier_name`	NAME	Ten nha cung cap
`modify_no`	-	Nguoi thay doi
`tran_status`	TRAN_STATUS	Trang thai giao dich

Vi du phan hoi

{
  "supplier_data": [
    {
      "supplier_no": "SUP001",
      "supplier_name": "Cong ty nha cung cap A",
      "modify_no": "USER001",
      "tran_status": "AU"
    }
  ]
}

Xu ly dac biet

Nha cung cap va tram lam viec dung chung bang du lieu

Du lieu nha cung cap duoc luu trong bang WORKSTATION, danh dau la nha cung cap gia cong ngoai voi LOCATION = 'outSource'. Khi them moi se tu dong thiet lap gia tri mac dinh WS002-WS013.

SQL cap nhat co so du lieu

Xac dinh them moi hoac cap nhat

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

INSERT (Them moi nha cung cap)

INSERT INTO WORKSTATION (
    ID, NAME, DESCRIPTION, LOCATION,
    LASTMAINTAINUSER, LASTMAINTAINDATETIME,
    WS002, WS003, WS004, WS005, WS006, WS007,
    WS008, WS009, WS010, WS011, WS012, WS013,
    BARCODEUSE, DISPATCHUSE
) VALUES (
    :ID,
    :NAME,
    '',
    'outSource',           -- Danh dau gia cong ngoai
    :userid,
    N'{thoi gian hien tai}',
    'N', 'Y', 'N', 'N', 'N', 'Y',
    'N', 'N', 'N', 'N', 'N', 'N',
    2, 2
)

UPDATE (Cap nhat nha cung cap)

UPDATE WORKSTATION SET
    NAME = :NAME,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{thoi gian hien tai}'
WHERE ID = :ID AND LOCATION = 'outSource'