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

INSERT INTO [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],[COST_AMOUNT])VALUES(N'TRJF00000000001',N'AFT-22-000001',NULL,N'baotq',N'baotq',N'Apr 12 2022 9:56AM',N'A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'DV0001',N'DEP000000000028',NULL,NULL,NULL,NULL,N'N',90000000)

go

INSERT INTO [TR_REQUEST_JOB_DETAIL] ([REQ_DT_ID],[REQ_ID],[EMP_ID],[TLNANME],[BRANCH_ID],[DEP_ID],[PHONE],[NOTES],[AUTH_STATUS])VALUES(N'TRJD00000000001',N'TRJF00000000001',N'EMP000000000119',N'tuanva',N'DV0001',N'DEP000000000028',N'0376869390',N'',N'')

go

INSERT INTO [TR_REQ_JOB_TRIP] ([TRIP_ID],[REQ_ID],[TIME_TRIP],[DAY_TRIP],[FROM_TRIP],[TO_TRIP],[NOTES],[AUTH_STATUS])VALUES(N'RJT000000000001',N'TRJF00000000001',N'10:54',N'Apr 12 2022 12:00AM',N'01',N'02',N'',N'')

go

INSERT INTO [TR_REQ_JOB_RETURN_TRIP] ([RETURN_ID],[REQ_ID],[TIME_RETURN],[DAY_RETURN],[FROM_RETURN],[TO_RETURN],[NOTES],[AUTH_STATUS])VALUES(N'RJRT00000000001',N'TRJF00000000001',N'10:55',N'Apr 13 2022 12:00AM',N'02',N'01',N'',N'')

go

INSERT INTO [TR_REQ_JOB_FLY] ([FLY_ID],[REQ_ID],[TIME_FLY],[DAY_FLY],[COST],[NOTES],[AUTH_STATUS])VALUES(N'RJF000000000001',N'TRJF00000000001',N'10:54',NULL,6000000.00,N'',N'')

insert into SYS_PREFIX ([ID], Prefix, Description)

VALUES('TR_REQ_PAY_JOB_DT', 'PJDT', N'Chi tiết phiếu yêu cầu công tác')

insert into SYS_PREFIX ([ID], Prefix, Description)

VALUES('TR_REQ_PAY_JOB', 'TRPJ', N'Phiếu yêu cầu công tác')

insert into SYS_PREFIX ([ID], Prefix, Description)

VALUES('TR_REQ_PAY_DRIVE', 'TRDR', N'Thông chi chi phí vận hành xe')

insert into SYS_PREFIX ([ID], Prefix, Description)

VALUES('TR_REQ_PAY_DRIVE_DT', 'TRDDT', N'Bảng kê chi phí sử dụng nhiên liệu')

CREATE TABLE BANK_OUTSIDE(

BANK_OUTSIDE_ID VARCHAR(20),

BANK_OUTSIDE_CODE VARCHAR(20),

BANK_OUTSIDE_NAME NVARCHAR(250),

NOTE NVARCHAR(250),

MAKER_ID VARCHAR(20),

CREATE_DT VARCHAR(20),

AUTH_STATUS VARCHAR(1)

)

CREATE PROCEDURE [dbo].[BANK_OUTSIDE_Search]

@p_BANK_OUTSIDE_ID	varchar(20)  = NULL,

@p_BANK_OUTSIDE_CODE	varchar(20)  = NULL,

@p_BANK_OUTSIDE_NAME	varchar(20)  = NULL,

@p_TOP	INT = NULL

AS

BEGIN -- PAGING

IF @p_TOP = 300 SET @p_TOP = 1000

IF(@p_TOP IS NULL OR @P_TOP = '' OR @P_TOP = 0)

-- PAGING BEGIN

-- SELECT END

SELECT A.*

FROM BANK_OUTSIDE A 

 WHERE 1 = 1

	AND (A.BANK_OUTSIDE_CODE LIKE '%' + @p_BANK_OUTSIDE_CODE + '%' OR  @p_BANK_OUTSIDE_CODE IS NULL OR @p_BANK_OUTSIDE_CODE = '')

	AND (A.BANK_OUTSIDE_NAME LIKE '%' + @p_BANK_OUTSIDE_NAME + '%' OR  @p_BANK_OUTSIDE_NAME IS NULL OR @p_BANK_OUTSIDE_NAME = '')

	ORDER BY A.BANK_OUTSIDE_CODE

-- PAGING END

ELSE

-- PAGING BEGIN

SELECT TOP(CONVERT(INT,@P_TOP))A.*

-- SELECT END

FROM BANK_OUTSIDE A 

 WHERE 1 = 1

	AND (A.BANK_OUTSIDE_CODE LIKE '%' + BANK_OUTSIDE_CODE + '%' OR  BANK_OUTSIDE_CODE IS NULL OR BANK_OUTSIDE_CODE = '')

	AND (A.BANK_OUTSIDE_NAME LIKE '%' + BANK_OUTSIDE_CODE + '%' OR  @p_BANK_OUTSIDE_NAME IS NULL OR @p_BANK_OUTSIDE_NAME = '')

	ORDER BY A.BANK_OUTSIDE_CODE

-- PAGING END

END -- PAGING