https://pastein.ru/t/TeM
Загрузка данных
К одной ли базе подключены приложения Приложение 1 <?xml version="1.0" encoding="utf-8"?> <Configuration> <ReportDataUiServiceConfiguration> <MaxRecords Value="10000" /> </ReportDataUiServiceConfiguration> <ChannelsSettings> <ChannelsConfiguration /> </ChannelsSettings> <ListSettings> <ListConstraints /> </ListSettings> <VehicleTypeConfiguration> <AllowVehicleTypes /> </VehicleTypeConfiguration> <HTTPHandlerParameters> <RemoveRecordsParameters> <BufferSize Value="7" /> <TimeoutMs Value="300" /> </RemoveRecordsParameters> </HTTPHandlerParameters> <HttpListenerParameters> <ThreadsCount Value="16" /> <QueueSize Value="100" /> </HttpListenerParameters> <CoreModules> <Reports> <ReportsPlateEncoding2 Value="Latin" /> <Report Name="Unknown" /> </Reports> <DatabaseServiceConfiguration> <CommandTimeout Value="90" /> <IsCustomSqlQueryEnabled Value="true" /> <FetchRecordsLimit Value="100" /> </DatabaseServiceConfiguration> <ServerServiceConfiguration> <ServerGuid Value="4d72d15a-2f86-41d7-8ffb-c69698f0ba63" /> </ServerServiceConfiguration> <UserLoginService> <AutomaticLogon IsEnabled="true"> <Username Value="VfAE3FXsTyGqWbbLqZKaxg==" /> <Password Value="VfAE3FXsTyGqWbbLqZKaxg==" /> </AutomaticLogon> </UserLoginService> <VehicleDatabasesConfiguration> <DisregardPlateRegion Value="false" /> </VehicleDatabasesConfiguration> <VehicleDatabaseRecordsConfiguration> <PassStatus Value="Null" /> </VehicleDatabaseRecordsConfiguration> </CoreModules> <GuiConfiguration> <PagesElements> <GuestPasses> <IsShowPassBtn Value="true" /> </GuestPasses> <Rebranding> <CustomLoginLogoFileName Value="" /> <CustomSideMenuFileName Value="" /> <CustomLoginBackgroundFileName Value="" /> <TechSupportLink Value="" /> <IsCopyrightHidden Value="false" /> <AppTitle Value="" /> <Favicon Value="" /> </Rebranding> </PagesElements> </GuiConfiguration> <DataStorage> <DataStorageConfiguration> <ProviderName Value="PostgreSql" /> </DataStorageConfiguration> <TokenTrackingService> <Period Value="PT10S" /> </TokenTrackingService> <FbConnectionConfiguration> <Hostname Value="127.0.0.1" /> <Port Value="3050" /> <Username Value="U1lTREJB" /> <Password Value="bWFzdGVya2V5" /> <DatabaseName Value="C:\ProgramData\Mallenom\Automarshal\Database\DEFAULT.FDB" /> </FbConnectionConfiguration> <SqlServerConnectionConfiguration> <CurrentServer Value="localhost\SQLEXPRESS" /> <DatabaseName Value="default" /> <AuthenticationType Value="Windows" /> <Username Value="" /> <Password Value="" /> <ConnectionTimeout Value="8" /> </SqlServerConnectionConfiguration> <PostgreSqlConnectionConfiguration> <DatabaseName Value="default" /> <Host Value="127.0.0.1" /> <Port Value="5432" /> <TimeOut Value="15" /> <MaxConnections Value="32" /> <AuthenticationType Value="PostgreSql" /> <UserName Value="cG9zdGdyZXM=" /> <Password Value="YWRtaW4=" /> <KeepAlive Value="3" /> <ConnectionPruningInterval Value="120" /> <ConnectionIdleLifetime Value="120" /> <ApplicationName Value="Automarshal" /> </PostgreSqlConnectionConfiguration> </DataStorage> </Configuration> Приложение 2 <?xml version="1.0" encoding="utf-8"?> <Configuration> <ProxyConfiguration> <SOCKS5> <Host Value="localhost" /> <Port Value="1080" /> </SOCKS5> </ProxyConfiguration> <CoreModules> <LicenseExpirationController> <NotificationOccured Value="true" /> <WarningOccured Value="false" /> </LicenseExpirationController> <Reports> <ReportsPlateEncoding2 Value="Latin" /> <Report Name="Unknown" /> </Reports> <DatabaseServiceConfiguration> <CommandTimeout Value="90" /> <IsCustomSqlQueryEnabled Value="true" /> <FetchRecordsLimit Value="100" /> </DatabaseServiceConfiguration> <TerritoriesGuiConfiguration> <PassStatus Value="Average" /> </TerritoriesGuiConfiguration> <ImageProcessKernel> <ManualValidationStatus Value="NotVerify" /> <MaxUnrecogSymbols Value="3" /> <ManualValidationCancelBehavior Value="StoreDefault" /> <ManualValidationChannelDirection Value="Entry" /> <ManualConditionsSign Value="Or" /> <ManualDatabasesComparisonType Value="FoundIn" /> <ManualVerifyInList Value="false" /> <ManualVerifyInVideoChannel Value="false" /> <ManualVerifyToFilter Value="false" /> <ManualVerifyChannelDirection Value="false" /> <ManualVehicleDatabases /> <ManualVideoChannels> <VideoChannel Id="0" /> </ManualVideoChannels> </ImageProcessKernel> <KernelUI> <IsAspectRatio Value="true" /> <BufferFrameCount Value="50" /> <BufferFrameDutyRatio Value="1" /> <IsProcessing Value="true" /> <IsSuspendMainProcessing Value="false" /> <UseNativeResolution Value="false" /> </KernelUI> <PlateBoundsInflater> <IsEnabled Value="false" /> <HorizontalFactor Value="1.2" /> <VerticalFactor Value="1.1" /> </PlateBoundsInflater> <PlateImageEnhancer> <PlateLinearContrast IsEnabled="true"> <K1 Value="0.05" /> <K2 Value="0.05" /> <X0 Value="0" /> <Xn Value="255" /> </PlateLinearContrast> </PlateImageEnhancer> <ModuleAutotuning> <IsEnable Value="false" /> <VideoChannelName Value="All" /> <ServerName Value="<не выбран>" /> <PrecentageFiltration Value="0" /> <MaxPlateSize> <Width Value="0" /> <Height Value="0" /> </MaxPlateSize> <MinPlateSize> <Width Value="0" /> <Height Value="0" /> </MinPlateSize> <MaxSymbolSize> <Width Value="0" /> <Height Value="0" /> </MaxSymbolSize> <MinSymbolSize> <Width Value="0" /> <Height Value="0" /> </MinSymbolSize> </ModuleAutotuning> <ImageCompressorConfiguration> <Format Value="JPEG" /> <JpegQuality Value="70" /> <PngCompressionLevel Value="7" /> <MaxHeight Value="0" /> </ImageCompressorConfiguration> <WebImageCompressorConfiguration> <Format Value="JPEG" /> <JpegQuality Value="30" /> <PngCompressionLevel Value="7" /> <MaxHeight Value="360" /> </WebImageCompressorConfiguration> <FFmpegDecoder> <DecoderFamily Value="" /> </FFmpegDecoder> <VideoRecording> <StorageDirectory Value="C:\Users\Public\Videos" /> <PreferDirectRecording Value="true" /> <EncodingAPIProviderName Value="ffmpeg" /> <Providers> <Provider Name="ffmpeg"> <Container Value="mp4" /> <Encoder Value="libopenh264" /> <Encoders> <Encoder Name="libopenh264"> <Preset Value="veryfast" /> <CRF Value="23" /> </Encoder> </Encoders> </Provider> </Providers> </VideoRecording> <ServerServiceConfiguration> <ServerGuid Value="4d72d15a-2f86-41d7-8ffb-c69698f0ba63" /> </ServerServiceConfiguration> <EmailClient> <Hostname Value="smtp.mail.ru" /> <Port Value="25" /> <Username Value="" /> <Password Value="" /> <EnableSsl Value="true" /> <Timeout Value="PT10S" /> <AuthenticationMethod Value="Password" /> <From Value="" /> <FromDisplayName Value="" /> </EmailClient> <EmailChecker> <RetryTimeout Value="PT10S" /> <RepeatsCount Value="5" /> </EmailChecker> <HttpService> <IsEnabled Value="true" /> <Port Value="5050" /> <Backlog Value="100" /> <ThreadsCount Value="4" /> <QueueSize Value="25" /> <IpAddress Value="192.168.1.111" /> </HttpService> <TagsConfiguration /> <TriggersConfiguration /> <UserLoginService> <AutomaticLogon IsEnabled="true"> <Username Value="VfAE3FXsTyGqWbbLqZKaxg==" /> <Password Value="VfAE3FXsTyGqWbbLqZKaxg==" /> </AutomaticLogon> </UserLoginService> <VehicleDatabasesConfiguration> <DisregardPlateRegion Value="false" /> </VehicleDatabasesConfiguration> <VehicleDatabaseRecordsConfiguration> <PassStatus Value="Null" /> </VehicleDatabaseRecordsConfiguration> <StringFormatter> <DefaultTags> <Tag> <DataKing Value="RecordId" /> <Token Value="RecordId" /> <TagValue Value="id" /> </Tag> <Tag> <DataKing Value="PlateNumber" /> <Token Value="PlateNumber" /> <TagValue Value="plate" /> </Tag> <Tag> <DataKing Value="PlateStencil" /> <Token Value="PlateStencil" /> <TagValue Value="stencil" /> </Tag> <Tag> <DataKing Value="Timestamp" /> <Token Value="Timestamp" /> <TagValue Value="timestamp" /> </Tag> <Tag> <DataKing Value="Time" /> <Token Value="Time" /> <TagValue Value="time" /> </Tag> <Tag> <DataKing Value="Date" /> <Token Value="Date" /> <TagValue Value="date" /> </Tag> <Tag> <DataKing Value="ChannelDirection" /> <Token Value="ChannelDirection" /> <TagValue Value="chDir" /> </Tag> <Tag> <DataKing Value="MovementDirection" /> <Token Value="MovementDirection" /> <TagValue Value="movDir" /> </Tag> <Tag> <DataKing Value="VehicleDirectionName" /> <Token Value="VehicleDirectionName" /> <TagValue Value="nameDir" /> </Tag> <Tag> <DataKing Value="VideoChannelOrderNum" /> <Token Value="VideoChannelOrderNum" /> <TagValue Value="chNum" /> </Tag> <Tag> <DataKing Value="VideoChannelName" /> <Token Value="VideoChannelName" /> <TagValue Value="chName" /> </Tag> <Tag> <DataKing Value="RecognitionStatus" /> <Token Value="RecognitionStatus" /> <TagValue Value="status" /> </Tag> <Tag> <DataKing Value="UserListName" /> <Token Value="UserListName" /> <TagValue Value="list" /> </Tag> <Tag> <DataKing Value="DongleId" /> <Token Value="DongleId" /> <TagValue Value="dongle" /> </Tag> <Tag> <DataKing Value="ISO3166_1A2" /> <Token Value="ISO3166_1A2" /> <TagValue Value="ISO3166_1A2" /> </Tag> <Tag> <DataKing Value="ISO3166_1A3" /> <Token Value="ISO3166_1A3" /> <TagValue Value="ISO3166_1A3" /> </Tag> <Tag> <DataKing Value="ISO3166_1num" /> <Token Value="ISO3166_1num" /> <TagValue Value="ISO3166_1num" /> </Tag> <Tag> <DataKing Value="Driver" /> <Token Value="Driver" /> <TagValue Value="driver" /> </Tag> <Tag> <DataKing Value="VehicleType" /> <Token Value="VehicleType" /> <TagValue Value="vehicleType" /> </Tag> <Tag> <DataKing Value="Territory" /> <Token Value="Territory" /> <TagValue Value="territory" /> </Tag> <Tag> <DataKing Value="Duration" /> <Token Value="Duration" /> <TagValue Value="duration" /> </Tag> <Tag> <DataKing Value="Speed" /> <Token Value="Speed" /> <TagValue Value="speed" /> </Tag> <Tag> <DataKing Value="Payment" /> <Token Value="Payment" /> <TagValue Value="payment" /> </Tag> <Tag> <DataKing Value="Currency" /> <Token Value="Currency" /> <TagValue Value="currency" /> </Tag> <Tag> <DataKing Value="Tarificator" /> <Token Value="Tarificator" /> <TagValue Value="tarificator" /> </Tag> <Tag> <DataKing Value="SignalLostTimestamp" /> <Token Value="SignalLostTimestamp" /> <TagValue Value="signalLostTimestamp" /> </Tag> <Tag> <DataKing Value="ParkingSpaceFreeCount" /> <Token Value="ParkingSpaceFreeCount" /> <TagValue Value="parkingSpaceFreeCount" /> </Tag> <Tag> <DataKing Value="ParkingSpaceFreeCountForUserList" /> <Token Value="ParkingSpaceFreeCountForUserList" /> <TagValue Value="parkingSpaceFreeCountForUserList" /> </Tag> <Tag> <DataKing Value="MotionState" /> <Token Value="MotionState" /> <TagValue Value="motionState" /> </Tag> <Tag> <DataKing Value="OperatorUsername" /> <Token Value="OperatorUsername" /> <TagValue Value="operatorUsername" /> </Tag> <Tag> <DataKing Value="OperatorDisplayName" /> <Token Value="OperatorDisplayName" /> <TagValue Value="operatorDisplayName" /> </Tag> <Tag> <DataKing Value="IsOperatorOnWorkPlace" /> <Token Value="IsOperatorOnWorkPlace" /> <TagValue Value="isOperatorOnWorkPlace" /> </Tag> </DefaultTags> </StringFormatter> </CoreModules> <Application> <Misc> <LockWindows Value="false" /> <Locale Value="ru-RU" /> </Misc> <GeoSettings> <City Value="Москва" /> <Latitude Value="55.755773" /> <Longitude Value="37.617761" /> </GeoSettings> </Application> <CustomReportParameters> <OutsideLists Value="false" /> <SqlFilePath Value="" /> <IsSqlFileFilterEnabled Value="false" /> <SelectedVehicleDatabasesName /> </CustomReportParameters> <DataStorage> <DataStorageConfiguration> <ProviderName Value="PostgreSql" /> </DataStorageConfiguration> <TokenTrackingService> <Period Value="PT10S" /> </TokenTrackingService> <FbConnectionConfiguration> <Hostname Value="127.0.0.1" /> <Port Value="3050" /> <Username Value="U1lTREJB" /> <Password Value="bWFzdGVya2V5" /> <DatabaseName Value="C:\ProgramData\Mallenom\Automarshal\Database\DEFAULT.FDB" /> </FbConnectionConfiguration> <SqlServerConnectionConfiguration> <CurrentServer Value="localhost\SQLEXPRESS" /> <DatabaseName Value="default" /> <AuthenticationType Value="Windows" /> <Username Value="" /> <Password Value="" /> <ConnectionTimeout Value="8" /> </SqlServerConnectionConfiguration> <PostgreSqlConnectionConfiguration> <DatabaseName Value="default" /> <Host Value="127.0.0.1" /> <Port Value="5432" /> <TimeOut Value="15" /> <MaxConnections Value="32" /> <AuthenticationType Value="PostgreSql" /> <UserName Value="cG9zdGdyZXM=" /> <Password Value="YWRtaW4=" /> <KeepAlive Value="3" /> <ConnectionPruningInterval Value="120" /> <ConnectionIdleLifetime Value="120" /> <ApplicationName Value="Automarshal" /> </PostgreSqlConnectionConfiguration> <VehicleDatabaseColorSetting> <ColorSettingType Value="1" /> <Colors> <Color Value="-23296" /> <Color Value="-14259859" /> </Colors> </VehicleDatabaseColorSetting> <UserListImportSetting> <DirectoryPath Value="" /> <ImportUserlListType Value="None" /> <ImportPlatesConfiguration Value="DubbingDuplicateNumbers" /> </UserListImportSetting> <UserListExportSetting> <Path Value="" /> <Extension Value="xml" /> </UserListExportSetting> <UsersExportSetting> <Path Value="" /> </UsersExportSetting> <UserGroupsExportSetting> <Path Value="" /> </UserGroupsExportSetting> </DataStorage> <AdvancedOptionsView> <AdvancedOptionsView> <MinSavingEntitiesLimit Value="1000" /> <MaxSavingEntitiesLimit Value="5000" /> <Options> <FetchCacheLimit Value="500" /> <EntityCacheLimit Value="500" /> <MigrationStep Value="Null" /> <TableGroups Value="4095" /> </Options> </AdvancedOptionsView> </AdvancedOptionsView> <VehicleRegistrationLog> <Filters> <DisplayLimit Value="100" /> <SelectedDirection Value="AllDirections" /> <DateTimeRangeTemplate Value="Last30Days" /> <IncludeUnmatchedVehicles Value="true" /> <Servers> <Servers Name="4d72d15a-2f86-41d7-8ffb-c69698f0ba63"> <VideoChannels> <VideoChannels Id="0"> <HasVideoChannel Value="true" /> </VideoChannels> <VideoChannels Id="1"> <HasVideoChannel Value="true" /> </VideoChannels> </VideoChannels> </Servers> </Servers> <VehicleDatabases /> </Filters> <Explorer> <ShowDetails Value="false" /> </Explorer> <Columns> <DefaultColumns> <Column Name="Plate"> <Width Value="90" /> </Column> <Column Name="VehicleType"> <Width Value="100" /> <IsVisible Value="true" /> <Order Value="10" /> </Column> <Column Name="Direction"> <IsVisible Value="true" /> <Order Value="2" /> </Column> <Column Name="Status"> <IsVisible Value="true" /> <Order Value="3" /> </Column> <Column Name="TimeStamp"> <Width Value="115" /> <Order Value="1" /> <Format Value="dd.MM.yyyy HH:mm:ss" /> </Column> <Column Name="VideoChannel"> <Width Value="90" /> <IsVisible Value="true" /> <Order Value="6" /> </Column> <Column Name="Server"> <Width Value="100" /> <IsVisible Value="true" /> <Order Value="11" /> </Column> <Column Name="Operator"> <Width Value="100" /> <IsVisible Value="true" /> <Order Value="7" /> </Column> <Column Name="VehicleLists"> <Width Value="100" /> <IsVisible Value="false" /> <Order Value="12" /> </Column> <Column Name="ParkingTime"> <Width Value="160" /> <IsVisible Value="true" /> <Order Value="13" /> <Format Value="dd\.hh\:mm\:ss" /> </Column> <Column Name="Passage"> <IsVisible Value="true" /> <Order Value="14" /> </Column> <Column Name="VehicleDirectionName"> <Width Value="100" /> <IsVisible Value="true" /> <Order Value="15" /> </Column> <Column Name="CountryCode"> <IsVisible Value="true" /> <Order Value="4" /> </Column> <Column Name="Country"> <IsVisible Value="true" /> <Order Value="5" /> </Column> <Column Name="RecordFlags"> <IsVisible Value="false" /> <Order Value="16" /> </Column> <Column Name="VehicleDriverFullName"> <Width Value="100" /> <IsVisible Value="true" /> <Order Value="8" /> </Column> <Column Name="Territory"> <Width Value="100" /> <IsVisible Value="false" /> <Order Value="9" /> </Column> </DefaultColumns> <FieldsColumns> <Column FieldName="PassStatusFieldBegin"> <Width Value="90" /> <IsVisible Value="true" /> <Order Value="17" /> </Column> <Column FieldName="PassStatusFieldAction"> <Width Value="90" /> <IsVisible Value="true" /> <Order Value="18" /> </Column> <Column FieldName="PassStatusField"> <Width Value="90" /> <IsVisible Value="true" /> <Order Value="19" /> </Column> <Column FieldName="PassStatusFieldTime"> <Width Value="90" /> <IsVisible Value="true" /> <Order Value="20" /> </Column> <Column FieldName="PassStatusFieldCount"> <Width Value="90" /> <IsVisible Value="true" /> <Order Value="21" /> </Column> </FieldsColumns> </Columns> </VehicleRegistrationLog> <Views> <MainForm> <Layout> <Bounds X="537" Y="288" Width="2765" Height="1487" /> <WindowState Value="Normal" /> <Splitters> <Splitter Distance="716"> <Panel /> <Splitter Distance="458"> <Panel /> <Panel /> </Splitter> </Splitter> </Splitters> <DisplayEntryExitDetailView Value="false" /> <VehicleComparsionDetaislMode Value="Null" /> </Layout> <VideoGrid> <Layouts /> <ShowContextMenu Value="true" /> </VideoGrid> <StartMinimized Value="false" /> <MinimizeToTray Value="false" /> <CloseWithWarn Value="false" /> </MainForm> <LogForm /> <LastPlateForm /> <EditPlateForm /> <VehicleRegistrationForm> <AutoFillMode Value="Disabled" /> <DriverAutoFill Value="true" /> <DriverRequired Value="false" /> <AutoClose Value="false" /> <UpdateDelay Value="true" /> <SecondsToAutoClose Value="30" /> <MillisecondsToUpdate Value="1000" /> <DirectionRequired Value="false" /> <ShowDriverView Value="false" /> <SaveWithoutAccept Value="false" /> <AskBeforeCancel Value="true" /> </VehicleRegistrationForm> <CreateAdditionalImageForm /> <VehicleDriverPhotoForm /> </Views> <VehicleRegistrationDetails> <DetailsFields> <Fields /> </DetailsFields> </VehicleRegistrationDetails> <Recognition> <VehicleListsKnownPlatesListProvider IsEnabled="true"> <MaxEntries Value="1000" /> </VehicleListsKnownPlatesListProvider> </Recognition> <VideoChannelPriorityConfiguration> <IsEnabled Value="false" /> </VideoChannelPriorityConfiguration> <ReportDataUiServiceConfiguration> <MaxRecords Value="10000" /> </ReportDataUiServiceConfiguration> <ControlZones> <Zones /> </ControlZones> </Configuration>