select o.MfgOrderName,os.Description OrderStatus ,pb.ProductName+':'+p.ProductRevision PN,o.Qty,u.UOMName ,Format(o.PlannedCompletionDate,'yyyy/MM/dd') PlannedCompletionDate, o.SJ_ParentLot pl,p.Description dp from MfgOrder o left join OrderStatus os on o.OrderStatusId=os.OrderStatusId left join Product p on p.ProductId=(case when o.ProductId!='0000000000000000' then o.ProductId else (select pb.RevOfRcdId from ProductBase pb where pb.ProductBaseId=o.ProductBaseId) end ) left join ProductBase pb on pb.ProductBaseId=p.ProductBaseId left join UOM u on u.UOMId=o.UOMId where os.OrderStatusName='0' AND PB.ProductName LIKE '%'+?PN+'%' AND isnull(o.SJ_ParentLot,'') LIKE '%'+?pl+'%' AND p.Description LIKE '%'+?dp+'%'
修改sql之后 参数都要重新设置
