计算2 TDateTime之间的时间 [英] Calculate time between 2 TDateTime, with a twist

问题描述

我需要弄清楚如何获得两次之间的时间，但是只有在工作时间之内（存储在数据库中）

I need to find out how to get the time between 2 times, but only if it is within work hours(Stored in a database)

这就是我的时间现在知道了，但这是完全错误的。总计不会正确。

This is what I got for now, but it is totally wrong. the total won't bee correct.

int __fastcall Organisasjon::CalculateResponsetimeInOpeninghours(std::auto_ptr<DBCommand> cmd, long orgid, TDateTime starttimeIn, TDateTime endtimeIn)
{
int totalTimeInQueue = 0;
String sIsWorkDay = "";

String s  =  "SELECT o.isworkday, o.workdate, o.workstarttime, o.workendtime " \
                 "FROM orgwdexcep o " \
                 "WHERE o.workdate = :date " \
                 "AND o.orgid = :orgid ";
String s2 =  "SELECT o.isworkday, o.workdate, o.workstarttime, o.workendtime " \
                 "FROM globalwodexcep o " \
                 "WHERE o.workdate = :date ";
String s3 =  "SELECT o.workstarttime, o.workendtime " \
                 "FROM organizationworkday o " \
                 "WHERE o.weekdayindex = :weekdayindex " \
                 "AND o.orgid = :orgid ";
double MailThisDayStart = starttimeIn;
double MailThisDayEnd = endtimeIn;

while ((int)MailThisDayStart <= (int)endtimeIn)
{//for each day i period.
    if((int)MailThisDayStart != (int)endtimeIn)
    {
        MailThisDayEnd = (double)((long)MailThisDayEnd) + 1;
}
    cmd->setCommandText(s);
    cmd->Param( "date" ).setAsDateTime() = DBDatabase::ConvertToSADateTime(MailThisDayStart);
    cmd->Param("orgid").setAsLong() = orgid;
    cmd->Execute();
    if (!(cmd->isResultSet() && cmd->FetchNext()))
    {
        cmd->setCommandText(s2);
        cmd->Param( "date" ).setAsDateTime() = DBDatabase::ConvertToSADateTime(MailThisDayStart);
        cmd->Execute();
    }
    if(cmd->isResultSet() && cmd->FetchNext())
    {
      sIsWorkDay = String(cmd->Field("isworkday").asString());
    }
    else
    {
        int dayOfTheWeek = DayOfTheWeek(MailThisDayStart);
        cmd->setCommandText(s3);
        cmd->Param("weekdayindex").setAsLong() = dayOfTheWeek;
        cmd->Param("orgid").setAsLong() = orgid;
        cmd->Execute();
        if(cmd->isResultSet() && cmd->FetchNext())
        {
            sIsWorkDay = "T";
  }
    }
    if(sIsWorkDay == "T")
    {
        TDateTime tmpOpeningStart =  TDateTime(cmd->Field("workstarttime").asDateTime());
        TDateTime tmpOpeningEnd = TDateTime(cmd->Field("workendtime").asDateTime());
        double dtmpOpeningStart = tmpOpeningStart- (int)tmpOpeningStart;
        double dtmpOpeningEnd = tmpOpeningEnd- (int)tmpOpeningEnd;

        totalTimeInQueue +=  Organisasjon::CountHours(MailThisDayStart, MailThisDayEnd, dtmpOpeningStart, dtmpOpeningEnd,(int)MailThisDayStart);
    }
    MailThisDayStart++;//increase date by one
    MailThisDayStart = (double)((long)MailThisDayStart);
}
return totalTimeInQueue;
}

int __fastcall Organisasjon::CountHours(double MailTimeStart, double MailTimeEnd, double openingTimeStart, double openingTimeEnd, int DayToCompute)
{
   if(MailTimeEnd<openingTimeStart)
   {
       return 0;
       }
   if(MailTimeStart<(DayToCompute+openingTimeStart))
   {
       MailTimeStart=openingTimeStart;
   }
   else
   {
        MailTimeStart=MailTimeStart-(int)MailTimeStart;
   }
   if(MailTimeEnd>(DayToCompute+openingTimeEnd))
   {
    MailTimeEnd=openingTimeEnd;
   }
   else
   {
    MailTimeEnd=MailTimeEnd-(int)MailTimeEnd;
   }
   TDateTime dt = TDateTime((MailTimeEnd - MailTimeStart));
   unsigned short milli;
   unsigned short sec;
   unsigned short min;
   unsigned short hour;
   dt.DecodeTime(&hour,&min,&sec,&milli);
   int total = hour*3600;
   total += min*60;
   total += sec;
   return total;
}

推荐答案

您想看到什么在总计中？

尝试以下示例：

TDateTime MailTimeEnd = TDateTime::CurrentTime();;
MailTimeEnd += 1.0 / 24;
TDateTime MailTimeStart = TDateTime::CurrentTime();
TDateTime dt = TDateTime((MailTimeEnd - MailTimeStart));
unsigned short milli;
unsigned short sec;
unsigned short min;
unsigned short hour;
dt.DecodeTime(&hour,&min,&sec,&milli);
int total = hour*3600;
total += min*60;
total += sec;

总计== 3600 。是的。

这篇关于计算2 TDateTime之间的时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！