if exists (select name from sysobjects where name='fGetDaryaftPardakhtTafsiliCode')
	drop function fGetDaryaftPardakhtTafsiliCode
go
create function fGetDaryaftPardakhtTafsiliCode(@codeBargeh int , @isBedehkar bit)
returns nvarchar(1000)as
begin
	declare @s nvarchar(1000)
	set @s='';
	select
		@s=@s+
		case
			when @isBedehkar=1 then
				isnull(cast(CodeTafsiliBedehkar as nvarchar),'')
			else
				isnull(cast(CodeTafsiliBestankar as nvarchar),'')
		end +' , '
	from daryaftpardakht
	where code=@codeBargeh

	select
		@s=@s+
		cast(codetafsilimoshtari as nvarchar)+' , '
	from chekdetail c join daryaftpardakht d
	on c.codeparent=d.code and d.code=@codeBargeh
	where case when @isBedehkar=1 then CodeTafsiliBedehkar else CodeTafsiliBestankar end is null
	return @s
end
go
------------------------دریافت لیست کدهای تفصیلی مرتبط با یک چک
if exists (select name from sysobjects where name='fGetDaryaftPardakhtDetailTafsiliCode')
	drop function fGetDaryaftPardakhtDetailTafsiliCode
go
create function fGetDaryaftPardakhtDetailTafsiliCode(@codeDetail int , @isBedehkar bit)
returns nvarchar(1000)as
begin
	declare @s nvarchar(1000)
	set @s='';
	select
		@s=@s+
		case
			when @isBedehkar=1 then
				isnull(cast(CodeTafsiliBedehkar as nvarchar),'')
			else
				isnull(cast(CodeTafsiliBestankar as nvarchar),'')
		end +' , '
	from daryaftpardakhtdetail
	where code=@codeDetail

	select
		@s=@s+
		cast(codetafsilimoshtari as nvarchar)
		+' , '
	from chekdetail c join daryaftpardakhtdetail d
	on c.codeparent=d.code and d.code=@codeDetail
	where case when @isBedehkar=1 then CodeTafsiliBedehkar else CodeTafsiliBestankar end is null

	return @s
end