这表是查询销售汇总。根据单号汇总的,
为什么同样业务主管,数据会分成两行,
然后需要找到这个单据,使用语句强行重新修改业务主管,然查询的结果就合并了。
${if(len(SendPeople)==0,"","and dbo..SendPeople = '"+SendPeople+"'")}
${if(len(PCSendPeople)==0,"","and dbo..SendPeople not like '"+PCSendPeople+"'")}
${if(len(YWY)==0,"","and dbo..YWY = '"+YWY+"'")}
${if(len(DJLX)==0,"","and dbo..DJLX = '"+DJLX+"'")}
${if(len(店名不含)==0,"","and dbo..dwmc not like '%"+店名不含+"%'")}
${if(len(验收日期)==0,"","and dbo..ysrq between '"+验收日期+"'")}
${if(len(验收截止)==0,"","and '"+验收截止+"'")}