CN103616856B - A kind of automobile instrument assembling line method of controlling operation thereof based on database - Google Patents
A kind of automobile instrument assembling line method of controlling operation thereof based on database Download PDFInfo
- Publication number
- CN103616856B CN103616856B CN201310537475.XA CN201310537475A CN103616856B CN 103616856 B CN103616856 B CN 103616856B CN 201310537475 A CN201310537475 A CN 201310537475A CN 103616856 B CN103616856 B CN 103616856B
- Authority
- CN
- China
- Prior art keywords
- station
- information
- typing
- bar code
- fault
- 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
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Abstract
Based on an automobile instrument assembling line method of controlling operation thereof for database, the present invention relates to a kind of method that streamline accurately controls.The present invention will solve prior art existing defects, accurately cannot control the problem of flow line flow path.The present invention carries out according to the following steps: one, design upper computer software interface; Two, setting data storehouse; Three, the information that transmits of host computer process slave computer; Four, inquire about.The present invention accurately can control the flow line flow path of automobile instrument assembling.The operation that can be applicable to automobile instrument assembling line controls.
Description
Technical field
The present invention relates to a kind of method that streamline accurately controls, relate to automobile instrument assembly line control software design development technique field.
Background technology
What automobile was comparatively commonly used generally has 5 kinds of instrument and 3 kinds of corresponding sensors, and wherein instrument comprises reometer, oil manometer, water-thermometer, fuel gauge and speedometer; Sensor comprises engine oil pressure pickup, cooling-water temperature sensor and fuel-quantity transducer.
Automobile instrument assembling line comprises n station, for each station, only has appointed people could operate this station.In process of production, need the material by these station needs of scanning barcode typing, and material is divided into full inspection material to examine material with first.Full inspection material refers to the material that at every turn all will detect in process of production, namely all wants scanning barcode and input database at every turn; As long as first inspection material refers to the material producing input database when starting, no longer need after typing is complete to repeat typing at every turn.Full inspection material more than one at each station, so each station will arrange scanning sequency to full inspection material.If station only has an inspection material entirely, this material is set to No. 0 material.Likely can there is association between full inspection material, because can may entirely be examined material covering by another kind by certain bar code in assembling process, cannot scan, the full inspection material that can scan can be utilized to obtain the material be capped by association.
Due in automobile instrument assembly line, need in strict accordance with determining that flow process is assembled, so need the correctness of strict guarantee flow process, and rely on merely manual control, because assembling quantity is too much, some process may be omitted, the defective of automobile instrument can be caused.Chinese patent literature CN102736565A is the immediate prior art of the present invention.
Also there are problems in other similar software, such as other software just have recorded the bar code of scanning, do not realize the control of operating process; There is no troubleshooting function, can not record trouble reason and failure-description; There is no user operation real time record Presentation Function; Data message cannot be realized and generate Excel file according to condition statistics; Cannot dynamic corrections qualification rate; Do not support the reclamation work having completed product; First inspection material cannot be distinguished and entirely examine material; Associating of each station manipulation person and product cannot be realized; Association material (namely can be found the bar code of another kind of material by the bar code of a material) etc. can not be realized.
Summary of the invention
The object of the invention is, in order to solve prior art existing defects, accurately to control the problem of flow line flow path, a kind of automobile instrument assembling line method of controlling operation thereof based on database is provided.
A kind of automobile instrument assembling line method of controlling operation thereof based on database of the present invention, realizes according to following steps:
Step 1: design upper computer software interface: comprise log-in interface and production interface, production interface comprises inquiry, statistics, troubleshooting, setting and failure message and reports five functions, and shows production quantity, qualified quantity and qualification rate in real time;
Step 2: setting data storehouse: table is set based on Database subscriber's meter, material table, station terminal material, station terminal personnel arrange table, worksheet, production history record sheet, fault history table and real time fail description list eight table;
Step 3: the information that host computer process slave computer transmits, its detailed process is:
A1: information is passed to host computer by slave computer, by address, host computer judges whether information is bar code information, is jump into step B1, otherwise jump into steps A 2;
A2: judge whether information is IO information, is jump into step B3, otherwise thinks garbage;
B1: carry out information processing to user's bar code, judges whether information is operator's bar code information, is jump into step C1, otherwise jumps into step B2;
B2: judge whether information is bar code information, is jump into step C2, otherwise thinks garbage, do not deal with;
B3: judge whether information is that station completes information, is jump into step C3, otherwise is failure message, this work station product of worksheet is set to malfunction, and typing failure logging table;
C1: judge whether user name has permission in this station terminal, if had, then jumps into step D1; If no, then send personnel's lack of competence information to slave computer;
C2: judge operator's whether typing, if typing, then jump into step D2, if non-typing, then send the information lacking operator to slave computer, bar code information does not deal with;
C3: whether typing is complete and correct for inquiry this station flow process of worksheet and material, if met standard, then typing production history record sheet, and by the erasing of information about this product in worksheet, if the standard of not met, then point out work station product can not carry out this operation for completing;
D1: if this station typing operator, then these personnel are covered original personnel, if there is no typing operator, then direct data inserting storehouse personal information;
D2: bar code information is converted to feature bar code information, judges whether material exists, if exist, jumps into step e 1, if do not exist, is left intact and terminates;
E1: inquiry station terminal material arranges table, judges whether this station exists this material, is, jumps into step F 1, if do not exist, to slave computer transmit operation error message;
F1: continue to judge whether the detecting pattern of material on station is entirely examine material, is jump into step G1, otherwise think that first inspection material is stored in worksheet;
G1: judge whether station lacks first inspection material, does not lack, jumps into H1, lack, sends prompting and lacks first inspection material information;
H1: judge this material whether fault on this station by worksheet, if non-fault, jump into step I1, if fault, send and there is failure message;
I1: before judging this material, whether station completes, if complete, jumps into step J1, if prior fault or do not complete, then send information;
J1: judge the completion status of this material on this station, if do not complete, jumps into step K 1, if complete, then original record is updated to unfinished state, proceeds normal flow operation;
K1: judge whether the detection ordering of this material mates with work at present typing state, if coupling, then continues typing, if do not mate, sends the incorrect prompting of typing order to slave computer;
Step 4: user is by all production informations of interface queries single product, according to condition add up record of production and failure logging, the product being fault by troubleshooting is fixed a breakdown, and by failure-description and failure cause typing fault history table, each station manipulation error message of real-time query.
The present invention comprises following beneficial effect:
1, the operating process based on database pipeline controls, and more accurately facilitates;
2, production quantity, quantity performed and qualification rate can be shown in real time by MFC interface, shortcut correction qualification rate can also be used simultaneously;
3, real time record inquire about the operating mistake situation of each station, the reason of the clearer understanding misoperation of convenient operation person, greatly improves work efficiency;
4, according to condition statistics produces all materials of product and operator message and failure message, and can generate Excel file, is convenient to print data;
5, the design of database table makes the insertion of data and searches more succinct, coordinates the operating process of data, can improve database data operating efficiency;
6, rational Software Architecture Design, programming system resource occupation is little, and maintainable good, function is scalable.
Accompanying drawing explanation
Fig. 1 is workflow schematic diagram;
Fig. 2 is message processing flow figure, wherein A1 judges that information is no as bar code information, A2 judges whether information is IO information, B1 judges whether information is operator's bar code information, B2 judges whether information is material information, B3 judges whether information is that station completes information, B31 is failure message, C1 is for judge whether user name has permission in station terminal, C11 is lack of competence information, whether C2 for judge operator's typing, C21 is not for deal with, whether typing is complete and correct in order to inquire about for C3, C31 is typing production history record sheet, C32 can not carry out this operation for completing, D1 is typing operator, D2 is for judge whether material exists, E1 is for judge whether this station exists this material, E11 is transmit operation error message, F1 judges whether the detecting pattern of material on station is entirely examine material, material is examined stored in worksheet headed by F11, G1 is for judging whether station lacks first inspection material, G11 sends prompting and lacks first inspection material information, H1 is for judging this material whether fault on this station, H11 is that transmission exists failure message, I1 is for judging whether this material completes at station before, I11 is for sending information, J1 judges the completion status of this material on this station, J11 does not complete for being updated to by original record, K1 judges whether the detection ordering of this material mates with work at present typing state, K11 sends the incorrect prompting of typing order to slave computer, K12 is for continuing typing,
Fig. 3 is log-in interface;
Fig. 4 is working interface;
Fig. 5 is query interface;
Fig. 6 is statistics interface;
Fig. 7 is for arranging personnel, material and terminal interface;
Fig. 8 is for arranging station material information interface;
Fig. 9 is troubleshooting interface;
Figure 10 is operating process error reporting interface.
Embodiment
Technical solution of the present invention is not limited to following cited embodiment, also comprises the combination in any between each embodiment.
Embodiment one: a kind of automobile instrument assembling line method of controlling operation thereof based on database of present embodiment, realizes according to following steps:
Step 1: design upper computer software interface: comprise log-in interface and production interface, production interface comprises inquiry, statistics, troubleshooting, setting and failure message and reports five functions, and shows production quantity, qualified quantity and qualification rate in real time;
Step 2: setting data storehouse: table is set based on Database subscriber's meter, material table, station terminal material, station terminal personnel arrange table, worksheet, production history record sheet, fault history table and real time fail description list eight table;
Step 3: the information that host computer process slave computer transmits, its detailed process is:
A1: information is passed to host computer by slave computer, by address, host computer judges whether information is bar code information, is jump into step B1, otherwise jump into steps A 2;
A2: judge whether information is IO information, is jump into step B3, otherwise thinks garbage;
B1: carry out information processing to user's bar code, judges whether information is operator's bar code information, is jump into step C1, otherwise jumps into step B2;
B2: judge whether information is bar code information, is jump into step C2, otherwise thinks garbage, do not deal with;
B3: judge whether information is that station completes information, is jump into step C3, otherwise is failure message, this work station product of worksheet is set to malfunction, and typing failure logging table;
C1: judge whether user name has permission in this station terminal, if had, then jumps into step D1; If no, then send personnel's lack of competence information to slave computer;
C2: judge operator's whether typing, if typing, then jump into step D2, if non-typing, then send the information lacking operator to slave computer, bar code information does not deal with;
C3: whether typing is complete and correct for inquiry this station flow process of worksheet and material, if met standard, then typing production history record sheet, and by the erasing of information about this product in worksheet, if the standard of not met, then point out work station product can not carry out this operation for completing;
D1: if this station typing operator, then these personnel are covered original personnel, if there is no typing operator, then direct data inserting storehouse personal information;
D2: bar code information is converted to feature bar code information, judges whether material exists, if exist, jumps into step e 1, if do not exist, is left intact and terminates;
E1: inquiry station terminal material arranges table, judges whether this station exists this material, is, jumps into step F 1, if do not exist, to slave computer transmit operation error message;
F1: continue to judge whether the detecting pattern of material on station is entirely examine material, is jump into step G1, otherwise think that first inspection material is stored in worksheet;
G1: judge whether station lacks first inspection material, does not lack, jumps into H1, lack, sends prompting and lacks first inspection material information;
H1: judge this material whether fault on this station by worksheet, if non-fault, jump into step I1, if fault, send and there is failure message;
I1: before judging this material, whether station completes, if complete, jumps into step J1, if prior fault or do not complete, then send information;
J1: judge the completion status of this material on this station, if do not complete, jumps into step K 1, if complete, then original record is updated to unfinished state, proceeds normal flow operation;
K1: judge whether the detection ordering of this material mates with work at present typing state, if coupling, then continues typing, if do not mate, sends the incorrect prompting of typing order to slave computer;
Step 4: user is by all production informations of interface queries single product, according to condition add up record of production and failure logging, the product being fault by troubleshooting is fixed a breakdown, and by failure-description and failure cause typing fault history table, each station manipulation error message of real-time query.
Embodiment two: present embodiment and embodiment one are the tables of data recording the user name of all registrations, user cipher, user's bar code and user right unlike: the subscriber's meter described in step 2.Other is identical with embodiment one.
Embodiment three: present embodiment and embodiment one or two unlike: the material table described in step 2 is record the name of material of all registrations and the tables of data of bar code.Other is identical with embodiment one or two.
Embodiment four: one of present embodiment and embodiment one to three arrange table for record station sequence number and station title unlike: the station terminal material described in step 2 and record station terminal material configuration information and comprise the detecting pattern of required material and the tables of data of detection ordering information.Other is identical with one of embodiment one to three.
Embodiment five: one of present embodiment and embodiment one to four arrange the tables of data of personnel's title that table has permission for record station unlike: station terminal personnel described in step 2.Other is identical with one of embodiment one to four.
Embodiment six: one of present embodiment and embodiment one to five are each station manipulation person in writing task process unlike: the worksheet described in step 2, first inspection material, entirely examine material, typing progress and complete the tables of data of situation.Other is identical with one of embodiment one to five.
Embodiment seven: one of present embodiment and embodiment one to six are recorded the product bar code of product, printed board bar code, start the tables of data of production time, deadline, all operations person, all full inspection materials, all head inspection materials and the number of stoppages unlike: the production history record sheet described in step 2.Other is identical with one of embodiment one to six.
Embodiment eight: one of present embodiment and embodiment one to seven are the tables of data of record trouble product bug station sequence number, faulty item bar code, failure stations operator, fault-time, failure-description, failure cause and failure stations No. 0 inspection material entirely unlike: the fault history table described in step 2.Other is identical with one of embodiment one to seven.
Embodiment nine: one of present embodiment and embodiment one to eight unlike: the real time fail description list described in step 2 be the record operating mistake time, station, operating mistake describe, the tables of data of bar code.Other is identical with one of embodiment one to eight.
Beneficial effect of the present invention is verified by following examples:
Embodiment one: a kind of automobile instrument assembling line method of controlling operation thereof based on database, realizes according to following steps:
One, upper computer software interface is designed: comprise log-in interface (as shown in Figure 3) and production interface (as shown in Figure 4), production interface comprises inquiry, statistics, troubleshooting, setting and failure message and reports five functions, and shows production quantity, qualified quantity and qualification rate in real time.Query function refers to and can comprise all information such as operating personnel, material used, failure message by product bar code or the whole product of printed board barcode inquiry, and wherein query interface as shown in Figure 5; Statistical function is referred to and comprises production history record statistics, fault history and can be inquired about by restrictive condition, and wherein statistical circles face as shown in Figure 6.Troubleshooting function refers to and recalls faulty item by scanning printed board bar code or product bar code, and described and failure cause by interface input fault, and remove fault, in failure stations typing, wherein troubleshooting interface is as shown in Figure 9 again; Arranging function refers to by interface setting operation person, material registration, station registration, can setting operation person authority setting operation person, only have operator to be set to administrator right just can arrange, common employee can only carry out basic operation, when arranging station, be provided with the operator of authority, full inspection material and order, first inspection material, must note when arranging, adjacent stations will have common material, personnel, material and terminal interface are wherein set as shown in Figure 7, station material information interface is set as shown in Figure 8; Failure message function of reporting is each station of real time record nearest ten operating process error loggings, so that inquiry, wherein operating process error reporting interface as shown in Figure 10.
Two, setting data storehouse.Based on Database subscriber's meter, material table, station terminal material arranges table, station terminal personnel arrange table, worksheet, production history record sheet, fault history table, real time fail description list eight table.
Subscriber's meter: the tables of data recording the user name of all registrations, user cipher, user's bar code and user right;
Material table: record the name of material of all registrations and the tables of data of bar code;
Station terminal material arranges table: record station sequence number and station title, and record station terminal material configuration information and comprise the detecting pattern of required material and the tables of data of detection ordering information, the row that detecting pattern is set to "-1 " is the record of station sequence number and station title, and detecting pattern is " 0 " or " 1 " is the information record of record material in station manipulation flow process;
Station terminal personnel arrange table: personnel's title that record station has permission;
Worksheet: each station manipulation person in writing task process, first inspection material, entirely examine material, typing progress and complete situation;
Production history record sheet: recorded the product bar code of product, printed board bar code, beginning production time, deadline, all operations person, all full inspection materials, all head inspection materials and the number of stoppages;
Fault history table: record trouble product bug station sequence number, faulty item bar code, failure stations operator, fault-time, failure-description, failure cause and failure stations No. 0 entirely examine material;
Real time fail description list: record operating mistake time, station, operating mistake description, bar code.
Three, slave computer Information Monitoring, passes to host computer and processes, and wherein workflow schematic diagram as shown in Figure 1, and message processing flow figure as shown in Figure 2.
1, the useful information of slave computer collection is divided into two kinds, and one is IO information, and one is bar code information.Obtain station sequence number by message address, after slave computer passes to host computer information, by address, host computer judges which kind of information is information be.If bar code information, then further by accessing database, it is that bar code and subscriber's meter and material table are carried out matching judgment for which kind of bar code; IO information comprises two kinds of information: station completes and station fault.By judging above information to be divided into four kinds of situations: user's bar code information, bar code information, IO station state information and useless information.
2, to the process of user's bar code information, by user's barcode inquiry database user table, find the user's name of mating with user's bar code, then table is set with user name inquiry station terminal personnel, judges whether these personnel have permission in this station terminal.If had permission, then these personnel and corresponding station are deposited in database work table, stored in being have two kinds of situations, one is this station typing operator, then these personnel are covered original personnel, two is the non-typing operators of this station, then direct data inserting storehouse personal information.If lack of competence, then send personnel's lack of competence information to slave computer.
3, to bar code information processing:
(1) whether judge operator's typing, if non-typing, then send the information lacking operator to slave computer, bar code information does not deal with; If typing, then process bar code information.
(2) bar code information is converted to feature bar code information, then inquires about material table, judge whether material exists, if do not exist, be left intact and terminate.If exist, then continue.
(3) inquire about station terminal material and table is set, judge whether this station exists this material, if do not exist, to slave computer transmit operation error message, if exist, continue to judge the detecting pattern of material on station.If first inspection material is stored in worksheet, if full inspection material then judges whether station lacks first inspection material, if lack, send prompting and lack first inspection material information, if do not lack first inspection material, judge that this material is in this station whether fault, if fault, sends and there is failure message by worksheet.If non-fault, then continue judge this material before station whether complete, if prior fault do not complete, transmission information.If complete, then judge the completion status of this material on this station, if complete, then original record is updated to unfinished state, proceed normal flow operation.If do not complete, judge whether the detection ordering of this material mates with work at present table typing state, if do not mate, send the incorrect prompting of typing order to slave computer, if coupling, continue typing.
4, IO information is processed:
(1) if IO information is for completing information, then whether typing is complete and correct for inquiry this station flow process of worksheet and material, if the standard of not met, then points out work station product can not carry out this operation for completing.If met standard, typing production history record sheet, and by the erasing of information about this product in worksheet.
(2) if failure message, then this work station product of worksheet is set to malfunction, and typing failure logging table.
Four, user is by all production informations of interface queries single product, according to condition add up record of production and failure logging, the product being fault by troubleshooting is fixed a breakdown, and by failure-description and failure cause typing fault history table, each station manipulation error message of real-time query.
The invention solves following problem:
1, how to realize processing multiple information simultaneously.First create a query messages thread, the object of this thread determines whether the information of receiving, if the information of receiving, dynamic creation thread, after information processing completes, thread is withered away automatically.The present invention is exactly by dynamic creation thread, often receive an information, the thread that then dynamic creation one is new, in order to avoid multithreading simultaneously accessing database be database corruption, be then add interlocking to ensure once to only have a thread accesses database at accessing database.
2, how to judge which kind of information is the information that slave computer transmits be.First different information has different special addresses, so judge it is which kind of information according to the coupling of address feature, then calls the process that corresponding process function completes information.
3, composition graphs 2 illustrates how to control material scanning process order.By arranging material state in worksheet and completion status has been come.Stored the sequence max value scanning material by material state, if the detection ordering larger than material state 1 of scanning material, scanning is correct, otherwise incorrect.Completion status stores completion status information, and on station, ongoing product completion status is that station sequence number subtracts 1, if the product completed, completion status is station sequence number, if faulty item then completion status be-64 deduct station sequence number.
4, first inspection material and operator how is stored.By arranging particular row to store in worksheet.Row completion status being set to-17 stores these information.
5, the material that how storing initial worksheet does not have.This storage is realized by dynamic creation row.Similar record of production table and failure logging table are also that dynamic creation arranges to become and stores.
6, composition graphs 5,6 illustrates how to realize interface queries, statistics.The single product information of inquiry is realized by input printed board bar code or product bar code.By the inquiry that setting model realizes production history record sheet and fault history table by database access statement, realize the switchings of two kinds of inquiries by arranging zone bit.Can print data be passed through during statistics simultaneously, inquired about data are loaded in Excel form to realize the printing of historical information.
7, composition graphs 9 illustrates how to realize troubleshooting.First faulty item information is found out by printed board bar code or product bar code, typing failure-description and failure cause on troubleshooting interface also select " PASS " to preserve, now by button, the completion status of corresponding for the worksheet in database station corresponding failure product is revised as this station sequence number, now owing to likely not scanning and this station unclassified stores of typing, so need this product to rescan at corresponding station after troubleshooting record and complete.
8, illustrate what how station error reporting realized in conjunction with Figure 10.Station error reporting is if mistake in information processing, by information stored in real time fail description list, and station, bar code, wrong time is recorded typing in the lump.Each station only retains ten effective informations, if more than ten, only retains nearest ten error messages.Utilize the identical station record that a new information will cover the earliest.
9, how to realize personnel's setting, material is arranged, station is arranged and operating process is arranged.First personnel arrange and comprise personnel's title, password, authority, personnel's bar code, composition graphs 7 illustrates, first authority only has keeper and common employee two kinds selection, the authority of only filling in be keeper then these personnel are keepers, other any input is all considered as common employee, stored in subscriber's meter.Composition graphs 8 illustrates that material is arranged, and material arranges and only arranges name of material and bar code, stored in material table.Composition graphs 9 illustrates that station is arranged, and first arranges station sequence number and station title (require that station must from sequence number 1, station sequence number can not be jumped), and this storage is stored into station terminal material to arrange in table, makes detecting pattern be-1.The personnel's authority being arranged each station by Figure 10 is arranged in table stored in station terminal personnel.Simultaneously when arranging, be then again loaded into new operating process by the worksheet in formatted data base, production history record sheet and fault history table owing to changing operating process.
The present invention is by the information of visit data library storage, and strict control flow check waterline operating process, when operating lack of standardization, not entry information incited somebody to action by software, and point out user to revise operation, this not only ensure that the accuracy that goods batch operates, and greatly enhances qualification rate and efficiency.
Set forth as follows again for the present invention:
1, the present invention can control operation flow process accurately, improves the qualification rate of product, and the number of times of doing over again reduced improves work efficiency, avoids the inaccurate of manual control flow process;
2, the present invention is by interface troubleshooting, ensure that troubleshooting flow process, records the failure message that product existed simultaneously, facilitate user to inquire about;
3, the present invention retains the operating mistake of each station nearest ten times, and retains number of times and can set, and intelligent prompt operation error message, avoids the loaded down with trivial details of human error, decreases the time of inspection, improves work efficiency;
4, present invention achieves the according to condition statistics of production history record and fault history and generate Excel file, being convenient to print;
5, the present invention under working interface state, can use shortcut Ctrl+F8, ejects the correction of modified value setting dialog box realization to qualification rate;
6, the present invention can realize the operation of typing again having completed product, and must carry out according to operating process in rework process, reprocesses record and will cover original production history information;
7, the present invention can distinguish detecting pattern and the detection ordering of material, can ensure the typing of first inspection material once, afterwards in whole production run not in typing;
8, the present invention not only can realize associating between operator with product, and the operator limiting each station must have permission.This ensure that the trackability of producing product;
9, the present invention by one of them of material association realization scanning association material, just can obtain the bar code of its association;
10, the present invention is by establishment thread, and this thread has more condition dynamic creation thread, withers away after processing information, need not distribute Time and place always, substantially increases the utilization factor of internal memory, improves efficiency;
11, the present invention adopts each product to be stored in separate database file, decreases the routine access database time, substantially increases program operational efficiency;
12, invention increases operating personnel's authority of each station of Administrator and the detecting pattern of each station material and detection ordering function, make stream line operation Row control more flexible.
Claims (9)
1., based on an automobile instrument assembling line method of controlling operation thereof for database, it is characterized in that described method realizes according to following steps:
Step 1: design upper computer software interface: comprise log-in interface and production interface, production interface comprises inquiry, statistics, troubleshooting, setting and failure message and reports five functions, and shows production quantity, qualified quantity and qualification rate in real time;
Step 2: setting data storehouse: table is set based on Database subscriber's meter, material table, station terminal material, station terminal personnel arrange table, worksheet, production history record sheet, fault history table and real time fail description list eight table;
Step 3: the information that host computer process slave computer transmits, its detailed process is:
A1: information is passed to host computer by slave computer, by address, host computer judges whether information is bar code information, is jump into step B1, otherwise jump into steps A 2;
A2: judge whether information is IO information, is jump into step B3, otherwise thinks garbage;
B1: carry out information processing to user's bar code, judges whether information is operator's bar code information, is jump into step C1, otherwise jumps into step B2;
B2: judge whether information is bar code information, is jump into step C2, otherwise thinks garbage, do not deal with;
B3: judge whether information is that station completes information, is jump into step C3, otherwise is failure message, this work station product of worksheet is set to malfunction, and typing failure logging table;
C1: judge whether user name has permission in this station terminal, if had, then jumps into step D1; If no, then send personnel's lack of competence information to slave computer;
C2: judge operator's whether typing, if typing, then jump into step D2, if non-typing, then send the information lacking operator to slave computer, bar code information does not deal with;
C3: whether typing is complete and correct for inquiry this station flow process of worksheet and material, if met standard, then typing production history record sheet, and by the erasing of information about this product in worksheet, if the standard of not met, then point out work station product can not carry out this operation for completing;
D1: if this station typing operator, then these personnel are covered original personnel, if there is no typing operator, then direct data inserting storehouse personal information;
D2: bar code information is converted to feature bar code information, judges whether material exists, if exist, jumps into step e 1, if do not exist, is left intact and terminates;
E1: inquiry station terminal material arranges table, judges whether this station exists this material, is, jumps into step F 1, if do not exist, to slave computer transmit operation error message;
F1: continue to judge whether the detecting pattern of material on station is entirely examine material, is jump into step G1, otherwise think that first inspection material is stored in worksheet;
G1: judge whether station lacks first inspection material, does not lack, jumps into H1, lack, sends prompting and lacks first inspection material information;
H1: judge this material whether fault on this station by worksheet, if non-fault, jump into step I1, if fault, send and there is failure message;
I1: before judging this material, whether station completes, if complete, jumps into step J1, if prior fault or do not complete, then send information;
J1: judge the completion status of this material on this station, if do not complete, jumps into step K 1, if complete, then original record is updated to unfinished state, proceeds normal flow operation;
K1: judge whether the detection ordering of this material mates with work at present typing state, if coupling, then continues typing, if do not mate, sends the incorrect prompting of typing order to slave computer;
Step 4: user is by all production informations of interface queries single product, according to condition add up record of production and failure logging, the product being fault by troubleshooting is fixed a breakdown, and by failure-description and failure cause typing fault history table, each station manipulation error message of real-time query;
Described IO information comprises two kinds of information: station completes and station fault.
2., according to a kind of automobile instrument assembling line method of controlling operation thereof based on database described in claim 1, it is characterized in that the subscriber's meter described in step 2 is the tables of data recording the user name of all registrations, user cipher, user's bar code and user right.
3., according to a kind of automobile instrument assembling line method of controlling operation thereof based on database described in claim 2, it is characterized in that the material table described in step 2 is record the name of material of all registrations and the tables of data of bar code.
4., according to a kind of automobile instrument assembling line method of controlling operation thereof based on database described in claim 3, it is characterized in that the station terminal material described in step 2 arranges table for record station sequence number and station title and records station terminal material configuration information and comprise the detecting pattern of required material and the tables of data of detection ordering information.
5., according to a kind of automobile instrument assembling line method of controlling operation thereof based on database described in claim 4, it is characterized in that the station terminal personnel described in step 2 arrange the tables of data of personnel's title that table has permission for record station.
6., according to a kind of automobile instrument assembling line method of controlling operation thereof based on database described in claim 5, it is characterized in that the worksheet described in step 2 is each station manipulation person in writing task process, first inspection material, entirely examine material, typing progress and complete the tables of data of situation.
7., according to a kind of automobile instrument assembling line method of controlling operation thereof based on database described in claim 6, it is characterized in that the production history record sheet described in step 2 is recorded the product bar code of product, printed board bar code, start the tables of data of production time, deadline, all operations person, all full inspection materials, all head inspection materials and the number of stoppages.
8., according to a kind of automobile instrument assembling line method of controlling operation thereof based on database described in claim 7, it is characterized in that the fault history table described in step 2 is the tables of data of record trouble product bug station sequence number, faulty item bar code, failure stations operator, fault-time, failure-description, failure cause and failure stations No. 0 inspection material entirely.
9. according to Claim 8 described in a kind of automobile instrument assembling line method of controlling operation thereof based on database, it is characterized in that the real time fail description list described in step 2 is the record operating mistake time, station, operating mistake describe, the tables of data of bar code.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310537475.XA CN103616856B (en) | 2013-12-11 | 2013-12-11 | A kind of automobile instrument assembling line method of controlling operation thereof based on database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310537475.XA CN103616856B (en) | 2013-12-11 | 2013-12-11 | A kind of automobile instrument assembling line method of controlling operation thereof based on database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103616856A CN103616856A (en) | 2014-03-05 |
| CN103616856B true CN103616856B (en) | 2016-03-09 |
Family
ID=50167560
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310537475.XA Active CN103616856B (en) | 2013-12-11 | 2013-12-11 | A kind of automobile instrument assembling line method of controlling operation thereof based on database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103616856B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106548260A (en) * | 2015-09-16 | 2017-03-29 | 北汽福田汽车股份有限公司 | A kind of method and device of customization vehicle production |
| CN108008701A (en) * | 2016-10-31 | 2018-05-08 | 中车大同电力机车有限公司 | A kind of photosensitive completion real time monitoring subsystem |
| CN107527077B (en) * | 2017-07-21 | 2020-09-01 | 华润微电子（重庆）有限公司 | Semiconductor auxiliary production method and system |
| CN109709917A (en) * | 2018-12-25 | 2019-05-03 | 华南智能机器人创新研究院 | A kind of fault handling method and system of intelligence production line |
| CN111339384A (en) * | 2020-02-28 | 2020-06-26 | 浙江南都鸿芯动力科技有限公司 | Sim card bar code screening and sorting upper computer operating system |
| CN112232720A (en) * | 2020-12-11 | 2021-01-15 | 树根互联技术有限公司 | Process supervision method and device, computer equipment and readable storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0747789B1 (en) * | 1995-06-05 | 2003-04-09 | Canon Kabushiki Kaisha | Automated system for production facility |
| US6973366B2 (en) * | 2002-11-15 | 2005-12-06 | Fuji Photo Film Co., Ltd. | Production process control system |
| CN101046688A (en) * | 2007-04-29 | 2007-10-03 | 南通明兴科技开发有限公司 | Data aquisition, communication, controldevice based on RFID production line |
| CN101498931A (en) * | 2008-12-26 | 2009-08-05 | 北京三博中自科技有限公司 | Communication method for assembly line RFID interface control unit and upper computer |
| CN102736565A (en) * | 2011-04-02 | 2012-10-17 | 成都齐峰科技有限公司 | Communication method of automatic control equipment based on upper and lower computer structures |
| CN102880137A (en) * | 2012-09-24 | 2013-01-16 | 南通明兴科技开发有限公司 | Control method and device for production line processes |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2624156B2 (en) * | 1993-12-24 | 1997-06-25 | 日本電気株式会社 | Information processing equipment for production control |
-
2013
- 2013-12-11 CN CN201310537475.XA patent/CN103616856B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0747789B1 (en) * | 1995-06-05 | 2003-04-09 | Canon Kabushiki Kaisha | Automated system for production facility |
| US6973366B2 (en) * | 2002-11-15 | 2005-12-06 | Fuji Photo Film Co., Ltd. | Production process control system |
| CN101046688A (en) * | 2007-04-29 | 2007-10-03 | 南通明兴科技开发有限公司 | Data aquisition, communication, controldevice based on RFID production line |
| CN101498931A (en) * | 2008-12-26 | 2009-08-05 | 北京三博中自科技有限公司 | Communication method for assembly line RFID interface control unit and upper computer |
| CN102736565A (en) * | 2011-04-02 | 2012-10-17 | 成都齐峰科技有限公司 | Communication method of automatic control equipment based on upper and lower computer structures |
| CN102880137A (en) * | 2012-09-24 | 2013-01-16 | 南通明兴科技开发有限公司 | Control method and device for production line processes |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103616856A (en) | 2014-03-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103616856B (en) | A kind of automobile instrument assembling line method of controlling operation thereof based on database | |
| CN111160804B (en) | Mining equipment management method, device and system based on Internet of things | |
| CN106681930B (en) | Distributed automatic detection method and system for abnormal operation of application | |
| US7917897B2 (en) | Defect resolution methodology and target assessment process with a software system | |
| CN102819758B (en) | System and method for improving read-write success rate of radio frequency identification tags on movement production line | |
| KR102210972B1 (en) | Smart Factory System for Performing High Speed Big Data Analysis | |
| US7487408B2 (en) | Deferring error reporting for a storage device to align with staffing levels at a service center | |
| CN105718371A (en) | Regression test method, device and system | |
| CN104375928A (en) | Abnormal log management method and system | |
| US20120116827A1 (en) | Plant analyzing system | |
| CN105759784A (en) | Fault diagnosis method based on data envelopment analysis | |
| US10515336B2 (en) | Material harmonization disposition system for electronic inventories | |
| US8090994B2 (en) | System, method, and computer readable media for identifying a log file record in a log file | |
| CN113010413A (en) | Automatic interface testing method and device | |
| CN101312543A (en) | Method for recording television abnormality and television thereof | |
| CN113391978B (en) | Inspection method and device for host | |
| CN113032240A (en) | Software test automation management system and method | |
| US20080027976A1 (en) | Process Management System and Computer Readable Recording Medium | |
| CN111090395B (en) | Electronic information intelligent storage system for accounting industry | |
| CN107577802A (en) | A kind of data base management method and device | |
| US20050096957A1 (en) | System and method for manufacturing job rescheduling | |
| US7974386B2 (en) | Methods and systems for testing new network element failure rate | |
| CN114978865A (en) | Intelligent order dispatching method, equipment and medium based on ITSM fault service | |
| US20220036669A1 (en) | Flight management system and method for reporting an intermitted error | |
| CN114676061A (en) | Knowledge graph-based automatic firmware detection method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | 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 | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20190911 Address after: 150001 No. 434, postal street, Nangang District, Heilongjiang, Harbin Co-patentee after: Gao Hui Jun Patentee after: Harbin Institute of Technology Asset Investment Management Co., Ltd. Address before: 150001 Harbin, Nangang, West District, large straight street, No. 92 Patentee before: Harbin Institute of Technology |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20191017 Address after: 315200 No.189, Guangming Road, Zhuangshi street, Zhenhai District, Ningbo City, Zhejiang Province Patentee after: Ningbo Intelligent Equipment Research Institute Co., Ltd. Address before: 150001 No. 434, postal street, Nangang District, Heilongjiang, Harbin Co-patentee before: Gao Hui Jun Patentee before: Harbin Institute of Technology Asset Investment Management Co., Ltd. |