logmngr.cpp

偶作的毕业设计程序

// LogMngr.cpp: implementation of the CLogMngr class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "softdocsystem.h"
#include "LogMngr.h"

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

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

CLogMngr::CLogMngr()
{

}

CLogMngr::~CLogMngr()
{

}

bool CLogMngr::Setup(_ConnectionPtr cnnt)
{
/*if(m_LogCon->GetState()==adStateOpen)return true;
else 
return false;*/
	try{
		m_LogCon=cnnt;}
	catch(_com_error& e){
	AfxMessageBox(e.ErrorMessage());
	return false;}
	return true;	
}
/*bool CLogMngr::SetupPub(_ConnectionPtr cnnt)
{
	try{
	m_LogPub=cnnt;}
	catch(_com_error& e){
	AfxMessageBox(e.ErrorMessage());
	return false;}
	return true;
}
*/
void CLogMngr::Addlog(CString Operater,CString OptType,CString OptContent)
{
	CTime tm=CTime::GetCurrentTime();
	CString LogNumber,LogDate;
	CString sql_;
	LogDate.Format ("%d-%d-%d %d:%d",tm.GetYear(),tm.GetMonth (),tm.GetDay(),tm.GetHour(),tm.GetMinute());//时间
	LogNumber.Format("LG%d%02d%02d%02d%02d%02d",tm.GetYear (),tm.GetMonth (),tm.GetDay(),tm.GetHour(),tm.GetMinute(),tm.GetSecond());//编号
	sql_.Format("insert into DateLog(日志编号,操作者,操作类型,操作内容,操作时间) values('%s','%s','%s','%s','%s')",LogNumber,Operater,OptType,OptContent,LogDate);
_bstr_t sql=sql_;
try{
	if(m_LogCon->GetState ()==adStateOpen)
	m_LogCon->Execute(sql,NULL,adCmdText);}
catch(_com_error& e){
	AfxMessageBox(e.ErrorMessage());}
//if(m_LogCon->GetState()==adStateOpen)m_LogCon->Close();//如果数据连接开，则断开连接
}
/*
void CLogMngr::AddLogUnShut(CString Operater,CString OptType,CString OptContent)
{
	CTime tm=CTime::GetCurrentTime();
	CString LogNumber,LogDate;
	CString sql_;
	LogDate.Format ("%d-%d-%d-%d-%d",tm.GetYear(),tm.GetMonth (),tm.GetDay(),tm.GetHour(),tm.GetMinute());//时间
	LogNumber.Format("LG%d%02d%02d%02d%02d%02d",tm.GetYear (),tm.GetMonth (),tm.GetDay(),tm.GetHour(),tm.GetMinute(),tm.GetSecond());//编号
	sql_.Format("insert into DateLog(日志编号,操作者,操作类型,操作内容,操作时间) values('%s','%s','%s','%s','%s')",LogNumber,Operater,OptType,OptContent,LogDate);
_bstr_t sql=sql_;
try{
	m_LogPub->Execute(sql,NULL,adCmdText);}
catch(_com_error& e){
	AfxMessageBox(e.ErrorMessage());}
}
*/


bool CLogMngr::InlitSetup(_ConnectionPtr cnnt)
{
	try{
		m_LogCon=cnnt;}
	catch(_com_error& e){
	AfxMessageBox(e.ErrorMessage());
	return false;}
	return true;
}