CN103020750A - Process report generation method and device - Google Patents

Process report generation method and device Download PDF

Info

Publication number
CN103020750A
CN103020750A CN2012104696696A CN201210469669A CN103020750A CN 103020750 A CN103020750 A CN 103020750A CN 2012104696696 A CN2012104696696 A CN 2012104696696A CN 201210469669 A CN201210469669 A CN 201210469669A CN 103020750 A CN103020750 A CN 103020750A
Authority
CN
China
Prior art keywords
data
report
procedure
information
parts
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
Application number
CN2012104696696A
Other languages
Chinese (zh)
Inventor
沈银初
桓永兴
张传会
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Caxa Technology Co Ltd
Original Assignee
Caxa Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Caxa Technology Co Ltd filed Critical Caxa Technology Co Ltd
Priority to CN2012104696696A priority Critical patent/CN103020750A/en
Publication of CN103020750A publication Critical patent/CN103020750A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a process report generation method and a process report generation device. The method comprises the following steps of: acquiring instruction parameters used for generating a process report according to user requirements, wherein the instruction parameters comprise part information and process report information; extracting the detailed part data which corresponds to the part information from a first detailed list; extracting process report data which corresponds to the process report information from a second detailed list, wherein the process report data comprises detailed attribute data; querying to obtain an incidence relation between the detailed part data and the detailed attribute data and reading the corresponding part attribute data according to the incidence relation; exporting the part attribute data so as to generate a process report. According to the method, a user can acquire the process report according to actual requirements, the problem that the user requirement of generating the process repot is low in speed and high in cost in the prior art is solved, and the effects of fast responding different user requirements and generating the report are achieved.

Description

