新增文章

文章标题分类内容

IF EXISTS( SELECT 1 FROM StOrder a1 JOIN ICSTJGBillEntry a2 ON a1.FClassTypeID = a2.FSourceTranType AND a1.FID = a2.FSourceInterId )
BEGIN
   DECLARE @FBillNo varchar(100) 
   
   SELECT @FBillNo = STUFF( ( 
   -------------------------------------------------------------------------------------------------------
      SELECT CHAR(10) + FBillNo FROM ( 
      -------------------------------------------------------------------------------------------------------
         SELECT DISTINCT a3.FBillNo
         FROM StOrder a1 
         JOIN ICSTJGBillEntry a2 ON a1.FClassTypeID = a2.FSourceTranType AND a1.FID = a2.FSourceInterId
         JOIN ICSTJGBill      a3 ON a2.FInterID     = a3.FInterID
      -------------------------------------------------------------------------------------------------------
      ) b1  FOR XML PATH('') 
   -------------------------------------------------------------------------------------------------------
   )  ,1,0,'') 
   
   DECLARE   @Err varchar(100)  SELECT @Err = '存在关联单据，不能反审核！'+ CHAR(10) +'请先删除【受托加工材料入库单】'+ CHAR(10) +''+ @FBillNo
   
   RAISERROR(@Err, 18, 18)
   RETURN
END

结果：
消息 50000，级别 18，状态 18，第 21 行
存在关联单据，不能反审核！
请先删除【受托加工材料入库单】

STJGIN000005
STJGIN000006
STJGIN000007