onduty.cpp

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

// Onduty.cpp: implementation of the COnduty class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Office.h"
#include "Onduty.h"

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

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

COnduty::COnduty()
{

}

COnduty::~COnduty()
{

}

COleDateTime COnduty::GetBeginDate()
{
	return beginDate;
}

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

COleDateTime COnduty::GetEndDate()
{
	return endDate;
}

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

CString	COnduty::GetWatcher()
{
	return watcher;
}

CString COnduty::GetDuty()
{
	return duty;
}

CString COnduty::GetEvents()
{
	return events;
}

CString COnduty::GetRemark()
{
	return remark;
}

void COnduty::SetBeginDate(COleDateTime vBeginDate)
{
	beginDate=vBeginDate;
}

void COnduty::SetBeginTime(COleDateTime vBeginTime)
{
	beginTime=vBeginTime;
}

void COnduty::SetEndDate(COleDateTime vEndDate)
{
	endDate=vEndDate;
}

void COnduty::SetEndTime(COleDateTime vEndTime)
{
	endTime=vEndTime;
}

void COnduty::SetWatcher(CString	vWatcher)
{
	watcher=vWatcher;
}

void COnduty::SetDuty(CString vDuty)
{
	duty=vDuty;
}

void COnduty::SetEvents(CString vEvents)
{
	events=vEvents;
}

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

void COnduty::sqlInsert()
{
	CString strSQL;

	strSQL="select * from ondutyRecord";
	_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("beginDate",_variant_t(beginDate));
		m_pRecordset->PutCollect("beginTime",_variant_t(beginTime));
		m_pRecordset->PutCollect("endDate",_variant_t(endDate));
		m_pRecordset->PutCollect("endTime",_variant_t(endTime));
		m_pRecordset->PutCollect("events",_variant_t(events));
		m_pRecordset->PutCollect("watcher",_variant_t(watcher));
		m_pRecordset->PutCollect("duty",_variant_t(duty));
		m_pRecordset->PutCollect("remark",_variant_t(remark));
	
		m_pRecordset->Update();
	}
	
}

void COnduty::sqlUpdate(COleDateTime vBeginDate)
{
	CString strSQL;

	strSQL="select * from ondutyRecord where beginDate='";
	CString str;
	str.Format("%d-%d-%d %d:%d:%d",vBeginDate.GetYear(),vBeginDate.GetMonth(),vBeginDate.GetDay(),vBeginDate.GetHour(),vBeginDate.GetMinute(),vBeginDate.GetSecond());
	strSQL=strSQL+str+"'";
	
	_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("beginDate",_variant_t(beginDate));
		m_pRecordset->PutCollect("beginTime",_variant_t(beginTime));
		m_pRecordset->PutCollect("endDate",_variant_t(endDate));
		m_pRecordset->PutCollect("endTime",_variant_t(endTime));
		m_pRecordset->PutCollect("events",_variant_t(events));
		m_pRecordset->PutCollect("watcher",_variant_t(watcher));
		m_pRecordset->PutCollect("duty",_variant_t(duty));
		m_pRecordset->PutCollect("remark",_variant_t(remark));

		m_pRecordset->Update();
	}
}

void COnduty::sqlDelete(COleDateTime vBeginDate)
{
	CString strSQL;
	strSQL="delete from ondutyRecord where beginDate='";
	CString str;
	str.Format("%d-%d-%d %d:%d:%d",vBeginDate.GetYear(),vBeginDate.GetMonth(),vBeginDate.GetDay(),vBeginDate.GetHour(),vBeginDate.GetMinute(),vBeginDate.GetSecond());
	strSQL=strSQL+str+"'";
	

	(((COfficeApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);
}

void COnduty::GetData(COleDateTime vBeginDate)
{
	CString strSQL;

	strSQL="select * from ondutyRecord where beginDate='";
	CString str;
	str.Format("%d-%d-%d",vBeginDate.GetYear(),vBeginDate.GetMonth(),vBeginDate.GetDay());
	strSQL=strSQL+str+"'";
	_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;
		events= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("events"));
		watcher= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("watcher"));
		duty= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("duty"));
		beginDate= m_pRecordset->GetCollect("beginDate");
		beginDate= m_pRecordset->GetCollect("beginDate");
		beginTime= m_pRecordset->GetCollect("beginTime");
		endDate= m_pRecordset->GetCollect("endDate");
		endTime= m_pRecordset->GetCollect("endTime");		
		remark= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark"));
	}
}