Paper Menu >>
Journal Menu >>
Engineering, 2013, 5, 928-932
Published Online December 2013 (http://www.scirp.org/journal/eng)
Open Access ENG
Research and Development on the Visualization System for
Official and Scientific Management in Enterprise
Changhua Huang1,2, Guyong Han1, Man Liu3, Song Lu1
1Department of Air Force Service, Air Force Logistics College, Xuzhou, China
2School of Marine Engineering, Northwestern Polytechnical University, Xi’an, China
3Basic Department, Air Force Logistics College, Xuzhou, China
Email: firstname.lastname@example.org, email@example.com
Received June 12, 2013; revised July 12, 2013; accepted July 19, 2013
Copyright © 2013 Changhua Huang et al. This is an open access article distributed under the Creative Commons Attribution License,
which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
A visualization system for the official and scientific management has been design ed on C++. By this system, the infor-
mation of database has been shown to users intuitively, which makes it possible for users to be free from the data sea.
The system can realize the information mining and the integrated display, at the same time, improve the information’s
constructive level and integration degree.
Keywords: Scientific Research; Official Management; Informational Visualization; Database
Nowadays, enterprise is being influenced by information
technology thoroughly. Along with the enhancement of
informational level of the enterprise, various data of
man ageme nt systems are widely applied in the enterpri se.
Massive historical data in system are accumulated.
In face of the mass of data, customers often fail to find
the data they want. By visualization technology, one can
extract the needed data from various data systems, and
display it in an integrated interface via graphics, tables
and other forms intuitively.
In , Qian Zh u puts forward a PDM system of en ter-
prise based on traditional PDM and web graph files for
SQL Server 2000.
Concerning database security protection mechanism,
Xianzhong Chen an d Jian Zhang present several solu tion
schemes for the authentication .
In this paper, we analyze the digital situation of the
enterprise and the key technology for visualization. We
can complete the visualization systems’ development by
using C++ Builder. The enterprise information’s construc-
tion level and integration degree are improved obviously.
2. Overall Design of System
After user installed the visual management system, at
first the system will verify identity of user, if the identity
is correct, then the system allow to enter. Visual man-
agement system connect enterprise database server by the
enterprise network, and visit and dispose data informa-
tion in the database, at last will return to the visual man-
agement system, then realize the display of visualization
in the enterprise database. The total flow frame diagram
of system information is shown as Figure 1.
3. The Realization of Database Management
The database management system is based on SQL
Server 2000 and SQL Server 2005, to make sure the ap-
plication program and the database can communicate
with each other, some configuration should be made, for
our system the PDM (Product Data Management) data-
base is SQL Server 2000 system, BPM (Business Process
Management) database is SQL Server 2005 system. Ac-
cording to the actual situation, we use BDE (Borland
Database Engine)) controller of C++ Builder to visit
PDM database, using ADO (Active Data Objects) data-
base to visit BPM control. ADO can visit database by
OLE (Object Linking and Embedding) DB (database),
but the path of the datab ase file must be known. If enter-
prise database stored on the different servers, it is incon-
venient to obtain the file path and is liable to let out the
secret. According to the actual situation of businesses we
decided to access database by the ODBC（Open Databa se
Connectivit y）using ADO. BDE control is simpler to
connect database, here we mainly introduce the configu-
C. H. HUANG ET AL. 929
ration of ADO control connecting to ODBC of the data-
base, which is as follows:
1) Open “control panel” of the operation system, find
the “management tools”, it provides the ODBC data
source manager. Open the “data sources (ODBC)”, add
the data source in “system DNS” page, the data source
program interface appears in Figure 2, next we choose
SQL Server drive for database system.
2) Choose the driver, click “finish” button, then the
interface as shown in Figure 3 will appear, named the
new data source (here named Workflow), and select the
3) After finishing the database configuration, create
two database ZF_PDM and ZF Workflow in BDE Ad-
ministrator which build in C++ Builder. Set SERVER
Figure 1. The flow frame diagram of system information.
Figure 2. Choose data source program interface.
Figure 3. Establish data source.
NAME, DATABASE NAME, USER NAME. “SERVER
NAME” is the server name or IP address which will be
connected. DATABASE NAME is database name on the
server which will be connected. USER NAME is the
name of the user, generally set as “SA”. After setting,
right-click the new database, click “Apply”. Then click
the new database, connect database, when the database
connects successfully, we can use the BDE control and
ADO controls of C++ Builder to op erate the database.
4) When completed the above settings, we can access
the database via BDE control. Because the system is
complex, here we introduce setting of the attribute for
each control. Alias Name of Database control is set as
ZF_PDM, Database Name is set as ZF_PDM1; Database
Name of Query control is set as ZF_PDM1, the SQL
statement is stored in SQL; Data Se of Data Source con-
trol is set as Query; Data Source of DB-Grid control is
set as Data Source; Thus DB-Grid accessing database are
5) Connect ADO control to database
Double click “TADO Connection “controller, choose
“Microsoft OLE DB Provider for SQL Server” in the
“OLE DB Provider”. Then input the address of the con-
nected server in the “choice or input server name”, input
the user name and password, choose the database in the
server, and test until connect successfully. It is shown in
Connection of ADO Query control is set as TADO
Connection, store the needed implement SQL statement
in SQL attribute, Data-Set of Data-Source control is set
as ADO-Query; Set Data Source of DB-Chart control to
visit the database, and can be shown by chart.
Figure 4. Data connecting attribute set.
Open Access ENG
C. H. HUANG ET AL.
4. System Implementation
4.1. Detailed Design and Implementation of User
The user should input “user’s name” and “password”,
after logining successfully, the user can use any functions
of the system. Login interface control processes is shown
as Figure 5.
This system will save the user’s name and password to
the text document in the folder of system program, and
when the program is started, at first read the user’s name
and password from file, and judge whether the user’s
name and password are correct.
Logining to the main login interface of the system
needs to realize the function:
1) Extracting user name and password from the spe-
cific file, and test and verify if the information is correct.
2) Changing password.
Here we detailed the code that verifying the user’s in-
put information. There are two steps: extract the user
name, password and verify information that the user in-
put. The part of the code is as fo llows:
a) Extracting user name and password, the default user
name is Administrator, only extracting password, the
program code is shown as Table 1.
b) Verify the information code user input (can cut), it
is shown as Table 2.
4.2. Achievement of Visualization Office
The design and realization of visualization office sub-
Input the user
name and password
The user file
Figure 5. System login interface control flow program.
Table 1. Extracting password program code.
Dir=Get Current Dir();
aPwd=new string List ();
aPwd->Load From File (Dir+"\\PassWord\\PassWord.txt");
Table 2. verify information code user input.
void __fastcall TForm1::Button1Click( TObject *Sender)
Application->MessageBoxA("user name and password
are error","input error",MB_OK);
system start with the perspective of th e user, then provid e
visual display of information to the user from various
angles. According to the system framework and function
design of visual office management, it includes the proc-
ess status, process statistics, examining the process, the
realization of the function is as follows:
To-do and already do flow number statistics of each
ministry departments, each place class departments,
all the leaders and all staff, and list its detailed infor-
mation by chart;
Examining each departments, all the leaders and all
staff’s points and work contents;
Generate flow diagram of various process, display the
process of real-time dynamically state;
Display the used process templates and template
In order to realize the above function, we need to de-
sign the visual management subsystem in office in detail,
at the same time we design related content for its every
sub-module. After negotiating with the enterprise, and
build up the detailed frame diagram of the visualization
management subsystem in office finally, it can refer to
the Figure 6.
All the detailed process of information are stored to
the database of enterprise, it includes the subordinate
departments, and launched department, approver and so
on. Flow state module mainly use histogram to statistics
the completion of every department what belongs to (to-
tal flow number, pending flow number and done flow
number), the user can see what department operates good
from the process. Then show the detailed information of
each ministry departments, place class department and
leadership in enterprise they examine and approve, the
user can see the detail process that has been approved by
department or examined by leaders. Click a process in
the process list for details, then show the process of
real-time dynamic flow chart. According to it the user
can monitor the state of process. From this part the lead-
Open Access ENG
C. H. HUANG ET AL. 931
Off i cial management
Process stateProcess statisticsProcess inspection
Pending already do
Process sta tistics
Process for details
Integral sta tis tics
The leader assessment
Figure 6. Detailed frame diagram of the visualization man-
agement subsystem in office.
ers may see the completed process of departments in en-
terprise, and the operation of the process they concerned.
For example, click “administrative affairs” and show
subordinate departments. List all processes that had been
examined an d approved on right hand.
4.3. Statistics of Process
The statistical process module mainly statistics each de-
partment and enterprise personnel (leaders and employ-
ees) had examined and approved the quantity of process
information, including the total flow number, approval
batch number and no approval batch number. The user
can see the task and completed situation of each depart-
ment and enterprise. Time control restrict time, make a
list of the use of flow of templates in the limited time,
and statistics the number of times, display the detailed
information of process instance within the given time.
Let the user see the process te mplates that had been used
by enterprises often and not often, it is convenient for
user to modify the process template.
Convenient to operate, we adopt the methods of dis-
playing layer by layer. Click the ministry departments,
display the data of statistical information that has been
examined and approved by ministry department and its
subordinate place class department. Click the place class
department, display the process of statistical information
that has been examined and approved by leadership and
staff of place class department. For example, click “cen-
ter of information”, show the process of statistical infor-
mation that has been examined and approved by place
class department leadership Wang** and liu king**, as
well as other employees Wan** and Mu**, etc., it is
shown as Figure 7.
This module statistics the information of working in-
tensity of each department and personnel in enterprise,
statistics assessing score of each department and each
enterprise personnel on the base of the information in the
database. Click “processing evaluation” and enter into
the process of assessing page.
Figure 7. Count the process examined and appr oved by de-
4.4. The Realization of Visual Scientific Research
Management subsystem of scientific research mainly
shows two projects including the product and document.
The principle line is project-d ocument-process, users can
understand level relations of the product items, and the
phase the project is in , as well as the process information
such as the number of document and each document’s
state under the project. Management subsystem of scien-
tific research includes two submodule consisting of pro-
duct project and project document, it needs to achieve the
Generate structure tree of product;
Count the number of project, the completion and the
number of project in each technical stage;
Display the detailed informatio n of project;
Count the state of projective program (new, check in,
check out, release);
Display the flow chart under program;
Display the detailed information and record history of
Browse the program document.
In order to realize the above functions, we should de-
sign the visualization research management subsystem in
detail, and design related contents for its every sub-
module, by consulting with enterprise, and finally deter-
mine the detailed frame diagram the visualization re-
search management subsystem.
Product project module shows the hierarchical rela-
tionship by tree structure, so that users can see the prod-
uct structure in database visually, by opening up and
drawing back the product three, and users can complete
series of productive statistics, completed statistics and
marked statistics. Among them, the series of statistics
may count how many projects under each product series.
Completed statistics contrast with the number of total
projects, the number of finished projects and the number
Open Access ENG
C. H. HUANG ET AL.
Open Access ENG
of unfinished projects. Marked statistics count the num-
ber of the project in the various technical phases. When
click one product in the left of product tree, then display
the detailed information under th e project, such as name,
model, stage, date created, founder, etc. Click a certain
project under product tree, then show the detail informa-
tion of the project, such as stage, date created, found, use
and so on.
5. Document of the Project
Project Document reflects the relationship of project-
document-process comprehensively. A project has many
document, each document has the related process. By the
module the number of each project and the key document
can be display explicitly. Each specific document, the
flow chart of each document and the record history can
be browsed too. Among them, the flow chart marks the
process node with four different colors, respectively de-
noting the completed, the ongoing, the former node and
the to-be-done pro cess node, it is easy to know the situa-
tion of the process by the flow diagram.
Figure 8. The document information of project.
BPM database, integrated visualization display of infor-
mation is realized. Thus the leadership can obtain the
concerned information intuitively and be free from the
dilemma of “Be short of useful data by trapped in the
 Q. Zhu, “The PDM ‘System Based on the SQL Server’,”
Master’s Thesis, University of Sichuan, 2005.
Enter into “scientific management”, click “project
documentation” it will display “project documentation”.
The product tree is on the left, all the document statistical
information is on the right, the status of document in-
clude: new, check in, check out, release, shown as Fig-
 X.-Z. Chen and J. Zhang, “Research on the Application
System Based on SQL Server,” Hebei Journal of Indus-
trial Science & Technology, Vol. 20, No. 3, 2003, pp. 10-
Based on the analysis structure of PDM database and