Код

ТекстЗапросаПоОтменеСчета="
|set nocount on
|declare @docum5 char(9)
|declare @docum6 char(23)
|set @docum5 = ?
|set @docum6 = ?
|select case	when ga.cld = 0 and ga.mrk = 0 then '"""+ШрифтОбычный+"""'
|		when ga.mrk = 1 then '"""+ШрифтПометкаУдаления+"""'
|		when ga.cld = 1 then case when pa.nt > 0 then '"""+ШрифтАннулирован+"""' else '"""+ШрифтСписанВДоход+"""' end
|		else 	'"""+ШрифтОбычный+"""'
|		end
|from
|	(
|	select 	j1.iddoc doc1, j1.iddocdef doc1_вид, j1.closed&1 cld, j1.ismark mrk
|	from 	_1sjourn j1(nolock)
|	where 	j1.iddocdef = $ВидДокумента.Счет and j1.iddoc = @docum5
|	) as ga
|	,
|	(
|	select count(*) nt
|	from _1scrdoc cr(nolock)
|		inner join _1sjourn j2(nolock) on cr.child_date_time_iddoc = j2.date_time_iddoc
|	where parentval = @docum6
|		and mdid = 0
|		and j2.iddocdef = $ВидДокумента.ОтменаСчета
|		and j2.closed & 1 = 1
|	) as pa
|";