Add fields to the Tongda oa announcement management module and extract some information to the intermediate table. The oa Fields

Add fields to the Tongda oa announcement management module and extract some information to the intermediate table. The oa Fields

In this case, the basic data input control is used, and the Selection Component and date Selection Component of OA are used. Using the built-in components of the system has great advantages, the biggest benefit is to form a whole with the original program, which is much easier to write and can be called directly.

Effect of adding a field:

Fields added to the data table:

To facilitate field differentiation, you can mark the added fields separately with some identifiers to avoid confusion.

SQL is relatively simple, because only a few fields are added, corresponding to the SQL insert statement. The key of this program is to display the field control on the foreground page and combine it with the OA control.