// SumCheckDlg.cpp : implementation file
//
#include "stdafx.h"
#include "HrSys.h"
#include "SumCheckDlg.h"
#include "DepSelDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CSumCheckDlg dialog
CSumCheckDlg::CSumCheckDlg(CWnd* pParent /*=NULL*/)
: CDialog(CSumCheckDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CSumCheckDlg)
m_DepName = _T("");
//}}AFX_DATA_INIT
}
void CSumCheckDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CSumCheckDlg)
DDX_Control(pDX, IDC_YEAR_COMBO, m_year);
DDX_Control(pDX, IDC_MONTH_COMBO, m_month);
DDX_Control(pDX, IDC_ADODC1, m_adodc);
DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
DDX_Text(pDX, IDC_DEPNAME_STATIC, m_DepName);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CSumCheckDlg, CDialog)
//{{AFX_MSG_MAP(CSumCheckDlg)
ON_BN_CLICKED(IDC_SETDEP_BUTTON, OnSetdepButton)
ON_CBN_SELCHANGE(IDC_YEAR_COMBO, OnSelchangeYearCombo)
ON_CBN_SELCHANGE(IDC_MONTH_COMBO, OnSelchangeMonthCombo)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CSumCheckDlg message handlers
void CSumCheckDlg::Refresh_Data()
{
CString cSource;
CString cDepId;
cDepId.Format("%d", iDepId);
//读取月份信息
CString cYear, cMonth;
int index;
index = m_year.GetCurSel();
m_year.GetLBText(index, cYear);
index = m_month.GetCurSel();
m_month.GetLBText(index, cMonth);
cSource = "SELECT Emp_Name AS 员工姓名, SumQq AS 全勤天数, SumCc AS 出差天数,";
cSource += " SumBj AS 病假天数, SumSj AS 事假天数, SumKg AS 旷工天数,";
cSource += " SumFdxj AS 法定休假天数, SumNxj AS 年休假天数, SumDxj AS 倒休假天数,";
cSource += " SumCd AS 迟到时间, SumZt AS 早退时间, SumOt1 AS 一类加班天数,";
cSource += " SumOt2 AS 二类加班天数, SumOt3 AS 三类加班天数";
cSource += " FROM v_SumCheck WHERE CheckMonth = '";
cSource += cYear + "-" + cMonth + "' AND Dep_Id=" + cDepId;
m_adodc.SetRecordSource(cSource);
m_adodc.Refresh();
}
BOOL CSumCheckDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
CTime t = CTime::GetCurrentTime(); //读取当前系统日期
int iYear, iMonth;
iYear = t.GetYear();
iMonth = t.GetMonth();
m_year.SetCurSel(iYear - 2000);
m_month.SetCurSel(iMonth - 1);
Refresh_Data();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CSumCheckDlg::OnSetdepButton()
{
// TODO: Add your control notification handler code here
CDepSelDlg dlg;
//打开选择部门对话框
dlg.DoModal();
//从对话框中读取选择部门的信息
iDepId = dlg.DepId;
m_DepName = dlg.DepName;
UpdateData(FALSE);
//根据选择的部门信息,刷新表格数据
Refresh_Data();
}
void CSumCheckDlg::OnSelchangeYearCombo()
{
// TODO: Add your control notification handler code here
Refresh_Data();
}
void CSumCheckDlg::OnSelchangeMonthCombo()
{
// TODO: Add your control notification handler code here
Refresh_Data();
}