46 lines
1.3 KiB
Plaintext
46 lines
1.3 KiB
Plaintext
CREATE PROC DBO.GEXBPM_SENDMAILNOW
|
|
AS
|
|
/*
|
|
Function : FLOW 立刻發 MAIL 給所有待簽的人
|
|
Description: 本 SP 修改自 GEXBPM_DELAYSEND(催簽)
|
|
本 SP 是立刻再發送 MAIL 給目前待簽的人, 不管是否已逾期
|
|
Build Date : 2013/08/22
|
|
|
|
Modify History
|
|
Item Who Date Modify Docs
|
|
==== ========== ========== ================================================
|
|
|
|
*/
|
|
|
|
DECLARE @BILLNO VARCHAR(20)
|
|
DECLARE @SIGNPERSON VARCHAR(20)
|
|
DECLARE @AGENTID VARCHAR(20)
|
|
DECLARE @SIGN_TITLE NVARCHAR(100)
|
|
DECLARE @STITLE NVARCHAR(100)
|
|
|
|
DECLARE contact_cursor CURSOR FOR
|
|
SELECT BILLNO,SIGNPERSON,SIGN_TITLE,AGENTID FROM BPM_FLOWDATA_D WHERE FLOWSTATUS = 0
|
|
|
|
OPEN contact_cursor
|
|
|
|
-- Perform the first fetch.
|
|
FETCH NEXT FROM contact_cursor
|
|
INTO @BILLNO,@SIGNPERSON,@AGENTID,@SIGN_TITLE
|
|
|
|
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
|
|
WHILE @@FETCH_STATUS = 0
|
|
BEGIN
|
|
--發送 mail
|
|
SET @STITLE = '(催簽) ' + @SIGN_TITLE
|
|
EXEC GEX_SEND_FLOWMAIL 'S',@SIGNPERSON, @BILLNO, @STITLE
|
|
|
|
SET @STITLE = '(催簽:代理人) ' + @SIGN_TITLE
|
|
IF ISNULL(@AGENTID,'') <> '' EXEC GEX_SEND_FLOWMAIL 'S',@AGENTID, @BILLNO, @STITLE
|
|
|
|
FETCH NEXT FROM contact_cursor
|
|
INTO @BILLNO,@SIGNPERSON,@AGENTID,@SIGN_TITLE
|
|
END
|
|
|
|
CLOSE contact_cursor
|
|
DEALLOCATE contact_cursor
|