Response Example
{
"machine_data": [
{
"machine_no": "EQ001",
"machine_name": "CNC Machine",
"remark": "3-axis machining center",
"supplier_no": "WS001",
"machine_capacity": "100",
"tran_status": "AU"
}
]
}
Database Update SQL
Check Insert or Update
SELECT COUNT(1) FROM EQUIPMENT WHERE ID = N'{machine_no}'
-- count > 0 → UPDATE, count = 0 → INSERT
INSERT (Add Equipment)
INSERT INTO EQUIPMENT (
ID, LOCATION, NAME, DESCRIPTION, CALENDARID, EQ001,
EQ003, EQ006, EQ007, EQ008, EQ010, EQ011, EQ012,
ENDEFFECTDATETIME, LASTMAINTAINUSER, LASTMAINTAINDATETIME
) VALUES (
:EQID,
:WSID, -- Workstation location
:Eqname,
:description,
'24Hour', -- Default calendar
'0', -- Equipment status
:EQ003, -- Daily capacity
:EQ006, -- Inspection checklist
:EQ007, -- Scheduled work hours
:EQ008, -- Available work hours
:EQ010, -- Include in inventory count
:EQ011, -- Include in work hour calculation
:EQ012, -- Expiration date (empty=active)
'2049-12-31 00:00:00.000',
:userid,
'{current_time}'
)
UPDATE (Modify Equipment)
UPDATE EQUIPMENT SET
NAME = :Eqname,
DESCRIPTION = :description,
EQ003 = :EQ003,
EQ006 = :EQ006,
EQ007 = :EQ007,
EQ008 = :EQ008,
EQ010 = :EQ010,
EQ011 = :EQ011,
EQ012 = :EQ012,
ENDEFFECTDATETIME = '2049-12-31 00:00:00.000',
LASTMAINTAINUSER = :userid,
LASTMAINTAINDATETIME = '{current_time}'
WHERE ID = :EQID AND LOCATION = :WSID