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
);