| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- INSERT INTO p_device(
- id,
- code,
- name,
- type_id,
- department,
- description,
- projectid,
- picture,
- labelid,
- sourcesys,
- is_displayed,
- use_time,
- invalid_time,
- area,
- location,
- user_name,
- maintain_count,
- next_maintain_time,
- repair_count,
- last_repair_time,
- state,
- roomname,
- abnormal_phone,
- abnormal_time,
- report_phone,
- assists_name,
- principal_name
- )
- VALUES (
- :device.id,
- :device.code,
- :device.name,
- :device.typeId,
- :device.department,
- :device.description,
- :device.projectid,
- :device.picture,
- :device.labelid,
- :device.sourcesys,
- :device.isDisplayed,
- :device.useTime,
- :device.invalidTime,
- :device.area,
- :device.location,
- :device.userName,
- :device.maintainCount,
- :device.nextMaintainTime,
- :device.repairCount,
- :device.lastRepairTime,
- :device.state,
- :device.roomname,
- :device.abnormalPhone,
- :device.abnormalTime,
- :device.reportPhone,
- :device.assistsName,
- :device.principalName
- );
|
