Operator table has a subordinate departments, PB code below

Select the x2. OfficeName into # OfficeName
DictOffice from DictOper x1, x2
Where the x1. OfficeId=x2. OfficeId
. And the x1 OperId=
Dw_main. Setfilter (" officename='" + (current login department parameters) + "' ")
Dw_main. Filter ()

Behind the operid=to a parameter, and found out the current department want to use a parameter, said is not here, o master,

CodePudding user response:

Define a global variable gs_branch login application directly to the employee's department when I was assigned to gs_branch, so where is all can use gs_branch directly,

CodePudding user response:

Build a structrue str_sys_login, for example, public variables declared in str_sys_login sys_logon, when logging in all the information you need to put in to this sys_logon, such as sys_logon. Empid=ll_login_empid, so need to use directly for sys_logon of values, such as sys_logon. Empid,

CodePudding user response:

Define a global variable gs_login_id

When the query can use gs_login_id filter conditions