letter.cpp

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

// Letter.cpp: implementation of the CLetter class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Office.h"
#include "Letter.h"

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

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

CLetter::CLetter()
{

}

CLetter::~CLetter()
{

}


COleDateTime CLetter::GetLetterDate()
{
	return letterDate;
}
CString CLetter::GetLetterType()
{
	return letterType;
}
CString CLetter::GetLetterCharacter()
{
	return letterCharacter;
}
CString CLetter::GetSendor()
{
	return sendor;
}
CString CLetter::GetReceiver()
{
	return receiver;
}
CString CLetter::GetSubject()
{
	return subject;
}
CString CLetter::GetContent()
{
	return content;
}
CString CLetter::GetRemark()
{
	return remark;
}

void CLetter::SetLetterDate(COleDateTime vLetterDate)
{
	letterDate=vLetterDate;
}
void CLetter::SetLetterType(CString vLetterType)
{
	letterType=vLetterType;
}
void CLetter::SetLetterCharacter(CString vLetterCharacter)
{
	letterCharacter=vLetterCharacter;
}
void CLetter::SetSendor(CString vSendor)
{
	sendor=vSendor;
}
void CLetter::SetReceiver(CString vReceiver)
{
	receiver=vReceiver;
}
void CLetter::SetSubject(CString vSubject)
{
	subject=vSubject;
}
void CLetter::SetContent(CString vContent)
{
	content=vContent;
}
void CLetter::SetRemark(CString vRemark)
{
	remark=vRemark;
}
	
void CLetter::sqlInsert()
{
	CString strSQL;

	strSQL="select * from letterRecord";//sql语句
	_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("content",_variant_t(content));//内容
		m_pRecordset->PutCollect("letterCharacter",_variant_t(letterCharacter));//信函性质
		m_pRecordset->PutCollect("letterDate",_variant_t(letterDate));//信函日期
		m_pRecordset->PutCollect("letterType",_variant_t(letterType));//信函类型
		m_pRecordset->PutCollect("receiver",_variant_t(receiver));//接收人
		m_pRecordset->PutCollect("remark",_variant_t(remark));//备注
		m_pRecordset->PutCollect("sendor",_variant_t(sendor));//发件人
		m_pRecordset->PutCollect("subject",_variant_t(subject));//主题

		m_pRecordset->Update();//更新到数据库
	}
}
void CLetter::sqlDelete(CString vSubject)
{
	CString strSQL;
	strSQL="delete from letterRecord where subject='";
	strSQL=strSQL+vSubject+"'";//构造删除指定主题的信函的sql语句
	(((COfficeApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);//执行删除
}
void CLetter::sqlUpdate(CString vSubject)
{
	CString strSQL;

	strSQL="select * from letterRecord where subject='";
	strSQL=strSQL+vSubject+"'";//构造查询指定主题的信函的sql语句
	_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("content",_variant_t(content));//内容
		m_pRecordset->PutCollect("letterCharacter",_variant_t(letterCharacter));//信函性质
		m_pRecordset->PutCollect("letterDate",_variant_t(letterDate));//信函日期
		m_pRecordset->PutCollect("letterType",_variant_t(letterType));//信函类型
		m_pRecordset->PutCollect("receiver",_variant_t(receiver));//接收人
		m_pRecordset->PutCollect("remark",_variant_t(remark));//备注
		m_pRecordset->PutCollect("sendor",_variant_t(sendor));//发件人
		m_pRecordset->PutCollect("subject",_variant_t(subject));//主题
		
		m_pRecordset->Update();//将修改更新到数据库
	}
}
void CLetter::GetData(CString vSubject)
{
	CString strSQL;

	strSQL="select * from letterRecord where subject='";
	strSQL=strSQL+vSubject+"'";//构造查询指定主题的信函的sql语句
	_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;
		content= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("content"));//内容
		letterCharacter= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("letterCharacter"));//信函性质
		letterDate= m_pRecordset->GetCollect("letterDate");//信函日期
		letterType= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("letterType"));//信函类型	
		receiver= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("receiver"));//接收人
		remark= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark"));//备注
		sendor= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("sendor"));//发件人
		subject= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("subject"));//主题
	}
}