File:cn/search.html
Function Code:510
Method Code:11
事务(进程 ID 85)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
select * from (select top 1 * from (select top 12 * from shopgoods where Status=1 and CatalogID=0 and GoodsCode='SY332047' and (yxUser<>1) and (Special<>1 or Special is null) order by GoodsCode asc,Grade desc,GoodsID desc) as tab1 order by goodscode desc,grade,goodsid) as tab2 order by GoodsCode asc,Grade desc,GoodsID desc
数据库执行错误
class/product.xmlc
...ct a.goodsid from shopgoods a with(nolock) left join shopitem b with(nolock) on a.Goodsid = b.Goodsid where a.goodsid=shopgoods.goodsid and a.Status=1 and a.CatalogID=0 and ( charindex('{@keyword}',b.GoodsCode1)>0 or charindex('{@keyword}',b.GoodsCode)>0 ) and (yxUser<>1{=} or yxUser={@yxUser}{=}){@SelectSpecial} ) %};
}
$else{
@where={% Status=1 and CatalogID=0{=} and {$get(attname)} like'%{@keyword}%'{=} and (yxUser<>1 or yxUser is null{=} or yxUser={@yxUser}{=}){@SelectSpecial}%};
}
@data=@query.pager(@format,*,@where,{%GoodsCode asc,Grade desc,GoodsID desc%},12,$get.number(page,1),5){
$if(@query[XDCID]<>$empty){
@XDCID={%#&:<span style="color:#0000FF;margin-left:10px;">XDCID：{@query[XDCID]}</span>%};
}
$else{
@XDCID=;
}
@showstockmsg=;
$if($session[UserID]==$null){
@showstockmsg={%#&:<div style="margin-left:10px; color:red;float:left">Please Login to see Special Offer & Quantity.</div>%};
}
$if(@query[Weight]==1){
@gyh={%#&:<span style="float: left; color:#FF870...