【VC开源代码栏目提醒】:网学会员,鉴于大家对VC开源代码十分关注,论文会员在此为大家搜集整理了“AbsenceDlg.cpp”一文,供大家参考学习!
// AbsenceDlg.cpp : implementation file
//
#include "stdafx.h"
#include "CheckManage.h"
#include "AbsenceDlg.h"
#include "HolidaySet.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
/////////////////////////////////////////////////////////////////////////////
// CAbsenceDlg dialog
CAbsenceDlg::CAbsenceDlg(CWnd* pParent /*=NULL*/)
: CDialog(CAbsenceDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CAbsenceDlg)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
}
void CAbsenceDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CAbsenceDlg)
DDX_Control(pDX, IDC_ADODC1, m_Adodc);
DDX_Control(pDX, IDC_DATAGRID1, m_Datagrid);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CAbsenceDlg, CDialog)
//{{AFX_MSG_MAP(CAbsenceDlg)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CAbsenceDlg message handlers
BOOL CAbsenceDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
CurrentTime = CTime::GetCurrentTime();
CHolidaySet holiday;
if(holiday.HaveHoliday(CurrentTime.Format("%Y-%m-%d")))
{
MessageBox("今天是节假日,无缺勤人员");
}
else
{
RefreshData();
}
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
// 刷新数据
void CAbsenceDlg::RefreshData()
{
UpdateData(TRUE);
//根据部门编号设置SELECT语句
CString cTime;
cTime = CurrentTime.Format("%Y-%m-%d");
// 设置SELECT语句
CString cSource = "SELECT e.EmpId AS 员工编号, e.Name AS , d.DepName AS 部门名称,"
" e.Mobile AS 联系电话 FROM DepInfo d, EmpInfo e"
" WHERE e.DepId = d.DepId AND e.EmpId IN"
" (SELECT EmpId FROM CheckInfo WHERE (ShiJia='是' OR BingJia='是' OR KuangGong='是')"
" AND CheckDate = '" + cTime + "')";
//刷新ADO Data控件的记录源
m_Adodc.SetRecordSource(cSource);
m_Adodc.Refresh();
//设置列宽度
_variant_t vIndex;
vIndex = long(0);
m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(00);
vIndex = long(1);
m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(130);
vIndex = long(2);
m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(130);
vIndex = long(3);
m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(140);
}
上一篇:
AboutPage.cpp
下一篇:
首鼠两端