Project

General

Profile

Bug #789

Lỗi PUR 102 - Data lưu trữ chỉ có 2 dòng nhưng hiển thị trên giao diện tới 3 dòng - Do hồ sơ thầu đang bị lỗi 1 hồ sơ thầu nhưng có tới 2 NCC trúng thầu

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

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/31/2020
Due date:
% Done:

0%

Estimated time:

Description

DECLARE @REQ_ID VARCHAR, @BRANCH_CREATE VARCHAR
SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000102')
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID
UPDATE TR_REQUEST_DOC_DT SET BID_ID ='BIDM00000251219' WHERE REQ_DOC_ID =@REQ_ID AND REQDT_ID ='TRRDD0000251440'

EXEC TR_REQUEST_DOC_DT_BYID 'TRRD00000251102'

--SELECT * FROM PL_REQUEST_DOC_DT WHERE REQDT_ID ='PLRDD0000201005'

SELECT * FROM BID_MASTER WHERE BID_ID ='BIDM00000251219'

SELECT * FROM BID_CONTRACTOR_DT WHERE BID_ID ='BIDM00000251219'
UPDATE BID_CONTRACTOR_DT SET IS_BID_WIN ='0' WHERE BID_ID ='BIDM00000251219' AND ID ='BIDD00000251315'

DATA PUR 102.xlsx (21.9 KB) DATA PUR 102.xlsx Luc Tran Van, 12/31/2020 10:21 AM

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF