触发器，弹出窗口，合同状态改变时。

客户要求系统具有类似QQ弹窗的效果，当一条流程状态改变时，另一用户只要开着客户端，右下角弹窗。

USE [XXXXX]
GO
/****** Object:  Trigger [dbo].[trg_biz_Cont]    Script Date: 2016/4/28 11:21:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER TRIGGER [dbo].[trg_biz_Cont] ON [dbo].[biz_Cont] AFTER INSERT, UPDATE
AS 
BEGIN
  IF UPDATE(ContStatusId)
  BEGIN


 declare @batchid uniqueidentifier = newid();


 WITH CTE_ToDo_DeptTask AS 
 (
 SELECT 10102 AS BizTypeId, '处理监督' AS ToDo, 'f101002' AS Uri, 100 AS ContStatusId
 UNION
 SELECT 10103, '处理检验', 'f101501', 100
 UNION
 SELECT 10104, '处理计量', 'f101502', 100
 UNION
 SELECT 0, '评审合同', 'f101004', 110
 UNION
 SELECT 0, '签发合同', 'f101006', 120
 UNION
 SELECT 10101, '分配委托任务', 'f101007', 130
 )
 INSERT INTO GNotification(GContent, GNavigateUri, BizId, CreateBatchId)
 SELECT '您有新的待办事项【' + CTE_ToDo_DeptTask.To