previewdlg.cpp

工资管理系统是提供给财会人员使用的一个对单位职工工资进行管理的系统.它能自动对在职人员和离退人员的工资,个人所得税金和公积金进行管理,并生成多种相关的

// PreviewDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Salary.h"
#include "PreviewDlg.h"

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

extern _ConnectionPtr pTheConn; // Connection对象
/////////////////////////////////////////////////////////////////////////////
// CPreviewDlg dialog


CPreviewDlg::CPreviewDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CPreviewDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPreviewDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CPreviewDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPreviewDlg)
	DDX_Control(pDX, IDC_DATAGRID_SALARY, m_cDG);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPreviewDlg, CDialog)
	//{{AFX_MSG_MAP(CPreviewDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPreviewDlg message handlers

BOOL CPreviewDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	_RecordsetPtr m_pRS; // Recordset对象
	m_pRS.CreateInstance(__uuidof(Recordset)); // 创建实例
	CString strSQL;
	// 写SQL语句
	strSQL="select PERSONInfo.ID,PERSONInfo.NAME,SALARY.BASIC,\
		SALARY.BONUS,SALARY.ADDDETAIL,SALARY.ADDTOTAL,\
		SALARY.SUBDETAIL,SALARY.SUBTOTAL,SALARY.TOTAL\
		from SALARY,PERSONInfo where SALARY.PERSONID=PERSONInfo.ID\
		and SALARY.YEARMONTH='" + m_strYearMonth + "' order by PERSONInfo.ID";
   MessageBox(m_strYearMonth);
	// 打开Recordset对象
	try{
		m_pRS->Open(strSQL.AllocSysString(),
			pTheConn.GetInterfacePtr(),
			adOpenKeyset,adLockReadOnly,adCmdText);
	}
	catch(_com_error *e)
	{
		CString Error = e->ErrorMessage();
		AfxMessageBox(e->ErrorMessage());
	}
	catch(...)
	{
		AfxMessageBox("打开数据集对象出错!");
	}
	m_cDG.SetRefDataSource((LPUNKNOWN)m_pRS);
	m_pRS.Release(); // 释放
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}