Project

General

Profile

Bug #1600

Van hanh he thong 17062025

Added by Luc Tran Van about 7 hours ago. Updated about 1 hour ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
06/17/2025
Due date:
% Done:

0%

Estimated time:
fix_tim_totrinh.txt (36.6 KB) fix_tim_totrinh.txt Luc Tran Van, 06/17/2025 02:23 PM
FIX_TIM_TOTRINH1.txt (82.8 KB) FIX_TIM_TOTRINH1.txt Luc Tran Van, 06/17/2025 02:26 PM
FIX_TO_TRINH THANH LY.txt (6.95 KB) FIX_TO_TRINH THANH LY.txt Luc Tran Van, 06/17/2025 03:32 PM

History

#1 Updated by Luc Tran Van about 5 hours ago

SELECT * FROM TR_REQ_PAY_SCHEDULE trps WHERE trps.REQ_PAY_ID = ''

#2 Updated by Luc Tran Van about 5 hours ago

SELECT * FROM TR_REQ_PAY_SCHEDULE trps WHERE trps.REF_ID = (SELECT tpm.PO_ID FROM TR_PO_MASTER tpm WHERE tpm.PO_CODE = 'PO069/25/0190')

#3 Updated by Luc Tran Van about 5 hours ago

UPDATE TR_REQ_PAY_SCHEDULE SET PROCESS = 2 WHERE SCHEDULE_ID = ''

#4 Updated by Luc Tran Van about 4 hours ago

SELECT * FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID = @REQ_ADV_ID AND PAY_ID = @PAY_ID AND AUTH_STATUS_KT = 'A' AND TRN_TYPE = 'ADV_PAY' AND ISNULL <> '2')

#6 Updated by Luc Tran Van about 3 hours ago

SELECT * FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID ='TADY00000207552'

#9 Updated by Luc Tran Van about 2 hours ago

INSERT dbo.CM_ALLCODE(CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES
'NG', -- CDVAL - varchar(50)
N'Ngoài giờ', -- CONTENT - nvarchar(500)
'TR', -- CDTYPE - varchar(20)
6 -- LSTODR - int
)

#10 Updated by Luc Tran Van about 2 hours ago

SELECT A. *,c.DisplayName FROM AbpUserRoles A
INNER JOIN TL_USER B ON A.UserId = b.ID
INNER JOIN AbpRoles C ON A.RoleId = C.Id
WHERE B.TLNANME ='thuyenn1'

Also available in: Atom PDF