Response Example
{
"warehouse_data": [
{
"warehouse_no": "WH001",
"warehouse_name": "Finished Goods Warehouse",
"factory_no": "FACTORY01",
"modify_no": "USER001",
"tran_status": "AU"
}
]
}
Database Update SQL
Check Insert or Update
SELECT COUNT(1) FROM WAREHOUSE WHERE ID = N'{warehouse_no}'
-- count > 0 → UPDATE, count = 0 → INSERT
INSERT (Add Warehouse)
INSERT INTO WAREHOUSE (
ID, NAME, FACTORYID, WAREHOUSETYPE,
LASTMAINTAINUSER, LASTMAINTAINDATETIME, STORAGE_SPACES
) VALUES (
:ID,
:NAME,
:FACTORYID,
:WAREHOUSETYPE,
:userid,
N'{current_time}',
:STORAGE_SPACES
)
UPDATE (Modify Warehouse)
UPDATE WAREHOUSE SET
NAME = :NAME,
FACTORYID = :FACTORYID,
WAREHOUSETYPE = :WAREHOUSETYPE,
LASTMAINTAINUSER = :userid,
LASTMAINTAINDATETIME = N'{current_time}',
STORAGE_SPACES = :STORAGE_SPACES
WHERE ID = :ID
CMSNL Storage Location Data (Linked Update)
-- Delete old storage locations when modifying
DELETE CMSNL WHERE NL001 = :ID
-- Insert storage location details
INSERT INTO CMSNL (NL001, NL002, NL003)
VALUES (:ID, :NL002, :NL003)