CN111339384A - Sim card bar code screening and sorting upper computer operating system - Google Patents
Sim card bar code screening and sorting upper computer operating system Download PDFInfo
- Publication number
- CN111339384A CN111339384A CN202010131127.2A CN202010131127A CN111339384A CN 111339384 A CN111339384 A CN 111339384A CN 202010131127 A CN202010131127 A CN 202010131127A CN 111339384 A CN111339384 A CN 111339384A
- Authority
- CN
- China
- Prior art keywords
- excel
- bar code
- module
- sim
- screening
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000012216 screening Methods 0.000 claims abstract description 35
- 238000003860 storage Methods 0.000 claims abstract description 8
- 238000007726 management method Methods 0.000 claims description 12
- 238000012986 modification Methods 0.000 claims description 7
- 230000006870 function Effects 0.000 claims description 4
- 230000004048 modification Effects 0.000 claims description 4
- 238000013500 data storage Methods 0.000 claims description 3
- 238000012163 sequencing technique Methods 0.000 claims 2
- 238000004519 manufacturing process Methods 0.000 abstract description 7
- 238000004904 shortening Methods 0.000 abstract description 3
- 239000003086 colorant Substances 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 238000000034 method Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000011282 treatment Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9038—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/604—Tools and structures for managing or administering access control systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K7/00—Methods or arrangements for sensing record carriers, e.g. for reading patterns
- G06K7/10—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation
- G06K7/14—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation using light without selection of wavelength, e.g. sensing reflected white light
- G06K7/1404—Methods for optical code recognition
- G06K7/1408—Methods for optical code recognition the method being specifically adapted for the type of code
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- Automation & Control Theory (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Electromagnetism (AREA)
- Toxicology (AREA)
- Artificial Intelligence (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Storage Device Security (AREA)
Abstract
The invention discloses a Sim card bar code screening and sorting upper computer operating system which is characterized by comprising the following components:Excela table data reading and displaying module,SimA card scanning bar code screening display module,ExcelAnd a storage module.ExcelThe table data reading and displaying module is used for reading and displaying table data fromExcelReading in source filesSimThe bar code information of the card and display the read information to an operation interface;Simthe card scanning bar code screening display module is used for searching, screening and displaying scanned bar codes according to scanning characters and fixed rules of the code scanning robbers;Excelthe storage module is used for storing the searched and screened data into a new dataExcelIn the table. By this system, a freedom from scattering is providedOf sequenceSimA system means for quickly sorting card bar code data; simultaneously carrying out the sorted dataExcelStore, facilitate the later periodECUThe controller searches in production, thereby reducing manpower and shortening production time.
Description
Technical Field
The invention relates to the technical field of software systems, in particular to an operating system of a Sim card bar code screening and sorting upper computer.
Background
In thatECUWhen in production, theSimCards and their corresponding bar codes are matched one-to-one, but face a messy disorderSimCard andSimthe corresponding relation between the bar codes of the cards can be quickly found, which is a laborious and troublesome work, wastes a large amount of manpower, and simultaneously spends a large amount of time, and the defect is not overcome by an effective means at present.
Disclosure of Invention
Aiming at the technical problems in the related art, the invention provides an operating system of a Sim card bar code screening and sorting upper computer, which can overcome the defects in the prior art.
In order to achieve the technical purpose, the technical scheme of the invention is realized as follows:
an operating system of an upper computer for screening and sorting Sim card bar codes comprises
ExcelA table data reading and displaying module,SimA card scanning bar code screening display module,ExcelA memory module, wherein,
the above-mentionedExcelThe table data reading and displaying module is used for reading and displaying table data fromExcelReading in source filesSimThe bar code information of the card and display the read information to an operation interface;
the above-mentionedSimThe card scanning bar code screening display module is used for searching, screening and displaying scanned bar code information from a source file according to scanning characters and fixed rules of code scanning robbery, wherein the displayed bar code information is ordered information;
the above-mentionedExcelThe storage module is used for storing the searched and screened information into a new oneExcelIn the table.
Further, theExcelThe table data reading and displaying module comprisesExcelA reading module of the path,ExcelA reading module of table data,ExcelAnd a display module of table data.
Further, theSimThe screening and displaying module of the card scanning bar code comprises a character scanning module, a bar code information searching module, a bar code information screening module and a bar code information displaying module.
Further, the system is inNI Labview_2018And (4) designing on a platform.
Further, theExcelIn the memory module, pairSimWhen the bar code information is stored, the user can set the format of storage generation and data storage according to the style of the userExcelForm template from system catalogExcelThe user may add style in the template, the style including underlining, form line, color of the form, font of the form data, and color of the form data.
Furthermore, the generated form has the function of authority management, and a user can only check the form and cannot directly edit the form.
Further, when the user needs to generateExcelWhen the data content of the table is modified, the data content is set before modificationExcelThe access right of the form can be modified by a user only after a correct management password is input during modification, wherein the management password is set by an administrator during programming.
The invention has the beneficial effects that: by this system, a random disorder is providedSimA system means for quickly sorting card bar code data; simultaneously carrying out the sorted dataExcelStore, facilitate the later periodECUThe controller searches in production, thereby reducing manpower and shortening production time.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings without creative efforts.
Fig. 1 is a schematic block diagram of an Sim card barcode screening and sorting upper computer operating system according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments that can be derived by one of ordinary skill in the art from the embodiments given herein are intended to be within the scope of the present invention.
As shown in fig. 1, an Sim card barcode screening and sorting upper computer operating system according to an embodiment of the present invention includes:Excela table data reading and displaying module,SimA card scanning bar code screening display module,ExcelA memory module, wherein,
the above-mentionedExcelThe table data reading and displaying module is used for reading and displaying table data fromExcelReading in source filesSimThe bar code information of the card and display the read information to an operation interface;
the above-mentionedSimThe card scanning bar code screening display module is used for searching, screening and displaying scanned bar code information from a source file according to scanning characters and fixed rules of code scanning robbery, wherein the displayed bar code information is ordered information;
the above-mentionedExcelThe storage module is used for storing the searched and screened information into a new oneExcelIn the table.
In one embodiment of the invention, theExcelThe table data reading and displaying module comprisesExcelA reading module of the path,ExcelA reading module of table data,ExcelAnd a display module of table data.
In one embodiment of the invention, theSimThe screening and displaying module of the card scanning bar code comprises a character scanning module, a bar code information searching module, a bar code information screening module and a bar code information displaying module.
In one embodiment of the invention, the system is inNI Labview_2018And (4) designing on a platform.
In one embodiment of the invention, theExcelIn the memory module, pairSimWhen the bar code information is stored, the user can set the generated grids according to the style of the userOf formula (II), data storageExcelForm template from system catalogExcelThe user may add style in the template, the style including underlining, form line, color of the form, font of the form data, and color of the form data.
In a specific embodiment of the present invention, the generated form has a function of rights management, and a user can only view the form and cannot directly edit the form.
In one embodiment of the invention, when the user needs to generateExcelWhen the data content of the table is modified, the data content is set before modificationExcelThe access right of the form can be modified by a user only after a correct management password is input during modification, wherein the management password is set by an administrator during programming.
In a particular embodiment of the present invention,Simthe screening display part of the card scanning bar code: screening and searching required information from a source file according to a fixed rule according to the scanning character of the code scanning gun, and outputting the scanned bar code information to a table at the lower right of an interface if the scanning character accords with the searching rule; if the searched bar code information does not accord with the searching rule, the upper computer system pops up a dialog box to prompt a user that the searched bar code does not exist; (a) if the searched bar code has been added to the form at the lower right, a dialog box also pops up to prompt the user that the scan information has been added (b). According to the two error-proofing treatments of a and b, ensureSimAccuracy of card barcode sequence.
When in specific use, the method comprises the following steps:
s1, the system appoints oneExcelRead path fromExcelReading in source filesSimThe bar code information of the card and display the read information to an operation interface;
s2, searching, screening and displaying scanned bar code information from a source file according to the scanning characters and fixed rules of the code scanning gun, wherein the displayed bar code information is ordered information;
s3, storing the searched and screened information into a new oneExcelIn the table.
In one embodiment of the invention, inSimAfter the bar code of the card is read and screened, the bar code after screening and sorting is carried outSimThe bar code is stored, the format of the storage and generation can be set according to the style of the user, and the data is storedExcelThe form format being a template from the system catalogExcelIn the method, a user can add underlines, form lines, form colors, form data fonts and colors and the like into the template by himself, and the template with the set format is stored after the setting is finished, so that a new template is generatedExcelWhen the form is formed, the format in the form is consistent with the format set by the user.
In a specific embodiment of the invention, the generated form has the function of authority management, and the user can only check the form but can not edit the form, so that the condition that the data in the form is modified by misoperation of the user is avoided, the authenticity of the data content of the form is ensured, and if the user does need to modify the data in the formExcelThe data content of the table is modified, and the table needs to be set before being modifiedExcelAfter the prompted management password is input, the user can modify the data and the format, and the password is set by an administrator when the program is written. By the generation mode of the template and the management password, the user can generate the required format according to the requirementExcelThe form also ensures that the data in the form cannot be tampered by people at will.
In summary, with the above technical solution of the present invention, a system for random disorder is providedSimA system means for quickly sorting card bar code data; simultaneously carrying out the sorted dataExcelStore, facilitate the later periodECUThe controller searches in production, thereby reducing manpower and shortening production time.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (7)
1. The utility model provides a Sim card bar code screening sequencing upper computer operating system which characterized in that includes:Excela table data reading and displaying module,SimA card scanning bar code screening display module,ExcelA memory module, wherein,
the above-mentionedExcelThe table data reading and displaying module is used for reading and displaying table data fromExcelReading in source filesSimThe bar code information of the card and display the read information to an operation interface;
the above-mentionedSimThe card scanning bar code screening display module is used for searching, screening and displaying scanned bar code information from a source file according to scanning characters and fixed rules of code scanning robbery, wherein the displayed bar code information is ordered information;
the above-mentionedExcelThe storage module is used for storing the searched and screened information into a new oneExcelIn the table.
2. The system of claim 1, wherein the system comprises a plurality of upper computer operating systems for screening and sorting Sim cards according to their respective formatsExcelThe table data reading and displaying module comprisesExcelA reading module of the path,ExcelA reading module of table data,ExcelAnd a display module of table data.
3. The system of claim 1, wherein the system comprises a plurality of upper computer operating systems for screening and sorting Sim cards according to their respective formatsSimThe screening and displaying module of the card scanning bar code comprises a character scanning module, a bar code information searching module, a bar code information screening module and a bar code information displaying module.
4. The system of claim 1, wherein the system is implemented in a system for screening and sorting the Sim cardsNI Labview_2018And (4) designing on a platform.
5. The system of claim 1, wherein the system comprises a plurality of upper computer operating systems for screening and sorting Sim cards according to their respective formatsExcelIn the memory module, pairSimWhen the bar code information is stored, the user can set the format of storage generation and data storage according to the style of the userExcelForm template from system catalogExcelThe user may add style in the template, the style including underlining, form line, color of the form, font of the form data, and color of the form data.
6. The system for screening and sequencing upper computer operating systems of Sim cards according to claim 1, wherein the generated tables have a function of authority management, and users can only view the tables and cannot directly edit the tables.
7. The system of claim 1, wherein the generated Sim card barcode is selected and sorted by the user when the user desiresExcelWhen the data content of the table is modified, the data content is set before modificationExcelThe access right of the form can be modified by a user only after a correct management password is input during modification, wherein the management password is set by an administrator during programming.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010131127.2A CN111339384A (en) | 2020-02-28 | 2020-02-28 | Sim card bar code screening and sorting upper computer operating system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010131127.2A CN111339384A (en) | 2020-02-28 | 2020-02-28 | Sim card bar code screening and sorting upper computer operating system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111339384A true CN111339384A (en) | 2020-06-26 |
Family
ID=71181942
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010131127.2A Pending CN111339384A (en) | 2020-02-28 | 2020-02-28 | Sim card bar code screening and sorting upper computer operating system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111339384A (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2000068690A (en) * | 1998-08-20 | 2000-03-03 | Sumitomo Wiring Syst Ltd | Method for preventing electronic parts mounting error |
| US20050092833A1 (en) * | 2003-10-29 | 2005-05-05 | Ivoice.Com, Inc. | Product location method utilizing product bar code and product-situated, aisle-identifying bar code |
| CN103616856A (en) * | 2013-12-11 | 2014-03-05 | 哈尔滨工业大学 | Database-based automobile instrument assembly flow line operation control method |
| CN104657701A (en) * | 2013-11-21 | 2015-05-27 | 苏州市拓德网络科技有限公司 | Intelligent visual recognition and tracking method and system applied to plurality of barcodes |
| CN105208803A (en) * | 2015-09-24 | 2015-12-30 | 高德（无锡）电子有限公司 | Fool-proof method for multi-layer plate misplacing |
| CN106672523A (en) * | 2015-11-09 | 2017-05-17 | 上海开铭智能科技有限公司 | SMT material mistake preventing and tracing method and system |
| CN107480734A (en) * | 2017-05-19 | 2017-12-15 | 南京吉帝思信息科技有限公司 | A method and device for intelligent barcode identification of multi-type medical devices |
| CN207302073U (en) * | 2017-10-18 | 2018-05-01 | 深圳市新光扬电子设备有限公司 | Bar code information contrasts device |
| CN209268970U (en) * | 2018-12-28 | 2019-08-20 | 李亚峰 | A kind of magnanimity file administration positioning access device |
| CN110427530A (en) * | 2019-07-03 | 2019-11-08 | 中国第一汽车股份有限公司 | Goods, materials and equipments electronic label recognition method, device, equipment and storage medium |
| CN110705942A (en) * | 2019-10-10 | 2020-01-17 | 环旭电子股份有限公司 | Method and device for screening bar code information |
-
2020
- 2020-02-28 CN CN202010131127.2A patent/CN111339384A/en active Pending
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2000068690A (en) * | 1998-08-20 | 2000-03-03 | Sumitomo Wiring Syst Ltd | Method for preventing electronic parts mounting error |
| US20050092833A1 (en) * | 2003-10-29 | 2005-05-05 | Ivoice.Com, Inc. | Product location method utilizing product bar code and product-situated, aisle-identifying bar code |
| CN104657701A (en) * | 2013-11-21 | 2015-05-27 | 苏州市拓德网络科技有限公司 | Intelligent visual recognition and tracking method and system applied to plurality of barcodes |
| CN103616856A (en) * | 2013-12-11 | 2014-03-05 | 哈尔滨工业大学 | Database-based automobile instrument assembly flow line operation control method |
| CN105208803A (en) * | 2015-09-24 | 2015-12-30 | 高德（无锡）电子有限公司 | Fool-proof method for multi-layer plate misplacing |
| CN106672523A (en) * | 2015-11-09 | 2017-05-17 | 上海开铭智能科技有限公司 | SMT material mistake preventing and tracing method and system |
| CN107480734A (en) * | 2017-05-19 | 2017-12-15 | 南京吉帝思信息科技有限公司 | A method and device for intelligent barcode identification of multi-type medical devices |
| CN207302073U (en) * | 2017-10-18 | 2018-05-01 | 深圳市新光扬电子设备有限公司 | Bar code information contrasts device |
| CN209268970U (en) * | 2018-12-28 | 2019-08-20 | 李亚峰 | A kind of magnanimity file administration positioning access device |
| CN110427530A (en) * | 2019-07-03 | 2019-11-08 | 中国第一汽车股份有限公司 | Goods, materials and equipments electronic label recognition method, device, equipment and storage medium |
| CN110705942A (en) * | 2019-10-10 | 2020-01-17 | 环旭电子股份有限公司 | Method and device for screening bar code information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6031625A (en) | System for data extraction from a print data stream | |
| US6456740B1 (en) | System and method for identifying form type in a handwriting recognition based form completion system | |
| US5040142A (en) | Method of editing and circulating an electronic draft document amongst reviewing persons at remote terminals attached to a local area network | |
| CN113434674A (en) | Data analysis method and device, electronic equipment and readable storage medium | |
| US20070136660A1 (en) | Creation of semantic objects for providing logical structure to markup language representations of documents | |
| CN110543303A (en) | Visual business platform | |
| CN102087657B (en) | IO (Input/output) to point method and IO (Input/output) to point for nuclear power plant simulation platform | |
| US4677585A (en) | Method for obtaining common mode information and common field attribute information for a plurality of card images | |
| CN110288310A (en) | Work visa report management method, equipment, storage medium and device | |
| US20080282148A1 (en) | Processing method for increasing speed of opening a word processing document | |
| CN107145538B (en) | Table data query method, device and system | |
| CN118194842A (en) | Intelligent document identification method and device, electronic equipment and storage medium | |
| CN111190880A (en) | Database detection method and device and computer readable storage medium | |
| US7409388B2 (en) | Generation of anonymized data records for testing and developing applications | |
| CN115391439B (en) | Document data export method, device, electronic equipment and storage medium | |
| CN115374239A (en) | Legal and legal analysis method and device, computer equipment and readable storage medium | |
| CN115510181A (en) | Nuclear power plant instant knowledge management method and system | |
| CN113722352A (en) | Intelligent data verification method, system and storage medium for reporting and reviewing scheme | |
| CN111339384A (en) | Sim card bar code screening and sorting upper computer operating system | |
| JP2568180B2 (en) | Image processing method | |
| CN107563689A (en) | Use bar code management system and method | |
| KR20190101555A (en) | System for automatically inspecting document | |
| CN111767703A (en) | Form data acquisition method, device and system | |
| CA2137830A1 (en) | An automated method for checking patent applications | |
| CN111639478A (en) | Automatic data auditing method and system based on EXCEL document |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200626 |