ALTER PROCEDURE [dbo].[HJGL_spCH_HotProessTrustItem]
(
   @HotProessTrustId nvarchar(50),
   @ProessTypes nvarchar(50)=null
)
AS
--通过检测id获取委托单信息
BEGIN


select HotProessTrustId,ISO_IsoNo,JOT_JointNo,JOT_JointDesc,STE_Code,
STRING_AGG((case when ProessTypes='1' then '预热'
		when ProessTypes='2' then '消氢'
		when ProessTypes='3' then '后热'
		when ProessTypes='4' then '消应力热处理'
		when ProessTypes='5' then '稳定化处理'
		else ''end),'+') as ProessTypes  from HJGL_View_CH_HotProessTrustItem TrustItem
		where HotProessTrustId=@HotProessTrustId
		and (ProessTypes=@ProessTypes or @ProessTypes is null)
		group by HotProessTrustId,ISO_IsoNo,JOT_JointNo,JOT_JointDesc,STE_Code

union 

select '99999999' as Number,'以下空白' AS ISO_IsoNo,null,null,null,null

end
go