采购报价单报表--模糊查询

代码示例

SELECT T0.[TAXDate], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[UseBaseUn]
	, T1.[PQTReqQty] AS 所需数量, T1.[PQTReqDate] AS 必需日期, T1.[ShipDate] AS 报价日期, T1.[Quantity] AS 报价数量, T1.[Price]
	, T1.[PriceAfVAT] AS 折扣后的含税单价, T1.[DiscPrcnt], T1.[LineTotal], T0.[DocStatus], T1.[VatPrcnt]
	, T4.[SlpName] AS 采购员
FROM OPQT T0
	INNER JOIN PQT1 T1 ON T0.[DocEntry] = T1.[DocEntry]
	INNER JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode]
	INNER JOIN OITB T3 ON T2.[ItmsGrpCod] = T3.[ItmsGrpCod]
	INNER JOIN OSLP T4 ON T0.[SlpCode] = T4.[SlpCode]
WHERE (T1.[ItemCode] LIKE '%%[%0]%%'
		OR '[%0]' = '')
	AND (T0.[taxDate] LIKE '%%[%2]%%'
		OR '[%2]' = '')
	AND (T0.[DocStatus] LIKE '%%[%5]%%'
		OR '[%5]' = '')
	AND (T0.[CARDCODE] LIKE '%%[%7]%%'
		OR '[%7]' = '')
	AND (T0.[CARDNAME] LIKE '%%[%8]%%'
		OR '[%8]' = '')
	AND (T4.[slpname] LIKE '%%[%9]%%'
		OR '[%9]' = '')
	AND (T0.[DOCNUM] = [%10]
		OR [%10] = '')
ORDER BY T0.[DocNum] DESC