管家婆财贸双全提示此记录为系统会计科目禁止删除处理方法

P_BAS_DeleteBaseInfo删除判断的存储过程，重点检查EXISTS语句后面括起来的数据库记录，如果在数据库存在记录，先删除记录

开始判断系统科目
IF (EXISTS(SELECT * FROM atypecw WHERE typeid = @typeid AND sysrow<>0)) OR
(EXISTS(SELECT * FROM T_CW_SetAtypeList WHERE atypeid = @typeid))
BEGIN
SELECT @prm_ErrorMsg='此记录为系统会计科目'
RETURN -5
END

DECLARE @TradeId INT
SELECT @TradeId = CAST(SubValue AS INT)
FROM dbo.T_GBL_SysDataCW
WHERE SubName = 'TradeId'
SELECT ProjectNameEn, atypeID, LEN(atypeID) AS ATypeLen
INTO #DefaultSubjectContrast
FROM dbo.T_CW_TradeSubjectContrast
WHERE TradeID = @TradeId AND IsVisible = 1
IF EXISTS (SELECT * FROM T_CW_SubjectContrast WHERE atypeid = @typeid AND IsVisible = 1 AND LEN(@typeid) < 15)
BEGIN
SELECT @prm_ErrorMsg='此记录为系统会计科目'
RETURN -5
END