Generation method and the device of procedure-report
Technical field
The present invention relates to data processing field, in particular to a kind of generation method and device of procedure-report.
Background technology
At existing PDM, PLM, in the managing softwares such as ERP, technique is as the bridge that connects between design and the production, form plays irreplaceable effect, because industry is different under the enterprise, the mode of production is different, discrete manufacturing type is for example arranged, streamline manufacturing type in enormous quantities etc., so that it is not nearly all identical to the form of the manufacturing crimping and transfer processes of different enterprises design, if realize the form of technological design for the different demand of every enterprise by developer's code of writing a program respectively, can increase a lot of implementation costs like this: at first the enforcement personnel will provide to the developer labor report of each form of a enterprise, the developer to take time read over and and the enforcement personnel repeatedly ditch pass to and reach after the profound understanding user's request, could begin to write code and satisfy these demands, the program that the developer submits to will be used through just offering the user after the long stable testing of enforcement personnel.In addition,, the production organizational mode of enterprise or service logic cause the corresponding adjustment of form needs if changing, the user need to submit change request to the software developer, the developer arranges the developer to revise code to meet consumers' demand again, if check and accept to finish change request was proposed in 3 years afterwards, this is trouble more, at this moment probably no longer be engaged in this work because be responsible for then the personnel of this exploitation, rearrange a developer and do, can cause the response user's request time prolongation and allow the user feel dissatisfied.
As from the foregoing, the developer need to write code for the real needs of each user's form and satisfy its form demand, so not only can cause response user's request speed slow, and increased cost of development, selling cost, cost of serving and source code maintenance cost, in order to address the above problem, the user can use text or XML file to write some simple report definition configurations, implementing the librarian use text editor directly is configured User Part form demand in text or XML file, then the user's request that above-mentioned text or XML file can't be disposed, writing code by the developer realizes, but do like this cost that can only save seldom, general enforcement personnel (also being the user) are difficult to grasp this collocation method, and easily configuration is wrong, even and configuration wrong the enforcement personnel also be difficult for finding.
In addition, the report generation of prior art lacks user friendly, the user interface that allows enforcement personnel or user remove to define form by the mode of interaction design fully can't be provided, and lack opening and extensibility, can't allow enforcement personnel or user do secondary development, it is the realization for a certain concrete application, for example: the form realization technology for product structure is arranged in the PDM product, form realization technology for order or worker's list is arranged in the ERP product, can't accomplish that a form realization technology is applied in a plurality of different applications, can not accomplish that a form realization technology can satisfy the form demand of tens people's small enterprise, can satisfy again the form demand of complexity of tens0000 people's large enterprise, the form of saying nothing of prior art all needs to do any exploitation or secondary development just can be met consumers' demand.
For in the prior art to the problem that demand response speed is slow and cost is high of user's generating process form, effective solution is not yet proposed at present.
Summary of the invention
For demand response the speed slow and cost high problem of correlation technique to user's generating process form, effective solution is not yet proposed at present, for this reason, fundamental purpose of the present invention is to provide a kind of generation method and device of procedure-report, to address the above problem.
To achieve these goals, according to an aspect of the present invention, provide a kind of generation method of procedure-report, the method comprises: the order parameter that is used for the generating process form according to customer requirement retrieval, wherein, order parameter comprises components information and procedure-report information; From the first detail list, extract the parts detailed data corresponding with components information; Extract the procedure-report data corresponding with procedure-report information from the second detail list, wherein, the procedure-report data comprise the attribute specification data; Inquiry obtains the incidence relation of parts detailed data and attribute specification data, and reads corresponding parts attribute data according to incidence relation; Derive the parts attribute data, with the generating process form.
Further, deriving the parts attribute data, after the generating process form, method comprises: whether have Update attribute information in the search procedure-report information; In order parameter, comprise and according to Update attribute information procedure-report is upgraded processing in the situation of Update attribute information, to obtain the procedure-report after the renewal.
Further, Update attribute information comprises: fractionation information, wherein, according to Update attribute information procedure-report is upgraded processing, and comprise with the step of obtaining the procedure-report after the renewal: inquire about the to be split data corresponding with fractionation information; Data Division to be split is the fractionation data, and upgrades procedure-report.
Further, the form attribute information comprises: replacement information, wherein, according to the form attribute information procedure-report is upgraded processing, and comprise with the step of obtaining the procedure-report after the renewal: inquire about the replacement data corresponding with replacement information and be replaced data; To be replaced data modification is replacement data, and upgrades procedure-report.
Further, the form attribute information comprises: pooling information, wherein, according to the form attribute information procedure-report is upgraded processing, and comprise with the step of obtaining the procedure-report after the renewal: inquire about the one or more to be combined data corresponding with pooling information; Merge one or more data to be combined, and upgrade procedure-report.
Further, before being used for the order parameter of generating process form according to customer requirement retrieval, method also comprises: creation database, and database comprises: the first detail list, the second detail list and the first tables of data, wherein, the first detail list comprises: the parts detailed data; The second detail list comprises: the procedure-report data; The first tables of data comprises: the relation on attributes of parts detailed data and procedure-report data and the parts attribute data corresponding with relation on attributes.
To achieve these goals, according to an aspect of the present invention, provide a kind of generating apparatus of procedure-report, this device comprises: acquisition module, be used for being used for according to customer requirement retrieval the order parameter of generating process form, wherein, order parameter comprises components information and procedure-report information; The first extraction module is used for extracting the parts detailed data corresponding with components information from the first detail list; The second extraction module is used for extracting the procedure-report data corresponding with procedure-report information from the second detail list, and wherein, the procedure-report data comprise the attribute specification data; The first processing module is used for the relation on attributes that inquiry obtains parts detailed data and attribute specification data, and reads corresponding parts attribute data according to relation on attributes; The second processing module is used for deriving the parts attribute data, with the generating process form.
Further, device comprises: search module is used for search procedure-report information and whether has Update attribute information; The 3rd processing module is used for comprising at order parameter and according to Update attribute information procedure-report is upgraded processing in the situation of Update attribute information, to obtain the procedure-report after the renewal.
Further, Update attribute information comprises: fractionation information, and wherein, the 3rd processing module comprises: the first enquiry module is used for inquiry the to be split data corresponding with fractionation information; The first sub-processing module is used for Data Division to be split is the fractionation data, and upgrades procedure-report.
Further, the form attribute information comprises: replacement information, and wherein, the 3rd processing module comprises: the second enquiry module is used for the inquiry replacement data corresponding with replacement information and is replaced data; The second sub-processing module, being used for being replaced data modification is replacement data, and upgrades procedure-report.
Further, the form attribute information comprises: pooling information, and wherein, the 3rd processing module comprises: the 3rd inquiry module is used for the inquiry one or more to be combined data corresponding with pooling information; The 3rd sub-processing module is used for merging one or more data to be combined, and upgrades procedure-report.
Further, device also comprises: the manages module everywhere, is used for creation database, and database comprises: the first detail list, the second detail list and the first tables of data, and wherein, the first detail list comprises: the parts detailed data; The second detail list comprises: the procedure-report data; The first tables of data comprises: the relation on attributes of parts detailed data and procedure-report data and the parts attribute data corresponding with relation on attributes.
Generation method and the device of the procedure-report by the application, so that the user can obtain parts managing detailed catalogue and procedure-report data according to the actual requirements, and according to components information and procedure-report data generating process form, solved in the prior art problem that demand response speed is slow and cost is high to user's generating process form, realized the user's request that quick response is different, and generate the effect of different forms, need to not design form for each product coding of each user, thereby so that the generation of procedure-report is quick and cost is low.
Description of drawings
Accompanying drawing described herein is used to provide a further understanding of the present invention, consists of the application's a part, and illustrative examples of the present invention and explanation thereof are used for explaining the present invention, do not consist of improper restriction of the present invention.In the accompanying drawings:
Fig. 1 is the structural representation according to the generating apparatus of the procedure-report of the embodiment of the invention;
Fig. 2 is the process flow diagram according to the generation method of the procedure-report of the embodiment of the invention;
Fig. 3 is the process flow diagram according to the generation method of procedure-report embodiment illustrated in fig. 2;
Fig. 4 is the synoptic diagram according to user preset form column information embodiment illustrated in fig. 3;
Fig. 5 is the synoptic diagram according to the components information of X32 pump embodiment illustrated in fig. 3;
Fig. 6 is the synoptic diagram according to user preset report line pooling information embodiment illustrated in fig. 3;
Fig. 7 is the synoptic diagram according to user preset report line sequencing information embodiment illustrated in fig. 3;
Fig. 8 is the synoptic diagram according to the parts detailed data of pipe assembling embodiment illustrated in fig. 3;
Fig. 9 is the synoptic diagram according to the parts detailed data of motor embodiment illustrated in fig. 3;
Figure 10 is the synoptic diagram according to the parts attribute data of the X32 pump that reads embodiment illustrated in fig. 3;
Figure 11 is the synoptic diagram according to the parts attribute data of the impeller shaft that reads embodiment illustrated in fig. 3 and pinion wheel; And
Figure 12 is the synoptic diagram of the procedure-report data after merging according to row embodiment illustrated in fig. 11.
Embodiment
Need to prove that in the situation of not conflicting, embodiment and the feature among the embodiment among the application can make up mutually.Describe below with reference to the accompanying drawings and in conjunction with the embodiments the present invention in detail.
Fig. 1 is the structural representation according to the generating apparatus of the procedure-report of the embodiment of the invention.As shown in Figure 1, this device comprises: acquisition module 10, be used for according to the order parameter of customer requirement retrieval for the generating process form, and wherein, order parameter comprises components information and procedure-report information; The first extraction module 30 is used for extracting the parts detailed data corresponding with components information from the first detail list; The second extraction module 50 is used for extracting the procedure-report data corresponding with procedure-report information from the second detail list, and wherein, the procedure-report data comprise the attribute specification data; The first processing module 70 is used for the incidence relation that inquiry obtains parts detailed data and attribute specification data, and reads corresponding parts attribute data according to incidence relation; The second processing module 90 is used for deriving the parts attribute data, with the generating process form.
Adopt the generating apparatus of the application's procedure-report, by the corresponding parts detailed data of the components information in the order parameter that the first extraction module extracts from the first detail list with acquisition module gets access to, and the second extraction module extracts the corresponding procedure-report data of procedure-report information in the and instruction parameter from the second detail list, then; The first processing module inquiry obtains attribute specification data in the procedure-report data and the incidence relation of parts detailed data, and read corresponding parts attribute data according to incidence relation, the second last processing module derives the parts attribute data, with the generating process form.The generation method of the procedure-report by the application, so that the user can obtain parts managing detailed catalogue and procedure-report data according to the actual requirements, and according to components information and procedure-report data generating process form, solved in the prior art problem that demand response speed is slow and cost is high to user's generating process form, realized the user's request that quick response is different, and generate the effect of different forms, need to not design form for each product coding of each user, thereby so that the generation of procedure-report is quick and cost is low.
Wherein, order parameter can be that product A wherein is components information for the order parameter of the procedure-report B that generates product A, and procedure-report B is procedure-report information.For example, order parameter is for being used for generating the detailed form in man-hour of automobile oil cylinder, then automobile oil cylinder is components information, man-hour, detailed form was procedure-report information, attribute information then is the property parameters such as part sequence number, part name, figure number or production time per piece in the detailed form in man-hour, usually, in man-hour detailed form, these attribute informations are column information.
In above-described embodiment of the application, device can comprise: search module is used for search procedure-report information and whether has Update attribute information; The 3rd processing module is used for comprising at order parameter and according to Update attribute information procedure-report is upgraded processing in the situation of Update attribute information, to obtain the procedure-report after the renewal.
Particularly, whether has Update attribute information in the search module search procedure-report information, then the 3rd processing module comprises in order parameter and according to Update attribute information procedure-report is upgraded processing in the situation of Update attribute information, to obtain the procedure-report after the renewal.
According to above-described embodiment of the application, Update attribute information can comprise: fractionation information, and wherein, the 3rd processing module comprises: the first enquiry module is used for inquiry the to be split data corresponding with fractionation information; The first sub-processing module is used for Data Division to be split is the fractionation data, and upgrades procedure-report.
In above-described embodiment of the application, the form attribute information can comprise: replacement information, and wherein, the 3rd processing module comprises: the second enquiry module is used for the inquiry replacement data corresponding with replacement information and is replaced data; The second sub-processing module, being used for being replaced data modification is replacement data, and upgrades procedure-report.
Particularly, Update attribute information can comprise fractionation information, in the form that the second processing module 70 obtains, generally be presented as the row coordinate, if certain row has defined fractionation, the inquiry of the first enquiry module needs the data of fractionation, the first sub-processing module will split Query Result according to the fractionation rule in the user-defined fractionation information these row, for example, the user has filled in material " steel pipe Q235A " in the process for machining card, these two row of title material in the material consumption norm summary sheet and material trademark all are that the material in the slave processing technology card fetches data, the fractionation rule of title material definition is as separator with the space, get first data of separator, the fractionation rule of material trademark definition is as separator with the space, get second data of separator, if certain row has defined replacement, the second sub-processing module will be replaced Query Result according to user-defined Substitution Rules these row.
Above-described embodiment according to the application is characterized in that, the form attribute information can also comprise: pooling information, and wherein, the 3rd processing module comprises: the 3rd inquiry module is used for the inquiry one or more to be combined data corresponding with pooling information; The 3rd sub-processing module is used for merging one or more data to be combined, and upgrades procedure-report.
Particularly, the 3rd inquiry module is determined the capable information that merges and/or be listed as merging (whether the established technology report data comprises pooling information) of Query Result according to the definition information (established technology report data) of form, then the 3rd sub-processing module is processed: the row merging refers to differentiate by the value of the key column of user's appointment, two row are merged into delegation if the value of two row key columns is identical, and the value of non-key row can be defined as and remain unchanged or numerical value addition or quantity addition or character addition.
In above-described embodiment of the application, device also comprises: the manages module everywhere, is used for creation database, and database comprises: the first detail list, the second detail list and the first tables of data, and wherein, the first detail list comprises: the parts detailed data; The second detail list comprises: the procedure-report data; The first tables of data comprises: the relation on attributes of parts detailed data and procedure-report data and the parts attribute data corresponding with relation on attributes.
Fig. 2 is the process flow diagram according to the generation method of the procedure-report of the embodiment of the invention.Fig. 3 is the process flow diagram according to the generation method of procedure-report embodiment illustrated in fig. 2.Fig. 4 is the synoptic diagram according to user preset form column information embodiment illustrated in fig. 3.
The method comprises the steps: as shown in Figures 2 and 3
Step S102, according to the order parameter of customer requirement retrieval for the generating process form, wherein, order parameter comprises components information and procedure-report information.
Particularly, can realize by execution in step S212: obtain components information and procedure-report information that the user is used for the generating process form.Wherein, components information can be certain part product, also can be certain parts.
Step S104 extracts the parts detailed data corresponding with components information from the first detail list.
Step S106 extracts the procedure-report data corresponding with procedure-report information from the second detail list, wherein, the procedure-report data comprise the attribute specification data.
Step S108, inquiry obtains the incidence relation of parts detailed data and attribute specification data, and reads corresponding parts attribute data according to incidence relation.
Step S110 derives the parts attribute data, with the generating process form.
Adopt the generation method of the application's procedure-report, the order parameter that is used for the generating process form according to customer requirement retrieval, then from the first detail list and the second detail list, extract respectively the parts detailed data corresponding with components information and the procedure-report data corresponding with procedure-report information, afterwards, inquiry obtains the incidence relation of parts detailed data and attribute specification data, and read corresponding parts attribute data according to incidence relation, and derive the parts attribute data, with the generating process form.The generation method of the procedure-report by the application, so that the user can obtain parts managing detailed catalogue and procedure-report data according to the actual requirements, and according to components information and procedure-report data generating process form, solved in the prior art problem that demand response speed is slow and cost is high to user's generating process form, realized the user's request that quick response is different, and generate the effect of different forms, need to not design form for each product coding of each user, thereby so that the generation of procedure-report is quick and cost is low.
Wherein, order parameter can be that product A wherein is components information for the order parameter of the procedure-report B that generates product A, and procedure-report B is procedure-report information.For example, order parameter is for being used for generating the detailed form in man-hour of automobile oil cylinder, then automobile oil cylinder is components information, man-hour, detailed form was procedure-report information, attribute information then is the property parameters such as part sequence number, part name, figure number or production time per piece in the detailed form in man-hour, usually, in man-hour detailed form, these attribute informations are column information.
Before being used for the order parameter of generating process form according to customer requirement retrieval, method can also comprise: creation database, database comprises: the first detail list, the second detail list and the first tables of data, and wherein, the first detail list comprises: the parts detailed data; The second detail list comprises: the procedure-report data; The first tables of data comprises: the relation on attributes of parts detailed data and procedure-report data and the parts attribute data corresponding with relation on attributes.
Particularly, as shown in Figure 3, can realize to step S210 by execution in step S202:
Step S202 reads technical papers.
Particularly, can read the process data of putting down in writing on all process charts in user's the technology document and the process chart.
Step S204 preserves the process data in the technical papers.Concrete, the process data in the technical papers that reads is saved in text or the xml file.
Step S206 preserves process chart title and card cell name, with the generated data table.Particularly, system reads process chart and process data thereof from text or xml file, title according to process chart creates corresponding table in database, and in table corresponding to process chart, create corresponding field according to the cell name of process chart, then execution in step S208: process data is imported in the tables of data, and this step also comprises tables of data is kept in the database.
Step S210 is according to the default procedure-report information of user's request.Particularly, the design data that produces in the design process can be saved in the above-mentioned database, and can use the default user's of Report Customization Tool procedure-report information, the information of each procedure-report of the user preset that gets access to is saved in the corresponding table of database or in the XML file.Finish the establishment of database by above-mentioned steps, then form gathers engine according to the actual output report of user's request, the developer just need to not do exploitation and save a large amount of cost of development for each enterprise like this, enforcement personnel or user can oneself define form and shorten a large amount of enforcement time, and the form change also only needs solve by user again default report messages.
After the establishment of finishing database, to preserve in the database for the required information of generating report forms, these information can be kept at a tables of data, also can be kept in a plurality of tables of data, as: the first detail list, preserve components information; The second detail list is preserved procedure-report information; The first tables of data is preserved the relation on attributes of components information and procedure-report information.
Particularly, step S104 shown in Figure 2 can realize by step S214 and step S216:
Step S214 carries out BOM to the components information in the user's request and launches to obtain the parts managing detailed catalogue.
Particularly, it is the bill of materials that system at first carries out BOM(according to the product of customer requirement retrieval user selection or parts) launch, the data that will participate in gathering to obtain which parts, more specifically, in the BOM expansion process, system adds up automatically to the assembling quantity of identical parts, and according to the substance of the sub-parts of parts and the substance of assembling quantity calculating unit, then according to the sequence number of parts and the synthetic sequence number that can express the assembling level of sequence number of father's parts, for example: 1.2.6, the connector between the sequence number of the sequence number of sub-parts and father's parts can be defined by user oneself
Step S216 preserves the parts managing detailed catalogue.
Particularly, with the result that execution in step S214 obtains, also be that the parts managing detailed catalogue is preserved.
Step S106 among the embodiment shown in Figure 2 can realize to step S222 by step S218 shown in Figure 3:
Step S218: obtain the procedure-report data in the user's request.
Particularly, be deposited into (being internal memory) in the specific data structure according to the procedure-report information presupposed information that (file herein or table can be the second detail lists in above-described embodiment) reads selected form in the corresponding table or in the XML file from database.
Execution in step S220 is according to procedure-report data and parts detailed data generated query statement.
Particularly, determine to extract data in which field of which table that this form will be from database according to the presupposed information of form (being user's definition information), then these procedure-report data and parts detailed data are connected, the getattr relation, and according to user-defined filtercondition and the synthetic complete SQL query statement of ordering rule.
Step S222: use query statement in database, to obtain Query Result, and the result is preserved.Particularly, from database, obtain the parts attribute data according to the query statement that comprises relation on attributes, the parts attribute data is saved in the specific data structure as Query Result.Wherein, above-mentioned steps can gather engine and finishes by the form of system.
In above-described embodiment of the application, deriving the parts attribute data, after the generating process form, the method can comprise: whether have Update attribute information in the search procedure-report information; In order parameter, comprise and according to Update attribute information procedure-report is upgraded processing in the situation of Update attribute information, to obtain the procedure-report after the renewal.
Particularly, Update attribute information can comprise: fractionation information, wherein, according to Update attribute information procedure-report is upgraded processing, and comprise with the step of obtaining the procedure-report after the renewal: inquire about the to be split data corresponding with fractionation information; Data Division described to be split is the fractionation data, and upgrades procedure-report.
Particularly, the form attribute information can also comprise: replacement information, wherein, according to the form attribute information procedure-report is upgraded processing, comprise with the step of obtaining the procedure-report after the renewal: inquire about the replacement data corresponding with replacement information and be replaced data; To be replaced data modification is replacement data, and upgrades procedure-report.
In addition, the form attribute information can also comprise: pooling information, wherein, according to the form attribute information procedure-report is upgraded processing, and comprise with the step of obtaining the procedure-report after the renewal: inquire about the one or more to be combined data corresponding with pooling information; Merge one or more data to be combined, and upgrade procedure-report.
More specifically, above-mentioned steps can realize to step S226 by step S224:
Step S224 splits or replaces processing to the row Query Result of form, and obtains the procedure-report after the renewal.
Particularly, can gather engine by form and check whether each row of form have defined fractionation and/or replaced (that is to say no fractionation information and/or the replacement information of comprising), if certain row has defined fractionation, engine will split Query Result according to the fractionation rule in the user-defined fractionation information these row, for example, the user has filled in material " steel pipe Q235A " in the process for machining card, these two row of title material in the material consumption norm summary sheet and material trademark all are that the material in the slave processing technology card fetches data, the fractionation rule of title material definition is as separator with the space, get first data of separator, the fractionation rule of material trademark definition is as separator with the space, get second data of separator, if certain row has defined replacement, engine will be replaced Query Result according to user-defined Substitution Rules these row.
Step S226, the result merges processing to report query, and obtains the procedure-report after the renewal.
Particularly, engine determines whether to merge (whether the established technology report data comprises pooling information) to the capable merging of Query Result and/or row according to the definition information (established technology report data) of form, the row merging refers to differentiate by the value of the key column of user's appointment, two row are merged into delegation if the value of two row key columns is identical, the value of non-key row can be defined as and remain unchanged or numerical value addition or quantity addition or character addition, for example, the task time detail list, as shown in Figure 4, the user can be defined as the merging key column with part drawing number and operation title, numerical value addition when being defined as the row merging man-hour, so just can accomplish that same processes is automatically cumulative man-hour, the frock summary sheet can be defined as the merging key column with frock code name and frock title, quantity addition when making the use number be defined as the row merging, so just can accomplish that identical frock quantity is automatically cumulative, the material consumption norm summary sheet can be defined as the merging key column with material trademark and title material and material specification, numerical value addition when net and gross weight and technique are defined as the row merging by norm, so just can accomplish the material that material trademark is identical with title material and material specification, net and gross weight and technique quota are automatically cumulative, the process route detail list can be defined as the merging key column with part drawing number and part name, character addition when the operation title is defined as the row merging, so just can accomplish the operation title synthesis route string with parts, for example: rough turn → car → as to mill → finish-milling → mill → thermal treatment, the connector of user between can self-defined route point.Row merge the numerical value that refers to a plurality of row and merge in the row.
After execution in step S226, all right execution in step S228 of the method and step S230, particularly,
Step S228, the output procedure-report.
Particularly, will at first output in the XML file through the Query Result that above-mentioned steps is processed.
Step S230, the user reads procedure-report.
Wherein, if select output Excel during user's consolidated statement, form gathers engine according to user-defined output setting, such as the content line number, reference position, the row step-length, the settings such as outgoing position of every row output number of times and the every row of form output to the report data that is kept in the XML file in the Excel template file of user's appointment.The output format of some form homepage and continuous page or leaf is different in enterprise, and engine supports that not only the output format of form homepage and continuous page definition is different, and supports that the output format of the continuous page or leaf of form and continuous page definition is different.
After a product complete design and technics institution, the user need to obtain following form: parts list, self-made components detail list, standard component detail list, outsourcing piece detail list, task time detail list, task time summary sheet, frock detail list, frock summary sheet, material consumption norm detail list, material consumption norm summary sheet, process route detail list, equipment nomenclature, technical papers catalogue; The user need to use these forms to put in the follow-up production, for example: the procurement staff needs standard component detail list, outsourcing piece detail list, material consumption norm detail list and material consumption norm summary sheet, the personnel that are responsible for the tool of production need frock detail list and frock summary sheet, so that go storehouse get for the production of cutter, anchor clamps, measurer and accessory, the personnel of establishment Workshop Production production plan need task time detail list, task time summary sheet, process route detail list, equipment nomenclature, and production scheduling personnel need process route detail list, equipment nomenclature etc.
Yet, because the scale type of enterprise is different, employed report form type, quantity are not identical yet, small enterprise may only have 3 to 5 forms, and large enterprise may just need more than 100 form, and above-described embodiment of use the application generates these forms and will make quick response for user's different demands, and the efficient of generating report forms is high, for example for the generation of the task time detail list of X32 pump, the task time that user's request generates, detailed tableau format can be as shown in table 1:
Table 1:
Part name Part drawing number The operation title Man-hour During the chief engineer
Fig. 5 is the synoptic diagram according to the components information of X32 pump embodiment illustrated in fig. 3; Fig. 6 is the synoptic diagram according to user preset report line pooling information embodiment illustrated in fig. 3; Fig. 7 is the synoptic diagram according to user preset report line sequencing information embodiment illustrated in fig. 3; Fig. 8 is the synoptic diagram according to the parts detailed data of pipe assembling embodiment illustrated in fig. 3; Fig. 9 is the synoptic diagram according to the parts detailed data of motor embodiment illustrated in fig. 3; Figure 10 is the synoptic diagram according to the parts attribute data of the X32 pump that reads embodiment illustrated in fig. 3; Figure 11 is the synoptic diagram according to the parts attribute data of the impeller shaft that reads embodiment illustrated in fig. 3 and pinion wheel; And Figure 12 is the synoptic diagram of the procedure-report data after merging according to row embodiment illustrated in fig. 11.
Wherein, the X32 pump can be assembled by 10 parts, as shown in Figure 5, these ten parts can be respectively: X series impeller, X series impeller cavity, gear cap, cylinder body, pipe assembling, motor, motor support flange, impeller nut, impeller shaft and pinion wheel.
Execution in step S102 is specifically according to the order parameter of customer requirement retrieval for generation task time detail list.
Execution in step S104 obtains the parts detailed data particularly from the first detail list.Wherein, the parts detailed data comprises: X series impeller, X series impeller cavity, gear cap, cylinder body, pipe assembling, motor, motor support flange, impeller nut, impeller shaft and pinion wheel, and the usage quantity of the motor of the corresponding X32 pump of these parts, the managing detailed catalogues such as model.
Execution in step S106 obtains the detailed data in the procedure-report data particularly from the second detail list.Wherein, the attribute specification data comprise: when part name, part drawing number, operation title, man-hour and chief engineer.
Step S108 inquires about particularly the incidence relation that obtains between parts detailed data and the attribute specification data, and reads parts attribute data corresponding to described incidence relation from database.
Particularly, the part name row of above-mentioned form can be from the part name field reading out data of parts table, the part drawing number row can fetch data from the part drawing number field of parts table, operation title row can fetch data from the operation name field of machine work order table, man-hour, row can fetch data from production time per piece and the standard field in whole man-hour of machine work order table, and with production time per piece and accurate whole addition in man-hour, row can fetch data from production time per piece and the standard field in whole man-hour of machine work order table during the chief engineer, and production time per piece and accurate whole addition in man-hour be multiply by again the total quantity of parts.
Execution in step S110 derives the parts attribute data particularly with the generating process form.
After the generating process form, whether has Update attribute information in the search procedure-report information, for example: merging, replacement and fractionation information.
Particularly, if have pooling information in the procedure-report information, the Update attribute information of merging part name shown in Figure 6, part drawing number and operation title for example, whether this three numerical value that is listed as of part name, part drawing number and operation title that detects form according to pooling information is identical, if identical then advance line data and merge, and the data during with the man-hour in the report line field and chief engineer to carry out numerical value cumulative, to obtain the procedure-report after the renewal.
In addition, if having sequencing information in the procedure-report information, the Update attribute information of the data in the procedure-report being pressed the part drawing number ascending sort is as shown in Figure 7 then pressed the part drawing number ascending sort, and obtains the procedure-report after the renewal.
Before being used for the order parameter of generating process form according to customer requirement retrieval, the design drawing of product and the data in the technical papers need to be extracted and be saved in the database, particularly, the data of the design drawing of X32 pump product are saved in the parts table in the database, and according to the assembly relation of product and parts, in database, construct product tree.
After finishing product tree, when execution in step S104 and step S106, system can according to part drawing number be connected with part name with the technique table be connected with the parts table namely the first detail list be connected detail list) set up correct connection, thereby obtain parts detailed data and parts attribute data.
Particularly, when reading components information, it is Bill Of Material that the X32 pump is carried out BOM(, is called again the bill of materials) launch, obtain 10 sub-parts under the X32 pump, the parts managing detailed catalogue of X32 pump and 10 sub-parts is saved in the internal memory, then respectively each parts is launched, for example: as shown in Figure 8, assembling launches to obtain the managing detailed catalogue of 3 sub-parts to pipe, as shown in Figure 9, motor is launched to obtain 3 sub-parts of corresponding motor.
As shown in Figure 5, impeller shaft and pinion wheel occur in table, can carry out the quantity merging to impeller shaft and these two parts of pinion wheel according to user's request, the assembling quantity of pipe assembling is 4 among Fig. 5, the assembling quantity of impeller shaft is 4 among Fig. 8, so the accumulative total assembling quantity of impeller shaft under pipe assembling is 4*4=16, adds the assembling quantity 2 of impeller shaft under the X32 pump, calculating the total assembling quantity of impeller shaft is 16+2=18, at this moment total 11+1=12 parts among the BOM.
In addition, part impeller shaft and coil in the motor also occur, can carry out the quantity merging to impeller shaft and coil according to user's request, the assembling quantity of motor in the X32 pump is 2 as shown in Figure 5, impeller shaft shown in Figure 9 assembling quantity in motor is 2, therefore the accumulative total assembling quantity of impeller shaft under motor is 2*2=4, and it is 18+4=22 that total obtains the total assembling quantity of impeller shaft, at this moment total 12+1=13 parts among the BOM.
Figure 10 shows X32 pump product is carried out the bill of materials and assembling quantity and the total quantity that BOM launches resulting X32 pump product, so far gets access to completely parts managing detailed catalogue.
After execution of step S104, form gathers engine and reads in shown in the attribute specification information (such as Figure 11) of task time detail list, then inquiry obtains the incidence relation of parts detailed data and attribute specification data, and reads corresponding parts attribute data according to incidence relation.Particularly, the attribute specification data are resolved, the query statement of generating database obtains Query Result.Wherein, man-hour, row were by computing formula: the man-hour=production time per piece in accurate whole man-hour+machine work order of machine work order, calculate; Row are by computing formula during the chief engineer: during the chief engineer=(production time per piece of accurate whole man-hour of machine work order+machine work order) * detail list in total quantity, calculate; The value of then getting accurate whole man-hour and production time per piece from Query Result calculates the value of row in man-hour, gets accurate whole man-hour from Query Result, and the value that the value of the total quantity of the parts that record among production time per piece and the BOM is listed as when calculating the chief engineer obtains the parts attribute data.
After the parts attribute data that derived query obtains, whether comprise the Update attribute information such as pooling information in the search procedure-report information, if comprise pooling information in the procedure-report, then will go mergings (as shown in figure 12) and renewal procedure-report; If do not split and replacement information in the procedure-report information, then can be with the procedure-report output of obtaining.
Can also use above-described embodiment to obtain the task time detail list of air rotor injection mould.
Certainly, the industry of different user is different with the production management mode, and detailed tableau format of the task time of user's request and rule are just not identical yet, can be as shown in table 2 such as the user's who has task time detail list yet:
Table 2:
Part name Part drawing number During turner During miller During driller During grinder
Need to prove, can in the computer system such as one group of computer executable instructions, carry out in the step shown in the process flow diagram of accompanying drawing, and, although there is shown logical order in flow process, but in some cases, can carry out step shown or that describe with the order that is different from herein.
From above description, can find out, the present invention has realized following technique effect: generation method and the device of the procedure-report by the application, so that the user can obtain parts managing detailed catalogue and procedure-report data according to the actual requirements, and according to components information and procedure-report data generating process form, solved in the prior art problem that demand response speed is slow and cost is high to user's generating process form, realized the user's request that quick response is different, and generate the effect of different forms, need to not design form for each product coding of each user, thereby so that the generation of procedure-report is quick and cost is low.
Obviously, those skilled in the art should be understood that, above-mentioned each module of the present invention or each step can realize with general calculation element, they can concentrate on the single calculation element, perhaps be distributed on the network that a plurality of calculation elements form, alternatively, they can be realized with the executable program code of calculation element, thereby, they can be stored in the memory storage and be carried out by calculation element, perhaps they are made into respectively each integrated circuit modules, perhaps a plurality of modules in them or step are made into the single integrated circuit module and realize.Like this, the present invention is not restricted to any specific hardware and software combination.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.

