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

INSERT SYS_PREFIX(ID, Prefix, Description) VALUES (N'CM_APPROVE_GROUP', 'CAG', NULL)
INSERT SYS_PREFIX(ID, Prefix, Description) VALUES (N'CM_REQUEST_TEMPLATE', 'CRTEM', NULL)
INSERT SYS_PREFIX(ID, Prefix, Description) VALUES (N'CM_TEMPLATE_LOG', 'CMLOG', NULL)
INSERT SYS_PREFIX(ID, Prefix, Description) VALUES (N'CM_TEMPLATE_NOTE', 'CTNO', NULL)
INSERT SYS_PREFIX(ID, Prefix, Description) VALUES (N'CM_TEMPLATE_SHARE', 'CTS', NULL)
INSERT SYS_PREFIX(ID, Prefix, Description) VALUES (N'CM_TYPE_TEMPLATE', 'CTM', N'Loại tờ trình')

INSERT SYS_PARAMETERS( ParaKey, ParaValue, DataType, Description, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT) VALUES ( N'Report_no', N'44', 'Num', N'Số tờ trình Onl', '1', 'admin', '2013-11-11 00:00:00.000', 'A', 'admin', '2013-11-11 00:00:00.000')
INSERT SYS_PARAMETERS( ParaKey, ParaValue, DataType, Description, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT) VALUES ( N'Report_No_year', N'2023', 'Num', N'Năm số tờ trình Onl', '1', 'admin', NULL, NULL, NULL, NULL)

INSERT CM_ALLCODE( CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ( 'AUTH_STATUS_APP', 'A', N'Đã duyệt', NULL, 1)
INSERT CM_ALLCODE( CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ( 'AUTH_STATUS_APP', 'U', N'Chờ duyệt', NULL, 2)
INSERT CM_ALLCODE( CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ( 'AUTH_STATUS_ONL', 'U', N'Lưu nháp', NULL, 3)
INSERT CM_ALLCODE( CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ( 'AUTH_STATUS_ONL', 'O', N'Hoàn tất', NULL, 4)
INSERT CM_ALLCODE( CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ( 'AUTH_STATUS_ONL', 'R', N'Từ chối', NULL, 5)
INSERT CM_ALLCODE( CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ( 'AUTH_STATUS_ONL', 'A', N'Đã gửi duyệt', NULL, 6)
INSERT CM_ALLCODE( CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ( 'AUTH_STATUS_ONL', 'C', N'Đã đóng', NULL, 7)

INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES
INSERT INTO [CM_TYPE_TEMPLATE] ([TYPE_TEMPLATE_ID],[TYPE_TEMPLATE_NAME],[TYPE_TEMPLATE_STORE],[TYPE_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HEADER],[CREATE_LOCATION],[CONTENT])VALUES

INSERT SYS_CODEMASTERS(Prefix, CurValue, Description, Active) VALUES (N'CTM', 22, N'', '1')

INSERT SYS_PREFIX(ID, Prefix, Description) VALUES (N'CM_SENT_TO_TEMPLATE', 'CSTM', NULL)

DELETE TR_REQUEST_JOB_FORM
DELETE TR_REQUEST_JOB_TRAIN
DELETE TR_REQUEST_JOB_DETAIL
DELETE TR_REQ_JOB_FLY
DELETE TR_REQ_JOB_TRIP
DELETE TR_REQ_JOB_RETURN_TRIP
DELETE TR_REQUEST_CAR
DELETE TR_REQUEST_CAR_DETAIL
DELETE TR_REQ_CAR_FUEL

UPDATE TL_USER SET EMAIL=EmailAddress

SELECT * FROM ASS_TRANSFER_MULTI_MASTER aumd WHERE aumd.TRANS_MULTI_MASTER_ID='TFS000000251193'
SELECT * FROM ASS_TRANSFER_MULTI_DT atmd WHERE atmd.TRANS_MULTI_MASTER_ID='TFS000000251193'

ASS000000000450

SELECT * FROM CON_LAYOUT_BLUEPRINT clb
SELECT * FROM CON_BID_CONTRACTOR_DT_ARISE cbcda
SELECT * FROM CON_MASTER cm
SELECT * FROM CON_REQUEST_CONTRACT
SELECT * FROM CON_REQUEST_DOC_BID_DT
SELECT * FROM CON_REQUEST_DOC_DT
SELECT * FROM CON_REQUEST_DOC_PAYMENT_DT
SELECT * FROM CON_REQUEST_DOC_PROF_DT
SELECT * FROM CON_REQUEST_DOC_REPAIR_DT
SELECT * FROM CON_REQUEST_HH_DT
SELECT * FROM CON_REQUEST_PROCESS_DT
SELECT * FROM CON_REQUEST_REVIEW_DT
SELECT * FROM CON_TRACK ct

dev_apimobile\src\common\Common.gAMSPro.Application\Impls

DELETE CM_APPROVE_GROUP
DELETE CM_REQUEST_TEMPLATE
DELETE CM_TEMPLATE_LOG
DELETE CM_TEMPLATE_NOTE
DELETE CM_TEMPLATE_SHARE