Based on the city rail vehicle wiring method of EPLAN platform
Technical field
The present invention relates to a kind of city rail vehicle wiring method based on EPLAN platform, belong to city rail vehicle manufacturing technology field.
Background technology
The electric wiring of city rail vehicle is a very lengthy and jumbled job, current way is generally by electric for the distribution data importing of electrical schematic diagram Autocad EPLAN, set up basic distribution database, local distribution form is generated by the form automatic generation function of EPLAN software, then by manually checking contrast, find out item by item each several part wire size, link position, equipment wiring point inconsistent, and profiling error reason, finally confirms amendment.Roughly divide following step:
(1) electrical principle of permutation car is always schemed, resolve into the electrical principle Local map of different piece;
(2) the distribution data of each Local map are manually inputted EPLAN software, set up corresponding total figure principles database and each Local map distribution database;
(3) utilize the wirelist check.frm template of EPLAN software, according to each distribution data-base content, automatically generate each corresponding " XXX.csv " wire size listing file;
(4) each " XXX.csv " wire size listing file is transferred the list of to excel form wire size;
(5) arrange each Excel form wire size list, will check that outlier is deleted with wire size, looking into of execution VisualBasic editing machine establishment weighs statement, deletes repeated rows;
(6) sort by " wire size " and " location designation ", obtain train and the wire size list of each local;
(7) by the wire size list of each local and train wire size list comparative analysis, the Correctness checking of distribution is carried out.
There is following problem in the said method step of prior art:
(1) accuracy rate is low.Easy appearance lacks line and multi-thread mistake, wire two ends tie point mistake, terminal block docking point mistake, thus technical papers mistake can be caused, and then cause vehicle production process to lack line and equipment wiring error, even cause equipment burnout and cannot ledger line, increase artificial waste and spillage of material.
(2) artificial complex operation of checking is complicated, wastes time and energy, inefficiency.Because permutation car needs the distribution quantity of information of input to have more than ten ten thousand, need do a large amount of data checks and check, artificial input checks contrast for a long time, easily produces visual fatigue, can produce a large amount of error messages and the multi-thread situation of scarce line.Especially perform the operation of Visual Basic language, often cannot be able to run because of faulty operation.
(3) car load distribution be divided on car, under car, the local distribution of the different piece such as switch board, control stand, relate to different department and manufacturer, its input operation specification is different, causes the final information disunity generated, further increases difficulty and the workload of check work.
Summary of the invention
Object of the present invention overcomes the deficiency of above-mentioned prior art exactly, provides a kind of city rail vehicle wiring method based on EPLAN platform.
The object of the present invention is achieved like this: a kind of city rail vehicle wiring method based on EPLAN platform, is characterized in that taking the following step:
(1) electrical principle of permutation car is always schemed, resolve into the electrical principle Local map of different piece;
(2) the distribution data of each Local map are manually inputted EPLAN software, set up corresponding total figure principles database and each Local map distribution database;
(3) utilize the wirelist check.frm template of EPLAN software, according to each distribution data-base content, automatically generate each corresponding " XXX.csv " wire size listing file;
(4) each " XXX.csv " wire size listing file is transferred the list of to excel form wire size;
(5) each Excel form wire size list is looked into heavily delete;
(6) the excel form wire size list of permutation car is sorted by wire size and location designation, draw permutation fare sorted lists;
(7) dissimilar single-unit vehicle wire size list is merged in wire size list arrangement in each local;
(8) set up importing template and derive template, by importing template, variant type single-unit vehicle wire size list is imported sequencer program module, wire size suffix is removed by sequencer program module, derives by deriving template each single-unit vehicle wire size sorted lists sorted by wire size and location designation;
(9) check variant type single-unit vehicle wire size sorted lists, this step is divided into A, B two:
A. permutation fare sorted lists and variant type single-unit vehicle wire size sorted lists are imported in distribution nucleus correcting program module, program automatically completes and checks, and derives the wire size problem list not being inconsistent content in variant type single-unit vehicle wire size sorted lists with permutation fare sorted lists;
B. the terminal table of each switch board and variant type single-unit vehicle wire size sorted lists are imported in terminal block nucleus correcting program module, program automatically completes and checks, and derives the terminal problem list not being inconsistent content with terminal table;
(10) revise dissimilar single-unit vehicle wire size sorted lists according to respective wire size problem list, terminal problem list, draw dissimilar single-unit vehicle wire harness file;
(11) distribution of each vehicle is carried out by dissimilar single-unit vehicle wire harness file.
In order to realize object of the present invention better, described step (5) is performed such:
(5.1) by each line ordering in the list of Excel form wire size;
(5.2) I=0 is made;
(5.3) I=I+1 is made;
(5.4) judge whether the capable data of I are empty: be enter step (5.8), otherwise enter next step;
(5.5) judge that whether the capable data of I+1 are empty: be then step (5.8); Otherwise enter next step;
(5.6) judge that whether the capable data capable with I+1 of I are identical: be enter next step; Otherwise return step (5.3);
(5.7) delete I+1 capable, then return step (5.6);
(5.8) look into and heavily delete end.
In order to realize object of the present invention better, described steps A is performed such:
A1 imports permutation fare sorted lists and variant type single-unit vehicle wire size sorted lists;
A2 reads permutation fare sorted lists data one by one;
A3 judges whether institute's read data is empty: be enter steps A 7; Otherwise enter next step;
A4 judges whether institute's read data is included in single-unit vehicle wire size sorted lists distribution data: be enter next step, otherwise enter steps A 6;
A5 judges that whether wiring point data are identical: be, returns steps A 2; Otherwise enter next step;
Misdata is recorded to document by A6, returns steps A 2;
A7 derives distribution problem list.
In order to realize object of the present invention better, described step B is performed such:
B1 imports the terminal table of each switch board and variant type single-unit vehicle wire size sorted lists;
B2 reads the terminal block data of terminal table one by one;
B3 judges whether institute's read data is empty: be enter step B7; Otherwise enter next step;
B4 judges whether comprise identical data in wire size sorted lists distribution data: be enter next step, otherwise enter step B6;
B5 judges whether comprise identical data in wire size sorted lists distribution data has two at least: be return step B2; Otherwise enter next step;
Misdata is recorded to document by B6, returns step B2;
B7 leading-out terminal problem list.
Technical scheme of the present invention, has many-sided beneficial effect: improve designer's work efficiency, saved for 80% time; Improve the accuracy of distribution file, decrease wrong distribution, reduce the economic loss of material and artificial aspect; Decrease the workload of technologist, improve the production efficiency of workman, accelerate the manufacturing schedule of vehicle; Decrease the device damage because wrong distribution causes, decrease the loss of the aspect such as economy, time; Standard is unified, and first bus is consistent with other vehicle wire harness, is conducive to the maintenance inspection in the later stage of vehicle, improves the security of vehicle, reduces maintenance cost; Save the time of test, decrease the workload of commissioning staff.
Accompanying drawing explanation
Fig. 1 is the city rail vehicle wiring method FB(flow block) based on EPLAN platform of the embodiment of the present invention.
Fig. 2 looks into the FB(flow block) of heavily deleting subroutine in Fig. 1.
Fig. 3 is the FB(flow block) of the distribution check subroutine in Fig. 1.
Fig. 4 is the FB(flow block) of the terminal block check subroutine in Fig. 1.
Embodiment
For making the object of the embodiment of the present invention, technical scheme and advantage clearly, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Referring to accompanying drawing 1, the city rail vehicle wiring method based on EPLAN platform of the present embodiment is from frame 0, always scheme at the electrical principle of frame 1 by permutation car, resolve into the electrical principle Local map of different piece. enter frame 2, the distribution data of each Local map are manually inputted EPLAN software, sets up corresponding total figure principles database and each Local map distribution database.Enter frame 3, utilize the wirelist check.frm template of EPLAN software, according to each distribution data-base content, automatically generate each corresponding " XXX.csv " wire size listing file.Enter frame 4, transfer each " XXX.csv " wire size listing file the list of to excel form wire size.Enter frame 5, each Excel form wire size list is looked into and heavily deletes.Enter frame 6, the excel form wire size list of permutation car is sorted by wire size and location designation, draws permutation fare sorted lists.Enter frame 7, the wire size list of each local is arranged and merges into dissimilar single-unit vehicle wire size list.Enter frame 8, set up and import template and derive template, by importing template, variant type single-unit vehicle wire size list is imported sequencer program module, wire size suffix is removed by sequencer program module, derives by deriving template each single-unit vehicle wire size sorted lists sorted by wire size and location designation.Enter frame 9, check variant type single-unit vehicle wire size sorted lists, this step is divided into A, B two.A this, permutation fare sorted lists and variant type single-unit vehicle wire size sorted lists are imported in distribution nucleus correcting program module, program automatically completes and checks, and derives the wire size problem list not being inconsistent content in variant type single-unit vehicle wire size sorted lists with permutation fare sorted lists; B this, the terminal table of each switch board and variant type single-unit vehicle wire size sorted lists are imported in terminal block nucleus correcting program module, program automatically completes and checks, and derives and is not inconsistent the terminal problem list of content with terminal table.Enter frame 10, revise dissimilar single-unit vehicle wire size sorted lists according to respective wire size problem list, terminal problem list, draw dissimilar single-unit vehicle wire harness table.Enter frame 11 carries out each vehicle distribution by dissimilar single-unit vehicle wire harness file.Enter frame 12, complete whole wiring method flow process.
Look into referring to the list of accompanying drawing 2, Excel form wire size and heavily delete subroutine from frame 5.0.Enter frame 5.1, by each line ordering in the list of Excel form wire size.Enter frame 5.2, make I=0.Enter frame 5.3, make I=I+1.Enter frame 5.4, judge whether the capable data of I are empty: be enter frame 5.8; Otherwise enter frame 5.5.At frame 5.5, judge whether the capable data of I+1 are empty: be enter frame 5.8; Otherwise enter frame 5.6.At frame 5.6, judge that whether the capable data capable with I+1 of I are identical: be, enter frame 5.7; Otherwise return frame 5.3.At frame 5.7, delete I+1 capable, then return frame 5.6.Enter frame 5.8, look into and heavily delete end.
Referring to accompanying drawing 3, distribution checks subroutine from frame A0.Enter frame A1, import permutation fare sorted lists and variant type single-unit vehicle wire size sorted lists.Enter frame A2, read permutation fare sorted lists data one by one.Enter frame A3, judge whether institute's read data is empty: be enter frame A7; Otherwise enter frame A4.At frame A4, judge whether institute's read data is included in single-unit vehicle wire size sorted lists distribution data: be enter frame A5; Otherwise enter frame A6.At frame A5, judge that whether wiring point data are identical: be, return frame A2; Otherwise enter frame A6.At frame A6, misdata is recorded to document, returns frame A2.At frame A7, derive wire size problem list.Enter frame A8, distribution is checked flow process and is terminated.
Referring to accompanying drawing 4, terminal block checks subroutine from frame B0.Enter frame B1, import the terminal table of each switch board and variant type single-unit vehicle wire size sorted lists.Enter frame B2, read the terminal block data of terminal table one by one.Enter frame B3, judge whether institute's read data is empty: be enter frame B7; Otherwise enter frame B4.At frame B4, judge whether comprise identical data in wire size sorted lists distribution data: be enter frame B5; Otherwise enter frame B6.At frame B5, judge whether the identical data comprised in wire size sorted lists distribution data has at least two: be return frame B2; Otherwise enter frame B6.At frame B6, misdata is recorded to document, returns frame B2.At frame B7, leading-out terminal problem list.Enter frame B8, complete terminal block and check flow process.
Last it is noted that above embodiment is only in order to illustrate technical scheme of the present invention, be not intended to limit; Although with reference to previous embodiment to invention has been detailed description, those of ordinary skill in the art is to be understood that: it still can be modified to the technical scheme described in foregoing embodiments, or carries out equivalent replacement to wherein portion of techniques feature; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the spirit and scope of various embodiments of the present invention technical scheme.