Vi du phan hoi
{
"warehouse_data": [
{
"warehouse_no": "WH001",
"warehouse_name": "Kho thanh pham",
"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 WAREHOUSE WHERE ID = N'{warehouse_no}'
-- count > 0 → UPDATE, count = 0 → INSERT
INSERT (Them moi kho)
INSERT INTO WAREHOUSE (
ID, NAME, FACTORYID, WAREHOUSETYPE,
LASTMAINTAINUSER, LASTMAINTAINDATETIME, STORAGE_SPACES
) VALUES (
:ID,
:NAME,
:FACTORYID,
:WAREHOUSETYPE,
:userid,
N'{thoi gian hien tai}',
:STORAGE_SPACES
)
UPDATE (Cap nhat kho)
UPDATE WAREHOUSE SET
NAME = :NAME,
FACTORYID = :FACTORYID,
WAREHOUSETYPE = :WAREHOUSETYPE,
LASTMAINTAINUSER = :userid,
LASTMAINTAINDATETIME = N'{thoi gian hien tai}',
STORAGE_SPACES = :STORAGE_SPACES
WHERE ID = :ID
Du lieu vi tri CMSNL (Cap nhat lien dong)
-- Xoa vi tri cu khi cap nhat
DELETE CMSNL WHERE NL001 = :ID
-- Them chi tiet vi tri
INSERT INTO CMSNL (NL001, NL002, NL003)
VALUES (:ID, :NL002, :NL003)