if ISNULL(@htdm, '') = ''
begin
select -100 as errorcode, '该合同代码不能为空' as errormsg
return -100
end
if ISNULL(@htmc, '') = ''
begin
select -100 as errorcode, '该合同名称不能为空' as errormsg
return -100
end
--begin tran
if ISNULL(@tzzldm, '') = ''
begin
declare @count int = (select count(tzzldm) from AMV10Base..bill_tzzl)
declare @i int = 1
while @i<=@count
begin
begin tran
--select top 1* from (select top (@count) tzzldm from AMV10Base..bill_tzzl order by tzzldm)a order by tzzldm desc
insert AMV10Base..banking_pact_config (fsrq,tzzldm, htdm, htmc, glfl, tgfl, bgfl, czydm) values ((convert(varchar(10),getdate(),120)), (select top 1* from (select top (@count) tzzldm from AMV10Base..bill_tzzl order by tzzldm)a order by tzzldm desc),@htdm, @htmc ,@pj_glfl ,@pj_tgfl ,@pj_bgfl ,@p_f_czydm)
set @count = @count-1
end
end
--delete from AMV10Base..banking_pact_config
print '11111111'
if ISNULL(@tzzldm, '') != ''
begin tran
begin
insert AMV10Base..banking_pact_config (fsrq,tzzldm, htdm, htmc, glfl, tgfl, bgfl, czydm) values ((convert(varchar(10),getdate(),120)), @tzzldm,@htdm, @htmc ,@pj_glfl ,@pj_tgfl ,@pj_bgfl ,@p_f_czydm)
end
if @@rowcount = 0 or @@error != 0
begin
rollback tran