A method, device and equipment for controlling hardware equipment

By receiving database control instructions and using CLR assembly to communicate with servo programs, obtaining and sending hardware device control instructions, the problems of inflexible hardware device control and difficult operation and maintenance in the prior art are solved, and efficient and flexible hardware device control is achieved.

CN119011636BActive Publication Date: 2025-05-09BEIJING XINGHAN BONA PHARMACEUTICAL TECHNOLOGY CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411024356.9
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-07-29
Publication Date
2025-05-09
Estimated Expiration
2044-07-29

AI Technical Summary

Technical Problem

Existing hardware control solutions are difficult to directly and efficiently control hardware equipment, and are difficult to operate and maintain, lack flexibility, and cannot meet the needs of independent personalization.

Method used

By receiving the database control instructions sent by the warehouse management system, a communication request is initiated to the servo program using the pre-stored CLR assembly, the routing information and service information in the target data are obtained, and the control instructions are sent to the controller of the hardware device through the servo program.

Benefits of technology

It realizes direct and efficient control of hardware equipment, reduces operation and maintenance difficulties, improves the flexibility of hardware control, and can independently and flexibly control modern facilities in warehousing.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119011636B_ABST
    Figure CN119011636B_ABST
Patent Text Reader

Abstract

The present invention provides a method, device and equipment for controlling hardware equipment, the method comprising: receiving a database control instruction sent by a warehouse management system, the database control instruction including an identifier of target data; initiating a communication request to a servo program according to the identifier of the target data in the database control instruction through a pre-stored common language runtime CLR assembly; receiving a response from the servo program; acquiring the target data in a database according to the identifier of the target data in the response from the servo program; the target data including routing information and business information of the current communication; sending an instruction to a controller of a target hardware equipment through the servo program according to the business information of the target data, and controlling the target electronic device through the controller. The scheme of the present invention can control hardware equipment more directly and efficiently, reduce the difficulty of operation and maintenance, and improve the flexibility of hardware control.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of computer information technology, and in particular to a method, device and equipment for controlling hardware equipment. Background Art

[0002] To achieve the standard of "modern pharmaceutical logistics", the application and control of hardware equipment represented by electronic tags plays a vital role. It can improve the efficiency of warehousing operations and reduce the labor costs of enterprises.

[0003] The existing hardware control solution is controlled by programs developed by software developers. If the user's technical level is not high, they need to contact the software developer to solve any problems. The later operation and maintenance is difficult, and most of the independent individual needs cannot be changed, which lacks flexibility. Summary of the invention

[0004] The technical problem to be solved by the present invention is to provide a hardware device control method, device and equipment, which can control the hardware equipment more directly and efficiently, reduce the difficulty of operation and maintenance, and improve the flexibility of hardware control.

[0005] In order to solve the above technical problems, the technical solution of the present invention is as follows:

[0006] A hardware device control method, comprising:

[0007] Receiving a database control instruction sent by a warehouse management system, wherein the database control instruction includes an identifier of target data;

[0008] Initiate a communication request to the server program according to the identifier of the target data in the database control instruction through a pre-stored common language runtime CLR assembly;

[0009] receiving a response from the servo program;

[0010] According to the identifier of the target data in the response of the servo program, the target data is obtained in the database; the target data includes the routing information and service information of the current communication;

[0011] According to the business information of the target data, an instruction is sent to the controller of the target hardware device through the servo program, and the target electronic device is controlled through the controller.

[0012] Optionally, the target data is pre-stored in the database before the warehouse management system sends the database control instruction; the business information of the target data includes an identifier of the target data.

[0013] Optionally, acquiring the target data in a database according to the identifier of the target data in the response of the servo program includes:

[0014] According to the identifier of the target data, a temporary parameter table corresponding to the identifier of the target data is obtained in a database;

[0015] The target data is obtained in the temporary parameter table; the temporary parameter table stores the target data in the form of message unique value, parameter name and parameter value.

[0016] Optionally, sending instructions to a controller of a target hardware device through a servo program according to the business information of the target data includes:

[0017] Determine a target hardware device in at least one hardware device according to the parameter values ​​of the gateway number, the bus number and the device number in the service information; and

[0018] Determining, according to the parameter value of the operation type in the service information, an instruction to be executed on the target hardware device;

[0019] The servo program sends instructions to the controller of the target hardware device.

[0020] Optionally, determining an instruction to be executed on the target hardware device according to a parameter value of the operation type in the service information includes:

[0021] According to the parameter value of the operation type in the business information, it is determined whether to execute a light-on label instruction or a light-off instruction on the target hardware device.

[0022] Optionally, when a light-up label instruction is to be executed on the target hardware device, the target data also includes display content information, and the servo program sends a light-up label instruction to a controller of the target hardware device according to the business information and displays the display content information on the target hardware device.

[0023] Optionally, the hardware device control method further includes:

[0024] When the target hardware device receives the input instruction and calls back the servo program according to the input instruction, it receives the data storage instruction sent by the servo program and calls the specified storage process to store the data into the target table of the database.

[0025] The present invention also provides a hardware device control device, comprising:

[0026] An acquisition module, used for receiving a database control instruction sent by a warehouse management system, wherein the database control instruction includes an identifier of the target data;

[0027] The processing module is used to initiate a communication request to a servo program through a pre-stored common language runtime CLR assembly according to the identifier of the target data in the database control instruction; receive a response from the servo program, and obtain the target data in a database according to the identifier of the target data in the response of the servo program; the target data includes routing information and business information of the current communication; according to the business information of the target data, send instructions to a controller of a target hardware device through the servo program, and control the target electronic device through the controller.

[0028] The present invention also provides a computing device, comprising: a processor and a memory storing a computer program, wherein when the computer program is run by the processor, the method as described above is executed.

[0029] The present invention also provides a computer-readable storage medium storing instructions, which, when executed on a computer, enable the computer to execute the above method.

[0030] The above solution of the present invention includes at least the following beneficial effects:

[0031] The above scheme of the present invention is as follows: receiving a database control instruction sent by a warehouse management system, wherein the database control instruction includes the identifier of the target data; initiating a communication request to a servo program according to the identifier of the target data in the database control instruction through a pre-stored common language runtime CLR assembly; receiving a response from the servo program; acquiring the target data in a database according to the identifier of the target data in the response from the servo program; the target data includes the routing information and business information of the current communication; according to the business information of the target data, sending an instruction to the controller of the target hardware device through the servo program, and controlling the target electronic device through the controller. The hardware device can be controlled more directly and efficiently, the difficulty of operation and maintenance can be reduced, and the flexibility of hardware control can be improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] Figure 1 is a flowchart of a hardware device control method according to an embodiment of the present invention;

[0033] Figure 2 is a schematic diagram of a hardware device control system according to an embodiment of the present invention;

[0034] Figure 3 is a schematic diagram of the installation position of the electronic tag according to an embodiment of the present invention;

[0035] Figure 4 It is a structural diagram of a hardware device control apparatus according to an embodiment of the present invention. DETAILED DESCRIPTION

[0036] The exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although the exemplary embodiments of the present invention are shown in the accompanying drawings, it should be understood that the present invention can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided in order to enable a more thorough understanding of the present invention and to enable the scope of the present invention to be fully communicated to those skilled in the art.

[0037] like Figure 1 As shown, an embodiment of the present invention provides a hardware device control method, comprising:

[0038] Step 11, receiving a database control instruction sent by the warehouse management system, wherein the database control instruction includes an identifier of the target data;

[0039] Here, the database control instruction is an SQL command, for example, the database control instruction may be SELECTDBO.XGate_SendRdpData(@Gzid), wherein @Gzid is the identifier of the target data. The identifier of the target data is stored in the database by the warehouse management system before step 11.

[0040] Step 12, initiating a communication request to the server program according to the identifier of the target data in the database control instruction through the pre-stored common language runtime CLR assembly;