Claims (12)

1. the generation method of a procedure-report is characterized in that, comprising:
According to the order parameter of customer requirement retrieval for the generating process form, wherein, described order parameter comprises components information and procedure-report information;
From the first detail list, extract the parts detailed data corresponding with described components information;
Extract the procedure-report data corresponding with described procedure-report information from the second detail list, wherein, described procedure-report data comprise the attribute specification data;
Inquiry obtains the incidence relation of described parts detailed data and described attribute specification data, and reads corresponding parts attribute data according to described incidence relation;
Derive described parts attribute data, to generate described procedure-report.
2. method according to claim 1 is characterized in that, is deriving described parts attribute data, and to generate after the described procedure-report, described method comprises:
Search in the described procedure-report information and whether have Update attribute information;
In described order parameter, comprise and according to described Update attribute information described procedure-report is upgraded processing in the situation of described Update attribute information, to obtain the procedure-report after the renewal.
3. method according to claim 2 is characterized in that, described Update attribute information comprises: fractionation information, wherein, according to described Update attribute information described procedure-report is upgraded processing, and comprise with the step of obtaining the procedure-report after the renewal:
Inquire about the to be split data corresponding with described fractionation information;
Data Division described to be split is the fractionation data, and upgrades described procedure-report.
4. method according to claim 2 is characterized in that, described form attribute information comprises: replacement information, wherein, according to described form attribute information described procedure-report is upgraded processing, and comprise with the step of obtaining the procedure-report after the renewal:
Inquire about the replacement data corresponding with described replacement information and be replaced data;
Be described replacement data with the described data modification that is replaced, and upgrade described procedure-report.
5. method according to claim 2 is characterized in that, described form attribute information comprises: pooling information, wherein, according to described form attribute information described procedure-report is upgraded processing, and comprise with the step of obtaining the procedure-report after the renewal:
Inquire about the one or more to be combined data corresponding with described pooling information;
Merge one or more described data to be combined, and upgrade described procedure-report.
6. the described method of any one is characterized in that according to claim 1-5, and before being used for the order parameter of generating process form according to customer requirement retrieval, described method also comprises:
Creation database, described database comprises: described the first detail list, described the second detail list and the first tables of data, wherein,
Described the first detail list comprises: described parts detailed data;
Described the second detail list comprises: described procedure-report data;
Described the first tables of data comprises: the described relation on attributes of described parts detailed data and described procedure-report data and the described parts attribute data corresponding with described relation on attributes.
7. the generating apparatus of a procedure-report is characterized in that, comprising:
Acquisition module is used for according to the order parameter of customer requirement retrieval for the generating process form, and wherein, described order parameter comprises components information and procedure-report information;
The first extraction module is used for extracting the parts detailed data corresponding with described components information from the first detail list;
The second extraction module is used for extracting the procedure-report data corresponding with described procedure-report information from the second detail list, and wherein, described procedure-report data comprise the attribute specification data;
The first processing module is used for the relation on attributes that inquiry obtains described parts detailed data and described attribute specification data, and reads corresponding parts attribute data according to described relation on attributes;
The second processing module is used for deriving described parts attribute data, to generate described procedure-report.
8. device according to claim 7 is characterized in that, described device comprises:
Search module is used for searching for described procedure-report information and whether has Update attribute information;
The 3rd processing module is used for comprising in the situation of described Update attribute information at described order parameter, according to described Update attribute information described procedure-report is upgraded processing, to obtain the procedure-report after the renewal.
9. device according to claim 8 is characterized in that, described Update attribute information comprises: fractionation information, and wherein, described the 3rd processing module comprises:
The first enquiry module is used for inquiry the to be split data corresponding with described fractionation information;
The first sub-processing module is used for Data Division described to be split is the fractionation data, and upgrades described procedure-report.
10. device according to claim 8 is characterized in that, described form attribute information comprises: replacement information, and wherein, described the 3rd processing module comprises:
The second enquiry module is used for the inquiry replacement data corresponding with described replacement information and is replaced data;
The second sub-processing module, being used for the described data modification that is replaced is described replacement data, and upgrades described procedure-report.
11. device according to claim 8 is characterized in that, described form attribute information comprises: pooling information, and wherein, described the 3rd processing module comprises:
The 3rd inquiry module is used for the inquiry one or more to be combined data corresponding with described pooling information;
The 3rd sub-processing module is used for merging one or more described data to be combined, and upgrades described procedure-report.
12. the described device of any one in 11 according to claim 7 is characterized in that described device also comprises:
The manages module everywhere, is used for creation database, and described database comprises: described the first detail list, described the second detail list and the first tables of data, and wherein, described the first detail list comprises: described parts detailed data; Described the second detail list comprises: described procedure-report data; Described the first tables of data comprises: the described relation on attributes of described parts detailed data and described procedure-report data and the described parts attribute data corresponding with described relation on attributes.
CN2012104696696A 2012-11-19 2012-11-19 Process report generation method and device Pending CN103020750A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2012104696696A CN103020750A (en) 2012-11-19 2012-11-19 Process report generation method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2012104696696A CN103020750A (en) 2012-11-19 2012-11-19 Process report generation method and device

