// InCommand.cpp: implementation of the CInCommand class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "WhMgr.h"
#include "InCommand.h"

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

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

CInCommand::CInCommand()
{
	//初始化
	m_MaterialNum = "";
	m_Count = "";
	m_Price = "";
	m_Supplier = "";
	m_Buyer = "";
}

CInCommand::~CInCommand()
{

}

BOOL CInCommand::DoIn()
{
	//得到當前時間
	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 tblIn([MaterialNum], [Count], [Price], [Supplier], [Data], [Buyer]) Values("
		+ m_MaterialNum + ", " 
		+ m_Count + ", " 
		+ m_Price + ", \"" 
		+ m_Supplier + "\", #" 
		+ strData + "#, \"" 
		+ m_Buyer + "\")";
	//執行入庫
	if(!ExecuteSQL(strSQL))
	{
		return FALSE;
	}
	else
	{
		return TRUE;
	}
}