smartcost/protected/model/CategoryDao.php

<?php

class CategoryDao {
	
	public $displayorder;
	public $cid;
	public $name;
	public $pid;
	public $grade;
	public $_table = 'zhhelp_category';
	public $_primarykey = "cid";
	public $_fields = array ('displayorder','cid', 'name', 'pid', 'grade'  );
	
	/**
	 * 获取分类等级
	 * @param unknown_type $grade
	 */
	function get_category_by_grade($grade = 1) {
		$sql = "select displayorder,cid, name, pid, grade from " . $this->_table . " where grade=" . $grade;
		$query = Doo::db ()->query ( $sql );
		$result = $query->fetchAll ();
		return $result;
	}
	
	/**
	 * 获取分类 根据ID
	 * @param unknown_type $id
	 */
	function get_category_by_cid($cid = 0) {
		$sql = "select displayorder,cid, name, pid, grade from " . $this->_table . " where cid=" . $cid;
		$query = Doo::db ()->query ( $sql );
		$result = $query->fetch ();
		return $result;
	}
	
	/**
	 * 获取子类
	 * @param unknown_type $cid
	 */
	function get_category_by_pid($cid = 0) {
		$sql = "select displayorder,cid, name, pid, grade from " . $this->_table . " where pid=" . $cid;
		$query = Doo::db ()->query ( $sql );
		$result = $query->fetchAll ();
		return $result;
	}
}

?>