File:cn/search.html
Function Code:510
Method Code:10
事务(进程 ID 104)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
select * FROM shopitem WHERE Goodsid='1849430' and status=1 and Weight<>'' and Price is not null ORDER BY Grade asc,WeightValue asc
数据库执行错误
class/product.xmlc
... %});
}
@queryitemSpe=$null;
$if($and($iif(@UserID>0),$iif($session[isSpeprice]==1))){
@queryitemSpe=$db.dataTable({%select top 22 goodscode,userid,discount,spestatus,weight from shopspegoods d with(nolock) where d.goodsid ={@goodsid} and d.userid in(-1,'{@UserID}') order by UserID desc %});
}
@AllStock=0;
$if(@queryitemAll.select(Company='Accela' or Company='韶远').count()>0){
@AllStock=@queryitemAll[0][stockall];
}
//本段and Price is not null后面原本有{@customStatus},是为了限制只有可定制客户才能看到bulk
@speclist=@queryitem.format(@format2,*,{% Goodsid='{@goodsid}' and status=1 and Weight<>'' and Price is not null %},{%Grade asc,WeightValue asc%}){
//此处限制PMS才能显示个别产品
$if($and($iif(@PMS==0),$iif($or($iif(@queryitem[Goodscode]==SYH00156),$iif(@queryitem[Goodscode]==SYH00155))),$iif(@queryitem[Weight]==1盒))){
$continue;
}
@distejia=display:none\;;
$if($session[UserID]<>$null){
@dis=;
}
$else{
@dis=display:none\;;
}
$if(@queryitemAll.select(Goodsid={@goodsid} and SpePrice>0).count()>0){
...