科目是否使用的问题

友飞达

IF @ArApUse=1

BEGIN

IF EXISTS(SELECT top 1 cCode FROM Ap_Detail WHERE cCode=@cCode)

BEGIN

-- Result:Row=368
Col=24
Content='应收应付系统'
ID=4fc2e8cf-4bd4-4dbe-8086-1a0137786d3b

SET @cRetValue=dbo.UDF_GetResourceMessageByID('U8.CW.GL.SQL.00021')+'(Ap_Detail)'

RETURN

END

IF EXISTS(SELECT top 1 cCode FROM Ap_Vouch WHERE cCode=@cCode)

BEGIN

-- Result:Row=374
Col=24
Content='应收应付系统'
ID=da8ad8f1-8a22-4e7a-b4e0-b4132dbae5a6

SET @cRetValue=dbo.UDF_GetResourceMessageByID('U8.CW.GL.SQL.00021')+'(Ap_Vouch)'

RETURN

END

IF EXISTS(SELECT top 1 cCode FROM Ap_Vouchs WHERE cCode=@cCode)

BEGIN

-- Result:Row=380
Col=25
Content='应收应付系统'
ID=aa6c54c1-dabd-4de2-96d5-b815917d05b0

SET @cRetValue=dbo.UDF_GetResourceMessageByID('U8.CW.GL.SQL.00021')+'(Ap_Vouchs)'

RETURN

END

IF EXISTS(SELECT top 1 cCode FROM Ap_CloseBill WHERE cCode=@cCode)

BEGIN

-- Result:Row=386
Col=24
Content='应收应付系统'
ID=94620d76-d4c0-4e97-93ae-17fe05277e8f

SET @cRetValue=dbo.UDF_GetResourceMessageByID('U8.CW.GL.SQL.00021')+'(Ap_CloseBill)'

RETURN

END

IF EXISTS(SELECT top 1 cKm FROM Ap_CloseBills WHERE cKm=@cCode)

BEGIN

-- Result:Row=392
Col=24
Content='应收应付系统'
ID=144d365d-6d49-4eed-8914-5be1bacfe12f

falcon2008

来学习学习代码  有点看不懂 就认得几个数据表名称

wchl

用友里SQL高手不少嘛

李晓东

什么意思啊

youngman007

好深奥的东东{:3_60:}