meeting.cpp

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

// Meeting.cpp: implementation of the CMeeting class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Office.h"
#include "Meeting.h"

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

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

CMeeting::CMeeting()
{

}

CMeeting::~CMeeting()
{

}

CString CMeeting::GetName()
{
	return name;
}

COleDateTime CMeeting::GetMeetingDate()
{
	return meetingDate;
}

CString CMeeting::GetLocation()
{
	return location;
}

COleDateTime CMeeting::GetBeginTime()
{
	return beginTime;
}

COleDateTime CMeeting::GetEndTime()
{
	return endTime;
}

CString CMeeting::GetPresident()
{
	return president;
}

int CMeeting::GetNum()
{
	return num;
}

CString CMeeting::GetSubject()
{
	return subject;
}

CString CMeeting::GetContent()
{
	return content;
}

CString CMeeting::GetRemark()
{
	return remark;
}
	
void CMeeting::SetName(CString vName)
{
	name=vName;
}

void CMeeting::SetMeetingDate(COleDateTime vMeetingDate)
{
	meetingDate=vMeetingDate;
}

void CMeeting::SetLocation(CString vLocation)
{
	location=vLocation;
}

void CMeeting::SetBeginTime(COleDateTime vBeginTime)
{
	beginTime=vBeginTime;
}
void CMeeting::SetEndTime(COleDateTime vEndTime)
{
	endTime=vEndTime;
}

void CMeeting::SetPresident(CString vPresident)
{
	president=vPresident;
}
void CMeeting::SetNum(int vNum)
{
	num=vNum;
}

void CMeeting::SetSubject(CString vSubject)
{
	subject=vSubject;
}

void CMeeting::SetContent(CString vContent)
{
	content=vContent;
}

void CMeeting::SetRemark(CString vRemark)
{
	remark=vRemark;
}

void CMeeting::sqlInsert()
{
	CString strSQL;

	strSQL="select * from meetingRecord";
	_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("name",_variant_t(name));
		m_pRecordset->PutCollect("meetingDate",_variant_t(meetingDate));
		m_pRecordset->PutCollect("location",_variant_t(location));
		m_pRecordset->PutCollect("beginTime",_variant_t(beginTime));
		m_pRecordset->PutCollect("endTime",_variant_t(endTime));
		m_pRecordset->PutCollect("president",_variant_t(president));
		str.Format("%d",num);
		m_pRecordset->PutCollect("num",_variant_t(str));
		m_pRecordset->PutCollect("subject",_variant_t(subject));
		m_pRecordset->PutCollect("content",_variant_t(content));
		m_pRecordset->PutCollect("remark",_variant_t(remark));

		m_pRecordset->Update();
	}
}

void CMeeting::sqlDelete(CString vSubject)
{
	CString strSQL;
	strSQL="delete from meetingRecord where subject='";
	strSQL=strSQL+vSubject+"'";
	(((COfficeApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);
}

void CMeeting::sqlUpdate(CString vSubject)
{
	CString strSQL;

	strSQL="select * from meetingRecord where subject='";
	strSQL=strSQL+vSubject+"'";
	_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("name",_variant_t(name));
		m_pRecordset->PutCollect("meetingDate",_variant_t(meetingDate));
		m_pRecordset->PutCollect("location",_variant_t(location));
		m_pRecordset->PutCollect("beginTime",_variant_t(beginTime));
		m_pRecordset->PutCollect("endTime",_variant_t(endTime));
		m_pRecordset->PutCollect("president",_variant_t(president));
		str.Format("%d",num);
		m_pRecordset->PutCollect("num",_variant_t(str));
	//	m_pRecordset->PutCollect("subject",_variant_t(subject));
		m_pRecordset->PutCollect("content",_variant_t(content));
		m_pRecordset->PutCollect("remark",_variant_t(remark));
		m_pRecordset->Update();
	}
}

void CMeeting::GetData(CString vSubject)
{
	CString strSQL;

	strSQL="select * from meetingRecord where subject='";
	strSQL=strSQL+vSubject+"'";
	_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;
		name= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("name"));
		location= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("location"));
		beginTime= m_pRecordset->GetCollect("beginTime");
		endTime= m_pRecordset->GetCollect("endTime");
		meetingDate= m_pRecordset->GetCollect("meetingDate");
		
		content= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("content"));	
		president= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("president"));		
		subject= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("subject"));		
		remark= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark"));
		num= m_pRecordset->GetCollect("num").intVal;
	//	AfxMessageBox("1");
	}
}