Quick Development Platform for measurement (create data tables and business tables)

In a twinkling of an eye, I have been working in measurement for 20 days. In these 20 days, there are not many, but some gains.
In the last 10 days, I learned how to familiarize myself with the quick open platform, read the documentation, and listen to my colleagues. I will do exercises for ten days,
I am almost familiar with this platform, so I have to say it is powerful.
I. Platform Introduction
The quick development platform is mainly divided into two modes. One is the engine mode and the other is the source code generation mode. Both modes are used in the measurement quick development platform, but the source code generation mode is different in the measurement quick development platform, which greatly improves the efficiency.
No matter how we build an application on the platform (developed on the platform as we call it) (on the platform, we call functional modules built based on actual business as applications ), in the end, we want users to use it. That is to say, users need to have a place to open the applications we have built on the platform, therefore, the measurement quick development platform is implemented by configuring menus (of course, each menu configured is controlled by permissions), and each menu corresponds to an application. Every menu configured on the platform is an application built on the platform in different modes. Then, I divide the build mode in the platform into the following five modes: intelligent form development, form workflow development, advanced workflow development, report development, and extended development
2. Database Maintenance (database)
We all know that to create a form that requires a database, this database maintenance is used to create a data table. In the development tool of the platform, the name of a menu is "database maintenance". Right-click the default menu to create a table.

 

When we configure a data table under database maintenance, there are two columns: "field name" and "actual name" (for example ):

　　Field name: That is, the alias of the data table field (alias). When a business table is set in the platform building, the system displays the field alias, of course, the premise is that the SQL statement in the set business table does not use the keyword "as" to rename the alias again.

　　ACTUAL NAME: That is, the table field name. For example, if you write an SQL statement, you must use this name for query.

The data table is created in this way.

3. Business table maintenance (Business table)　　

This concept is very important, because we will certainly be very ordinary in the construction of the platform. People with development experience know that when we are using some controls for development, some controls need to be bound to data sources, such as the gridview grid control we use, it needs to specify a data source, that is, bind a able. The principles in the platform are similar. All components (components that need to be bound to a business table in the platform, and components that are not bound to a business table are called controls) also need to be bound to a data source, however, the platform is called binding a business table. Each business table is composed of an SQL statement. This SQL statement can be complex or simple. The platform will obtain a datatable through this SQL statement query, then the datatable will be bound to the part.

In other words, a business table is a container for installing SQL statements. When parts are bound to a business table, the table structure and content are queried Based on the SQL statements in the business table and displayed on the automatically generated interface. Create a business table ()

Click Save.

Business tables are also divided into read-only business tables and read/write business tables ".

Read-only business tableThat is, data write operations cannot be performed based on the service only for query purposes. For example, if you use the savedata method in the parts bound to a read-only business table, an error is returned. Generally, you can customize more complex SQL statements for such business tables.

Read/write business table: Queries and writes data. For example, you can directly call the savedata method in the part bound to the read/write business table to submit the data on the interface to the database table. Generally, this type of business tables operate on a data table and automatically generate SQL statements by checking the interface, which is not allowed to be customized.

After creating both the data table and business table, you can create a form below.