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();
}
