CN104133900A - Definition description method of 360-degree treeview - Google Patents
Definition description method of 360-degree treeview Download PDFInfo
- Publication number
- CN104133900A CN104133900A CN201410379211.0A CN201410379211A CN104133900A CN 104133900 A CN104133900 A CN 104133900A CN 201410379211 A CN201410379211 A CN 201410379211A CN 104133900 A CN104133900 A CN 104133900A
- Authority
- CN
- China
- Prior art keywords
- node
- definition
- view
- business object
- business datum
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/10—Requirements analysis; Specification techniques
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a 360-degree treeview software implementation process based on flexible definition and controllable permission. Root nodes are used as main service objects of 360-degree treeview to be subjected to analysis and 360-degree treeview definition, service object nodes are defined for the root nodes, each service object node corresponds to a service data node, and the 360-degree treeview definition can be quoted continuously for the service data node definition. The 360-degree treeview is omnibearing service data display treeview based on the service objects, the connecting and inquiring address with the detailed condition can be designed for each node on the 360-degree treeview, so that connecting and inquiring operation of service data can be conducted, and recursion definition calling of the 360-degree treeview can be conducted on each data node.
Description
Technical field
The present invention relates to a kind of computer application technology, solved when analyzing specific business object, to user, show the requirement that omnibearing data present, make the displaying of business datum more abundant directly perceived.A kind of definition describing method of 360 ° of tree view specifically.
Background technology
In ERP application, how to show that the data in ERP are that each enterprise must consider and the part realizing, traditional form, chart are shown and can only be carried out data display by single dimension, in actual service application, analysis to specific transactions object, need to comprehensively analyze from different angles and business datum, in this business background, issue clear this method.
Summary of the invention
The definition describing method that the object of this invention is to provide a kind of 360 ° of tree view.
The object of the invention is to realize in the following manner, comprise following content:
1) definition of 360 ° of tree view is described,
[root node] ┊ ┊
├-[
business object node 1] ┊ is by data joint investigation ┊
┊ ├-[business datum node 1] ┊ can show ┊ here
┊ ┊ └-[
business object node 1] information ┊ that ┊ is detailed
┊ ┊ └-[business datum node 1] ┊ (form) ┊
┊ └-[business datum node 2] ┊ (list) ┊
┊ └-[
business object node 1] ┊ (...) ┊
┊ ├-[business datum node 1] ┊ ┊
┊ └-[business datum node 1] ┊ ┊
└-[
business object node 2] ┊ ┊
├-[business datum node 1] ┊ ┊
└-[business datum node 2] ┊ ┊
2) the definition describing mode of 360 ° of tree view, describes and is divided into two parts, root node, business object node for 360 ° of tree view of functional entrance;
root node is described:
view ID: for distinguishing the system numbering of different business objects;
view name:for distinguishing the system of different business objects, describe;
root node title SQL:the title of root node is generally automatic from concrete business object, comprises concrete customer name;
root node joint investigation address:uRL address for the concrete business object of joint investigation;
business object node is described:
node serial number:for distinguishing the numbering of different business object child nodes;
nodename:for distinguishing the system of different business object child nodes, describe, comprising: delivery, returned money;
node ID:sort by when tree structure view shows;
control authority whether:for responsive business datum, can carry out control of authority, the authority that need to control, allow this node to distribute to different operating personnel;
point title business datum SQL:here refer to the combined data of obtaining on node;
node joint investigation address: for business object node, joint investigation address can be set, facilitate user to count more easily retrieval and inquisition to this business datum;
downstream site data SQL:for business object node, concrete business datum can be set as its downstream site;
downstream site joint investigation address:for the concrete business datum Node configuration joint investigation of the subordinate address of business object node, obtain the details of concrete business datum;
downstream site view ID:the 360 tree view interface ID for subordinate's concrete business datum Node configuration of business object node, realize the displaying of recursion;
Step is as follows:
1) by business object node, the circularly exhibiting of business datum node, realize the data analysis of 360 °, the tree view of utilizing recursive algorithm to realize without progression restriction represents, the definition describing mode of 360 ° of tree view, for 360 ° of tree view of functional entrance, describe and be divided into two parts, root node, business object node, wherein:
Root node is described: view ID, view name, root node title, root node joint investigation address;
Whether business object node is described: node serial number, nodename, node ID, control authority, some title business datum SQL, node joint investigation address, downstream site data SQL, downstream site joint investigation address, downstream site view ID;
2) the recursive call methods of exhibiting of view.
Step 1: obtain root node, for the displaying of setting, we adopt interim result table, after Organization of Data is good, passing to the displaying control on foreground shows, for just interim result table, there is following information: node serial number, nodename, demonstration sequence number, tree definition ID, node data SQL, whether adjust joint investigation address, URL corresponding to joint investigation address, by parameter, set the descriptor that definition ID obtains its root node, for 360 ° of tree view root nodes, only has one, by address parameter and tree definition ID, obtain concrete numbering and the title of root node;
Step 2: obtain business object node, set by parameter the descriptor that definition ID obtains its service node;
Step 3: the subordinate's business datum node that obtains business object node, in describing, business object node has downstream site data SQL, downstream site joint investigation address, for downstream site data SQL system requirements, must return to numbering, title, to form the node of data;
Step 4: for the business datum node that has downstream site view ID, repeating step 2, step 3, step 4;
3) the definition description of nodename and the associated methods of dynamic service data
Definition describing method 360 ° of tree view, there is a definition of name service data SQL to describe step as follows: contact person's node of take under client is foundation: contact person (2), wherein contact person is the node name in describing according to definition, number 2 is described and is obtained from database according to " some title business datum SQL ", and SQL is defined as follows:
select?count(*)?from?YXMBRY?where?YXMBRY_KHBH=KHBH
Wherein: KHBH system can be obtained according to address parameter, and can be with PID father node ID, an ID present node ID;
System is supported particular constraints form Calling Stored Procedure:
[sp] sp_test_tree (ID=ID) [/sp], wherein sp_test_tree is storing process title, ID parameter, ID is the parameter value that system provides;
Address parameter example:
http://127.0.0.1/gs5/NetTree/NetTree.aspx?ID=36001&Is360=1&randomid=1403149348467&KHBH=SY000034
Wherein ID, Is360, randomid are preset parameters, and user time can use any parameter in addition in definition, and are using by the mode of parameter name in SQL or joint investigation address, during call stored procedure.
4) node control of authority
Because 360 ° of tree view data are comprehensive, some enterprise's sensitive data needs authorization control, when definition view node, by whether using control authority, and arranges after the authorized person that this node is corresponding, and system is shown no node according to control of authority.
Excellent effect of the present invention: the method, successfully for the tide ERP-360 ° of views of collaborative client of marketing, by the application of this technology, has well solved user to 360 of business datum ° of displaying demands.
Accompanying drawing explanation
Fig. 1 is the procedure chart of routine processes view definition.
Embodiment
With reference to Figure of description, to of the present invention, be described in detail below.
Main contents have:
1, the definition of 360 ° of tree view is described,
[root node] ┊ ┊
├-[
business object node 1] ┊ is by data joint investigation ┊
┊ ├-[business datum node 1] ┊ can show ┊ here
┊ ┊ └-[
business object node 1] information ┊ that ┊ is detailed
┊ ┊ └-[business datum node 1] ┊ (form) ┊
┊ └-[business datum node 2] ┊ (list) ┊
┊ └-[
business object node 1] ┊ (...) ┊
┊ ├-[business datum node 1] ┊ ┊
┊ └-[business datum node 1] ┊ ┊
└-[
business object node 2] ┊ ┊
├-[business datum node 1] ┊ ┊
└-[business datum node 2] ┊ ┊
2, the definition describing mode of 360 ° of tree view, describes and is divided into two parts, root node, business object node for 360 ° of tree view of functional entrance.
root node is described:
view ID: for distinguishing the system numbering of different business objects.
view name:for distinguishing the system of different business objects, describe.
root node title SQL:the title of root node is generally automatic from concrete business object, for example: concrete customer name.
root node joint investigation address:uRL address for the concrete business object of joint investigation.
business object node is described:
node serial number:for distinguishing the numbering of different business object child nodes.
nodename:for distinguishing the system of different business object child nodes, (for example: delivery, returned money etc.) described.
node ID:sort by when tree structure view shows.
control authority whether:for responsive business datum, can carry out control of authority, the authority of need controlling this node can be distributed to different operating personnel.
point title business datum SQL:here be mainly the combined data (for example: returned money (200,000), contact person (12) etc.) of obtaining on node.
node joint investigation address: for business object node, joint investigation address can be set, facilitate user to count more easily retrieval and inquisition to this business datum.
downstream site data SQL:for business object node, concrete business datum can be set as its downstream site.
downstream site joint investigation address:for the concrete business datum Node configuration joint investigation of the subordinate address of business object node, obtain the details of concrete business datum.
downstream site view ID:the 360 tree view interface ID for subordinate's concrete business datum Node configuration of business object node, realize the displaying of recursion.
3, the recursive call methods of exhibiting of view.
Step 1: obtain root node, for tree displaying we adopt interim result table, Organization of Data is good after, pass to the displaying control on foreground and show.For just interim result table, there is following information: whether node serial number, nodename, demonstration sequence number, tree definition ID, node data SQL, adjust joint investigation address, URL corresponding to joint investigation address.By parameter, set the descriptor that definition ID can obtain its root node very easily.For 3360 ° of tree view root nodes, only have one, by address parameter and tree definition ID, can obtain concrete numbering and the title of root node.For example: 0001, client 0001.
Step 2: obtain business object node, set by parameter the descriptor that definition ID can obtain its service node very easily.
Step 3: obtain subordinate's business datum node of business object node, have downstream site data SQL, downstream site joint investigation address in business object node is described.For downstream site data SQL system requirements, must return to numbering, title, to form the node of data.
Step 4: for the business datum node that has downstream site view ID, repeating step 2, step 3, step 4.
4, the definition description of nodename and the combination technology of dynamic service data.
Definition describing method 360 ° of tree view, there is the definition of a name service data SQL to describe, contact person's node of take under client is example: contact person (2), wherein contact person is the node name in describing according to definition, number 2 is described and is obtained from database according to " some title business datum SQL ", and SQL is defined as follows:
select?count(*)?from?YXMBRY?where?YXMBRY_KHBH=KHBH
Wherein: KHBH system can be obtained according to address parameter, and can be with PID father node ID, an ID present node ID.
System support is with particular constraints form Calling Stored Procedure: [sp] sp_test_tree (ID=ID) [/sp], and wherein sp_test_tree is storing process title, ID parameter, and ID is the parameter value that system provides.
Address parameter example:
http://127.0.0.1/gs5/NetTree/NetTree.aspx?ID=36001&Is360=1&randomid=1403149348467&KHBH=SY000034
Wherein ID, Is360, randomid are preset parameters, and user time can use any parameter in addition in definition, and are using by the mode of parameter name in SQL or joint investigation address, during call stored procedure.
5, node control of authority
Because 360 ° of tree view data are comprehensive, some enterprise's sensitive data needs authorization control, when definition view node, by whether using control authority, and arranges after the authorized person that this node is corresponding, and system can be shown no node according to control of authority.
360 view definitions
360 view definition managing detailed catalogues
。
Except the technical characterictic described in instructions, be the known technology of those skilled in the art.
Claims (1)
1. a definition describing method for 360 ° of tree view, is characterized in that comprising following content:
1) definition of 360 ° of tree view is described,
[root node] ┊ ┊
├-[
business object node 1] ┊ is by data joint investigation ┊
┊ ├-[business datum node 1] ┊ can show ┊ here
┊ ┊ └-[
business object node 1] information ┊ that ┊ is detailed
┊ ┊ └-[business datum node 1] ┊ (form) ┊
┊ └-[business datum node 2] ┊ (list) ┊
┊ └-[
business object node 1] ┊ (...) ┊
┊ ├-[business datum node 1] ┊ ┊
┊ └-[business datum node 1] ┊ ┊
└-[
business object node 2] ┊ ┊
├-[business datum node 1] ┊ ┊
└-[business datum node 2] ┊ ┊
2) the definition describing mode of 360 ° of tree view, describes and is divided into two parts, root node, business object node for 360 ° of tree view of functional entrance;
root node is described:
view ID: for distinguishing the system numbering of different business objects;
view name:for distinguishing the system of different business objects, describe;
root node title SQL:the title of root node is generally automatic from concrete business object, comprises concrete customer name;
root node joint investigation address:uRL address for the concrete business object of joint investigation;
business object node is described:
node serial number:for distinguishing the numbering of different business object child nodes;
nodename:for distinguishing the system of different business object child nodes, describe, comprising: delivery, returned money;
node ID:sort by when tree structure view shows;
control authority whether:for responsive business datum, can carry out control of authority, the authority that need to control, allow this node to distribute to different operating personnel;
point title business datum SQL:here refer to the combined data of obtaining on node;
node joint investigation address: for business object node, joint investigation address can be set, facilitate user to count more easily retrieval and inquisition to this business datum;
downstream site data SQL:for business object node, concrete business datum can be set as its downstream site;
downstream site joint investigation address:for the concrete business datum Node configuration joint investigation of the subordinate address of business object node, obtain the details of concrete business datum;
downstream site view ID:the 360 tree view interface ID for subordinate's concrete business datum Node configuration of business object node, realize the displaying of recursion;
Step is as follows:
(1) by business object node, the circularly exhibiting of business datum node, realize the data analysis of 360 °, the tree view of utilizing recursive algorithm to realize without progression restriction represents, the definition describing mode of 360 ° of tree view, for 360 ° of tree view of functional entrance, describe and be divided into two parts, root node, business object node, wherein:
Root node is described: view ID, view name, root node title, root node joint investigation address;
Whether business object node is described: node serial number, nodename, node ID, control authority, some title business datum SQL, node joint investigation address, downstream site data SQL, downstream site joint investigation address, downstream site view ID;
(2) the recursive call methods of exhibiting of view;
Step 1: obtain root node, for the displaying of setting, we adopt interim result table, after Organization of Data is good, passing to the displaying control on foreground shows, for just interim result table, there is following information: node serial number, nodename, demonstration sequence number, tree definition ID, node data SQL, whether adjust joint investigation address, URL corresponding to joint investigation address, by parameter, set the descriptor that definition ID obtains its root node, for 360 ° of tree view root nodes, only has one, by address parameter and tree definition ID, obtain concrete numbering and the title of root node;
Step 2: obtain business object node, set by parameter the descriptor that definition ID obtains its service node;
Step 3: the subordinate's business datum node that obtains business object node, in describing, business object node has downstream site data SQL, downstream site joint investigation address, for downstream site data SQL system requirements, must return to numbering, title, to form the node of data;
Step 4: for the business datum node that has downstream site view ID, repeating step 2, step 3, step 4;
(3) the definition description of nodename and the associated methods of dynamic service data
Definition describing method 360 ° of tree view, there is a definition of name service data SQL to describe step as follows: contact person's node of take under client is foundation: contact person (2), wherein contact person is the node name in describing according to definition, number 2 is described and is obtained from database according to " some title business datum SQL ", and SQL is defined as follows:
select?count(*)?from?YXMBRY?where?YXMBRY_KHBH=KHBH
Wherein: KHBH system can be obtained according to address parameter, and can be with PID father node ID, an ID present node ID;
System is supported particular constraints form Calling Stored Procedure:
[sp] sp_test_tree (ID=ID) [/sp], wherein sp_test_tree is storing process title, ID parameter, ID is the parameter value that system provides;
Address parameter example:
http://127.0.0.1/gs5/NetTree/NetTree.aspx?ID=36001&Is360=1&randomid=1403149348467&KHBH=SY000034
Wherein ID, Is360, randomid are preset parameters, and user time can use any parameter in addition in definition, and are using by the mode of parameter name in SQL or joint investigation address, during call stored procedure;
(4) node control of authority
Because 360 ° of tree view data are comprehensive, some enterprise's sensitive data needs authorization control, when definition view node, by whether using control authority, and arranges after the authorized person that this node is corresponding, and system is shown no node according to control of authority.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410379211.0A CN104133900A (en) | 2014-08-04 | 2014-08-04 | Definition description method of 360-degree treeview |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410379211.0A CN104133900A (en) | 2014-08-04 | 2014-08-04 | Definition description method of 360-degree treeview |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104133900A true CN104133900A (en) | 2014-11-05 |
Family
ID=51806578
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410379211.0A Pending CN104133900A (en) | 2014-08-04 | 2014-08-04 | Definition description method of 360-degree treeview |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104133900A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105808413A (en) * | 2016-03-02 | 2016-07-27 | 上海新炬网络信息技术有限公司 | Business process visualization based SQL performance monitoring method |
| CN106293928A (en) * | 2015-06-05 | 2017-01-04 | 阿里巴巴集团控股有限公司 | A kind of overall situation task node dependence method for visualizing, device and system |
| CN106802797A (en) * | 2016-12-28 | 2017-06-06 | 微景天下（北京）科技有限公司 | The generation method and device of a kind of application programming interface |
| CN108733709A (en) * | 2017-04-21 | 2018-11-02 | 国家计算机网络与信息安全管理中心 | Method, apparatus and computer storage media for information management |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1801151A (en) * | 2005-01-05 | 2006-07-12 | 微软公司 | Object model tree diagram |
| US20100037203A1 (en) * | 2008-08-11 | 2010-02-11 | International Business Machines Corporation | Dynamic Highlighting of Related Artifacts in a UML Diagram |
| US20100083172A1 (en) * | 2008-10-01 | 2010-04-01 | International Business Machines Corporation | Method and system for generating and displaying an interactive dynamic list view of multiply connected objects |
| CN102096711A (en) * | 2011-01-24 | 2011-06-15 | 四川长虹电器股份有限公司 | Method for constructing tree structural directory in database |
| WO2014070165A1 (en) * | 2012-10-31 | 2014-05-08 | Hewlett-Packard Development Company, L.P. | Executable software specification generation |
-
2014
- 2014-08-04 CN CN201410379211.0A patent/CN104133900A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1801151A (en) * | 2005-01-05 | 2006-07-12 | 微软公司 | Object model tree diagram |
| US20100037203A1 (en) * | 2008-08-11 | 2010-02-11 | International Business Machines Corporation | Dynamic Highlighting of Related Artifacts in a UML Diagram |
| US20100083172A1 (en) * | 2008-10-01 | 2010-04-01 | International Business Machines Corporation | Method and system for generating and displaying an interactive dynamic list view of multiply connected objects |
| CN102096711A (en) * | 2011-01-24 | 2011-06-15 | 四川长虹电器股份有限公司 | Method for constructing tree structural directory in database |
| WO2014070165A1 (en) * | 2012-10-31 | 2014-05-08 | Hewlett-Packard Development Company, L.P. | Executable software specification generation |
Non-Patent Citations (1)
| Title |
|---|
| 众一煤化有限公司: "众一煤化有限公司ERP软件操作说明", 《百度文库HTTP://WENKU.BAIDU.COM/VIEW/A9ACDBCB49649B6648D74741.HTML?FROM=SEARCH》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106293928A (en) * | 2015-06-05 | 2017-01-04 | 阿里巴巴集团控股有限公司 | A kind of overall situation task node dependence method for visualizing, device and system |
| CN106293928B (en) * | 2015-06-05 | 2020-04-14 | 阿里巴巴集团控股有限公司 | Global task node dependency relationship visualization method, device and system |
| CN105808413A (en) * | 2016-03-02 | 2016-07-27 | 上海新炬网络信息技术有限公司 | Business process visualization based SQL performance monitoring method |
| CN106802797A (en) * | 2016-12-28 | 2017-06-06 | 微景天下（北京）科技有限公司 | The generation method and device of a kind of application programming interface |
| CN108733709A (en) * | 2017-04-21 | 2018-11-02 | 国家计算机网络与信息安全管理中心 | Method, apparatus and computer storage media for information management |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102471165B1 (en) | Systems and methods for identifying process flows from log files and visualizing the flow | |
| US20210149553A1 (en) | Digital processing systems and methods for real-time resource and capacity allocation in collaborative work systems | |
| US20210112047A1 (en) | Dynamic, customizable, controlled-access child outcome planning and administration resource | |
| De Francisci Morales | SAMOA: A platform for mining big data streams | |
| US10740482B2 (en) | Method for sharing multiple data items using a single URL | |
| US9614880B1 (en) | Methods for real-time notifications in an activity stream | |
| CA2754422C (en) | Electronic process-driven collaboration system | |
| US9495282B2 (en) | Method and systems for a dashboard testing framework in an online demand service environment | |
| US11138216B2 (en) | Automatically invoked unified visualization interface | |
| CN106062806A (en) | Utilizing interactivity signals to generate relationships and promote content | |
| CN104133900A (en) | Definition description method of 360-degree treeview | |
| CN110609840A (en) | User information screening method, device and equipment | |
| CN109002440A (en) | Method, apparatus and system for big data multidimensional analysis | |
| CN114357041B (en) | Industrial data asset publishing method and device | |
| US20240070347A1 (en) | Dynamic asset management system and methods for generating interactive simulations representing assets based on automatically generated asset records | |
| Chourasia et al. | SeedMe: Data Sharing Building Blocks. | |
| US10319049B2 (en) | Re-sharing media content on a network | |
| CN107729394A (en) | Data Mart management system and its application method based on Hadoop clusters | |
| US20220351237A1 (en) | A computer implemented platform for advertisement campaigns and method thereof | |
| US20210232548A1 (en) | Dynamic asset management system and methods for automatically tracking assets, generating asset records for assets, and linking asset records to other types of records in a database of a cloud computing system | |
| US11244019B2 (en) | Enrichment of user specific information | |
| Choi et al. | Conceptual group activity recognition model for classroom environments | |
| Altmanninger et al. | A categorization for conflicts in model versioning | |
| CN106600157A (en) | Integration method of informational data | |
| US11449510B1 (en) | One way cascading of attribute filters in hierarchical object models |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20141105 |