select  Row_number() over(order by CreateTime desc ) as id, (Cast(ProjectId as varchar(250)) +'\n'+ Cast(projectname as varchar(250))) as ProjectIdname,BidderName,contactuser,contactuserphone,

case when PayerType=1 then '报名收费' when PayerType=2 then '中标收费' when PayerType=3 then '保证金' else '' end as PayerTypeStr

,payamount,case when PayStatus=1 then '已支付' else '未支付' end as PayStatusStr,recommendusername,CreateTime  from 

(select  a.ProjectId,c.projectname,a.BidderName,contactuser,contactuserphone,payertype,payamount,paystatus,

recommendusername,a.createtime from 

(select  ProjectId,BidderId,BidderName,paystatus,payamount,createtime  from  Product_FeeBidder)a 

left join User_BiddingSubInfo b on a.BidderId=b.BiddingSubInfoid

left join Product_FeeProject  c on a.ProjectId=c.ProjectId

UNION all 

select projectid,projectname,biddername,contactuser, contactuserphone, payertype, TradeMoney, paystatus,recommendusername,CreateTime from 

(SELECT bidderid,biddername ,InSubAcc,3 as payertype,TradeMoney,1 as paystatus,CreateTime FROM Product_FNTDInAccRecord where  bidderid is not null )a 

inner join 

(SELECT ProjectId,Projectname,SubAcc FROM  Product_FNTDProjectSubAcc)b on a.InSubAcc=b.SubAcc

left join 

(SELECT BiddingSubInfoid,subname,contactuser,contactuserphone,recommenduserid,recommendusername from User_BiddingSubInfo 

where BiddingSubInfoid in (SELECT distinct bidderid FROM Product_FNTDInAccRecord))c

on a.bidderid=c.BiddingSubInfoid )data1 where  1=1 

 ${if(len(payertypestr) == 0,"","and payertypestr = '" + payertypestr + "'")}

 ${if(len(paystatusstr) == 0,"","and paystatusstr = '" + paystatusstr + "'")} 

  ${if(len(BidderName) == 0,"","and biddername like'%" + BidderName + "%'")} ${if(len(recommendusername) == 0,"","and recommendusername like'%"+recommendusername+"%'")}  

  ${if(len(创建时间)=0,""," and CreateTime>='"+创建时间+"'")} ${if(len(至)=0,""," and CreateTime<'"+至+"'")}