systemparam.cpp

一个电视台专用的信息管理软件源代码

// SystemParam.cpp: implementation of the CSystemParam class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "SystemParam.h"

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

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

CSystemParam::CSystemParam()
{

}

CSystemParam::~CSystemParam()
{

}


CString CSystemParam::GetLogName()
{
	return LogName;
}
CString CSystemParam::GetPassword()
{
	return Password;
}
int CSystemParam::GetRemoveTimeLimit()
{
	return RemoveTimeLimit;
}
int CSystemParam::GetDiskLimit()
{
	return DiskLimit;
}


void CSystemParam::SetLogName(CString cLogName)
{
	LogName=cLogName;
}
void CSystemParam::SetPassword(CString cPassword)
{
	Password=cPassword;
}
void CSystemParam::SetRemoveTimeLimit(int iRemoveTimeLimit)
{
	RemoveTimeLimit=iRemoveTimeLimit;
}
void CSystemParam::SetDiskLimit(int iDiskLimit)
{
	DiskLimit=iDiskLimit;
}
//判断指定管理员名是否存在

int CSystemParam::HaveLoginName(CString cLoginName)
{	
	
	//设置SELECT语句

	vSQL = "SELECT * FROM CSystemParam WHERE LoginName='" + cLoginName + "'";
	
	//执行SELECT语句
	m_pRecordset = GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;

}
void CSystemParam::sql_insert(CString cLogName,CString cPassword,int iRemoveTimeLimit,int iDiskLimit)
{
	//设置INSERT语句
	CString strdLimit,strtLimit;
	strdLimit.Format("%d", iDiskLimit);
	strtLimit.Format("%d", iRemoveTimeLimit);
	vSQL = "INSERT INTO SystemParam VALUES('" + cLogName + "','" +cPassword + "'," + strtLimit + "," + strdLimit + " )";
	//执行INSERT语句
	ExecuteSQL(vSQL);	
	
}
void CSystemParam::sql_update(int iRemoveTimeLimit,int iDiskLimit)
{
	//设置UPDATE语句
	CString strdLimit,strtLimit;
	strdLimit.Format("%d", iDiskLimit);
	strtLimit.Format("%d", iRemoveTimeLimit);
	vSQL = "UPDATE SystemParam SET RemoveTimeLimit = "  + strtLimit + ", DiskLimit =" + strdLimit;
	//执行INSERT语句
	ExecuteSQL(vSQL);	
	
}

void CSystemParam::GetData()
{
		vSQL = "SELECT * FROM SystemParam ";
	//执行SELETE语句
	m_pRecordset = GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CSystemParam();
	else
	{
		LogName = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("LogName");
		Password = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Password");
		RemoveTimeLimit = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("RemoveTimeLimit"));
		DiskLimit = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DiskLimit"));
	}

}