finchina.web.exception.DAOException: select 1 as id ,symbol,100*W1NAVG as [最近一周] ,100*W4NAVG as [最近一月],100*W13NAVG as [最近三月],100*W26NAVG as [最近六月],100*W52NAVG as [最近一年],100*YTDNAVG as [年初至今],100*SLNAVG as [成立至今] from dernav a where tdate=(select max(tdate) from dernav where symbol=a.symbol) AND SYMBOL=@symbol union select 2 as id ,A.symbol AS SYMBOL,W1RETURN as W1NAVG,W4RETURN as W4NAVG,W13RETURN as W13NAVG ,W26RETURN as W26NAVG,W52RETURN as W52NAVG,YTDRETURN as YTDNAVG,slnavg from( select a.symbol,W1RETURN,W4RETURN,W13RETURN,W26RETURN,W52RETURN,YTDRETURN ,((b.tclose-1)/(a.tclose-1)-1)*100 as slnavg from ( select symbol,tclose from cihdquote x where symbol in ('000001','399001') and TDATE=(SELECT MAX(TDATE) FROM CIHDQUOTE WHERE SYMBOL=x.SYMBOL and tdate<=((select min(TDate)from dernav where symbol=@symbol)) ) )A left join( select symbol,W1RETURN,W4RETURN,W13RETURN,W26RETURN,W52RETURN,YTDRETURN ,tclose from cihdquote A where symbol in ('000001','399001') and TDATE=(SELECT MAX(TDATE) FROM CIHDQUOTE WHERE SYMBOL=A.SYMBOL) )B on a.symbol=b.symbol )A order by id,symbol select OFProfile7 as '投资目标', OFProfile22 as '投资理念', OFProfile25 as '风险收益特征', OFProfile12 as '投资范围' from OFProfile where symbol=@symbol
事务(进程 ID 63)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
在 finchina.web.data.SqlModel.Query(String key, String sql, SqlParameter[] parameters) 位置 E:\sourceCode\BJYHfund\finchina\finchina\web\data\SqlModel.cs:行号 142
在 finchina.web.data.DbModel.Query(String type, String key, String sql, SqlParameter[] parameters) 位置 E:\sourceCode\BJYHfund\finchina\finchina\web\data\DbModel.cs:行号 150
在 finchina.web.data.DbModel.Query(String sql, SqlParameter[] parameters) 位置 E:\sourceCode\BJYHfund\finchina\finchina\web\data\DbModel.cs:行号 121
在 FundBase_fundGK.bindData(String symbol)
欢迎光临北京银行网站 BANK OF BEIJING
