File:cn/xmls/goods.xmls
Method:query.map(columns,*where,*order)
'=' 附近有语法错误。
select top 1 GoodsName,RelevantIds,GoodsId FROM cpgoods WHERE CAS=
数据库执行错误
cn/xmls/goods.xmls
...oodsName];
@queryc.insert();
$write(OK);
$end();
}
$return($empty);
}
//相关产品
$ajax GoodsTgs(){
@format=[#<li class="fl">
<a class="block" href="{~../goods/*Guid}">
<span class="block"><img class="maxwh" data-cas="{*CAS}" src="{@picc}" alt=""></span>
<div >
<p class="wot">{#left(GoodsName,20,...)}</p>
<p class="fomar wot">{*GoodsCode}</p>
</div>
</a>
</li>#];
@GuId=$post(Guid);
@querygoods=$query(goods,goods);
@querycatalog=$query(catalog,goods);
@querygoods[GuId]=@GuId;
@rowg=@querygoods.map(['GoodsName,RelevantIds,GoodsId'],['CAS={*GuId}']);
@RelevantIds=@querygoods.scalar(Relation,['CAS={*GuId}']);
$if(@RelevantIds){
@querygoods.set(RelevantIds,@RelevantIds,number);
@Goodslist=@querygoods.table(['EnGoodsName,GoodsName,CAS,GoodsCode,Guid'],['Status>0 and {*CAS in @RelevantIds}'],['GoodsId desc'],5);
@GoodsLists=@Goodslist.format(@format){
@pic=$var[GoodsCode];
$if(@pic<>$null){
@src=["/files/images/goods/{@pic}.png"];
$if($file.existsFile($file.getMapP...