[0041] Here, the CLR (Common Language Runtime) assembly is pre-written by the developer and injected into the database engine. The CLR (Common Language Runtime) assembly is used to control the servo program. When the database engine receives the database control instruction sent by the warehouse management system, the database engine first parses the control instruction to obtain the identifier of the target data; then calls the CLR assembly to construct a data format suitable for HTTP or RPC protocol transmission according to the identifier of the target data. The converted command is communicated with the servo program through HTTP or RPC protocol.

[0042] Step 13, receiving a response from the servo program;

[0043] Here, the server receives the command sent by the database engine and parses the command to obtain the identifier @Gzid of the target data.

[0044] Step 14, acquiring target data from a database according to the identifier of the target data in the response of the servo program; the target data includes routing information and service information of the current communication;

[0045] Here, the target data is found in the database according to the identifier of the target data, the target data is stored in the temporary parameter table of the database, and the target data is stored in the database before the warehouse management system sends the database control instruction to the database. The servo program can find the corresponding temporary parameter table in the database according to the identifier of the target data, thereby obtaining the target data therefrom.

[0046] Step 15: Send instructions to the controller of the target hardware device through the servo program according to the business information of the target data, and control the target electronic device through the controller.

[0047] Here, after the servo program obtains the target data, it sends a control instruction to the controller, and the controller controls the target electronic device according to the received control instruction.

[0048] In this embodiment, the hardware device control system corresponding to the above hardware device control method is as follows: Figure 2 As shown, it includes a WMS (warehouse management system) system, a database, a servo program, a controller and hardware devices, and the hardware devices can be electronic tags, AGVs, stackers, gratings, etc. Through the hardware device control method of the present invention, all these hardware devices can be controlled. The electronic tags are installed on the warehouse shelves, and the installation method is as follows Figure 3 As shown, preferably, one electronic tag corresponds to one stored item.

[0049] In an optional embodiment of the present invention, the target data is pre-stored in a temporary parameter table of a database before the warehouse management system sends the database control instruction; the business information of the target data includes an identifier of the target data.

[0050] In this embodiment, taking the warehouse management system needing to send SQL instructions to the database to light up the electronic tag as an example, before the database receives the database control instruction sent by the warehouse management system in step 11, that is, before the warehouse management system sends the database control instruction to the database, the warehouse management system will connect to the database to store the information to be sent (including the identification of the target data) in the parameter temporary table in the database. The parameter temporary table mainly stores three types of information, including routing information, business information, display content information and display mode. The routing information includes: sending service end and receiving service end; the business information includes: gateway serial number, bus serial number, device serial number, operation type, message id (that is, the identification of the target data); the display content information is the content displayed on the electronic tag screen after the electronic tag is lit, including product name, product description, packaging unit, display direction, storage location, quantity, etc. When the electronic tag is to be lit, the WMS system needs to store the display content information in the database; when the electronic tag is to be turned off, the WMS system only stores the routing information and business information in the parameter temporary table, and no longer needs to store the display content information. The display mode includes light source color and background color. The temporary parameter table is shown in Table 1 below:

[0051] Table 1, temporary table of parameters

[0052]

[0053]

[0054] The WMS system randomly generates the identifier of the target data and stores the identifier of the target data together with the data to be stored in the temporary parameter table of the database. The identifier of the target data is used to identify the target data during the communication process between the servo program and the database.

[0055] In an optional embodiment of the present invention, step 14 may include:

[0056] Step 141, according to the identifier of the target data, obtaining a temporary parameter table corresponding to the identifier of the target data in a database;

[0057] Step 142, obtaining the target data in the temporary parameter table; the temporary parameter table stores the target data in the form of message unique value, parameter name and parameter value.

[0058] In this embodiment, after receiving the request, the servo program searches the database for the corresponding temporary parameter table according to the identifier Gzid of the target data in the command, and obtains the target data from the temporary parameter table.

[0059] In an optional embodiment of the present invention, step 15 may include:

[0060] Step 151, determining a target hardware device in at least one hardware device according to the parameter values ​​of the gateway number, bus number and device number in the service information; and,

