data.sql 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353
  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, 'systemId',
  183. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  184. REPLACE INTO `calculate_method`
  185. VALUES ('11', '(当前时刻室内焓值-上一时刻室内焓值)的绝对值',
  186. '${obj;CurrentTime;1h;InfoCode;returnAirH}-${obj;LastTime;1h;InfoCode;returnAirH}',
  187. 'ACATAH_ReturnAirHdifference', 1, 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId',
  188. '2021-09-20 17:14:18', 1);
  189. REPLACE INTO `calculate_method`
  190. VALUES ('12', '回风温度', '${obj;CurrentTime;15min;InfoCode;returnAirTemp}', 'ACATAH_ReturnAirTemp', 1, 'Eqdx', NULL,
  191. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  192. REPLACE INTO `calculate_method`
  193. VALUES ('13', '(当前时刻回风温度-上一时刻回风温度)的绝对值',
  194. '${obj;CurrentTime;1h;InfoCode;returnAirTemp}-${obj;LastTime;1h;InfoCode;returnAirTemp}',
  195. 'ACATAH_ReturnAirTempdifference', 1, 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId',
  196. '2021-09-20 17:14:18', 1);
  197. REPLACE INTO `calculate_method`
  198. VALUES ('14', '回风温度设定', '${obj;CurrentTime;15min;InfoCode;returnAirTempSet}', 'ACATAH_ReturnAirTempSet', 1, 'Eqdx',
  199. NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  200. REPLACE INTO `calculate_method`
  201. VALUES ('15', '回风阀开度', '${obj;CurrentTime;15min;InfoCode;returnAirValveOpening}', 'ACATAH_ReturnAirValveOpening', 1,
  202. 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  203. REPLACE INTO `calculate_method`
  204. VALUES ('16', '运行状态', '${obj;CurrentTime;15min;InfoCode;runStatus}', 'ACATAH_RunStatus', 1, 'Eqdx', NULL, 'systemId',
  205. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  206. REPLACE INTO `calculate_method`
  207. VALUES ('17', '季节转换设定', '${obj;CurrentTime;15min;InfoCode;seasonChangeSet}', 'ACATAH_SeasonChangeSet', 1, 'Eqdx', NULL,
  208. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  209. REPLACE INTO `calculate_method`
  210. VALUES ('18', '送风温度', '${obj;CurrentTime;15min;InfoCode;supplyAirTemp}', 'ACATAH_SupplyAirTemp', 1, 'Eqdx', NULL,
  211. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  212. REPLACE INTO `calculate_method`
  213. VALUES ('19', '(当前时刻送风温度-上一时刻送风温度)的绝对值',
  214. '${obj;CurrentTime;1h;InfoCode;supplyAirTemp}-${obj;LastTime;1h;InfoCode;supplyAirTemp}',
  215. 'ACATAH_SupplyAirTempdifference', 1, 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId',
  216. '2021-09-20 17:14:18', 1);
  217. REPLACE INTO `calculate_method`
  218. VALUES ('2', '(当前时刻出水温度-上一时刻出水温度)的绝对值',
  219. '${obj;CurrentTime;1h;InfoCode;chillWaterOutTemp}-${obj;LastTime;1h;InfoCode;chillWaterOutTemp}',
  220. 'ACATAH_ChillWaterOutTempdifference', 1, 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId',
  221. '2021-09-20 17:14:18', 1);
  222. REPLACE INTO `calculate_method`
  223. VALUES ('20', '送风温度设定', '${obj;CurrentTime;15min;InfoCode;supplyAirTempSet}', 'ACATAH_SupplyAirTempSet', 1, 'Eqdx',
  224. NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  225. REPLACE INTO `calculate_method`
  226. VALUES ('21', '送风机频率', '${obj;CurrentTime;15min;InfoCode;supplyFanFreq}', 'ACATAH_SupplyFanFreq', 1, 'Eqdx', NULL,
  227. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  228. REPLACE INTO `calculate_method`
  229. VALUES ('22', '冷水出口温度', '${obj;CurrentTime;15min;InfoCode;chillWaterOutTemp}', 'ACATFU_ChillWaterOutTemp', 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 ('23', '(当前时刻出水温度-上一时刻出水温度)的绝对值',
  233. '${obj;CurrentTime;1h;InfoCode;chillWaterOutTemp}-${obj;LastTime;1h;InfoCode;chillWaterOutTemp}',
  234. 'ACATFU_ChillWaterOutTempdifference', 1, 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId',
  235. '2021-09-20 17:14:18', 1);
  236. REPLACE INTO `calculate_method`
  237. VALUES ('24', '冷水阀开度', '${obj;CurrentTime;15min;InfoCode;chillWaterValveOpening}', 'ACATFU_ChillWaterValveOpening', 1,
  238. 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  239. REPLACE INTO `calculate_method`
  240. VALUES ('25', '手自动状态', '${obj;CurrentTime;15min;InfoCode;manualAutoStatus}', 'ACATFU_ManualAutoStatus', 1, 'Eqdx', NULL,
  241. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  242. REPLACE INTO `calculate_method`
  243. VALUES ('26', '运行状态', '${obj;CurrentTime;15min;InfoCode;runStatus}', 'ACATFU_RunStatus', 1, 'Eqdx', NULL, 'systemId',
  244. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  245. REPLACE INTO `calculate_method`
  246. VALUES ('27', '季节转换设定', '${obj;CurrentTime;15min;InfoCode;seasonChangeSet}', 'ACATFU_SeasonChangeSet', 1, 'Eqdx', NULL,
  247. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  248. REPLACE INTO `calculate_method`
  249. VALUES ('28', '送风温度', '${obj;CurrentTime;15min;InfoCode;supplyAirTemp}', 'ACATFU_SupplyAirTemp', 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 ('29', '(当前时刻送风温度-上一时刻送风温度)的绝对值',
  253. '${obj;CurrentTime;1h;InfoCode;supplyAirTemp}-${obj;LastTime;1h;InfoCode;supplyAirTemp}',
  254. 'ACATFU_SupplyAirTempdifference', 1, 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId',
  255. '2021-09-20 17:14:18', 1);
  256. REPLACE INTO `calculate_method`
  257. VALUES ('3', '冷水阀开度', '${obj;CurrentTime;15min;InfoCode;chillWaterValveOpening}', 'ACATAH_ChillWaterValveOpening', 1,
  258. 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  259. REPLACE INTO `calculate_method`
  260. VALUES ('30', '送风温度设定', '${obj;CurrentTime;15min;InfoCode;supplyAirTempSet}', 'ACATFU_SupplyAirTempSet', 1, 'Eqdx',
  261. NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  262. REPLACE INTO `calculate_method`
  263. VALUES ('31', '冷凝器换热端差日维度平均值阈值', NULL, 'ACCCAC_CondHeatTransferDayAvg', 1, 'Eqwb', NULL, 'systemId',
  264. '2021-11-02 15:10:00', 'systemId', '2021-11-02 15:10:00', 1);
  265. REPLACE INTO `calculate_method`
  266. VALUES ('32', '冷凝器运行持续时间', NULL, 'ACCCAC_CondContinuousOperation', 1, 'Eqwb', NULL, 'systemId', '2021-11-02 15:10:00',
  267. 'systemId', '2021-11-02 15:10:00', 1);
  268. REPLACE INTO `calculate_method`
  269. VALUES ('33', '蒸发器换热端差日维度平均值阈值', NULL, 'ACCCAC_EvapHeatTransferDayAvg', 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 ('34', '蒸发器运行持续时间', NULL, 'ACCCAC_EvapContinuousOperation', 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 ('35', '冷凝器换热端差日维度平均值阈值', NULL, 'ACCCCC_CondHeatTransferDayAvg', 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 ('36', '冷凝器运行持续时间', NULL, 'ACCCCC_CondContinuousOperation', 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 ('37', '蒸发器换热端差日维度平均值阈值', NULL, 'ACCCCC_EvapHeatTransferDayAvg', 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 ('38', '蒸发器运行持续时间', NULL, 'ACCCCC_EvapContinuousOperation', 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 ('39', '冷凝器换热端差日维度平均值阈值', NULL, 'ACCCPC_CondHeatTransferDayAvg', 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 ('4', '新风焓值', '${obj;CurrentTime;15min;InfoCode;freshAirH}', 'ACATAH_FreshAirH', 1, 'Eqdx', NULL, 'systemId',
  291. '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  292. REPLACE INTO `calculate_method`
  293. VALUES ('40', '冷凝器运行持续时间', NULL, 'ACCCPC_CondContinuousOperation', 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 ('41', '蒸发器换热端差日维度平均值阈值', NULL, 'ACCCPC_EvapHeatTransferDayAvg', 1, 'Eqwb', NULL, 'systemId',
  297. '2021-11-02 15:10:00', 'systemId', '2021-11-02 15:10:00', 1);
  298. REPLACE INTO `calculate_method`
  299. VALUES ('42', '蒸发器运行持续时间', NULL, 'ACCCPC_EvapContinuousOperation', 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 ('43', '冷凝器换热端差日维度平均值阈值', NULL, 'ACCCSC_CondHeatTransferDayAvg', 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 ('44', '冷凝器运行持续时间', NULL, 'ACCCSC_CondContinuousOperation', 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 ('45', '蒸发器换热端差日维度平均值阈值', NULL, 'ACCCSC_EvapHeatTransferDayAvg', 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 ('46', '蒸发器运行持续时间', NULL, 'ACCCSC_EvapContinuousOperation', 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 ('47', '逼近温度日维度平均值阈值', NULL, 'ACCCOT_ApproachTempDayAvg', 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 ('48', '逼近温度运行持续时间', NULL, 'ACCCOT_ApproachTempContinuousOperation', 1, 'Eqwb', NULL, 'systemId',
  318. '2021-11-02 15:10:00', 'systemId', '2021-11-02 15:10:00', 1);
  319. REPLACE INTO `calculate_method`
  320. VALUES ('5', '连续时刻室外焓值差', '${obj;CurrentTime;15min;InfoCode;freshAirH}', 'ACATAH_FreshAirHdifference', 1, 'Eqdx', NULL,
  321. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  322. REPLACE INTO `calculate_method`
  323. VALUES ('6', '新风阀开度', '${obj;CurrentTime;15min;InfoCode;freshAirValveOpening}', 'ACATAH_FreshAirValveOpening', 1,
  324. 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  325. REPLACE INTO `calculate_method`
  326. VALUES ('7', '手自动状态', '${obj;CurrentTime;15min;InfoCode;manualAutoStatus}', 'ACATAH_ManualAutoStatus', 1, 'Eqdx', NULL,
  327. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  328. REPLACE INTO `calculate_method`
  329. VALUES ('8', '回风CO2浓度', '${obj;CurrentTime;15min;InfoCode;returnAirCO2}', 'ACATAH_ReturnAirCO2', 1, 'Eqdx', NULL,
  330. 'systemId', '2021-09-20 17:13:56', 'systemId', '2021-09-20 17:14:18', 1);
  331. REPLACE INTO `calculate_method`
  332. VALUES ('9', '(当前时刻CO2浓度-上一时刻CO2浓度)的绝对值',
  333. '${obj;CurrentTime;1h;InfoCode;returnAirCO2}-${obj;LastTime;1h;InfoCode;returnAirCO2}',
  334. 'ACATAH_ReturnAirCO2difference', 1, 'Eqdx', NULL, 'systemId', '2021-09-20 17:13:56', 'systemId',
  335. '2021-09-20 17:14:18', 1);
  336. REPLACE INTO `obj_group`
  337. VALUES ('1', '组合式空调机组', 'ACATAH', 'installType: "1"', '0', 'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  338. REPLACE INTO `obj_group`
  339. VALUES ('2', '吊装空调', 'ACATAH', 'installType: "2"', '0', 'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  340. REPLACE INTO `obj_group`
  341. VALUES ('3', '新风机组', 'ACATFU', '', '0', 'Eqdx', NULL, NULL, NULL, NULL, NULL, 1);
  342. REPLACE INTO `obj_group`
  343. VALUES ('4', '离心式冷水机组', 'ACCCCC', '', '0', 'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  344. REPLACE INTO `obj_group`
  345. VALUES ('5', '螺杆式冷水机组', 'ACCCSC', '', '0', 'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  346. REPLACE INTO `obj_group`
  347. VALUES ('6', '活塞式冷水机组', 'ACCCPC', '', '0', 'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  348. REPLACE INTO `obj_group`
  349. VALUES ('7', '吸收式冷水机组', 'ACCCAC', '', '0', 'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);
  350. REPLACE INTO `obj_group`
  351. VALUES ('8', '冷却塔组', 'ACCCOT', '', '0', 'Eqwb', NULL, NULL, NULL, NULL, NULL, 1);