标题: 退款登记里摘要部分显示退款学员名称和退款人数代码 [打印本页] 作者: haotengtech 时间: 2016-5-4 09:05 标题: 退款登记里摘要部分显示退款学员名称和退款人数代码 declare @RecordCount int
declare @ExamDate datetime
declare @mark varchar(50)
set @mark='[ '
select top 3 @mark=@mark+rtrim(doc_view.姓名)+' ' from doc_view where 单号=@docnum
set @mark=@mark+']等'
select top 1 @RecordCount=人数,@ExamDate=创建日期 from doc_ywmark where doc_ywmark.单号=@docnum
set @mark=@mark+'['+rtrim(cast(@recordCount as char(20)))+']人退还学费用'
if @cmdtype=1
begin
update doc_ywmark set 状态=1,摘要=case when isnull(摘要,'1')='1' or 摘要='' then @mark else 摘要 end where doc_ywmark.单号=@docnum
end
else
begin
update doc_ywmark set 状态=0 where doc_ywmark.单号=@docnum
end