CN107609077A - Wlding approaches to IM - Google Patents
Wlding approaches to IM Download PDFInfo
- Publication number
- CN107609077A CN107609077A CN201710785385.0A CN201710785385A CN107609077A CN 107609077 A CN107609077 A CN 107609077A CN 201710785385 A CN201710785385 A CN 201710785385A CN 107609077 A CN107609077 A CN 107609077A
- Authority
- CN
- China
- Prior art keywords
- wlding
- granting
- text box
- recovery
- record
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Abstract
The invention belongs to the technical field of electronic information technology, is related to a kind of management method, and in particular to and wlding approaches to IM, wlding approaches to IM are applied to correlation data base management system, including：Wlding fundamentals of management information bank is created, wlding fundamentals of management information bank includes multiple data message tables；Create wlding granting recovery record information list template and wlding granting recovery record information typing forms；Record information typing forms are reclaimed according to multiple data message tables and wlding granting and reclaim input data information in record information list template to wlding granting, record information list is reclaimed in the wlding granting that the wlding granting recovery record information list for recording the papery version for there are data is converted to electronic edition.The present invention carries out the digital management of wlding granting recovery record using computer software, improves the efficiency that welding engineer examines welding list.
Description
Technical field
This area is related to a kind of wlding approaches to IM, belongs to the technical field of electronic information technology, specifically belongs to
In electronic information technology using computer software to wlding record, particularly nuclear-electric welding material granting recovery record carry out procedure,
The technical field of the method for electronic management.
Background technology
In general, nuclear-electric welding material includes two major classes：Core level wlding and non-core level wlding.Furtherly this two major classes wlding
Include core level welding wire, core level welding rod, non-core level welding wire, non-core level welding rod, non-core level flux-cored wire etc. again in the nuclear power construction phase,
Moreover, again different for the wlding batch number of each wlding manufacturer, in a word, the species that is related to by wlding is more, quantity
Also more, caused wlding granting recovery record is quite huge.
Welding engineer to welding list when auditing, it is necessary to check on welding list the welder filled in, wlding granting
Whether time, stove lot number information are consistent with the information on wlding granting recovery record；Carried out to welder's work efficiency and wlding consumption
, it is necessary to use the welder among wlding granting recovery record, batch number, discharging quantity, recovery quantity during statistic analysis
Etc. information.However, wlding granting recovery record is as the part in completion of works data, it is necessary to using the form of paper document
Recorded, and collect and bind into book form, therefore, welding engineer is more than carrying out, it is necessary to collect the wlding bound into book form during work
Provide and leafed through repeatedly on recovery record paper document, consult relevant information, in this manner, can not only have a strong impact on welding
Engineer audits welding list and carries out the efficiency of relevant information statistical work, and the cleaning of file can be impacted.
The content of the invention
The present invention is based on above mentioned problem, it is proposed that a kind of new wlding approaches to IM, the wlding information management
Method is applied to correlation data base management system, including：
Wlding fundamentals of management information bank is created, wlding fundamentals of management information bank includes multiple data message tables；
Create wlding granting recovery record information list template and wlding granting recovery record information typing forms；
Record information typing forms are reclaimed according to multiple data message tables and wlding granting and reclaim record letter to wlding granting
Input data information in table template is ceased, the wlding granting recovery record information list for recording the papery version for there are data is converted into electricity
The wlding granting recovery record information list of sub- version.
Further, in the above-mentioned technical solutions, multiple data message tables comprise at least：Welder's information table, drying person's letter
Cease table, wlding procurement information table, wlding and provide zone information table, wlding measurement unit information table；And wlding granting recovery note
Record Data Enter forms include the first child form and the second child form, the first child form and wlding granting recovery record information list mould
Plate associates, and the second child form associates with multiple data message tables.
Further, in any of the above-described technology, the second child form includes record information typing region；And according to multiple
Data message table and wlding granting reclaim record information typing forms and input number into wlding granting recovery record information list template
It is believed that the step of breath, specifically includes：
Data with reference to described in the papery wlding granting recovery multiple data message tables of record information table reference are believed to record
Cease the corresponding wlding granting recovery record information of typing region typing；
The corresponding wlding granting included in the first forms of corresponding wlding granting recovery record information of typing is reclaimed
In record information list template, to generate the wlding granting of electronic edition recovery record information list.
Further, in any of the above-described technology, the second child form includes：Record editorial management region, record editor's pipe
Manage the multiple edit controls in region；And wlding approaches to IM also includes：It is corresponding according to any control in multiple edit controls
The edit instruction received performs addition, the editting function preserve, replicate, deleting, refreshing, searching, turning over item, closing forms.
Further, in any of the above-described technology, at least record has data below information in wlding procurement information table：Batch
Number, manufacturer, title, specification, the trade mark, core grade, type, length, packing specification, radical, single weight.
Further, in any of the above-described technology, reclaimed and remembered according to the wlding granting of wlding procurement information table and electronic edition
Record information table and perform pre-set commands generation wlding granting recovery record comprehensive inquiry table,
Wherein, pre-set commands include：SELECT [record information list is reclaimed in wlding granting] .*, wlding procurement information table boards
Number, wlding procurement information table specifications, wlding procurement information table core grades, wlding procurement information table types, wlding procurement information
[wlding is sent out by table [single weight] and FROM [record information list is reclaimed in wlding granting] LEFT JOIN wlding procurement information tables ON
Put back to and receive record information list] batches number=wlding procurement information table batches number.
Further, in any of the above-described technical scheme, wlding approaches to IM also includes：Reclaimed according to wlding granting
Record comprehensive inquiry table and create welder's work efficiency form；And/or
Record comprehensive inquiry table is reclaimed according to wlding granting and creates wlding consumption form.
Further, in any of the above-described technical scheme, record comprehensive inquiry table is reclaimed according to wlding granting and creates welder
The step of work efficiency form, includes：
Header group is established at the page header of Report Form Design view, header group includes receiving people's header group, type header
Group, batch header group；
Addition, which is corresponded to, in the case where receiving people's header group receives people's text box, the corresponding addition type text box under type header group
And corresponding addition batch text box, trade mark text box, specification text box and core grade text box under batch header group；
In the body region addition sequence number text box of Report Form Design view, date textbox, discharging quantity text box, recovery
Quantity text box, unit of text frame, single weight text box, and typing has designator in control source：=[discharging quantity]-
Typing has designator in the text box of [recovery quantity] and control source：=([discharging quantity]-[recovery quantity])/[single heavy
Amount] text box；
Each welder's wlding is correspondingly added on the right side for receiving people's header group, type header group and batch header group respectively to disappear
Consumption collects text box, all types of wlding consumptions collect text box and each batch wlding consumption collects text box, and
Designator is inputted respectively in the control source of each text box：=Sum (([discharging quantity]-[recovery quantity])/[single weight]).
Further, in any of the above-described technical scheme, record comprehensive inquiry table is reclaimed according to wlding granting and creates wlding
The step of consuming form includes：
Establish header group at the page header of Report Form Design view, header group include trade mark header group, specification header group,
Core grade header group, batch header group；
The corresponding addition trade mark text box under trade mark header group, the corresponding addition specification text box under specification header group,
Corresponding addition core grade text box and the corresponding addition batch text box under batch header group under core grade header group；
In the body region addition sequence number text box of Report Form Design view, date textbox, discharging quantity text box, recovery
Quantity text box, unit of text frame, single weight text box, typing has designator in type text box, and control source：=
Typing has designator in the text box of [discharging quantity]-[recovery quantity] and control source：=([discharging quantity]-[recovery number
Amount])/text box of [single weight]；
Respectively in the corresponding addition in the right side of trade mark header group, specification header group, core grade header group and batch header group
Each trade mark wlding consumption collects text box, each trade mark specification grade wlding consumption collects text box and each batch wlding disappears
Consumption collects text box, and inputs designator respectively in the control source of each text box：=Sum (([discharging quantity]-[recovery
Quantity])/[single weight]).
Further, in any of the above-described technical scheme, correlation data base management system is Microsoft Office
Access management systems, correlation data base management system are Microsoft Office Access management systems.
It is using the advantages of technical solution of the present invention：
The procedure to wlding record, electronic management are realized using computer software, makes examination ＆ verification welding either simplex work and phase
Pass statistical work is more convenient, efficient, while realizes the systematized management to wlding record, can not only so improve wlding neck
With information retrieval, efficiency is examined, and a kind of side of more convenient and efficient is provided for statistical works such as welder's work efficiency, wlding consumption
Method, favourable basis is established for growing continuously and fast for follow-up related industry.
Brief description of the drawings
Fig. 1 is the flow chart of the wlding approaches to IM of the embodiment of the present invention；
Fig. 2 is welder's information table schematic diagram of the embodiment of the present invention；
Fig. 3 is that drying person's information table of the embodiment of the present invention represents to be intended to；
Fig. 4 is that the wlding procurement information of the embodiment of the present invention represents to be intended to；
Fig. 5 is that the wlding of the embodiment of the present invention provides zone information table schematic diagram；
Fig. 6 is the wlding measurement unit information table schematic diagram of the embodiment of the present invention；
Fig. 7 is that record information typing forms schematic diagram is reclaimed in the wlding granting of the embodiment of the present invention；
Fig. 8 is that the wlding granting recovery record comprehensive inquiry of the embodiment of the present invention represents to be intended to；
Fig. 9 is welder's work efficiency form schematic diagram of the embodiment of the present invention；
Figure 10 is that the wlding of the embodiment of the present invention consumes form schematic diagram.
Embodiment
The content of the invention for mainly including three aspects：(1) stream of wlding granting recovery record is realized by computer software
Cheng Hua, electronic management；(2) the efficient statistics to welder's work efficiency, wlding consumption is realized.
The method of technical solution of the present invention is described in detail as follows below in conjunction with the accompanying drawings.
As shown in figure 1, wlding approaches to IM according to embodiments of the present invention, applied to correlation data base administration system
System, specifically includes following steps：
Step 102, wlding fundamentals of management information bank is created, wlding fundamentals of management information bank includes multiple data message tables.
How much data message tables in the step 102 comprise at least：Welder's information table, drying person's information table, wlding buying
Information table, wlding are provided zone information table, wlding measurement unit information table, and pre-saved in the plurality of data message table
Relevant information, wherein described information can be with real-time update, to ensure the real-time of data message and accuracy.
Further, welder's information table is as shown in Fig. 2 welder's information table in the embodiment is qualification welder's master list
Table, its establishment process are：Be first turned on the Design view of this table, sequentially input under field name welder's code name, welder's name,
Affiliated function's information, wherein data type select text, and this table then is switched into spreadsheet views and typing relevant information.
As shown in figure 3, drying person's information table in the embodiment is drying person's master list table, it is created drying person's information table
Process is：The Design view of this table is first turned on, drying person's name, affiliated function's information are sequentially input under field name, its
Middle data type selects text, and this table then is switched into spreadsheet views and typing relevant information.
Wlding procurement information table is as shown in figure 4, the establishment process of the wlding procurement information table in the embodiment is：Beat first
The Design view of this table is opened, batch number, manufacturer, title, specification, the trade mark, core grade, class are sequentially input under field name
Type, length, packing specification, radical, single weight (such as root/KG), current range, drying temperature and the temporal information recommended,
Wherein for data type in addition to single weight selection numeral, other information selects text, and this form then is switched into data
Table view and typing relevant information.
Wlding provides zone information table as shown in figure 5, the wlding in the embodiment provides the establishment process of zone information table
For：The Design view of this table is first turned on, the input granting area information under field name, wherein data type selection text,
Then this form is switched into spreadsheet views and typing relevant information.
Wlding measurement unit information table is as shown in fig. 6, the establishment process of the wlding measurement unit information table in the embodiment
For：The Design view of this table is first turned on, wlding unit information is inputted under field name：Root, disk, wherein data type select
Text, this form is then switched into spreadsheet views and preserved.
So, by creating multiple data message tables, be able to can be directly selected in follow-up wlding information management procedure
The information such as corresponding drying person, welder and batch number, save the work repeatedly input, save time and cost of labor, realize one
Secondary typing, nonexpondable effect.
Step 104, wlding granting recovery record information list template and wlding granting recovery record information typing forms are created.
Wherein, create its wlding granting recovery record information list template process be：It is first turned on wlding granting recovery note
The Design view of information table template is recorded, sequence number, date are sequentially input under field name, welding list numbering, batch number, is received
People, discharging quantity, Time Of Release, recovery quantity, recovery time, unit, granting people, heat-preserving container numbering, granting region, welding list
Quantity, unit information；Wherein for data type：Sequence number selects automatic numbering, date, Time Of Release, recovery time selection day
Phase/time, welding list numbering, batch number, people, unit are received, people, heat-preserving container numbering is provided, provides region, unit selection text
This, discharging quantity, recovery quantity, welding odd number amount selection numeral；Then this form is switched into spreadsheet views and preserved.
Further, the wlding granting recovery record information typing forms created in the embodiment include the first child form
It is specific as shown in fig. 7, respectively as shown in Fig. 7 top half and the latter half with the second child form, wherein the first child form and
Wlding granting recovery record information list template association, the second child form associate with multiple data message tables.
Further, selection " record information list is reclaimed in wlding granting " in " the record source " of the attribute list of the forms, protects
Demonstrate,proving the information of the typing in this forms can automatically generate in " record information list is reclaimed in wlding granting ".
Further during the first child form is established, in " source object " of the attribute list of first child form, choosing
" record information list is reclaimed in the granting of table wldings " is selected, at the same time, is checked " link master fields " and " link subfield " of attribute list
It is central whether to contain content, blank should be kept, by the foundation of first child form, can after typing information work is completed,
The information of institute's typing can be checked in time.
Text box is created in first child form, completes " date, welding list numbering, to provide number in text box guide
The setting of 8 text boxes such as amount, recovery quantity, heat-preserving container numbering, Time Of Release, recovery time, welding odd number amount ", in text
Corresponding title is selected respectively in control source in the attribute list of frame.
Combo box is created in first child form, batch number is completed in combo box guide, people is received, provides people, hair
The setting of the combo boxes such as region, unit is put, selects corresponding title respectively in the control source of attribute list after setting, such as
Shown in Fig. 7 top half.
Further, the second child form includes record information typing region and record editorial management region.
Step 106, record information typing forms are reclaimed according to multiple data message tables and wlding granting to return to wlding granting
Input data information in record information list template is received, record information list is reclaimed into the wlding granting for recording the papery version for there are data
Be converted to the wlding granting recovery record information list of electronic edition.
Further, the step can be performed specifically as following steps：
(1) data with reference to described in the papery wlding granting recovery multiple data message tables of record information table reference are to record
The corresponding wlding granting recovery record information of Data Enter region typing.
Wherein papery wlding granting recovery record information list is the circulation note that welder and drying person receive wlding needed for
Record, in practical operation, fill in time relevant information to the granting of papery wlding reclaim record sheet among, and when giving back wlding and
When supplement wlding recovery information, the granting of papery wlding recovery record sheet in includes the date, wlding model, batch number, production
Manufacturer, diameter, quantity, Time Of Release, welding list numbering, core grade, heat-preserving container numbering, receive people, provide people, recovery quantity,
Recovery time etc., it is consistent to reclaim information described in record information list template with wlding granting.
(2) the corresponding wlding granting included in the first forms of corresponding wlding granting recovery record information of typing is returned
Receive in record information list template, to generate the wlding granting of electronic edition recovery record information list.
Further, the second child form of wlding granting recovery record information typing forms also includes record in the embodiment
Editorial management region, the multiple edit controls in editorial management region are recorded, any control can be according to corresponding in multiple edit controls
The edit instruction received performs addition, the editting function preserve, replicate, deleting, refreshing, searching, turning over item, closing forms.
It is understood that after the first child form has been created, button is created in the second child form, in button guide
Complete addition record, deletion record, keeping records, refresh forms data, Section 1 record, previous item record, the next item down record,
Last record, the setting for closing the buttons such as window, as shown in Fig. 7 the latter half.
After the completion of this forms creates, toward second child form in one wlding granting of typing recovery record, computer software
Automatically this information can be flowed into above-mentioned first child form in the wlding granting recovery record sheet template shown, so completed one by one
The typing of wlding granting recovery record, you can be converted to the wlding granting recovery record information list for recording the papery version for having data
The wlding granting recovery record information list of electronic edition..
Further, in the above-described embodiments, wlding approaches to IM also includes：According to wlding procurement information table and electricity
The wlding granting recovery record information list of sub- version performs pre-set commands generation wlding granting recovery record comprehensive inquiry table.
Further, in the above-described embodiments, pre-set commands include：[record information is reclaimed in wlding granting to SELECT
Table] .*, the wlding procurement information table trades mark, wlding procurement information table specifications, wlding procurement information table core grades, wlding buying
Information table types, wlding procurement information table [single weight] and FROM [record information list is reclaimed in wlding granting] LEFT
JOIN wlding procurement information tables ON [record information list is reclaimed in wlding granting] batches number=wlding procurement information table batches number.
Specifically, the process of establishment wlding granting recovery record comprehensive inquiry table is：The SQL view of this inquiry table is opened,
Input mentioned order simultaneously preserves, further in record comprehensive inquiry table is reclaimed in wlding granting, as shown in figure 8, input is default
After order operation, software can collect the information that wlding granting is reclaimed among record information list and wlding procurement information table, make
It can not only show all information among wlding granting recovery record information list, can also show that wlding procurement information table is worked as
In corresponding wlding specifying information.
Further, in the above-described embodiments, wlding approaches to IM is also comprehensive including being recorded according to wlding granting recovery
Close inquiry table and create welder's work efficiency form and/or wlding consumption form.
Fig. 9 and Figure 10 is combined separately below consumes the operation of form to creating welder's work efficiency form and/or wlding respectively
Journey illustrates.
Embodiment one：Record comprehensive inquiry table is reclaimed according to wlding granting and creates welder's work efficiency form
Selection " wlding granting recovery record comprehensive inquiry table ", ensures herein in " the record source " of the attribute list of the form
Data source in form is " wlding granting recovery record comprehensive inquiry table ".
As shown in figure 9, establishing header group at the page header of the Design view of the form, header group includes receiving people's page
Eyebrow group, type header group, batch header group.
Addition, which is corresponded to, in the case where receiving people's header group receives people's text box, the corresponding addition type text box under type header group
And corresponding addition batch text box, trade mark text box, specification text box and core grade text box under batch header group.
In the body region addition sequence number text box of Report Form Design view, date textbox, discharging quantity text box, recovery
Quantity text box, unit of text frame, single weight text box, and typing has designator in control source：=[discharging quantity]-
Typing has designator in the text box of [recovery quantity] and control source：=([discharging quantity]-[recovery quantity])/[single heavy
Amount] text box.
Each welder's wlding is correspondingly added on the right side for receiving people's header group, type header group and batch header group respectively to disappear
Consumption collects text box, all types of wlding consumptions collect text box and each batch wlding consumption collects text box, and
Designator is inputted respectively in the control source of each text box：=Sum (([discharging quantity]-[recovery quantity])/[single weight]),
Realization collects to welder's effect.
Welding engineer can be counted by welder's work efficiency form to the wlding Expenditure Levels of each welder, the wlding work
Effect form can intuitively embody the work efficiency situation of every welder, be easy to corresponding statistical work.This statistical form being capable of basis
Wlding used in wlding type used in every welder (welding wire, welding rod) and used wlding batch Classifying Sum
Amount, welder's work efficiency is embodied with this.
Embodiment two：Record comprehensive inquiry table is reclaimed according to wlding granting and creates wlding consumption form
Selection " wlding granting recovery record comprehensive inquiry table ", ensures herein in " the record source " of the attribute list of the form
Data source in form is " wlding granting recovery record comprehensive inquiry table ".
As shown in Figure 10, header group is established at the page header of the Design view of the form, header group includes trade mark page
Eyebrow group, specification header group, core grade header group, batch header group.
The corresponding addition trade mark text box under trade mark header group, the corresponding addition specification text box under specification header group,
Corresponding addition core grade text box and the corresponding addition batch text box under batch header group under core grade header group.
In the body region addition sequence number text box of Report Form Design view, date textbox, discharging quantity text box, recovery
Quantity text box, unit of text frame, single weight text box, typing has designator in type text box, and control source：=
Typing has designator in the text box of [discharging quantity]-[recovery quantity] and control source：=([discharging quantity]-[recovery number
Amount])/text box of [single weight].
Respectively in the corresponding addition in the right side of trade mark header group, specification header group, core grade header group and batch header group
Each trade mark wlding consumption collects text box, each trade mark specification grade wlding consumption collects text box and each batch wlding disappears
Consumption collects text box, and inputs designator respectively in the control source of each text box：=Sum (([discharging quantity]-[recovery
Quantity])/[single weight]), realize and wlding consumption is collected.
Welding engineer consumes form by wlding and the Expenditure Levels of all kinds of wldings can be counted, wlding consumption
Form can intuitively embody the Expenditure Levels of every kind of wlding, be easy to corresponding statistical work.This statistical form can be according to every
The wlding amounts used in Classifying Sum such as the trade mark and specification, core grade, batch number of kind wlding, are disappeared with this to embody wlding
Consumption.
This method successfully applied China Nuclear Industry Fifth Construction Co., Ltd. wlding management in, to sum up due to
Wlding management is carried out using computer software, improves the efficiency that welding engineer examines welding list；Wlding management counting method
Use, greatly reduce the time that welding engineer is spent by the work efficiency of every welder of statistics and the consumption of every kind of wlding；
Wlding manages the use of database, preferably can carry out systematic management to wlding service condition.
Claims (10)
1. a kind of wlding approaches to IM, it is characterised in that the wlding approaches to IM is applied to correlation database
Management system, including：
Wlding fundamentals of management information bank is created, the wlding fundamentals of management information bank includes multiple data message tables；
Create wlding granting recovery record information list template and wlding granting recovery record information typing forms；
Record information typing forms are reclaimed according to the multiple data message table and the wlding granting to return to the wlding granting
Input data information in record information list template is received, record information list is reclaimed into the wlding granting for recording the papery version for there are data
Be converted to the wlding granting recovery record information list of electronic edition.
2. wlding approaches to IM according to claim 1, it is characterised in that
The multiple data message table comprises at least：Welder's information table, drying person's information table, wlding procurement information table, wlding hair
Put zone information table, wlding measurement unit information table；And
The wlding granting recovery record information typing forms include the first child form and the second child form, first child form
Associated with wlding granting recovery record information list template, second child form associates with the multiple data message table.
3. wlding approaches to IM according to claim 2, it is characterised in that second child form, which includes record, to be believed
Cease typing region；And
It is described to be sent out according to the multiple data message table and wlding granting recovery record information typing forms to the wlding
The step of receiving input data information in record information list template is put back to specifically include：
Data with reference to described in papery wlding granting recovery the multiple data message table of record information table reference are to institute
State the corresponding wlding granting recovery record information of record information typing region typing；
By the corresponding wlding including in first forms of corresponding wlding granting recovery record information of typing
Provide in recovery record information list template, to generate the wlding granting of electronic edition recovery record information list.
4. wlding approaches to IM according to claim 3, it is characterised in that second child form includes：Record
Editorial management region, the record multiple edit controls in editorial management region；And
The wlding approaches to IM also includes：
Addition is performed according to the edit instruction that any control correspondingly receives in the multiple edit control, preserves, replicate, delete
The editting function remove, refresh, searching, turn over item, closed forms.
5. the wlding approaches to IM according to any one of claim 2 to 4, it is characterised in that the wlding buying
At least record has data below information in information table：Batch number, manufacturer, title, specification, the trade mark, core grade, type, length
Degree, packing specification, radical, single weight.
6. wlding approaches to IM according to claim 5, it is characterised in that also include：
Record information list is reclaimed according to the wlding granting of the wlding procurement information table and the electronic edition and performs pre-set commands life
Record comprehensive inquiry table is reclaimed into wlding granting,
Wherein, the pre-set commands include：SELECT [record information list is reclaimed in wlding granting] .*, wlding procurement information table boards
Number, wlding procurement information table specifications, wlding procurement information table core grades, wlding procurement information table types, wlding procurement information
[wlding is sent out by table [single weight] and FROM [record information list is reclaimed in wlding granting] LEFT JOIN wlding procurement information tables ON
Put back to and receive record information list] batches number=wlding procurement information table batches number.
7. wlding approaches to IM according to claim 6, it is characterised in that also include：
Record comprehensive inquiry table is reclaimed according to the wlding granting and creates welder's work efficiency form；And/or
Record comprehensive inquiry table is reclaimed according to the wlding granting and creates wlding consumption form.
8. wlding approaches to IM according to claim 7, it is characterised in that described to be reclaimed according to the wlding granting
The step of record comprehensive inquiry table creates welder's work efficiency form includes：
Header group is established at the page header of Report Form Design view, the header group includes receiving people's header group, type header
Group, batch header group；
In described receive addition is corresponded under people's header group receive people's text box, the corresponding addition type text under the type header group
This frame and corresponding addition batch text box, trade mark text box, specification text box and core etc. under the batch header group
Level text box；
In the body region addition sequence number text box of the Report Form Design view, date textbox, discharging quantity text box, recovery
Quantity text box, unit of text frame, single weight text box, and typing has designator in control source：=[discharging quantity]-
Typing has designator in the text box of [recovery quantity] and control source：=([discharging quantity]-[recovery quantity])/[single heavy
Amount] text box；
Respectively each weldering is correspondingly added on the right side for receiving people's header group, the type header group and the batch header group
Work wlding consumption collects text box, all types of wlding consumptions collect text box and each batch wlding consumption collects text
Frame, and designator is inputted respectively in the control source of each text box：=Sum (([discharging quantity]-[recovery quantity])/it is [single
Weight]).
9. wlding approaches to IM according to claim 7, it is characterised in that described to be reclaimed according to the wlding granting
Record comprehensive inquiry table, which creates the step of wlding consumes form, to be included：
Establish header group at the page header of Report Form Design view, the header group include trade mark header group, specification header group,
Core grade header group, batch header group；
The corresponding addition trade mark text box under the trade mark header group, the corresponding addition specification text under the specification header group
Frame, corresponding addition core grade text box and the corresponding addition stove under the batch header group under the core grade header group
Lot number text box；
In the body region addition sequence number text box of the Report Form Design view, date textbox, discharging quantity text box, recovery
Quantity text box, unit of text frame, single weight text box, typing has designator in type text box, and control source：=
Typing has designator in the text box of [discharging quantity]-[recovery quantity] and control source：=([discharging quantity]-[recovery number
Amount])/text box of [single weight]；
Respectively in the trade mark header group, the specification header group, the core grade header group and the batch header group
Right side correspondingly adds that each trade mark wlding consumption collects text box, each trade mark specification grade wlding consumption collects text box and each
Batch wlding consumption collects text box, and inputs designator respectively in the control source of each text box：=Sum (([hairs
Put quantity]-[recovery quantity])/[single weight]).
10. wlding approaches to IM according to any one of claim 1 to 4, it is characterised in that the correlation number
It is Microsoft OfficeAccess management systems according to base management system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710785385.0A CN107609077A (en) | 2017-09-04 | 2017-09-04 | Wlding approaches to IM |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710785385.0A CN107609077A (en) | 2017-09-04 | 2017-09-04 | Wlding approaches to IM |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107609077A true CN107609077A (en) | 2018-01-19 |
Family
ID=61057514
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710785385.0A Pending CN107609077A (en) | 2017-09-04 | 2017-09-04 | Wlding approaches to IM |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107609077A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112222690A (en) * | 2020-09-30 | 2021-01-15 | 中石化第四建设有限公司 | Method for establishing pipeline weld joint management information |
| CN113112196A (en) * | 2021-03-24 | 2021-07-13 | 西安理工大学 | Enterprise welding material management system |
| CN113665995A (en) * | 2021-07-21 | 2021-11-19 | 中国核工业第二二建设有限公司 | Remote management method and system for welding rod heat-preserving barrel |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101499162A (en) * | 2009-03-05 | 2009-08-05 | 唐文超 | Medical research data management system and method |
| CN103425975A (en) * | 2013-07-17 | 2013-12-04 | 中国中医科学院 | System and method for acquiring clinical case data |
-
2017
- 2017-09-04 CN CN201710785385.0A patent/CN107609077A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101499162A (en) * | 2009-03-05 | 2009-08-05 | 唐文超 | Medical research data management system and method |
| CN103425975A (en) * | 2013-07-17 | 2013-12-04 | 中国中医科学院 | System and method for acquiring clinical case data |
Non-Patent Citations (2)
| Title |
|---|
| CCILEARNINGSOLUTIONSINC: "《Microsoft Office Access 2007专业级认证教程》", 28 February 2011, 中国铁道出版社 * |
| 张强，杨玉明: "《Access 2010中文版入门与实例教程》", 31 March 2011, 电子工业出版社 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112222690A (en) * | 2020-09-30 | 2021-01-15 | 中石化第四建设有限公司 | Method for establishing pipeline weld joint management information |
| CN112222690B (en) * | 2020-09-30 | 2022-08-30 | 中石化第四建设有限公司 | Method for establishing pipeline weld joint management information |
| CN113112196A (en) * | 2021-03-24 | 2021-07-13 | 西安理工大学 | Enterprise welding material management system |
| CN113665995A (en) * | 2021-07-21 | 2021-11-19 | 中国核工业第二二建设有限公司 | Remote management method and system for welding rod heat-preserving barrel |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105447122B (en) | A kind of implementation method that archives economy can be independently created based on multilist association | |
| CN107609077A (en) | Wlding approaches to IM | |
| CN102496083B (en) | Credit rating report manuscript manufacturing method | |
| CN102411540B (en) | Automatic management system of workflow-based common software testing process | |
| CN103177308A (en) | Intelligent decision-making support system for project management | |
| CN105718436A (en) | New type table data management method | |
| CN106408435A (en) | Process compiling system and process compiling method | |
| CN104298705A (en) | Converting method of relational data and unstructured data | |
| CN110032373B (en) | Object-oriented table function universal implementation method | |
| CN104268194A (en) | Method for dynamically generating public opinion brief report | |
| CN103473305A (en) | Method and system for performing decision-making process show in statistic analysis | |
| CN108170721A (en) | A kind of report form generation method for privately-offered fund | |
| CN104899688A (en) | Unified asset management and planning method for center and distribution substations | |
| CN107704199A (en) | A kind of logical partition method and device of solid state hard disc | |
| CN102194156A (en) | Method and system for sci-tech novelty retrieval | |
| Joyfong et al. | Preparation of Smart Card Data for Food Purchase Analysis of Students through Process Mining | |
| CN106682153A (en) | Data extraction tool on basis of data modeling and data increment implementation | |
| CN109711799A (en) | Guide the teaching software and its operation method of the standardization office of administration hilllock | |
| CN105243490B (en) | A kind of statistical system and method based on git software | |
| Shen et al. | Research on application of computer technology in the optimization of department information system | |
| CN103345485A (en) | Method and system for automatic generation of mainframe platform dynamic reports | |
| Yaxiong et al. | A research on BPM system based on process knowledge | |
| CN108563799A (en) | A kind of method of dynamic generation public sentiment bulletin | |
| CN101334863A (en) | Integrated session environment scheme generation system and method based on elemental analysis | |
| CN110309987A (en) | The Optimization Work method of magnanimity document piecemeal distribution editor's collaboration processing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180119 |
|
| RJ01 | Rejection of invention patent application after publication |