Galloping workflow engine, workflow management system, BPM software, ccflow: Secondary Development of Message Mechanism

Galloping workflow engine, workflow management system, BPM software, ccflow: Secondary Development of Message Mechanism
========================================================== ========================================
 
Overview:
1. ccflow generates many messages during running, such as sending, returning, deleting, forwarding, receiving, and listening.

2. These messages are stored in the ta_sms table after they are generated.
There is a column in ta_sms that marks the device alerttype that receives the message.
@ 0 = do not receive @ 1 = SMS @ 2 = Email @ 3 = internal message @ 4 = QQ message @ 5 = RTX message @ 6 = MSN message

3. The current ccflow function has provided the mail sending service, as long as it is enabled.
D: \ ccflow \ visualworkflowservices \ bin \ release \ visualworkflowservices.exe
It will automatically send the email to the specified receiver.
 
4. the user determines the device or form used to receive messages.
User setting steps: log on to the system and choose Settings> basic Settings> message prompting method. user-Defined information is stored in the wf_emp table. developers can develop separate pages to maintain the table based on their system requirements.

5. If you want to send messages to QQ, MSN, skpe, and SMS, or how to push messages to my system,
You have to perform secondary development.

How to push ccflow messages to my OA, CRM... system?
----------------------------------------------
1. Write a stored procedure under the ccflow Database User Name ccstaff

/* Create a stored procedure */
Create procedure ccstaff
(
@ Sender nvarchar (100 ),
@ Receivers nvarchar (2000 ),
@ Title nvarchar (100 ),
@ Context nvarchar (max)
)
As
Begin
/* Write your business logic here .*/
Set nocount on;
-- Declare @ senderid int
-- Declare @ CCS varbinary (max)
-- Declare @ BCCs varbinary (max)
-- Declare @ sendtime datetime
-- Declare @ importance nchar (2)
-- Declare @ size int
-- Declare @ hasaffixture bit
-- Declare @ affixture nvarchar (4000)
End

2. Write your business logic in the stored procedure, and ccflow pushes the message to your system.
 

How do I perform secondary development to send messages to QQ, MSN, skpe, and SMS?
----------------------------------------------
1. Write a serviceProgram, Run on the server.

2. Regularly retrieve the table ta_sms to query the messages that are not sent or newly generated messages.
Select * From ta_sms where smssta = 0

3. facilitates the collection of retrieved results and sends messages to the specified device based on the alerttype.

4. After the message is successfully sent, the message status smssta = 1 indicates that the message has been successfully sent.