CREATE OR REPLACE FUNCTION XCGHJ."GET_SWGL_ADDCOUNT"
(MyPopman in varchar) return number is
/*收文管理-在办件(我添加的)*/
retVal number;
cansee number;
canseeall number;
BEGIN
select max(cansee),max(canseeall)into cansee,canseeall
from archivestakeoverright
where username=MyPopeman
if canseeall=1 then
SELECT COUNT(ArchivesID) into retVal FROM ArchivesTakeOver
WHERE (GDState!=2);
else if cansee=1 then
SELECT COUNT(ArchivesID) into retVal FROM ArchivesTakeOver
WHERE (GDState!=2) and takeoberoffice=(select groupset from sysuserlib where userid=MyPopeman);
else
SELECT COUNT(ArchivesID) into retVal FROM ArchivesTakeOver
WHERE (GDState!=2) and addman=MyPopeman
end if
return retVal;
END;
(MyPopman in varchar) return number is
/*收文管理-在办件(我添加的)*/
retVal number;
cansee number;
canseeall number;
BEGIN
select max(cansee),max(canseeall)into cansee,canseeall
from archivestakeoverright
where username=MyPopeman
if canseeall=1 then
SELECT COUNT(ArchivesID) into retVal FROM ArchivesTakeOver
WHERE (GDState!=2);
else if cansee=1 then
SELECT COUNT(ArchivesID) into retVal FROM ArchivesTakeOver
WHERE (GDState!=2) and takeoberoffice=(select groupset from sysuserlib where userid=MyPopeman);
else
SELECT COUNT(ArchivesID) into retVal FROM ArchivesTakeOver
WHERE (GDState!=2) and addman=MyPopeman
end if
return retVal;
END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货