File:project-details.html
Method:query.map(columns,*where,*order)
关键字 'and' 附近有语法错误。
select top 1 * FROM gogoods WHERE GoodsCode= and AreaId=1
数据库执行错误
product.xmls
...
$if(@count==0){
@content=['<div style="color: #FF0000; font-size: 12px; height: 45px; line-height: 45px; text-align: center;">对不起，没有数据!</div>
'];
@Pager=$empty;
}
$return($empty);
}
//产品详情
$sub viewGoods(){
@querygoods=$query(goods,goods);
@queryfile=$query(document,download);
@gid=$http.get(gid);
@querygoods[GoodsId]=@gid;
@goodscode=@querygoods.scalar(GoodsCode,['GoodsId={*GoodsId}']);
@querygoods[GoodsCode]=@goodscode;
@AreaId=$shell[AreaId];
@querygoods[AreaId]=@AreaId;
@rowGoods=@querygoods.map(*,['GoodsCode={*GoodsCode} and AreaId={*AreaId}']);
@queryfile[GoodsCode]=@rowGoods[GoodsCode];
@queryfile[Cas]=@rowGoods[CAS];
@FilePath=@queryfile.scalar(['FilePath'],['GoodsCode={*GoodsCode} and DocumentType=1']);
@FilePath1=@queryfile.scalar(['FilePath'],['(Cas ={*Cas} and GoodsCode={*GoodsCode}) and DocumentType=0']);
@fpic=$string();
@pics=@rowGoods[Pic];
@fpic=["files/images/goods/{@pics}"];
$if(@pics==$empty||@pics==$null||@pics==NULL){
@fpic=["image/z...