34,838
社区成员




Create PROC f_getStatus(@ordNo int)
AS
BEGIN
SELECT '处理中:'+CHAR(13)+CHAR(10)
SELECT * FROM SYSFLOW WHERE isAction ='N' AND ORDNO=@ordNo
SELECT '待处理:'+CHAR(13)+CHAR(10)
SELECT * FROM SYSFLOW WHERE isAction ='Y' AND ORDNO=@ordNo
END