Platform Business Data Permission control

1. Concept Introduction

Business Data permission control, refers to the platform project management inside the business table, through the Personnel ID, Department ID and other variables form, to control the data display.

As shown in the following:

Figure one, can only view their own registered data;

Figure Two, you can view the entire department of data;

Figure three, you can view the whole hospital data.

650) this.width=650; "id=" aimg_1769 "src=" http://bbs.delit.cn/data/attachment/forum/201606/28/ 152145realjp33jwqrqepe.png.thumb.jpg "width=" "height=" 165 "alt=" 152145realjp33jwqrqepe.png.thumb.jpg "/>

650) this.width=650; "id=" aimg_1770 "src=" http://bbs.delit.cn/data/attachment/forum/201606/28/ 152147l0f0iwzybkk30fww.png.thumb.jpg "width=" 399 "height=" 163 "alt=" 152147l0f0iwzybkk30fww.png.thumb.jpg "/>

650) this.width=650; "id=" aimg_1771 "src=" http://bbs.delit.cn/data/attachment/forum/201606/28/ 152148bqfbpe4bssfvf0ze.png.thumb.jpg "width=" 399 "height=" 155 "alt=" 152148bqfbpe4bssfvf0ze.png.thumb.jpg "/>

2. Implementation methods

To achieve the control of business data permissions, the first need to add personnel ID, Department ID, and so on the business table, variable personnel ID, Department ID and other variables, and finally in the form of load events set the business table variable value.

The database increases the Person ID, Department ID field, and sets the default value, locates the appropriate login user ID () in the client environment, or logs in to the User Department ID (). Once this is set up, the form will automatically save the default values of the settings to the database.

650) this.width=650; "id=" aimg_1772 "src=" http://bbs.delit.cn/data/attachment/forum/201606/28/ 152155y3s7161551n0n8sn.png.thumb.jpg "width=" "height=" 147 "alt=" 152155y3s7161551n0n8sn.png.thumb.jpg "/>

650) this.width=650; "id=" aimg_1773 "src=" http://bbs.delit.cn/data/attachment/forum/201606/28/ 152202irp44upwprgunamz.png.thumb.jpg "width=" 399 "height=" alt= "152202irp44upwprgunamz.png.thumb.jpg"/>

You can only view your own registered data: first set the staff ID variable in the business table, and then in the form of event management, the Load event sets the value of the business table variable.

650) this.width=650; "id=" aimg_1774 "src=" http://bbs.delit.cn/data/attachment/forum/201606/28/ 152209xho3d2pj3uejhc4u.png.thumb.jpg "alt=" 152209xho3d2pj3uejhc4u.png.thumb.jpg "/>

650) this.width=650; "id=" aimg_1775 "src=" http://bbs.delit.cn/data/attachment/forum/201606/28/ 152212vkf6md06u0a7oddm.png.thumb.jpg "alt=" 152212vkf6md06u0a7oddm.png.thumb.jpg "/>

View data for the entire department: first set the Department ID variable in the business table, and then in the form of event management, the Load event sets the value of the business table variable.

650) this.width=650; "id=" aimg_1776 "src=" http://bbs.delit.cn/data/attachment/forum/201606/28/ 152214vgyham2nyb2bvmat.png.thumb.jpg "alt=" 152214vgyham2nyb2bvmat.png.thumb.jpg "/>

650) this.width=650; "id=" aimg_1777 "src=" http://bbs.delit.cn/data/attachment/forum/201606/28/ 152217p8fpgcdp9gddgin9.png.thumb.jpg "alt=" 152217p8fpgcdp9gddgin9.png.thumb.jpg "/>

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

Reprint please specify the source:

The http://www.delit.cn of measuring science and technology

Platform Business Data Permission control