Managing Software Development-Tools

Management software, especially the software that interacts closely with the DB, usually extracts data from the DB, performs operations on the front-end UI interface, and then saves the data to the DB. of course, the process is very complicated, and we have made it very clear. from zeroCodeIt is also possible to develop and gradually accumulate to form your own class libraries, method sets, or frameworks. if there is assistance with auxiliary development tools, the development efficiency will certainly get twice the result with half the effort. this section mainly discusses auxiliary development tools.

First, we will deal with the database, which involves database creation, backup and restoration, database object creation and maintenance, data import and export, and generation of SQL statements, it must support multiple databases. currently, SQL Server-Supported tools are SQL Server 05 or 08 query analyzer. PL/SQL is supported for Oracle. These tools need to be integrated, it is convenient for us to operate a variety of databases at the same time.

Auxiliary Tool Name	DBAdministrative Analyzer
Basic functions	1.Support DBCreate and DBObject creation and maintenance,Data Import and Export, SQLStatement generation 2.Like sqlserverQuery analyzer,Support for OracleDB
Extended Functions	1.Self-powerdesignerFile generation DBObject Structure 2.DBObject,Mainly table objects,Generate object files

After the DB object is created successfully, we need to maintain the data on the front-end, that is, the creation of the UI interface. the traditional method is to generate a webform/winform page in the vs development environment, drag the control to it, and write code in the background for the control to bind and obtain data and perform data operations. if a system has many modules and each module contains many pages, this method will increase the workload, that is, too much repetitive work. therefore, it is best to have a tool to quickly generate the UI and bind and obtain the control values.

auxiliary tool name	UI designer
basic functions	1. according to DB table/ View, Generate the UI interface. you can adjust the widget location, size and other attributes. the bound data in the drop-down menu can be dynamically modified 2. Based on the entity class, Generate the UI interface, Functions
extended functions	1. multiple databases table/ View, can be generated to the same UI interface, that is, data on the UI , it may involve multiple databases tables or entities 2. supported design methods A) drag-and-drop, Microsoft vs environment mode B) word file generation table, Add the control keyword mode in the table C) dB the table generates WORD Based on the column name in sequence document

After the UI is designed, You need to perform operations on this page. during the operation, the same page may be operated by multiple users, that is, each person only completes some of the operations on the page. this requires the workflow to complete this operation. the function of a workflow can be used to sort out the business process, that is, to determine the next operator of a business document, or to determine which business documents can be operated by an operator.

Auxiliary Tool Name	FlowProcess designer
Basic functions	1.Determine which operators maintain a document 2.Which business documents constitute a business scenario,How to allocate each business document
Extended Functions	1.Business processes can be monitored,View the status of each business flow 2.Operation logs for each business flow

The UI Designer only completes interface generation, and collects and assigns values to simple control values. whether the Execution Code of an event in the UI page can also be completed through the designer. for example, in the page_load event, we may perform the following operations:

I. Bind the drop-down menu control data

Ii. Set the initial value of the control.

Iii. Based on the page editing type, if it is update or view, you need to load data from the DB and bind it to the control

The above steps are only the Execution Code logic of an event on the entire page. If there is a graphical event designer to define these operation steps, that is, the above Code is implemented by dragging the control, instead of writing code manually. the work efficiency will be significantly improved. there is a problem to consider: granularity of event division. it will directly affect the complexity and difficulty of the event rule designer.

auxiliary tool name	event rule designer
basic functions	1. determine the events that can be executed on a page 2. define the process of each event. this means that you do not write code, graphic design
extended functions	1. graphic design of business rules, example: drop-down menu control on the foreground page, data needs to be bound. This is a method. it can also be considered as a business rule, it obtains data from DB and binds the data to a drop-down menu, at the same time, define the data column and display column name. this operation can also be graphically designed

For data that has been saved to the database, you must not only maintain (cuid) operations, but also perform statistics and analysis on the data. That is, you must present the data in another way, that is, the report, such as the input sales order data, we need to analyze the order to find out which products are easy to sell and which products have higher unit prices. this also requires a flexible design tool, namely the report designer. besides data, charts, such as bar charts and pie charts, must also be supported. at present, rldc is a good stuff, and Microsoft is also pushing this technology.

Auxiliary Tool Name	Report designer
Basic functions	1.Regular reports,It can be implemented through the designer,Including data retrieval,Data Presentation Methods 2.Provides a wizard,RldcFile
Extended Functions	1.WebformAnd winformThe report designer can share a set

Most of the system data is stored in a database or a file. Sometimes it needs to be printed and saved in paper. this involves printing data. the printing format also needs to be adjusted frequently. If the adjustment is frequently adjusted by the developer to modify the code, the work efficiency will be reduced a lot. If a graphical printing designer is provided, this problem can be solved, it is best to support multiple software types such as webform and winform at the same time

Auxiliary Tool Name	Print designer
Basic functions	1.The print format can be adjusted as needed,Widget location changes do not need to be implemented by code modifications 2.WebformAnd winformTwo types of printing
Extended Functions

The above is a summary of each auxiliary development tool.ArticleEvery tool will be described in more detail, so stay tuned!