File:en/ProductsThr.htm
Method:query.dataTable(sql)
事务(进程 ID 63)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 select top(3) * from cpgoods where CatalogId='609' and GoodsCode<>'Deoxynivalenol' ORDER BY NEWID()
数据库执行错误
themes/theme/en/xmls/engoods.xmls
...d Cas={*Cas}'],['Title desc']);
$return(@FileName);
$end();
}
$return($empty);
}

//��ز�Ʒ
$ajax GoodsTgs(){
@format=[#
<li>
<a href="{~ProductsThr/*GoodsCode}"><h1>{#left(EnGoodsName,20,...)}</h1></a>
<p>{*Description}</p>
</li>
#];
@query=$query(goods,goods);

@Guid=$argv(0,$null);
@cid=@query.scalar(CatalogId,['CAS='{@Guid}' or GoodsCode='{@Guid}' or EngoodsName='{@Guid}'']);

@ct=@query.dataScalar(['select COUNT(*) from cpgoods where CatalogId='{@cid}' ']);
$if(@ct>1){
@table=@query.dataTable(['select top(3) * from cpgoods where CatalogId='{@cid}' and GoodsCode<>'{$argv(0)}' ORDER BY NEWID()']);
@list=@table.format(@format);
}
$else{
@list=$empty;
}



$write(@list);
}

//��ز�Ʒ
$ajax GoodsTgssssss(){
@format=[#
<li>
<a href="{~ProductsThr/*GoodsCode}"><h1>{#left(EnGoodsName,20,...)}</h1></a>
<p>{*EnBody}</p>
</li>
#];
@query=$query(goods,goods);

@Guid=$argv(0,$null);
@row=@query.dataMap(['select * from cpgoods where CAS='{@Guid}' or Good...