storage.spaces.get - Du lieu co ban vi tri luu tru

繁體中文 English Tiếng Việt ภาษาไทย

Thong tin co ban

Ten API

storage.spaces.get

Ten phuong thuc

upCmsnlCROSS

Bang du lieu dich

CMSNL

Node JSON

storage_spaces_data

Khoa chinh

NL001 + NL002 (phuc hop)

Vi tri chuong trinh

RegularESB.java:3368

Truong phan hoi

Truong ERP	Truong MES	Mo ta
`warehouse_no`	NL001	Ma kho
`storage_spaces_no`	NL002	Ma vi tri
`storage_spaces_name`	NL003	Ten vi tri
`tran_status`	TRAN_STATUS	Trang thai giao dich

Vi du phan hoi

{
  "storage_spaces_data": [
    {
      "warehouse_no": "WH001",
      "storage_spaces_no": "A01-01",
      "storage_spaces_name": "Khu A hang dau tang dau",
      "tran_status": "AU"
    }
  ]
}

Xu ly dac biet

Che do DELETE truoc INSERT

API nay ap dung che do "xoa truoc them moi", khi dong bo se xoa tat ca vi tri trong kho do truoc, sau do INSERT du lieu moi.

SQL cap nhat co so du lieu

Xoa du lieu cu

-- Xoa tat ca vi tri trong kho do
DELETE CMSNL WHERE NL001 = :warehouse_no

INSERT (Them moi vi tri)

INSERT INTO CMSNL (NL001, NL002, NL003)
VALUES (
    :NL001,      -- Ma kho
    :NL002,      -- Ma vi tri
    :NL003       -- Ten vi tri
)