data.sql 22 KB

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