A Method for Point-in-Time Video Replay of a Real-Time Database

Abstract

The present invention discloses a method for real-time database point-in-time video playback. The software environment for its application is: installing any version of the historical database software in 2017; the hardware environment for its application is: at least one NVR of any model from Hikvision. The method for real-time database point-in-time video playback includes the following steps: for the case where different NVRs need to be adapted and are already encapsulated, embed the SDK (CHCNetSDK.CS) of the NVR into the C# project for invocation; for the case where there are multiple NVRs at the customer site, store the information of multiple NVRs locally in C#, then confirm the information corresponding to the username, password, IP, and Port. At the same time, ensure with the owner that one IP address corresponds to one NVR, so that the NVR boxes do not overlap and do not cause duplicate IP addresses to be invoked, preventing incorrect reference to channels. The present invention solves the technical problem that different NVRs need to be adapted and are already encapsulated; moreover, when there are multiple NVRs at the customer site, it can connect to the correct NVR.

Description

Technical Field

[0001] The present invention relates to a video playback method, and in particular to a real-time database point-in-time video playback method, an operation method of the real-time database point-in-time video playback method, and a computer-readable storage medium for executing the real-time database point-in-time video playback method. Background Art

[0002] For the case where a computer is installed with any version of Historian2017 (historical database software 2017) and a Hikvision NVR of any model is equipped on-site, the historical images cannot appear on the same screen as Historian at the same time point. The difficulties are as follows Figure 1 shown. Different NVRs need to be adapted, which are encapsulated and contain technical barriers. After consulting the technology of Hikvision, its dedicated development kit is used to test and solve the problem. If there are multiple NVRs at the customer site, it is a rather important issue to connect to the correct NVR using C#. Incorrect IP addresses and Port numbers will connect to the wrong device screen. Summary of the Invention

[0003] In order to solve the technical problems that different NVRs need to be adapted, which are encapsulated, and that incorrect IP addresses and Port numbers of multiple NVRs at the customer site will connect to the wrong device screen, the present invention provides a real-time database point-in-time video playback method, an operation method of the real-time database point-in-time video playback method, and a computer-readable storage medium for executing the real-time database point-in-time video playback method.

[0004] The present invention is implemented by the following technical solutions: A real-time database point-in-time video playback method, the software environment it applies to is: installing any version of historical database software 2017; the hardware environment it applies to is: at least one Hikvision NVR of any model; the real-time database point-in-time video playback method includes the following steps:

[0005] For the case where different NVRs need to be adapted, which are encapsulated, embed CHCNetSDK.CS of the NVR into the C# project for calling;

[0006] For the case where there are multiple NVRs at the customer site, store information of multiple NVRs locally in C#, then confirm the information corresponding to the username, password, IP, and Port. At the same time, ensure with the owner that one IP number corresponds to one NVR, so that the NVR boxes do not overlap and do not cause duplicate IP addresses to be called, preventing incorrect reference to channels.

[0007] As a further improvement of the above solution, the real-time database point-in-time video playback method further includes the following steps:

[0008] For the channel acquisition design in the NVR, use System.Runtime.InteropServices.Marshal in CHCNetSDK.CS to call transcoding to obtain the correct channel number and channel alias.

[0009] As a further improvement of the above solution, the real-time database point video playback method further includes the following steps:

[0010] For the situation where after configuring information in the C# project and it is necessary to confirm which window corresponds to which channel during video window playback, create an NVR group, determine the correct NVR and channel through the key position, and execute the playback script.

[0011] As a further improvement of the above solution, the real-time database point video playback method further includes the following steps:

[0012] Regarding the use of the Historian Client of the historical database software in C#, extract the relevant DLL files in the AVEVA WSP installation software and add them to the C# project, and reference the functions of aaHistClientTagPicker.dll and aaHistClientTrendControl.dll.

[0013] As a further improvement of the above solution, the real-time database point video playback method further includes the following steps:

[0014] For the situation of viewing the trend curve and the video playback window, use a ContextMenuStrip control to distinguish between the upper and lower layers.

[0015] As a further improvement of the above solution, the real-time database point video playback method further includes the following steps:

