CN108509554B

CN108509554B - Method for rapidly generating tissue architecture diagram based on WPF technology and EXCEL

Info

Publication number: CN108509554B
Application number: CN201810238488.XA
Authority: CN
Inventors: 李立
Original assignee: Vtron Software Nanjing Co ltd
Current assignee: Vtron Software Nanjing Co ltd
Priority date: 2018-03-22
Filing date: 2018-03-22
Publication date: 2022-03-01
Anticipated expiration: 2038-03-22
Also published as: CN108509554A

Abstract

The invention discloses a method for quickly generating an organization architecture diagram based on a WPF technology and an EXCEL, which belongs to the technical field of electronic maps and comprises the steps of establishing an organization structure detail of an EXCEL list mode, displaying organization relation data of the organization structure detail in a TreeeView control according to a hierarchical tree form, generating a simulation sample diagram by a Canvas technology and a Thumb technology in the WPF, adding an editing function to the TreeeView control in a WPF server, and converting the Canvas finally generated by the WPF into a jpg graph for subsequent communication or printing.

Description

Method for rapidly generating tissue architecture diagram based on WPF technology and EXCEL

Technical Field

The invention belongs to the technical field of internet, and particularly relates to a method for rapidly generating a tissue architecture diagram based on a WPF (wavelet packet Filter) technology and EXCEL (EXCEL).

Background

When the personnel management department makes an organizational chart, the personnel management department adds the software which can support drawing, such as Office series software, Visio, Xmind and the like, according to the organizational structure manually one by one. This approach generally results in no problems in completing the fabrication. However, if a lot of organizational charts need to be prepared or the internal structure of a single organization changes greatly, the pictures need to be modified one by one, which is very inefficient and prone to errors.

Disclosure of Invention

The invention aims to provide a method for rapidly generating an organizational structure diagram based on a WPF (wavelet packet Filter) technology and EXCEL (EXCEL), and the technical problem of rapidly generating the organizational structure diagram is solved.

In order to achieve the purpose, the invention adopts the following technical scheme:

a method for rapidly generating a tissue architecture diagram based on WPF technology and EXCEL comprises the following steps:

step 1: establishing a database server and a WPF server, wherein the database server is communicated with the WPF server through a network cable;

step 2: establishing an organization structure detail in a database server, wherein the organization structure detail is an Excel list mode;

and step 3: the WPF server calls an organization structure detail in the database server, the organization structure detail in the Excel list mode is accessed and read by using the WPF, and organization relation data of the organization structure detail is displayed in the TreeeView control according to a hierarchical tree;

and 4, step 4: the WPF server generates a simulation sample graph by utilizing a Canvas technology and a Thumb technology in the WPF according to the hierarchical tree structure;

and 5: adding an editing function to the TreeeView control in the WPF server, so that the organization relation data can be reversely written back into an Excel file;

step 6: and adding an export function to the TreeeView control in the WPF server, and converting the Canvas finally generated by the WPF into a jpg graph for subsequent communication or printing.

When step 2 is executed, a Config file is preset, an Excel column header field relation table is defined in the Config file, and then Excel details are strictly referred to the specification to enter basic data.

Default pattern links at each level are defined and organized in the Config file so that a user can select a default level pattern by himself.

According to the method for rapidly generating the tissue architecture diagram based on the WPF technology and the EXCEL, the architecture diagram is generated very rapidly, and the tissue architecture diagram can be generated rapidly as long as an organization structure list is maintained in the EXCEL.

Drawings

FIG. 1 is a flow chart of the present invention;

fig. 2 is a resulting tissue architecture diagram of the present invention.

Detailed Description

Fig. 1 is a method for rapidly generating a tissue architecture diagram based on WPF technology and EXCEL, comprising the following steps:

establishing a Config file, defining an Excel column header field relation table in the Config file as shown in a table 1, and then strictly referring to the specification by Excel detail and inputting basic data;

TABLE 1

And step 3: the WPF server calls an organization structure detail in the database server, the organization structure detail in the Excel list mode is accessed and read by using the WPF, and organization relation data of the organization structure detail is displayed in the TreeeView control according to a hierarchical tree; the method comprises the following specific steps:

step A1: storing the organization relation in the Excel into a uniform organization structure object according to the hierarchy, and executing the read structure logic according to the definition in the Config file;

step A2: and displaying the control in a TreeeView control in a hierarchical tree form by utilizing the WPF bidirectional binding.