[0061] Step 152, determining the instruction to be executed on the target hardware device according to the parameter value of the operation type in the service information;

[0062] Step 153: Send instructions to the controller of the target hardware device through the servo program.

[0063] In this embodiment, the servo program queries the gateway number, bus number and device number in the temporary parameter table to determine the target hardware device to be controlled. According to the parameter value of the operation type, the instruction to be executed on the target hardware device is determined. Taking the electronic tag as an example, when the parameter value of the operation type is Cmd_Display, it means lighting up the electronic tag; when the parameter value of the operation type is Cmd_Clear, it means turning off the light. After the servo program obtains the target hardware device to be controlled and the instruction to be executed on the target hardware device by querying the temporary parameter table, the servo program sends instructions to the controller to control the hardware device.

[0064] In an optional embodiment of the present invention, step 152 may include:

[0065] Step 1521: Determine whether to execute a light-on tag instruction or a light-off tag instruction on the target hardware device according to the parameter value of the operation type in the business information.

[0066] In this embodiment, an electronic tag is taken as an example, and the electronic tag is controlled to light up or go out by the controller. Of course, it is understandable that when the target hardware device is other, the operation type will correspond to other instructions.

[0067] In an optional embodiment of the present invention, when a light label instruction is to be executed on the target hardware device, the target data also includes display content information, and the servo program sends a light label instruction to the controller of the target hardware device according to the business information and displays the display content information on the target hardware device.

[0068] In the above embodiment of the present invention, in order to realize the interaction between the servo program and the target hardware device, the .NET dynamic library (Ptl.Device.dll) and Java package (ptl.device.jar) of the underlying communication that directly interacts with the device provided by the manufacturer of the target hardware device are required. The servo program calls the device control method through the communication library to handle the device callback event or error.

[0069] The communication library uses the XGate class as the main entry point to manage all devices directly or indirectly connected to it. The servo program uses the methods provided by the communication library in the following steps:

[0070] 1. Initialize the controller X-Gate;

[0071] 2. Add the target hardware device to different buses of the controller X-Gate;

[0072] 3. Start the communication of the controller working bus;

[0073] 4. Subscribe to the interaction events or failures between the communication bus and the device;

[0074] 5. Light up or turn off the electronic tag node device to implement the business logic of the on-site solution;

[0075] 6. Handle the callback events of the equipment and implement the business logic of the on-site solution.

[0076] The specific process of the above hardware device control method is described below with a specific embodiment:

[0077] Example 1: Light up the electronic tag

[0078] First, WMS will connect to the database to store the information to be sent into the parameter temporary table (HzTemp), and execute the assembly definition SQL command: SELECT DBO.XGate_SendRdpData(@Gzid);

[0079] Then the database sends a request to the servo program through the RPC protocol. After receiving the request, the servo program queries the corresponding parameter name and content value in the database through the unique ID (Gzid) in the command. According to the values ​​of the gateway, bus, and device serial number in the parameters, the specific device is found, and the corresponding interface provided by the device manufacturer is called to send the message to the controller. Finally, the message reaches the electronic tag, which is successfully lit and displays the display content in the parameter.

[0080] In an optional embodiment of the present invention, the hardware device control method further includes:

[0081] When the target hardware device receives the input instruction and calls back the servo program according to the input instruction, it receives the data storage instruction sent by the servo program and calls the specified storage process to store the data into the target table of the database.

[0082] In this embodiment, the servo program can also receive callbacks from the controller and store data in the database. When the staff operates the + and - buttons of the electronic tag to modify the value of the displayed content quantity, and then presses the OK button of the electronic tag, the device communication library will call back the servo program through the communication thread. After receiving the message, the servo program writes the information to the database WMS_DZBQ_RETURN_T table and calls the specified stored procedure WMS_DZBQ_return. WMS can customize the message processing logic in this stored procedure.

[0083] The following is a specific example of the specific application process of the above embodiment in the scenario of delivery and picking:

[0084] Example 2: Picking and dispatching

