logdao.cpp

RFID小区车库管理系统。实现车辆的合法性检查和计费管理。

// LogDAO.cpp: implementation of the CLogDAO class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "CMS.h"
#include "LogDAO.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
inline void TESTHR(HRESULT x) {if FAILED(x) _com_issue_error(x);};

CLogDAO::CLogDAO(_ConnectionPtr pConnection)
{
	m_pConnection = pConnection;
}

CLogDAO::~CLogDAO()
{

}

_RecordsetPtr CLogDAO::SelectLogByUser(CString strUserID)
{
	_ConnectionPtr pConnection = NULL;
	_RecordsetPtr pRecordset = NULL;
	_CommandPtr pCommand = NULL;
	try
	{
		TESTHR(pConnection.CreateInstance(__uuidof(Connection)));
		HRESULT hr = pConnection->Open("driver={SQL Server};Server=WANYONGCHAO; \
			DATABASE=CMS; UID=sa; PWD=chenlidong;","","",adModeUnknown);

		
		//创建Command对象
		TESTHR(pCommand.CreateInstance(__uuidof(Command)));
		pCommand->CommandText = "Select_Log_By_User";
		pCommand->CommandType = adCmdStoredProc;
		pCommand->ActiveConnection = pConnection;
		
		//添加多个参数
		pCommand->Parameters->Refresh();
		pCommand->Parameters->Item[_variant_t((long)1)]->Value = (_bstr_t)strUserID;

		_variant_t vNull;
		vNull.vt=VT_ERROR;
		vNull.scode=DISP_E_PARAMNOTFOUND;
		pRecordset = pCommand->Execute(&vNull ,&vNull ,adCmdStoredProc);
	}
	catch(_com_error e)
	{
        _bstr_t bstrSource(e.Source());
        _bstr_t bstrDescription(e.Description());	
		MessageBox(NULL, (LPCSTR)bstrDescription,(LPCSTR)bstrSource,MB_OK);		
	}
	return pRecordset;
}

_RecordsetPtr CLogDAO::SelectLogByDate(const COleDateTime& time)
{
	_RecordsetPtr pRecordset = NULL;
	_CommandPtr pCommand = NULL;
	try
	{		
		//创建Command对象
		TESTHR(pCommand.CreateInstance(__uuidof(Command)));
		pCommand->CommandText = "Select_Log_By_Date";
		pCommand->CommandType = adCmdStoredProc;
		pCommand->ActiveConnection = m_pConnection;
		
		//添加多个参数
		pCommand->Parameters->Refresh();
		pCommand->Parameters->Item[_variant_t((long)1)]->Value = (_variant_t)time;

		_variant_t vNull;
		vNull.vt=VT_ERROR;
		vNull.scode=DISP_E_PARAMNOTFOUND;
		pRecordset = pCommand->Execute(&vNull ,&vNull ,adCmdStoredProc);
	}
	catch(_com_error e)
	{
        _bstr_t bstrSource(e.Source());
        _bstr_t bstrDescription(e.Description());	
		MessageBox(NULL, (LPCSTR)bstrDescription,(LPCSTR)bstrSource,MB_OK);		
	}

	return pRecordset;
}

void CLogDAO::InsertLog(CString strUserID)
{
	_CommandPtr pCommand = NULL;
	try
	{		
		//创建Command对象
		TESTHR(pCommand.CreateInstance(__uuidof(Command)));
		pCommand->CommandText = "Insert_LOG";
		pCommand->CommandType = adCmdStoredProc;
		pCommand->ActiveConnection = m_pConnection;
		
		//添加多个参数
		pCommand->Parameters->Refresh();
		pCommand->Parameters->Item[_variant_t((long)1)]->Value = (_variant_t)(_bstr_t)strUserID;

		_variant_t vNull;
		vNull.vt=VT_ERROR;
		vNull.scode=DISP_E_PARAMNOTFOUND;
		pCommand->Execute(&vNull ,&vNull ,adCmdStoredProc);
	}
	catch(_com_error e)
	{
        _bstr_t bstrSource(e.Source());
        _bstr_t bstrDescription(e.Description());	
		MessageBox(NULL, (LPCSTR)bstrDescription,(LPCSTR)bstrSource,MB_OK);		
	}
}

void CLogDAO::SelectLogType(CString& strType)
{
	_CommandPtr pCommand = NULL;
	try
	{		
		//创建Command对象
		TESTHR(pCommand.CreateInstance(__uuidof(Command)));
		pCommand->CommandText = "Select_Log_Type";
		pCommand->CommandType = adCmdStoredProc;
		pCommand->ActiveConnection = m_pConnection;
		
		//添加多个参数
		pCommand->Parameters->Refresh();
		pCommand->Parameters->Item[_variant_t((long)1)]->Value = (_variant_t)(long)0;

		_variant_t vNull;
		vNull.vt=VT_ERROR;
		vNull.scode=DISP_E_PARAMNOTFOUND;
		pCommand->Execute(&vNull ,&vNull ,adCmdStoredProc);
		long i = (long)pCommand->Parameters->Item[_variant_t((long)1)]->Value;
		if(i == 0)
		{
			strType = "入";
		}
		else
		{
			strType = "出";
		}
	}
	catch(_com_error e)
	{
        _bstr_t bstrSource(e.Source());
        _bstr_t bstrDescription(e.Description());	
		MessageBox(NULL, (LPCSTR)bstrDescription,(LPCSTR)bstrSource,MB_OK);		
	}
}