[0016] For the situation where the historical database software and the Hikvision display window display the same start time node and end time node, use dateTimeStart in System.Windows.Forms.DateTime as the start time node and dateTimeEnd in System.Windows.Forms.DateTime as the end time node.

[0017] As a further improvement of the above solution, the real-time database point video playback method further includes the following steps:

[0018] To make the time playback point of the historian Client of the historical database software consistent with the time of the video playback window, use HCNetSDK.NET_DVR_PlayBackControl_V40(m_lPlayHandle, CHCNetSDK.NET_DVR_PLAYPAUSE, IntPtr.Zero, 0, IntPtr.Zero, ref iOutValue) to compare with the time point every specific time, and call the corresponding picture after calibrating the time.

[0019] The present invention also provides an operation method for any of the above real-time database time point video playback methods. The operation method of the real-time database time point video playback method includes the following steps:

[0020] Step 1, configure the corresponding information of the NVR for viewing historical videos;

[0021] Step 2, click to test the communication with the NVR and restart the program;

[0022] Step 3, open the pre-saved Historian trend file *.aaTrend;

[0023] Step 4, the interface determines whether the NVR and the trend file are successful;

[0024] Step 5, if the run button has no response, the login fails;

[0025] Step 6, it is necessary to determine which item in the configuration has a problem and reconfigure it;

[0026] Step 7, if a historical video picture is generated, it means the operation is successful and the user can continue to operate.

[0027] As a further improvement of the above solution, the NVR corresponding information includes the IP address, port number, username, and password of the NVR.

[0028] The present invention also provides a computer-readable storage medium, on which a computer program is stored. When the program is executed by a processor, the steps of any of the above real-time database time point video playback methods are implemented.

[0029] The beneficial effects of the present invention are:

[0030] (1) Solve the technical problem that different NVRs need to be adapted, which is a packaged technology;

[0031] (2) When there are multiple NVRs at the customer site, it can connect to the correct NVR;

[0032] (3) Re-correspond the channel number and channel alias, and can normally display the configuration information;

[0033] (4) It can achieve a one-to-one correspondence between the window and the channel during video window playback;

[0034] (5) Realize the free use of HistorianClient in C#;

[0035] (6) It can conveniently view the trend curve and the video playback window;

[0036] (7) When synchronously viewing the trend curve and the video playback window, the start and end time nodes can coincide;

[0037] (8) It can make the time playback point of the historian Client consistent with the time of the video playback window Description of the Drawings

[0038] Figure 1 It is a schematic diagram of the defects existing in the prior art;

[0039] Figure 2 It is a flowchart of the operation method of the real-time database time point video playback method of the present invention. Detailed Embodiments

[0040] In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0041] The real-time database time point video playback method of the present invention is obtained in the process of solving practical applications, and the whole method will be introduced in detail below.

[0042] I. Adapt to the NVR of Hikvision model

[0043] Problem:

[0044] Adapting different NVRs is encapsulated and contains technical barriers. After consulting the technology of Hikvision, its special development package is used to test and solve the problem.

[0045] Solution process:

[0046] Query the relevant SDK (CHCNetSDK.CS) on the Hikvision official website and embed it in the C# project for calling.

[0047] II. Solve the problem of connecting to the correct NVR

[0048] Problem:

[0049] There are multiple NVRs at the customer site. Connecting to the correct NVR using C# is a rather important issue. Incorrect IP addresses and Port numbers will lead to connecting to the wrong device screen.

[0050] Solution process:

[0051] Store information of multiple NVRs locally in C#, then confirm the information corresponding to the username, password, IP, and Port. At the same time, ensure with the owner that one IP number corresponds to one NVR, so that the NVR boxes do not overlap and do not cause duplicate IP addresses to be called, preventing incorrect reference to channels.

[0052] It is found in the research of Hikvision SDK that by using Login through the method CHCNetSDK.NET_DVR_Login_V30(IP, Int16.Parse(Port), UserName, Password, ref DeviceInfo) in the SDK, it is possible to successfully log in to the corresponding NVR machine, laying the foundation for obtaining channel signals and images in the next step.

[0053] III. Solve the problem of channel number and channel alias transcoding

