findSql分页

//控制器产品列表
    function paimailist() {
        $key = urldecode($this->spArgs("key"));
        $leibei = $this->spArgs("leibei");
        $tj = $this->spArgs("tj");
        $cj = $this->spArgs("cj");

        $condition = "SELECT * FROM paimai WHERE 1=1";
        if($leibei !=0) {
        $condition .= " and leibei = '$leibei'";
        }

        if($tj != 0) {
        $condition .= " and tj = '$tj'";
        }

        if($cj != 0) {
        $condition .= " and cj = '$cj'";
        }

        if($key !=""){
             $condition .= " and title like '%$key%'";
        }
        $paimaiobj = spClass("lib_paimai");
        $this->results = $paimaiobj->spPager($this->spArgs('page', 1), 10)->findSql($condition, 'id DESC');
        $this->pager = $paimaiobj->spPager()->getPager();
        $this->key = $this->spArgs("key") ;
        $this->leibei = $this->spArgs("leibei") ;
        $this->cj = $this->spArgs("cj") ;
        $this->tj = $this->spArgs("tj") ;
        $this->display("admin/paimai_list.html");
    }

模板里面表单

<form id="form1" name="form1" method="post" action="<{spUrl c=paimai a=paimailist}>" >

                        <tr>

                            <td width="79" valign="middle">藏品名称</td>

                            <td width="222" valign="middle">

                                <input name="key" type="text" class="inp" id="key" style=" width:200px;" />

                            </td>

                            <td width="1011" valign="middle">

                                <select name="leibei" id="leibei" style="height:27px;">
                                    <option value="0" selected="selected">所有类型</option>
                                    <option value="1">瓷器预展</option>
                                    <option value="2">玉器预展</option>
                                    <option value="3">字画预展</option>
                                    <option value="4">杂项预展</option>
                                </select>
                                <input name="submit" type="submit" class="inputButton" value=" 搜 索 " />
                                <input name="tj" type="checkbox" id="tj" value="1" />
                                只查看推荐
                                <input name="cj" type="checkbox" id="cj" value="1" />
                                只查看已售</td>

                        </tr>

                    </form>

模板分页代码

<{if $pager}>

                                共有文章<{$pager.total_count}>条，共有<{$pager.total_page}>页（每页<{$pager.page_size}>篇文章）：

                                <!--在当前页不是第一页的时候，显示前页和上一页-->

                                <{if $pager.current_page != $pager.first_page}>

                                <a href="<{spUrl c=paimai a=paimailist page=$pager.first_page key=$key leibei=$leibei cj=$cj tj=$tj}>">前页</a> |

                                <a href="<{spUrl c=paimai a=paimailist page=$pager.prev_page key=$key leibei=$leibei cj=$cj tj=$tj}>">上一页</a> |

                                <{/if}>

                                <!--开始循环页码，同时如果循环到当前页则不显示链接-->

                                <{foreach from=$pager.all_pages item=thepage}>

                                <{if $thepage != $pager.current_page}>

                                <a href="<{spUrl c=paimai a=paimailist page=$thepage key=$key leibei=$leibei cj=$cj tj=$tj}>"><{$thepage}></a>

                                <{else}>

                                <b><{$thepage}></b>

                                <{/if}>

                                <{/foreach}>

                                <!--在当前页不是最后一页的时候，显示下一页和后页-->

                                <{if $pager.current_page != $pager.last_page}>

                                |

                                <a href="<{spUrl c=paimai a=paimailist page=$pager.next_page key=$key leibei=$leibei cj=$cj tj=$tj}>">下一页</a> |

                                <a href="<{spUrl c=paimai a=paimailist page=$pager.last_page key=$key leibei=$leibei cj=$cj tj=$tj}>">后页</a>

                                <{/if}>

                                <{/if}>