kaoqintongji.cpp

来自「这是采用mfc编写的工资管理系统」· C++ 代码 · 共 75 行

// Kaoqintongji.cpp : implementation file
//

#include "stdafx.h"
#include "salarymanagement.h"
#include "Kaoqintongji.h"

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

/////////////////////////////////////////////////////////////////////////////
// CKaoqintongji dialog


CKaoqintongji::CKaoqintongji(CWnd* pParent /*=NULL*/)
	: CDialog(CKaoqintongji::IDD, pParent)
{
	//{{AFX_DATA_INIT(CKaoqintongji)
	//}}AFX_DATA_INIT

	m_ado.OnInitADOConn();
}

CKaoqintongji::~CKaoqintongji()
{
	m_ado.ExitConnect();
}

void CKaoqintongji::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKaoqintongji)
	DDX_Control(pDX, IDC_DATETIMEPICKER, m_date);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKaoqintongji, CDialog)
	//{{AFX_MSG_MAP(CKaoqintongji)
	ON_BN_CLICKED(IDC_BUTTON2, OnStat)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKaoqintongji message handlers

BOOL CKaoqintongji::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	m_date.SetFormat("yyy年MM月");	

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CKaoqintongji::OnStat() 
{
	UpdateData();

	COleDateTime timeDest;
	m_date.GetTime(timeDest);

	CString sql;
	sql.Format("Select * From KaoQin Where 记录月份='%s'",timeDest.Format("%Y-%m"));

//	_RecordsetPtr pRecordset=m_ado.GetRecordSet(sql);
	CKaoqinDlg::s_SQL=sql;
	CKaoqinDlg::s_bRefresh=TRUE;
}