22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER [dbo].[CW_XTKe_trigger] ON [dbo].[CW_XueFen_Detail]
WITH EXECUTE AS CALLER
AFTER INSERT
AS
DECLARE @elective_id varchar (50)
--选课ID
DECLARE @flag int
--支付状态 0 缴费 1 退费
DECLARE @teachclass_id varchar (50)
-- 教学班ID
SELECT @flag = i.flag,
@elective_id = i.creditID
FROM inserted i
IF (@flag = 0)
BEGIN
UPDATE [CSDN_ColligateCharge_SS]..t_edu_TeachClassStudentList
SET paied = 1
WHERE ID =@elective_id
END
ELSE
BEGIN
select @teachclass_id = teachclass_id from [CSDN_ColligateCharge_SS]..t_edu_TeachClassStudentList
where ID =@elective_id
DELETE
FROM [CSDN_ColligateCharge_SS]..t_edu_TeachClassStudentList
WHERE ID =@elective_id
UPDATE [CSDN_ColligateCharge_SS]..t_edu_TeachClassInfo
SET current_capacity = current_capacity - 1
WHERE ID = @teachclass_id
END
建议加上回滚的事务..