舟山闪爸电子技术有限公司

先看效果圖:

此主題相關(guān)圖片如下：未標(biāo)題-1.gif

 

實(shí)現(xiàn)步驟:

打開自定義sql函數(shù)標(biāo)簽,新建自定義sql函數(shù)標(biāo)簽,輸入標(biāo)簽名,如下圖:

此主題相關(guān)圖片如下：未標(biāo)題-2.gif

 

查詢語句:

select ID,Tid,Title,Author,DownLB,DownYY,DownSQ,DownSize,Adddate,Hits,downcontent from KS_DownLoad where tid in({$CurrClassChildID}) order by id desc

循環(huán)體:

<style>
dt a:link, dt a:visited{font-size:14px;font-weight:bold;color:#003366}
dt a:hover{color:#ff0000;text-decoration:none}
dd {font-size:12px;color:#555;line-height:26px}
.info span{color:#ff6600}
.info a:link,.info a:visited{color:#555;text-decoration:none}
.info a:hover{color:#555}
</style>
[loop=10]
<dl>
<dt><img src="../../Images/downloadicon.gif" width="21" height="20" align="absmiddle"/><a href='{$Field(ID,GetInfoUrl,3,1)}'>{$Field(Title,Text,0,...,0,)} </a></dt>
    <dd >{$Field(downcontent,Text,200,...,0,)}</dd>

    <dd class="info"><span>更新時間：</span> {$Field(Adddate,Date,YYYY-MM-DD)} <span>&nbsp;&nbsp;語言：</span> {$Field(DownYY,Text,0,...,0,)} <span>&nbsp;&nbsp;授權(quán)：</span> {$Field(DownSQ,Text,0,...,0,)}<span>&nbsp;&nbsp;下載次數(shù)：</span> <font color=red>{$Field(Hits,Num,0,2)}</font></dd>
   </dl>
<div style="border-bottom:#ccc 1px  dashed"></div>
<br/>
[/loop]

標(biāo)簽制作完畢,打開要調(diào)用下載列表的模板,輸入標(biāo)簽如:{SQL_下載通用分頁()}