对应sqlselect * from t_projectgoods left join v_supplieragreement as agreement on agreement.brandguid = t_projectgoods.goodsbrandguid and agreement.goodsclassguid = t_projectgoods.goodsclassguidwhere agreement.agreementtype = 3 and agreement.auditstatus = 1and supplierguid = #{} and projectguid = #{}