[0085] WMS receives the order to be shipped, calculates the location of the items to be picked, and occupies the inventory. The employee operates WMS to select the picking order and issue the picking instruction, and then begins the interaction with the electronic tag. The specific process is as follows:

[0086] 1.WMS connects to the database to organize the parameter information required for lighting (gateway serial number, bus serial number, device serial number, operation type, message ID, product name, product description, packaging unit, display direction, storage location, quantity, light source color, background color), and stores the information to be sent in the parameter temporary table (HzTemp) to generate a unique ID (gzid) for this communication;

[0087] 2. Execute the assembly definition SQL command: SELECT DBO.XGate_SendRdpData(@Gzid) to initiate communication with the servo program;

[0088] 3. After receiving the request, the server program queries the database for the corresponding parameter name and content value through the unique ID (Gzid) in the command;

[0089] 4. The servo program finds the specific device based on the values ​​of the gateway, bus, and device serial number in the parameters, and finally displays the parameters on the electronic label through the communication library device control method provided by the device manufacturer;

[0090] 5. Finally, the electronic tag lights up and displays the content, and the channel indicator light tower corresponding to the electronic tag also lights up;

[0091] 6. The employee walks to the corresponding lit electronic tag, picks the corresponding goods according to the displayed content, and presses the OK button of the electronic tag after processing is completed. The device communication library will call back the servo program through the communication thread;

[0092] 7. After receiving the message, the server program writes the information to the WMS_DZBQ_RETURN_T table in the database and calls the specified stored procedure WMS_DZBQ_return. In this stored procedure, WMS marks the order as having been picked based on the unique ID of the communication and enters the subsequent outbound review step.

[0093] The code for lighting up the electronic tag in the above embodiment of the present invention is as follows:

[0094]

[0095]

[0096] The code in the process of extinguishing the electronic tag in the above embodiment of the present invention is as follows:

[0097]

[0098]

[0099] The above method of the present invention separates the control logic of the hardware from the control technology, and provides a set of fast hardware equipment control methods, so that users can independently and flexibly control the modern facilities in their own warehouses, giving users room to play freely, reducing the difficulty of learning and training for user operation and maintenance personnel, and reducing the labor costs of enterprises. The control logic of the electronic tags is initiated by the database engine in the form of SQL commands. Users do not need to learn more programming knowledge, but only need to understand simple SQL syntax, which greatly reduces the control difficulty of electronic tags. The control logic of the hardware is edited by the user independently and is no longer restricted by software developers. In addition, the hardware equipment control is flexible. In different business scenarios, different business needs can be met by hardware without the need for re-development.

[0100] like Figure 4 As shown, an embodiment of the present invention further provides a hardware device control device 40, comprising:

[0101] The acquisition module 41 is used to receive a database control instruction sent by the warehouse management system, wherein the database control instruction includes an identifier of the target data;

[0102] The processing module 42 is used to initiate a communication request to the servo program through a pre-stored common language runtime CLR assembly according to the identifier of the target data in the database control instruction; receive a response from the servo program, and obtain the target data in the database according to the identifier of the target data in the response of the servo program; the target data includes routing information and business information of the current communication; according to the business information of the target data, send instructions to the controller of the target hardware device through the servo program, and control the target electronic device through the controller.

[0103] Optionally, the target data is pre-stored in a temporary parameter table of a database before the warehouse management system sends the database control instruction; the business information of the target data includes an identifier of the target data.

[0104] Optionally, acquiring the target data in a database according to the identifier of the target data in the response of the servo program includes:

[0105] According to the identifier of the target data, a temporary parameter table corresponding to the identifier of the target data is obtained in a database;

[0106] The target data is obtained in the temporary parameter table; the temporary parameter table stores the target data in the form of message unique value, parameter name and parameter value.

[0107] Optionally, sending instructions to a controller of a target hardware device through a servo program according to the business information of the target data includes:

[0108] Determine a target hardware device in at least one hardware device according to the parameter values ​​of the gateway number, the bus number and the device number in the service information; and

[0109] Determining, according to the parameter value of the operation type in the service information, an instruction to be executed on the target hardware device;

