timeseldlg.cpp

visual c++与sql Server数据库开发考勤管理系统

// TimeSelDlg.cpp : implementation file
//

#include "stdafx.h"
#include "CheckManage.h"
#include "TimeSelDlg.h"
#include "CheckInfo.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "_Recordset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTimeSelDlg dialog


CTimeSelDlg::CTimeSelDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTimeSelDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTimeSelDlg)
	m_time = 0;
	//}}AFX_DATA_INIT
}


void CTimeSelDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTimeSelDlg)
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_Datagrid);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_time);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTimeSelDlg, CDialog)
	//{{AFX_MSG_MAP(CTimeSelDlg)
	ON_BN_CLICKED(IDC_RESERCH_BUTTON, OnReserchButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTimeSelDlg message handlers

BOOL CTimeSelDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_time = CTime::GetCurrentTime();
	UpdateData(FALSE);
	RefreshData();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CTimeSelDlg::RefreshData()
{
	UpdateData(TRUE);

	//根据部门编号设置SELECT语句
	CString cTime;
	cTime = m_time.Format("%Y-%m-%d");
	
	// 设置SELECT语句
	CString cSource = "SELECT c.EmpId AS 员工编号, e.Name AS 姓名, c.CheckDate AS 出勤日期,"
		" c.QuanQin AS 是否全勤, c.ChuChai AS 是否出差, c.ShiJia AS 是否事假,"
		" c.BingJia AS 是否病假, c.KuangGong AS 是否旷工, c.XiuXi AS 是否休息,"
		" c.ChiDao AS 是否迟到, c.ZaoTui AS 是否早退, c.Memo AS 备注"
		" FROM CheckInfo c, EmpInfo e WHERE c.EmpId = e.EmpId AND c.CheckDate = '" + cTime + "'";

	//刷新ADO Data控件的记录源
	m_Adodc.SetRecordSource(cSource);
	m_Adodc.Refresh();

	//设置列宽度
	_variant_t vIndex;
	vIndex = long(0);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(1);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(2);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(3);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(4);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(5);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(6);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(7);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(8);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(9);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(10);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(11);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(100);
}

// 查询按钮
void CTimeSelDlg::OnReserchButton() 
{
	// TODO: Add your control notification handler code here
	RefreshData();
}