1、选择服务商

货主选择服务商具体是指选择服务商公司中的销售人员。具体的数据表为：

select a.SupplierID,a.SupplierComID,a.SupplierTypeID,a.ShortName,b.CompanyName,a.ShortKey,b.Address from tr_comsuppliers a inner join td_company b on a.SupplierComID = b.CompanyID where a.Flag = 1 and a.CompanyID = '#{companyid}' and a.SupplierTypeID = '#{suppliertypeid}' and (b.CompanyName like '%#{supplier}%' or a.ShortName like '%#{supplier}%' or a.ShortKey like '%#{supplier}%')