if EXISTS(
SELECT * FROM PATS_ORDER WHERE ORDER_NO=@ORDER_NO
)
BEGIN
DECLARE @REPEAT_INDICATOR CHAR(1)--长期医嘱标识
DECLARE @FREQUENCY int--需要执行次数
DECLARE @FREQ_COUNTER int --已经执行的次数
SELECT @REPEAT_INDICATOR=REPEAT_INDICATOR
,@FREQUENCY=FREQUENCY--需要执行次数
,@FREQ_COUNTER=FREQ_COUNTER--已经执行的次数
FROM PATS_ORDER WHERE ORDER_NO='1'
IF @REPEAT_INDICATOR='0'
BEGIN
UPDATE PATS_ORDER SET ORDER_STATUS=1
END
ELSE--如果是长期医嘱
BEGIN
IF @FREQ_COUNTER>=@FREQUENCY
BEGIN
UPDATE PATS_ORDER SET ORDER_STATUS=1,FREQ_COUNTER=FREQ_COUNTER+1
END
ELSE
BEGIN
UPDATE PATS_ORDER SET ORDER_STATUS=2,FREQ_COUNTER=FREQ_COUNTER+1
END
END
END
SELECT * FROM PATS_ORDER WHERE ORDER_NO=@ORDER_NO
)
BEGIN
DECLARE @REPEAT_INDICATOR CHAR(1)--长期医嘱标识
DECLARE @FREQUENCY int--需要执行次数
DECLARE @FREQ_COUNTER int --已经执行的次数
SELECT @REPEAT_INDICATOR=REPEAT_INDICATOR
,@FREQUENCY=FREQUENCY--需要执行次数
,@FREQ_COUNTER=FREQ_COUNTER--已经执行的次数
FROM PATS_ORDER WHERE ORDER_NO='1'
IF @REPEAT_INDICATOR='0'
BEGIN
UPDATE PATS_ORDER SET ORDER_STATUS=1
END
ELSE--如果是长期医嘱
BEGIN
IF @FREQ_COUNTER>=@FREQUENCY
BEGIN
UPDATE PATS_ORDER SET ORDER_STATUS=1,FREQ_COUNTER=FREQ_COUNTER+1
END
ELSE
BEGIN
UPDATE PATS_ORDER SET ORDER_STATUS=2,FREQ_COUNTER=FREQ_COUNTER+1
END
END
END