C++ (Cpp) DateTime::DateToTimestampの例

コード例 #1

ファイル: WorkTime.cpp プロジェクト: alexssource/KeeperTime

bool WorkTime::IsSet() const
{
    MYSQL_RES* res;
    string sql;
    DateTime* dayStart = new DateTime();
    DateTime* dayEnd = new DateTime();
    
    dayStart->Hour(0);
    dayStart->Minute(0);
    dayStart->Minute(0);
    dayStart->DateToTimestamp();
    
    dayEnd->Hour(23);
    dayEnd->Minute(59);
    dayEnd->Seconds(59);
    dayEnd->DateToTimestamp();
    
    sql = "SELECT `id` FROM `" + this->table + "` WHERE "
            + "`user` = " + NumberToStringConverter<int>::Convert(this->GetUser()->GetId()) + " "
            + "AND `day` > " + NumberToStringConverter<int>::Convert(dayStart->Timestamp()) + " "
            + "AND `day` < " + NumberToStringConverter<int>::Convert(dayEnd->Timestamp()) + " "
            + "LIMIT 0, 2";
    res = this->connector->Query(sql, SELECT);
    
    if(mysql_num_rows(res) != 0) {
        return true;
    }
    else {
        return false;
    }
}