File:view.html
Method:query.map(columns,*where,*order)
资源池 'internal' 没有足够的系统内存来运行此查询。
当前命令发生了严重错误。应放弃任何可能产生的结果。
select top 1 GoodsDataId,Click FROM usgoodsData WHERE GoodsName='DM-M 钢板模块式污水处理设备' and CatalogName='污水处理设备' and CompanyName='上海盛太水环机械设备有限公司' and BrandName='盛太' and CreateDate='2025-09-22 00:00:00'
数据库执行错误
xmls/goodsview.xmls
...y(goodsData,user);
@dbgoodsData[GoodsName]=@row[GoodsName];
@dbgoodsData[CatalogName]=@rowCatalog[CatalogName];
@dbgoodsData[CompanyName]=@rowmanufactor[CompanyName];
@dbgoodsData[BrandName]=@row[BrandName];
@dbgoodsData[CreateDate]=$datetime.now().toString(yyyy-MM-dd);
@goodsDataCount=@dbgoodsData.scalar(['count(*)'],['GoodsName={*GoodsName} and CatalogName={*CatalogName} and CompanyName={*CompanyName} and BrandName={*BrandName} and CreateDate={*CreateDate}']);
$if(@goodsDataCount>0){
@dbgoodsMap=@dbgoodsData.map(['GoodsDataId,Click'],['GoodsName={*GoodsName} and CatalogName={*CatalogName} and CompanyName={*CompanyName} and BrandName={*BrandName} and CreateDate={*CreateDate}']);
@dbgoodsData[GoodsDataId]=@dbgoodsMap[GoodsDataId];
@dbgoodsData.nonQuery(['update {**table} set Click=Click+1 where GoodsDataId={*GoodsDataId}']);
}
$else{
@dbgoodsData[Click]=1;
@goodsDataId=@dbgoodsData.insert(1);
}
}
$return($empty);
}