以下是代码
<?php
// 本类由系统自动生成，仅供测试用途
class IndexAction extends Action {
public function index(){
$Dao = M('medicine_detail',null,"DB_SQLSRV");
$count = $Dao->count();// 计算总数
import("ORG.Util.Page"); // 导入分页类
$p = new Page($count, 10); // 实例化分页类
$page = $p->show(); // 分页显示输出
$list = $Dao->table('medicine_detail a,s_Developer b')->field('a.sName,b.sDevName')->where("b.sDevCode = a.sSendDept and a.dRehear between '2014-01-01' and '2015-01-01'")->limit($p->firstRow.','.$p->listRows)->order('a.dRehear')->select();
$p->setConfig('prev','上一页');
$p->setConfig('next','下一页');
$p->setConfig('first','首页');
$p->setConfig('last','尾页');
$p->setConfig('theme',"共 %totalPage% 页，共%totalRow%%header%， %first% %upPage% %linkPage% %downPage% %end%");
$p->setConfig('linkPage',',');
$page = $p->show();
// 赋值赋值
$this->assign('page', $page);
$this->assign('list', $list);
$this->display();
}
} 最佳答案
