operator.php

来自「一个通用的php网站的会员系统和通行证系统」· PHP 代码 · 共 102 行

<?php

Class Operator extends iData {

	

	/**
     * Method:	添加
	 * @param void
	 * @return boolean
     */
	function add()
	{
		global $table;
		if($this->dataInsert($table->operator))
			return true;
		else return false;
	
	}

	/**
     * Method:	更新
	 * @param int $OpID
	 * @return boolean
     */
	function update($OpID)
	{
		global $table;
 		$where="where OpID=".$OpID;
		if($this->dataUpdate($table->operator,$where))
			return true;
		else return false;
	
	}

 

	/**
     * Method: 删除
	 * @param int $OpID
	 * @return boolean
     */		
	function del($OpID)
	{
		global $table;
		$which="OpID";
		
		if($this->dataDel($table->operator,$which,$OpID,$method="="))
			return true;
		else return false;
	
	}

	function getInfo($OpID)
	{
		global $table,$db;
		$sql  ="SELECT o.*,r.*,p.*  FROM $table->operator o left join $table->resource r ON r.RID=o.RID left join $table->privilege p ON p.PID=o.PID where OpID='$OpID'";
		$result = $db->getRow($sql);
		
		return $result;
		
	}
	
	function getRecordNum()
	{
		global $table,$db;
		$sql  ="SELECT Count(*) as nr FROM  $table->operator ";
		$result = $db->getRow($sql);
		
		return $result[nr];
	}

	function getRecordLimit($start, $offset)
	{
		global $table,$db;
		 
		$sql  ="SELECT  o.*,r.*,p.*  FROM $table->operator o left join $table->resource r ON r.RID=o.RID left join $table->privilege p ON p.PID=o.PID Limit $start, $offset";
		$result = $db->Execute($sql);
		while(!$result->EOF) {
			$data[] = $result->fields;
			$result->MoveNext();
		}
		
		return $data;
	}

	function getAll()
	{
		global $table,$db;
		 
		$sql  ="SELECT  o.*,r.*,p.*  FROM $table->operator o left join $table->resource r ON r.RID=o.RID left join $table->privilege p ON p.PID=o.PID ";
		$result = $db->Execute($sql);
		while(!$result->EOF) {
			$data[] = $result->fields;
			$result->MoveNext();
		}
		
		return $data;
	
	}
}
?>