DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

SELECT ASSET_CODE, AMORT_AMT, AMORTIZED_AMT, AMORT_MONTH, AMORTIZED_MONTH, AMORT_STATUS FROM ASS_MASTER WHERE (AMORT_AMT - AMORTIZED_AMT <=0 OR AMORT_MONTH - AMORTIZED_MONTH <=0) AND AMORT_STATUS NOT IN ( 'KHX','DTL')

UPDATE ASS_MASTER SET AMORT_STATUS='KHX' WHERE (AMORT_AMT - AMORTIZED_AMT <=0 OR AMORT_MONTH - AMORTIZED_MONTH <=0) AND AMORT_STATUS ='DKH'

UPDATE SYS_GROUP_LIMIT_DT SET VALUE_LIMIT =5000000000 WHERE GROUP_LM_DTID ='SGLDT0000000571'

ID:PLRD00000205604
TypeMail & TypeContent:REQUEST_DOC_PROCESS_Approve

--- CHẠY LỆNH 1
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205762' AND PROCESS_ID ='TKTGD'
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205762' AND PROCESS_ID ='TGD'
UPDATE PL_REQUEST_PROCESS SET STATUS='C', PARENT_PROCESS_ID ='GDK_TT' WHERE REQ_ID ='PLRD00000205762' AND PROCESS_ID ='TGD'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID ='PLRD00000205762'
---- CHẠY LỆNH 2
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC 'PLRD00000205762'
EXEC PL_REQ_DOC_UPDATE_AFTER_APPROVE'PLRD00000205762'

./wwwroot/Reports/PL_MASTER

DECLARE @IS_NEXT_CDT INT
SET @IS_NEXT_CDT=(SELECT dbo.FN_CHECK_LIMIT_PL_REQ_CDT('PLRD00000205762','PTGD'))
select @IS_NEXT_CDT

DECLARE @IS_NEXT INT
SET @IS_NEXT =(SELECT dbo.FN_CHECK_LIMIT_PL_REQ('PLRD00000205762', 'PTGD'));
SELECT @IS_NEXT

SET @IS_NEXT =(SELECT dbo.FN_CHECK_LIMIT_PL_REQ('PLRD00000205762', 'GDK'));
SELECT @IS_NEXT

SELECT * FROM TL_USER WHERE TLNANME
IN
(
SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME LIKE N'TRƯỞNG PHÒNG%' AND BRANCH_CODE <> '069' AND POS_NAME <> N'Trưởng Phòng Giao dịch')

SELECT * FROM CM_EMPLOYEE_LOG WHERE POS_NAME LIKE N'TRƯỞNG PHÒNG%' AND BRANCH_CODE <> '069' AND POS_NAME <> N'Trưởng Phòng Giao dịch'

SELECT * FROM CM_EMPLOYEE_LOG WHERE USER_DOMAIN ='vuongnv'
SELECT * FROM TL_USER WHERE TLNANME ='vuongnv'

SELECT * FROM AbpUserRoles WHERE UserId ='3965'
SELECT * FROM AbpRoles

UPDATE AbpSettings SET Value = 40 WHERE Name = 'gAMSProCore.FileSizeAttach'