data.sql 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341
  1. REPLACE INTO `monitor_indicator`
  2. VALUES ('ACATAH_ChillWaterOutTemp', '冷水出口温度', 'ACATAH', '℃', NULL,'Eqdx',NULL, NULL, NULL, NULL, NULL, 1);
  3. REPLACE INTO `monitor_indicator`
  4. VALUES ('ACATAH_ChillWaterOutTempdifference', '连续时刻出水温度差', 'ACATAH', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  5. REPLACE INTO `monitor_indicator`
  6. VALUES ('ACATAH_ChillWaterValveOpening', '冷水阀开度', 'ACATAH', '%', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  7. REPLACE INTO `monitor_indicator`
  8. VALUES ('ACATAH_FreshAirH', '新风焓值', 'ACATAH', 'kJ/kgda', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  9. REPLACE INTO `monitor_indicator`
  10. VALUES ('ACATAH_FreshAirHdifference', '连续时刻室外焓值差', 'ACATAH', 'kJ/kgda', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  11. REPLACE INTO `monitor_indicator`
  12. VALUES ('ACATAH_FreshAirValveOpening', '新风阀开度', 'ACATAH', '%', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  13. REPLACE INTO `monitor_indicator`
  14. VALUES ('ACATAH_ManualAutoStatus', '手自动状态', 'ACATAH', NULL, '[
  15. {
  16. \"key\": \"0\",
  17. \"value\": \"手动\"
  18. },
  19. {
  20. \"key\": \"1\",
  21. \"value\": \"自动\"
  22. }
  23. ]', 'Eqdx',NULL, NULL, NULL, NULL, NULL, 1);
  24. REPLACE INTO `monitor_indicator`
  25. VALUES ('ACATAH_ReturnAirCO2', '回风CO2浓度', 'ACATAH', 'ppm', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  26. REPLACE INTO `monitor_indicator`
  27. VALUES ('ACATAH_ReturnAirCO2difference', '连续时刻CO2浓度差', 'ACATAH', 'ppm', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  28. REPLACE INTO `monitor_indicator`
  29. VALUES ('ACATAH_ReturnAirH', '回风焓值', 'ACATAH', 'kJ/kgda', NULL, 'Eqdx',NULL, NULL, NULL, NULL, NULL, 1);
  30. REPLACE INTO `monitor_indicator`
  31. VALUES ('ACATAH_ReturnAirHdifference', '连续时刻室内焓值差', 'ACATAH', 'kJ/kgda', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  32. REPLACE INTO `monitor_indicator`
  33. VALUES ('ACATAH_ReturnAirTemp', '回风温度', 'ACATAH', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  34. REPLACE INTO `monitor_indicator`
  35. VALUES ('ACATAH_ReturnAirTempdifference', '连续时刻回风温度差', 'ACATAH', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  36. REPLACE INTO `monitor_indicator`
  37. VALUES ('ACATAH_ReturnAirTempSet', '回风温度设定', 'ACATAH', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  38. REPLACE INTO `monitor_indicator`
  39. VALUES ('ACATAH_ReturnAirValveOpening', '回风阀开度', 'ACATAH', '%', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  40. REPLACE INTO `monitor_indicator`
  41. VALUES ('ACATAH_RunStatus', '运行状态', 'ACATAH', NULL, '[
  42. {
  43. \"key\": \"0\",
  44. \"value\": \"停止\"
  45. },
  46. {
  47. \"key\": \"1\",
  48. \"value\": \"运行\"
  49. }
  50. ]','Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  51. REPLACE INTO `monitor_indicator`
  52. VALUES ('ACATAH_SeasonChangeSet', '季节转换设定', 'ACATAH', NULL, '[
  53. {
  54. \"key\": \"1\",
  55. \"value\": \"夏季\"
  56. },
  57. {
  58. \"key\": \"2\",
  59. \"value\": \"换热季\"
  60. },
  61. {
  62. \"key\": \"3\",
  63. \"value\": \"冬季\"
  64. },
  65. {
  66. \"key\": \"99\",
  67. \"value\": \"其他\"
  68. }
  69. ]','Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  70. REPLACE INTO `monitor_indicator`
  71. VALUES ('ACATAH_SupplyAirTemp', '送风温度', 'ACATAH', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  72. REPLACE INTO `monitor_indicator`
  73. VALUES ('ACATAH_SupplyAirTempdifference', '连续时刻送风温度差', 'ACATAH', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  74. REPLACE INTO `monitor_indicator`
  75. VALUES ('ACATAH_SupplyAirTempSet', '送风温度设定', 'ACATAH', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  76. REPLACE INTO `monitor_indicator`
  77. VALUES ('ACATAH_SupplyFanFreq', '送风机频率', 'ACATAH', 'Hz', NULL, 'Eqdx',NULL, NULL, NULL, NULL, NULL, 1);
  78. REPLACE INTO `monitor_indicator`
  79. VALUES ('ACATFU_ChillWaterOutTemp', '冷水出口温度', 'ACATFU', NULL, NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  80. REPLACE INTO `monitor_indicator`
  81. VALUES ('ACATFU_ChillWaterOutTempdifference', '连续时刻出水温度差', 'ACATFU', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  82. REPLACE INTO `monitor_indicator`
  83. VALUES ('ACATFU_ChillWaterValveOpening', '冷水阀开度', 'ACATFU', '%', NULL, 'Eqdx',NULL, NULL, NULL, NULL, NULL, 1);
  84. REPLACE INTO `monitor_indicator`
  85. VALUES ('ACATFU_ManualAutoStatus', '手自动状态', 'ACATFU', NULL, '[
  86. {
  87. \"key\": \"0\",
  88. \"value\": \"手动\"
  89. },
  90. {
  91. \"key\": \"1\",
  92. \"value\": \"自动\"
  93. }
  94. ]','Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  95. REPLACE INTO `monitor_indicator`
  96. VALUES ('ACATFU_RunStatus', '运行状态', 'ACATFU', NULL, '[
  97. {
  98. \"key\": \"0\",
  99. \"value\": \"停止\"
  100. },
  101. {
  102. \"key\": \"1\",
  103. \"value\": \"运行\"
  104. }
  105. ]','Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  106. REPLACE INTO `monitor_indicator`
  107. VALUES ('ACATFU_SeasonChangeSet', '季节转换设定', 'ACATFU', NULL, '[
  108. {
  109. \"key\": \"1\",
  110. \"value\": \"夏季\"
  111. },
  112. {
  113. \"key\": \"2\",
  114. \"value\": \"换热季\"
  115. },
  116. {
  117. \"key\": \"3\",
  118. \"value\": \"冬季\"
  119. },
  120. {
  121. \"key\": \"99\",
  122. \"value\": \"其他\"
  123. }
  124. ]','Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  125. REPLACE INTO `monitor_indicator`
  126. VALUES ('ACATFU_SupplyAirTemp', '送风温度', 'ACATFU', '℃', NULL, 'Eqdx',NULL, NULL, NULL, NULL, NULL, 1);
  127. REPLACE INTO `monitor_indicator`
  128. VALUES ('ACATFU_SupplyAirTempdifference', '连续时刻送风温度差', 'ACATFU', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  129. REPLACE INTO `monitor_indicator`
  130. VALUES ('ACATFU_SupplyAirTempSet', '送风温度设定', 'ACATFU', '℃', NULL,'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  131. REPLACE INTO `monitor_indicator`
  132. VALUES ('ACCCAC_CondContinuousOperation', '冷凝器运行持续时间', 'ACCCAC', '天', NULL, 'Eqwb',NULL, NULL, NULL, NULL, NULL, 1);
  133. REPLACE INTO `monitor_indicator`
  134. VALUES ('ACCCAC_CondHeatTransferDayAvg', '冷凝器换热端差日维度平均值阈值', 'ACCCAC', '℃', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  135. REPLACE INTO `monitor_indicator`
  136. VALUES ('ACCCAC_EvapContinuousOperation', '蒸发器运行持续时间', 'ACCCAC', '天', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  137. REPLACE INTO `monitor_indicator`
  138. VALUES ('ACCCAC_EvapHeatTransferDayAvg', '蒸发器换热端差日维度平均值阈值', 'ACCCAC', '℃', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  139. REPLACE INTO `monitor_indicator`
  140. VALUES ('ACCCCC_CondContinuousOperation', '冷凝器运行持续时间', 'ACCCCC', '天', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  141. REPLACE INTO `monitor_indicator`
  142. VALUES ('ACCCCC_CondHeatTransferDayAvg', '冷凝器换热端差日维度平均值阈值', 'ACCCCC', '℃', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  143. REPLACE INTO `monitor_indicator`
  144. VALUES ('ACCCCC_EvapContinuousOperation', '蒸发器运行持续时间', 'ACCCCC', '天', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  145. REPLACE INTO `monitor_indicator`
  146. VALUES ('ACCCCC_EvapHeatTransferDayAvg', '蒸发器换热端差日维度平均值阈值', 'ACCCCC', '℃', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  147. REPLACE INTO `monitor_indicator`
  148. VALUES ('ACCCPC_CondContinuousOperation', '冷凝器运行持续时间', 'ACCCPC', '天', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  149. REPLACE INTO `monitor_indicator`
  150. VALUES ('ACCCPC_CondHeatTransferDayAvg', '冷凝器换热端差日维度平均值阈值', 'ACCCPC', '℃', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  151. REPLACE INTO `monitor_indicator`
  152. VALUES ('ACCCPC_EvapContinuousOperation', '蒸发器运行持续时间', 'ACCCPC', '天', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  153. REPLACE INTO `monitor_indicator`
  154. VALUES ('ACCCPC_EvapHeatTransferDayAvg', '蒸发器换热端差日维度平均值阈值', 'ACCCPC', '℃', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  155. REPLACE INTO `monitor_indicator`
  156. VALUES ('ACCCSC_CondContinuousOperation', '冷凝器运行持续时间', 'ACCCSC', '天', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  157. REPLACE INTO `monitor_indicator`
  158. VALUES ('ACCCSC_CondHeatTransferDayAvg', '冷凝器换热端差日维度平均值阈值', 'ACCCSC', '℃', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  159. REPLACE INTO `monitor_indicator`
  160. VALUES ('ACCCSC_EvapContinuousOperation', '蒸发器运行持续时间', 'ACCCSC', '天', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  161. REPLACE INTO `monitor_indicator`
  162. VALUES ('ACCCSC_EvapHeatTransferDayAvg', '蒸发器换热端差日维度平均值阈值', 'ACCCSC', '℃', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  163. REPLACE INTO `monitor_indicator`
  164. VALUES ('ACCCOT_ApproachTempContinuousOperation', '逼近温度运行持续时间', 'ACCCOT', '天', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  165. REPLACE INTO `monitor_indicator`
  166. VALUES ('ACCCOT_ApproachTempDayAvg', '逼近温度日维度平均值阈值', 'ACCCOT', '℃', NULL,'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  167. REPLACE INTO `calculate_method`
  168. VALUES ('1', '冷水出口温度', '${obj;CurrentTime;15min;InfoCode;chillWaterOutTemp}', 'ACATAH_ChillWaterOutTemp', 1,'Eqdx', NULL,
  169. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  170. REPLACE INTO `calculate_method`
  171. VALUES ('10', '回风焓值', '${obj;CurrentTime;15min;InfoCode;returnAirH}', 'ACATAH_ReturnAirH', 1,'Eqdx', NULL, 'systemId',
  172. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  173. REPLACE INTO `calculate_method`
  174. VALUES ('11', '(当前时刻室内焓值-上一时刻室内焓值)的绝对值',
  175. '${obj;CurrentTime;1h;InfoCode;returnAirHdifference}-${obj;LastTime;1h;InfoCode;returnAirHdifference}',
  176. 'ACATAH_ReturnAirHdifference', 1,'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18',
  177. 1);
  178. REPLACE INTO `calculate_method`
  179. VALUES ('12', '回风温度', '${obj;CurrentTime;15min;InfoCode;returnAirTemp}', 'ACATAH_ReturnAirTemp', 1,'Eqdx', NULL, 'systemId',
  180. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  181. REPLACE INTO `calculate_method`
  182. VALUES ('13', '(当前时刻回风温度-上一时刻回风温度)的绝对值',
  183. '${obj;CurrentTime;1h;InfoCode;returnAirTempdifference}-${obj;LastTime;1h;InfoCode;returnAirTempdifference}',
  184. 'ACATAH_ReturnAirTempdifference', 1,'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18',
  185. 1);
  186. REPLACE INTO `calculate_method`
  187. VALUES ('14', '回风温度设定', '${obj;CurrentTime;15min;InfoCode;returnAirTempSet}', 'ACATAH_ReturnAirTempSet', 1,'Eqdx', NULL,
  188. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  189. REPLACE INTO `calculate_method`
  190. VALUES ('15', '回风阀开度', '${obj;CurrentTime;15min;InfoCode;returnAirValveOpening}', 'ACATAH_ReturnAirValveOpening', 1,'Eqdx',
  191. NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  192. REPLACE INTO `calculate_method`
  193. VALUES ('16', '运行状态', '${obj;CurrentTime;15min;InfoCode;runStatus}', 'ACATAH_RunStatus', 1,'Eqdx', NULL, 'systemId',
  194. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  195. REPLACE INTO `calculate_method`
  196. VALUES ('17', '季节转换设定', '${obj;CurrentTime;15min;InfoCode;seasonChangeSet}', 'ACATAH_SeasonChangeSet', 1,'Eqdx', NULL,
  197. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  198. REPLACE INTO `calculate_method`
  199. VALUES ('18', '送风温度', '${obj;CurrentTime;15min;InfoCode;supplyAirTemp}', 'ACATAH_SupplyAirTemp', 1,'Eqdx', NULL, 'systemId',
  200. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  201. REPLACE INTO `calculate_method`
  202. VALUES ('19', '(当前时刻送风温度-上一时刻送风温度)的绝对值',
  203. '${obj;CurrentTime;1h;InfoCode;supplyAirTempdifference}-${obj;LastTime;1h;InfoCode;supplyAirTempdifference}',
  204. 'ACATAH_SupplyAirTempdifference', 1,'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18',
  205. 1);
  206. REPLACE INTO `calculate_method`
  207. VALUES ('2', '(当前时刻出水温度-上一时刻出水温度)的绝对值',
  208. '${obj;CurrentTime;1h;InfoCode;chillWaterOutTempdifference}-${obj;LastTime;1h;InfoCode;chillWaterOutTempdifference}',
  209. 'ACATAH_ChillWaterOutTempdifference', 1,'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId',
  210. '2021-09-20 17:14:18', 1);
  211. REPLACE INTO `calculate_method`
  212. VALUES ('20', '送风温度设定', '${obj;CurrentTime;15min;InfoCode;supplyAirTempSet}', 'ACATAH_SupplyAirTempSet', 1,'Eqdx', NULL,
  213. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  214. REPLACE INTO `calculate_method`
  215. VALUES ('21', '送风机频率', '${obj;CurrentTime;15min;InfoCode;supplyFanFreq}', 'ACATAH_SupplyFanFreq', 1,'Eqdx', NULL, 'systemId',
  216. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  217. REPLACE INTO `calculate_method`
  218. VALUES ('22', '冷水出口温度', '${obj;CurrentTime;15min;InfoCode;chillWaterOutTemp}', 'ACATFU_ChillWaterOutTemp', 1,'Eqdx', NULL,
  219. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  220. REPLACE INTO `calculate_method`
  221. VALUES ('23', '(当前时刻出水温度-上一时刻出水温度)的绝对值',
  222. '${obj;CurrentTime;1h;InfoCode;chillWaterOutTempdifference}-${obj;LastTime;1h;InfoCode;chillWaterOutTempdifference}',
  223. 'ACATFU_ChillWaterOutTempdifference', 1, 'Eqdx',NULL, 'systemId', '2021-09-20 17:13:56', 'systemId',
  224. '2021-09-20 17:14:18', 1);
  225. REPLACE INTO `calculate_method`
  226. VALUES ('24', '冷水阀开度', '${obj;CurrentTime;15min;InfoCode;chillWaterValveOpening}', 'ACATFU_ChillWaterValveOpening', 1,'Eqdx',
  227. NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  228. REPLACE INTO `calculate_method`
  229. VALUES ('25', '手自动状态', '${obj;CurrentTime;15min;InfoCode;manualAutoStatus}', 'ACATFU_ManualAutoStatus', 1,'Eqdx', NULL,
  230. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  231. REPLACE INTO `calculate_method`
  232. VALUES ('26', '运行状态', '${obj;CurrentTime;15min;InfoCode;runStatus}', 'ACATFU_RunStatus', 1, 'Eqdx',NULL, 'systemId',
  233. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  234. REPLACE INTO `calculate_method`
  235. VALUES ('27', '季节转换设定', '${obj;CurrentTime;15min;InfoCode;seasonChangeSet}', 'ACATFU_SeasonChangeSet', 1,'Eqdx', NULL,
  236. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  237. REPLACE INTO `calculate_method`
  238. VALUES ('28', '送风温度', '${obj;CurrentTime;15min;InfoCode;supplyAirTemp}', 'ACATFU_SupplyAirTemp', 1,'Eqdx', NULL, 'systemId',
  239. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  240. REPLACE INTO `calculate_method`
  241. VALUES ('29', '(当前时刻送风温度-上一时刻送风温度)的绝对值',
  242. '${obj;CurrentTime;1h;InfoCode;supplyAirTempdifference}-${obj;LastTime;1h;InfoCode;supplyAirTempdifference}',
  243. 'ACATFU_SupplyAirTempdifference', 1,'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18',
  244. 1);
  245. REPLACE INTO `calculate_method`
  246. VALUES ('3', '冷水阀开度', '${obj;CurrentTime;15min;InfoCode;chillWaterValveOpening}', 'ACATAH_ChillWaterValveOpening', 1,'Eqdx',
  247. NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  248. REPLACE INTO `calculate_method`
  249. VALUES ('30', '送风温度设定', '${obj;CurrentTime;15min;InfoCode;supplyAirTempSet}', 'ACATFU_SupplyAirTempSet', 1,'Eqdx', NULL,
  250. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  251. REPLACE INTO `calculate_method`
  252. VALUES ('4', '新风焓值', '${obj;CurrentTime;15min;InfoCode;freshAirH}', 'ACATAH_FreshAirH', 1,'Eqdx', NULL, 'systemId',
  253. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  254. REPLACE INTO `calculate_method`
  255. VALUES ('5', '连续时刻室外焓值差', '${obj;CurrentTime;15min;InfoCode;freshAirHdifference}', 'ACATAH_FreshAirHdifference', 1,'Eqdx',
  256. NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  257. REPLACE INTO `calculate_method`
  258. VALUES ('6', '新风阀开度', '${obj;CurrentTime;15min;InfoCode;freshAirValveOpening}', 'ACATAH_FreshAirValveOpening', 1,'Eqdx', NULL,
  259. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  260. REPLACE INTO `calculate_method`
  261. VALUES ('7', '手自动状态', '${obj;CurrentTime;15min;InfoCode;manualAutoStatus}', 'ACATAH_ManualAutoStatus', 1,'Eqdx', NULL,
  262. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  263. REPLACE INTO `calculate_method`
  264. VALUES ('8', '回风CO2浓度', '${obj;CurrentTime;15min;InfoCode;returnAirCO2}', 'ACATAH_ReturnAirCO2', 1,'Eqdx', NULL, 'systemId',
  265. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  266. REPLACE INTO `calculate_method`
  267. VALUES ('9', '(当前时刻CO2浓度-上一时刻CO2浓度)的绝对值',
  268. '${obj;CurrentTime;1h;InfoCode;returnAirCO2difference}-${obj;LastTime;1h;InfoCode;returnAirCO2difference}',
  269. 'ACATAH_ReturnAirCO2difference', 1,'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18',
  270. 1);
  271. REPLACE INTO `calculate_method`
  272. VALUES ('31', '冷凝器换热端差日维度平均值阈值', NULL, 'ACCCAC_CondHeatTransferDayAvg', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  273. 'systemId', '2021-11-02 15:10:00', 1);
  274. REPLACE INTO `calculate_method`
  275. VALUES ('32', '冷凝器运行持续时间', NULL, 'ACCCAC_CondContinuousOperation', 1, 'Eqwb',NULL, 'systemId', '2021-11-02 15:10:00',
  276. 'systemId', '2021-11-02 15:10:00', 1);
  277. REPLACE INTO `calculate_method`
  278. VALUES ('33', '蒸发器换热端差日维度平均值阈值', NULL, 'ACCCAC_EvapHeatTransferDayAvg', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  279. 'systemId', '2021-11-02 15:10:00', 1);
  280. REPLACE INTO `calculate_method`
  281. VALUES ('34', '蒸发器运行持续时间', NULL, 'ACCCAC_EvapContinuousOperation', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  282. 'systemId', '2021-11-02 15:10:00', 1);
  283. REPLACE INTO `calculate_method`
  284. VALUES ('36', '冷凝器运行持续时间', NULL, 'ACCCCC_CondContinuousOperation', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  285. 'systemId', '2021-11-02 15:10:00', 1);
  286. REPLACE INTO `calculate_method`
  287. VALUES ('35', '冷凝器换热端差日维度平均值阈值', NULL, 'ACCCCC_CondHeatTransferDayAvg', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  288. 'systemId', '2021-11-02 15:10:00', 1);
  289. REPLACE INTO `calculate_method`
  290. VALUES ('38', '蒸发器运行持续时间', NULL, 'ACCCCC_EvapContinuousOperation', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  291. 'systemId', '2021-11-02 15:10:00', 1);
  292. REPLACE INTO `calculate_method`
  293. VALUES ('37', '蒸发器换热端差日维度平均值阈值', NULL, 'ACCCCC_EvapHeatTransferDayAvg', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  294. 'systemId', '2021-11-02 15:10:00', 1);
  295. REPLACE INTO `calculate_method`
  296. VALUES ('48', '逼近温度运行持续时间', NULL, 'ACCCOT_ApproachTempContinuousOperation', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  297. 'systemId', '2021-11-02 15:10:00', 1);
  298. REPLACE INTO `calculate_method`
  299. VALUES ('47', '逼近温度日维度平均值阈值', NULL, 'ACCCOT_ApproachTempDayAvg', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00', 'systemId',
  300. '2021-11-02 15:10:00', 1);
  301. REPLACE INTO `calculate_method`
  302. VALUES ('40', '冷凝器运行持续时间', NULL, 'ACCCPC_CondContinuousOperation', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  303. 'systemId', '2021-11-02 15:10:00', 1);
  304. REPLACE INTO `calculate_method`
  305. VALUES ('39', '冷凝器换热端差日维度平均值阈值', NULL, 'ACCCPC_CondHeatTransferDayAvg', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  306. 'systemId', '2021-11-02 15:10:00', 1);
  307. REPLACE INTO `calculate_method`
  308. VALUES ('42', '蒸发器运行持续时间', NULL, 'ACCCPC_EvapContinuousOperation', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  309. 'systemId', '2021-11-02 15:10:00', 1);
  310. REPLACE INTO `calculate_method`
  311. VALUES ('41', '蒸发器换热端差日维度平均值阈值', NULL, 'ACCCPC_EvapHeatTransferDayAvg', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  312. 'systemId', '2021-11-02 15:10:00', 1);
  313. REPLACE INTO `calculate_method`
  314. VALUES ('44', '冷凝器运行持续时间', NULL, 'ACCCSC_CondContinuousOperation', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  315. 'systemId', '2021-11-02 15:10:00', 1);
  316. REPLACE INTO `calculate_method`
  317. VALUES ('43', '冷凝器换热端差日维度平均值阈值', NULL, 'ACCCSC_CondHeatTransferDayAvg', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  318. 'systemId', '2021-11-02 15:10:00', 1);
  319. REPLACE INTO `calculate_method`
  320. VALUES ('46', '蒸发器运行持续时间', NULL, 'ACCCSC_EvapContinuousOperation', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  321. 'systemId', '2021-11-02 15:10:00', 1);
  322. REPLACE INTO `calculate_method`
  323. VALUES ('45', '蒸发器换热端差日维度平均值阈值', NULL, 'ACCCSC_EvapHeatTransferDayAvg', 1,'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  324. 'systemId', '2021-11-02 15:10:00', 1);
  325. REPLACE INTO `obj_group`
  326. VALUES ('1', '组合式空调机组', 'ACATAH', 'installType: 1', '0', 'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  327. REPLACE INTO `obj_group`
  328. VALUES ('2', '吊装空调', 'ACATAH', 'installType: 2', '0', 'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  329. REPLACE INTO `obj_group`
  330. VALUES ('3', '新风机组', 'ACATFU', '', '0', 'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  331. REPLACE INTO `obj_group`
  332. VALUES ('4', '离心式冷水机组', 'ACCCCC', '', '0','Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  333. REPLACE INTO `obj_group`
  334. VALUES ('5', '螺杆式冷水机组', 'ACCCSC', '', '0','Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  335. REPLACE INTO `obj_group`
  336. VALUES ('6', '活塞式冷水机组', 'ACCCPC', '', '0','Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  337. REPLACE INTO `obj_group`
  338. VALUES ('7', '吸收式冷水机组', 'ACCCAC', '', '0','Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  339. REPLACE INTO `obj_group`
  340. VALUES ('8', '冷却塔组', 'ACCCOT', '', '0','Eqwb', NULL, NULL, NULL, NULL, NULL, 1);