feedback.cpp

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

// Feedback.cpp: implementation of the CFeedback class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Office.h"
#include "Feedback.h"

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

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

CFeedback::CFeedback()
{

}

CFeedback::~CFeedback()
{

}
COleDateTime CFeedback::GetFeedbackDate()
{
	return feedbackDate;
}
CString CFeedback::GetReceiver()
{
	return receiver;
}
CString CFeedback::GetSendor()
{
	return sendor;
}
CString CFeedback::GetFeedbackType()
{
	return feedbackType;
}
CString CFeedback::GetIndication()
{
	return indication;
}
CString CFeedback::GetIdea()
{
	return idea;
}
CString CFeedback::GetManagement()
{
	return management;
}
CString CFeedback::GetSubject()
{
	return subject;
}
CString CFeedback::GetContent()
{
	return content;
}
CString CFeedback::GetRemark()
{
	return remark;
}

void CFeedback::SetFeedbackDate(COleDateTime vFeedbackDate)
{
	feedbackDate=vFeedbackDate;
}
void CFeedback::SetReceiver(CString vReceiver)
{
	receiver=vReceiver;
}
void CFeedback::SetSendor(CString vSendor)
{
	sendor=vSendor;
}
void CFeedback::SetFeedbackType(CString vFeedbackType)
{
	feedbackType=vFeedbackType;
}
void CFeedback::SetIndication(CString vIndication)
{
	indication=vIndication;
}
void CFeedback::SetIdea(CString vIdea)
{
	idea=vIdea;
}
void CFeedback::SetManagement(CString vManagement)
{
	management=vManagement;
}
void CFeedback::SetSubject(CString vSubject)
{
	subject=vSubject;
}
void CFeedback::SetContent(CString vContent)
{
	content=vContent;
}
void CFeedback::SetRemark(CString vRemark)
{
	remark=vRemark;
}

void CFeedback::sqlInsert()
{
	CString strSQL;

	strSQL="select * from feedbackRecord";
	_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("feedbackDate",_variant_t(feedbackDate));
		m_pRecordset->PutCollect("feedbackType",_variant_t(feedbackType));
		m_pRecordset->PutCollect("idea",_variant_t(idea));
		m_pRecordset->PutCollect("indication",_variant_t(indication));
		m_pRecordset->PutCollect("management",_variant_t(management));
		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 CFeedback::sqlDelete(CString vSubject)
{
	CString strSQL;
	strSQL="delete from feedbackRecord where subject='";
	strSQL=strSQL+vSubject+"'";
	(((COfficeApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);
}
void CFeedback::sqlUpdate(CString vSubject)
{
	CString strSQL;

	strSQL="select * from feedbackRecord 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("content",_variant_t(content));
		m_pRecordset->PutCollect("feedbackDate",_variant_t(feedbackDate));
		m_pRecordset->PutCollect("feedbackType",_variant_t(feedbackType));
		m_pRecordset->PutCollect("idea",_variant_t(idea));
		m_pRecordset->PutCollect("indication",_variant_t(indication));
		m_pRecordset->PutCollect("management",_variant_t(management));
		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 CFeedback::GetData(CString vSubject)
{
	CString strSQL;

	strSQL="select * from feedbackRecord 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;
		content= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("content"));
		feedbackType= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("feedbackType"));
		feedbackDate= m_pRecordset->GetCollect("feedbackDate");
		idea= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("idea"));	
		indication= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("indication"));		
		management= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("management"));		
		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"));
	}
}