File:cn/productview.html
Function Code:510
Method Code:11
事務(進程 ID 52)與另一個進程被死鎖在 鎖 資源上，并且已被選作死鎖犧牲品。請重新運行該事務。
select count(*) from [shopitem] where goodsid='160873' and status=1 and WeightValue is not null and Weight<>'' and Price is not null
數據庫執行錯誤
class/product.xmlc
...<a href="{*last}" class="aa">末頁</a>
</li><li>
<span class="ipaget" style="display:inline;">第{*page}頁 共{*pages}頁 共:{*total}個</span>
</li>
%};
@queryitem=$query(item,goods);
@goodsid=$get.number(goodsid);
@maxunit=0;
@unit=g;
@goods=$db.dataTable({% select goodscode,goodsid,brandid from shopgoods with(nolock) where status=1 and goodsid={@goodsid} ; %});
$if($or($iif(@goods==$null),$iif(@goods.count()==0))){
$write(您查看的產品已下架！);
$end();
}
@brandid=@goods[0][brandid];
@distj=;
@data=@queryitem.pager(@format,*,goodsid='{@goodsid}' and status=1 and WeightValue is not null and Weight<>'' and Price is not null ,{%Grade asc,weightvalue asc%},10,$get.number(page,1),10){
$if($session[UserID]<>$null){
@dis=;
}
$else{
@dis=display:none\;;
}
//此處限制PMS才能顯示個別產品
$if($and($iif(@PMS==0),$iif($or($iif(@queryitem[Goodscode]==SYH00156),$iif(@queryitem[Goodscode]==SYH00155))),$iif(@queryitem[Weight]==1盒))){
$continue;
}
//合全沒價格的不顯示
$if($and($iif($or($iif(@UserID==1111111),$ii...