//-------------------------- //获取上一篇，下一篇链接 //-------------------------- function GetPreNext() { $rs = ""; $aid = $this->ArcID; $rid = $this->Fields['typeid']; $next = " #@__archives.ID>'$aid' and #@__archives.typeID='$rid' order by #@__archives.ID asc "; $pre = " #@__archives.ID<'$aid' and #@__archives.typeID='$rid' order by #@__archives.ID desc "; //$next = " #@__archives.ID>'$aid' order by #@__archives.ID asc "; //$pre = " #@__archives.ID<'$aid' order by #@__archives.ID desc "; $query = "Select #@__archives.ID,#@__archives.title, #@__archives.typeid,#@__archives.ismake,#@__archives.senddate,#@__archives.arcrank,#@__archives.money, #@__arctype.typedir,#@__arctype.typename,#@__arctype.namerule,#@__arctype.namerule2,#@__arctype.ispart, #@__arctype.moresite,#@__arctype.siteurl  from #@__archives left join #@__arctype on #@__archives.typeid=#@__arctype.ID where "; $nextRow = $this->dsql->GetOne($query.$next); $preRow = $this->dsql->GetOne($query.$pre); if(is_array($preRow)){ $mlink = GetFileUrl($preRow['ID'],$preRow['typeid'],$preRow['senddate'],$preRow['title'],$preRow['ismake'],$preRow['arcrank'],$preRow['namerule'],$preRow['typedir'],$preRow['money'],true,$preRow['siteurl']); $rs .= "上一篇：<a href='$mlink'>{$preRow['title']}</a> "; } else{ $rs .= "上一篇：没有了 "; } if(is_array($nextRow)){ $mlink = GetFileUrl($nextRow['ID'],$nextRow['typeid'],$nextRow['senddate'],$nextRow['title'],$nextRow['ismake'],$nextRow['arcrank'],$nextRow['namerule'],$nextRow['typedir'],$nextRow['money'],true,$nextRow['siteurl']); $rs .= "   下一篇：<a href='$mlink'>{$nextRow['title']}</a> "; } else{ $rs .= "   下一篇：没有了 "; } return $rs; }