91精品大片在线观看,欧美日本韩国一区二区三区视频,亚洲人成综合小说社区在线,国产草莓精品国产AV片国产

haotengtech 發(fā)表于 2016-5-4 09:05:43

退款登記里摘要部分顯示退款學(xué)員名稱和退款人數(shù)代碼

declare @RecordCount int
declare @ExamDate datetime
declare @mark varchar(50)
set @mark='[ '
select top 3 @mark=@mark+rtrim(doc_view.姓名)+' ' from doc_view where 單號(hào)=@docnum
set @mark=@mark+']等'
select top 1 @RecordCount=人數(shù),@ExamDate=創(chuàng)建日期 from doc_ywmark where doc_ywmark.單號(hào)=@docnum
set @mark=@mark+'['+rtrim(cast(@recordCount as char(20)))+']人退還學(xué)費(fèi)用'

if @cmdtype=1
begin
   updatedoc_ywmark set 狀態(tài)=1,摘要=case when isnull(摘要,'1')='1' or 摘要='' then @mark else 摘要 end where doc_ywmark.單號(hào)=@docnum            
end
else
begin
      updatedoc_ywmark set 狀態(tài)=0 where doc_ywmark.單號(hào)=@docnum
end