计算2 TDateTime之间的时间 [英] Calculate time between 2 TDateTime, with a twist
本文介绍了计算2 TDateTime之间的时间的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要弄清楚如何获得两次之间的时间,但是只有在工作时间之内(存储在数据库中)
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屋!
查看全文