2.窗体第一次打开时,是使用一个比较复杂的查询语句:
SELECT DISTINCT PlantCode, BPNo, BPCalID, BPType, OwnerID,
(SELECT StepDesp1
FROM epstep
WHERE Rectype = 'EPBPInfo' AND step =
(SELECT step
FROM EPTrackList
WHERE TrackListID =
(SELECT MAX(TrackListID)
FROM EPTrackList
WHERE rectype = 'EPBPInfo' AND RecNo = EPBPInfo.BPNo AND
((StepDate IS NOT NULL AND stepdate <> '') OR
(stepremark <> '' AND stepremark IS NOT NULL))) AND
RecNo = EPBPInfo.BPNo)) AS BPStatus, ForecastDate, FinalDate,
BPFinalQty, PTRNo,
(SELECT StepDesp1
FROM epstep
WHERE Rectype = 'EPPTRInfo' AND step =
(SELECT step
FROM EPTrackList
WHERE TrackListID =
(SELECT MAX(TrackListID)
FROM EPTrackList
WHERE rectype = 'EPPTRInfo' AND
RecNo = EPBPInfo.PTRNo AND ((StepDate IS NOT NULL AND
stepdate <> '') OR
(stepremark <> '' AND stepremark IS NOT NULL))) AND
RecNo = EPBPInfo.PTRNo)) AS PTRStatus, BPRemark,
SimpleBPFlag, AlarmInd, BPEWO, BPGroupID, BPNotice,
(SELECT StepDesp
FROM epstep
WHERE Rectype = 'EPBPInfo' AND step =
(SELECT step
FROM eptracklist
WHERE tracklistid =
(SELECT MAX(TrackListID)
FROM EPTrackList
WHERE rectype = 'EPBPInfo' AND RecNo = EPBPInfo.BPNo AND
((StepDate IS NOT NULL AND stepdate <> '') OR
(stepremark <> '' AND stepremark IS NOT NULL))) AND
RecNo = EPBPInfo.BPNo)) AS BPStep, IssuedBy, IssueDate
FROM EPBPInfo
ORDER BY bpno