File:cn/search.html
Function Code:510
Method Code:11
事务(进程 ID 56)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
select count(*) from [shopgoods] where Status=1 and CatalogID=0 and isEducation=0 and yxUser=0 and Special=0 and GoodsCode='SY291158'
数据库执行错误
class/product.xmlc
...($get(attname,1)==MDL),$iif($get(attname,1)==MF))){
@where={% Status=1 and CatalogID=0{=} and contains({$get(attname,1)},'"{@keyword}"') {@whereEdu} {@whereAgent} {@yxUser} {@SelectSpecial} %};
}
$else{
@where={% Status=1 and CatalogID=0{=} and {$get(attname,1)} like '%{@keyword}%' {@whereEdu} {@whereAgent} {@yxUser} {@SelectSpecial} %};
}
}
////在此处判断输入内容是否是CAS,按照CAS长度排序
@orderStr=;
$if($regex.isMatch(@keyword,^\\d+\\-\\d{2}\\-\\d{1}$)==1){
@orderStr={%len(CAS) asc,%};
}
//分页
@data=@query.pager(@format,{%*,replace(Goodscode,'SY','0SY') as Goodscodea %},@where,{%#&: {@orderStr} Grade asc,GoodsID asc%},12,@page,5){
//$write($datetime.now());
//$write(--);
//判断是否耗材显示
@CAS=;
@MDL=;
@enName=;
@gyh=;
@purityTitle=;
@purityTd=;
@shuoming=;
@cankaoPrice=;
@maxunit=0;
@stockPurity=;
@ee=;
@ckChunchu=;
@zctj=;
@brandid=@query[brandid];
@goodsid=@query[goodsid];
@stockshTitle={%#&:<td>库存</td> %};
@stockjnTitle=;
@stockqdTitle=;
@stockcdTitle=;
@st...