yeguanglin
/
forecast


			
				
					
						
						
							12345678910111213141516171819202122232425262728293031323334
							---- 通信的协议
INSERT INTO config_transmit VALUES (1, 'TCP异步客户端', 'cn.oleauto.transmit.tcp.TcpClient', E'host=设备ip\r\nport=设备端口');

---- 设备的协议
INSERT INTO config_protocol VALUES (1, 'IEC60870-104平衡', 'cn.oleauto.iec104.IEC104ProtocolImpl', E'cotFieldLength=cot信息字节数\r\ncommonAddressFieldLength=公共地址字节数\r\nioaFieldLength=测点编号字节数\r\ncommonAddress=公共地址\r\norginAddress=源地址');

---- 通信信道
INSERT INTO config_channel VALUES (0, '000', 'mute 通道', '1', 1, '', 1, '', '', '2026-07-03 14:13:27', '2026-07-03 14:13:27', '', '');
INSERT INTO config_channel VALUES (1, '001', '电气设备通道', '0', 1, E'host=192.168.1.137\nport=2405', 1, ' ', '', '2026-07-03 15:43:11', '2026-07-03 15:38:53', 'admin', 'admin');

---- 场站数据
INSERT INTO public.config_station (id, station_name,station_code,superior_area_id,period_total,longitude,latitude,province_number,city_number,"position",installed_capacity,grid_connected_capacity,fans_pv_panelquantity,elevation,operation_time,boosterstation_voltage_level,booster_station_longitude,boosterstation_latitude,responsible_person_name,responsible_person_phone,is_enable,push_status,subject_total,is_full_power,is_del,create_by,create_time,update_by,update_time,station_type,system_power_uuid,area_id) VALUES
    (1, '江门','JMJD01','EAST01',0,'124','37','370000','370000','广东省',120000,120000,75,12.500000,'2026-7-6','110KV','121.2223','38.9087','张工','13800000000',true,1,1,true,false,'admin','2026-07-01 13:23:25.447','admin','2026-07-01 13:23:25.447',0,'','EAST01');

---- 设备数据
INSERT INTO public.config_device VALUES (1, '电气设备', 1, '1', 'ELEC', 'brand1', 'model1', 'serial1', 'GOOD', '2026-09-01', NULL, '', '2026-09-01 14:41:10.415056', '2026-09-01 14:41:10.415056', '', '');
INSERT INTO public.config_device VALUES (2, '气象设备', 3, '1', 'WEAT', 'brand1', 'model1', 'serial1', 'GOOD', '2026-09-01', NULL, '', '2026-09-01 14:41:10.415056', '2026-09-01 14:41:10.415056', '', '');

---- 测点数据
INSERT INTO public.config_point (name,code,addr,category,config_device_id,init_value,will_inverse,kb_composite,k,b,zero_filter,will_check_ud,up1,up2,down1,down2,hop_filter,lazy_tm,config_alarm_template_id,create_time,update_time,create_by,update_by) VALUES
          ('斜面辐照度','yc16392',16392,'YC',2,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('温度','yc16393',16393,'YC',2,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('气压','yc16394',16394,'YC',2,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('湿度','yc16395',16395,'YC',2,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('风速','yc16396',16396,'YC',2,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('风向','yc16397',16397,'YC',2,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('并网状态','yx4',4,'YX',1,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('限电功率','yc16389',16389,'YC',1,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('可用率','yc16390',16390,'YC',1,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('水平面总辐照度','yc16391',16391,'YC',2,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','','');
INSERT INTO public.config_point (name,code,addr,category,config_device_id,init_value,will_inverse,kb_composite,k,b,zero_filter,will_check_ud,up1,up2,down1,down2,hop_filter,lazy_tm,config_alarm_template_id,create_time,update_time,create_by,update_by) VALUES
          ('实际发电功率','yc16385',16385,'YC',1,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('理论发电功率','yc16405',16405,'YC',1,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','',''),
          ('设备状态','yx2',2,'YX',1,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2026-07-03 11:05:09','2026-07-03 11:05:09','','');                                                                                                                                                                                                                                               ('开关分合1','001',1,'YX',1,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2025-09-11 11:26:55','2025-09-11 15:40:11','','');