File:en/serch-list.htm
Method:query.pager(columns,where,order,size,page,*countVar)
事务(进程 ID 65)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
select * from (select top 1 * from (select top 10 * from cpgoods where Status=1 and AreaId=2 and (CAS like '%M19955%' or EnGoodsName like '%M19955%' or GoodsCode like '%M19955%') order by GoodsId desc) as tab1 order by goodsid) as tab2 order by GoodsId desc
数据库执行错误
en/xmls/engoods.xmls
...bles1.format(@format);
$if(@list==$empty){
@list=["<p style="text-align: center;color: red;">No data!</p>"];
}
$if(@tables1.count()==0){
@sty=["display:none"];
}
$else{
@sty=[""];
}
//ƴ�����id
@CatalogIds=$string();
//�����������ֵ��ѯ�Ľ����ȡ
@cc=@query.pager(*,['Status=1 and AreaId=2 and (CAS like '%{@keywords}%' or EnGoodsName like '%{@keywords}%' or GoodsCode like '%{@keywords}%') {@wheresql}'],['GoodsId desc'],@number,$get(page,1));
@cclist=@cc.format(@f){
@CatalogIds.append(["{$var[CatalogId]},"]);
}
@CatalogIds=@CatalogIds.remove(-1);
$if(@CatalogIds){
//��ѯBy Targets�µķ��� Product
//查询分类名对应，再根据查询结果向上查询所属分类
@Targets=@query.dataTable(['select * from cpcatalog where ( CatalogName like '%{@keywords}%' or CatalogId in({@CatalogIds}) ) and AreaId=2 and CatalogPath like '%,2,%' ']);
//@Targets=@query.dataTable(['select * from cpcatalog where CatalogId in({@CatalogIds}) and AreaId=2 and CatalogPath like '%,2,%'']);
@Product=@Targets.format(@formatcatalog){
@cnums...