Viewing file:  da_umpermission.php (1.27 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
class Da_umpermission extends CI_Model {
// PK is pmUsID
// PK is pmMnID
public $pmUsID;
public $pmMnID;
public $pmSeq;
public $pmX;
public $pmC;
public $pmR;
public $pmU;
public $pmD;
function Da_umpermission() {
parent::__construct();
$this->db = $this->load->database('ums', TRUE);
}
function insert() {
$sql = "INSERT INTO umpermission (pmSeq, pmX, pmC, pmR, pmU, pmD)
VALUES(?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->pmSeq, $this->pmX, $this->pmC, $this->pmR, $this->pmU, $this->pmD));
}
function update() {
$sql = "UPDATE umpermission SET
pmSeq = ?,
pmX = ?,
pmC = ?,
pmR = ?,
pmU = ?,
pmD = ?
WHERE pmUsID = ? AND pmMnID = ? ";
$this->db->query($sql, array($this->pmSeq, $this->pmX, $this->pmC, $this->pmR, $this->pmU, $this->pmD, $this->pmUsID, $this->pmMnID));
}
function delete($key1, $key2) {
$sql = "DELETE FROM umpermission WHERE pmUsID = ? AND pmMnID = ? ";
$this->db->query($sql, array($key1, $key2));
}
function getByKey($key1, $key2) {
$sql = "SELECT * FROM umpermission WHERE pmUsID = ? AND pmMnID = ? ";
$query = $this->db->query($sql, array($key1, $key2)) ;
return $query ;
}
} //=== end class da_umpermission
?>
|