Project

General

Profile

Feature #1419

VẬN HÀNH SAU GOLIVE NGÀY 12-12-2022

Added by Luc Tran Van over 2 years ago. Updated over 2 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/12/2022
Due date:
% Done:

0%

Estimated time:
1.0 EXPORT DATA 3 TTCT DUONG NT5.txt (2.99 KB) 1.0 EXPORT DATA 3 TTCT DUONG NT5.txt Luc Tran Van, 12/12/2022 09:33 AM
0004_2022_TTr-0940005.xlsx (16.1 KB) 0004_2022_TTr-0940005.xlsx Luc Tran Van, 12/12/2022 09:43 AM
0011_2022_TTr-0710005.xlsx (16.1 KB) 0011_2022_TTr-0710005.xlsx Luc Tran Van, 12/12/2022 09:43 AM
0012_2022_TTr-0710005.xlsx (16 KB) 0012_2022_TTr-0710005.xlsx Luc Tran Van, 12/12/2022 09:43 AM
AbpRoles_DATA.txt (42 KB) AbpRoles_DATA.txt Luc Tran Van, 12/12/2022 09:56 AM
TL_SYS_ROLE_MAPPING_DATA.txt (998 KB) TL_SYS_ROLE_MAPPING_DATA.txt Luc Tran Van, 12/12/2022 09:56 AM
AbpUserRoleDATA.txt (633 KB) AbpUserRoleDATA.txt Luc Tran Van, 12/12/2022 09:56 AM
TL_USER_DATA.txt (2.52 MB) TL_USER_DATA.txt Luc Tran Van, 12/12/2022 09:56 AM
TL_USER_DATA_2.txt (3.42 MB) TL_USER_DATA_2.txt Luc Tran Van, 12/12/2022 09:57 AM
TR_CONTRACT_SendAppr.txt (4.36 KB) TR_CONTRACT_SendAppr.txt Luc Tran Van, 12/12/2022 10:52 AM
TR_CONTRACT_SendAppr.txt (4.51 KB) TR_CONTRACT_SendAppr.txt Luc Tran Van, 12/12/2022 01:55 PM
TR_RATE_SUPPLIER_MASTER_Search.txt (35.8 KB) TR_RATE_SUPPLIER_MASTER_Search.txt Luc Tran Van, 12/12/2022 02:29 PM
DATA_PHONG_9.xlsx (10.4 KB) DATA_PHONG_9.xlsx Luc Tran Van, 12/12/2022 03:28 PM
CM_REJECT_INS.txt (101 KB) CM_REJECT_INS.txt Luc Tran Van, 12/12/2022 03:54 PM
CM_REJECT_INS.txt (102 KB) CM_REJECT_INS.txt Luc Tran Van, 12/12/2022 03:58 PM
TR_CONTRACT_Ins.txt (13.4 KB) TR_CONTRACT_Ins.txt Luc Tran Van, 12/12/2022 04:41 PM
TR_CONTRACT_Upd.txt (22.4 KB) TR_CONTRACT_Upd.txt Luc Tran Van, 12/12/2022 04:41 PM
advance_search_121222.txt (50.7 KB) advance_search_121222.txt Luc Tran Van, 12/12/2022 05:19 PM
ASS_TRANSACTIONS.txt (13.8 KB) ASS_TRANSACTIONS.txt Luc Tran Van, 12/13/2022 11:06 AM

History

#1 Updated by Luc Tran Van over 2 years ago

EXEC dbo.sp_generate_inserts @table_name = 'TL_USER', -- varchar(776)
@from = 'FROM TL_USER' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'AbpRoles', -- varchar(776)
@from = 'FROM AbpRoles' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'AbpUserRoles', -- varchar(776)
@from = 'FROM AbpUserRoles' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'TL_SYS_ROLE_MAPPING', -- varchar(776)
@from = 'FROM TL_SYS_ROLE_MAPPING' -- varchar(800)

#4 Updated by Luc Tran Van over 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='Thay REQ_CODE vào đây')
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM CM_GOODSTYPE
SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID

#9 Updated by Luc Tran Van over 2 years ago

SELECT * FROM ASS_MASTER am WHERE am.ASSET_CODE='069CC15021306180001'
SELECT * FROM ASS_USE_MULTI_MASTER aumm WHERE aumm.USER_MASTER_ID='SMA000000000050'

SELECT * FROM ASS_USE_MULTI_MASTER aumm WHERE aumm.USER_MASTER_ID='SDT000000000142'

#13 Updated by Luc Tran Van over 2 years ago

SELECT * FROM ASS_TRANSACTIONS WHERE TRN_ID ='SDT000000000142'
UPDATE ASS_TRANSACTIONS SET ASSET_ID='XXS000000007940' WHERE TRN_ID ='SDT000000000142'

Also available in: Atom PDF