34,590
社区成员
发帖
与我相关
我的任务
分享
declare @Index nvarchar(200)
declare @BusinessContractIndex nvarchar(200)
declare @FreightBreedIndex nvarchar(200)
declare @ValueAddedTaxBasePrice nvarchar(200)
declare @QS nvarchar(200)
declare @GJHF nvarchar(200)
declare @NJZS nvarchar(200)
declare @JZCHD nvarchar(200)
declare @GJQL nvarchar(200)
set @Index ='1'
set @BusinessContractIndex='2'
set @FreightBreedIndex ='3'
set @ValueAddedTaxBasePrice='4'
set @QS='5'
set @GJHF ='6'
set @NJZS ='7'
set @JZCHD ='8'
set @GJQL='9'
declare @InsertStatement nvarchar(2000)
set @InsertStatement='insert into udot_BusinessContractFreightQualityDetail (bcfqdf_Index,
bcfqdf_BusinessContractIndex,
bcfqdf_FreightBreedIndex,
bcfqdf_ValueAddedTaxBasePrice,
bcfqdf_QS,
bcfqdf_GJHF,
bcfqdf_NJZS,
bcfqdf_JZCHD,
bcfqdf_GJQL) values ('+
convert(nvarchar(10),@Index)+','+
convert(nvarchar(10),@BusinessContractIndex)+','+
convert(nvarchar(10),@FreightBreedIndex)+','+
convert(nvarchar(10),@ValueAddedTaxBasePrice)+','+
convert(nvarchar(10),@QS)+','+
convert(nvarchar(10),@GJHF)+','+
convert(nvarchar(10),@NJZS)+','+
convert(nvarchar(10),@JZCHD)+','+
convert(nvarchar(10),@GJQL)+')' ;
select @InsertStatement
/*
结果:
insert into udot_BusinessContractFreightQualityDetail (bcfqdf_Index, bcfqdf_BusinessContractIndex, bcfqdf_FreightBreedIndex, bcfqdf_ValueAddedTaxBasePrice, bcfqdf_QS, bcfqdf_GJHF, bcfqdf_NJZS, bcfqdf_JZCHD, bcfqdf_GJQL) values (1,2,3,4,5,6,7,8,9)
*
/
create procedure udsp_InsertBusinessContractFreightQualityDetail
@BusinessContractNumber nvarchar(32),
@FreightBreedName nvarchar(16),
@ValueAddedTaxBasePrice real,
@QS real,
@GJHF real,
@NJZS real,
@JZCHD real,
@GJQL real
as
declare @Index smallint
set @Index=isnull((select max(bcfqdf_Index) from udot_BusinessContractFreightQualityDetail),0) + 1
declare @BusinessContractIndex smallint
set @BusinessContractIndex=(select bcf_Index from udot_BusinessContract where bcf_BusinessContractNumber=@BusinessContractNumber)
declare @FreightBreedIndex smallint
set @FreightBreedIndex=(select fbf_Index from udsdt_FreightBreed where fbf_Name=@FreightBreedName)
declare @InsertStatement nvarchar(4000)
set @InsertStatement='insert into udot_BusinessContractFreightQualityDetail (
bcfqdf_Index,
bcfqdf_BusinessContractIndex,
bcfqdf_FreightBreedIndex,
bcfqdf_ValueAddedTaxBasePrice,
bcfqdf_QS,
bcfqdf_GJHF,
bcfqdf_NJZS,
bcfqdf_JZCHD,
bcfqdf_GJQL
) values ('+
convert(nvarchar(10),@Index)+','+
convert(nvarchar(10),@BusinessContractIndex)+','+
convert(nvarchar(10),@FreightBreedIndex)+','+
convert(nvarchar(10),@ValueAddedTaxBasePrice)+','+
convert(nvarchar(10),@QS)+','+
convert(nvarchar(10),@GJHF)+','+
convert(nvarchar(10),@NJZS)+','+
convert(nvarchar(10),@JZCHD)+','+
convert(nvarchar(10),@GJQL)+')'
if exists(select 1 from udot_BusinessContractFreightQualityDetail
where bcfqdf_BusinessContractIndex=@BusinessContractIndex and bcfqdf_FreightBreedIndex=@FreightBreedIndex
)
raiserror('已存在同名记录',16,1)
else
execute(@InsertStatement)
go
declare @BusinessContractIndex smallint
set @BusinessContractIndex=(select bcf_Index from udot_BusinessContract where bcf_BusinessContractNumber=@BusinessContractNumber)
declare @FreightBreedIndex smallint
set @FreightBreedIndex=(select fbf_Index from udsdt_FreightBreed where fbf_Name=@FreightBreedName)
-->
declare @BusinessContractIndex smallint
set @BusinessContractIndex=(select bcf_Index from udot_BusinessContract where bcf_BusinessContractNumber=@BusinessContractNumber)
SET @BusinessContractIndex=ISNULL(@BusinessContractIndex,0)
declare @FreightBreedIndex smallint
set @FreightBreedIndex=(select fbf_Index from udsdt_FreightBreed where fbf_Name=@FreightBreedName)
SET @FreightBreedIndex=ISNULL(@FreightBreedIndex,0)