CN102073625B - Method for generating serial number files of set-top box - Google Patents
Method for generating serial number files of set-top box Download PDFInfo
- Publication number
- CN102073625B CN102073625B CN2010106001160A CN201010600116A CN102073625B CN 102073625 B CN102073625 B CN 102073625B CN 2010106001160 A CN2010106001160 A CN 2010106001160A CN 201010600116 A CN201010600116 A CN 201010600116A CN 102073625 B CN102073625 B CN 102073625B
- Authority
- CN
- China
- Prior art keywords
- excel
- cpu processor
- stb
- data
- row
- 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.)
- Active
Links
Images
Abstract
The invention discloses a method for generating serial number files of a set-top box, comprising the following steps: newly establishing an Excel sample on a PC (Personal Computer); putting the serial numbers of the set-top box in sequence, wherein the serial numbers are increased gradually; adjusting the parameter of the Excel sample until the printed effect can reach the pre-set requirement; adopting a Uedit editor to extract the shell data head 1 and head 2 of the Excel sample; designing an application program on the PC; automatically generating an Excel file by adopting the extracted shell data head 1 and head 2 of the Excel sample via the application program; and providing the input fields of the serial numbers of the initial set-top box and the number of the set-top box so that a user can write; generating a plurality of Excel files under the present catalogue after the user writes and determines, and adopting the input serial number as the name for each file. The method is used for automatically generating the serial number files without needing manual data input and manual data adjustment, thereby greatly reducing the work quantity and simultaneously efficiently avoiding errors.
Description
Technical field
The present invention relates to the technical field of STB, particularly a kind of method that generates STB series number file.
Background technology
Every STB all will stick STB series number label before dispatching from the factory.At present, the series number on the label prints on label paper with bill printer, and then label paper is divided into many little labels, every corresponding series number of little label paper, and series number increases progressively.General manual way is, makes an Excel form earlier, imports corresponding series number then, adjust row height, col width, font and print parameters after, and then series number printed.Artificial input series number is more loaded down with trivial details, and easy error.
Summary of the invention
The objective of the invention is to overcome the deficiency of prior art, a kind of method that generates STB series number file is provided, be used for generating the series number file automatically, need not artificial input data or adjustment data, significantly reduced workload, avoided effectively makeing mistakes simultaneously.
The technical solution adopted for the present invention to solve the technical problems is: a kind of method that generates STB series number file comprises the steps:
A, on PC a newly-built Excel sample; Reader top box series number in order; Series number increases progressively, and the parameter of adjustment Excel sample reaches preset requirement until the effect of output print, extracts the shell data head1 and the head2 of Excel sample with the Uedit editing machine;
B, on PC the design application program; This application program is utilized the shell data head1 and the head2 of the Excel form that steps A extracted, generates the Excel file automatically, and the input field of initial STB series number and STB quantity is provided; Import for the user; After user's input and confirming, under current directory, generate a plurality of Excel files, each file is a title with the series number of input.
Described steps A comprises as follows:
A1, a newly-built Excel sample, and design line number and columns;
A2, reader top box series number in order, series number increases progressively;
The parameter of A3, adjustment Excel sample, parameter comprise row height, col width, font and print parameters, reach preset requirement until the effect of output print;
A4, extract from the data of Excel file header to Excel data field beginning, and be the array head1 of C language format the data-switching of extracting with the Uedit editing machine;
A5, extract data, and be the array head2 of C language format the data-switching of extracting from end, Excel data field to Excel end of file with the Uedit editing machine.
3. a kind of method that generates STB series number file according to claim 1, it is characterized in that: described step B comprises as follows:
B1, show that at the display interface of PC the input field of initial STB series number and STB total quantity supplies user's input; After the user imported initial STB series number, STB total quantity and confirms, the CPU processor of PC obtained the initial series number and the STB total quantity of user's input;
Whether the CPU processor of B2, PC finishes dealing with to all series numbers is judged, if, termination routine then, otherwise continue next step;
The CPU processor of B3, PC is that title is set up the Excel form with first series number;
The array head1 that the CPU processor of B4, PC extracts said steps A 4 writes the Excel form;
The CPU processor of B5, PC number respectively adds 1 respectively with the row of Excel form number and row;
Whether the CPU processor of B6, PC numbers finishes dealing with to all row of this page is judged, if continue next step, otherwise forwards step B9 to;
The array head2 that the CPU processor of B7, PC extracts said steps A 5 writes the Excel form;
The CPU processor of B8, PC cuts out the Excel form, and returns step B2, whether all series numbers is finished dealing with judge;
Whether the CPU processor of B9, PC number finishes dealing with to all row is judged, if continue next step, otherwise forwards step B11 to;
The CPU processor of B10, PC returns step B6 after will the number of going adding 1, whether all row of this page numbers is finished dealing with judge;
The CPU processor of B11, PC extracts one group of preset parameter 0x11 before each data in the Excel list data district, 0x00, and 0x00, and the parameter of extracting write the Excel form;
The CPU processor of B12, PC will the number of going and the series number of row institute correspondence position write the Excel form;
The CPU processor of B13, PC returns step B9 after will the number of being listed as adding 1, and whether all row number is finished dealing with judge.
The invention has the beneficial effects as follows; Characteristics according to the storage of Excel list data; On PC, design the software of a cover generation STB series number file, can be used for generating the series number file automatically, need not artificial input data or adjustment data; Significantly reduced workload, avoided effectively makeing mistakes simultaneously.
Below in conjunction with accompanying drawing and embodiment the present invention is done further explain; But a kind of method that generates STB series number file of the present invention is not limited to embodiment.
Description of drawings
Fig. 1 is the process flow diagram that the present invention extracts sample Excel shell data;
Fig. 2 the present invention generates the process flow diagram of Excel file.
Embodiment
Data storage in the Excel form is clocklike, and the data field is in the centre position of file.The stem of Excel file is relevant controlled variable with the end, is placed on here like parameters such as font, line spaces.The data of change form, these two area contents are constant.The form of data field is simple relatively, and one group of fixing parameter 0x11 is arranged before each data, 0x00, and 0x00 is followed by being required series number.
The present invention is exactly the characteristics according to the storage of Excel list data, on PC, has designed the software of a cover generation STB series number file, can be used for generating the series number file automatically, need not artificial input data or adjustment data.
Embodiment, referring to illustrated in figures 1 and 2, a kind of method that generates STB series number file of the present invention comprises the steps:
A, on PC a newly-built Excel sample; Reader top box series number in order; Series number increases progressively, and the parameter of adjustment Excel sample reaches preset requirement until the effect of output print, extracts the shell data head1 and the head2 of Excel sample with the Uedit editing machine;
B, on PC the design application program; This application program is utilized the shell data head1 and the head2 of the Excel form that steps A extracted, generates the Excel file automatically, and the input field of initial STB series number and STB quantity is provided; Import for the user; After user's input and confirming, under current directory, generate a plurality of Excel files, each file is a title with the series number of input.
Described steps A comprises as follows:
A1, a newly-built Excel sample, and design line number and columns; In this step, the line number and the columns of newly-built Excel sample are set according to actual conditions; In this example, newly-built Excel sample is 25 row, 4 row (shown in the frame 101 of Fig. 1);
A2, reader top box series number in order, series number increases progressively; In this step, the number of STB series number is set according to actual conditions; In this example, the STB series number of input is 100 (shown in the frames 102 of Fig. 1);
The parameter of A3, adjustment Excel sample, parameter comprise row height, col width, font and print parameters, reach preset requirement (shown in the frame 103 of Fig. 1) until the effect of output print;
A4, extract from the data of Excel file header to Excel data field beginning, and be the array head1 (shown in the frame 104 of Fig. 1) of C language format the data-switching of extracting with the Uedit editing machine;
A5, extract data, and be the array head2 (shown in the frame 105 of Fig. 1) of C language format the data-switching of extracting from end, Excel data field to Excel end of file with the Uedit editing machine.
Described step B comprises as follows:
B1, show that at the display interface of PC the input field of initial STB series number and STB total quantity supplies user's input; After the user imported initial STB series number, STB total quantity and confirms, the CPU processor of PC obtained the initial series number and the STB total quantity (shown in the frame 201 of Fig. 2) of user's input;
Whether the CPU processor of B2, PC finishes dealing with to all series numbers is judged, if, termination routine then, otherwise continue next step (shown in the frame 202 of Fig. 2);
The CPU processor of B3, PC is that title is set up Excel form (shown in the frame 203 of Fig. 2) with first series number;
The array head1 that the CPU processor of B4, PC extracts said steps A 4 writes Excel form (shown in the frame 204 of Fig. 2);
The CPU processor of B5, PC number respectively adds 1 (shown in the frame 205 of Fig. 2) respectively with the row of Excel form number and row;
Whether the CPU processor of B6, PC numbers finishes dealing with to all row of this page is judged, if continue next step, otherwise forwards step B9 (shown in the frame 206 of Fig. 2) to;
The array head2 that the CPU processor of B7, PC extracts said steps A 5 writes Excel form (shown in the frame 207 of Fig. 2);
The CPU processor of B8, PC cuts out the Excel form, and returns step B2, whether all series numbers is finished dealing with judge (shown in the frame 208 of Fig. 2);
Whether the CPU processor of B9, PC number finishes dealing with to all row is judged, if continue next step, otherwise forwards step B11 (shown in the frame 209 of Fig. 2) to;
The CPU processor of B10, PC returns step B6 after will the number of going adding 1, whether all row of this page numbers is finished dealing with judge (shown in the frame 210 of Fig. 2);
The CPU processor of B11, PC extracts one group of preset parameter 0x11 before each data in the Excel list data district, 0x00, and 0x00, and the parameter of extracting write Excel form (shown in the frame 211 of Fig. 2);
The CPU processor of B12, PC will the number of going and the series number of row institute correspondence position write Excel form (shown in the frame 212 of Fig. 2);
The CPU processor of B13, PC returns step B9 after will the number of being listed as adding 1, and whether all row number is finished dealing with judge (shown in the frame 213 of Fig. 2).
The foregoing description only is used for further specifying a kind of method that generates STB series number file of the present invention; But the present invention is not limited to embodiment; Every foundation technical spirit of the present invention all falls in the protection domain of technical scheme of the present invention any simple modification, equivalent variations and modification that above embodiment did.
Claims (1)
1. a method that generates STB series number file is characterized in that: comprise steps A and step B; Wherein, steps A comprises:
A1, a newly-built Excel sample, and design line number and columns;
A2, reader top box series number in order, series number increases progressively;
The parameter of A3, adjustment Excel sample, parameter comprise row height, col width, font and print parameters, reach preset requirement until the effect of output print;
A4, extract from the data of Excel file header to Excel data field beginning, and be the array head1 of C language format the data-switching of extracting with the Uedit editing machine;
A5, extract data, and be the array head2 of C language format the data-switching of extracting from end, Excel data field to Excel end of file with the Uedit editing machine;
Step B comprises:
B1, show that at the display interface of PC the input field of initial STB series number and STB total quantity supplies user's input; After the user imported initial STB series number, STB total quantity and confirms, the CPU processor of PC obtained the initial STB series number and the STB total quantity of user's input;
Whether the CPU processor of B2, PC finishes dealing with to all series numbers is judged, if, termination routine then, otherwise continue next step;
The CPU processor of B3, PC is that title is set up the Excel form with initial STB series number;
The array head1 that the CPU processor of B4, PC extracts said steps A 4 writes the Excel form;
The CPU processor of B5, PC number is changed to 1 respectively with the row of Excel form number and row;
Whether the CPU processor of B6, PC numbers finishes dealing with to all row of this page is judged, if continue next step, otherwise forwards step B9 to;
The array head2 that the CPU processor of B7, PC extracts said steps A 5 writes the Excel form;
The CPU processor of B8, PC cuts out the Excel form, and returns step B2, whether all series numbers is finished dealing with judge;
Whether the CPU processor of B9, PC number finishes dealing with to all row is judged, if continue next step, otherwise forwards step B11 to;
The CPU processor of B10, PC returns step B6 after will the number of going adding 1, whether all row of this page numbers is finished dealing with judge;
The CPU processor of B11, PC extracts one group of preset parameter 0x11 before each data in the Excel list data district, 0x00, and 0x00, and the parameter of extracting write the Excel form;
The CPU processor of B12, PC will the number of going and the series number of row institute correspondence position write the Excel form;
The CPU processor of B13, PC returns step B9 after will the number of being listed as adding 1, and whether all row number is finished dealing with judge.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010106001160A CN102073625B (en) | 2010-12-21 | 2010-12-21 | Method for generating serial number files of set-top box |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010106001160A CN102073625B (en) | 2010-12-21 | 2010-12-21 | Method for generating serial number files of set-top box |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102073625A CN102073625A (en) | 2011-05-25 |
| CN102073625B true CN102073625B (en) | 2012-11-28 |
Family
ID=44032170
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010106001160A Active CN102073625B (en) | 2010-12-21 | 2010-12-21 | Method for generating serial number files of set-top box |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102073625B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5091868A (en) * | 1988-05-09 | 1992-02-25 | Westcorp Software Systems, Inc. | Method and apparatus for forms generation |
| US5740408A (en) * | 1993-12-22 | 1998-04-14 | International Business Machines Corporation | Method for automated software application testing |
| CN101174350A (en) * | 2007-11-15 | 2008-05-07 | 北大方正集团有限公司 | Bill processing equipment and method |
-
2010
- 2010-12-21 CN CN2010106001160A patent/CN102073625B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5091868A (en) * | 1988-05-09 | 1992-02-25 | Westcorp Software Systems, Inc. | Method and apparatus for forms generation |
| US5740408A (en) * | 1993-12-22 | 1998-04-14 | International Business Machines Corporation | Method for automated software application testing |
| CN101174350A (en) * | 2007-11-15 | 2008-05-07 | 北大方正集团有限公司 | Bill processing equipment and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102073625A (en) | 2011-05-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101197849B (en) | Method for commuting internet page into wireless application protocol page | |
| CN104158836A (en) | Method for rendering mobile application interface through data | |
| CN102541730A (en) | Semantic identification and automatic generation method for spacecraft test script | |
| CN102214244A (en) | Analytic method and system for docx file information | |
| CN102663103A (en) | Configurable method for automatically generating database and accessing data | |
| CN102521218B (en) | File combining method and file combining device | |
| CN104050281A (en) | Webpage information extraction method and device based on http protocol | |
| CN103034731A (en) | Method for generating Web front-end interactive page | |
| CN103500196A (en) | EXCEL data export method and export device in multi-concurrence large data volume environment | |
| CN102855243A (en) | Method and device for extracting document structure | |
| CN104699714A (en) | Method and device for transferring files of book edition format into files of EPUB format | |
| CN103970736A (en) | Method for converting Excel sheet to database table | |
| CN103902717A (en) | System and method for personalizing internal portals of enterprises | |
| CN109445771A (en) | A kind of off line network layers block code Auto-Generation Tool of CS framework and method | |
| CN107977205A (en) | Gui interface automatically creates method and system | |
| CN102073625B (en) | Method for generating serial number files of set-top box | |
| CN106599324B (en) | CAD data capturing method | |
| CN106202013A (en) | A kind of implementation method of webpage version EXCEL | |
| US10489495B2 (en) | Document collaboration apparatus for supporting simultaneous editing of styles for objects and operating method thereof | |
| CN103309849A (en) | Docx document creating and modifying method based on OpenXML (open extensive markup language) | |
| CN105022667B (en) | One kind being based on built-in browser CSS engine parallel methods | |
| CN105868240A (en) | Method and device for self-adaptive display of page | |
| CN108763279B (en) | Webpage data distributed template acquisition method and system | |
| CN106780302A (en) | A kind of digital picture automatic keyline layout method and device | |
| CN103761395A (en) | Method for generating dynamic report of virtual terminal of intelligent substation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Method for generating serial number files of set-top box Effective date of registration: 20160722 Granted publication date: 20121128 Pledgee: Fujian Zhangzhou rural commercial bank, Limited by Share Ltd Pledgor: Fujian Erling Electronic Co., Ltd. Registration number: 2016350000068 |
|
| PLDC | Enforcement, change and cancellation of contracts on pledge of patent right or utility model | ||
| PC01 | Cancellation of the registration of the contract for pledge of patent right | ||
| PC01 | Cancellation of the registration of the contract for pledge of patent right |
Date of cancellation: 20200528 Granted publication date: 20121128 Pledgee: Fujian Zhangzhou rural commercial bank, Limited by Share Ltd. Pledgor: FUJIAN ERLING ELECTRONICS Co.,Ltd. Registration number: 2016350000068 |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20200707 Address after: 363000 Room 201, building 1, No. 23, Shengli East Road, Xiangcheng District, Zhangzhou City, Fujian Province Patentee after: Zhangzhou Haiyin Intelligent Information Technology Co.,Ltd. Address before: 363000 Fujian city of Zhangzhou Province Zhang Hua Road, No. 47 Patentee before: FUJIAN ERLING ELECTRONICS Co.,Ltd. |