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

EXEC dbo.sp_generate_inserts @table_name = 'MW_OUT', -- varchar(776)
@from = 'FROM MW_OUT' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_OUT_DT', -- varchar(776)
@from = 'FROM MW_OUT_DT' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_TRANSFER', -- varchar(776)
@from = 'FROM MW_TRANSFER' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_TRANSFER_DT', -- varchar(776)
@from = 'FROM MW_TRANSFER_DT' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_LIQ_MASTER', -- varchar(776)
@from = 'FROM MW_LIQ_MASTER' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_LIQ_DT', -- varchar(776)
@from = 'FROM MW_LIQ_DT' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_MAST_BAL', -- varchar(776)
@from = 'FROM MW_MAST_BAL' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_MAST_BAL_STMT', -- varchar(776)
@from = 'FROM MW_MAST_BAL_STMT' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_MAST_PRICE', -- varchar(776)
@from = 'FROM MW_MAST_PRICE' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_CODE_COUNTER', -- varchar(776)
@from = 'FROM MW_CODE_COUNTER' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_OUT_CODE_COUNTER', -- varchar(776)
@from = 'FROM MW_OUT_CODE_COUNTER' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_TRANSF_CODE_COUNTER', -- varchar(776)
@from = 'FROM MW_TRANSF_CODE_COUNTER' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_LIQ_CODE_COUNTER', -- varchar(776)
@from = 'FROM MW_LIQ_CODE_COUNTER' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'CM_BRANCH', -- varchar(776)
@from = 'FROM CM_BRANCH' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'CM_DEPARTMENT', -- varchar(776)
@from = 'FROM CM_DEPARTMENT' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'CM_MAPPING_CHUCDANH_ROLE ', -- varchar(776)
@from = 'FROM CM_MAPPING_CHUCDANH_ROLE ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_REQUEST_DOC', -- varchar(776)
@from = 'FROM TR_REQUEST_DOC' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_REQUEST_DOC_DT', -- varchar(776)
@from = 'FROM TR_REQUEST_DOC_DT' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_REQUEST_DOC_PL_DT ', -- varchar(776)
@from = 'FROM TR_REQUEST_DOC_PL_DT ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'CM_SUPPLIER ', -- varchar(776)
@from = 'FROM CM_SUPPLIER ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'CM_HANGHOA ', -- varchar(776)
@from = 'FROM CM_HANGHOA ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'BID_MASTER ', -- varchar(776)
@from = 'FROM BID_MASTER ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'BID_CONTRACTOR_DT ', -- varchar(776)
@from = 'FROM BID_CONTRACTOR_DT ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_PO_MASTER', -- varchar(776)
@from = 'FROM TR_PO_MASTER' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_PO_DETAIL', -- varchar(776)
@from = 'FROM TR_PO_DETAIL' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_PO_PAYMENT ', -- varchar(776)
@from = 'FROM TR_PO_PAYMENT ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_CONTRACT ', -- varchar(776)
@from = 'FROM TR_CONTRACT ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_CONTRACT_DT ', -- varchar(776)
@from = 'FROM TR_CONTRACT_DT ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_CONTRACT_PAYMENT ', -- varchar(776)
@from = 'FROM TR_CONTRACT_PAYMENT ' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS', -- varchar(776)
@from = 'FROM PL_REQUEST_PROCESS' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS_CHILD', -- varchar(776)
@from = 'FROM PL_REQUEST_PROCESS_CHILD' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'PL_PROCESS', -- varchar(776)
@from = 'FROM PL_PROCESS' -- varchar(800)

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID NOT IN (SELECT REQ_ID FROM PL_REQUEST_DOC)
AND REQ_ID NOT IN (SELECT REQ_ID FROM TR_REQUEST_DOC) AND REQ_ID NOT IN (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT)

UPDATE AbpSettings SET Value='20' WHERE NAME='gAMSProCore.FileSizeAttach'

PLRD00001160771

select * from pl_request_process where req_id = 'PLRD00001160771'

UPDATE ASS_LIQUIDATION SET AUTH_STATUS = 'A',CHECKER_ID='phuongtln1',APPROVE_DT=GETDATE WHERE AUTH_STATUS = 'U'
UPDATE ASS_COLLECT_MULTI_MASTER SET AUTH_STATUS = 'A',CHECKER_ID='phuongtln1',APPROVE_DT=GETDATE WHERE AUTH_STATUS = 'U'

INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('AUTH_STATUS', 'A', N'Đã duyệt', 'TR_REQ_CAR', 3);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('AUTH_STATUS', 'U', N'Chờ duyệt', 'TR_REQ_CAR', 2);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('AUTH_STATUS', 'M', N'Tôi xử lý', 'TR_REQ_CAR', 0);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('AUTH_STATUS', 'R', N'Từ Chối', 'TR_REQ_CAR', 4);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('AUTH_STATUS', 'D', N'Phiếu bị hủy', 'TR_REQ_CAR', 5);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('AUTH_STATUS', 'E', N'Lưu Nháp', 'TR_REQ_CAR', 1);

INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('CAR_TYPE', 'XL', N'Xử lý phiếu', 'REQ', 0);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('CAR_TYPE', 'CV', N'Chuyên viên điều động xe', 'REQ', 0);

SELECT * FROM ASS_MASTER am WHERE am.ASSET_ID NOT IN (SELECT ASSET_ID FROM ASS_INVENTORY_DT)

INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('FeeType', 'CTP', N'Công tác phí', 'TR', 0);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('FeeType', 'RX', N'Rửa Xe', 'TR', 0);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('FeeType', 'K', N'Khác', 'TR', 0);

Regex cho diễn giải hoạch toán: ^[!-%'-;=-~\s]{1,}$

UPDATE AbpSettings SET [Value]='^[!-%''-;=-~\s]{1,}$' WHERE [Name]='gAMSProCore.CoreNoteRegexValidation'
SELECT * FROM AbpSettings WHERE [Name]='gAMSProCore.CoreNoteRegexValidation'

UPDATE SYS_PREFIX SET Description=N'Nhập mới tài sản' where Prefix= 'ASA'

update AbpSettings set Value = 'Normal' where Name = 'gAMSProCore.LoginMethod'