在局网站 作风建设,网站推广服务报价表,阿贝云永久免费服务器,php购物网站开发使用场景
一个计算价格的函数#xff0c;多个存储过程调用#xff0c;因业务需求经常要新增参数#xff0c;避免修改函数时程序执行存储过程报错#xff0c;将多个参数拼接为一个字符串传递 -- 调用函数CalcuPrice(UnitPrice,CONCAT(MFQZC,MFQZC,ItemNum,ItemNum,多个存储过程调用因业务需求经常要新增参数避免修改函数时程序执行存储过程报错将多个参数拼接为一个字符串传递 -- 调用函数CalcuPrice(UnitPrice,CONCAT(MFQZC,MFQZC,ItemNum,ItemNum,AssmCode,AssmCode))-- 定义函数function [CalcuPrice](UnitPrice decimal(38, 3), -- 单价ARGS varchar(900))returns decimal(38, 3)as begin/***************************************** 解析参数列****************************************/-- 1、定义接受参数列表的变量declare MFQZC varchar(100),ItemNum varchar(100)/*物料编码*/,AssmCode varchar(100)/*加工件编码*/declare Str0 varchar(100),Str1 varchar(100),Str2 varchar(100)-- 2、循环读取键值对declare S_subject CURSOR FAST_FORWARD FORselect data from dbo.SplitStr(ARGS,);open S_subject;fetch next from S_subject into Str0;while FETCH_STATUS0beginset Str1 (select data from (select ROW_NUMBER() over (ORDER BY (select 1)) RowNum,data from dbo.SplitStr(Str0, )) a where RowNum1)set Str2 (select data from (select ROW_NUMBER() over (ORDER BY (select 1)) RowNum,data from dbo.SplitStr(Str0, )) a where RowNum2)if(Str1MFQZC)beginset MFQZCStr2endelse if(Str1ItemNum)beginset ItemNumStr2endelse if(Str1AssmCode)beginset AssmCodeStr2endfetch next from S_subject into Str0;endclose S_subject;deallocate S_subject;end;-- 接下来就可以用从字符串中解析出来的参数进行后续逻辑处理
