Platform business data access control

1. Concept Introduction

Business data permission control refers to controlling the data display in the business table in the platform project management through variable forms such as personnel ID and department ID.

As shown below:

Figure 1: You can only view your own registered data.

Figure 2, you can view the data of the whole department;

Figure 3. You can view the data of the whole hospital.

2. implementation method

To control business data permissions, you first need to add personnel ID, department ID, etc. to the database, then add variables such as personnel ID and department ID to the business table, and finally set the variable value of the business table in the loading event of the form.

Add the personnel ID and department ID fields to the database, and set the default values. Find the corresponding login user ID() or login user department ID() in the client environment. After setting here, after the form is added and saved, the default value will be automatically saved into the database.

You can only view the data registered by yourself: first set the person ID variable in the business table, and then set the business table variable value in the event management of the form.

View the entire department data: first set the department ID variable in the business table, then set the business table variable value in the event management of the form, load the event.

Original address: http://bbs.delit.cn/thread-1102-1-1.html

Please indicate the source:

Author; Metrology www.delit.cn