MiddlewareSyncDao_insertSensor.sql 474 B

1234567891011121314151617181920212223242526272829303132
  1. INSERT INTO p_sensor_monitor_point(
  2. id,
  3. code,
  4. name,
  5. projectid,
  6. picture,
  7. sourcesys,
  8. typeid,
  9. room,
  10. deviceid,
  11. upper,
  12. floor,
  13. state,
  14. stat_type,
  15. is_displayed
  16. )
  17. VALUES (
  18. :sensorpoint.id,
  19. :sensorpoint.code,
  20. :sensorpoint.name,
  21. :sensorpoint.projectid,
  22. :sensorpoint.picture,
  23. :sensorpoint.sourcesys,
  24. :sensorpoint.typeid,
  25. :sensorpoint.room,
  26. :sensorpoint.deviceid,
  27. :sensorpoint.upper,
  28. :sensorpoint.floor,
  29. :sensorpoint.state,
  30. :sensorpoint.statType,
  31. :sensorpoint.isDisplayed
  32. );