File:goods-offer.html
Method:query(table,*app,*connect)
default.manufactor
对像不存在
xmls/goods.xmls
...dId,goo.BrandName,goo.CatalogId,goo.CatalogPath,goo.Status,goo.TagIds,goo.ParentGoodsId,goo.Keyword,man.CompanyName,man.CompanyQQ,datediff(year,man.ChenliDate,getdate()) ChenliDate,man.sjTag,man.BusinessLicenceProvinceId,man.BusinessLicenceCityId,man.ManufactorId from goods_goods goo left join usmanufactor man on (goo.ManufactorId=man.ManufactorId and man.Status=1 and man.mStatus=0) where goo.Status=1 {@sqlwhere})a where RowNumber {#between(RowNumber)}']);
@querycity=$query(city,logistics);
@queryman=$query(manufactor,user);
@count=@db.dataScalar(['select count(*) from goods_goods goo left join usmanufactor man on goo.ManufactorId=man.ManufactorId where goo.Status=1 and man.Status=1 and man.mStatus=0 {@sqlwhere}']);
$if(@count==0){
@plist=['<li style="width:100%;color:red;text-align:center;font-size:15px;border:0px"><img style="width:100%;height:100%;border:0" src="images/non022.png" /></li>'];
@Pager=$empty;
}
$else{
@pagedata();
}
$return($empty);
}
$sub getSeachpara(...