Viewing file:  da_umgpermission.php (1.23 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
class Da_umgpermission extends CI_Model {
// PK is gpGpID
// PK is gpMnID
public $gpGpID;
public $gpMnID;
public $gpSeq;
public $gpX;
public $gpC;
public $gpR;
public $gpU;
public $gpD;
function Da_umgpermission() {
parent::__construct();
$this->db = $this->load->database('ums', TRUE);
}
function insert() {
$sql = "INSERT INTO umgpermission (gpSeq, gpX, gpC, gpR, gpU, gpD)
VALUES(?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->gpSeq, $this->gpX, $this->gpC, $this->gpR, $this->gpU, $this->gpD));
}
function update() {
$sql = "UPDATE umgpermission SET
gpSeq = ?,
gpX = ?,
gpC = ?,
gpR = ?,
gpU = ?,
gpD = ?
WHERE gpGpID = ? AND gpMnID = ? ";
$this->db->query($sql, array($this->gpSeq, $this->gpX, $this->gpC, $this->gpR, $this->gpU, $this->gpD, $this->gpGpID, $this->gpMnID));
}
function delete($key1, $key2) {
$sql = "DELETE FROM umgpermission WHERE gpGpID = ? AND gpMnID = ? ";
$this->db->query($sql, array($key1, $key2));
}
function getByKey($key1, $key2) {
$sql = "SELECT * FROM umgpermission WHERE gpGpID = ? AND gpMnID = ? ";
$query = $this->db->query($sql, array($key1, $key2)) ;
return $query ;
}
} //=== end class da_umgpermission
?>
|