CREATE FUNCTION GDZJ.GETNOPASS
(ITEMNAME VARCHAR(100),
REPORTTYPE INTEGER,
RESULTID INTEGER
)
RETURNS INTEGER
SPECIFIC GDZJ.SQL091102183311900
LANGUAGE SQL
NOT DETERMINISTIC
READS SQL DATA
STATIC DISPATCH
CALLED ON NULL INPUT
EXTERNAL ACTION
INHERIT SPECIAL REGISTERS
begin atomic
--返回值0:没有该检验项目。1:有检验项目,但全部合格。2:有检验项,但有一个不合格。(只要有一个不合格就判其不合格)
DECLARE IResult INTEGER;
DECLARE ICount INTEGER;
set IResult=0;
--REPORTTYPE:1:外单位、0:非外单位
if REPORTTYPE=1 then
set ICount=(
select count(1) from DETECT_END_INFO where
CHECK_OUT_UNIT_INFO_ID=RESULTID and locate(ITEMNAME,PROJECT_NAME)>0
end;