string cmd = \" select *,(select top 1 uspianfrom UserInfo where usname=wbupren) asdcliang,(selectsum(ydshuliang)from YingDanwhereWangBaInfo.wbid=YingDan.ydinfoid \" tj2 \" ) as xsydshuliang,(selectsum(ydshuliang)from YingDanwhere YingDan.ydinfoid =0\" tj2
\" ) as xsydshuliang2 from WangBaInfo \" tj \"order by wbid desc
和
select top 1((select count(wbid)*0.1from WangBaInfowhere wbupren =\'\" name \"\' and wbjianboss=true) (select count(wbid)*0.3from WangBaInfowhere wbupren =\'\" name \"\' and wbsongji=true) (select count(wbid)*0.6from WangBaInfowhere wbupren =\'\" name \"\' and wbsfhetong=true) (select count(wbid)*0.9from WangBaInfowhere wbupren =\'\" name \"\' and wbsfdingjin=true)) as \'fen\',wbid fromWangBaInfo