[0110] The servo program sends instructions to the controller of the target hardware device.

[0111] Optionally, determining an instruction to be executed on the target hardware device according to a parameter value of the operation type in the service information includes:

[0112] According to the parameter value of the operation type in the business information, it is determined whether to execute a light-on label instruction or a light-off instruction on the target hardware device.

[0113] Optionally, when a light-up label instruction is to be executed on the target hardware device, the target data also includes display content information, and the servo program sends a light-up label instruction to a controller of the target hardware device according to the business information and displays the display content information on the target hardware device.

[0114] Optionally, the processing module 42 may also be used for:

[0115] When the target hardware device receives the input instruction and calls back the servo program according to the input instruction, it receives the data storage instruction sent by the servo program and calls the specified storage process to store the data into the target table of the database.

[0116] It should be noted that the device is a device corresponding to the above method, and all implementation methods in the above method embodiments are applicable to the embodiments of the device and can achieve the same technical effects.

[0117] The embodiment of the present invention further provides a computing device, comprising: a processor, a memory storing a computer program, wherein when the computer program is executed by the processor, the method described above is executed. All implementations in the above method embodiment are applicable to this embodiment and can achieve the same technical effect.

[0118] The embodiment of the present invention further provides a computer-readable storage medium storing instructions, which, when executed on a computer, enable the computer to execute the above method. All implementations in the above method embodiment are applicable to this embodiment and can achieve the same technical effect.

[0119] Those skilled in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0120] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0121] In the embodiments provided by the present invention, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0122] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0123] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0124] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program codes, such as USB flash drives, mobile hard disks, ROM, RAM, magnetic disks, or optical disks.

[0125] In addition, it should be noted that in the apparatus and method of the present invention, it is obvious that each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present invention. Moreover, the steps of performing the above-mentioned series of processing can naturally be performed in chronological order according to the order of description, but it is not necessary to perform them in chronological order, and some steps can be performed in parallel or independently of each other. For those of ordinary skill in the art, it is understood that all or any steps or components of the method and apparatus of the present invention can be implemented in any computing device (including processors, storage media, etc.) or a network of computing devices in hardware, firmware, software or a combination thereof, which can be achieved by those of ordinary skill in the art using their basic programming skills after reading the description of the present invention.

[0126] Therefore, the purpose of the present invention can also be achieved by running a program or a group of programs on any computing device. The computing device can be a well-known general device. Therefore, the purpose of the present invention can also be achieved by simply providing a program product containing a program code that implements the method or device. That is to say, such a program product also constitutes the present invention, and the storage medium storing such a program product also constitutes the present invention. Obviously, the storage medium can be any well-known storage medium or any storage medium developed in the future. It should also be pointed out that in the device and method of the present invention, it is obvious that each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present invention. In addition, the steps of performing the above-mentioned series of processing can naturally be performed in chronological order according to the order of description, but it is not necessary to perform them in chronological order. Some steps can be performed in parallel or independently of each other.

[0127] The above is a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A method for controlling a hardware device, characterized in that: include: Receiving a database control instruction sent by a warehouse management system, wherein the database control instruction includes an identifier of target data; The database engine calls a pre-stored common language runtime CLR assembly and constructs a data format suitable for transmission using a hypertext transfer protocol HTTP or a remote procedure call RPC protocol according to the identifier of the target data; The converted command initiates a communication request to the server program through the Hypertext Transfer Protocol HTTP or the Remote Procedure Call RPC protocol; the database engine controls the server program through the Common Language Runtime CLR assembly; receiving a response from the servo program; According to the identifier of the target data in the response of the servo program, the target data is obtained in the database; the target data includes the routing information and business information of the current communication; the target data is pre-stored in the parameter temporary table of the database before the warehouse management system sends the database control instruction; the business information of the target data includes the identifier of the target data; The temporary parameter table stores routing information, service information, display content information and display mode; The routing information includes: sending service end and receiving service end; the service information includes: gateway serial number, bus serial number, device serial number, operation type, message ID, wherein the message ID is the ID of the target data; the display content information is the content displayed on the screen of the electronic tag when the electronic tag is lit, including the product name, product description, packaging unit, display direction, storage location, and quantity; According to the business information of the target data, a command is sent to a controller of the target hardware device through a servo program, and the target hardware device is controlled through the controller; The method includes sending instructions to a controller of a target hardware device through a servo program according to the business information of the target data, including: Determine a target hardware device in at least one hardware device according to the parameter values ​​of the gateway number, the bus number and the device number in the service information; and Determining, according to the parameter value of the operation type in the service information, an instruction to be executed on the target hardware device; Sending instructions to the controller of the target hardware device through a servo program; The hardware device control method further includes: when the target hardware device receives the input instruction and calls back the servo program according to the input instruction, the servo program stores the data in the target table of the database.

