不能这样用,你参数里面要用帆软的函数。而不是数据库的函数
SELECT
CASE WHEN T1.TypeName IN ('贷项通知单', '贷项通知单新', '贷项账户单', '贷项账户单新') THEN T1.ARFCMoney_NonTax*-1
ELSE T1.ARFCMoney_NonTax
END ARFCMoney_NonTax
FROM dbo.AR_ARBillHead T1
WHERE (T1.BusinessType not in (9, 12, 8, 6, 5) or T1.BusinessType is null)
AND (T1.SrcType not in (7) OR T1.SrcType is null)
AND T1.Org = '1001808310074580'
AND T1.PayCust_Name NOT IN ('成都安可信电子股份有限公司', '成都安可信气体设备有限公司', '成都安讯智控自动化设备有限公司', '深圳万讯自控股份有限公司江阴分公司')
${if(len(endtime)=0,"","and T1.DisplayName='"+ format(endtime,"yyyy-MM") +"'")}
