USE [XXXXX]
GO
/****** Object: Trigger [dbo].[trg_Biz_Samp_19] Script Date: 2016/4/22 9:58:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--------先接收任务再样品领取,结果登记提示--------------
ALTER trigger [dbo].[trg_Biz_Samp_19] ON [dbo].[biz_Samp]
AFTER insert,UPDATE
AS
BEGIN
IF UPDATE(SampStatusId)
BEGIN
declare @batchid uniqueidentifier = newid();
BEGIN TRAN
INSERT INTO GNotification(GContent, GNavigateUri, BizId, CreateBatchId)
SELECT '您有新的待办事项【结果登记】: ' , 'f103015' ,INSERTED.SampId, @batchid
FROM INSERTED
INNER JOIN DELETED ON DELETED.SampId = INSERTED.SampId
left join biz_DeptTask on biz_DeptTask.TaskId = INSERTED.TaskId
WHERE
INSERTED.SampStatusId != DELETED.SampStatusId
and INSERTED.SampStatusId = 420
and exists(select 1 from biz_DeptTask where TestStatusId >= 310 )
--and INSERTED.TaskId = biz_DeptTask.TaskId) ----确保是
触发器,根据具体业务写弹窗提示
本文讨论如何在数据库中利用触发器根据业务需求创建弹窗提示。通过实例解析触发器的工作原理,阐述如何在特定操作后向用户显示警告或确认信息,以提升用户体验并确保数据一致性。
摘要由CSDN通过智能技术生成