[0054] Problem:

[0055] Channels in the NVR at the customer site are obtained normally. The channel numbers are allocated in sequence as Arabic numerals 1, 2, 3. As the most important part of the main differentiation identification of the channel number, the alias needs to be specifically corresponded and displayed. Because it is very difficult for the owner to find the required channel among more than 60 channel numbers of Arabic numerals 1, 2, 3, the Chinese alias makes the use of this software very convenient.

[0056] Solution process:

[0057] However, the alias is not a standard function. In the script given by the SDK during testing, it took a long time to test the function for correctly corresponding the alias. Use System.Runtime.InteropServices.Marshal in CHCNetSDK.CS to call transcoding to obtain the correct channel number and channel alias.

[0058] The channel number and channel alias are re-corresponded, and the configuration information can be displayed normally.

[0059] uint dwSize = (uint)Marshal.SizeOf(m_struIpParaCfgV40);

[0060] IntPtr ptrIpParaCfgV40 = Marshal.AllocHGlobal((Int32)dwSize);

[0061] Marshal.StructureToPtr(m_struIpParaCfgV40, ptrIpParaCfgV40, false);

[0062] m_struChanNoInfo.Init(); / / Alias

[0063] Int32 nSize = Marshal.SizeOf(m_struPicCfgV40); / / Alias

[0064] IntPtr ptrPicCfg = Marshal.AllocHGlobal(nSize); / / Alias

[0065] Marshal.StructureToPtr(m_struPicCfgV40, ptrPicCfg, false); / / Alias

[0066] uint dwReturn = 0;

[0067] int iGroupNo = 0; / / This demo only gets the first group of 64 channels. If the device has more than 64 IP channels, you need to call NET_DVR_GET_IPPARACFG_V40 multiple times by group number 0~i

[0068] if (!CHCNetSDK.NET_DVR_GetDVRConfig(m_lUserID, CHCNetSDK.NET_DVR_GET_IPPARACFG_V40, iGroupNo, ptrIpParaCfgV40, dwSize, ref dwReturn))

[0069] {iLastErr = CHCNetSDK.NET_DVR_GetLastError();

[0070] str1 = "NET_DVR_GET_IPPARACFG_V40 failed, error code = " + iLastErr; / / Failed to get IP resource configuration information, output the error number

[0071] returnnum = str1;

[0072] }

[0073] else

[0074] {

[0075] m_struIpParaCfgV40=(CHCNetSDK.NET_DVR_IPPARACFG_V40)Marshal.PtrToStructure(ptrIpParaCfgV40,typeof(CHCNetSDK.NET_DVR_IPPARACFG_V40));

[0076] for(i=0;i <dwAChanTotalNum;i++)

[0077] {

[0078] ListAnalogChannel(i+1,m_struIpParaCfgV40.byAnalogChanEnable[i]);

[0079] iChannelNum[i]=i+(int)DeviceInfo.byStartChan;

[0080] }

[0081] bytebyStreamType;

[0082] uintiDChanNum=64;

[0083] if(dwDChanTotalNum<64)

[0084] {

[0085] iDChanNum=dwDChanTotalNum; / / If the device IP channel is less than 64, obtain it according to the actual number of channels

[0086] }

[0087] for(i=0;i <iDChanNum;i++)

[0088] {

[0089] iChannelNum[i+dwAChanTotalNum]=i+(int)m_struIpParaCfgV40.dwStartDChan;

[0090] byStreamType=m_struIpParaCfgV40.struStreamMode[i].byGetStreamType;

[0091] m_unionGetStream = m_struIpParaCfgV40.struStreamMode[i].uGetStream;

[0092] switch (byStreamType)

[0093] {

[0094] / / Currently, the NVR only supports one way: 0 - directly retrieve the stream from the device

[0095] case 0:

[0096] dwSize = (uint)Marshal.SizeOf(m_unionGetStream);

[0097] IntPtr ptrChanInfo = Marshal.AllocHGlobal((Int32)dwSize);

[0098] Marshal.StructureToPtr(m_unionGetStream, ptrChanInfo, false);

[0099] m_struChanInfo = (CHCNetSDK.NET_DVR_IPCHANINFO)Marshal.PtrToStructure(ptrChanInfo, typeof(CHCNetSDK.NET_DVR_IPCHANINFO));

[0100] CHCNetSDK.NET_DVR_GetDVRConfig(m_lUserID, CHCNetSDK.NET_DVR_GET_PICCFG_V40, iChannelNum[i], ptrPicCfg, (UInt32)nSize, ref dwReturn); / / Alias

[0101] m_struPicCfgV40 = (CHCNetSDK.NET_DVR_PICCFG_V40)Marshal.PtrToStructure(ptrPicCfg, typeof(CHCNetSDK.NET_DVR_PICCFG_V40)); / / Alias

[0102] / / List the IP channels

[0103] ChannelIPNum[i] = Convert.ToInt32(m_struChanInfo.byIPID);

[0104] ChannelStatusNum[i] = Convert.ToString(m_struChanInfo.byEnable);

[0105] string ChanOthername = Encoding.GetEncoding("GBK").GetString(m_struPicCfgV40.sChanName).Trim(); / / Alias

[0106] ListIPChannel(i + 1, m_struChanInfo.byEnable, m_struChanInfo.byIPID, ChanOthername); / / The last one is the alias

[0107] Marshal.FreeHGlobal(ptrChanInfo);

[0108] break;

[0109] default:

[0110] break;}}}

