$sql = "SELECT * FROM {{account}}";
        $model= Yii::app()->db->createCommand($sql)->queryAll();
        $count = count($model);
        $pages = new CPagination(count($model));
        $pages->pageSize = 1;
        $pages->applylimit($criteria);
        $model=Yii::app()->db->createCommand($sql." LIMIT :offset,:limit");
        $model->bindValue(':offset', $pages->currentPage*$pages->pageSize);
        $model->bindValue(':limit', $pages->pageSize);
        $model=$model->queryAll();
        $this->render('shouquan',array('pages'=>$pages,'list'=>$model,'count'=>$count));
 
  ####shouquan.php
 
  <?php foreach($list as $value):?>
   <?php echo $value['f'];?>
  ###字段处理
 
<?php endforeach;?>
   <?php
              $this->widget('CLinkPager',array( 'header'=>'',
                  'firstPageLabel' => '首页',
                  'lastPageLabel' => '末页',
                  'prevPageLabel' => '上一页',
                  'nextPageLabel' => '下一页',
                  'pages' => $pages,
                  'maxButtonCount'=>13 ) ); ?>