CN103064831B - The method of deploying of product structure table and system - Google Patents
The method of deploying of product structure table and system Download PDFInfo
- Publication number
- CN103064831B CN103064831B CN201110317042.4A CN201110317042A CN103064831B CN 103064831 B CN103064831 B CN 103064831B CN 201110317042 A CN201110317042 A CN 201110317042A CN 103064831 B CN103064831 B CN 103064831B
- Authority
- CN
- China
- Prior art keywords
- custom field
- result table
- user
- source
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- Stored Programmes (AREA)
Abstract
The present invention relates to a kind of method of deploying and system of product structure table.The method comprises the following steps: the information creating source table described according to metadata and result table; The data that will launch are inserted in the table of described source; The data launched in the table of described source are inserted described result table, and launches the data in described result table step by step; The expansion logic of the custom field that acquisition user adds in described result table and custom field; The result table comprising described custom field is launched according to described expansion logic.The method of deploying of the said goods structural table and system, the source table set up by the information described according to metadata and result table, the custom field easily added in result table and the expansion logic of custom field, result table is launched according to expansion logic, achieve the controlled of field, facilitate user to add custom field.
Description
[technical field]
The present invention relates to computer application field, particularly a kind of method of deploying of product structure table and system.
[background technology]
Product structure table refers to the composition situation of the parts (generally including finished goods, semi-manufacture or component) of product, subordinate's parts composition of parts, every consumption of one-level parts and the attribute etc. of correspondence.
Existing product structure table launches to be direct splicing SQL or realized by storing process in source code by level, launches logic and is directly embedded in code or storing process.Wherein, in product structure table, under father's item, there is subitem, product structure table is launched refer to and father's item, subitem are shown.In existing product structure table, if user needs to add the parts of product or subordinate's parts of parts, then must revise source code by product development personnel and realize.
[summary of the invention]
Based on this, be necessary to provide a kind of method of deploying that user can be facilitated to add the product structure table of custom field.
A method of deploying for product structure table, comprises the following steps:
The information creating source table described according to metadata and result table;
The data that will launch are inserted in the table of described source;
The data launched in the table of described source are inserted described result table, and launches the data in described result table step by step;
The expansion logic of the custom field that acquisition user adds in described result table and custom field;
The result table comprising described custom field is launched according to described expansion logic.
Preferably, insert the step of the data that will launch in the table of described source after, also step is comprised: obtain the peek logic that user adds custom field and custom field in the table of described source.
Preferably, also step is comprised: the peek logic of the custom field added in the table of described source and custom field be inserted in described result table.
Preferably, also step is comprised: the corresponding relation between the expansion logic setting up self-defining field that user and described user add and custom field.
Preferably, also step is comprised: delete user in the result table launched according to Permission Levels and have no right the data of checking.
In addition, there is a need to provide a kind of development system that user can be facilitated to add the product structure table of custom field.
A development system for product structure table, comprising:
Creation module, shows and result table for the information creating source described according to metadata;
Insert module, for inserting the data that will launch in the table of described source;
Launch module, for the data launched in the table of described source are inserted described result table, and launch the data in described result table step by step;
Acquisition module, for obtaining the expansion logic of custom field that user adds in described result table and custom field;
Described expansion module is also for launching according to described expansion logic the result table comprising described custom field.
Preferably, described acquisition module also adds the peek logic of custom field and custom field in the table of described source for obtaining user.
Preferably, described insert module is also for being inserted into the peek logic of the custom field added in the table of described source and custom field in described result table.
Preferably, described creation module also for set up self-defining field that user and described user add and custom field expansion logic between corresponding relation.
Preferably, also comprise removing module, described removing module is for having no right the data of checking according to user in the result table of Permission Levels deletion expansion.
The method of deploying of the said goods structural table and system, the source table set up by the information described according to metadata and result table, the custom field easily added in result table and the expansion logic of custom field, result table is launched according to expansion logic, achieve the controlled of field, facilitate user to add custom field.
[accompanying drawing explanation]
Fig. 1 is the process flow diagram of the method for deploying of product structure table in an embodiment;
Fig. 2 is the structural representation of the development system of product structure table in an embodiment;
Fig. 3 is the structural representation of the development system of product structure table in another embodiment.
[embodiment]
Below in conjunction with specific embodiment and accompanying drawing, the method for deploying of product structure table and the technical scheme of system are described in detail, with make its clearly, complete.
As shown in Figure 1, in one embodiment, a kind of method of deploying of product structure table, comprises the following steps:
Step S110, the information creating source table described according to metadata and result table.
Metadata (MetaData) is the data about data warehouse, refer to produce in Construction of Data Warehouse process define to relevant data source, object definition, critical data that transformation rule etc. is relevant.According to source table and the result table of the information creating of metadata description, user can add custom field in source table and result table.
Step S120, inserts the data that will launch in the table of this source.
As launched coming in product structure table source block, then the data of source block are inserted in the table of source in the future.The data carrying out source block can comprise the peek data of unit field, quantity required field, Date Required field etc.
After step S120, also comprise step: obtain the user custom field of interpolation and peek logic of custom field in the table of this source.Wherein, logic of peeking shows self-defining character assignment.In the table of source, directly add the peek logic of custom field and custom field, can show in result table.In addition, set up corresponding relation between the custom field of user and interpolation and the peek logic of custom field, the peek logic that user adds custom field and custom field is equivalent to a Plugin events.
Step S130, the data launched in being shown in this source insert this result table, and launch the data in this result table step by step.
Insert to result table the data launched from source table, the data launched in result table are as the peek data of subitem parts field, element attribute field, consumption type field, parts level field etc.The data in result table are launched step by step according to level.
After the step obtaining the user's custom field of interpolation and peek logic of custom field in the table of this source, also comprise step: the peek logic of the custom field added in the table of this source and custom field be inserted in this result table.The custom field added in the table of source and the peek logic of custom field can be carried in result table, launch.In addition, the expansion logic of the custom field that user adds is obtained.Launch logic such as date calculating, quantity calculating, field to carry.In addition, the corresponding relation between the peek logic also can setting up custom field that user and user add and custom field.When facilitating user to check that source is shown, corresponding custom field can be obtained.
Step S140, the expansion logic of the custom field that acquisition user adds in this result table and custom field.
User can add the expansion logic of independently custom field and custom field in result table, and this custom field there will not be in the table of source.Launch logic such as date calculating, quantity calculating, field to carry.In addition, the peek logic of the custom field that user adds can also be obtained.The expansion logic of the custom field that user and user add and custom field is equivalent to a Plugin events.Self-defined peek logic also can be comprised in this Plugin events.
After the step s 150, also step is comprised: the corresponding relation between the expansion logic setting up self-defining field that user and this user add and custom field.User is facilitated to check the data launched according to the field of oneself definition next time.
Step S150, launches according to this expansion logic the result table comprising this custom field.
After launching result table, also can carry out self-defined process to the result launched, as deleted the data etc. that user haves no right to check according to Permission Levels.Permission Levels can set according to the identity of user, and as keeper can check all data, different department employee checks corresponding division data.
As shown in Figure 2, in one embodiment, a kind of development system of product structure table, comprises creation module 210, insert module 220, launches module 230 and acquisition module 240.Wherein:
Creation module 210 is shown and result table for the information creating source described according to metadata.Metadata (MetaData) is the data about data warehouse, refers to the critical data that the definition of relevant data source, object definition, transformation rule etc. that produce in Construction of Data Warehouse process are correlated with.According to source table and the result table of the information creating of metadata description, user can add custom field in source table and result table.
Insert module 220 for inserting the data that will launch in the table of this source.As launched coming in product structure table source block, then the data of source block are inserted in the table of source in the future.The data carrying out source block can comprise the peek data of unit field, quantity required field, Date Required field etc.
Launch module 230 for the data launched in the table of this source are inserted this result table, and launch the data in described result table step by step.Insert to result table the data launched from source table, the data launched in result table are as the peek data of subitem parts field, element attribute field, consumption type field, parts level field etc.The data in result table are launched step by step according to level.
Acquisition module 240 is for the expansion logic of the custom field that obtains user and add in this result table and custom field.Wherein, launch logic such as date calculating, quantity calculating, field to carry.User can add the expansion logic of independently custom field and custom field in result table, and this custom field there will not be in the table of source.In addition, acquisition module 240 is also for obtaining the peek logic of the custom field that user adds.Wherein, logic of peeking shows self-defining character assignment.The expansion logic of the custom field that user and user add and custom field is equivalent to a Plugin events.Self-defined peek logic also can be comprised in this Plugin events.
In addition, creation module 210 also for set up self-defining field that user and this user add and custom field expansion logic between corresponding relation.The peek logic that user adds custom field and custom field is equivalent to a Plugin events.User is facilitated to check the data launched according to the field of oneself definition next time.
Launch module 230 also for launching to comprise the result table of this custom field according to this expansion logic.After expansion module 230 launches result table, in result table, comprise the custom field that user adds.
In one embodiment, acquisition module 240 also adds the peek logic of custom field and custom field in the table of this source for obtaining user.The custom field added in the table of source and the peek logic of custom field can be carried in result table, launch.In addition, acquisition module 240 is also for obtaining the expansion logic of the custom field that user adds.Launch logic such as date calculating, quantity calculating, field to carry.
Creation module 210 also for set up self-defining field that user and this user add and custom field peek logic between corresponding relation.When facilitating user to check that source is shown, corresponding custom field can be obtained.
Insert module 220 is also for being inserted into the peek logic of the custom field added in the table of this source and custom field in this result table.The custom field added in the table of source and the peek logic of custom field can be carried in result table, launch.
When expansion module 230 launches result table, the peek logic of the custom field that user adds in the table of source and custom field can be present in result table.
In one embodiment, as shown in Figure 3, the development system of the said goods structural table, except comprising creation module 210, insert module 220, launching module 230 and acquisition module 240, also comprises removing module 250.Removing module 250 is for having no right the data of checking according to user in Permission Levels deletion result table.Permission Levels can set according to the identity of user, and as keeper can check all data, different department employee checks corresponding division data.
The method of deploying of the said goods structural table and system, the source table set up by the information described according to metadata and result table, the custom field easily added in result table and the expansion logic of custom field, result table is launched according to expansion logic, achieve the controlled of field, facilitate user to add custom field.
In addition, in result table, both can customize field, and also can customize expansion logic and the peek logic of field, make user add the field needing to launch according to self-demand, easy to operate.
The above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but therefore can not be interpreted as the restriction to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (8)
1. a method of deploying for product structure table, comprises the following steps:
The information creating source table described according to metadata and result table;
The data that will launch are inserted in the table of described source;
Obtain the user custom field of interpolation and peek logic of custom field in the table of described source;
The data launched in the table of described source are inserted described result table, and launches the data in described result table step by step;
The expansion logic of the custom field that acquisition user adds in described result table and custom field;
The result table comprising described custom field is launched according to described expansion logic.
2. the method for deploying of product structure table according to claim 1, is characterized in that, also comprise step: the peek logic of the custom field added in the table of described source and custom field be inserted in described result table.
3. the method for deploying of product structure table according to claim 1, is characterized in that, also comprise step: the corresponding relation between the expansion logic setting up self-defining field that user and described user add and custom field.
4. the method for deploying of product structure table according to claim 1, is characterized in that, also comprise step: delete user in the result table launched according to Permission Levels and have no right the data of checking.
5. a development system for product structure table, is characterized in that, comprising:
Creation module, shows and result table for the information creating source described according to metadata;
Insert module, for inserting the data that will launch in the table of described source;
Launch module, for the data launched in the table of described source are inserted described result table, and launch the data in described result table step by step;
Acquisition module, for obtaining the expansion logic of custom field that user adds in described result table and custom field;
Described expansion module is also for launching according to described expansion logic the result table comprising described custom field;
Described acquisition module is also for obtaining the user custom field of interpolation and peek logic of custom field in the table of described source.
6. the development system of product structure table according to claim 5, is characterized in that, described insert module is also for being inserted into the peek logic of the custom field added in the table of described source and custom field in described result table.
7. the development system of product structure table according to claim 5, is characterized in that, described creation module also for set up self-defining field that user and described user add and custom field expansion logic between corresponding relation.
8. the development system of product structure table according to claim 5, is characterized in that, also comprise removing module, and described removing module is for having no right the data of checking according to user in the result table of Permission Levels deletion expansion.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110317042.4A CN103064831B (en) | 2011-10-18 | 2011-10-18 | The method of deploying of product structure table and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110317042.4A CN103064831B (en) | 2011-10-18 | 2011-10-18 | The method of deploying of product structure table and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103064831A CN103064831A (en) | 2013-04-24 |
| CN103064831B true CN103064831B (en) | 2016-01-13 |
Family
ID=48107461
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110317042.4A Active CN103064831B (en) | 2011-10-18 | 2011-10-18 | The method of deploying of product structure table and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103064831B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105912723B (en) * | 2016-05-09 | 2019-09-13 | 统一通信（苏州）有限公司 | A kind of storage method of custom field |
| CN107657066A (en) * | 2017-11-13 | 2018-02-02 | 医渡云（北京）技术有限公司 | Medical data scientific research field customizing method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101216763A (en) * | 2008-01-17 | 2008-07-09 | 金蝶软件（中国）有限公司 | Personalized interface accomplishing method and system |
| CN101706720A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Method for showing interface according to customized information during operation |
| CN101706716A (en) * | 2009-09-08 | 2010-05-12 | 南京师范大学 | VO-based form customization, configuration and parsing operation method |
| CN101866333A (en) * | 2009-12-24 | 2010-10-20 | 金蝶软件（中国）有限公司 | Worksheet self-defining method and adapter engine |
| CN102110142A (en) * | 2011-02-09 | 2011-06-29 | 浪潮集团山东通用软件有限公司 | Method for dynamically expanding personnel transaction in human resource management information system |
-
2011
- 2011-10-18 CN CN201110317042.4A patent/CN103064831B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101216763A (en) * | 2008-01-17 | 2008-07-09 | 金蝶软件（中国）有限公司 | Personalized interface accomplishing method and system |
| CN101706716A (en) * | 2009-09-08 | 2010-05-12 | 南京师范大学 | VO-based form customization, configuration and parsing operation method |
| CN101706720A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Method for showing interface according to customized information during operation |
| CN101866333A (en) * | 2009-12-24 | 2010-10-20 | 金蝶软件（中国）有限公司 | Worksheet self-defining method and adapter engine |
| CN102110142A (en) * | 2011-02-09 | 2011-06-29 | 浪潮集团山东通用软件有限公司 | Method for dynamically expanding personnel transaction in human resource management information system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103064831A (en) | 2013-04-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102779040B (en) | A kind of method and apparatus generating customizing form | |
| CN104331285A (en) | Automatic code generation method and system | |
| JP2005222552A5 (en) | ||
| CN110096476A (en) | Data back up method, device and computer readable storage medium | |
| WO2008090044A3 (en) | Secure data deletion in a transaction system | |
| CN102902767A (en) | Method and system for rapidly creating forms | |
| CN105302533A (en) | Code synchronizing method and apparatus | |
| CN103902717A (en) | System and method for personalizing internal portals of enterprises | |
| CN103093038A (en) | Updating method and updating device for bills of material (BOMs) | |
| CN104461743A (en) | Device and method for automatically generating resources and configuration | |
| CN105550219A (en) | Information resource automatic cataloguing method | |
| CN103064659A (en) | Software as a service (SAAS) model based on metadata extraction user-defined worksheet system | |
| CN103064831B (en) | The method of deploying of product structure table and system | |
| CN105260464A (en) | Data storage structure conversion method and apparatus | |
| CN102999527A (en) | Dynamic information pushing method and system in SNS (social networking services) network | |
| CN103701653A (en) | Processing method for interface hot plugging and unplugging configuration data and network configuration server | |
| CN103488476A (en) | Associated data processing system and associated data processing method | |
| CN104574275A (en) | Method for combining maps in drawing process of model | |
| CN104268607A (en) | Textile fabric management system and method based on RFID technology | |
| CN104794025B (en) | The method of rapid verification storage device | |
| CN103678983A (en) | Smartphone usage permission verification system and method | |
| WO2010048046A3 (en) | Modeling party identities in computer storage systems | |
| CN104283932A (en) | File synchronization system and method | |
| CN105335386A (en) | Method and apparatus for providing navigation tag | |
| CN109670192A (en) | A kind of component ID batch extracting method based on BIM |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |