CN108073592A - Judge sequence number whether repeat method and television set sequence number wiring method - Google Patents
Judge sequence number whether repeat method and television set sequence number wiring method Download PDFInfo
- Publication number
- CN108073592A CN108073592A CN201610990914.6A CN201610990914A CN108073592A CN 108073592 A CN108073592 A CN 108073592A CN 201610990914 A CN201610990914 A CN 201610990914A CN 108073592 A CN108073592 A CN 108073592A
- Authority
- CN
- China
- Prior art keywords
- sequence number
- mac
- client
- data
- write
- 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.)
- Granted
Links
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Computer And Data Communications (AREA)
- General Factory Administration (AREA)
Abstract
The present invention disclose it is a kind of judge sequence number whether repeatedly method and television set sequence number wiring method.Judge whether the method repeated includes sequence number：Client receives sequence number to be judged and No. MAC；Client query database；After completing data base querying, client judges sequence number and whether No. MAC repeat；If judging sequence number and MAC repetitions, the sequence number repeated and No. MAC are write XLS documents by client；If judging sequence number and No. MAC not repeating, client will be in the sequence number and No. MAC write-in database.Before sequence number and MAC write-ins electric appliance such as television set, set-top box or car-mounted terminal, first judge sequence number and whether No. MAC repeat, can effectively avoid sequence number and No. MAC is repeatedly written, reduce later stage human input, improve treatment effeciency.The present invention judge sequence number whether repeatedly method, can be used between different producing lines, avoid sequence number and MAC repetitions between different producing lines.
Description
Technical field
The present invention relates to computer realm, specifically, be related to it is a kind of judge sequence number whether repeat method and television set
The wiring method of sequence number.
Background technology
Before television set dispatches from the factory, it is necessary into television set writing sequence number, and require the sequence number of every television set write-in
All there is uniqueness, it is not reproducible.And under existing technical conditions, due to before sequence number is write television set, and not having
The function that whether different television set sequence numbers are repeatedly written between sequence number and same production line between variant production line is inquired about,
Sequence number is caused often to be repeatedly written in television set, so as to increase later stage human input significantly, reduces production efficiency.
The content of the invention
In view of the deficiencies of the prior art, the present invention provide it is a kind of judge sequence number whether repeatedly method and television set sequence
Number wiring method.
According to the first aspect of the invention, it is disclosed herein it is a kind of judge sequence number whether repeat method, including：
Data receiver：Client receives sequence number to be judged and No. MAC；
Data base querying：Client query database；
Judge whether data repeat：After completing data base querying, client judges sequence number and whether No. MAC repeat；
Data processing：If judging sequence number and MAC repetitions, client is literary by the sequence number repeated and No. MAC write-in XLS
Shelves；If judging sequence number and No. MAC not repeating, client will be in sequence number and No. MAC write-in database.
According to an embodiment of the present invention, database querying step includes：
If network is in connection status, client first inquires about remote data base, this is carried out after completing remote database lookup
Ground data base querying, after completing local data library inquiry, execution judges whether data repeat step；
If network is off, local data base is only inquired about, after completing local data library inquiry, execution judges number
The step according to whether repeatedly.
According to an embodiment of the present invention, data processing step includes：Repetition flag seat step is set and judges number
Whether sub-step is repeated according to flag bit：
Repetition flag position is set：
If network is in connection status, and judges sequence number and MAC repetitions, client sets local repeated data mark
Position and long-range repeated data flag bit, it is rear perform judge Data Labels position whether sub-step repeatedly；If judge sequence number and MAC
Number do not repeat, then directly perform judge Data Labels position whether sub-step repeatedly；
If network is off, and judges sequence number and MAC repetitions, client sets local repeated data mark
Position, rear perform judge whether Data Labels position repeats sub-step；If judging sequence number and No. MAC not repeating, directly perform and sentence
Whether disconnected Data Labels position repeats sub-step；
Judge whether Data Labels position repeats：
If network is in connection status, client judges whether teledata flag bit and local data flag bit repeat：
If repeating, sequence number and No. MAC are write XLS documents by client；If not repeating, client is remote by sequence number and No. MAC write-in
Journey database and local data base；
If network is off, client judges whether local data flag bit repeats：If repeating, client is by sequence
Row number and No. MAC write-in XLS document；If not repeating, sequence number and No. MAC are write local data base by client.
According to an embodiment of the present invention, method further includes following steps：
Servers' data judges：If network is in connection status, client is by the sequence number and MAC to be judged of reception
Number also it is sent to server end, received server-side to sequence number and No. MAC, server end inquiry remote data base and local number
According to storehouse, judge sequence number and whether No. MAC repeat, if repeating, server end feeds back judging result to client, client executing
Database querying step；If not repeating, server end feeds back judging result to client, and sequence number and No. MAC write-in is long-range
Database and local data base, database querying step described in client executing.
According to an embodiment of the present invention, during servers' data judges, client is by the sequence to be judged of reception
Number and No. MAC be sent to server end include following sub-step：
Data Format Transform：The sequence number of acquisition and No. MAC are converted into string format；
String segmentation：" ' or t ' will be used between each field in string format " segmentation；
Send field：Send each field split；
Received server-side sequence number and No. MAC include following sub-step：
Receive field：Receive each field that client is sent；
Storage field simultaneously inquires about database：First each field is stored in tuple；
Subsequent server end inquires about remote data base and local data base again.
According to an embodiment of the present invention,：During servers' data judges, client and server is covered by TCP
It connects word and carries out network communication, server end receives the sequence number to be judged of client transmission by TCP socket communication mode
And No. MAC.
According to an embodiment of the present invention, the sequence number repeated and No. MAC write-in XLS document are included：
The sequence number repeated and No. MAC are read in file stream；
It obtains the worksheet of XLS and needs to write the null in XLS worksheets；
It will be in the sequence number that repeated and the corresponding unit lattice of No. MAC write-in null；
Flush files stream is closed.
According to an embodiment of the present invention, the method, which further includes, intercepts port step：Server end is intercepted more simultaneously
The port of a client, and establish communication connection respectively with multiple client, to receive the reception that each client is sent respectively
Sequence number and No. MAC, rear execute server end data judgment step.
Before sequence number and No. MAC write-in, first it is made whether the judgement repeated, subsequent sequence number and MAC can be avoided
It number is repeatedly written, increases manual operation.Applied in multiple producing lines, in the case where multiple producing lines share a server, go back
The phenomenon that being repeated to avoid sequence number between multiple producing lines.In preferred embodiment, the communication between client and server is adopted
With TCP socket, the repetition of sequence number between different producing lines more efficient can be avoided so that judgement sequence number weight of the invention
Multiple method has faster data speed, so as to ensure that the product ID of production has not repeated with great abbreviation production
The follow-up operation for being more conducive to subsequent artefacts.
According to the second aspect of the invention, a kind of wiring method of television set sequence number is disclosed herein, including：
It transmits Sequence Number and No. MAC：Sequence number that multiple write sequence softwares are written into respectively and No. MAC are sent to visitor
Family end；
Data receiver：Sequence number and No. MAC are treated in client reception；
Data base querying：Client query database；
Judge whether data repeat：After completing data base querying, client judges sequence number and whether No. MAC repeat；
Data processing：If judging sequence number and MAC repetitions, client feedback judging result to each write sequence software,
And the sequence number repeated and No. MAC are write into XLS documents；If judging sequence number and No. MAC not repeating, client feedback judges knot
Fruit to each write sequence software, and will sequence number and No. MAC write-in database in；
Sequence number writes：If sequence number and No. MAC do not repeat, write sequence software writing sequence number into corresponding television set
And No. MAC, if repeating, it is not written into.
The wiring method of television set sequence number can avoid sequence number and MAC repetitions between different television sets and different producing lines
Write-in greatly reduces since sequence number and No. MAC are repeatedly written the human input in caused later stage, while improves place
Manage efficiency.
Description of the drawings
Attached drawing described herein is used for providing further understanding of the present application, forms the part of the application, this Shen
Schematic description and description please does not form the improper restriction to the application for explaining the application.In the accompanying drawings：
Fig. 1 is client software flow chart in embodiment one；
Fig. 2 is server software flow chart in embodiment one；
Fig. 3 is client software structure diagram in embodiment one；
Fig. 4 is the flow chart that NPOI components operate XLS in embodiment one；
Fig. 5 is SQLite3 order execution flow charts in embodiment one.
Specific embodiment
Multiple embodiments of the present invention, as clearly stated, the details in many practices will be disclosed with schema below
It will be explained in the following description.It should be appreciated, however, that the details in these practices is not applied to limit the present invention.Also
It is to say, in some embodiments of the present invention, the details in these practices is non-essential.In addition, for the sake of simplifying schema,
Some known usual structures will illustrate it in a manner of simply illustrative in the drawings with component.
The present invention for be related to it is a kind of judge sequence number whether repeatedly method and television set sequence number wiring method.This
Invention can solve the problems, such as that sequence number and No. MAC are repeatedly written in television set production, are especially that of avoiding between different producing lines
The generation for the phenomenon that television set sequence number and No. MAC are repeatedly written.By the way that the write sequence software of each producing line is covered by TCP
It connects word mode and is connected to server, between each producing line is realized in the case that each producing line shares the database of a server
Sequence number and No. MAC do not repeat, and sequence number and No. MAC to repeating are prompted, and the operation of XLS documents is recorded,
So as to the operation of subsequent artefacts.In addition, it is of the invention to judge method that whether sequence number repeat and television set sequence number
Wiring method, can be also used for other needs in writing sequence number and the product of No. MAC such as set-top box or car-mounted terminal, equally
It can be repeatedly written to avoid sequence number and No. MAC, save manual operation, improve production efficiency.
In addition, the client in the present invention realizes that server end is then realized using Python using C#, client and service
The data at device end, which are stored and inquired about, is all based on SQLite3, and the communication between client and server uses TCP socket.
Hereinafter, by the present invention will be described in detail in two specific embodiments judge method that whether sequence number repeat and
The wiring method of television set sequence number.
Embodiment one：
In this example, judging sequence number, whether the method repeated in turn includes the following steps：Data receiver, data base querying,
Judge data whether repeat and data processing step, specifically：
Data receiver：Client receives sequence number to be judged and No. MAC；
Data base querying：Client query database；
Judge whether data repeat：After completing data base querying, client judges sequence number and whether No. MAC repeat；
Data processing：If judging sequence number and MAC repetitions, client is literary by the sequence number repeated and No. MAC write-in XLS
Shelves；If judging sequence number and No. MAC not repeating, client will be in sequence number and No. MAC write-in database.
The sequence number judged and No. MAC can be directly inputted into client by user interface, can also be by
Code reader scanning sequence number and No. MAC or by being sent to client after write sequence Software Create sequence number and No. MAC,
Client query database, after the inquiry for completing database, client carry out again data whether repeat judgement, client according to
Judging result carries out data processing, and will determine that result feeds back to user.Specifically, after client completes inquiry, client will
The sequence number of reception and No. MAC are compared with the sequence number stored in database and No. MAC, to judge whether data repeat.
Hereinafter, the present embodiment will be described in detail so that network is in connection status and network is off both of these case as an example
The present invention judge sequence number whether repeatedly method.
(1) network is in connection status
If network is in connection status, judge sequence number whether repeat method idiographic flow it is as follows, incorporated by reference to Fig. 1：
Data receiver：Client receives sequence number to be judged and No. MAC；
After client receives sequence number and No. MAC, following database querying steps are performed：
Data base querying：Client first inquires about remote data base, and local data base is carried out after completing remote database lookup
Inquiry, after completing local data library inquiry, execution judges whether data repeat step；
Judge whether data repeat：After completing remote database lookup and local data library inquiry, client judges sequence
Number and No. MAC whether repeat, perform data processing step afterwards；
After judging whether data repeat, it is any group Data duplication to further confirm that, further includes data processing step, number
Include according to processing step：Repetition flag seat step is set and judges whether Data Labels position repeats sub-step：
Repetition flag position is set：If judging sequence number and MAC repetitions, client set local repeated data flag bit and
Long-range repeated data flag bit, it is rear perform judge Data Labels position whether sub-step repeatedly；If judge sequence number and No. MAC not
Repeat, then directly perform judge Data Labels position whether repeatedly sub-step；
Judge whether Data Labels position repeats：Client judges whether teledata flag bit and local data flag bit weigh
It is multiple：If repeating, sequence number and No. MAC are write XLS documents by client；If not repeating, client writes sequence number and No. MAC
Remote data base and local data base.
In this example, the database query operations of client are divided into local data library inquiry and remote database lookup two
Point.If network is in connection status, when client carries out the inquiry of local data base and remote data base, in order to avoid remotely counting
It is taken considerable time when being carried out at the same time according to library inquiry and local data library inquiry, wherein, remote database lookup is placed on main thread
Middle progress, local data library inquiry are then put into thread and are carried out, and are carrying out judging whether teledata and local data repeat
Before, main thread is allowed to wait the inquiry for completing local data base and remote data base until local data base poll-final always
Afterwards, another rise judges whether data repeat, and then mainly carries out the operation of Data duplication flag bit.If local data base and remote
After journey database completes inquiry, judge sequence number and MAC repetitions, then local repeated data mark and long-range repeated data are set
Flag bit, then, client judges whether local data flag bit and teledata flag bit repeat；If local data base and remote
After journey database completes inquiry, judge sequence number and No. MAC does not repeat, then client directly judges local data flag bit and remote
Whether number of passes repeats according to flag bit, carry out local data flag bit and teledata flag bit whether the judgement repeated, be in order to
Further confirm that it is any group sequence number and MAC repetitions.If local data flag bit and teledata flag bit repeat, client
By sequence number and No. MAC write-in XLS document, and pass through Client-Prompt user, if local data flag bit and teledata mark
Will position does not repeat, and sequence number and No. MAC are write direct local data base and remote data base by client, and prompt user.
In preference, after client receives sequence number and No. MAC, sequence number and No. MAC can also be sent to service
Device end, server end carry out data judgement, please refer to Fig.2.Server end intercepts port, establishes and connects with client, server
Thread is opened at end, with received serial number and No. MAC, receive client transmission sequence number and No. MAC, server end inquiry is remote
Journey database and local data base, judge sequence number and whether No. MAC repeat, if repeating, server end feedback judging result is extremely
Client；If not repeating, server end feeds back judging result to client, and sequence number and No. MAC is write remote data base
And local data base.After judging result feeds back to client, client continues sequence number and No. MAC according to flow shown in Fig. 1 is
The judgement of no repetition.Server end will determine that result feeds back to client, and the value and meaning of feedback are as shown in table 1：
| Meaning | Value of feedback |
| Sequence number repeats | Duplicate SN |
| LAN MAC are repeated | Duplicate LAN |
| WIFI MAC are repeated | Duplicate WIFI |
| BT MAC are repeated | Duplicate BT |
| New data | New data |
Table 1
It is client software structure diagram such as Fig. 3, wherein, in Fig. 3, user interface major function is to realize and user
Interaction and the communication with other structures, such as list entries number and No. MAC and display data judging result.When being judged
Sequence number and No. MAC inputted by operating user interface, after list entries number and No. MAC, when client is by sequence number and MAC
When number being sent to server end, client and server is communicated by TCP socket, and client transmits Sequence Number and No. MAC
To server end, received server-side sequence number and No. MAC；Server end carry out data whether the judgement repeated, and will determine that
As a result client is fed back to by TCP socket.TCP socket is used for the data communication of client and server, has
Data-transformation facility, specifically, client and server are established by TCP socket and communicated；Client passes through TCP socket
Mode transmits Sequence Number and No. MAC to server end, and whether server end sends data by TCP socket mode to client
The judging result repeated.
When client judges sequence number and MAC repetitions, for the data repeated, NPOI components operation XLS, by sequence number
And No. MAC write-in XLS；For unduplicated data, SQLite3 database manipulations carry out the storage of data.
It please referring to Fig.4, the data repeated are write XLS documents mainly by being realized by NPOI components of increasing income by client,
The data repeated are write using NPOI components by XLS documents.For the data repeated, NPOI components operation XLS, by repeated data
Write XLS documents, NPOI components operation XLS flows as shown in figure 4, including：
The sequence number repeated and No. MAC are read in file stream；
It obtains the worksheet of XLS and needs to write the null in XLS worksheets；
It will be in the sequence number that repeated and the corresponding unit lattice of No. MAC write-in null；
Flush files stream is closed.
If data do not repeat, with reference to figure 5, SQLite3 database manipulations store local data, SQLite3 orders
It is as shown in Figure 5 to perform flow.
Client first sets repetition flag position, and whether rear judgement symbol position repeats, and can either realize what whether data repeated
Judge, moreover it is possible to further confirm that be which group Data duplication, so as to the group repeat count according to carry out manual operation.
During above-mentioned servers' data judges, the sequence number to be judged of reception and No. MAC are sent to service by client
Device end includes following sub-step：
Data Format Transform：The sequence number of acquisition and No. MAC are converted into string format；
String segmentation：" ' or t ' will be used between each field in string format " segmentation；
Send field：Send each field split；
Received server-side sequence number and No. MAC include following sub-step：
Receive field：Receive each field that client is sent；
Storage field simultaneously inquires about database：First each field is stored in tuple；
Subsequent server end inquires about remote data base and local data base again.
(2) network is off
If network is off, judge sequence number whether repeat method idiographic flow it is as follows, incorporated by reference to Fig. 2 mono-
And understand：
Data receiver：Client receives sequence number to be judged and No. MAC；
After client receives sequence number and No. MAC, following database querying steps are performed：
Data base querying：Client carries out local data library inquiry, and after completing local data library inquiry, execution judges data
Whether step is repeated；
Judge whether data repeat：After completing local data library inquiry, client judges sequence number and whether No. MAC weigh
It is multiple, data processing step is performed afterwards；
After judging whether data repeat, it is any group Data duplication to further confirm that, further includes data processing step, number
Include according to processing step：Repetition flag seat step is set and judges whether Data Labels position repeats sub-step：
Repetition flag position is set：If judging sequence number and MAC repetitions, client sets local repeated data flag bit,
Afterwards perform judge Data Labels position whether repeatedly sub-step；If judging sequence number and No. MAC not repeating, judgement is directly performed
Data Labels position whether repeat sub-step；
Judge whether Data Labels position repeats：Client judges whether local data flag bit repeats：If it repeats, client
By sequence number and No. MAC write-in XLS document；If not repeating, sequence number and No. MAC are write local data base by client.
Wherein, it is identical to be in connection status for operation and network of the client the data write-in XLS documents repeated, such as Fig. 3
Shown, which is not described herein again.If data do not repeat, with reference to figure 4, SQLite3 database manipulations store local data,
It is as shown in Figure 4 that SQLite3 orders perform flow.
If network connection is off, the inquiry of local data base is only carried out.If local data base completes inquiry
Afterwards, judge sequence number and MAC repetitions, then local repeated data mark is set, then, client end judges local data mark
Whether position repeats；If after local data base completes inquiry, judge sequence number and No. MAC does not repeat, then client directly judges this
Whether ground Data Labels position repeats, carry out local data flag bit whether the judgement repeated, be to further confirm that it is any group
Sequence number and MAC repetitions.If local data flag bit repeats, client carries sequence number and No. MAC write-in XLS document
Show user, if local data flag bit does not repeat, sequence number and No. MAC are write direct local data base by client, and are prompted
User.
Compared due to the operation of above-mentioned write-in database and write-in XLS documents and expend the time, so in this example, judge sequence
Number and No. MAC whether the method repeated is put into them in two threads and carries out, at this time in order to avoid the conflict between thread, add
Lock mechanism is entered, has ensured that a thread can not obtain both of these documents using other operations when database or XLS documents.
If be carried out at the same time the judgement whether multiple production line sequence numbers repeat, server end intercepts multiple client simultaneously
Port, and pass through TCP socket and multiple client and establish communication connection respectively, be adopted as each communicate to connect and establish one
The mode of thread process, main thread continues to intercept particular clients port after establishing thread, and thread is then carried out receiving data and looked into
Ask database, judge whether data repeat, data processing and feedback judging result step operations.
Before sequence number and No. MAC write-in, first it is made whether the judgement repeated, subsequent sequence repetition can be avoided to write
Enter, increase manual operation.Applied in multiple producing lines, in the case where multiple producing lines share a server, can also avoid
Sequence number and the phenomenon that MAC repetitions between multiple producing lines.In preferred embodiment, the communication between client and server uses
TCP socket more efficient can avoid sequence number and the repetition of No. MAC between different producing lines so that judgement sequence of the invention
The method that row number repeats has faster data speed, so as to ensure that the product ID of production and No. MAC do not repeat and pole
The follow-up operation for being more conducive to subsequent artefacts of big abbreviation production.
Embodiment two：
The present embodiment provides a kind of wiring method of television set sequence number, including：
It transmits Sequence Number and No. MAC：Sequence number that multiple write sequence softwares are written into respectively and No. MAC are sent to visitor
Family end；
Data receiver：Sequence number and No. MAC are treated in client reception；
Data base querying：Client query database；
Judge whether data repeat：After completing data base querying, client judges sequence number and whether No. MAC repeat；
Data processing：If judging sequence number and MAC repetitions, client feedback judging result to each write sequence software,
And the sequence number repeated and No. MAC are write into XLS documents；If judging sequence number and No. MAC not repeating, client feedback judges knot
Fruit to each write sequence software, and will sequence number and No. MAC write-in database in；
Sequence number writes：If sequence number and No. MAC do not repeat, write sequence software writing sequence number into corresponding television set
And No. MAC, if repeating, it is not written into.
In other embodiments, data base querying, data processing and servers' data judgment step and write XLS text
Shelves operation is identical with embodiment one, and which is not described herein again.
The wiring method of television set sequence number can avoid sequence number and MAC repetitions between different television sets and different producing lines
Write-in greatly reduces since sequence number and No. MAC are repeatedly written the human input in caused later stage, while improves place
Manage efficiency.
The upper only embodiments of the present invention, are not intended to limit the invention.For those skilled in the art
For, the invention may be variously modified and varied.All any modifications made in spirit and principles of the present invention are equal
Replace, improve etc., it should all be included within scope of the presently claimed invention.
Claims (9)
1. it is a kind of judge sequence number whether repeat method, which is characterized in that described method includes following steps：
Data receiver：Client receives sequence number to be judged and No. MAC；
Data base querying：Client query database；
Judge whether data repeat：After completing data base querying, client judges sequence number and whether No. MAC repeat；
Data processing：If judging sequence number and MAC repetitions, the sequence number repeated and No. MAC are write XLS documents by client；
If judging sequence number and No. MAC not repeating, client will be in the sequence number and No. MAC write-in database.
2. according to the method described in claim 1, it is characterized in that, the database querying step includes：
If network is in connection status, client first inquires about remote data base, and local number is carried out after completing remote database lookup
According to library inquiry, after completing local data library inquiry, execution judges whether data repeat step；
If network is off, local data base is only inquired about, after completing local data library inquiry, execution judges that data are
It is no to repeat step.
3. according to the method described in claim 2, it is characterized in that, the data processing step includes：Repetition flag position is set
Sub-step and judge Data Labels position whether repeat sub-step：
Repetition flag position is set：
If network is in connection status, and judges sequence number and MAC repetitions, client set local repeated data flag bit and
Long-range repeated data flag bit, it is rear perform judge Data Labels position whether sub-step repeatedly；If judge sequence number and No. MAC not
Repeat, then directly perform judge Data Labels position whether repeatedly sub-step；
If network is off, and judges sequence number and MAC repetitions, client sets local repeated data flag bit,
It performs afterwards and judges whether Data Labels position repeats sub-step；If judging sequence number and No. MAC not repeating, directly perform and judge number
Whether sub-step is repeated according to flag bit；
Judge whether Data Labels position repeats：
If network is in connection status, client judges whether teledata flag bit and local data flag bit repeat：If weight
Multiple, sequence number and No. MAC are write XLS documents by client；If not repeating, client remotely counts sequence number and No. MAC write-in
According to storehouse and local data base；
If network is off, client judges whether local data flag bit repeats：If repeating, client is by sequence number
And No. MAC write-in XLS document；If not repeating, sequence number and No. MAC are write local data base by client.
4. according to any methods of claim 2-3, which is characterized in that further include following steps：
Servers' data judges：If network is in connection status, client goes back the sequence number to be judged of reception and No. MAC
It is sent to server end, received server-side to sequence number and No. MAC, server end inquiry remote data base and local data
Storehouse, judges sequence number and whether No. MAC repeat, if repeating, server end feeds back judging result to client, client executing institute
State database querying step；If not repeating, server end feeds back judging result to client, and sequence number and No. MAC write-in is remote
Journey database and local data base, database querying step described in client executing.
5. according to the method described in claim 4, it is characterized in that, in servers' data judgement, client will receive
Sequence number to be judged and No. MAC be sent to server end include following sub-step：
Data Format Transform：The sequence number of acquisition and No. MAC are converted into string format；
String segmentation：" ' or t ' will be used between each field in string format " segmentation；
Send field：Send each field split；
The received server-side sequence number and No. MAC include following sub-step：
Receive field：Receive each field that client is sent；
Storage field simultaneously inquires about database：First each field is stored in tuple；
Subsequent server end inquires about remote data base and local data base again.
6. according to the method described in claim 4, it is characterized in that：During servers' data judges, client and server
Network communication is carried out by TCP socket, server end is waited to judge by what TCP socket communication mode reception client was sent
Sequence number and No. MAC.
7. according to any methods of claim 1-3, which is characterized in that described to write the sequence number repeated and No. MAC
XLS documents include：
The sequence number repeated and No. MAC are read in file stream；
It obtains the worksheet of XLS and needs to write the null in XLS worksheets；
It will be in the sequence number that repeated and the corresponding unit lattice of No. MAC write-in null；
Flush files stream is closed.
8. according to the method described in claim 4, it is characterized in that：The method, which further includes, intercepts port step：Server end
The port of multiple client is intercepted simultaneously, and establishes communication connection respectively with multiple client, to receive each client respectively
The received serial number of transmission and No. MAC, rear execute server end data judgment step.
9. a kind of wiring method of television set sequence number, which is characterized in that said write method includes：
It transmits Sequence Number and No. MAC：Sequence number that multiple write sequence softwares are written into respectively and No. MAC are sent to client
End；
Data receiver：Sequence number and No. MAC are treated in client reception；
Data base querying：Client query database；
Judge whether data repeat：After completing data base querying, client judges sequence number and whether No. MAC repeat；
Data processing：If judging sequence number and MAC repetitions, client feedback judging result to each write sequence software, and will
The sequence number repeated and No. MAC write-in XLS document；If judging sequence number and No. MAC not repeating, client feedback judging result is extremely
Each write sequence software, and will be in the sequence number and No. MAC write-in database；
Sequence number writes：If sequence number and No. MAC do not repeat, write sequence software into corresponding television set writing sequence number and
It No. MAC, if repeating, is not written into.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610990914.6A CN108073592B (en) | 2016-11-10 | 2016-11-10 | Method for judging whether sequence number is repeated or not and method for writing in sequence number of television |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610990914.6A CN108073592B (en) | 2016-11-10 | 2016-11-10 | Method for judging whether sequence number is repeated or not and method for writing in sequence number of television |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108073592A true CN108073592A (en) | 2018-05-25 |
| CN108073592B CN108073592B (en) | 2022-09-06 |
Family
ID=62154587
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610990914.6A Active CN108073592B (en) | 2016-11-10 | 2016-11-10 | Method for judging whether sequence number is repeated or not and method for writing in sequence number of television |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108073592B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112099454A (en) * | 2020-09-24 | 2020-12-18 | 富泰华精密电子（郑州）有限公司 | Control method, control device, and storage medium |
| CN112950236A (en) * | 2021-03-31 | 2021-06-11 | 四川虹美智能科技有限公司 | Serial number writing method and device and computer readable medium |
| CN113014491A (en) * | 2021-02-26 | 2021-06-22 | 山东英信计算机技术有限公司 | Method and device for checking server MAC address repetition |
| CN113204468A (en) * | 2021-05-13 | 2021-08-03 | 山东英信计算机技术有限公司 | Method, system and storage medium for removing duplicate of server diagnosis information |
| CN113836575A (en) * | 2021-08-18 | 2021-12-24 | 青岛中科英泰商用系统股份有限公司 | Equipment information write-in control method and system thereof |
| CN114124904A (en) * | 2022-01-25 | 2022-03-01 | 北京智象信息技术有限公司 | Method and system for verifying MAC addresses to be burnt into multiple devices by server |
| CN114338611A (en) * | 2021-12-30 | 2022-04-12 | 苏州易德龙科技股份有限公司 | Management and control method for avoiding MAC ID repetition |
Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050044530A1 (en) * | 2003-08-21 | 2005-02-24 | Lev Novik | Systems and methods for providing relational and hierarchical synchronization services for units of information manageable by a hardware/software interface system |
| CN1917540A (en) * | 2006-07-27 | 2007-02-21 | 中山大学 | Distribution type resource shared device and method in use for digital cells |
| CN101371254A (en) * | 2003-02-21 | 2009-02-18 | 索尼电子有限公司 | Medium content identification |
| US20090059809A1 (en) * | 2003-11-21 | 2009-03-05 | Kenneth Gould | System and Method for Detecting and Reporting Cable Network Devices with Duplicate Media Access Control Addresses |
| CN102081537A (en) * | 2010-12-31 | 2011-06-01 | 青岛海信宽带多媒体技术有限公司 | Method for upgrading software |
| CN102377753A (en) * | 2010-08-19 | 2012-03-14 | 腾讯科技（深圳）有限公司 | System information identification method, device and system |
| CN102521252A (en) * | 2011-11-17 | 2012-06-27 | 四川长虹电器股份有限公司 | Access method of remote data |
| CN103793485A (en) * | 2014-01-20 | 2014-05-14 | 锐达互动科技股份有限公司 | Method for inquiring network data by client terminal based on cached data |
| CN104111936A (en) * | 2013-04-18 | 2014-10-22 | 阿里巴巴集团控股有限公司 | Method and system for querying data |
| CN104156796A (en) * | 2014-06-23 | 2014-11-19 | 福建二菱电子有限公司 | Method and system for managing production line of MAC (Media Access Control) address on Internet set top box |
| CN104461641A (en) * | 2014-12-15 | 2015-03-25 | 福州瑞芯微电子有限公司 | Data burning and writing method, system and equipment and target equipment |
| CN105142024A (en) * | 2015-08-20 | 2015-12-09 | 深圳Tcl数字技术有限公司 | Method and device for recording television data |
| CN105407146A (en) * | 2015-10-27 | 2016-03-16 | 成都艾克尔特医疗科技有限公司 | Data synchronization method from wristband to APP to server |
| CN105611408A (en) * | 2015-12-23 | 2016-05-25 | 深圳创维数字技术有限公司 | Set top box number writing method, set top box and set top box number writing server |
| CN105763924A (en) * | 2016-01-29 | 2016-07-13 | 四川长虹电器股份有限公司 | Double search method based on application of intelligent set top box |
| CN105871855A (en) * | 2016-04-11 | 2016-08-17 | 杨鹏 | Method and system for generating, storing and identifying identification code of electronic equipment |
-
2016
- 2016-11-10 CN CN201610990914.6A patent/CN108073592B/en active Active
Patent Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101371254A (en) * | 2003-02-21 | 2009-02-18 | 索尼电子有限公司 | Medium content identification |
| US20050044530A1 (en) * | 2003-08-21 | 2005-02-24 | Lev Novik | Systems and methods for providing relational and hierarchical synchronization services for units of information manageable by a hardware/software interface system |
| US20090059809A1 (en) * | 2003-11-21 | 2009-03-05 | Kenneth Gould | System and Method for Detecting and Reporting Cable Network Devices with Duplicate Media Access Control Addresses |
| CN1917540A (en) * | 2006-07-27 | 2007-02-21 | 中山大学 | Distribution type resource shared device and method in use for digital cells |
| CN102377753A (en) * | 2010-08-19 | 2012-03-14 | 腾讯科技（深圳）有限公司 | System information identification method, device and system |
| CN102081537A (en) * | 2010-12-31 | 2011-06-01 | 青岛海信宽带多媒体技术有限公司 | Method for upgrading software |
| CN102521252A (en) * | 2011-11-17 | 2012-06-27 | 四川长虹电器股份有限公司 | Access method of remote data |
| CN104111936A (en) * | 2013-04-18 | 2014-10-22 | 阿里巴巴集团控股有限公司 | Method and system for querying data |
| CN103793485A (en) * | 2014-01-20 | 2014-05-14 | 锐达互动科技股份有限公司 | Method for inquiring network data by client terminal based on cached data |
| CN104156796A (en) * | 2014-06-23 | 2014-11-19 | 福建二菱电子有限公司 | Method and system for managing production line of MAC (Media Access Control) address on Internet set top box |
| CN104461641A (en) * | 2014-12-15 | 2015-03-25 | 福州瑞芯微电子有限公司 | Data burning and writing method, system and equipment and target equipment |
| CN105142024A (en) * | 2015-08-20 | 2015-12-09 | 深圳Tcl数字技术有限公司 | Method and device for recording television data |
| CN105407146A (en) * | 2015-10-27 | 2016-03-16 | 成都艾克尔特医疗科技有限公司 | Data synchronization method from wristband to APP to server |
| CN105611408A (en) * | 2015-12-23 | 2016-05-25 | 深圳创维数字技术有限公司 | Set top box number writing method, set top box and set top box number writing server |
| CN105763924A (en) * | 2016-01-29 | 2016-07-13 | 四川长虹电器股份有限公司 | Double search method based on application of intelligent set top box |
| CN105871855A (en) * | 2016-04-11 | 2016-08-17 | 杨鹏 | Method and system for generating, storing and identifying identification code of electronic equipment |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112099454A (en) * | 2020-09-24 | 2020-12-18 | 富泰华精密电子（郑州）有限公司 | Control method, control device, and storage medium |
| CN113014491A (en) * | 2021-02-26 | 2021-06-22 | 山东英信计算机技术有限公司 | Method and device for checking server MAC address repetition |
| CN113014491B (en) * | 2021-02-26 | 2022-07-08 | 山东英信计算机技术有限公司 | Method and device for checking server MAC address repetition |
| CN112950236A (en) * | 2021-03-31 | 2021-06-11 | 四川虹美智能科技有限公司 | Serial number writing method and device and computer readable medium |
| CN112950236B (en) * | 2021-03-31 | 2023-05-23 | 四川虹美智能科技有限公司 | Sequence number writing method, device and computer readable medium |
| CN113204468A (en) * | 2021-05-13 | 2021-08-03 | 山东英信计算机技术有限公司 | Method, system and storage medium for removing duplicate of server diagnosis information |
| CN113836575A (en) * | 2021-08-18 | 2021-12-24 | 青岛中科英泰商用系统股份有限公司 | Equipment information write-in control method and system thereof |
| CN114338611A (en) * | 2021-12-30 | 2022-04-12 | 苏州易德龙科技股份有限公司 | Management and control method for avoiding MAC ID repetition |
| CN114124904A (en) * | 2022-01-25 | 2022-03-01 | 北京智象信息技术有限公司 | Method and system for verifying MAC addresses to be burnt into multiple devices by server |
| CN114124904B (en) * | 2022-01-25 | 2022-05-24 | 北京智象信息技术有限公司 | Method and system for verifying MAC (media Access control) address by server side to be burned into multiple devices |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108073592B (en) | 2022-09-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108073592A (en) | Judge sequence number whether repeat method and television set sequence number wiring method | |
| US10277702B2 (en) | Method and apparatus for accessing an enterprise resource planning system via a mobile device | |
| US10891627B2 (en) | Methods and apparatus for using artificial intelligence entities to provide information to an end user | |
| CN101246486B (en) | Method and apparatus for improved process of expressions | |
| CN108519967A (en) | Chart method for visualizing, device, terminal and storage medium | |
| US20160006673A1 (en) | Resource server providing a rapidly changing resource | |
| KR20190039230A (en) | Method and system for server-side rendering of native content for presentations | |
| US20150193404A1 (en) | Operational transformations proxy for thin clients | |
| US8751689B2 (en) | Serialization and distribution of serialized content using socket-based communication | |
| US11803540B2 (en) | Method and system for defining an adaptive polymorphic data model | |
| CN107636655A (en) | Data are provided in real time to service（DaaS）System and method | |
| CN109086365A (en) | local file sharing method, system, device, electronic equipment and storage medium | |
| CN109543154A (en) | Method for converting types, device, storage medium and the electronic equipment of list data | |
| CN105227386B (en) | For dividing the method, apparatus and system of population statistics online user number | |
| CN117278661B (en) | Industrial Internet of things multi-protocol analysis method and system | |
| US7117252B1 (en) | Data transmission method, computer-readable medium, and data transmission apparatus | |
| CN112689020B (en) | Message transmission method, message middleware, electronic equipment and storage medium | |
| CN107454456B (en) | Management control method and system for floating layer elements | |
| US20140047377A1 (en) | Retrieving data from an external data source | |
| CN107342929A (en) | A kind of sending method of new message notification, apparatus and system | |
| JP6946404B2 (en) | Recommended methods, devices, devices and readable storage media based on cloud search | |
| CN113114557B (en) | Message sending method and device, electronic equipment and storage medium | |
| CN110442698A (en) | Conversation content generation method and system | |
| CN105046561A (en) | Method capable of adapting to various bank transaction message formats | |
| CN109241164A (en) | A kind of data processing method, device, server and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |