// 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 全勤天數(shù), SumCc AS 出差天數(shù),";
	cSource += " SumBj AS 病假天數(shù), SumSj AS 事假天數(shù), SumKg AS 曠工天數(shù),";
	cSource += " SumFdxj AS 法定休假天數(shù), SumNxj AS 年休假天數(shù), SumDxj AS 倒休假天數(shù),";
	cSource += " SumCd AS 遲到時間, SumZt AS 早退時間, SumOt1 AS 一類加班天數(shù),";
	cSource += " SumOt2 AS 二類加班天數(shù), SumOt3 AS 三類加班天數(shù)";
	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();  //讀取當前系統(tǒng)日期
	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);
	//根據(jù)選擇的部門信息，刷新表格數(shù)據(jù)
	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();	
}