A BUG Correction of Aopeng ERP system

There is a BUG in the user table of Aopeng ERP system. Users who are in normal use can delete it directly after clicking on it, and I happen to have stepped on it and suffocated to death. This correction is specially made.

Code:

/ * * Object: Trigger [dbo]. [otri_user_del] Script Date: 03Universe 11:31:08 * * /

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/-

Name: otri_user_del

Function description: it is not allowed to delete an account in the "available" status. To delete an account, you must first undisable it.

Access method: public

Return value: NumberA

Designer: Lu Jinyuan

Date of creation: 03Compact 06Universe 2019

Version:: 1.0

Description of the change:

-- /

ALTER TRIGGER [dbo]. [otri_usergroup_del] ON [dbo]. [osys_usergroup]

FOR DELETE

AS

Declare @ error int

Set @ error= (select act_sw from deleted)

IF @ error! = 0

Begin

Raiserror ('to ensure security, it is not allowed to delete accounts in the 'available' status', 16p1)

Rollback

End