syslog.cpp

本网站是一个库存管理系统

// SysLog.cpp: implementation of the SysLog class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Stock.h"
#include "SysLog.h"
#include "ADOConn.h"

extern CUsers curUser;

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

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

CSysLog::CSysLog()
{
	LogId = 0;
	LogDate = "";
	LogTime = "";
	LogType = 0;
	Title = "";
	Body = "";
	UserName = "";
}

CSysLog::~CSysLog()
{

}

//读取和设置成员变量
long CSysLog::GetLogId()
{
	return LogId;
}

void CSysLog::SetLogId(long lLogId)
{
	LogId = lLogId;
}

CString CSysLog::GetLogDate()
{
	return LogDate;
}

void CSysLog::SetLogDate(CString cLogDate)
{
	LogDate = cLogDate;
}

CString CSysLog::GetLogTime()
{
	return LogTime;
}

void CSysLog::SetLogTime(CString cLogTime)
{
	LogTime = cLogTime;
}

int CSysLog::GetLogType()
{
	return LogType;
}

void CSysLog::SetLogType(int iLogType)
{
	LogType = iLogType;
}

CString CSysLog::GetTitle()
{
	return Title;
}

void CSysLog::SetTitle(CString cTitle)
{
	Title = cTitle;
}

CString CSysLog::GetBody()
{
	return Body;
}

void CSysLog::SetBody(CString cBody)
{
	Body = cBody;
}

CString CSysLog::GetUserName()
{
	return UserName;
}

void CSysLog::SetUserName(CString cUserName)
{
	UserName = cUserName;
}

//数据库操作
void CSysLog::sql_insert()
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString strType;
	strType.Format("%d", LogType);
	CTime t = CTime::GetCurrentTime();
	LogDate = t.Format("%Y-%m-%d");		//自动生成当前日期
	LogTime = t.Format("%H:%M");		//自动生成当前时间
	UserName = curUser.GetUserName();	//自动保存当前用户

	//设置INSERT语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO SysLog (LogDate, LogTime, LogType, Title, Body, UserName) VALUES('" 
		+ LogDate + "','" + LogTime + "'," + strType + ",'" + Title + "','" + Body + "','" 
		+ UserName + "')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CSysLog::sql_deleteById(CString cId)			//按日志编号删除记录
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM SysLog WHERE LogId=" + cId;
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CSysLog::sql_deleteByDate(CString cDate)		//按日期删除记录
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM SysLog WHERE LogDate='" + cDate + "'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CSysLog::sql_deleteAll()						//删除所有记录
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM SysLog WHERE LogId>0";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}