Summary of the invention
The technical problem to be solved in the present invention just provides the method for the automatic typing of new clothes ammeter relevant information in a kind of labour intensity is low, efficient is high, be difficult for makeing mistakes the applying bar code engineering that realizes that Every household has an ammeter.
For addressing the above problem, the technical solution used in the present invention is:
This method comprises the following steps:
The first step is extracted the new clothes family and is generated interim user data storehouse
From electricity consumption MIS database is applied to install, extract the user data information that those newly applied to install and prepared to send electricity by the ODBC standard interface, generate corresponding interim user data storehouse,
Second goes on foot, and extracts the temporary table database of new outbound ammeter
From the continuous data table of electricity consumption MIS database, extract the essential information of new clothes ammeter by the ODBC standard interface, and generate corresponding temporary table database,
In the 3rd step, generate and the printing bar code:
Utilize interim user data storehouse to generate bar code, and export bar-code label with printer prints, the content of each bar-code label comprises bar code and literal two parts, print bar code above, following printing character, unit in charge of construction pastes this bar-code label on the ammeter position at corresponding family in construction
In the 4th step, generate the table information database:
By computer by serial data in the temporary table database are downloaded in the barcode scanner, and generate the table information database that can inquire about at barcode scanner,
In the 5th step, generate the family information database:
By computer by serial data in the interim user data storehouse are downloaded in the barcode scanner, and generate the family information database that can inquire about at barcode scanner,
In the 6th step, gather family table correspondence database:
On-site acceptance staff's barcode scanner in the table bar code be attached on the family bar-code label on the electric energy meter run-down respectively, generates family table correspondence database,
In the 7th step, extract family table correspondence database: system can be sent to the family table correspondence database that the barcode scanner collection generates in the network data base of electricity consumption MIS by the serial port of computing machine.
Its additional technical feature is:
User data information in the described first step comprises family number, name in an account book, address, table sequence number and electricity consumption classification information, and the essential information of new clothes ammeter comprises table number, the table end and assets number in described second step;
Bar code is made up of family number and table sequence number in described the 3rd step, and described literal is made up of family number, name in an account book, table sequence number, classification, and described printer is a laser printer;
Described barcode scanner has the function at the bottom of manual typing family number, table number and the rewriting table.
The method of the automatic typing of new clothes ammeter relevant information compared with prior art has the following advantages in the engineering that applying bar code provided by the present invention realizes that Every household has an ammeter: one, because this method comprises the following steps:
The first step is extracted the new clothes family and is generated interim user data storehouse
From electricity consumption MIS database is applied to install, extract the user data information that those newly applied to install and prepared to send electricity by the ODBC standard interface, generate corresponding interim user data storehouse,
Second goes on foot, and extracts the temporary table database of new outbound ammeter
From the continuous data table of electricity consumption MIS database, extract the essential information of new clothes ammeter by the ODBC standard interface, and generate corresponding temporary table database,
In the 3rd step, generate and the printing bar code:
Utilize interim user data storehouse to generate bar code, and export bar-code label with printer prints, the content of each bar-code label comprises bar code and literal two parts, print bar code above, following printing character, unit in charge of construction pastes this bar-code label on the ammeter position at corresponding family in construction
In the 4th step, generate the table information database:
By computer by serial data in the temporary table database are downloaded in the barcode scanner, and generate the table information database that can inquire about at barcode scanner,
In the 5th step, generate the family information database:
By computer by serial data in the interim user data storehouse are downloaded in the barcode scanner, and generate the family information database that can inquire about at barcode scanner,
In the 6th step, gather family table correspondence database:
On-site acceptance staff's barcode scanner in the table bar code be attached on the family bar-code label on the electric energy meter run-down respectively, generates family table correspondence database,
In the 7th step, extract family table correspondence database: system can be sent to the family table correspondence database that the barcode scanner collection generates in the network data base of electricity consumption MIS by the serial port of computing machine.
By from electricity consumption MIS database is applied to install, extracting those user data informations of newly applying to install and prepare to send electricity and the essential information of new clothes ammeter, build up interim user data storehouse and interim user data storehouse, generate the family bar coded sticker of table family correspondence then according to interim user data storehouse, unit in charge of construction pastes this family bar-code label on the ammeter position at corresponding family in construction, by computer by serial data in temporary table database and the interim user data storehouse are downloaded in the barcode scanner then, and generate table information database and the family information database that to inquire about at barcode scanner, this moment is by on-site acceptance staff's barcode scanner, in the table bar code be attached on the family bar-code label on the electric energy meter run-down respectively, generate family table correspondence database, the family table correspondence database that generates the most at last is sent in the network data base of electricity consumption MIS, like this, the automatic typing of new clothes ammeter relevant information in the engineering of just having finished that Every household has an ammeter, adopt this method image data, convenient and swift, avoided increasing labour intensity because of manual input, reduced labour cost, and computer operation, error rate is low;
They are two years old, because user data information in the described first step comprises family number, name in an account book, address, table sequence number and electricity consumption classification information, the essential information of new clothes ammeter comprises table number, the table end and assets number in described second step, make that the essential information of needed user data information and new clothes ammeter is more complete, and more convenient to operate;
They are three years old, because bar code is made up of family number and table sequence number in described the 3rd step, described literal is made up of family number, name in an account book, table sequence number, classification, described printer is a laser printer, user for identical family number, name in an account book, the ammeter of two or more ammeters and two or more different purposes is installed, can be by table sequence number and class discrimination;
They are four years old, because described barcode scanner has the function at the bottom of manual typing family number, table number and the rewriting table, when the table bar code or be attached to family bar-code label on the electric energy meter when occurring damaging, can or rewrite the table end by manual mode typing family number, table number, then according to manual typing family number, table number or rewrite the table end, form family table correspondence database, range of application is wider.
Embodiment
Be described in further details below in conjunction with the structure and the use principle of accompanying drawing the method for the automatic typing of new clothes ammeter relevant information in the applying bar code of the present invention engineering that realizes that Every household has an ammeter.
As shown in Figure 1, the hardware configuration synoptic diagram of the method for the automatic typing of new clothes ammeter relevant information in the engineering that applying bar code of the present invention realizes that Every household has an ammeter, comprise server 1, server 1 is provided with at least one terminal 2, and printer 3 and some barcode scanners 4.
As shown in Figure 2, be network terminal software design schematic diagram, this method has utilized the electricity consumption mis system already to expand the data of applying to install in the database, connect (ODBC) 5 by the open type data storehouse and read related data, and interim user data storehouse 6 in the middle of generating, equally, connect (ODBC) 5ODBC by the open type data storehouse and read the continuous data storehouse, and temporary table database 6 in the middle of generating.In PB7 software programming application software 7, because PB7 software does not contain the communication control, system connects by object and embeds (OLE) 9 increase serial communication controls 8, and to realize the communication function of native system and barcode scanner, communication speed is 115200pbs.Utilize in 39 bar code character libraries and the user data storehouse family number+table sequence number to generate bar-code label and printout, unit in charge of construction pastes this label on the ammeter position at corresponding family in construction.
As shown in Figure 3, design concept calcspar for barcode scanner software, this method barcode scanner 4 parts are selected for use machine intimate to carry the BC2.0 programming tool and are write application software and display interface, by bar code input editing step 15, gather the ammeter bar code, bar code scan interruption subroutine 10 and serial communication interruption subroutine 11 have been adopted in the software design, key word index is set up in the customer data base tabulation 12 and the ammeter data storehouse tabulation 14 of downloading respectively, so that corresponding associate field is read in inquiry, this field is family bar code and table bar code, after two bar codes are scanned examination respectively, generate the family, table mapping table 13.Data download and extraction data communication speed are 115200bps, collector is when image data, promptly can import by scanning barcode, also can import with the miniature keyboard of collector, this dual mode can carry out alternately, also can revise the table truth of a matter certificate of having imported collector inside by miniature keyboard simultaneously.
The method of the automatic typing of new clothes ammeter relevant information comprises the following steps: in the engineering that applying bar code of the present invention realizes that Every household has an ammeter
The first step is extracted the new clothes family and is generated interim user data storehouse
From electricity consumption MIS database is applied to install, extract the user data information that those newly applied to install and prepared to send electricity by the ODBC standard interface, generate corresponding interim user data storehouse,
Second goes on foot, and extracts the temporary table database of new outbound ammeter
From the continuous data table of electricity consumption MIS database, extract the essential information of new clothes ammeter by the ODBC standard interface, and generate corresponding temporary table database,
In the 3rd step, generate and the printing bar code:
Utilize interim user data storehouse to generate bar code, and export bar-code label with printer prints, the content of each bar-code label comprises bar code and literal two parts, print bar code above, following printing character, unit in charge of construction pastes this bar-code label on the ammeter position at corresponding family in construction
In the 4th step, generate the table information database:
By computer by serial data in the temporary table database are downloaded in the barcode scanner, and generate the table information database that can inquire about at barcode scanner,
In the 5th step, generate the family information database:
By computer by serial data in the interim user data storehouse are downloaded in the barcode scanner, and generate the family information database that can inquire about at barcode scanner,
In the 6th step, gather family table correspondence database:
On-site acceptance staff's barcode scanner in the table bar code be attached on the family bar-code label on the electric energy meter run-down respectively, generates family table correspondence database,
In the 7th step, extract family table correspondence database: system can be sent to the family table correspondence database that the barcode scanner collection generates in the network data base of electricity consumption MIS by the serial port of computing machine.
By from electricity consumption MIS database is applied to install, extracting those user data informations of newly applying to install and prepare to send electricity and the essential information of new clothes ammeter, build up interim user data storehouse and interim user data storehouse, generate the family bar coded sticker of table family correspondence then according to interim user data storehouse, unit in charge of construction pastes this family bar-code label on the ammeter position at corresponding family in construction, by computer by serial data in temporary table database and the interim user data storehouse are downloaded in the barcode scanner then, and generate table information database and the family information database that to inquire about at barcode scanner, this moment is by on-site acceptance staff's barcode scanner, in the table bar code be attached on the family bar-code label on the electric energy meter run-down respectively, generate family table correspondence database, the family table correspondence database that generates the most at last is sent in the network data base of electricity consumption MIS, like this, the automatic typing of new clothes ammeter relevant information in the engineering of just having finished that Every household has an ammeter, adopt this method image data, convenient and swift, avoided increasing labour intensity because of manual input, reduced labour cost, and computer operation, error rate is low.
For the essential information that makes needed user data information and new clothes ammeter is more complete, and more convenient to operate; User data information in the first step comprises family number, name in an account book, address, table sequence number and electricity consumption classification information, and the essential information of new clothes ammeter comprises table number, the table end and assets number in described second step.Certainly as required, can also increase other information.
For user for identical family number, name in an account book, the ammeter of two or more ammeters and two or more different purposes is installed, can distinguish, bar code is made up of family number and table sequence number in described the 3rd step, described literal is made up of family number, name in an account book, table sequence number, classification, and printer 3 is a laser printer.
Barcode scanner 4 has the function at the bottom of manual typing family number, table number and the rewriting table, when the table bar code or be attached to family bar-code label on the electric energy meter when occurring damaging, can or rewrite the table end by manual mode typing family number, table number, then according to manual typing family number, table number or rewrite the table end, form family table correspondence database, range of application is wider.
The foregoing description is just to explanation of the present invention; therefore; protection scope of the present invention not only is confined to the foregoing description, as long as the method for the automatic typing of new clothes ammeter relevant information is identical in structure and applying bar code of the present invention realization Every household has an ammeter the engineering, just drops on the scope of protection of the invention.