[0111] Marshal.FreeHGlobal(ptrIpParaCfgV40);

[0112] IV. Play a certain channel of multiple Hikvision NVRs

[0113] Problem:

[0114] After configuring the information in the C# project, it is necessary to confirm which window corresponds to which channel when playing in the video window. Therefore, a pop-up window is required to index the corresponding window.

[0115] Solution process:

[0116] Create an NVR group, determine the correct NVR and channel based on the button position, and execute the following playback script:

[0117] c1.playbackbytime(c1.ChangeChan - 1, pictureBox1.Handle, dateTimeStart.Value.AddSeconds(-2), dateTimeStart.Value.AddHours(1), refCS1.m_lPlayHandles);

[0118] public void playbackbytime(int chan, IntPtr pichandle, DateTime startdt, DateTime enddt, ref int m_lPlayHandle)

[0119] {

[0120] if (nvrr.m_lUserID < 0)

[0121] {

[0122] nvrr.Login();

[0123] }

[0124] if (m_lPlayHandle >= 0)

[0125] {

[0126] / / If already playing back, stop playback first

[0127] if (!CHCNetSDK.NET_DVR_StopPlayBack(m_lPlayHandle))

[0128] {

[0129] iLastErr = CHCNetSDK.NET_DVR_GetLastError();

[0130] errmsg = "NET_DVR_StopPlayBack failed, error code = " + iLastErr;

[0131] return;

[0132] }

[0133] m_bReverse = false;

[0134] m_bPause = false;

[0135] return;

[0136] }

[0137] CHCNetSDK.NET_DVR_VOD_PARA struVodPara = new CHCNetSDK.NET_DVR_VOD_PARA();

[0138] struVodPara.dwSize = (uint)Marshal.SizeOf(struVodPara);

[0139] struVodPara.struIDInfo.dwChannel = (uint)nvrr.iChannelNum[(int)chan]; / / Channel number

[0140] struVodPara.hWnd = pichandle; / / Playback window handle

[0141] / / Set the starting time to search video files

[0142] struVodPara.struBeginTime.dwYear = (uint)startdt.Year;

[0143] struVodPara.struBeginTime.dwMonth = (uint)startdt.Month;

[0144] struVodPara.struBeginTime.dwDay = (uint)startdt.Day;

[0145] struVodPara.struBeginTime.dwHour = (uint)startdt.Hour;

[0146] struVodPara.struBeginTime.dwMinute = (uint)startdt.Minute;

[0147] struVodPara.struBeginTime.dwSecond = (uint)startdt.Second;

[0148] / / Set the stopping time to search video files

[0149] struVodPara.struEndTime.dwYear = (uint)enddt.Year;

[0150] struVodPara.struEndTime.dwMonth = (uint)enddt.Month;

[0151] struVodPara.struEndTime.dwDay = (uint)enddt.Day;

[0152] struVodPara.struEndTime.dwHour = (uint)enddt.Hour;

[0153] struVodPara.struEndTime.dwMinute = (uint)enddt.Minute;

[0154] struVodPara.struEndTime.dwSecond = (uint)enddt.Second;

[0155] / / Playback by time

[0156] m_lPlayHandle = CHCNetSDK.NET_DVR_PlayBackByTime_V40(nvrr.m_lUserID, ref struVodPara);

[0157] if (m_lPlayHandle < 0)

[0158] {

[0159] iLastErr = CHCNetSDK.NET_DVR_GetLastError();

[0160] errmsg = "NET_DVR_PlayBackByTime_V40 failed, error code = " + iLastErr;

[0161] return;

[0162] }

[0163] uint iOutValue = 0;

[0164] if(!CHCNetSDK.NET_DVR_PlayBackControl_V40(m_lPlayHandle,CHCNetSDK.NET_DVR_PLAYSTART,IntPtr.Zero,0,IntPtr.Zero,refiOutValue))

[0165] {

[0166] iLastErr=CHCNetSDK.NET_DVR_GetLastError();

[0167] errmsg="NET_DVR_PLAYSTARTfailed,errorcode="+iLastErr; / / Playback control failed, output error code

[0168] return;}}