And 4, step 4: the WPF server generates a simulation sample graph by utilizing a Canvas technology and a Thumb technology in the WPF according to the hierarchical tree structure; the method comprises the following specific steps:

step B1: defining and organizing default pattern links of each level in a Config file so that a user can select a default level pattern by himself;

step B2: defining a TabControl, and adding a Canvas as a sub-tab of the TabControl according to a selected node level in a TreeeView double-click event to display an organization architecture diagram of the current selected level;

step B3: and (3) using a recursive algorithm to place each node element of TreeeView into a Canvas as a Path, defining a connection class, and binding a father node and a child node by using a connection line so as to facilitate subsequent dragging adjustment. Default node pattern of the generated graph to be a picture pointed by an Excel photo link, and otherwise, capturing a pattern configured by a Config file;

step B4: a drag class Dragthumb is defined, inherited from Thumb. Capturing the latest position of a mouse in a DragDelta event of Dragthumb, calling a SetTop and SetLft method of Canvas, and moving a dragged element to a new position to finish a dragging function;

step B5: in order to ensure that the automatically generated organizational chart can be readjusted, adding common editing functions such as cutting, copying and pasting, and binding corresponding execution actions and operable time by using a Command Command;

step B6: and adding a search box so as to quickly locate a certain hierarchical organization and a certain specific person.

And 5: adding an editing function to the TreeeView control in the WPF server, so that the organization relation data can be reversely written back into an Excel file; the method comprises the following specific steps:

step C1: by utilizing a WPF (WPF) bidirectional binding technology, common editing operations of adding, modifying and deleting organizational structure objects are completed in TreeeView related events;

step C2: and storing the latest organization structure object into Excel.

Step 6: adding an export function to a TreeeView control in a WPF server, and converting Canvas finally generated by the WPF into a jpg graph, wherein the Canvas is a Canvas technology in a Net WPF development platform for subsequent communication or printing, and the specific steps are as follows:

step D1: establishing a virtual Canvas object DrawingVisual, and using the DrawingContext object to re-compose Canvas and objects in the Child on the DrawingVisual virtual Canvas on the basis of the virtual Canvas object DrawingVisual; creating a RenderTargetBotmap instance, and introducing the width, height and pixel values of a canvas into the RenderTargetBotmap as constructor parameters of the RenderTargetBotmap, wherein the pixel format adopts PixelFormat. Pbgra32; then calling a Render method of the object and transmitting the Render method into a drawingVisual;

step D2: a bitmap Encoder object is defined, and a Jpegbitmap Encoder instance is created to be used as the final graphic output.

Claims

1. A method for rapidly generating a tissue architecture diagram based on WPF technology and EXCEL is characterized in that: the method comprises the following steps:

and 4, step 4: the WPF server generates a simulation sample graph by using a Canvas technology and a Thumb technology in WPF according to a hierarchical tree structure, and the specific steps are as follows:

step B3: using a recursive algorithm to place each node element of TreeeView into a Canvas as a Path, defining a connection class, and binding a father node and a child node by using a connection line so as to facilitate subsequent dragging adjustment; default node pattern of the generated graph to be a picture pointed by an Excel photo link, and otherwise, capturing a pattern configured by a Config file;

step B4: defining a drag class Dragthumb, inherited from Thumb; capturing the latest position of a mouse in a DragDelta event of Dragthumb, calling a SetTop and SetLft method of Canvas, and moving a dragged element to a new position to finish a dragging function;

step B6: adding a search box to facilitate quick positioning to a certain hierarchical organization and a certain specific person;

and 5: adding an editing function to the TreeeView control in the WPF server, and reversely writing the organization relation data back into an Excel file;

step D1: establishing a virtual Canvas object DrawingVisual, and using the DrawingContext object to re-compose Canvas and objects in the Child on the DrawingVisual virtual Canvas on the basis of the virtual Canvas object DrawingVisual; creating a RenderTargetBotmap instance, and introducing the width, height and pixel values of a canvas into the RenderTargetBotmap as constructor parameters of the RenderTargetBotmap, wherein the pixel format adopts PixelFormat. Pbgra32; then calling a Render method of the object and transmitting DrawingVisual;

2. The method for rapidly generating the organizational structure chart based on the WPF technology and the EXCEL is characterized in that when the step 2 is executed, a Config file is preset, an EXCEL column header field relation table is defined in the Config file, and then EXCEL details are strictly referred to the specification to enter basic data.