public function add() { $reValue = 0; $mysql = new Mysql(); $sql = "insert into " . $mysql->dbpre . "developer" . $mysql->debug . "(ProjectId,UserId) values(\n\t\t" . intval($this->ProjectId) . ",\n\t\t" . intval($this->UserId) . "\n\t\t)"; $mysql->runSql($sql); $reValue = $mysql->lastId(); $mysql->closeDb(); return $reValue; }
public function add() { $reValue = 0; $mysql = new Mysql(); $sql = "insert into " . $mysql->dbpre . "user" . $mysql->debug . "(Name,Email,Mobile,Role,Level,Department,Team,Ratio,Enabled) values(" . $mysql->escape($this->Name) . "',\n\t\t'" . $mysql->escape($this->Email) . "',\n\t\t'" . $mysql->escape($this->Mobile) . "',\n\t\t" . intval($this->Role) . ",\n\t\t" . intval($this->Leval) . ",\n\t\t" . intval($this->Department) . ",\n\t\t" . intval($this->Team) . ",\n\t\t" . floatval($this->Ratio) . ",\n\t\t" . intval($this->Enabled) . "\n\t\t)"; $mysql->runSql($sql); $reValue = $mysql->lastId(); $mysql->closeDb(); return $reValue; }
public function add() { $reValue = 0; $mysql = new Mysql(); $sql = "insert into " . $mysql->dbpre . "hours" . $mysql->debug . "(ProjectId,Memo,CreateTime,UserId,Hours1,Ratio,Hours2,WorkDate) values(\n\t\t" . intval($this->ProjectId) . ",\n\t\t'" . $mysql->escape($this->Memo) . "',\n\t\t'" . $mysql->escape($this->CreateTime) . "',\n\t\t" . intval($this->UserId) . ",\n\t\t" . floatval($this->Hours1) . ",\n\t\t" . floatval($this->Ratio) . ",\n\t\t" . floatval($this->Hours2) . ",\n\t\t'" . $mysql->escape($this->WorkDate) . "'\n\t\t)"; //echo $sql; $mysql->runSql($sql); $reValue = $mysql->lastId(); $mysql->closeDb(); return $reValue; }
public function add() { $reValue = 0; $mysql = new Mysql(); $sql = "insert into " . $mysql->dbpre . "project" . $mysql->debug . "(Subject,Type,CreateTime,PublishTime,Status,UserId,Department,Team,Hours,Developer,Schedule,Detail,Pv,Uv,Fans,Summary,Laud) values('" . $mysql->escape($this->Subject) . "',\n\t\t'" . $mysql->escape($this->Type) . "',\n\t\t'" . $mysql->escape($this->CreateTime) . "',\n\t\t'" . $mysql->escape($this->PublishTime) . "',\n\t\t" . intval($this->Status) . ",\n\t\t" . intval($this->UserId) . ",\n\t\t" . intval($this->Department) . ",\n\t\t" . intval($this->Team) . ",\n\t\t" . floatval($this->Hours) . ",\n\t\t'" . $mysql->escape($this->Developer) . "',\n\t\t" . intval($this->Schedule) . ",\n\t\t'" . $mysql->escape($this->Detail) . "',\n\t\t" . intval($this->Pv) . ",\n\t\t" . intval($this->Uv) . ",\n\t\t" . intval($this->Fans) . ",\n\t\t'" . $mysql->escape($this->Summary) . "',\n\t\t" . intval($this->Laud) . "\n\t\t)"; //echo $sql; $mysql->runSql($sql); $reValue = $mysql->lastId(); $mysql->closeDb(); return $reValue; }
public function add() { $reValue = 0; $mysql = new Mysql(); $sql = "insert into " . $mysql->dbpre . "memo" . $mysql->debug . "(ProjectId,Memo,CreateTime,UserId) values(\n\t\t" . intval($this->ProjectId) . ",\n\t\t'" . $mysql->escape($this->Memo) . "',\n\t\t'" . $mysql->escape($this->CreateTime) . "',\n\t\t" . intval($this->UserId) . "\n\t\t)"; //echo $sql; $mysql->runSql($sql); $reValue = $mysql->lastId(); $mysql->closeDb(); return $reValue; }
public function add() { $reValue = 0; $mysql = new Mysql(); $sql = "insert into boguan_tubu_invit (Name,Phone,Address,CreateTime) values(\n \t\t'" . $mysql->escape($this->Name) . "',\n '" . $mysql->escape($this->Phone) . "',\n \t\t'" . $mysql->escape($this->CreateTime) . "'\n \t\t)"; //echo $sql; $mysql->runSql($sql); $reValue = $mysql->lastId(); if ($mysql->errno() == 1062) { $reValue = -1; } $mysql->closeDb(); return $reValue; }
public function add() { $reValue = 0; $mysql = new Mysql(); $sql = "select count(id) from " . $mysql->dbpre . "post" . $mysql->debug . " where belong=" . intval($this->Belong) . " and subject='" . intval($this->Subject) . "'"; $count = $mysql->getVar($sql); if ($count) { return -2; } else { $sql = "insert into " . $mysql->dbpre . "post" . $mysql->debug . "( Belong, ChildIds,Subject,Content,Summary,CategoryRoot,CategoryIds,Status,DisplayOrder,CommentStatus,CommentCount,Image,\n\tCreator,\n\tCreateDate,\n\tTags,\n\tDigCount,\n\tViewCount,\n\tCreatorDetail,\n\tProperty,\n\tDisplayDate,\n\tSource,\n\tLink,\n\tMemo,\n\tKeywords) values(" . intval($this->Belong) . ",'" . $mysql->escape($this->ChildIds) . "','" . $mysql->escape($this->Subject) . "',\n\t'" . $mysql->escape($this->Content) . "',\n\t'" . $mysql->escape($this->Summary) . "',\n\t" . intval($this->CategoryRoot) . ",\n\t'," . $mysql->escape($this->CategoryIds) . ",',\n\t" . intval($this->Status) . ",\n\t" . intval($this->DisplayOrder) . ",\n\t" . intval($this->CommentStatus) . ",\n\t" . intval($this->CommentCount) . ",\n\t'" . $mysql->escape($this->Image) . "',\n\t" . intval($this->Creator) . ",\n\t'" . $mysql->escape($this->CreateDate) . "',\n\t'" . $mysql->escape($this->Tags) . "',\n\t" . intval($this->DigCount) . ",\n\t" . intval($this->ViewCount) . ",\n\t'" . $mysql->escape($this->CreatorDetail) . "',\n\t'" . $mysql->escape($this->Property) . "',\n\t'" . $mysql->escape($this->DisplayDate) . "',\n\t'" . $mysql->escape($this->Source) . "',\n\t'" . $mysql->escape($this->Link) . "',\n\t'" . $mysql->escape($this->Memo) . "',\n\t'" . $mysql->escape($this->Keywords) . "'\n\t)"; //echo $sql; $mysql->runSql($sql); $reValue = $mysql->lastId(); } $mysql->closeDb(); return $reValue; }
/** * 获取最后一次插入产生的ID * * @return \int */ public function lastId() { return $this->_db->lastId(); }