// ReturnCommand.cpp: implementation of the CReturnCommand class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "WhMgr.h"
#include "ReturnCommand.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CReturnCommand::CReturnCommand()
{

}

CReturnCommand::~CReturnCommand()
{

}

void CReturnCommand::DoReturn()
{
	CString strData;
	CTime time = CTime::GetCurrentTime();
	strData.Format("%d-%d-%d %d:%d:%d", 
		time.GetYear(), 
		time.GetMonth(), 
		time.GetDay(),
		time.GetHour(),
		time.GetMinute(),
		time.GetSecond());

	CString strSQL;
	strSQL = "Insert into tblReturn([Count], [OutInfo], [Data], [Jsr], [Ghr]) Values("
		+ m_Count + ", \"" 
		+ m_OutInfo + "\", #" 
		+ strData + "#, \"" 
		+ m_Jsr + "\", \""
		+ m_Ghr + "\")";
	if(!ExecuteSQL(strSQL))
	{
		::AfxMessageBox("歸還失敗！");
	}
}