achievement.cpp

这是一个企业办公管理系统。实现了文件的制作、修改、传递、、保存、销毁、存档等一系列操作。为windows系统认证模式

// Achievement.cpp: implementation of the CAchievement class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Office.h"
#include "Achievement.h"

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

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

CAchievement::CAchievement()
{

}

CAchievement::~CAchievement()
{

}

COleDateTime CAchievement::GetAchievementDate()
{
	return achievementDate;
}
CString CAchievement::GetName()
{
	return name;
}
CString CAchievement::GetId()
{
	return id;
}
CString CAchievement::GetDepartment()
{
	return department;
}
CString CAchievement::GetProject()
{
	return project;
}
CString CAchievement::GetAchievement()
{
	return achievement;
}
CString CAchievement::GetRemark()
{
	return remark;
}

void CAchievement::SetAchievementDate(COleDateTime vAchievementDate)
{
	achievementDate=vAchievementDate;
}
void CAchievement::SetName(CString vName)
{
	name=vName;
}
void CAchievement::SetId(CString vId)
{
	id=vId;
}
void CAchievement::SetDepartment(CString vDepartment)
{
	department=vDepartment;
}
void CAchievement::SetProject(CString vProject)
{
	project=vProject;
}
void CAchievement::SetAchievement(CString vAchievement)
{
	achievement=vAchievement;
}
void CAchievement::SetRemark(CString vRemark)
{
	remark=vRemark;
}

void CAchievement::sqlInsert()
{
	CString strSQL;

	strSQL="select * from achievementRecord";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	if(SUCCEEDED(hTRes))
	{
		m_pRecordset->AddNew();

		CString str;
		m_pRecordset->PutCollect("achievement",_variant_t(achievement));
		m_pRecordset->PutCollect("achievementDate",_variant_t(achievementDate));
		m_pRecordset->PutCollect("department",_variant_t(department));
		m_pRecordset->PutCollect("id",_variant_t(id));
		m_pRecordset->PutCollect("name",_variant_t(name));
		m_pRecordset->PutCollect("project",_variant_t(project));
		m_pRecordset->PutCollect("remark",_variant_t(remark));

		m_pRecordset->Update();
	}
}
void CAchievement::sqlDelete(CString vAchievement)
{
	CString strSQL;
	strSQL="delete from achievementRecord where achievement='";
	strSQL=strSQL+vAchievement+"'";
	(((COfficeApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);
}
void CAchievement::sqlUpdate(CString vAchievement)
{
	CString strSQL;

	strSQL="select * from achievementRecord where achievement='";
	strSQL=strSQL+vAchievement+"'";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	if(!(m_pRecordset->adoEOF))
	{
		CString str;
		m_pRecordset->PutCollect("achievement",_variant_t(achievement));
		m_pRecordset->PutCollect("achievementDate",_variant_t(achievementDate));
		m_pRecordset->PutCollect("department",_variant_t(department));
		m_pRecordset->PutCollect("id",_variant_t(id));
		m_pRecordset->PutCollect("name",_variant_t(name));
		m_pRecordset->PutCollect("project",_variant_t(project));
		m_pRecordset->PutCollect("remark",_variant_t(remark));
		m_pRecordset->Update();
	}
}
void CAchievement::GetData(CString vAchievement)
{
	CString strSQL;

	strSQL="select * from achievementRecord where achievement='";
	strSQL=strSQL+vAchievement+"'";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	if(SUCCEEDED(hTRes))
	{
		CString str;
		achievement= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("achievement"));
		achievementDate= m_pRecordset->GetCollect("achievementDate");
		department= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("department"));	
		id= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("id"));		
		name= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("name"));		
		project= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("project"));
		remark= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark"));
	}
}