U9列表加计算列

1、定义sql函数

 

ALTER FUNCTION [dbo].[fn_GetItemStoreQty] ( @ItemID VARCHAR(50)   --料品ID
                                                )
RETURNS decimal(24,9)
AS 
    BEGIN
        DECLARE @StoreQty decimal(24,9)
        SET @StoreQty=0
       select  @StoreQty=isnull(sum(A.[StoreQty]),0)
  from  InvTrans_WhQoh as A 
  where  A.[ItemInfo_ItemID] = @ItemID and a.StorageType=4

        RETURN @StoreQty

    END

测试：select dbo.fn_GetIssueApproveOn('1002601060077128')

2、在\Portal\bin\script.xml下注册函数

<sql  name="GetItemStoreQty" method="fn_GetItemStoreQty" owner="dbo"/>

 3、在列表中加计算列

 

 GetItemStoreQty (SOLines.ItemInfo.ItemID)