// OutCommand.cpp: implementation of the COutCommand class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "WhMgr.h"
#include "OutCommand.h"

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

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

COutCommand::COutCommand()
{

}

COutCommand::~COutCommand()
{

}

BOOL COutCommand::DoOut()
{
	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 tblOut([MaterialNum], [Count], [Department], [Data], [Use], [State], [Jsr], [Lqr]) Values("
		+ m_MaterialNum + ", " 
		+ m_Count + ", \"" 
		+ m_Department + "\", #" 
		+ strData + "#, \""
		+ m_Use + "\", \""
		+ m_State + "\", \""
		+ m_Jsr + "\", \""
		+ m_Lqr + "\")";

	return ExecuteSQL(strSQL);
}