[0169] 6. Adapting Historian Client

[0170] question:

[0171] To use HistorianClient in C#, you need to call the proprietary HistorianClient dll control.

[0172] Solution process:

[0173] In the AVEVA WSP installation software, extract the relevant DLL files and add them to the C# project, and reference the aaHistClientTagPicker.dll and aaHistClientTrendControl.dll functions.

[0174] 7. Solve the problem of upper and lower areas

[0175] question:

[0176] The display should be separated into upper and lower parts so that the trend curve and video playback window can be easily viewed.

[0177] Solution process:

[0178] A ContextMenuStrip control is used to distinguish the upper and lower layers.

[0179] 8. The Historian and Hikvision display windows show the same start and end time nodes

[0180] question:

[0181] The most important overlapping information for synchronous viewing of the trend curve and the video playback window is the start and end time nodes. Only by overlapping the time nodes of these two parts can the key problem of this invention software be solved.

[0182] Solution process:

[0183] Use dateTimeStart in System.Windows.Forms.DateTime as the start time node, and dateTimeEnd in System.Windows.Forms.DateTime as the end time node.

[0184] IX. Video storage function

[0185] Problem:

[0186] When querying videos, effective video files can be stored by downloading the videos for subsequent troubleshooting.

[0187] Solution process:

[0188] Path.ChangeExtension(Application.ExecutablePath, ".xml");

[0189] X. Linear synchronization function

[0190] Problem:

[0191] To keep the time playback point of the historian Client consistent with the time of the video playback window, real-time performance is very important, which is the core problem of this invention software.

[0192] Solution process:

[0193] Use CHCNetSDK.NET_DVR_PlayBackControl_V40(m_lPlayHandle,CHCNetSDK.NET_DVR_PLAYPAUSE, IntPtr.Zero, 0, IntPtr.Zero, ref iOutValue) to compare with the time point at every specific time interval. After calibrating the time, call the corresponding picture according to the time.

[0194] Please refer to Figure 1 , the computer needs to install any version of Historian2017 and any model of Hikvision NVR needs to be equipped on-site. The operation method of the real-time database time point video playback method includes the following steps:

[0195] Step 1: Configure the corresponding information of the NVR for which historical videos are to be viewed. This includes the IP address, port number, username, and password of the NVR (multiple NVRs are supported);

[0196] Step 2: Click to test the communication with the NVR and restart the program;

[0197] Step 3: Open the pre-saved Historian trend file (*.aaTrend);

[0198] Step 4: The interface determines whether the NVR and the trend file are successful;

[0199] Step 5: If the run button has no response, the login fails;

[0200] Step 6: It is necessary to determine which item in the configuration has a problem and reconfigure it;

[0201] Step 7: If historical video images are generated, it indicates successful operation, and the user can continue to operate.

