callboard.cpp

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

// Callboard.cpp : implementation file
//

#include "stdafx.h"
#include "Office.h"
#include "Callboard.h"
#include "CallboardClass.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCallboard dialog


CCallboard::CCallboard(CWnd* pParent /*=NULL*/)
	: CDialog(CCallboard::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCallboard)
	m_staff = _T("");
	m_content = _T("");
	//}}AFX_DATA_INIT
}


void CCallboard::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCallboard)
	DDX_Control(pDX, IDC_STAFF, m_staffCombo);
	DDX_Control(pDX, IDC_LIST, m_list);
	DDX_CBString(pDX, IDC_STAFF, m_staff);
	DDX_Text(pDX, IDC_CONTENT, m_content);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCallboard, CDialog)
	//{{AFX_MSG_MAP(CCallboard)
	ON_BN_CLICKED(IDC_PUBLISH, OnPublish)
	ON_BN_CLICKED(IDC_EXIT, OnExit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCallboard message handlers

void CCallboard::OnPublish() 
{
	UpdateData(true);

	m_publishDate=COleDateTime::GetCurrentTime(); //获取当前系统时间

	CCallboardClass callBoard; //公告栏表访问类
	callBoard.SetContent(m_content); //设定内容
	callBoard.SetStaff(m_staff); //设定发布人
	callBoard.SetPublishDate(m_publishDate); //设定发布日期

	callBoard.sqlInsert(); //将记录插入数据库
	Refresh(); //刷新公告栏列表
}

void CCallboard::OnExit() 
{
	this->OnCancel();
}

void CCallboard::Refresh()
{
	_RecordsetPtr m_pRecordset;

	m_list.DeleteAllItems();
	CString strSQL;
	strSQL="select * from callBoardRecord";
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
		
		while(!(m_pRecordset->adoEOF))
		{
			m_list.InsertItem(i,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("publishDate")));
			m_list.SetItemText(i,1,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staff")));
			m_list.SetItemText(i,2,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("content")));
			
			i++;
			if(!(m_pRecordset->adoEOF))
				m_pRecordset->MoveNext();
		}
	}
}

BOOL CCallboard::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	DWORD style;
	style=m_list.GetExStyle();
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
	m_list.SetExtendedStyle(style);
	
	m_list.InsertColumn(0,"发布时间",LVCFMT_LEFT,100);
	m_list.InsertColumn(1,"发布人员",LVCFMT_LEFT,100);
	m_list.InsertColumn(2,"内容",LVCFMT_LEFT,100);

	_RecordsetPtr m_pRecordset;

	CString strSQL;
//	_RecordsetPtr m_pRecordset;  //记录集
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));//创建实例	

	strSQL="select distinct staffName from staff";	//查询语句
				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);  //查询，打开记录集
	int i=0;
	while(!(m_pRecordset->adoEOF))
	{
		
		m_staffCombo.InsertString(i,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffName")));
		m_pRecordset->MoveNext();
		i++;
	}
	m_pRecordset->Close();

//	CString strSQL;
	strSQL="select * from callBoardRecord";
//	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
		
		while(!(m_pRecordset->adoEOF))
		{
			m_list.InsertItem(i,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("publishDate")));
			m_list.SetItemText(i,1,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staff")));
			m_list.SetItemText(i,2,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("content")));
			
			i++;
			if(!(m_pRecordset->adoEOF))
				m_pRecordset->MoveNext();
		}
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}