public function updateOpenIdQQ() { $mysql = new Mysql(); $sql = "update " . $mysql->dbpre . "user" . $mysql->debug . " set \n\t\t\tOpenIdQQ='" . $mysql->escape($this->OpenIdQQ) . "'\n\t\t\t WHERE UserId=" . intval($this->UserId); $mysql->runSql($sql); $result = $mysql->affectedRows(); $mysql->closeDb(); return $result; }
public function delete() { $mysql = new Mysql(); $sql = "delete from " . $mysql->dbpre . "hours" . $mysql->debug . "\n\t\t\t WHERE Id=" . intval($this->Id); //echo $sql; $mysql->runSql($sql); $result = $mysql->affectedRows(); $mysql->closeDb(); return $result; }
public function update() { $mysql = new Mysql(); $sql = "update " . $mysql->dbpre . "project" . $mysql->debug . " set \n\t\t\tSubject='" . $mysql->escape($this->Subject) . "',\n\t\t\tType=" . intval($this->Type) . ",\n\t\t\tDepartment=" . intval($this->Department) . ",\n\t\t\tTeam=" . intval($this->Team) . ",\n\t\t\tPublishTime='" . $mysql->escape($this->PublishTime) . "',\n\t\t\tStatus='" . $mysql->escape($this->Status) . "',\n\t\t\tHours='" . $mysql->escape($this->Hours) . "',\n\t\t\tDeveloper='" . $mysql->escape($this->Developer) . "',\n\t\t\tSchedule='" . $mysql->escape($this->Schedule) . "',\n\t\t\tDetail='" . $mysql->escape($this->Detail) . "',\n\t\t\tPv='" . $mysql->escape($this->Pv) . "',\n\t\t\tUv='" . $mysql->escape($this->Uv) . "',\n\t\t\tFans='" . $mysql->escape($this->Fans) . "',\n\t\t\tSummary='" . $mysql->escape($this->Summary) . "',\n\t\t\tUrl='" . $mysql->escape($this->Url) . "',\n\t\t\tQrCode='" . $mysql->escape($this->QrCode) . "',\n\t\t\tLaud=" . intval($this->Laud) . "\n\t\t\t WHERE Id=" . intval($this->Id); //echo $sql; $mysql->runSql($sql); $result = $mysql->affectedRows(); $mysql->closeDb(); return $result; }