Publications (1)

Publication Number Publication Date
CN103020750A true CN103020750A (en) 2013-04-03

Family

ID=47969332

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2012104696696A Pending CN103020750A (en) 2012-11-19 2012-11-19 Process report generation method and device

Country Status (1)

Country Link
CN (1) CN103020750A (en)

Cited By (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105046401A (en) * 2015-06-19 2015-11-11 国家电网公司 Material statistic method and device for power projects
CN106933870A (en) * 2015-12-29 2017-07-07 平安科技(深圳)有限公司 The record list method and system of data of insuring
CN107038555A (en) * 2017-04-10 2017-08-11 广州智造家网络科技有限公司 A kind of BOM tables introduction method and device
CN107464083A (en) * 2017-08-24 2017-12-12 北京车和家信息技术有限责任公司 A kind of generation method of BOM, device and equipment
CN108197310A (en) * 2018-01-31 2018-06-22 杭州优工品科技有限公司 Industrial part management method and device based on big data
CN108876571A (en) * 2018-05-17 2018-11-23 武汉楚鼎信息技术有限公司 A kind of finance order conversion method and system of report, device
CN109003031A (en) * 2018-10-09 2018-12-14 郑州云海信息技术有限公司 A kind of method, equipment and the storage medium of scheduling and planning product
CN109190326A (en) * 2018-11-22 2019-01-11 南京新联电能云服务有限公司 Generate the method and device of process flow chart
CN109344374A (en) * 2018-08-22 2019-02-15 中国平安人寿保险股份有限公司 Report generation method and device, electronic equipment based on big data, storage medium
CN109408494A (en) * 2018-11-01 2019-03-01 北京京航计算通讯研究所 Model based on Worksheet self-defining function produces resume generation method
CN109472015A (en) * 2018-11-01 2019-03-15 北京京航计算通讯研究所 Model production resume based on Worksheet self-defining function generate system
CN110110407A (en) * 2019-04-24 2019-08-09 上海交通大学 A kind of technique information mark and report form generation method based on threedimensional model
CN110196969A (en) * 2018-02-26 2019-09-03 北大方正集团有限公司 A kind of shipment report automatic generation method and system
CN110648033A (en) * 2018-06-27 2020-01-03 西安海平方网络科技有限公司 Method and device for acquiring engineering list, computer equipment and storage medium
CN111784286A (en) * 2020-06-19 2020-10-16 内蒙古第一机械集团股份有限公司 Generation method of heat treatment process
CN113407549A (en) * 2021-08-19 2021-09-17 清华四川能源互联网研究院 Data processing method and device, electronic equipment and readable storage medium
CN113590669A (en) * 2021-07-29 2021-11-02 奇瑞汽车股份有限公司 Cost report generation method and device and computer storage medium
CN113688609A (en) * 2021-08-20 2021-11-23 北京数码大方科技股份有限公司 Method and device for naming process file, storage medium and processor
WO2022142380A1 (en) * 2021-01-04 2022-07-07 长鑫存储技术有限公司 Process data processing method and apparatus, storage medium, and electronic device

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2007280327A (en) * 2006-04-12 2007-10-25 Fujitsu Ltd Creation system and creation/management method of component configuration table
CN101477526A (en) * 2008-12-31 2009-07-08 中兴通讯股份有限公司 Method and system for implementing statistical forms customization
CN101504642A (en) * 2009-03-23 2009-08-12 金蝶软件(中国)有限公司 Report generation system and method
US7640264B1 (en) * 2005-09-23 2009-12-29 Emc Corporation System and methods for querying a report database
CN101706818A (en) * 2009-12-04 2010-05-12 金蝶软件(中国)有限公司 Report dynamic filtering method and device

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7640264B1 (en) * 2005-09-23 2009-12-29 Emc Corporation System and methods for querying a report database
JP2007280327A (en) * 2006-04-12 2007-10-25 Fujitsu Ltd Creation system and creation/management method of component configuration table
CN101477526A (en) * 2008-12-31 2009-07-08 中兴通讯股份有限公司 Method and system for implementing statistical forms customization
CN101504642A (en) * 2009-03-23 2009-08-12 金蝶软件(中国)有限公司 Report generation system and method
CN101706818A (en) * 2009-12-04 2010-05-12 金蝶软件(中国)有限公司 Report dynamic filtering method and device

Cited By (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105046401A (en) * 2015-06-19 2015-11-11 国家电网公司 Material statistic method and device for power projects
CN106933870A (en) * 2015-12-29 2017-07-07 平安科技(深圳)有限公司 The record list method and system of data of insuring
CN106933870B (en) * 2015-12-29 2020-09-29 平安科技(深圳)有限公司 Policy recording method and system for insurance data
CN107038555A (en) * 2017-04-10 2017-08-11 广州智造家网络科技有限公司 A kind of BOM tables introduction method and device
CN107464083A (en) * 2017-08-24 2017-12-12 北京车和家信息技术有限责任公司 A kind of generation method of BOM, device and equipment
CN108197310A (en) * 2018-01-31 2018-06-22 杭州优工品科技有限公司 Industrial part management method and device based on big data
CN110196969A (en) * 2018-02-26 2019-09-03 北大方正集团有限公司 A kind of shipment report automatic generation method and system
CN108876571A (en) * 2018-05-17 2018-11-23 武汉楚鼎信息技术有限公司 A kind of finance order conversion method and system of report, device
CN110648033A (en) * 2018-06-27 2020-01-03 西安海平方网络科技有限公司 Method and device for acquiring engineering list, computer equipment and storage medium
CN109344374B (en) * 2018-08-22 2023-09-01 中国平安人寿保险股份有限公司 Report generation method and device based on big data, electronic equipment and storage medium
CN109344374A (en) * 2018-08-22 2019-02-15 中国平安人寿保险股份有限公司 Report generation method and device, electronic equipment based on big data, storage medium
CN109003031A (en) * 2018-10-09 2018-12-14 郑州云海信息技术有限公司 A kind of method, equipment and the storage medium of scheduling and planning product
CN109408494B (en) * 2018-11-01 2022-07-19 北京京航计算通讯研究所 Model production record generation method based on form self-defining function
CN109472015A (en) * 2018-11-01 2019-03-15 北京京航计算通讯研究所 Model production resume based on Worksheet self-defining function generate system
CN109408494A (en) * 2018-11-01 2019-03-01 北京京航计算通讯研究所 Model based on Worksheet self-defining function produces resume generation method
CN109190326B (en) * 2018-11-22 2024-01-30 南京新联电能云服务有限公司 Method and device for generating process flow chart
CN109190326A (en) * 2018-11-22 2019-01-11 南京新联电能云服务有限公司 Generate the method and device of process flow chart
CN110110407A (en) * 2019-04-24 2019-08-09 上海交通大学 A kind of technique information mark and report form generation method based on threedimensional model
CN111784286A (en) * 2020-06-19 2020-10-16 内蒙古第一机械集团股份有限公司 Generation method of heat treatment process
WO2022142380A1 (en) * 2021-01-04 2022-07-07 长鑫存储技术有限公司 Process data processing method and apparatus, storage medium, and electronic device
CN113590669A (en) * 2021-07-29 2021-11-02 奇瑞汽车股份有限公司 Cost report generation method and device and computer storage medium
CN113590669B (en) * 2021-07-29 2024-03-29 奇瑞汽车股份有限公司 Method and device for generating cost report forms and computer storage medium
CN113407549B (en) * 2021-08-19 2021-11-23 清华四川能源互联网研究院 Data processing method and device, electronic equipment and readable storage medium
CN113407549A (en) * 2021-08-19 2021-09-17 清华四川能源互联网研究院 Data processing method and device, electronic equipment and readable storage medium
CN113688609A (en) * 2021-08-20 2021-11-23 北京数码大方科技股份有限公司 Method and device for naming process file, storage medium and processor
CN113688609B (en) * 2021-08-20 2023-12-12 北京数码大方科技股份有限公司 Naming method and device of process file, storage medium and processor

Similar Documents

Publication Publication Date Title
CN103020750A (en) Process report generation method and device
Pintzos et al. Assembly precedence diagram generation through assembly tiers determination
David et al. What does PLMS (product lifecycle management systems) manage: Data or documents? Complementarity and contingency for SMEs
CN106649225A (en) JSON self-definition-based report generation system and method
Magar et al. Requirements on engineering tools for increasing reuse in industrial automation
CN103020158A (en) Report form creation method, device and system
CN111309315B (en) Automatic configuration method based on industrial Internet of things data and business modeling
CN103019693A (en) System and method for generating user interface
CN102789487B (en) Data query retrieval process device and data query search processing method
CN105574303A (en) Enterprise informatization operation system
US20180121058A1 (en) Graphical user interface systems and methods for data integration with data-driven engineering drawings
CN104715032A (en) Mapping system and method of Chinese and English table name and field name of report system
CN102004954A (en) Product information system and information integration method of product design system
Chiarini A comparison between time-driven activity-based costing and value stream accounting in a lean Six Sigma manufacturing case study
US20130124265A1 (en) Enterprise System/Process Modeling System and Method
CN103186632A (en) Method and device for customizing operation and maintenance form
CN103927423A (en) Part design change method and system in PDM system
CN104317936A (en) ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models
Mourtzis et al. PSS design evaluation via KPIs and lean design assistance supported by context sensitivity tools
CN105046414A (en) Business tracing method and business tracing device applied to ERP systems
CN115496452A (en) Digital delivery system based on digital twin
CN107748748A (en) Water conservancy and hydropower technical standard text retrieval system
CN112541692B (en) Scientific data management plan generation method and device
Mueller A cost calculation model for the optimal design of size ranges
CA2522254A1 (en) Method and system for designing, implementing and documenting olap

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20130403

RJ01 Rejection of invention patent application after publication