value(runsql("select dbo.isxs控價(jià)('"+商品_商品清單_類別編號(hào)+"',"+string(銷售單_銷售價(jià),3)+","+string(銷售單_批次成本單價(jià),3)+",'"+__操作員+"')"))=0

---------------------------------------------------------SQl 腳本

IF? EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[isxs控價(jià)]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[isxs控價(jià)]
GO

create FUNCTION [dbo].[isxs控價(jià)](@lbbh char(10),@xsjia float,@cbjia float,@jzr char(10))
RETURNS int
AS
BEGIN

?? ?-- @返回 = 0 通過(guò)
?? ?-- @返回 = 1 不通過(guò) select dbo.isxs控價(jià)('1450016','1450016','1004105',301)
?? ?declare @返回 int,@ygbh char(6)
?? ?select @ygbh=職工編號(hào) from 職工清單 where 姓名=@jzr
?? ?if @ygbh='0070'
?? ?select? @返回=0
?? ?if @lbbh='控價(jià)' and (@xsjia>=@cbjia/0.8)
?? ??? ??? ?select? @返回=1
?? ?return? isnull(@返回,0)
end

---------------------------------------------------------程序效果