2. The hardware device control method according to claim 1, characterized in that: Acquiring the target data in a database according to the identifier of the target data in the response of the servo program includes: According to the identifier of the target data, a temporary parameter table corresponding to the identifier of the target data is obtained in a database; The target data is obtained in the temporary parameter table; the temporary parameter table stores the target data in the form of message unique value, parameter name and parameter value.

3. The hardware device control method according to claim 1, characterized in that: Determining, according to the parameter value of the operation type in the service information, an instruction to be executed on the target hardware device, including: According to the parameter value of the operation type in the business information, it is determined whether to execute a light-on label instruction or a light-off instruction on the target hardware device.

4. The hardware device control method according to claim 3, characterized in that: When the light-up label instruction is to be executed on the target hardware device, the target data also includes display content information, and the servo program sends the light-up label instruction to the controller of the target hardware device according to the service information and displays the display content information on the target hardware device.

5. A hardware device control device, characterized in that: include: An acquisition module, used for receiving a database control instruction sent by a warehouse management system, wherein the database control instruction includes an identifier of the target data; A processing module, used for constructing a data format suitable for transmission by a hypertext transfer protocol HTTP or a remote procedure call RPC protocol according to the identifier of the target data through a pre-stored common language runtime CLR assembly; The converted command initiates a communication request to the server program via the Hypertext Transfer Protocol HTTP or the Remote Procedure Call RPC protocol; receiving a response from the servo program; According to the identifier of the target data in the response of the servo program, the target data is obtained in the database; the target data includes the routing information and business information of the current communication; the target data is pre-stored in the parameter temporary table of the database before the warehouse management system sends the database control instruction; the business information of the target data includes the identifier of the target data; The temporary parameter table stores routing information, service information, display content information and display mode; The routing information includes: sending service end and receiving service end; the service information includes: gateway serial number, bus serial number, device serial number, operation type, message ID, wherein the message ID is the ID of the target data; the display content information is the content displayed on the screen of the electronic tag when the electronic tag is lit, including the product name, product description, packaging unit, display direction, storage location, and quantity; According to the business information of the target data, a command is sent to a controller of the target hardware device through a servo program, and the target hardware device is controlled through the controller; The method includes sending instructions to a controller of a target hardware device through a servo program according to the business information of the target data, including: Determine a target hardware device in at least one hardware device according to the parameter values ​​of the gateway number, the bus number and the device number in the service information; and Determining, according to the parameter value of the operation type in the service information, an instruction to be executed on the target hardware device; Sending instructions to the controller of the target hardware device through a servo program; The processing module is also used for: when the target hardware device receives an input instruction and calls back the servo program according to the input instruction, receiving a data storage instruction sent by the servo program, and calling a specified storage process to store the data into a target table of the database.

6. A computing device, characterized in that include: A processor and a memory storing a computer program, wherein when the computer program is executed by the processor, the method according to any one of claims 1 to 4 is performed.

7. A computer-readable storage medium, characterized in that: Instructions are stored, and when the instructions are executed on a computer, the computer is caused to execute the method according to any one of claims 1 to 4.

Citation Information

Patent Citations

  • Acousto-optic technology-based commodity management method

    CN108694536A

  • Warehousing and sorting system and method based on Internet of Things monitoring

    CN110135786A