42 lines
925 B
Transact-SQL
42 lines
925 B
Transact-SQL
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALTER VIEW [dbo].[View_HJGL_HotProess_TrustItem]
|
|
AS
|
|
/********热处理明细********/
|
|
SELECT TrustItem.HotProessTrustItemId,
|
|
TrustItem.HotProessTrustId,
|
|
TrustItem.WeldJointId,
|
|
TrustItem.IsPass,
|
|
TrustItem.IsHardness,
|
|
TrustItem.IsTrust,
|
|
TrustItem.HardTrustItemID,
|
|
(CASE WHEN TrustItem.IsCompleted=1 THEN '完成' when TrustItem.IsCompleted=0 then '未完成' ELSE '未热处理' END) AS IsCompleted,
|
|
TrustItem.IsCompleted as OldIsCompleted,
|
|
Trust.ProjectId,
|
|
Trust.HotProessTrustNo,
|
|
Trust.ProessDate,
|
|
JOT.JOT_JointNo,
|
|
ISO.ISO_IsoNo,
|
|
JOT.JOT_JointDesc,
|
|
Material.MaterialCode,
|
|
JOT.JOT_Sch
|
|
FROM HJGL_HotProess_TrustItem AS TrustItem
|
|
LEFT JOIN HJGL_HotProess_Trust AS Trust ON Trust.HotProessTrustId=TrustItem.HotProessTrustId
|
|
LEFT JOIN PW_JointInfo AS JOT ON JOT.JOT_ID=TrustItem.WeldJointId
|
|
LEFT JOIN PW_IsoInfo AS ISO ON ISO.ISO_ID=JOT.ISO_ID
|
|
LEFT JOIN Base_Material AS Material ON Material.MaterialId=JOT.MaterialId
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GO
|
|
|
|
|