主从表接口
declare @Row_Index int
declare @sort_info nvarchar(max)
declare @sort_name varchar(100)
declare @sort_area_calc_rate varchar(30)
set @Row_Index = 0
while CHARINDEX('|',@sort_info_list,0)>0
begin
set @Row_Index = @Row_Index + 1
set @sort_info = ''
set @sort_info=substring(@sort_info_list,0,CHARINDEX('|',@sort_info_list,0))
if len(@sort_info) > 0
begin
set @sort_name = null
set @sort_name = substring(@sort_info,0,CHARINDEX('§',@sort_info,0))
set @sort_info = substring(@sort_info,CHARINDEX('§',@sort_info,0)+1,len(@sort_info))
set @sort_area_calc_rate = ''
set @sort_area_calc_rate = substring(@sort_info,0,CHARINDEX('§',@sort_info,0))
set @sort_info = substring(@sort_info,CHARINDEX('§',@sort_info,0)+1,len(@sort_info))
if @sort_name is null or len(@sort_name)=0
begin
set @rescode =12;
set @resdesc='新增补偿标准失败,第【'+Convert(varchar(30),@Row_Index)+'】行 分类【名称】不能为空!';
select @rescode asrescode,@resdesc as resdesc
rollback tran
return
end
insert into t_b_compensate_standard
()
values
()
set @key_id = @@Identity;
end
set @sort_info_list= substring(@sort_info_list,CHARINDEX('|',@sort_info_list,0)+1,len(@sort_info_list))
end