|
1
|
BEGIN TRANSACTION
|
|
2
|
DELETE FROM SYS_PERMISSIONS_PAGE_FOR_USER
|
|
3
|
DECLARE @index_ent INT = 1; -- Set this value as required
|
|
4
|
DECLARE @TLNAME NVARCHAR(255),
|
|
5
|
@BRANCH_ID NVARCHAR(255),
|
|
6
|
@DEP_ID NVARCHAR(255),
|
|
7
|
@ROLE_NEW NVARCHAR(255),
|
|
8
|
@EFF_DATE VARCHAR(50),
|
|
9
|
@EXP_DATE VARCHAR(50),
|
|
10
|
@NOTES NVARCHAR(255),
|
|
11
|
@ROLE_NEW_DISPLAY NVARCHAR(255);
|
|
12
|
|
|
13
|
-- Declare cursor to iterate through the records
|
|
14
|
DECLARE role_cursor CURSOR FOR
|
|
15
|
SELECT A.TLNAME, A.BRANCH_ID, A.DEP_ID, A.EFF_DATE, A.EXP_DATE, A.NOTES
|
|
16
|
FROM TL_SYS_ROLE_MAPPING A
|
|
17
|
LEFT JOIN AbpRoles B ON A.ROLE_NEW = B.DisplayName
|
|
18
|
WHERE A.TLNAME IS NOT NULL
|
|
19
|
AND A.AUTH_STATUS = 'A' AND A.RECORD_STATUS = '1'
|
|
20
|
AND A.ROLE_NEW = 'GDDV'
|
|
21
|
AND A.IS_MAIN = 1
|
|
22
|
OPEN role_cursor;
|
|
23
|
|
|
24
|
FETCH NEXT FROM role_cursor INTO @TLNAME, @BRANCH_ID, @DEP_ID, @EFF_DATE, @EXP_DATE, @NOTES;
|
|
25
|
|
|
26
|
-- Loop through each record
|
|
27
|
WHILE @@FETCH_STATUS = 0
|
|
28
|
BEGIN
|
|
29
|
DECLARE @DONE_INS_APPROVE_GROUP BIT=1, @ERROR_MESS NVARCHAR(MAX);
|
|
30
|
EXEC SYS_PERMISSIONS_PAGE_FOR_USER_Ins_ADMIN 'DuLlieuUyQuyenCu', -- @p_AuthorizedNumber
|
|
31
|
@TLNAME, -- @p_TLNAME
|
|
32
|
@BRANCH_ID, -- @p_BRANCH_ID
|
|
33
|
@DEP_ID, -- @p_DEP_ID
|
|
34
|
51, -- @p_RoleId
|
|
35
|
@EFF_DATE, -- @p_EffectiveDate
|
|
36
|
@EXP_DATE, -- @p_ExpirationDate
|
|
37
|
'', -- @p_Notes
|
|
38
|
'admin', -- @p_MAKER_ID
|
|
39
|
'', -- @p_CREATE_DT
|
|
40
|
'A', -- @p_AUTH_STATUS
|
|
41
|
'admin', -- @p_CHECKER_ID
|
|
42
|
'', -- @p_APPROVE_DT
|
|
43
|
'1', -- @p_RECORD_STATUS
|
|
44
|
'UQ', -- @p_TYPE
|
|
45
|
@DONE_INS_APPROVE_GROUP OUTPUT, -- @DONE_INS_APPROVE_GROUP OUT
|
|
46
|
@ERROR_MESS OUTPUT; -- @ERROR_MESS OUT
|
|
47
|
SELECT @DONE_INS_APPROVE_GROUP, @ERROR_MESS
|
|
48
|
IF @@Error <> 0 GOTO ABORT
|
|
49
|
-- Increment the index
|
|
50
|
SET @index_ent = @index_ent + 1;
|
|
51
|
|
|
52
|
-- Fetch next record
|
|
53
|
FETCH NEXT FROM role_cursor INTO @TLNAME, @BRANCH_ID, @DEP_ID, @EFF_DATE, @EXP_DATE, @NOTES;
|
|
54
|
END;
|
|
55
|
|
|
56
|
-- Clean up cursor
|
|
57
|
CLOSE role_cursor;
|
|
58
|
DEALLOCATE role_cursor;
|
|
59
|
COMMIT TRANSACTION
|
|
60
|
ABORT:
|
|
61
|
BEGIN
|
|
62
|
ROLLBACK TRANSACTION
|
|
63
|
SELECT @DONE_INS_APPROVE_GROUP = 0, @ERROR_MESS = N'Xảy ra lỗi trong quá trình sinh quyền kiêm nhiệm phòng ban con'
|
|
64
|
End
|