|
Crystal Reports 和sql-server共同进行报表的开发--存储过程-实践(6) FETCH NEXT FROM cur2_2 INTO @userid
END
CLOSE cur2_2
DEALLOCATE cur2_2
DROP TABLE #temp_proc2_1
SELECT * FROM #temp_proc2
DROP TABLE #temp_proc2
GO
fgw_proc2_1.txt
--fgw_proc2_1
CREATE PROCEDURE [AHD].[fgw_proc2_1](@call_req_id char(30) , @level char(30) , @time_stamp int , @isOK int OUTPUT)
AS
SET NOCOUNT ON
SET @isOK = 0 DECLARE cur_zh CURSOR FOR SELECT time_stamp FROM AHD.AHD.ztr_his WHERE call_req_id = @call_req_id and to_status in ('L1WIP','L2WIP') and time_stamp>@time_stamp
OPEN cur_zh
DECLARE @time_stamp1 int
SET @time_stamp1=0 FETCH cur_zh INTO @time_stamp1
IF (@time_stamp1 is not null) and (@time_stamp1<>0)
BEGIN
IF CHARINDEX('一级', @level) IS NOT NULL AND CHARINDEX('一级', @level)<>0
BEGIN
if @time_stamp1 - @time_stamp <600
SET @isOK=1
END
ELSE IF CHARINDEX('二级', @level) IS NOT NULL AND CHARINDEX('二级', @level)<>0
BEGIN
if @time_stamp1 - @time_stamp <1800
SET @isOK=1
END
ELSE IF CHARINDEX('三级', @level) IS NOT NULL AND CHARINDEX('三级', @level)<>0
BEGIN
if @time_stamp1 - @time_stamp <1800
SET @isOK=1
END
ELSE IF CHARINDEX('四级', @level) IS NOT NULL AND CHARINDEX('四级', @level)<>0
BEGIN
if @time_stamp1 - @time_stamp <1800
|