[0202] When the real-time database point-in-time video playback method of the present invention is designed as a program to implement the function, a computer-readable storage medium can be adopted. A computer program is stored on the computer-readable storage medium. The computer terminal may include a memory, a processor, and a computer program stored on the memory and executable on the processor. When the computer program is executed by the processor, the steps of the real-time database point-in-time video playback method of the present invention are implemented. The computer terminal can be a computer, a smart phone, etc. It can also be designed as a program running in an embedded manner and installed on a computer terminal, such as installed on a single-chip microcomputer.

[0203] When the real-time database point-in-time video playback method of the present invention is designed as a program to implement the function, it can also be designed as a program that can run independently on a computer-readable storage medium. The computer-readable storage medium can be a USB flash drive, designed as a USB key, and the entire method can be designed to be started by an external trigger through the USB flash drive.

[0204] The above are only the preferred embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent replacements, and improvements made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for real-time database point-in-time video playback, characterized in that, the software environment it applies to is: install any version of the historical database software 2017; the hardware environment it applies to is: at least one NVR of any model of Hikvision; the method for real-time database point-in-time video playback includes the following steps: For the case where different NVRs need to be adapted to the encapsulated situation, embed CHCNetSDK.CS of the NVR into the C# project for calling; For the case where there are multiple NVRs at the customer site, store the information of multiple NVRs locally in C#, then confirm the information corresponding to the username, password, IP, and Port. At the same time, ensure with the owner that one IP number corresponds to one NVR, so that the NVR boxes do not overlap and do not cause duplicate IP addresses for calling, and prevent incorrect reference to channels.

2. The method for real-time database point-in-time video playback according to claim 1, characterized in that, the method for real-time database point-in-time video playback further includes the following steps: For the design of obtaining channels in the NVR, use System.Runtime.InteropServices.Marshal in CHCNetSDK.CS to call transcoding to obtain the correct channel number and channel alias.

3. The method for real-time database point-in-time video playback according to claim 1, characterized in that, the method for real-time database point-in-time video playback further includes the following steps: For the case where after configuring the information in the C# project, it is necessary to confirm which window corresponds to which channel during video window playback, create an NVR group, determine the correct NVR and channel through the button position, and execute the playback script.

4. The method for real-time database point-in-time video playback according to claim 1, characterized in that, the method for real-time database point-in-time video playback further includes the following steps: For the use of the Historian Client of the historical database software in C#, extract the relevant DLL files in the AVEVA WSP installation software and add them to the C# project, and reference the functions of aaHistClientTagPicker.dll and aaHistClientTrendControl.dll.

5. The method for real-time database point-in-time video playback according to claim 1, characterized in that, the method for real-time database point-in-time video playback further includes the following steps: For the case of viewing the trend curve and the video playback window, use a ContextMenuStrip control to distinguish between the upper and lower layers.

6. The method for real-time database point-in-time video playback according to claim 1, characterized in that, the method for real-time database point-in-time video playback further includes the following steps: For the situation where the same start time node and end time node are displayed in the historical database software and the Hikvision display window, dateTimeStart in System.Windows.Forms.DateTime is used as the start time node, and dateTimeEnd in System.Windows.Forms.DateTime is used as the end time node.

7. An operation method of the real-time database time-point video playback method according to any one of claims 1 to 6, characterized in that, the operation method of the real-time database time-point video playback method includes the following steps: Step 1, configure the corresponding information of the NVR for the historical video to be viewed; Step 2, click to test the communication with the NVR and restart the program; Step 3, open the pre-saved Historian trend file *.aaTrend; Step 4, the interface determines whether the NVR and the trend file are successful; Step 5, if the run button has no response, the login fails; Step 6, it is necessary to determine which item in the configuration has a problem and reconfigure; Step 7, if the historical video picture is generated, it means that the operation is successful and the user can continue to operate.

8. The operation method of the real-time database time-point video playback method according to claim 7, characterized in that, the NVR corresponding information includes the IP address, port number, username and password of the NVR.

9. A computer-readable storage medium, on which a computer program is stored, characterized in that, when the program is executed by a processor, the steps of the real-time database time-point video playback method according to any one of claims 1 to 6 are implemented.

Images