AND (a.ColorDesc =@Color or isnull(@Color,'') = '')
AND (a.tempt =@tempt or isnull(@tempt ,'') = '')
条件中,如果@tempt 这些参数不为空的时候,则直接等,如果参数是空的
时候,紫色赋‘’给它。
AND (a.ColorDesc =@Color or isnull(@Color,'') = '')
AND (a.tempt =@tempt or isnull(@tempt ,'') = '')
条件中,如果@tempt 这些参数不为空的时候,则直接等,如果参数是空的
时候,紫色赋‘’给它。