--/*合同参数表开始*/
--声明合同变量
DECLARE @ParaRemark NVARCHAR(MAX);
DECLARE @ContractTemplate1 NVARCHAR(MAX);
DECLARE @ContractTemplate2 NVARCHAR(MAX);
DECLARE @ContractTemplate3 NVARCHAR(MAX);
DECLARE @ContractTemplate4 NVARCHAR(MAX);
DECLARE @SortOrder INT;
--声明游标
DECLARE FDT_CONTRACT CURSOR FOR SELECT spt.ParaRemark,spt.SortOrder
FROM dbo.GetSysParamTable('FDT_PROJECT_CONTRACT',NULL) AS spt ORDER BY spt.SortOrder
--打开游标
OPEN FDT_CONTRACT
fetch next from FDT_CONTRACT into @ParaRemark,@SortOrder
while @@fetch_status<>-1
BEGIN
--查询合同表给合同变量赋值
IF @SortOrder=1
SET @ContractTemplate1=@ParaRemark;
ELSE IF @SortOrder=2
SET @ContractTemplate2=@ParaRemark;
ELSE IF @SortOrder=3
SET @ContractTemplate3=@ParaRemark;
ELSE IF @SortOrder=4
SET @ContractTemplate4=@ParaRemark;
fetch next from FDT_CONTRACT into @ParaRemark,@SortOrder
END
--关闭游标
close FDT_CONTRACT
--删除游标
deallocate FDT_CONTRACT
--/*合同参数表结束*/
--声明合同变量
DECLARE @ParaRemark NVARCHAR(MAX);
DECLARE @ContractTemplate1 NVARCHAR(MAX);
DECLARE @ContractTemplate2 NVARCHAR(MAX);
DECLARE @ContractTemplate3 NVARCHAR(MAX);
DECLARE @ContractTemplate4 NVARCHAR(MAX);
DECLARE @SortOrder INT;
--声明游标
DECLARE FDT_CONTRACT CURSOR FOR SELECT spt.ParaRemark,spt.SortOrder
FROM dbo.GetSysParamTable('FDT_PROJECT_CONTRACT',NULL) AS spt ORDER BY spt.SortOrder
--打开游标
OPEN FDT_CONTRACT
fetch next from FDT_CONTRACT into @ParaRemark,@SortOrder
while @@fetch_status<>-1
BEGIN
--查询合同表给合同变量赋值
IF @SortOrder=1
SET @ContractTemplate1=@ParaRemark;
ELSE IF @SortOrder=2
SET @ContractTemplate2=@ParaRemark;
ELSE IF @SortOrder=3
SET @ContractTemplate3=@ParaRemark;
ELSE IF @SortOrder=4
SET @ContractTemplate4=@ParaRemark;
fetch next from FDT_CONTRACT into @ParaRemark,@SortOrder
END
--关闭游标
close FDT_CONTRACT
--删除游标
deallocate FDT_CONTRACT
--/*合同参数表结束*/