Project

General

Profile

Feature #1459

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 13.03.2023

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
03/13/2023
Due date:
% Done:

0%

Estimated time:
PHIEUYEUCAUXE.xlsx (40.6 KB) PHIEUYEUCAUXE.xlsx Luc Tran Van, 03/13/2023 01:54 PM
rpt_TR_REQUEST_CAR.txt (5.31 KB) rpt_TR_REQUEST_CAR.txt Luc Tran Van, 03/13/2023 01:54 PM
TR_REQUEST_JOB_FORM_PROCESS_Upd.txt (41.4 KB) TR_REQUEST_JOB_FORM_PROCESS_Upd.txt Luc Tran Van, 03/13/2023 02:39 PM
CM_EMPLOYEE_Search.txt (5.84 KB) CM_EMPLOYEE_Search.txt Luc Tran Van, 03/13/2023 04:14 PM
TR_REQUEST_JOB_FORM_Search.txt (15.7 KB) TR_REQUEST_JOB_FORM_Search.txt Luc Tran Van, 03/13/2023 04:54 PM

History

#1 Updated by Luc Tran Van over 2 years ago

  • Subject changed from VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 10.03.2023 to VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 13.03.2023

#2 Updated by Luc Tran Van over 2 years ago

.net core\src\GSOFTcore.gAMSPro.Web.Host\wwwroot\Reports\CAR_MASTER

#3 Updated by Luc Tran Van over 2 years ago

UPDATE TR_CONTRACT SET REQ_DOC_ID ='' WHERE CONTRACT_ID ='TRC000000251776'

#5 Updated by Luc Tran Van over 2 years ago

DECLARE @ROLE_ID_NVTT INT ,@ROLE_ID_NVMS INT
SET @ROLE_ID_NVTT = (SELECT Id FROM AbpRoles WHERE DisplayName = 'NVTT')
SET @ROLE_ID_NVMS = (SELECT Id FROM AbpRoles WHERE DisplayName = 'NVMS')
INSERT INTO AbpPermissions SELECT GETDATE,930,Discriminator,IsGranted,[NAME],TenantId,@ROLE_ID_NVTT,UserId FROM AbpPermissions WHERE RoleId = @ROLE_ID_NVMS

#8 Updated by Luc Tran Van over 2 years ago

INSERT TR_REQUEST_JOB_FORM(REQ_ID, REQ_CODE, REQ_DT, REF_ID, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, REQ_REASON, REQ_DESC, NOTES, REQ_TYPE_TRANS, REQ_TYPE_GROUP, REQ_TYPE_BOOKING_HOTEL, REQ_TYPE_BOOKING_AIR, REQ_TYPE_BOOKING_TRAIN, SENDER_ID, SEND_DT, SIGN_USER, SIGN_DT, PROCESS_ID, BRANCH_CREATE, DEP_CREATE, BRANCH_ID, DEP_ID, FRMDATE, TODATE, IS_SEND_APPR, CONTENT, REQ_TYPE_BOOKING_CAR, NUM_TRIP_PEOPLE, OVERALL_TIME, TYPE_WORK, FROM_DATE, TO_DATE, HOTEL_NT, HOTEL_HO, EMP_ID, EMP_PHONE, REQ_CAR_ID) VALUES (N'AFT000000000000', 'AFT-00-000000', NULL, '', '', NULL, 'A', NULL, NULL, N'Phiếu trắng', NULL, NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, '', '', '', N'', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', NULL, NULL, N'', NULL, '', '', NULL)

Also available in: Atom PDF