Вдруг кому пригодится.
Модуль работает на SQL Server Compact Edition. Базу AdiPNV.sdf можно читать и править
. Подключение через встроенный в Windows драйвер, моя строка "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=C:\Program Files\Adicom\PNV\AdiPNV.sdf"
Импорт параметров источников выброса предприятия: SELECT A.OBJ_NAME, A.OBJ_ORD_NUMB, A.ISKI, EO_TYPE, A.OBJ_AREA_TYPE, POINT_X, POINT_Y, EO_HEIGHT, EO_DIAMETER, EO_LENGTH, EO_WIDTH, EO_TEMP_GVS, EO_SPEED_GVS, EO_VOLUME_GVS, EO_PERC_PNG, EO_MOG_CO2, B.OBJ_NAME, OKATO_CODE, A.OBJ_LOCATION, A.OBJ_EXPLOITATION, A.URBAN_AIR, A.PROTECT_AREA, A.MED_AREA, A.NORTH_AREA, A.BAIKAL_AREA, A.ECODIS_ZONE FROM COBJECT A INNER JOIN COBJECT B ON B.OBJ_ID=A.PARENT_ID INNER JOIN EMISS_OBJECT ON A.OBJ_ID=EMISS_OBJECT.OBJ_ID INNER JOIN OBJ_COORDINATES ON A.OBJ_ID=OBJ_COORDINATES.OBJ_ID INNER JOIN R_OKATO ON A.OKATO_ID=R_OKATO.OKATO_ID WHERE A.OBJ_TYPE=4 AND A.ORG_ID='ORG_ID ID ОРГАНИЗАЦИИ ИЗ ТАБЛИЦЫ ORGANIZATION'
Импорт выбросов источников выбросов предприятия: SELECT OBJ_ORD_NUMB, ORG_POLLUTANT.AERO_ID, AP_NAME, OEF_EMISS_POWER, OEF_MOG FROM COBJECT INNER JOIN OREG_EMISS_FACT ON COBJECT.OBJ_ID=OREG_EMISS_FACT.OBJ_ID INNER JOIN ORG_POLLUTANT ON OREG_EMISS_FACT.OrgPollutantId=ORG_POLLUTANT.POL_ID INNER JOIN R_AERO_POLUTION ON ORG_POLLUTANT.AERO_ID=R_AERO_POLUTION.AERO_ID WHERE COBJECT.OBJ_TYPE=4 AND COBJECT.ORG_ID='ORG_ID ID ОРГАНИЗАЦИИ ИЗ ТАБЛИЦЫ ORGANIZATION'
Импорт параметров выпусков предприятия: SELECT A.OBJ_NAME, A.OBJ_ORD_NUMB, POINT_X, POINT_Y, WSH_NAME, A.POPUL_LOC, A.DRINK_WTS, A.MG_FON, A.FISH_CAT, WP_DESCR, WS_DESCR, A.DOC_NAME, A.DOC_NUM, A.DOC_DATE, B.OBJ_NAME, OKATO_CODE, A.OBJ_LOCATION, A.OBJ_EXPLOITATION, SEA_NAME, A.SEA_TYPE, A.URBAN_AIR, A.PROTECT_AREA, A.MED_AREA, A.NORTH_AREA, A.BAIKAL_AREA, A.ECODIS_ZONE FROM COBJECT A INNER JOIN COBJECT B ON B.OBJ_ID=A.PARENT_ID INNER JOIN OBJ_COORDINATES ON A.OBJ_ID=OBJ_COORDINATES.OBJ_ID INNER JOIN R_WATERSHED ON A.WTS_ID=R_WATERSHED.WSH_ID INNER JOIN R_OKATO ON A.OKATO_ID=R_OKATO.OKATO_ID INNER JOIN WATER_OBJECT ON WATER_OBJECT.OBJ_ID=A.OBJ_ID INNER JOIN R_WATER_PURPOSE ON WATER_OBJECT.WP_ID=R_WATER_PURPOSE.WP_ID INNER JOIN R_WATER_SPECIES ON WATER_OBJECT.WS_ID=R_WATER_SPECIES.WS_ID INNER JOIN R_SEA_RF ON A.SEA_ID=R_SEA_RF.SEA_ID WHERE A.OBJ_TYPE=2 AND A.ORG_ID='ORG_ID ID ОРГАНИЗАЦИИ ИЗ ТАБЛИЦЫ ORGANIZATION'
Импорт состава сбросов по выпускам предприятия: SELECT OBJ_ORD_NUMB, OWF_LIMG, OWF_SVLIMG, ORG_POLLUTANT.AQUA_ID, AQP_NAME, OWF_SBG FROM COBJECT INNER JOIN WATER_OBJECT ON COBJECT.OBJ_ID=WATER_OBJECT.OBJ_ID INNER JOIN OREG_WATER_FACT ON COBJECT.OBJ_ID=OREG_WATER_FACT.OBJ_ID INNER JOIN ORG_POLLUTANT ON OREG_WATER_FACT.OrgPollutantId=ORG_POLLUTANT.POL_ID INNER JOIN R_AQUA_POLUTION ON ORG_POLLUTANT.AQUA_ID=R_AQUA_POLUTION.AQUA_ID WHERE COBJECT.OBJ_TYPE=2 AND COBJECT.ORG_ID='ORG_ID ID ОРГАНИЗАЦИИ ИЗ ТАБЛИЦЫ ORGANIZATION'
Импорт параметров ОРО предприятия: SELECT A.OBJ_NAME, POINT_X, POINT_Y, REGNUM_WSO, GRORO_NUM, ORO_ORDER, A.DOC_NAME, A.DOC_NUM, A.DOC_DATE, B.OBJ_NAME, OKATO_CODE, A.OBJ_LOCATION, A.OBJ_EXPLOITATION, SEA_NAME, A.SEA_TYPE, IND_SPEC, IND_ZONE, A.URBAN_AIR, A.PROTECT_AREA, A.MED_AREA, A.NORTH_AREA, A.BAIKAL_AREA, A.ECODIS_ZONE FROM COBJECT A INNER JOIN COBJECT B ON B.OBJ_ID=A.PARENT_ID INNER JOIN WASTE_OBJECT ON A.OBJ_ID=WASTE_OBJECT.OBJ_ID INNER JOIN OBJ_COORDINATES ON A.OBJ_ID=OBJ_COORDINATES.OBJ_ID INNER JOIN R_OKATO ON A.OKATO_ID=R_OKATO.OKATO_ID INNER JOIN R_SEA_RF ON A.SEA_ID=R_SEA_RF.SEA_ID WHERE A.OBJ_TYPE=3 AND A.ORG_ID='ORG_ID ID ОРГАНИЗАЦИИ ИЗ ТАБЛИЦЫ ORGANIZATION'
Импорт перечня отходов по ОРО предприятия: SELECT OBJ_NAME, UCH_NUM_ORO, WST_CODE, WST_NAME, OWSF_RAZM FROM COBJECT INNER JOIN WASTE_OBJECT ON COBJECT.OBJ_ID=WASTE_OBJECT.OBJ_ID INNER JOIN OREG_WASTE_FACT ON COBJECT.OBJ_ID=OREG_WASTE_FACT.OBJ_ID INNER JOIN ORG_POLLUTANT ON OREG_WASTE_FACT.OrgPollutantId=ORG_POLLUTANT.POL_ID INNER JOIN R_WASTES ON ORG_POLLUTANT.WASTE_ID=R_WASTES.WASTE_ID WHERE COBJECT.OBJ_TYPE=3 AND COBJECT.ORG_ID='ORG_ID ID ОРГАНИЗАЦИИ ИЗ ТАБЛИЦЫ ORGANIZATION'
Описание основных таблиц БД в прикрепленном текстовом документе.
